1

Sql Server Performance Tuning Expert Jobs in Missouri

Manage and maintain SQL Server instances across various environments, ensuring high availability ... Monitor database performance, tuning SQL queries, and optimizing database configurations for ...

SQL DBA

Saint Louis, MO · On-site +1

$48.50 - $60.75/hr

Manage and maintain SQL Server instances across various environments, ensuring high availability ... Monitor database performance, tuning SQL queries, and optimizing database configurations for ...

Design, build and test applications Conduct root cause analysis and advanced performance tuning for ... SQL Informatica (SSIS) or similar ETL tools Teradata or other relational database systems (RDBMS ...

Minimum 10+ work experience and 5-7+ years of experience with SQL Server 2008/2012/2014/2016 T-SQL coding. * Experience with index design and T-SQL performance tuning techniques * Experience with ...

SQL DBA (XIN001_JDGH)

Columbia, MO

$47.50 - $59.50/hr

Participate with SQL Team in monitoring server performance, utilize monitoring tools, SQL Profiler, Extended Events, Performance Monitor and Configuration Monitor Knowledge and experience with ...

Design and develop user-facing applications using Angular and SQL Server . * Collaborate with ... Knowledge of performance tuning and optimization techniques. * Familiarity with Agile methodologies.

Strong grasp of performance tuning - execution plans, index strategy, wait statistics * Solid understanding of SQL Server security, auditing, and access control * Experience with backup/restore, DR ...

Strong SQL/PLSQL, stored procedure debugging, performance tuning. * Experience with Oracle/SQL Server. * Knowledge of data replication, batch processing, and high availability setups. * Good ...

next page

Showing results 1-20

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

SQL Engineer

The Timberline Group

Saint Louis, MO • On-site, Remote

Full-time

Re-posted 11 days ago


Job description

Skills needed:
  • Database Schemas
  • Understanding of SQL Agent Jobs
  • Data Migration experience
  • PowerShell and/or T-SQL Scripting knowledge
  • Data Conversion experience
  • SQL and Stored Procedure tuning experience
SQL Engineer
Must have: TSQL, SQL scripting and Data migration
  • Manage and maintain SQL Server instances across various environments, ensuring high availability, security, and performance.
  • Implement and support geoclustering solutions to achieve disaster recovery and business continuity objectives.
  • Monitor database performance, tuning SQL queries, and optimizing database configurations for improved efficiency.
  • Develop and implement automation scripts using PowerShell, Python, or similar tools to automate routine DBA tasks, deployment processes, and monitoring.
  • Handle table locks and concurrency issues effectively, ensuring minimal impact on production environments.
  • Plan and execute database migrations and upgrades, including transitioning on-premises databases to Azure cloud services.
  • Implement and manage SQL Server AlwaysOn Availability Groups for high availability and disaster recovery.
  • Utilize performance monitoring tools such as SQL Server Management Studio (SSMS), Azure Monitor, or third-party tools to proactively monitor and analyze database performance.
  • Collaborate with cross-functional teams to troubleshoot database-related issues and implement solutions promptly.
  • Develop and maintain documentation related to database configurations, processes, automation scripts, and procedures.
  • Implement and enforce database security best practices, ensuring compliance with organizational standards and regulations.
  • Participate in on-call rotations and respond to database incidents in a timely manner.

Qualifications
  • Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent experience).
  • Proven experience as a SQL Server DBA in a large-scale production environment, with a strong emphasis on operational tasks.
  • In-depth knowledge of SQL Server internals, including geoclustering, table locks, and concurrency management.
  • Experience in designing and implementing database backup and recovery strategies.
  • Proficiency in performance tuning, query optimization, and index management.
  • Hands-on experience with database migration tools and methodologies, particularly to Azure SQL Database or Azure SQL Managed Instance.
  • Strong scripting skills with PowerShell, Python, or similar languages for automation of DBA tasks and deployments.
  • Experience with performance monitoring tools and techniques to identify and resolve database performance issues.
  • Strong understanding of database security principles and best practices.
  • Excellent troubleshooting skills and the ability to resolve database issues under pressure.
  • Effective communication skills and the ability to collaborate with diverse teams.
  • Relevant certifications (e.g., Microsoft Certified: Azure Database Administrator Associate) would be a plus.