Overview

Responsibilities

• Implementation of approved DDL and DML changes in both prod and non-prod environments
• Manage and use database scripts in Bitbucket for deployment in support of release and change management process
• Review and approve application-driven database changes, to ensure compliance with performance, security, operational, and recoverability standards
• Review application SQL for correctness, efficiency, and safety
• Develop and maintain a working understanding of the application data models, including core tables, relationships, data flows, and how applications use the schema, to support troubleshooting and change review
• Monitor database health, performance, and capacity and act on alerts
• Support application teams in troubleshooting database related issues
• Support release cycles and assist with database patching, upgrades, and routine maintenance activities
• Support backup, recovery, and restore validation activities
• Facilitate user access management and support data security practices, including PII awareness and customer data redaction requests
• Participate in an on-call rotation that includes some light after-hours support

• Proven ability to safeguard confidential and highly sensitive database content
• Strong communication skills, able to articulate complex technical issues clearly
• Strong teamwork, decision-making, documentation, and analytical skills
• Knowledge of backup and recovery technologies and processes relevant to Oracle/PostgreSQL
• Experience with database user administration, access control, and least-privilege practices
• Experience with database monitoring, alerting, and basic performance analysis
• Experience with using version control (such as Git or Bitbucket) for committing, reviewing, and pulling database changes as part of the deployment workflow

Qualifications

• Must be presently authorized to work in the U.S. without a requirement for work authorization sponsorship by our company for this position now or in the future
• Must reside in the United States (does not include Alaska or Hawaii)
• Must be able to work a schedule within U.S. Central Standard Time core business hours.
• 3+ years of administering databases in a production environment, with strong experience in Oracle or PostgreSQL
• Experience working in both on-prem and cloud-based environments, or strong experience in one with demonstrated aptitude to support and learn the other
• Strong SQL skills, including the ability to write and read complex queries, review changes, and identify inefficient or incorrect scripts
• Experience supporting application development teams with troubleshooting, release coordination, and change review
• Must be committed to incorporating security into all decisions and daily job responsibilities

• Bachelor's degree in Computer Science, Computer Information Systems, Management Information Systems, or related field preferred
• Experience with cloud-managed database services (AWS RDS, Aurora, etc), including backup, replication, and failover
• Experience with PL/SQL or PL/pgSQL stored procedures and functions
• Practical experience with Oracle tools such as OEM, RMAN, and Data Guard
• Experience working with infrastructure-as-code tools such as Terraform for cloud configuration and support
• Experience working in a Unix command line environment and with scripting languages (Shell, Python, Perl, etc)
• Knowledge of Agile methodology and tools like JIRA and Confluence
• Understanding of data governance and security standards (such as PCI)