The Senior/Lead Database Developer will play a critical role in the design,
development, and maintenance of our database systems. The ideal candidate will have over 8
years of experience with SQL Server, ETL processes, API development, and a solid
understanding of MongoDB and AWS. This role requires a detail-oriented professional with a
passion for database technologies and a drive for excellence.
WHAT YOU'LL BE DOING:
- Design, develop, and maintain robust SQL Server databases to support various applications.
- Develop and implement ETL processes to ensure efficient data integration and transformation.
- Develop ETL job to sync production data to Data warehouse for near real time reporting using Talend Open Studio for Big Data.
- Design and develop APIs for seamless data exchange between systems.
- Manage and optimize database performance, ensuring data integrity and security.
- Collaborate with cross-functional teams to gather requirements and deliver database solutions that meet business needs.
- Provide technical expertise in MongoDB and contribute to NoSQL database solutions as required.
- Utilize AWS services to support database infrastructure and cloud-based solutions.
- Perform database troubleshooting, debugging, and optimization.
- Stay updated with the latest industry trends and best practices in database development.
WHAT WE EXPECT YOU TO HAVE:
- Bachelor's degree in computer science, Information Technology, or a related field.
- 8+ years of hands-on experience with SQL Server, including database design, development, and performance tuning.
- Strong experience with ETL tools-Talend Open Studio and processes.
- Proficient in API development and integration.
- Good knowledge of MongoDB and experience with NoSQL databases.
- Experience with AWS services and cloud infrastructure.
- Strong problem-solving skills and attention to detail.
- Excellent communication and teamwork skills.
- Ability to work in a fast-paced environment and manage multiple priorities.
Preferred Skills:
- Experience with data warehousing and data lakes.
- Knowledge of additional cloud platforms (e.g., Azure, Google Cloud).
- Familiarity with Agile methodologies.
- Experience in managing remote and distributed teams.
- Strong organizational skills and attention to detail.
- Must to have Contact center domain projects experience
Schedule & Shift:5:30 PM to 2:30 AM || 6:30 PM to 3:30 AM
