Join AIS Info and leverage your expertise to design, develop, and optimize mission-critical database solutions! About AIS Info AIS Info is a leading technology and professional services company headquartered in Gurgaon, India. We help clients across various industries, including banking, finance, insurance, and telecommunications, streamline operations, enhance efficiency, and make data-driven decisions. Our focus is on building strategic partnerships and providing high-skilled talent to automate tasks and mitigate risks, allowing our clients to focus on core business growth. The Role We're seeking a seasoned Senior MS SQL Developer to join our growing team and play a vital role in our data management initiatives. You'll be responsible for designing, developing, and optimizing database solutions using MS SQL Server, ensuring data integrity, security, and performance. Responsibilities Database Development & Design : Design and develop complex database structures using MS SQL Server, adhering to best practices for data normalization and optimization. Collaborate with cross-functional teams to understand business requirements and translate them into robust database models. Implement stored procedures, functions, and triggers to enhance database functionality and automation. ETL Processes & Data Integration Develop and manage efficient ETL (Extract, Transform, Load) processes to seamlessly integrate data from various sources. Cleanse, transform, and validate data to ensure accuracy and consistency before loading it into the database. Maintain and optimize existing ETL workflows for optimal performance. Data Management & Analytics Perform complex data analysis tasks using SQL queries and reporting tools to generate valuable insights for stakeholders. Apply your analytical skills to identify data quality issues and implement solutions for data cleansing and improvement. Work closely with business analysts and other teams to translate data insights into actionable business strategies. Database Administration & Performance Optimization Implement best practices for database security, access control, and user management. Monitor database performance and troubleshoot any issues to ensure optimal system efficiency and responsiveness. Identify opportunities for database optimization and implement strategies to improve performance and scalability. Technical Skills & Qualifications 5+ years of experience as a Senior MS SQL Developer or a similar role. In-depth knowledge of MS SQL Server, including T-SQL, stored procedures, functions, and triggers. Solid understanding of database design principles, normalization techniques, and data modeling concepts. Experience with ETL processes and data integration tools (i.e., SSIS). Strong analytical and problem-solving skills with the ability to write complex SQL queries. Proficiency in data cleansing and manipulation techniques. Excellent communication and collaboration skills to work effectively with cross-functional teams. Bachelor's degree in Computer Science, Information Technology, or a related field (preferred). Microsoft SQL Server certifications (MCSA, MCDBA) are a strong plus (ref:hirist.tech),
Employement Category:
Employement Type: Full time Industry: IT Services & Consulting Role Category: Not Specified Functional Area: Not Specified Role/Responsibilies: Senior SQL Server Developer - Database Design