Database Administrator with AWS

Job Description We are looking for an experienced DatabaseAdministrator (DBA) with strong hands-on experience in Oracle, MySQL,PostgreSQL, and IBM DB2 databases across both AWS cloud and on-premises/EC2environments. The candidate should have strong expertise in Oracle RAC, DataGuard, 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 · Administerand support Oracle, MySQL, PostgreSQL, and IBM DB2 databases. · Manage AWSRDS Oracle, RDS/Aurora MySQL, and RDS PostgreSQL environments. · Manage DB2and MySQL databases hosted on AWS EC2. · Performdatabase installation, configuration, upgrades, patching, maintenance, andtroubleshooting. · Monitordatabase availability, performance, capacity, and resource utilization. · Performdatabase backup, recovery, restore testing, and disaster recovery activities. · Managedatabase users, roles, privileges, authentication, and security controls. · Performdatabase performance and SQL tuning. · Supportproduction deployments, maintenance activities, incidents, and change requests. Qualifications Oracle DBASkills · OracleDatabase 19c administration. · Oracle RAC,Data Guard, and ASM. · RMAN backupand recovery. · Oracleperformance and SQL tuning. · Oraclepatching, Release Updates (RU), and upgrades. · Data Guardswitchover/failover and DR activities. · RAC and ASMtroubleshooting. · Oraclesecurity, auditing, users, roles, and privileges. MySQL Skills · MySQL 5.7/8.0administration. · AWSRDS/Aurora MySQL administration. · MySQLadministration on AWS EC2. · Backup andrecovery. · Replicationand high availability. · Performancemonitoring and SQL tuning. · User andprivilege management. · MySQL patching, upgrades, and vulnerability remediation. · Troubleshooting connectivity, locking, replication, and performance issues. PostgreSQL Skills · PostgreSQL administration, preferably versions 17 · AWS RDSPostgreSQL 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 DB2database administration on AWS EC2/Linux. · DB2installation, configuration, maintenance, and troubleshooting. - DB2 Fix Packup grades and security patching. · DB2 Java/ JDK upgrades and compatibility management. · DB2 backup, recovery, restore, and DR activities. · DB2 HADR and high-availability configuration. · TroubleshootingDB2 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 DB2software 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 DB2Fix 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 DB2on Amazon EC2 · AWS backup and restore. · Cloud Watch monitoring and alerting.