SQL Server DBA (683540)

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 08619
• No Third Party Agencies
• $72 per hour 1099, $62 per hour W2 + benefits
• 2 days a week on-site in Trenton, New Jersey, 3 days work from home
• Job Id: CAI-683540
• 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

Apply Now

Short Description

The State of New Jersey’s Department of Human Services (NJDHS) Division of Family Development (DFD) is seeking a SQL Server DBA to design, manage, and maintain the relational/SQL databases, data warehouse, and reporting infrastructure for all applications within DFD. The ideal candidate will possess 7+ years of experience with SQL Schema management, 7+ years of experience using MS SQL Server 2008 and above, and 7+ years of experience with SQL/TSQL development, SSMS, SSIS, SSAS, and SSRS.

Required Skills/Years of Experience

• Bachelor’s degree in computer science or related field
• 7+ years of experience with SQL Schema management
• 7+ years of experience with MS SQL Server 2008 and above
• 7+ years of experience with SQL/TSQL development, SSMS, SSIS, SSAS, and SSRS
• 5+ years of experience designing databases and data modeling
• 5+ years of experience writing stored procedures
• 3+ years of experience interfacing with EC2
• 3+ years of experience with AWS RDS
• 1+ years of experience with .NET, VB, ASPX, DAX, C#, and VBA
• 1+ years of experience with Crystal Reports and PowerBI
• 1+ years of experience developing restful apis for database layer and web application architecture
• 1+ years of experience analyzing and converting hierarchical data into relational data

Desired Skills/Years of Experience:

• 7+ years of experience with Visual Studio 2008 and above
• 1+ year of experience developing, hosting, and managing databases on AWS RDS

Complete Description

The State of New Jersey’s Department of Human Services (NJDHS) Division of Family Development (DFD) is seeking a SQL Server DBA to design, manage, and maintain the relational/SQL databases, data warehouse, and reporting infrastructure for all applications within DFD. The ideal candidate will possess 7+ years of experience with SQL Schema management, 7+ years of experience using MS SQL Server 2008 and above, and 7+ years of experience with SQL/TSQL development, SSMS, SSIS, SSAS, and SSRS.

The SQL Server DBA will be tasked to:

• Design, manage, and maintain the relational/SQL databases, data warehouse, and reporting infrastructure for all applications within DFD
• Design, develop, and maintain database solutions and data warehousing
• Support enterprise application services
• Create report on analytics
• Support architecture design, data modeling, documentation, policies, and standards
• Analyze systems to integrate with future systems
• Maintain legacy reporting along with design
• Implement new reporting and data availability models
• Design, implement, and support data models, databases, and DW solutions
• Develop and implement OLTP schemas and comprehensive testing plans for validating data transformation and integration
• Develop key metrics to ensure integrity on data architecture
• Take ownership of assigned tasks and adhere to sprint deadlines
• Collaborate with teams of developers, the technical lead, architect, business SMEs, and project managers
• Recognize problems and respond
• Gather information systematically
• Sort through complex issues, seek input from others, and address root causes of issues
• Make timely and difficult decisions using consensus when possible
• Adapt to change rapidly

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

About Dantech

Dantech Corporation, Inc. is a Certified Business Enterprise (CBE) in the District of Columbia and a federally recognized Woman Owned Small Business (WOSB). The company has a history of technology, innovation and transformation since its launch in 1999. As an Equal Opportunity/Affirmative Action Employer, all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, age, protected veteran status, or disability status. For more information about positions with Dantech, please see: https://www.dantechcorp.com/staffing.