DHHS- SQL Server Administrator

NC DHHS 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 troubleing and resolving database problems; Experience with following:
oBackups restores and High Availability (Always on)
oInstallation and configuration of SQLand 2019 Standard and Enterprise
oConfiguration of SSIS and SSRS
oWork experience on SSIS and SSRS to create and deploys packages and Reports
oDatabase upgrade Patching & Refresh
oSQL tuning Data conversion / Migration Supporting Enterprise Systems
oDatabase maintenance Database backup and recovery
oSetup and constantly improve maintenance operational and monitoring processes
oExport/Import Replication maintaining back up jobs Creating Linked Server Objects
oExperience in Database Mirroring log shipping and DR procedures
oExperience in SQL transactional Replication
oSupporting MS SQL databases in Microsoft clustered environments
oSQL 2016 Availability groups is a plus
oExperience in Spotlight is plus
oWindows administration PowerS Visual Studio (SQL Server Data Tools) is a plus

Job duties:
oSQL Server performance ysis tuning capacity planning/forecast security and design
oCollaborate with DBAs and Developers in troubleing database and application errors
oActively monitor the database environment to ensure optimal performance and to prevent production issues.
oOpen and Followup on Service Request tickets to quickly resolve problems.
oPerform Production OnCall Support on rotational basis including OffHours and Weekend

Required/Desired Ss
SRequired /DesiredAmountof ExperienceDemonstrated experience working as a SQL Server administratorRequired7YearsStrong understanding of SQL database monitoring and performance tuningRequired7YearsExperience in troubleing and resolving database problemsRequired7YearsExperience with Backups restores and High Availability (Always on)Required7YearsExperience with Installation and configuration of SQLand 2019 Standard and EnterpriseRequired7YearsConfiguration of and work experience on SSIS and SSRS to create and deploys packages and Reports Required7YearsSQL tuning Data conversion / Migration Supporting Enterprise SystemsRequired7YearsSupporting MS SQL databases in Microsoft clustered environmentsRequired7YearsExperience in SQL transactional ReplicationRequired7YearsWindows administration PowerS Visual Studio (SQL Server Data Tools) is a plus Desired0Experience in Spotlight is plusDesired0SQL 2016 Availability groups is a plusDesired0
Questions
No.QuestionQuestion1Absences greater than two weeks MUST be approved by CAI management in advance and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you accept this requirementQuestion2Onsite work will be required at the client s discretion. Do you accept this requirementQuestion3Please list candidate s email address. Question4Please indicate how soon this candidate is available to start work. Vendors are encouraged to submit candidates that are available for the duration of the ignment.Question5Vendor must disclose to the agency if the candidate will be subcontracted at the time of submission. Do you accept this requirementQuestion6Vendor must notify the agency if any portion of the requirements listed in this task order is to be outsourced to other countries. Do you accept this requirementQuestion7Candidates submitted above the rate of will not be considered. Do you accept this requirement Question8Payment for all approved hours will be paid at the straight hourly rate regardless of the total hours worked by the engaged resource. It is the responsibility of the supplier to adhere to any applicable compensation laws including payment for overtime hours. Do you accept this requirementQuestion9Please confirm you have thoroughly validated and attest to the accuracy of the credentials listed throughout this candidate s VectorVMS profile and resume pursuant to Section 5.2.5 of ITS009440. Do you confirm Question10This position requires that if selected for the role candidate agrees to comply with EO224COVID19 Guidelines. Do you accept this requirement and affirm you will share this requirement with your candidate and have obtained confirmation that your candidate will comply with these guidelines Pls reply YES or NO