Sr Database Engineer

American Fork, UT

$101,500–$169,100 Per Year

1 day ago

Job Description

The Database Administrator is responsible for the day-to-day operational health, reliability, and performance of enterprise database environments hosted on AWS. The primary database platform for this role is PostgreSQL or MySQL on Linux/AWS RDS; candidates with solid Oracle 19c experience are equally welcome. Reporting to the Lead Database Administrator, this role executes within established architectural standards, independently resolving the full spectrum of operational database issues while escalating complex architectural decisions as appropriate.

Key Responsibilities

Daily Operations & Monitoring

Monitor health, performance, and availability of Production, QA, and Development databases (PostgreSQL, MySQL, and/or Oracle) hosted on AWS on a daily basis.
Respond to monitoring alerts, investigate root causes, and resolve common issues: space exhaustion, blocking sessions, runaway queries, and service disruptions.
Track resource utilization (CPU, memory, I/O, storage) and report capacity trends to the Lead DBA for planning.
Review database alert logs, audit logs, and job scheduler outputs proactively; participate in the rotating on-call DBA schedule.

Maintenance & Administration

Execute scheduled and ad hoc maintenance: table reorganization, index rebuilding, statistics gathering, tablespace/schema management, and object defragmentation.
Administer databases on Linux EC2 instances and AWS RDS - including startup/shutdown, patch application, and minor version updates under Lead DBA guidance.
Manage database user accounts, roles, and privileges in accordance with security policies and RBAC standards.
Apply patches and cumulative updates in non-production environments, documenting steps for Lead DBA review before production rollout.
Perform database cloning and environment refreshes for QA and development on a scheduled and on-demand basis.

Backup, Recovery & Business Continuity

Execute and validate backup jobs (RMAN for Oracle; pg_basebackup/pgBackRest for PostgreSQL; mysqldump/Percona XtraBackup for MySQL), ensuring schedules meet RPO targets.
Perform point-in-time and full restores in non-production environments to verify backup integrity and document recovery procedures.
Monitor AWS RDS automated backup and snapshot jobs; alert the Lead DBA to failures or anomalies.
Assist with disaster recovery testing and failover validation under Lead DBA direction; maintain up-to-date backup and recovery runbooks.

Performance Monitoring & Query Tuning

Identify slow-running queries and performance bottlenecks using platform-appropriate tools: EXPLAIN/EXPLAIN ANALYZE (PostgreSQL/MySQL), Oracle AWR/ADDM/ASH, wait event analysis, and execution plan review.
Assist application developers in tuning PL/SQL, PG/SQL, and T-SQL code for improved database access efficiency.
Monitor and manage index health; rebuild or coalesce fragmented indexes within maintenance schedules.
Review and optimize long-running batch jobs and scheduled tasks to minimize contention during peak hours.

Automation & Scripting

Write and maintain UNIX/Linux shell scripts to automate recurring tasks: log archiving, space checks, health reporting, and backup verification.
Schedule and manage automated jobs using cron, pgAgent / MySQL Event Scheduler, Oracle DBMS_SCHEDULER, and/or SQL Server Agent as applicable.
Maintain and update existing Terraform scripts for minor infrastructure changes under Lead DBA review and approval.
Document all automation scripts with clear inline comments; maintain a centralized runbook repository.

Development Support & Collaboration

Write, test, and debug PL/SQL, PG/SQL, and SQL scripts, stored procedures, and ad hoc queries in support of development and operations teams.
Collaborate with application development teams to provide database support during sprint cycles, deployments, and hotfixes.
Assist with data loads, migrations, and import/export operations using platform-native tools (pg_dump, mysqldump, Oracle Data Pump, SQL*Loader) and AWS DMS.
Support QA teams by providing accurate test data, database snapshots, and query assistance for validation activities.

Required Qualifications

Bachelor's degree (or equivalent) in Computer Science, Computer Engineering, or a related field, plus 4 years of hands-on database administration experience.
Primary expertise in at least one of the following: PostgreSQL on Linux / AWS RDS, MySQL on Linux / AWS RDS, or Oracle 19c on Linux. Multi-platform experience is a strong plus.
Solid working knowledge of backup and recovery strategies on your primary platform (pg_basebackup / pgBackRest, Percona XtraBackup, or Oracle RMAN).
Working knowledge of database performance diagnostics: EXPLAIN/EXPLAIN ANALYZE, query plan analysis, wait event analysis, and index tuning.
Hands-on experience writing SQL and scripting in PL/SQL and/or PG/SQL for operational and support tasks.
Practical UNIX/Linux systems administration and shell scripting experience (bash/ksh).
Exposure to AWS-hosted database environments: EC2-hosted databases and/or AWS RDS.
Understanding of database security fundamentals: user privilege management, role-based access control (RBAC), and auditing.
Strong attention to detail, disciplined change management habits, and reliable follow-through on assigned tasks.
Good communication skills with the ability to document procedures clearly and coordinate effectively with developers, QA teams, and the Lead DBA.

Preferred Qualifications

Cross-platform DBA experience: working knowledge of at least two of PostgreSQL, MySQL, and Oracle in a production environment.
Familiarity with Oracle Data Guard, PostgreSQL Streaming Replication, or MySQL Group Replication for standby/HA configurations.
Experience with AWS RDS and Aurora for PostgreSQL or MySQL workloads.
Exposure to Terraform or other infrastructure-as-code (IaC) tooling.
MS SQL Server administration experience in a production setting.
Experience in an Agile/Scrum delivery environment.
Knowledge of load testing tools and performance benchmarking methodologies.
Familiarity with streaming or integration technologies: AWS Kinesis, Apache Kafka, or Informatica.
Relevant professional certification: PostgreSQL Professional Certification, Oracle OCP, AWS Database Specialty, or equivalent.

USD 101,500.00 - 169,100.00 per year

Compensation:

Compensation includes a base salary in the range of $101,500.00 - $169,100.00. The base salary may vary within the anticipated base pay range based on factors such as the ultimate location of the position and the selected candidate's knowledge, skills, and abilities. Position may be eligible for additional compensation that may include an incentive program.

Benefits:

The Company offers eligible employees the flexibility to take as much vacation with pay as they deem consistent with their duties, the company's needs, and its obligations; seven paid holidays throughout the calendar year; and up to 160 hours of paid wellness annually for their own wellness or that of family members. Employees are also eligible for additional paid time off in the form of bereavement leave, time off to vote, jury duty leave, volunteer time off, military leave, and parental leave.

EOE, including disability/vets

Numbers & Facts

Location	American Fork, UT
Salary	$101,500–$169,100 Per Year

Skills

Access Controlunmatched
Advertising Schedulingunmatched
Agile Programming Methodologiesunmatched
Amazon Elastic Compute Cloud (EC2)unmatched
Amazon Relational Database Service (RDS)unmatched
Amazon Web Services (AWS)unmatched
Analysis Skillsunmatched
Apache Kafkaunmatched
Architectural Servicesunmatched
Auditingunmatched
Bash Scriptingunmatched
Benchmarkingunmatched
CPU (Central Processing Unit)unmatched
Change Managementunmatched
Cloningunmatched
Communication Skillsunmatched
Computer Engineeringunmatched
Computer Scienceunmatched
Computer Securityunmatched
Data Migrationunmatched
Data Recoveryunmatched
Database Administrationunmatched
Database Programmingunmatched
Database Replicationunmatched
Debugging Skillsunmatched
Detail Orientedunmatched
Documentationunmatched
Failoverunmatched
Follow Throughunmatched
Import/Exportunmatched
Informaticaunmatched
Information/Data Security (InfoSec)unmatched
Input/Outputunmatched
Ksh (Korn Shell) Scriptingunmatched
Linux Administrationunmatched
Linux Operating Systemunmatched
Load Testingunmatched
Machine Toolunmatched
Memory Hardwareunmatched
Microsoft SQL Server DBA (Database Administration)unmatched
Microsoft Transact-SQL (T-SQL)unmatched
Multiplatform/Cross-Platformunmatched
MySQLunmatched
On Callunmatched
Operational Supportunmatched
Operationsunmatched
Oracleunmatched
Oracle Certificationsunmatched
Oracle PL-SQLunmatched
Oracle SQL*Loaderunmatched
Performance Analysisunmatched
Performance Testingunmatched
PostgreSQLunmatched
Problem Solving Skillsunmatched
Production Systemsunmatched
Pumpsunmatched
Quality Assuranceunmatched
Query Analysisunmatched
RMANunmatched
Resource Utilizationunmatched
Root Cause Analysisunmatched
SQL (Structured Query Language)unmatched
Schedule Developmentunmatched
Scripting (Scripting Languages)unmatched
Scrum Project Management and Software Developmentunmatched
Software Developmentunmatched
Software Patchesunmatched
Startupunmatched
Statisticsunmatched
Stored Proceduresunmatched
Streaming Technologyunmatched
Test Dataunmatched
Test Plan/Scheduleunmatched
Test Toolsunmatched
Trend Analysisunmatched
Unix Shell Programmingunmatched
Unix System Administrationunmatched
User Account Administrationunmatched
Validation Testingunmatched

Level up your application

Professional resume templates

Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

Free resume templates

Free resume builder

Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

Free resume builder

Sr Database Engineer

Job Description

Numbers & Facts

Skills

Level up your application

Professional resume templates

Free resume builder