• 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

Competencies

• Prioritizes, considers alternatives, and responds quickly and effectively to unexpected IT incidents/events
• Effectively applies technical knowledge to solve a range of problems
• Possesses an in-depth knowledge and skill in a technical area
• Develops technical solutions to new or highly complex problems that cannot be solved using existing methods or approaches

Main KPIs

• Availability of application and database 
• Backup and restore of database 
• Responsiveness and query performance 
• Capacity Planning and Maintenance of Application and database 

• 4-6 years of relevant experience
• Bachelor’s degree in computer science, Engineering
• PostgreSQL 9.6+ and MS sql server experience required.
• Must have proficiency in PostgreSQL database architecture, logical and physical design, automation, documentation, installs, shell scripting, PL/ SQL programming, catalog navigation, query tuning, system tuning, resource contention analysis, backup and recovery, standby, replication, etc.
• Deep/wide knowledge of Linux and windows OS
• Understanding of command line and server administration
• Command of shell scripting (e.g., Bash, Perl)
• Strong analytical, verbal and written communication skills