NEW JOB OPENING
SYSTEM SOFTWARE PROGRAMMER - CONSULTANT
IN Columbia, SC, USA!

REQUIRED EDUCATION:

• Bachelor’s degree



MINIMUM REQUIRED EXPERIENCE/ 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



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 Power



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 andwritten) effectively with technical, non-technical staff, customers/stakeholders and executives



PREFFERED KNOWLEDGE, SKILLS, AND ABILITIES:

• Experience with Child Support Enforcement system design and development

• Experience with PowerBI



SCOPE OF THE PROJECT: The Department seeks a highly motivated individual who has the skills and experience of designing, developing and supporting enterprise scale web applications in the Support Applications group under the client. This is a posting of a position to perform in the role of SQL Database Administrator and Senior Developer that I 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.



RESPONSIBILITIES: 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

• 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

• **Only those lawfully authorized to work in the designated country associated with the position will be considered.**

• **Please note that all Position start dates and duration are estimates and may be reduced or lengthened based upon a client’s business needs and requirements.**