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