Blog

Hybrid Raleigh, NC

Local to NC

Hi,

Hope you are doing good.

Please have a look on the below role and let me know if you are comfortable with it.

Role:                                  SQL DBA

Location:                          Hybrid Raleigh, NC

Duration:                          8+ months

Visa:                                  No H1B/OPT/CPT

Client:                               NC DHHS

Items Required At The Time of Submittal: 

• Onsite work will be required at the client’s discretion. Do you accept this requirement?

Job Description:
Our client is seeking an experienced SQL Server Administrator to provide support for 300+ SQL databases across 3 Data Caters and 2 Cloud Providers. Due to the growth of SQL Server usage in ITD, NC DHHS is in need of a SQL Server Administrator to provide support for over 300+ SQL Databases across 3 Data Centers and 2 Cloud Providers. This role requires 7+ years’ demonstrated experience working as a SQL Server administrator; Strong understanding of SQL database monitoring and performance tuning;

Experience in troubleshooting and resolving database problems; Experience with following:

• Backups restores and High Availability (Always on),
• Installation and configuration of SQL 2014, 2016 and 2019 Standard and Enterprise.
• Configuration of SSIS and SSRS,
• Work experience on SSIS and SSRS to create and deploys packages and Reports.
• Database upgrade, Patching & Refresh.
• SQL tuning, Data conversion / Migration, Supporting Enterprise Systems.
• Database maintenance, Database backup and recovery.
• Setup and constantly improve maintenance, operational and monitoring processes.
• Export/Import Replication, maintaining back up jobs, Creating Linked Server Objects.
• Experience in Database Mirroring, log shipping and DR procedures.
• Experience in SQL transactional Replication.
• Supporting MS SQL databases in Microsoft clustered environments.
• SQL 2016 Availability groups is a plus.
• Experience in Spotlight is plus.
• Windows administration, PowerShell, Visual Studio (SQL Server Data Tools) is a plus.

Job duties:

• SQL Server performance analysis, tuning, capacity planning/forecast, security, and design.
• Collaborate with DBAs and Developers in troubleshooting database and application errors.
• Actively monitor the database environment to ensure optimal performance and to prevent production issues.
• Open and Follow-up on Service Request tickets to quickly resolve problems.
• Perform Production On-Call Support on rotational basis – including Off-Hours and Weekend.

Required Skills:

• 7 Years – Demonstrated experience working as a SQL Server administrator.
• 7 Years – Strong understanding of SQL database monitoring and performance tuning.
• 7 Years – Experience in troubleshooting and resolving database problems.
• 7 Years – Experience with Backups restores and High Availability (Always on),
• 7 Years – Experience with Installation and configuration of SQL 2014, 2016 and 2019 Standard and Enterprise.
• 7 Years – Configuration of and work experience on SSIS and SSRS to create and deploys packages and Reports.
• 7 Years – SQL tuning, Data conversion / Migration, Supporting Enterprise Systems.
• 7 Years – Supporting MS SQL databases in Microsoft clustered environments.
• 7 Years – Experience in SQL transactional Replication.

Desired Skills:

• Windows administration, PowerShell, Visual Studio (SQL Server Data Tools) is a plus.
• Experience in Spotlight is plus.
• SQL 2016 Availability groups is a plus.

Skills Matrix: