Oracle Apps DBA NMC Food Lands Building Abu Dhabi
Full time @Commercial Bank of Dubai posted 10 months ago Shortlist Email JobJob Detail
-
Job ID 9171
-
Career Level Executive
-
Experience Fresh
-
Gender Female|Male
Job Description
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
Other jobs you may like
-
Technical Documentation Specialist/Graphics Designer NAFFCO Dubai
- @ NAFFCO
- Jebel Ali Free zone، South Area، Jebel Ali Free Zone Street, Dubai, AE