Database Admin

Apptad Inc; Phoenix (AZ); On-site; USD 90,000 - 140,000; Full time

Job summary

Apptad Inc. is seeking an experienced Database Administrator to support production systems in a 24x7 environment. The role covers multiple database platforms including Oracle, PostgreSQL, SQL Server, YugabyteDB and cloud-native options like Aurora and Spanner.

Responsibilities include monitoring, performance tuning, backups, patching, and high-availability operations. Strong scripting, automation and collaboration with cross-functional teams are essential.

Qualifications

• 5+ years of database administration experience (on production environments).
• Experience with Oracle, PostgreSQL, SQL Server, YugabyteDB, Aurora PostgreSQL/MySQL, and Spanner.
• Proficient in public cloud platforms (AWS, Azure, GCP).
• Experience with IaC using Terraform and configuration management with Ansible.
• Proficient in GitHub and GitHub Actions for CI/CD and source control.
• Proficient in monitoring with Grafana/Prometheus and Oracle OEM.
• Experience with containers (Docker, Kubernetes).
• Scripting skills in Shell, Python, and PowerShell.
• Familiarity with Linux/Unix and Windows operating systems.

Responsibilities

• Provide 24x7 production support; act as first point of contact for DB incidents and restoration.
• Manage DB startups, shutdowns, restarts, failover, switchover, and maintenance validations.
• Monitor DB availability, logs, OEM alerts, health checks; perform RCA for Sev1/Sev2 incidents.
• Troubleshoot DB performance using AWR, ASH, explain plans, locks, and long-running queries.
• Manage storage, ASM, archive logs, backups, RMAN, and DB recovery tasks.
• Support patching, upgrades, migrations, and OS/server maintenance.
• Schedule backups and DB jobs via OEM and CRON; configure alerts and dashboards.
• Manage users, roles, privileges, and application access; enforce security controls.
• Coordinate vendor cases for DBMS issues with cross-functional teams.
• Drive documentation, standardization and automation of DBA processes.
• Develop self-service tools and automation to improve ops.

Skills

Database administration

Production support

Incident response

Automation/DevOps mindset

Tools

Oracle

PostgreSQL

Microsoft SQL Server

YugabyteDB

Aurora PostgreSQL

Aurora MySQL

Spanner

AWS

Azure

GCP

Terraform

Ansible

GitHub

GitHub Actions

Grafana

Prometheus

Oracle OEM

Docker

Kubernetes

Shell

Python

PowerShell

Linux/Unix

Windows

Job description

Role - Database Admin

Experience Required -5+ Years

Must Have Technical/Functional Skills

• Oracle, PostgreSQL, Microsoft SQL Server, YugabyteDB, Aurora PostgreSQL, Aurora MySQL, and Spanner
• Public Cloud: AWS, Azure, GCP
• IaC: Terraform
• Configuration Management: Ansible
• Source Control & CI/CD: GitHub, GitHub Actions
• Monitoring: Grafana, Prometheus, ORACLE OEM
• Containers: Docker, Kubernetes
• Scripting: Shell, Python, PowerShell
• Operating Systems: Linux/Unix/windows

Roles & Responsibilities

• Provide 24x7 support for Production (E3) and lower environments; act as the first point of contact for database incidents, restore service, perform troubleshooting, and route issues when required.
• Manage database startups, shutdowns, restarts, instance failover, switchover, parameter changes, and pre/post maintenance validations.
• Monitor database availability, alert logs, OEM alerts, health checks, and infrastructure-related issues; perform root cause analysis for Sev1 and Sev2 incidents.
• Troubleshoot database and SQL performance using AWR, ASH, explain plans, locks, deadlocks, blocking sessions, and long-running session reports.
• Manage database, tablespace, ASM, archive log, backup, Oracle Home, and OS filesystem capacity; forecast space needs and coordinate storage additions.
• Perform proactive and ad-hoc backups, restore points, flashback restores, RMAN table recovery, database restoration, and standby database rebuild.
• Support OS and database patching, upgrades, migrations, server reboots, and application or database maintenance changes.
• Schedule and maintain backup and database jobs using OEM and CRON; configure monitoring thresholds, alerts, reports, and Grafana dashboards.
• Administer users, profiles, roles, privileges, schema unlocks, DBA IDs, application access, and required access for RFC execution.
• Maintain database security, audit configuration, TDE, encryption, and object validity checks.
• Monitor and support Data Guard, GoldenGate, PostgreSQL/SQL Server/YugabyteDB replication, replication lag resolution, DR activities, switchovers, and failovers.
• Support export/import, data truncation, and application-requested database activities in accordance with change controls.
• Develop self-service and automation tools.
• Raise and coordinate vendor cases for DBMS software issues and work directly with application, infrastructure, development, and DBA teams.
• Drive documentation, standardization, operational improvements, and DBA process automation.
• Experience in scripting and AI related tools.
• Experience on Public cloud environments.