Database Administrator (Contract)

Job responsibilities:

• Perform installation, configuration, and upgrades of Oracle (12c/19c/21c) and PostgreSQL software in both Linux and Windows environments.

• Routine Maintenance: Execute patching management, monitor storage capacity, and conduct regular database health checks.

• Performance Optimization: Conduct query tuning, index optimization, and execution plan analysis to ensure low-latency application performance.

• Data Security: Manage user privileges, data encryption, and ensure strict compliance with corporate data security standards.

• Backup & Recovery: Develop and test Disaster Recovery (DR) strategies; perform routine backups using RMAN (Oracle) and pg_dump/Barman (PostgreSQL).

• High Availability: Manage data replication and failover utilizing Oracle Data Guard and PostgreSQL HA solutions (e.g., Patroni or Repmgr).

• Troubleshooting: Serve as the primary point of contact for database incidents and perform comprehensive Root Cause Analysis (RCA).
  

Qualifications:
Experience: 3–5 years as a DBA with a Bachelor's degree in IT or related fields.

• Technical Mastery:

  • Oracle: SGA/PGA, RMAN, Data Guard, and RAC.

  • PostgreSQL: Administration, Extensions, and Streaming Replication.

  • Scripting: Proficient in Linux (RHEL/Ubuntu) and Bash or Python automation.

  • SQL: Deep knowledge of PL/SQL and PL/pgSQL.

• Soft Skills: Strong analytical thinking, detail-oriented, and able to work under pressure.

Bonus Points

• Certified OCP or PostgreSQL Professional.

• Experience with Cloud Databases (AWS RDS, Google Cloud SQL, or Azure).