Database Administrator - IT
NMC Healthcare
- Abu Dhabi
- Permanent
- Full-time
- 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
- 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
- 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