Associate Principal designing and maintaining database solutions for The Options Clearing Corporation. Engaging in database management, performance tuning, and supporting systems development.
About the role
- Database Administrator ensuring availability, security, integrity of MoMoPSB's database platforms that power high-volume payments. Define database strategy and execute administration to meet objectives.
Responsibilities
- Own the multi‑year database roadmap: engine selection, cloud/on‑prem posture, managed services, and standards.
- Design and govern HA/DR architectures meeting defined SLOs, RPO/RTO for Tier‑0 payment systems.
- Embed security & compliance by design (PCI DSS, CBN PSB, NDPR, ISO 27001): encryption, segregation, least privilege, logging and retention.
- Establish observability strategy (SLOs, error budgets, performance baselines, telemetry).
- Plan capacity and cost: licensing optimization, storage tiering, reservations/commitments.
- Plan/execute major upgrades and migrations with near‑zero downtime; institute schema versioning (Flyway/Liquibase) in CI/CD.
- Implement robust backup & recovery strategies including immutable/WORM copies and quarterly restore drills.
- Engineer performance: indexing, partitioning, query tuning, connection management, and workload management.
- Harden security: RBAC, PAM/MFA, key management, secrets rotation, audit and access reviews.
- Enable data integration: CDC/ETL to analytics, fraud systems, and regulatory reporting with data quality controls.
- Maintain vendor relationships and optimize licenses/support contracts.
- Provision, configure, and patch databases; manage users/roles; maintain schemas and jobs.
- Monitor availability, replication lag, locks/deadlocks, storage growth; triage and resolve incidents.
- Execute backups (full/incremental) and validate restores; maintain offsite/air‑gapped copies.
- Support releases and change management; review SQL changes and advise on best practices.
- Maintain runbooks, architecture diagrams, SOPs, and compliance evidence.
Requirements
- 3–7 years hands‑on DBA experience in high‑availability, high‑throughput environments (financial services/telco preferred).
- Track record delivering HA/DR, performance tuning, security hardening, and major version upgrades/migrations.
- Experience operating in cloud (AWS/Azure) using services such as RDS/Aurora or Azure SQL Managed Instance.
- Expertise with at least two engines: PostgreSQL, Oracle, SQL Server, MySQL; familiarity with NoSQL (MongoDB/Cassandra) a plus.
- Proficiency in SQL, PL/pgSQL, T‑SQL, PL/SQL; query optimization, indexing, partitioning.
- Replication & HA (Always On/AG, Data Guard, Streaming/Logical replication).
- Backup/Recovery (RMAN, pgBackRest, PITR, snapshot strategies).
- Security (TLS, TDE, RBAC, tokenization/masking, auditing) and key management (KMS/Key Vault).
- Observability (pg_stat_statements, AWR, Extended Events, Prometheus/Grafana, CloudWatch/Azure Monitor).
- Automation with Terraform/Ansible; scripting in Bash/Python; schema migration tools (Liquibase/Flyway).
Benefits
- Bachelor's degree in computer science, Engineering, Information Systems or related field.
- Relevant certifications are an advantage (e.g., Oracle OCP, Microsoft DP‑300/DP‑900, AWS/Azure database certifications, ITIL).
Job title
Job type
Experience level
Salary
Not specified
Degree requirement
Tech skills
Location requirements
SQL Server Database Administrator enhancing and securing database environments for PV technology. Collaborating on complex platforms and optimizing operations for high - performance and reliability.
Information Technology Manager overseeing technology ecosystem for Bernalillo County. Providing strategic leadership, aligning IT initiatives with goals, and supervising IT professionals.
Database Administrator focused on SQL Server and DevOps tasks at a sports & entertainment marketing firm. Joining a fixed - term contract team supporting mission - critical database environments.
Application Database Administrator responsible for managing databases supporting applications at Assurity Trusted Solutions. Collaborating with developers and ensuring optimal database performance in a hybrid environment.
Database Administrator managing MySQL databases supporting critical applications. Collaborating with engineering teams in a company's global ad platform environment.
Oracle Database Administrator focused on managing Oracle databases in Azure for Boeing's Engineering & Technology Center. Collaborating with teams to ensure database functionality and support cloud migration efforts.
Database Administrator providing secure SQL Server Database Services for defense and intelligence communities. Engaging in design, implementation, and modernization of database environments.
Senior Database Administrator designing secure and scalable database environments for international clients. Collaborating with diverse teams to support database infrastructure within Avenga's global operations.
Database Administrator managing production databases for critical systems at Aviture. Ensuring stability and security while aiding modernization efforts in a hybrid work environment.