SQL Database Administrator

Location: Onsite Pittsburgh PA

• Manage and maintain SQL Server databases, ensuring optimal performance, security, and availability
• Lead efforts in database tuning, backup strategies, and disaster recovery planning
• Collaborate with application teams to integrate databases with various business applications
• Troubleshoot and resolve database-related issues in a timely manner
• Perform database migrations, upgrades, and patch management
• Monitor database performance and provide recommendations for continuous improvement
• Develop and maintain documentation for database architecture and processes
• Some design and implementation of APIs for seamless communication between systems
• Some application development and support

Experience 

• Proficiency in creating, maintaining, and optimizing databases
• Strong experience in writing and debugging complex SQL queries, stored procedures, functions, and triggers
• Experience implementing backup strategies and performing database restores
• Knowledge of roles, permissions, encryption, and implementing SQL Server security best practices
• Experience with query optimization, index maintenance, execution plans, and troubleshooting bottlenecks
• Experience in database schema design, normalization, and partitioning.
• Experience with SQL Server clustering, replication, log shipping, and Always On Availability Groups
• Ability to create, deploy, and troubleshoot ETL packages for data imports/exports. (SSIS: SQL Server Integration Services)
• Ability to build and deploy reports as needed. (SSRS: SQL Server Reporting Services)
• Proficient in developing, testing, and deploying C# applications using .NET/.NET Core