Database Administrator

We are seeking a skilled and proactive Database Administrator (DBA) with 10+ years of experience to design, implement, and manage databases for domain services that serve as Systems of Record
. The role involves overseeing the migration of 20 million records from legacy systems, ensuring high availability, consistency, and scalability in a cloud-deployed distributed environment
.

Key Responsibilities

• Database Design & Architecture
  :
  Design robust, scalable, and secure databases for domain services acting as Systems of Record. Define data models, indexing strategies, and partitioning for optimal performance.
• Data Migration
  :
  Lead the migration of ~20 million records from legacy systems to new cloud-based services. Ensure data integrity, consistency, and minimal downtime during migration.
• Database Management
  :
  Maintain and monitor database performance, availability, and reliability. Implement backup, recovery, and disaster recovery strategies.
• Cloud Deployment & Management
  :
  Manage databases deployed in cloud environments (e.g., AWS, Azure, GCP). Optimize cloud resources and ensure cost-effective database operations.
• High Availability & Consistency
  :
  Implement replication, clustering, and failover mechanisms. Ensure ACID compliance and data consistency across distributed systems.
• Security & Compliance
  :
  Enforce data security policies, access controls, and compliance standards. Conduct regular audits and vulnerability assessments.

Qualifications

• 10+ years of experience
  .
• Proven experience in database design, administration, and migration projects.
• Strong knowledge of relational and No
  
  SQL databases (e.g., Postgre
  
  SQL, MySQL, Mongo
  
  DB).
• Hands-on experience with cloud platforms and database services (e.g., RDS, Cloud SQL).
• Proficiency in data migration tools and scripting (e.g., Python, SQL, ETL frameworks).
• Understanding of distributed systems, CAP theorem, and consistency models.
• Excellent problem-solving and communication skills.

Preferred

• Experience with microservices architecture and domain-driven design.
• Familiarity with Dev Ops practices and CI/CD pipelines for database deployments.
• Certifications in cloud technologies or database administration.