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