Codes Administrator Jobs (NOW HIRING)

Position Summary

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. The engineer will design and implement highly available, secure, automated, and scalable database solutions supporting mission‑critical payment systems and corporate applications. This position requires deep expertise in database engineering, cloud infrastructure, Infrastructure as Code (IaC), automation, disaster recovery planning, and enterprise‑scale database migrations.

Qualifications – Required

• 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 – Preferred

• Master’s Degree in Computer Science, Engineering, or related field.
• AWS Certified Database Specialty.
• AWS Solutions Architect Professional.
• Microsoft 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.

Essential Functions and Responsibilities

• Design, 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 services.
• Develop cloud migration strategies using replication‑based migration methodologies with minimal downtime.
• Optimize cloud database performance, resiliency, and cost efficiency.
• Design, implement, and maintain enterprise HA/DR solutions (e.g., Db2 HADR, Pacemaker, Q Replication, SQL Server Always On, Distributed Availability Groups, FCI, Log Shipping, Transactional Replication, AWS RDS Multi‑AZ, Cross‑Region, Pilot Light, Warm Standby).
• Define and validate RTO and RPO objectives, and lead disaster recovery testing and failover exercises.
• Develop Infrastructure as Code solutions using Terraform to automate provisioning, configuration, patching, monitoring, backup validation, and recovery.
• 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 PCI‑DSS, FFIEC, SOC, and NIST compliance.
• 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 administrators.
• Lead architecture reviews, technology evaluations, and modernization initiatives; act as escalation point for complex incidents and projects.
• Communicate technical strategies and recommendations to executive leadership and governance committees.

Physical Demands and Work Environment

Work is generally sedentary in nature. The working environment is generally favorable. Lighting and temperature are adequate, and there are no hazardous or unpleasant conditions caused by noise, dust, etc. Work is generally performed within an office environment, with standard office equipment available. Employees in this position will report to the office 3 days per week. On‑site work requirements may change at any time.

Success Factors / Job Competencies

• Database Engineering
• Cloud Architecture
• High Availability & Disaster Recovery
• Infrastructure as Code
• DevOps & Automation
• Security & Compliance
• Performance Engineering
• Technical Leadership
• Enterprise Architecture
• Business Continuity Planning