Jobs · Information Technology · Pennsylvania

Senior SQL Database Administrator

LTM · Moon, PA · 1 mo ago
On-siteInformation TechnologyFull-time

About the role

The Senior SQL Database Administrator is responsible for designing, developing, and maintaining SQL Server databases, optimizing performance, and supporting production deployments.

Responsibilities

  • Design, develop, and maintain SQL Server databases, stored procedures, functions, triggers, and queries.
  • Optimize database performance, query execution, and scalability.
  • Maintain database health and resolve performance bottlenecks.
  • Manage backup, recovery, indexing, patching, and database security.
  • Support production deployments and troubleshoot application/database incidents.
  • Collaborate with development teams to implement database solutions based on business requirements.
  • Maintain technical documentation for database configurations and processes.
  • Ensure data integrity, security, and compliance with organizational standards.
  • Support database migration and modernization initiatives, including cloud platforms.
  • Work closely with cross-functional teams in Agile/DevOps environments.

Requirements

  • Strong hands-on experience with Microsoft SQL Server.
  • Expertise in complex SQL queries, stored procedures, views, and performance tuning.
  • Experience with SQL Server Administration, including: Backup & Recovery, Monitoring, Indexing, Security Management.
  • Strong understanding of database design and normalization.
  • Experience troubleshooting production database issues.
  • Knowledge of ETL processes and data integration concepts.
  • Familiarity with source control and deployment processes.

Preferred Skills

  • Experience with Azure SQL Database, Azure Data Factory, and Azure DevOps.
  • Exposure to cloud migration and hybrid cloud environments.
  • Experience with Power BI or reporting tools.
  • Knowledge of PowerShell scripting.
  • Familiarity with CI/CD pipelines and DevOps practices.

Must-Have Skills

  • Microsoft SQL Server
  • SQL Performance Tuning
  • Database Administration (DBA)
  • Backup & Recovery
  • Query Optimization
  • Production Support
  • Database Security
  • ETL Concepts

Benefits

  • Comprehensive Medical Plan
  • Short Term and Long-Term Disability Coverage
  • 401(k) Plan with Company match
  • Life Insurance
  • Vacation Time, Sick Leave, Paid Holidays
  • Paid Paternity and Maternity Leave

Similar jobs