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