SQL Database Administrator / Senior Developer

Job Description:

DPP is seeking a SQL Database Administrator / Senior Developer for an opportunity in Columbia, SC.

Work location: Hybrid in Columbia, SC. Onsite 3 days/week
Duration: 12 months with possibility for extension
Terms: W2 position
Candidate location: Candidate MUST be a SC resident or willing to relocate to SC prior to starting the role

Position summary:

The SQL Database Administrator and Senior Developer will design, develop and support enterprise scale web applications in the Child Support Applications group under the Social Services department.
You will be 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 ideal candidate will take initiative in performance, working independently and with groups to effectively accomplish project objectives and job duties.

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:

Experience with Child Support Enforcement system design and development
Experience with 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 Agency and other state information technology staff.

Education: Bachelor’s degree or equivalent experience

Responsibilities:

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 cleansing/create processes and other strategies that optimize data quality
Understanding performance, quality, and schedule considerations
Interpreting complex data and communicating it in an effective manner, leveraging advanced reporting techniques
Recognizing data patterns, quantifying potential issues, and identifying 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

Interested? Learn more:
Click the apply button to learn more about this position (26-00413).

Authorized US Worker - US Citizens and those authorized to work in the US are encouraged to apply. We are unable to sponsor at this time. EOE/AA/V/D

DPP offers a range of compensation and benefits packages to our employees and their eligible dependents. Call today to learn more about working with DPP.

Job Ident #: 26-00413

Company Details

DP Professionals

3741 Landmark Drive
Suite 200
Columbia, South Carolina 29204 USA
www.dppit.com/

DPP® specializes in placing highly qualified information technology professionals in both contingent and direct hire opportunities in private industries such as healthcare, insurance, banking, utilities, energy, manufacturing, federal and state government...

(Job and company information not to be copied, shared, scraped, or otherwise disseminated/distributed without explicit consent of JSfirm, LLC)

Job Info

Location

Columbia, South Carolina, United States

Type

Permanent

Company Details

DP Professionals

3741 Landmark Drive
Suite 200
Columbia, South Carolina 29204 USA
www.dppit.com/