Abu Dhabi, United Arab Emirates
Accountable for monitoring and uptime of all production databases

Estimate PostgreSQL database capacities; develop methods for monitoring database capacity and usage.

Lead efforts to develop and improve procedures for automated monitoring and proactive intervention, reducing any need for downtime

Participate in application development projects and arrange for the database architecture and design

Contribute to the creation of development, staging, and production database instances, and the migration from one environment to another

Responsible for developer SQL code review to ensure queries are optimized and tuned

Complete regular backups and recovery of databases

Designing disaster recovery strategy for postgresql and sql server instances

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

Participate in a 24×7 support rotation

Support complex tomcat web-based applications

Qualifications

5-7 years of relevant experience

Bachelor degree in Computer Science, Math, 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

Ability to thrive in a fast-paced environment and able to match stakeholder expectations to urgently deliver exceptional results
Apply for this job

Feedback / Suggestion

Icon