SQL DBA

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

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