A.C.Coy Company
Overview
Location: Onsite Pittsburgh PA
Job Type: Full TimeWork Authorization: US Citizen / Green Card The AC Coy Company has an immediate need for an SQL Database Administrator.
Ideal candidates must have at least 5 years experience as an SQL DBA with knowledge in API Development. Responsibilities
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
Qualifications 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
Ideal candidates must have at least 5 years experience as an SQL DBA with knowledge in API Development. Responsibilities
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
Qualifications 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