Database Administration Manager

Directorate: Information Communication Technology

Position: Database Administration Manager

Ref: NCWSC2012-008

Location: Headquarters - Kampala Road Industrial Area

Grade: 3

Reporting to: ICT Director

Supervises: Database Administration Coordinators and Officers

Broad Role: The Database Administration Manager (DBAM) is responsible for the performance, integrity and security of the Companies database. Additional role requirements are likely to include planning, development and troubleshooting.

Duties and responsibilities

• Organization’s database server administration
• Assist in the selection, installation, qualification, testing and validation of enterprise database systems and applications
• Design and develop databases, database users and database security and other database objects. Maintain version control of custom database objects and assist with the creation of entity relationship and modeling diagrams for new custom databases
• Create and maintain jobs/scripts with automated scheduling alerts, configuration and monitoring for all current and future databases. Responsible for monitoring the status of scheduled backups and database jobs
• Responsible for database security and the analysis and application of database patches and upgrades to database servers and components
• Optimization and performance tuning for all current and future databases and assisting the application team with application performance tuning
• Work with the Information Security Office to ensure compliance. Participate in audits by maintaining the necessary logs and providing reports or extracts to the qualified resources as requested for the audits
• Perform imports, exports and data conversion from one system to another as needed. Migrate between database platforms as necessary
• Participate in designing, setting up, implementing and testing business continuity and disaster recovery installations
• Installing and testing new versions of the database management system (DBMS).
• Ensuring that storage, archiving, back-up and recovery procedures are functioning correctly
• Communicating regularly with technical, applications and operational staff to ensure database integrity and security
• Oversee backup, clustering, mirroring, replication and failover
• Implement mechanisms for the restoration and recovery of databases
• Provide 24/7 support for critical situations.

Education, Professional Qualifications and Work Experience

• Degree in ICT or related field and/or relevant professional certification preferably Oracle Certified Professional (OCP)
• At least 5 years experience in data base administration or data base development
• Experience of managing multiple RDBMS on large systems
• Practical experience in monitoring and tuning a database to provide a high availability service
• Practical experience in managing the internal and external MS SQL database security
• Experience of Transactional SQL, and DTS stored procedures.

Required Skills and Competencies

• Strong self-sufficiency and initiative working on Database projects
• A proven track record of driving and defining complex IT strategy
• Exceptional communication skills are essential in order to explain complex IT concepts to non technical colleagues
• In depth experience of negotiating with and managing third parties
• Ability to work under pressure and meet deadlines.
• Knowledge of applicable data privacy practices and laws.

Interested candidates holding the necessary requirements are encouraged to send their hard copy application with clear reference of the job code on the envelope, detailed CV, names and contact of 3 referees, one of whom must be a former employer, copies of certificates, testimonials, current telephone number and email address on or before March 5 , 2012 to the address indicated below.

The Manager
Human Capital Advisory Services
The Kenya Institute of Management
P.O Box 43706 00100,
Nairobi Kenya

or dropped at

The Kenya Institute of management
2nd floor, Luther Plaza
Uhuru Highway/Nyerere Rd Roundabout

Only short listed candidates will be contacted.

Canvassing will lead to automatic disqualification.

Nairobi City Water & Sewerage Company (NCWSC) is an equal opportunity employer.