Photon
Database Administrator (DBA) - Domain Services & Cloud Migration - Plano, TX
Photon, Dallas, Texas, United States, 75215
Job Description
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 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. Preferred:
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.
Compensation, Benefits and Duration
Minimum Compensation: USD 44,000 Maximum Compensation: USD 154,000 Compensation is based on actual experience and qualifications of the candidate. The above is a reasonable and a good faith estimate for the role. Medical, vision, and dental benefits, 401k retirement plan, variable pay/incentives, paid time off, and paid holidays are available for full time employees. This position is available for independent contractors No applications will be considered if received more than 120 days after the date of this post
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 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. Preferred:
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.
Compensation, Benefits and Duration
Minimum Compensation: USD 44,000 Maximum Compensation: USD 154,000 Compensation is based on actual experience and qualifications of the candidate. The above is a reasonable and a good faith estimate for the role. Medical, vision, and dental benefits, 401k retirement plan, variable pay/incentives, paid time off, and paid holidays are available for full time employees. This position is available for independent contractors No applications will be considered if received more than 120 days after the date of this post