Job Summary
Database Administrator / Engineer (L2) with 6+ years of experience in enterprise database administration and production support across relational and NoSQL database platforms. Responsible for administration, monitoring, performance tuning, backup/recovery, patching, incident resolution, access management, and operational support of Oracle, PostgreSQL, Amazon Aurora, MongoDB, and Amazon DynamoDB environments across on-premises and cloud infrastructure.
Key Responsibilities
Administer and support Oracle, PostgreSQL, Amazon Aurora, MongoDB, and DynamoDB database environments. Monitor database availability, health, performance, capacity, and resource utilization. Perform database installation, configuration, patching, upgrades, and maintenance activities. Troubleshoot database connectivity, performance, locking, query, storage, and availability issues. Perform backup, restore, recovery, and database refresh/clone activities. Support database High Availability (HA), replication, and Disaster Recovery (DR) operations. Perform SQL/query performance analysis, indexing, and database performance tuning. Manage database users, roles, privileges, and access in accordance with security requirements. Support AWS managed database services, including Aurora and DynamoDB. Support database migrations, maintenance activities, and approved production changes. Perform database capacity monitoring and proactively identify utilization or performance issues. Support vulnerability remediation, database patching, and security-hardening activities. Handle L2 incidents, service requests, problems, and changes within defined SLAs. Coordinate with Application, Cloud, Infrastructure, Cybersecurity, and Development teams. Maintain SOPs, operational runbooks, configuration documentation, and knowledge articles.
Skill Requirements
Strong hands-on experience in Database Administration and Production Support. Experience administering Oracle and PostgreSQL databases. Hands-on knowledge of Amazon Aurora (PostgreSQL/MySQL compatible) and AWS database services. Experience supporting MongoDB databases and NoSQL environments. Working knowledge of Amazon DynamoDB administration and monitoring. Strong knowledge of SQL, query analysis, indexing, and performance tuning. Experience with database backup, recovery, replication, HA, and DR. Understanding of database security, user/role administration, and access controls. Knowledge of Linux/Unix environments and Shell scripting. Experience with database monitoring and performance-management tools. Knowledge of AWS cloud infrastructure and database connectivity. Familiarity with scripting/automation using Python, Shell, Ansible, or equivalent tools. Knowledge of Incident, Problem, Change, and Release Management processes. Strong troubleshooting, analytical, documentation, and communication skills. Relevant Oracle, PostgreSQL, MongoDB, or AWS certifications preferred.