Skunks, A Pan African Technology solutions firm is looking for a DBA. If you fit the bill kindly contact me offlist. Job Description: * Title: PostgreSQL DBA *Location: Nairobi with responsibility across 7 African Countries* Minimum 5 years of progressive experience performing PostgreSQL administration production environment; experience should include three or more years of database administration in an enterprise level environment with very large (> 1 terabyte) databases *Responsibilities:* · Collaborate with others to determine and deploy database solutions to business prioritized requirements, including business continuance and information security along with functional requirements. · Install, configure, and test new PostgreSQL databases, perform version upgrades of existing databases · Install, upgrade and maintain all PostgreSQL-related server and administration software · Perform DB profiling and optimization; analyze and propose schema changes to PostgreSQL databases as needed · Proactively monitor activity, utilization, exceptions and database health;propose and deploy appropriate improvements; automate repetitive tasks · Collaborate with team members to create, publish and maintain database deployment methods and procedures for PostgreSQL databases · Collaborate with the Infrastructure Architect to create and maintain database technology roadmaps and deployment plans · Perform database backup and recovery duties; establish standards and schedules for database backups; develop and routinely test recovery procedures for each database; ensure that backup schedules meet the recovery requirements and conforms to all database and data quality policies and standards · Work closely with project teams to ensure project success; coordinate product releases, data structure evolution, and manage and synchronize data promotions between development, test and production environments · Act as the final point of escalation and resolution for data related issues · Provide advanced technical support for database developers · Provide 24x7 database support as part of a rotation of DBAs · Design, implement and maintain archival and high availability strategies *Skills and abilities* · Exceptional knowledge of the PostgreSQL database platform. Persons with skills n other relational databases such as MySql, Oracle or Ms Sql will also be considered. · Mastery of physical database design · Expertise in configuring, implementing and supporting high availability strategies with database systems including clustering, and replication · Mastery of ANSI SQL and/or PL-SQL · Experience in software development using Perl, Shell, or other scripting languages · Solution focused and methodical, careful attention to detail · Solid background using UNIX operating systems – Ubuntu Linux administration a plus Experience with SQL Server and/or Oracle database platforms is desirable · Ability to perform capacity planning which supports the forecasting and purchasing processes · Ability to implement Database security safeguards and audit them · Consistently learning about trends and features in DB solutions, able to · bring best practices to bear at solving DB and overall application problems · Ability to work in a high availability production environment where unplanned downtime is not acceptable · Ability to communicate ideas and designs to all stakeholders, including non-technical audiences