About Codem
Codem is a technology services company specializing in eCommerce, SAP, custom applications, cloud infrastructure, DevOps, and systems integration. We work with global enterprises to build and modernize scalable platforms. We are now seeking MYSQL and MS SQL server DBA.
About the Role
Please DO NOT APPLY IF YOU ARE NOT AN IMMEDIATE JOINER
Please DO NOT APPLY IF YOU ARE AN ORACLE DBA.
Role Overview
We are seeking an experienced Database Administrator (DBA) responsible for the stability, performance, security, and scalability of our OLTP database environments . The role requires deep, hands-on expertise with MySQL and Microsoft SQL Server and proven experience managing high-availability production systems , complex upgrades, and mission-critical database migrations.
Only Apply if you are an immediate Joiner and you have more than 8 years experience.
Mandatory Technical Skills
You should have worked on MySQL DB as DBA hands on for minimum of 5 years
- MySQL (Production-grade) – MUST HAVE
- Strong experience with high availability (HA) architectures
- Expertise in database upgrades, migrations, and controlled rollouts
- Hands-on experience with Percona Cluster environments
Key Responsibilities
Database Operations & Stability
Ensure all OLTP databases remain stable, secure, and performant at all timesProactively identify, investigate, and resolve performance bottlenecks to minimize business impactMaintain and optimize routine administrative tasks including :Index maintenanceStatistics updatesCapacity planningStorage and partition managementPerformance Optimization
Identify high-resource-consuming queries and collaborate with application teams to improve efficiencyPerform query tuning, indexing strategies, and execution plan analysisBuild monitoring dashboards to detect performance gaps and enable faster incident triageBackup, Recovery & Replication
Design, implement, and maintain :Backup and restore strategiesReplication and log shipping mechanismsEnsure data availability and disaster recovery readiness across environmentsConduct periodic recovery testing and validationHigh Availability & Migrations (Critical)
Design, implement, and manage high availability database systemsExecute controlled upgrades with :Rollout plansDowntime mitigation strategiesRollback proceduresPerform version migrations with detailed risk assessment and impact analysisHands-on creation and management of :MySQL clusters and de-clustersMS SQL Server clustersSecurity & Access Control
Manage database security in alignment with IT and security policiesImplement and maintain :Roles and permissionsAccess controlsAudit and compliance requirementsData & Stakeholder Collaboration
Work end-to-end with stakeholders to align on data requirementsEnsure timely and accurate delivery of required datasetsBuild workflows that support reporting, analytics, and operational needsRequired Experience & Knowledge
Strong hands-on experience with :MySQLMicrosoft SQL ServerProven expertise in :Performance tuning and optimizationIndexing strategies and execution plan analysisBackup, restore, and replication setupsSolid understanding of :Database security principles (roles, permissions, access controls)Storage, partitioning, and log shipping use casesGood to Have
Experience with cloud-managed database servicesExposure to observability and monitoring platformsExperience supporting large-scale eCommerce or transactional systemsFamiliarity with CI / CD-driven database change managementWhat Makes This Role Critical
Ownership of production-critical databasesDirect involvement in major platform upgradesHigh visibility across engineering and business teamsOpportunity to define and mature database reliability practicesExplicit Deal BreakerCandidates must have proven, hands-on experience with MySQL production upgrades and Percona Cluster environments .
What We Offer
Competitive salary and benefits packageFlexible work hours and remote work optionsCollaborative, inclusive team culture