Database Administrator (DBA) – Domain Services & Cloud Migration - Plano, TX

Photon Career Site

138d • $44,000 - $154,000

About The Position

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.

Requirements

• 10+ years of experience.
• Proven experience in database design, administration, and migration projects.
• Strong knowledge of relational and NoSQL databases (e.g., PostgreSQL, MySQL, MongoDB).
• 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.

Nice To Haves

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

Responsibilities

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

Benefits

• Medical, vision, and dental benefits
• 401k retirement plan
• Variable pay/incentives
• Paid time off
• Paid holidays

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Number of Employees: 5,001-10,000 employees