Database Admin

Realign Llc; Phoenix (AZ); On-site; USD 120,000 - 180,000; Full time

Job summary

Realign Llc is seeking a Database Admin to join our Phoenix, AZ team on a full-time, onsite basis. You will manage Oracle, PostgreSQL, MS SQL Server, YugabyteDB, and more, while supporting 24x7 production environments and performing complex troubleshooting.

The role requires 5+ years of experience, strong scripting skills, and proficiency with Terraform, Ansible, Grafana, Docker, Kubernetes, and cloud platforms (AWS/Azure/GCP).

Qualifications

• 5+ years of database administration experience.
• Strong knowledge of Oracle, PostgreSQL, MS SQL Server, YugabyteDB, and Spanner.
• Experience with public cloud environments (AWS/Azure/GCP).
• Proficiency in Terraform, Ansible, GitHub, and CI/CD tooling.
• Monitoring with Grafana/Prometheus and OEM.
• Containers: Docker and Kubernetes.
• Scripting: Shell, Python, PowerShell.

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.

Skills

Oracle

PostgreSQL

Microsoft SQL Server

YugabyteDB

Aurora PostgreSQL

Aurora MySQL

Spanner

Tools

Docker

Kubernetes

Grafana

Prometheus

Oracle OEM

GitHub Actions

Cron

Job description

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

Scripting: Shell, Python, PowerShell

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.

Required Skills

Job Type: Full Time

Job Category: IT

Job Description

Role: Database Admin

Location: Phoenix, AZ (Onsite)

Fulltime – Permanent

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.

Required Skills

Database Administrator