SQLServer DBA/Developer (676808)
About the Opportunity
- We are only considering US Citizens and Green Card holders for this position. We are unable to sponsor for this role.
- We are only considering local candidates who currently reside within 45 minutes of postal code 08608
- No Third Party Agencies
- $86 per hour 1099, $74 per hour W2 + benefits
- 100% On-site in Trenton, New Jersey
- Job Id: CAI-676808
- Must be able to provide proof of COVID-19 vaccination plus booster shot
- Contract Term: Till end of the 2022 fiscal year with yearly extension based upon performance
Short Description
The State of New Jersey’s Department of Health (NJDOH) is seeking a SQLServer DBA/Developer to develop software and complete tasks as part of an Agile SCRUM team. The ideal candidate will have 8+ years of developing databases in Microsoft SQL Server 2017 or above.
Required Skills/Years of Experience
- High School Diploma or GED
- 8+ years of installing, configuring and managing new SQL Servers and databases (SQL 2017 or above)
- 8+ years of managing multi DB environment setup (including production)
- 8+ years of ensuring that all database servers are backed up and recovery is time tested to meet business’s Recovery Point Objectives
- 8+ years of failover clustering, replication and other high availability technology
- 8+ years of troubleshooting SQL Server service outages as they occur
- 8+ years of monitoring system health and performance
- 8+ years of working with developers to review scripts and support frequent DB deployment activities
- 8+ years of assisting developers with query tuning and schema refinement
- 8+ years of refining and automating regular processes, tracking issues and documenting changes
- 8+ years of writing Transact SQL (T-SQL) Queries, dynamic queries, indexes, constraints, views and functions
- 8+ years of writing new and understanding, reviewing and fine-tuning existing Stored Procedures
- 8+ years of Azure SQL databases and Azure portal features
- 8+ years of Microsoft Excel, data validations, data cleaning, manipulation, reporting and pivot features
- 1+ years of XML and JSON data structures
Desired Skills/Years of Experience:
- 5+ years of using Red Gate SQL Tool Belt
Complete Description
The State of New Jersey’s Department of Health (NJDOH) is seeking a SQLServer DBA/Developer to develop software and complete tasks as part of an Agile SCRUM team. The ideal candidate will have 8+ years of developing databases in Microsoft SQL Server 2017 or above.
The SQLServer DBA/Developer will be tasked to:
- Be involved and participate in the overall application lifecycle
- Collaborate with Front-end developers
- Define and communicate technical and design requirements
- Provide training, help and support to other team members
- Build high-quality reusable code that can be used in the future
- Develop functional and sustainable web applications with clean code
- Troubleshoot and debug applications
- Learn about new technologies
- Stay up to date with current best practices
- Conduct tests and optimize performance
- Manage cutting-edge technologies to improve applications
- Collaborate with multidisciplinary team of designers, developers, and system administrators
Hiring Expectations
- We are only considering US Citizens and Green Card holders for this position. We are unable to sponsor for this role.
- No Third Parties
- Right to Represent authorization is required
- Expect technical interview screening
- Expect F2F interview
- Background check and/or credit check will be required