MS SQL Server Specialist

Job Title: MS SQL Server Specialist

Location: Princeton, NJ

Employment Type: Full-time

Job Summary

We are seeking an experienced MS SQL Server Specialist with over 20 years of expertise in designing, implementing, and optimizing SQL Server databases and data warehouses. The ideal candidate will excel in query optimization, performance tuning, and managing enterprise-scale data architectures.

Key Responsibilities

• Design, implement, and maintain SQL Server databases and data warehouses.
• Optimize database performance through advanced T-SQL, indexing, partitioning, and query tuning strategies.
• Manage datasets exceeding 10TB, ensuring sub-second query response times.
• Develop and implement data archival strategies to maintain system performance and storage efficiency.
• Troubleshoot and resolve database performance and integrity issues.
• Collaborate with stakeholders to understand and implement business requirements.
• Ensure compliance with data governance and security best practices.
  
  

Required Skills And Qualifications

• Experience: Over 20 years of SQL Server database design, optimization, and management.
• Technical Skills:
• Advanced T-SQL for complex queries.
• Expertise in indexing, partitioning, and performance tuning.
• Knowledge of data archival strategies.
• Proven ability to manage and optimize large-scale data architectures (10TB datasets).
• Strong problem-solving and troubleshooting skills.
• Certification in MS SQL Server is a plus.
  

Achievements

• Successfully led the deployment of enterprise-scale data warehouses with superior performance benchmarks.
• Consistently achieved sub-second query response times for large datasets.