Oracle Apps DBA NMC Food Lands Building Abu Dhabi

An Oracle Apps DBA (Database Administrator) at NMC Healthcare will manage databases operations of various flavours in line with policies and ensure availability and performance of application are effectively handled. The role holder is also responsible for uptime of healthcare applications and database.

Responsibilities of Oracle Apps DBA

• 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 PostgreSQL Database servers and Tomcat application servers.
• Serves as a subject matter expert (SME) in database management. 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.

Qualifications & Experience

Following is the eligibility criteria for the role of Oracle Apps DBA – IT at NMC Healthcare:

• Bachelor’s degree in computer science, Engineering.
• 4-6 years of relevant experience.
• PostgreSQL 9.6+ and MS sql server experience required.

Knowledge & Skills

• 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.

Database Administrator ENOC UAE

Learning and Development Officer NMC Healthcare Abu Dhabi

Consultant Endocrinology NMC Food Lands Building Abu Dhabi

Tagged as: Database Administrator