Overview
Hybrid
Depends on Experience
Full Time
Skills
DBA
SQL
SSIS
SSRS
c#
.net
Job Details
Position: SQL Database Administrator (DBA) Location: Pittsburgh PA (3 day Hybrid) Duration: Full-Time
Job Description:
We are seeking an experienced SQL Database Administrator (DBA) with strong expertise in APIs, SQL Server management, and application integration. This role is central to maintaining high-performing, secure, and scalable database systems while collaborating closely with application teams on integration and development projects.
Key Responsibilities
- Administer and maintain SQL Server databases to ensure high performance, availability, and security.
- Implement and manage database tuning, backup strategies, and disaster recovery planning.
- Collaborate with developers and stakeholders to integrate databases with applications and services.
- Troubleshoot and resolve database-related issues efficiently.
- Perform upgrades, migrations, and patch management for database environments.
- Monitor system performance and recommend improvements.
- Document database architecture, configurations, and standard procedures.
- Contribute to API design and implementation for seamless system communication.
- Assist with application development and provide support as needed.
Required Qualifications
- Experience: Minimum 5 years as a SQL DBA with exposure to application and API development.
Technical Proficiencies
- Deep understanding of database creation, optimization, and maintenance.
- Skilled in writing/debugging complex SQL queries, stored procedures, functions, and triggers.
- Proven experience with backup/restore strategies and disaster recovery planning.
- Familiar with implementing roles, permissions, encryption, and overall database security best practices.
- Expertise in query optimization, indexing strategies, and performance tuning.
- Competent in database schema design, normalization, and partitioning.
- Experience with SQL Server clustering, replication, log shipping, and Always On Availability Groups.
- Able to develop and maintain ETL workflows using SSIS (SQL Server Integration Services).
- Capable of building and deploying reports with SSRS (SQL Server Reporting Services).
- Proficiency in developing and deploying C# applications using .NET/.NET Core.
Soft Skills
- Strong analytical and troubleshooting abilities.
- Excellent communication and team collaboration.
- High attention to detail and quality.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.