Database Administrator - Day 1 Onsite - Need local to TX - F2F interview

  • Dallas, TX
  • Posted 4 days ago | Updated 1 day ago

Overview

On Site
Depends on Experience
Contract - W2
Contract - 6 Month(s)

Skills

Python
Design
Migration
NoSQL
RDS
SQL
ETL
MongoDB

Job Details

Hi,
We are Photon, one of the world's largest Digital Platform Engineering company providing a combination of Strategy Consulting, Creative Design and Technology Services to a wide range of customers.
We work with 40% of the Fortune 100 companies. And, we have a repertoire of niche products and experiences that we have designed and built for businesses to fully empower their digital transformation.
Check out our video at
Job Description:
Database Administrator
Dallas TX
Financial Client
F2F Client Interview
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, Google Cloud Platform).
    • 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.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.