Senior MS SQL Developer
Location: Princeton NJ
Job Type: Full-Time
Experience Required: 10+ Years
Industry: Preferably Insurance/Reinsurance
Job Summary:
We are seeking an experienced Senior MS SQL Developer with over 10 years of hands-on experience in MS SQL Server, including complex system design. The ideal candidate will have a strong background in database architecture, performance tuning, and advanced query optimization. Additional skills in SSRS (SQL Server Reporting Services), Data Warehousing (DWH), and Data Mart development are highly desirable. Preference will be given to candidates with domain knowledge in the insurance or reinsurance industry.
Key Responsibilities:
· Database Design and Development:
· Lead the design, development, and maintenance of complex MS SQL Server databases.
· Architect and optimize database systems to ensure maximum performance, reliability, and scalability.
· Implement and oversee database security measures, ensuring compliance with industry standards and best practices.
· Performance Tuning and Optimization:
· Analyze and fine-tune SQL queries, indexes, and database structures for optimal performance.
· Conduct regular database performance reviews and proactively identify areas for improvement.
· Data Integration and Management:
· Design and implement ETL (Extract, Transform, Load) processes for data integration across multiple systems.
· Develop and maintain Data Warehouses and Data Marts to support business intelligence and reporting needs.
· Reporting and Analysis:
· Develop and maintain SSRS reports to meet business requirements.
· Collaborate with business analysts and stakeholders to design and implement reporting solutions that drive informed decision-making.
· Domain Expertise:
· Leverage your knowledge of the insurance/reinsurance industry to design and implement database solutions that meet the specific needs of this domain.
· Understand and model complex business processes and data flows related to insurance and reinsurance operations.
· Collaboration and Leadership:
· Work closely with cross-functional teams, including application developers, data analysts, and IT administrators, to deliver integrated solutions.
· Provide technical guidance and mentorship to junior developers, fostering a culture of continuous learning and improvement.
· Serve as a team player, contributing positively to the team’s dynamics and success.
· Display strong communication skills, effectively conveying technical concepts to both technical and non-technical stakeholders.
Qualifications:
· 10+ years of experience as an MS SQL Developer, with a proven track record in complex system design and database architecture.
· Strong expertise in MS SQL Server, including advanced query optimization, indexing strategies, and performance tuning.
· Hands-on experience with SSRS, Data Warehousing, and Data Mart development is highly desirable.
· Domain knowledge in the insurance or reinsurance industry is preferred.
· Proficiency in ETL tools and processes.
· Strong problem-solving skills, with the ability to troubleshoot and resolve complex database issues.
· Excellent communication skills, both verbal and written, with the ability to interact effectively with all levels of the organization.
· Demonstrated ability to work collaboratively as part of a team and contribute to a positive team environment.
· Bachelor’s degree in computer science, Information Technology, or a related field.
Preferred Skills:
· Experience with other BI tools and technologies.
· Familiarity with cloud-based database solutions (e.g., Azure SQL, AWS RDS).
· Knowledge of other database platforms like MySQL, Oracle, or NoSQL databases.
· Experience in Agile/Scrum development environments.
Why Join Us?
Work with a dynamic team of professionals in a collaborative and innovative environment.
Opportunity to work on challenging projects within the insurance/reinsurance domain.
Competitive salary and benefits package.
How to Apply:
Interested candidates are invited to submit their resume and a cover letter outlining their relevant experience and qualifications to [email/contact information].
Additional Key Responsibilities:
· Design, develop, and maintain SQL Server databases for our web-based applications.
· Optimize database performance, including indexing, query optimization, and storage management.
· Develop and implement database solutions to support application development and business needs.
· Collaborate with software developers, business analysts, and other stakeholders to gather requirements and ensure database solutions meet business objectives.
· Perform data modeling, schema design, and database architecture planning.
· Ensure data integrity, security, and compliance with industry standards and regulations.
· Troubleshoot and resolve database-related issues and provide technical support.
· Create and maintain documentation for database processes, procedures, and standards.
· Mentor and provide guidance to junior developers as needed.
Additional Qualifications:
· Excellent problem-solving skills and attention to detail.
· Strong communication and collaboration skills.