Database Administrator with AWS

Job Description We are looking for an experienced Database Administrator (DBA) with strong hands‑on experience in Oracle, MySQL, PostgreSQL, and IBM DB2 databases across both AWS cloud and on‑premises/EC2 environments. The candidate should have strong expertise in Oracle RAC, Data Guard, ASM, AWS RDS/Aurora, DB2 administration, Fix Pack and Java upgrades, ILMT compliance, database performance tuning, backup/recovery, security, patching, and high‑availability/DR solutions.

Key Responsibilities

Administer and support Oracle, MySQL, PostgreSQL, and IBM DB2 databases.

Manage AWS RDS Oracle, RDS/Aurora MySQL, and RDS PostgreSQL environments.

Manage DB2 and MySQL databases hosted on AWS EC2.

Perform database installation, configuration, upgrades, patching, maintenance, and troubleshooting.

Monitor database availability, performance, capacity, and resource utilization.

Perform database backup, recovery, restore testing, and disaster recovery activities.

Manage database users, roles, privileges, authentication, and security controls.

Perform database performance and SQL tuning.

Support production deployments, maintenance activities, incidents, and change requests.

Qualifications Oracle DBA Skills

Oracle Database 19c administration.

Oracle RAC, Data Guard, and ASM.

RMAN backup and recovery.

Oracle performance and SQL tuning.

Oracle patching, Release Updates (RU), and upgrades.

Data Guard switchover/failover and DR activities.

RAC and ASM troubleshooting.

Oracle security, auditing, users, roles, and privileges.

MySQL Skills

MySQL 5.7/8.0 administration.

AWS RDS/Aurora MySQL administration.

MySQL administration on AWS EC2.

Backup and recovery.

Replication and high availability.

Performance monitoring and SQL tuning.

User and privilege management.

MySQL patching, upgrades, and vulnerability remediation.

Troubleshooting connectivity, locking, replication, and performance issues.

PostgreSQL Skills

PostgreSQL administration, preferably versions 17

AWS RDS PostgreSQL administration.

Backup and recovery using pg_dump/pg_restore and physical backups.

Streaming replication and high availability.

PostgreSQL performance and SQL tuning.

PostgreSQL patching and major‑version upgrades.

User, role, and privilege management.

IBM DB2 Skills

IBM DB2 database administration on AWS EC2/Linux.

DB2 installation, configuration, maintenance, and troubleshooting. - DB2 Fix Pack upgrades and security patching.

DB2 Java/JDK upgrades and compatibility management.

DB2 backup, recovery, restore, and DR activities.

DB2 HADR and high‑availability configuration.

Troubleshooting DB2 database and application connectivity issues.

Review IBM security advisories and perform vulnerability remediation.

IBM ILMT & License Compliance

Manage and support IBM License Metric Tool (ILMT) requirements.

Monitor DB2 software inventory and license usage.

Maintain IBM licensing and compliance documentation.

Support ILMT audits and provide required compliance evidence.

Coordinate with infrastructure/licensing teams for IBM software compliance. - Ensure DB2 Fix Pack and Java/JDK versions meet organizational security and compliance requirements.

AWS / Cloud Skills

Hands‑on administration of: - Amazon RDS for Oracle

Amazon RDS/Aurora MySQL

Amazon RDS PostgreSQL

MySQL and DB2 on Amazon EC2

AWS backup and restore.

CloudWatch monitoring and alerting.

AWS security and database monitoring.

AWS KMS, Secrets Manager, and IAM concepts.

Database migration and cloud modernization experience.

Understanding of AWS high availability, Multi‑AZ, backup, and DR architecture.

Security & Compliance

Database vulnerability assessment and remediation.

Security patching and database version upgrades.

Database auditing and logging.

Password and privileged