Demo

MS SQL Server Specialist

Princeton IT Services, Inc
Princeton, NJ Full Time
POSTED ON 3/23/2025
AVAILABLE BEFORE 7/20/2025
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.

If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets
View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

Job openings at Princeton IT Services, Inc

Princeton IT Services, Inc
Hired Organization Address Brooklyn, NY Full Time
Job Description Job Title: NG911 FDNY Security Engineer Location: Brooklyn, NY Duration: Long term Job type: Contract Su...
Princeton IT Services, Inc
Hired Organization Address Princeton, NJ Full Time
Job title: VMware Engineer – Server Support Location: Princeton, NJ Employment Type: Full-Time Contract Responsibilities...
Princeton IT Services, Inc
Hired Organization Address New York, NY Contractor
Job Title: Auditor III Location: NYC Job Type: Full-Time Contract W2 Job Summary The Auditor III will be responsible for...
Princeton IT Services, Inc
Hired Organization Address Princeton, NJ Full Time
Job Description: SharePoint Developer Location : Princeton, NJ Job Type : Contract W2 Job Summary We are seeking a highl...

Not the job you're looking for? Here are some other MS SQL Server Specialist jobs in the Princeton, NJ area that may be a better fit.

SQL Server Database Administrator

Sunrise Systems, Trenton, NJ

SQL Server administrator

Resource Informatics Group, Trenton, NJ

AI Assistant is available now!

Feel free to start your new journey!