Job Summary
In addition to the responsibilities listed below, this position is responsible for planning, designing, and building database systems that are stable, recoverable, and integrated with other available technology stacks for the purpose of efficient, secure data utilization. This includes understanding the interoperability between databases and other dependent technology stacks (performance scalability, stability, capacity planning, etc.), possessing familiarity with one dependent technology stack (e.g. windows admin, networking, storage, etc.), working with engineering teams to recommend alternate solutions, and consulting as a 2nd level technical expert on specific platforms. Act as senior technical lead with deep hands-on expertise across database engineering, operations, security, automation, and customer engagement. Some of the unique challenges this position will face include database considerations for a large, corporate enterprise and a high degree of complexity and non-uniformity.
Key Responsibilities
Design, build, and maintain PostgreSQL, MySQL, MongoDB, and Azure Cosmos DB environments. Install, configure, upgrade, patch, and lifecycle-manage database platforms. Implement and manage high availability, clustering, and replication solutions. Develop and maintain backup, recovery, and disaster recovery strategies. Perform database performance tuning and query optimization. Lead database migrations, upgrades, and modernization initiatives. Manage Azure Cosmos DB scalability, partitioning, and global distribution. Administer MongoDB replica sets, sharding, and cluster operations. Manage PostgreSQL replication, failover, and enterprise database environments. Administer MySQL clustering, replication, and performance optimization. Implement database security controls, encryption, and access management. Address vulnerabilities and ensure compliance with security standards and regulations. Automate database administration and deployment processes using scripting and DevOps tools. Lead incident response, troubleshooting, and root cause analysis activities. Perform capacity planning, forecasting, and growth management. Execute database provisioning, refreshes, cloning, and data migration activities. Manage change requests, incidents, service requests, and problem management activities. Serve as the primary database subject matter expert for application and engineering teams. Develop and maintain operational procedures, standards, and technical documentation. Mentor junior DBAs, review technical solutions, and drive operational excellence and continuous improvement.
Skill Requirements
Bachelor\'s degree in Computer Science, CIS, or related field and Minimum six (6) years experience in an IT operations environment with technical experience in distributed technologies, systems development, and/or networking. Minimum 5 years of hands-on PostgreSQL administration experience. Minimum 3 years of hands-on MySQL administration experience. Minimum 3 years of hands-on MongoDB administration experience. Experience installing, configuring, upgrading, and patching enterprise database platforms. Strong knowledge of database backup, recovery, and disaster recovery processes. Experience with database high availability, replication, clustering, and failover solutions. Strong SQL and database performance tuning skills. Experience supporting mission-critical production databases in 24x7 environments. Knowledge of Linux operating systems and shell scripting. Additional Requirements: Experience with database security, access controls, encryption, and compliance requirements.
Other Requirements
Experience supporting healthcare, financial, or other highly regulated environments. Experience with CI/CD and database deployment automation. Knowledge of Kubernetes, containers, and cloud-native database architectures. Experience with monitoring and observability tools. Azure certification and/or PostgreSQL, MongoDB, or MySQL certifications. Experience with large-scale enterprise database migrations and cloud transformations. Minimum 2 years of Azure Cosmos DB administration experience.