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 Clearance

Due to project requirement Need Cat 2 Clearance