Note:
Location: Pittsburgh, PA(Hybrid)
C2C: Yes
Duration: 6+ Months
Primary Skills: SQL Server
Visa: H4EAD, green card or citizens preferred

Required Qualifications:
10+ years of experience as a SQL Server DBA
5+ years experience with SQL Server HADR technologies like Always On, Replication, and/or Clustering, SQL Server Linking.
2 + years of experience with Azure Cloud specially with setup of SQL Server VM with resiliency and High Availability setup, disk/network options and limitations
Familiarity with SSIS, SSRS, SSAS, data management tools e.g. IBM VDP

Responsibilities
This senior role requires expertise in database administration and the ability to work in a fast-paced collaborative environment. We provide support for on-premises and cloud databases (IaaS and DBaaS) including critical Tier 1 and Tier 2 systems that utilize high availability solutions with replication.
This resource will support the design, implementation, and maintenance of database environments.
You will ensure integrity and high availability of the database environments in your charge. Responsibilities include but are not limited to build/management of on-prem VM and as-a-service cloud implementations, monitoring/alerting setup and admin, application consulting, performance tuning, version upgrades, automations, architecture, access methods and reviews, backup/recovery, vendor coordination/ticketing, and team mentoring and knowledge sharing.
As part of the DBA team you will collaborate with peer DBAs, project teams, application contacts to support and maintain current implementations as well as new builds/requirements. The role will assist in assuring that the Database implementations are secure, compliant, and adhere to minimum security requirements as set.
You will use your knowledge and experience in the Database space to support application requirements and make recommendations for improving existing and future processes. You will aid in reviewing new enhancements, features, products for future use and planning.

Common Required Qualifications:
10 years of combined experience in Database Administration / Engineering
Advanced knowledge of performance tuning, monitoring/alerting, observability, dashboarding
Advanced knowledge of process/query analysis, buffer tuning, client/server connectivity and database consistency checks
Advanced knowledge of maintenance routines, upgrades, patching
Experience in handling physical/logical backups & restores and data refreshes.
Experience in Linux/Unix shell commands or Windows PowerShell or Python
Experience in OS fine tuning with regards to Network I/O, Disk
Should be able to collaborate with DBA peers and mentor, work well in a team and independently
Should be able to multi-task i.e. parallelize multiple environment build / data migration
Should be able to work off-hours for application release support, Linux patching support, maintenance windows
Experienced with security and data compliance aspects of database
Well versed with latest version of database

Preferred qualifications
Experience with automation via Ansible, Terraform
Experience with deployments (CI/CD) with GHA, GitHub, Jenkins