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.