Senior SQL Database Administrator Job at IntePros, Philadelphia, PA

eFBKUFFFelVaWm1tc2VwcVYwWEM3U0hQa2c9PQ==
  • IntePros
  • Philadelphia, PA

Job Description

Job Title: Senior SQL Server Database Administrator – Performance Tuning Specialist

Location: Philadelphia, PA

Schedule: 37.5-hour work week, 9–3 core hours, occasional on-call rotation

Type: Contract to hire

Position Summary

We are seeking a highly skilled Senior SQL Server DBA with deep expertise in performance tuning, query optimization, and troubleshooting. This is a demanding and high-impact role within a large enterprise environment where database performance and reliability are mission-critical. The ideal candidate will have 10+ years of experience as a SQL Server DBA and the ability to lead tuning efforts, re-write SQL queries, resolve blocking/memory issues, and mentor other team members.

This role offers the opportunity to work across SQL Server, MySQL, Azure, BigQuery, and PostgreSQL, with the flexibility to expand skills into other platforms. Candidates with both development and DBA backgrounds are encouraged to apply.

Key Responsibilities

  • Serve as the performance tuning expert across enterprise SQL Server environments.
  • Analyze and optimize SQL queries, indexes, and database configurations to improve application responsiveness.
  • Troubleshoot performance issues including blocking, deadlocks, and memory utilization.
  • Provide guidance and hands-on support to development teams for performance tuning and query re-writes.
  • Monitor and analyze database performance using tools such as Idera, Query Store, Profiler, or other comparable solutions.
  • Develop and maintain documentation, best practices, and training materials to upskill other DBAs and developers.
  • Support production environments, ensuring availability, scalability, and reliability of mission-critical databases.
  • Participate in on-call rotation for production support.
  • Automate administrative tasks through scripting languages (Python, PowerShell, etc.) or third-party tools.
  • Collaborate with infrastructure, application development, and offshore DBA teams (10+ DBAs globally).
  • Contribute to capacity planning, system upgrades, and future-proofing of database environments.

Qualifications

  • Bachelor’s degree in Computer Science, Information Systems, or related field (or equivalent experience).
  • 10+ years of experience as a SQL Server DBA in large-scale enterprise environments.
  • Proven expertise in SQL performance tuning, optimization, and troubleshooting.
  • Strong understanding of database architecture, indexing strategies, query execution plans, and transaction processing.
  • Hands-on experience with Idera Performance tools (or similar).
  • Experience with installation, upgrades, backup/recovery, and high availability (Always On, clustering, etc.).
  • Ability to lead and mentor other DBAs in performance tuning techniques.
  • Excellent problem-solving, analytical, and communication skills.

Preferred Skills

  • Exposure to MySQL, PostgreSQL, Azure SQL, and BigQuery.
  • Experience with automation via Python, PowerShell, or similar scripting tools.
  • Microsoft Certified Database Administrator or other industry certifications.
  • Background in development and DBA roles, offering a hybrid perspective.
  • Experience in high-transaction industries (e.g., finance, ecommerce, telecom).

Why Join?

  • Opportunity to step into a leadership path as the team transitions.
  • Be the go-to performance tuning expert in a high-profile enterprise environment.
  • Work with modern technologies across SQL Server, cloud platforms, and big data tools.
  • Collaborate with a strong DBA team, including offshore resources supporting global operations.

Job Tags

Contract work,

Similar Jobs

DSJ Global

Senior Director Supply Chain & Operations Technology Strategy Job at DSJ Global

 ...innovation or technology-driven programs. ~ Background in supply chain operations and emerging technologies (AI, automation, IoT, robotics). ~ Strong strategic thinking and ability to bridge technical and business needs. ~ Experience with technology governance and... 

Wisconsin Community Services

Case Manager - Waukesha OWI Job at Wisconsin Community Services

 ...Case Manager OWI - Waukesha County Position Summary: This position provides pretrial case management of individuals with pending repeat intoxicated driving charges for the Circuit Courts of Waukesha County. Essential Functions: 1.Monitor bail conditions of... 

Shrub Oak International School

Licensed Practical Nurse (LPN) Job at Shrub Oak International School

 ...Job Title: Licensed Practical Nurse (LPN) Reports to: Registered Nurse (RN) Department: Health and Wellness Compensation : $45/hour Company Overview: Shrub Oak International School () is a therapeutic day and residential school for autistic children, adolescents... 

Sara's Market & Bakery

Pastry Sous Chef Job at Sara's Market & Bakery

 ...a hands-on position for someone who balances artistry with precision and who finds joy in elevating the guest experience through food. Key Responsibilities Production & Quality Oversee daily pastry and bakery production, ensuring consistency, precision,... 

Keurig Dr Pepper Inc.

Warehouse Picker Order Selector Job at Keurig Dr Pepper Inc.

Job Overview: Warehouse Picker Order Selector- Springfield, IL About the Role Accurately pick products by matching numbers and products using voice audio headset. Hand stack cases of product weighing up to 50 pounds repetitively from floor to over-head. ...