ZipRecruiter

Log In

1

Sql Server Performance Tuning Expert Jobs in Connecticut

TecTammina

Ab Initio Developer

Hartford, CT · On-site

... Performance tuning on any RDBMS (SQL Server, Oracle, DB2 etc.) Good awareness of Enterprise Data Warehousing (EDW), Analytics, Enterprise Dashboard, Key performance Indicators (KPIs), Data Quality ...

TecTammina

Ab Initio Lead Administrator

Hartford, CT

... Performance tuning on any RDBMS (SQL Server, Oracle, DB2 etc.) Good awareness of Enterprise Data Warehousing (EDW), Analytics, Enterprise Dashboard, Key performance Indicators (KPIs), Data Quality ...

TecTammina

Hadoop Architect

Hartford, CT

Strong knowledge of Dimension Modeling Extensive experience in architecting ETL / OLAP solutions Strong knowledge of Performance tuning on any RDBMS (SQL Server, Oracle, DB2 etc.) Good awareness of ...

Prospect Infosystem Inc

developer (azure sql)

Hartford, CT · On-site

$55.50 - $68.75/hr

Work with Azure SQL databases to design schema, implement stored procedures, and optimize performance. Collaborate with data engineers on SSIS-based ETL processes and data migration activities.

Prospect Infosys Inc

developer (azure sql)

Hartford, CT · On-site

$55.50 - $68.75/hr

Work with Azure SQL databases to design schema, implement stored procedures, and optimize performance. Collaborate with data engineers on SSIS-based ETL processes and data migration activities.

ACI Infotech

Sybase PowerBuilder

Hartford, CT · On-site

Experience in IBM DB2 relational database environments in support of two-tier client server ... Design, development and performance tuning of relational database query scripts (SQL) as well as ...

E*Pro, Inc.

Sharepoint Developer/Architect

Windsor, CT

$48.75 - $63.75/hr

SQL Server programming and performance tuning. Hands-on experience reverse engineering, writing, and enhancing stored procedures. * Prior project experience of migrating from an existing platform to ...

Sarian, Inc.

Sr Data Engineer

Hartford, CT · On-site

$115K - $138K/yr

Strong expertise in Oracle SQL & PL/SQL (writing complex queries, stored procedures, triggers, performance tuning). * Hands-on experience with Snowflake (data modeling, query optimization, SnowSQL)

previous pagenext page

Showing results 21-40

All JobsSql Server Performance Tuning Expert JobsSql Server Performance Tuning Expert Jobs in Connecticut

Sql Server Performance Tuning Expert information

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 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 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 Connecticut? For Sql Server Performance Tuning Expert jobs in Connecticut, the most frequently searched job titles are:
What job categories do people searching Sql Server Performance Tuning Expert jobs in Connecticut look for? The top searched job categories for Sql Server Performance Tuning Expert jobs in Connecticut are:
What cities in Connecticut are hiring for Sql Server Performance Tuning Expert jobs? Cities in Connecticut with the most Sql Server Performance Tuning Expert job openings:
Sql Server Performance Tuning Expert jobs near you

Dir Info Tech & Info Sec

Coordinated Transportation Solutions

Trumbull, CT

$135K - $150K/yr

Full-time

Posted 28 days ago

Coordinated Transportation Solutions rating

8.4

Company rating: 8.4 out of 10

Based on 7 frontline employees who took The Breakroom Quiz

22nd of 97 rated public transport

Job description

Required Skills:

  • Strong understanding of Structured Query Language (SQL) and Database Security Practices.
  • Proficiency in SQL database language and knowledge of database management systems (DBMS), i.e., MY SQL or SQL Server.
  • Proficiency in SQL database design, modeling and performance tuning.
    • Manages the vendor relationship and provides support for the organization’s brokerage software. Including working directly with the SQL Server backend when necessary.
    • Manages Information Security; the development of security policies and procedures and security compliance, manages Annual Risk Assessments/Vulnerability Scans and remediation efforts.
    • Responsible for all infrastructure components including but not limited to servers, storage, databases, telecommunications, and networks.
    • Consults and assists other teams on enterprise projects and delivery of services.
    • Evaluate and Manage external IT vendors under contract with CTS
    • Identifies new technology solutions and work closely with internal business partners to forecast future needs and develop cost effective strategies aligned with business objectives.
    • Supervise and mentor technology team regarding best practices, design principles and innovative thinking for respective areas (i.e., helpdesk, systems and network and security).
    • Review and update a work-plan for the department annually.
    • Develops and maintains relationships with technology vendors and service providers to meet business needs.
    • Project Planning and budget responsibility for all IT Infrastructure projects.
    • Performs vendor product evaluations and creates Proof of Concepts.
    • Provides critical thinking, strategic thinking, and roadmaps.
    • Reviews and updates a department budget annually.
    • Responsible for validating external requirements and ensuring regulatory compliance such as HIPAA and NIST CSF.
    • Manages projects as assigned to include PC Replacement Program, software compliance, software distribution, infrastructure upgrade projects and review of technology standards to meet CTS requirements.
    • Leads team responsible for management and administration of the IT infrastructure.
    • Defines and implements security best practices for developing and maintaining availability, integrity and confidentiality of the data developed, stored, and accessed for the company and on the network.
    • Assists Business Development with the IT components of business proposals.
    • Responsible for disaster recovery and business continuity/resumption planning and testing. Assess, mitigate, and manage risk associated with IT Program.
    • Is named as CTS’ Privacy and Security Officer.
    • Represents CTS at meetings.

    • Education and/or Experience:

      Bachelor’s degree (B.S.) from four-year college or university; concentration in Information Technology and 8-12 years of experience including 7 years managerial experience. Healthcare Administration, HIPAA and PHI preferred. CISSP certification preferred
  • Salary $135K-150K

    • CTS offers a competitive, performance based, salary and fringe benefits program. CTS is an equal opportunity employer regardless of race, color, religion, creed, sex, marital status, national origin, disability, age, veteran status, on-the-job injury, sexual orientation, political affiliation or belief. Employment decisions are made without consideration of these or any other factors that employers are prohibited by law from considering.

What Coordinated Transportation Solutions employees say

Pay

Benefits

Hours and flexibility

Workplace

Get the full story on Breakroom