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 account management. • Support security compliance and audit requirements. • Review vendor security advisories for Oracle, MySQL, PostgreSQL, DB2, and Java. • Maintain evidence for security, backup, patching, and compliance activities. Security Clearanc e Due to project requirement Need Cat 2 Clearance