NMC Healthcare is currently seeking to hire a candidate for the job role of a Database Administrator in IT at Food Lands Building, Abu Dhabi, UAE. This is an Intermediate level full time role. For this position salary ranges from 10000-20000 AED, which may be slightly negotiable during the interview process.
Responsibilities of Database Administrator
- 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.
Requirements for Role of Database Administrator
- Bachelor’s degree in computer science, Engineering.
- 4-6 years of relevant experience
- PostgreSQL 9.6+ and MS SQL server experience required.
Skills And Knowledge Desired
- 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.
