Database Administrator

Job Description

• Manage databases operations of various flavours in line with policies and ensure availability and performance of application are effectively handled.
• Responsible for uptime of healthcare applications and database.
• Provides application systems administration including maintenance e.g., configuring and monitoring tomcat application servers, java and scheduling jobs.
• Performs installations, configurations, upgrades, clone and patching of Postgersql Database servers and Tomcat application servers.
• Serves as a subject matter expert (SME) in database management and mentoring throughout the Commission, providing guidance on data technologies, as well as developing and implementing data strategies and policies.
• Responsible for Postgresql Database administration and management.
• Supports developers for custom coding, code migration, interface design, SQL procedures and creates shell/SQL scripts, packages, and stored procedures to manipulate data.
• Estimate PostgreSQL database capacities; develop methods for monitoring database capacity and usage.
• Accountable for monitoring and uptime of all production databases 
• Responsible for developer SQL code review to ensure queries are optimized and tuned.
• Provide consistent maintenance on databases (e.g., Vacuum, Reindexing, Archiving).
• Lead pro-active remediation of database operational problems.
• Responsible for Query tuning and preventative maintenance