Database Administrator (DBA) - Modernization Lead

You will be working as a Database Administrator (DBA) - Modernization Lead with a minimum of 5 years of experience. The job location can be Mohali, Panchkula, Bangalore, Pune, Mumbai, or Gurgaon with night shifts (US Timings) on a rotational basis from 8 PM to 6 AM. The interviews are scheduled for different dates and locations. The ideal candidate should have good communication skills and an AI cleared profile. As the DBA Modernization Lead, your primary responsibility will be to lead the overhaul of the existing SQL Server database to a modern, scalable SQL, PostgreSQL, or other scalable backend on AWS. This role will involve designing and implementing the new database architecture, ensuring data integrity, optimizing performance, and supporting the development team in transitioning old business logic to the new platform. Key Responsibilities: - Lead the design and implementation of the new database architecture on AWS. - Migrate data from SQL Server to SQL or PostgreSQL. - Optimize database performance and ensure data integrity. - Collaborate with the Architect and development teams to translate old business logic into the new platform. - Implement data security measures and ensure compliance with industry standards. - Support data ingestion components and ensure efficient data processing. - Provide guidance and mentoring to junior DBAs and developers. Core Requirements: - Bachelor's degree in Computer Science, Information Technology, or a related field. - 7+ years of experience as a DBA, focusing on database design, migration, and optimization. - Expertise in SQL Server, SQL, PostgreSQL, and AWS database services. - Strong understanding of data modeling, ETL processes, and data warehousing. - Experience with Entity Framework and T-SQL. - Knowledge of database security best practices. - Excellent problem-solving skills and attention to detail. - Strong communication and collaboration skills. Skills required for this role include AWS, SQL Server, database management, PostgreSQL, ETL processes, data warehousing, and Entity Framework.,