Data Administrator (DBA) - Domain Services & Cloud Migration

Client: TFS

Job Title: Data Administrator (DBA) - Domain Services & Cloud Migration

Location: Plano TX

Responsibilities:

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.