Cloud Database Administrator (DBA) Engineer

About the role

The Cloud Database Administrator Engineer is responsible for the architecture, engineering, automation, security, availability, and operational support of The Clearing House's enterprise database platforms across on-premises and cloud environments. This role serves as a senior technical leader responsible for Db2 LUW, Microsoft SQL Server, AWS database services, and database platform modernization initiatives.

Responsibilities

• Architect, deploy, administer, and optimize enterprise Db2 LUW and Microsoft SQL Server environments.
• Manage database lifecycle activities including installation, upgrades, patching, performance tuning, capacity planning, backup and recovery, and security administration.
• Ensure database platforms meet enterprise standards for availability, performance, scalability, and compliance.
• Design and maintain database operational standards, procedures, and governance frameworks.
• Design, deploy, and administer cloud-native database services within AWS and Azure environments.
• Engineer resilient and scalable database solutions utilizing AWS RDS, EC2-hosted databases, EBS storage, AWS Backup, CloudWatch, and related cloud services.
• Develop cloud migration strategies for enterprise database workloads using replication-based migration methodologies and minimal downtime approaches.
• Optimize cloud database performance, resiliency, and cost efficiency.
• Design, implement, and maintain enterprise HA/DR solutions including:
• Db2 LUW: HADR, Pacemaker Cluster Manager, Q Replication, near-zero downtime maintenance solutions, cross-site failover architectures.
• SQL Server: Always On Availability Groups, distributed availability groups, FCI, log shipping, transactional replication.
• Cloud HA/DR patterns: AWS RDS Multi-AZ deployments, cross-region disaster recovery, pilot light architectures, warm standby architectures, active/passive and active/active recovery strategies, automated failover and recovery orchestration.
• Lead disaster recovery testing, failover exercises, and business continuity planning.
• Develop Infrastructure as Code solutions using Terraform.
• Automate database provisioning, configuration, patching, monitoring, backup validation, and recovery processes.
• Utilize Ansible, Puppet, Python, PowerShell, and Shell scripting to improve operational efficiency.
• Integrate database deployments into CI/CD pipelines and DevOps workflows.
• Champion GitOps and automation-first operational models.
• Implement database security controls aligned with financial industry regulations and corporate standards.
• Configure encryption at rest and in transit.
• Implement least-privilege access models and database auditing solutions.
• Support compliance requirements including PCI-DSS, FFIEC, SOC, and NIST frameworks.
• Participate in security assessments, audits, and vulnerability remediation efforts.
• Serve as senior technical advisor and subject matter expert for database technologies.
• Mentor junior engineers and database administrators.
• Lead architecture reviews, technology evaluations, and modernization initiatives.
• Act as escalation point for complex database incidents and enterprise projects.
• Communicate technical strategies and recommendations to executive leadership and governance committees.

Requirements

• Bachelor's degree in Computer Science, Information Systems, Engineering, or equivalent experience.
• 10+ years of enterprise database administration and engineering experience.
• Expert-level experience administering Db2 LUW 11.5+ in Linux environments.
• Expert-level experience administering Microsoft SQL Server 2019+.
• Extensive experience with Db2 HADR, Pacemaker clustering, and Q Replication.
• Extensive experience with SQL Server Always On Availability Groups and related HA technologies.
• Proven experience designing and supporting cloud database platforms within AWS.
• Strong experience with AWS RDS, EC2, VPC, IAM, CloudWatch, KMS, and AWS Backup.
• Expertise with Infrastructure as Code using Terraform.
• Strong scripting experience using Python, PowerShell, Bash, or similar languages.
• Experience leading large-scale database migration and modernization initiatives.
• Strong understanding of database performance tuning and capacity management.
• Experience supporting mission-critical production systems with stringent availability requirements.

Qualifications Desired

• Master's Degree in Computer Science, Engineering, or related field.
• AWS Certified Database Specialty.
• AWS Solutions Architect Professional.
• MICe Certified: Azure Database Administrator Associate.
• IBM Db2 Professional Certification.
• Experience with PostgreSQL and cloud-native PostgreSQL services.
• Experience with Dell EMC Data Domain and PowerProtect Data Manager.
• Experience with Kubernetes and containerized database workloads.
• Familiarity with observability platforms including Prometheus, Grafana, Splunk, and Datadog.
• Experience working within highly regulated financial services environments.

Benefits

Commensurate with experience.

Pay

$92,235 per year

Schedule

Full time