Senior SQL Server DBA

Robotics Prcocess Automation, LLC; Philadelphia (Philadelphia County); On-site; USD 120,000 - 150,000; Full time

Job summary

Robotics Process Automation, LLC seeks a seasoned SQL Server DBA in Philadelphia County. The successful candidate will oversee performance tuning, database optimization, and lead core DBA functions within high-transaction environments.

The role requires 10+ years of experience with SQL Server and proficiency in tools such as SSMS and Always On. Candidates with strong analytical and problem-solving skills will excel. The company offers equal opportunity employment, prioritizing diversity and inclusion.

Qualifications

• 10+ years of hands‑on experience as a SQL Server DBA in enterprise environments.
• Proven experience in high‑transaction systems such as ecommerce, banking, or financial services.
• Strong understanding of database file structures, access methods, and performance analysis.

Responsibilities

• Lead performance tuning efforts across large-scale SQL Server environments.
• Analyze and optimize SQL queries and database configurations.
• Monitor and troubleshoot database performance.

Skills

SQL Server performance tuning

Database optimization

High‑transaction systems

Analytical skills

Communication skills

Problem-solving skills

Education

Bachelor’s degree in Computer Science or Information Systems

Tools

SSMS

SSIS

SSRS

Always On

Idera SQL Diagnostic Manager

Dynatrace

Job description

Responsibilities

• Lead performance tuning efforts across large-scale SQL Server environments with high transaction volumes.
• Analyze and optimize SQL queries, indexes, and database configurations to improve application responsiveness.
• Monitor and troubleshoot database performance using tools such as:
  • Idera SQL Diagnostic Manager
  • Query Store
  • SQL Server Profiler
  • Dynatrace
• Evaluate index statistics and fragmentation; recommend and implement improvements.
• Develop and maintain documentation of performance best practices for use by development and DBA teams.
• Manage core DBA functions including installation, upgrades, backup/recovery, and high availability (e.g., Always On Failover Clustering).
• Participate in capacity planning and performance forecasting.
• Collaborate with development teams to improve database-related application processes.
• Escalate complex issues and coordinate resolution with internal and external resources.
• Apply administration best practices in daily operations and contribute to continuous improvement efforts.
• Participation in a 24/7 Production support call rotation.
• Willingness to learn and support other Database management systems as needed (BigQuery, MySQL, PostgreSQL).

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, or related field (or equivalent experience).
• 10+ years of hands‑on experience as a SQL Server DBA in enterprise environments.
• Proven experience in high‑transaction systems such as ecommerce, banking, or financial services.
• Strong understanding of database file structures, access methods, and performance analysis.
• Advanced knowledge of SQL Server tools and technologies: SSMS, SSIS, SSRS, Always On, etc.
• Demonstrated ability to lead tuning efforts and mentor junior DBAs.
• Excellent analytical, communication, and problem‑solving skills.
• Familiarity with application/database interaction and optimization strategies.
• Industry‑recognized certifications (e.g., Microsoft Certified Database Administrator) preferred.

Additional Skills (Preferred but Not Required)

• Experience with Java in performance-sensitive applications.
• Familiarity with Python for automation or scripting tasks.
• Exposure to MuleSoft (Mule) integration platform.
• Understanding of cloud‑based SQL Server deployments (e.g., Azure SQL).
• Knowledge of DevOps practices and CI/CD pipelines involving database components.

ROBOTIC PROCESS AUTOMATION LLC is an equal opportunity employer inclusive of female, minority, disability and veterans (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. ROBOTIC PROCESS AUTOMATION LLC will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will ROBOTIC PROCESS AUTOMATION LLC require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract.