Novalink Solutions LLC Jobs

SQL DBA

Novalink Solutions LLC

SQL DBA

Posted 12 Hours Ago

Be an Early Applicant

Madison, WI, USA

In-Office

Senior level

Artificial Intelligence • Information Technology • Professional Services • Consulting

The Role

The SQL DBA will design and develop applications while managing databases, optimizing performance, leading projects, and ensuring data quality and governance within Child Support Services.

Summary Generated by Built In

The Child Support Services Applications Team is part of the

Department of Social Services (DSS) and is responsible for developing and maintaining

applications in support of the Child Support Services Division (CSSD) including PACSS

(Palmetto Automated Child Support System), SDNH (State Directory of New Hires) and

the Client Portal application.

JOB DUTIES / RESPONSIBILITIES:

The Department seeks a highly motivated individual who has the skills and experience of

designing, developing and supporting enterprise scale web applications in the Child Support

Applications group under the South Carolina Department of Social Services. This is a posting of a

position to perform in the role of SQL Database Administrator and Senior Developer that is

responsible for developing applications and database integrations using the Microsoft SQL Server

platform. This will include reports, vendor exports, data warehousing tasks and other data related

tasks.

The candidate will take initiative in performance, working independently and with groups to

effectively accomplish project objectives and engage in the following:

• Identifying, extracting and transforming required data based on business requirements

and following data governance standards

• Performing detailed data analysis and data profiling supporting the development and

implementation of data cleanse/create processes and other strategies that optimize data

quality

• Understanding performance, quality, and schedule considerations

• Interpreting complex data and communicate it in an effective manner, leveraging

advanced reporting techniques

• Recognizing data patterns, quantify potential issues, and identify solutions

• Standardizing, harmonizing, cleaning, preparing, and using data for datasets

development, reporting, and analysis

• Providing support to the project team in terms of technical specification and build of

interface objects

• Lead efforts to design, test and validate system interfaces

• Work with state (agency IT staff) and Federal partners to design, test and implement

interface files and procedures for data exchange

• Inspect and correct, as necessary, interface partner files in production

• Serve as primary contact for any interface production file issues during nightly batch

process, monitors batch process for errors

• Act as liaison between Child Support team and interface partners

• Perform code, technical and logical reviews

• Monitor database growth trends and recommend normalization strategies and

maintenance improvements to ensure long-term performance and scalability

• Design, develop and manage data analysis reports using Microsoft PowerBI platform

• Serve as primary DBA for Child Support related applications

• Participate in the monitoring, oversight and reporting on the execution of the System

Development Contractor’s performance as it relates to development, daily operations

activities including batch and online performance.

• Developing and maintaining enterprise data authoritative ownership and stewardship

metadata

• Communicating and supporting the implementation of corporate policies, standards, and

procedures that provide effective architecture, governance, and management of the

organization’s information/data assets

• Developing and maintaining effective and efficient information architecture and data

ownership awareness and training programs

• Monitoring regulatory and compliance guidelines (such as data retention and audit

requirements) to determine impact on enterprise information architecture

REQUIRED SKILLS:

• 5+ years of experience as a SQL DBA

• 5+ years of large system architecture

• Large scale production system

implementation experience

• Experience overseeing work of

Software Development Vendors

• MS SQL Server

• TFS (Team Foundation Server)

• Microsoft Visual Studio 2022

• C#, ASP.net, and/or .NET

• Powershell

PREFERRED SKILLS (RANK IN ORDER OF

IMPORTANCE):

• Experience with Child Support

Enforcement system design and

development

• Experience with PowerBI

REQUIRED EDUCATION:

• BACHELOR’S DEGREE OR EQUIVALENT

EXPERIENCE

REQUIRED CERTIFICATIONS:

• N/A

ENVIRONMENTS AND TOOLS

• MS SQL 2022 enterprise server and MS

SQL 2022 enterprise server Reporting

Services

• TFS (Team Foundation Server)

• Microsoft Visual Studio 2022

• C#, ASP.net, .NET

• POWERSHELL

• MICROSOFT POWERBI

ADDITIONAL SKILLS:

• Proven abilities to plan, organize,

instruct, and review the work of the

development team.

• Knowledge of generally accepted

system architecture, project

management and supervision

principles and practices.

• Ability to communicate (orally and

written) effectively with technical,

non-technical staff,

customers/stakeholders (State and

Federal) and executives.

• Ability to communicate effectively

with DSS and other State

information technology staff

RequirementsRequired Skills

Skill Type

Skill Name