Senior DBA Engineer - Oracle SQL/Cloud

Enterprise
Richmond Heights, United States of America
yesterday

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Remote
Richmond Heights, United States of America

Tech stack

Agile Methodologies
Confluence
JIRA
Bash
Cloud Computing
Databases
Customer Data Management
Data Governance
Data Manipulation Languages
Data Security
Database Queries
Oracle Data Guard
Perl
Failover
Python
PostgreSQL
Oracle Applications
Oracle SQL Developer
Release Management
Application Data
Recovery Manager (RMAN)
Software Engineering
SQL Stored Procedures
PL-SQL
SQL Databases
Data Streaming
Unix Commands
Scripting (Bash/Python/Go/Ruby)
GIT
Amazon Web Services (AWS)
Infrastructure Automation Frameworks
Information Technology
Bitbucket
Database Monitoring
Terraform
Software Version Control
User Administration

Job description

The Rental Billing department is responsible for maintaining and managing the billing and invoicing software that produces outputs for our customers globally. This includes maintaining and managing interfaces with internal applications and delivering electronic data to external organizations and customers. This is an exciting time to be part of the billing team as we continue expanding globally and increasing our footprint across both on-prem and cloud-based database platforms., As an Engineer 2, DBA, you will play a key role in the day-to-day operation, stability, and support of our database environments. This role is focused on supporting application teams, maintaining database health, and ensuring that database changes are implemented safely and efficiently across both on-prem and cloud environments. You will work with Oracle and PostgreSQL databases and collaborate closely with development teams to review database changes, troubleshoot issues, and support application releases., * Implementation of approved DDL and DML changes in both prod and non-prod environments

  • Commit and manage database scripts in Bitbucket and pull approved changes 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 SQL from application teams 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

Requirements

  • 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 on-, Required:
  • 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 St. Louis, Missouri, or immediate surrounding area
  • 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
  • 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
  • Must be committed to incorporating security into all decisions and daily job responsibilities

Preferred:

  • 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)

Benefits & conditions

As an Enterprise Mobility team member, we offer an excellent package with market-competitive pay, comprehensive healthcare packages, 401k matching & profit sharing, schedule flexibility, work from home opportunities, paid time off, and organizational growth potential.

About the company

Enterprise Mobility is a leading provider of mobility solutions, owning and operating the Enterprise Rent-A-Car, National Car Rental and Alamo Rent A Car brands through its integrated global network of independent regional subsidiaries. Enterprise Mobility and its affiliates offer extensive car rental, carsharing, truck rental, fleet management, retail car sales, as well as travel management and other transportation services, to make travel easier and more convenient for customers. Privately held by the Taylor family of St. Louis, Enterprise Mobility together with its affiliate Enterprise Fleet Management manages a diverse fleet of 2.4 million vehicles and accounted for nearly $39 billion in revenue through a network of more than 9,500 fully-staffed neighborhood and airport rental locations in more than 90 countries and territories. At the center of it all, our dedicated IT teams innovate, design and develop the technology that is redefining how customers rent, buy and share vehicles from our family of brands. Here, you will be part of a diverse and talented team that creates and delivers powerful technology solutions for our customers and employees across the world with the resources and support to develop in a variety of career paths.

Apply for this position