SQL Database Administrator

Everything Computer Science, Inc.; Pittsburgh (Allegheny County); On-site; USD 80,000 - 120,000; Full time

Job summary

A leading technology firm seeks an experienced SQL Database Administrator (DBA) to enhance their database performance and security. Candidates should have a minimum of 5 years of relevant experience with expertise in MS SQL Server, T-SQL coding, and the ability to design APIs and troubleshoot database issues. The role demands strong analytical skills and experience using tools like PowerBI and SSRS.

Qualifications

• Minimum of 5 years of experience as a SQL DBA.
• Strong understanding of database structures.
• Expertise in MS SQL Server, particularly upgrades.

Responsibilities

• Manage and optimize SQL Server databases for performance, security, and availability.
• Diagnose and resolve locking and resource issues.
• Perform database migrations and upgrades.

Skills

SQL

Database Management

Query Optimization

API Development

ETL Processes

PowerBI

Tableau

Tools

SSRS

SSIS

.NET

PowerBI

Tableau

Job description

Skills and Experience:

• Expertise in MS SQL Server, with experience upgrading from 2012 to 2022.
• Proficient in diagnosing and resolving locking and resource issues; SSRS experience is a plus.
• Strong understanding of database structures to handle business requests efficiently.
• Ability to analyze data and present insights via PowerBI, Tableau, or similar platforms.
• Minimum of 5 years of experience as a SQL DBA, with knowledge of application and API development.
• Balanced experience in SQL infrastructure and T-SQL coding for Microsoft SQL Server.

Technical Skills:

• Proficiency in writing and debugging complex SQL queries, stored procedures, functions, and triggers.
• Experience implementing backup strategies and performing database restores.
• Manage and optimize SQL Server databases for performance, security, and availability.
• Perform database migrations, upgrades, and patch management.
• Design and implement APIs for system communication.
• Query optimization, index maintenance, and troubleshooting.
• Experience with clustering, replication, log shipping, and Always On Availability Groups.
• Develop and troubleshoot ETL packages using SSIS.
• Create, deploy, and troubleshoot reports with SSRS.
• Develop, test, and deploy C# applications with .NET/.NET Core.

Note: This description appears to be generated or reviewed with AI assistance. The job posting details are accurate and reflect the opportunity.

Employer Details:

• Dice ID: 91140503
• Position ID: 8653631

About Accroid Inc

Accroid Inc is a nationwide employment and service provider committed to empowering individuals. We prioritize doing what is right, fostering an inclusive culture, and building strong relationships. Our mission is to help businesses unlock their potential through technology and expertise, delivering measurable results. Connect with us on LinkedIn for insights, updates, and opportunities.