Key Responsibilities:
Design and define the To-Be database architecture for the application migration project, ensuring high performance, scalability, and security.
Conduct assessment of the current database environment and provide recommendations for improvements and optimizations.
Develop and implement data migration strategies, ensuring minimal downtime and data integrity.
Collaborate with application development teams to design and optimize database schemas, queries, indexing, and partitioning strategies.
Establish database best practices, standards, and guidelines for the new architecture.
Work with onshore and offshore teams to coordinate database-related activities, ensuring smooth execution of migration plans.
Ensure database security, backup, and recovery strategies are in place to mitigate risks.
Conduct performance tuning and troubleshooting to resolve database issues and optimize query execution.
Provide technical guidance and mentorship to database administrators and developers.
Stay updated with the latest MySQL trends, technologies, and best practices.
Required Skills & Qualifications:
8+ years of experience in database architecture, design, and administration, with a focus on MySQL.
Strong expertise in MySQL database design, replication, partitioning, and performance tuning.
Experience in large-scale application migration projects involving MySQL databases.
Hands-on experience with database optimization techniques, query tuning, and indexing strategies.
Strong understanding of database security, backup, and recovery strategies.
Experience working in an onshore-offshore delivery model.
Proficiency in database scripting, stored procedures, and automation.
Excellent communication and collaboration skills to work effectively across global teams.
Preferred Qualifications:
Certification in MySQL Database Administration or Architecture.
Experience with NoSQL databases and hybrid database solutions.
Familiarity with DevOps practices, CI/CD pipelines, and Infrastructure as Code (IaC) for database deployment.
Knowledge of ETL tools and data migration methodologies.