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 New York, NY Full Time
Job Description Job Description Job Title : Payment Auditor Analyst Location : NYC Job Type : Full-Time Contract W2 Job ...
Princeton IT Services, Inc
Hired Organization Address Brooklyn, NY Full Time
Job Title: QA Test Lead Location: Brooklyn, NY Job Type: Contact Job Description We are seeking an experienced QA Test L...
Princeton IT Services, Inc
Hired Organization Address Princeton, NJ Full Time
Job Title : AV (Audio / Visual) Technician Location : Princeton NJ Position Type : Fulltime Role Summary : We are seekin...
Princeton IT Services, Inc
Hired Organization Address Princeton, NJ Full Time
Job Title: Windows Administrator Location: Princeton, NJ (Onsite) Job Type: Full-Time Experience: 3–5 Years Job Descript...

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 Developer

Nesco Resource, Trenton, NJ

SQL Server Database Administrator

Sunrise Systems, Trenton, NJ

AI Assistant is available now!

Feel free to start your new journey!