Database Administrator with AWS

🌟 We're Hiring: 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.