1

Sql Server Performance Tuning Expert Jobs in Massachusetts

Senior SQL Server DBA Location: Boston, MA 02135 Duration: Long-Term Contract Work Schedule: 35 ... tuning, and performance monitoring. 8. Collaborate closely with application development teams ...

Sr Database Administrator - USA

Becket, MA ยท On-site +1

$54.75 - $75.50/hr

We're looking for a Senior Database Administrator who excels at performance optimization and database tuning across multiple platforms, with a strong focus on Microsoft SQL Server. This position is ...

Strong, hands on DBA experience with SQL Server, Postgres, Oracle, and TimescaleDB. * Deep proficiency in SQL, performance tuning, indexing, execution plan analysis, and workload optimization.

MA ยท On-site

Experience with SQL Server Integration Services (SSIS). * Experience with SQL Server Reporting ... Perform data analysis, validation, troubleshooting, and performance tuning of BI solutions.

next page

Showing results 1-20

Sql Server Performance Tuning Expert information

What is a SQL Server Performance Tuning Expert?

SQL Server Performance Tuning Experts are professionals who specialize in optimizing the performance of Microsoft SQL Server databases. They analyze, diagnose, and resolve performance bottlenecks by fine-tuning queries, indexes, database design, and server configurations. Their expertise helps organizations ensure fast, reliable, and scalable database operations, which is crucial for business-critical applications. These experts also advise on best practices, conduct performance audits, and implement monitoring solutions to maintain optimal database performance.

What skills and qualifications are needed to thrive as a SQL Server Performance Tuning Expert?

To thrive as a SQL Server Performance Tuning Expert, you need a deep understanding of SQL Server architecture, query optimization, indexing strategies, and database administration, typically backed by relevant experience or certifications such as Microsoft Certified: Azure Database Administrator Associate. Expertise in tools like SQL Server Management Studio (SSMS), SQL Profiler, Database Engine Tuning Advisor, and monitoring solutions is vital. Strong problem-solving skills, analytical thinking, and effective communication set top performers apart by enabling them to diagnose issues and collaborate with development teams. These skills and qualities are crucial for ensuring optimal database performance, minimizing downtime, and supporting business-critical applications.

What challenges does a SQL Server Performance Tuning Expert face when diagnosing and resolving performance bottlenecks?

A SQL Server Performance Tuning Expert often encounters challenges such as identifying inefficient queries, isolating problematic indexing strategies, and managing resource contention between concurrent workloads. They must also navigate complex environments where historical changes or legacy configurations impact current performance. Collaborating closely with developers, DBAs, and infrastructure teams is crucial to implement solutions without disrupting business operations. Staying up-to-date with the latest SQL Server features and monitoring tools helps ensure proactive, effective tuning.

What is the difference between Sql Server Performance Tuning Expert vs Database Administrator?

AspectSql Server Performance Tuning ExpertDatabase Administrator
Primary FocusOptimizing SQL Server performance and query tuningManaging and maintaining overall database systems
CertificationsSQL Server certifications, performance tuning coursesDBA certifications like Microsoft Certified: Azure Database Administrator
Work EnvironmentSpecialized in performance analysis, query optimizationBroader database management, backups, security
Industry UsageUsed in organizations needing high-performance SQL Server databasesUsed across industries for overall database health and security

While both roles work with SQL Server, the Sql Server Performance Tuning Expert specializes in enhancing database performance through query optimization and tuning. The Database Administrator manages the entire database environment, including security, backups, and maintenance. Understanding these differences helps organizations assign the right expertise for their needs.

What are popular job titles related to Sql Server Performance Tuning Expert jobs in Massachusetts?

For Sql Server Performance Tuning Expert jobs in Massachusetts, the most frequently searched job titles are:

What job categories do people searching Sql Server Performance Tuning Expert jobs in Massachusetts look for?

The top searched job categories for Sql Server Performance Tuning Expert jobs in Massachusetts are:

What cities in Massachusetts are hiring for Sql Server Performance Tuning Expert jobs?

Cities in Massachusetts with the most Sql Server Performance Tuning Expert job openings:

Senior SQL Server DBA

Inficare Technologies

Boston, MA โ€ข On-site

Full-time

Re-posted 16 days ago


Job description

Job Title: Senior SQL Server DBA
Location: Boston, MA 02135
Duration: Long-Term Contract
Work Schedule: 35 Hours per Week

Job Description
We are seeking an experienced Senior SQL Server Database Administrator (DBA) to support a critical Database Management Software Upgrades project. The ideal candidate will have extensive hands-on experience managing Microsoft SQL Server environments, performing upgrades and migrations, optimizing database performance, and implementing high-availability solutions in enterprise production environments.
Key Responsibilities
1. Install, configure, administer, and maintain Microsoft SQL Server instances.
2. Perform database upgrades, patching, migrations, and version transitions across SQL Server environments.
3. Monitor database health, availability, capacity, and overall system performance.
4. Implement, maintain, and support high-availability and disaster recovery solutions, including:
o Always On Availability Groups
o Failover Clustering
o Replication
o Log Shipping
5. Manage database security, including logins, roles, permissions, and Active Directory (AD) group integration.
6. Troubleshoot database-related issues and perform root cause analysis.
7. Optimize database performance through indexing strategies, query tuning, and performance monitoring.
8. Collaborate closely with application development teams, infrastructure teams, and system administrators to support business-critical applications.
9. Support production environments, including participation in on-call rotations as needed.
10. Develop and maintain database administration documentation, standards, and best practices.
Required Qualifications
1. Bachelor's degree in Computer Science, Information Technology, or equivalent experience.
2. Minimum 5+ years of hands-on experience as a SQL Server Database Administrator.
3. Strong experience with Microsoft SQL Server 2016, 2019, and 2022.
4. Proven expertise in SQL Server installation, configuration, patching, upgrades, and migrations.
5. Strong knowledge of:
o T-SQL
o Indexing strategies
o Query tuning
o Performance optimization
6. Experience implementing and supporting:
o Always On Availability Groups
o Failover Clustering
o Replication
o Log Shipping
7. Experience supporting mission-critical production environments with high availability requirements.
8. Strong troubleshooting and problem-solving skills.
9. Excellent communication and collaboration skills.
Preferred Qualifications
1. Experience with PowerShell scripting and SQL automation.
2. Experience with SSIS and SSRS.
3. Experience using SQL Sentry for monitoring and performance management.
4. Familiarity with enterprise infrastructure and cloud-integrated SQL environments.
Required Technical Skills
โ€ข Microsoft SQL Server (2016/2019/2022)
โ€ข SQL Server Management Studio (SSMS)
โ€ข T-SQL
โ€ข PowerShell
โ€ข SSIS
โ€ข SSRS
โ€ข Always On Availability Groups
โ€ข Failover Clustering
โ€ข Replication
โ€ข Log Shipping
โ€ข Database Performance Tuning
โ€ข Security Administration