Systems Software Programmer - Hybrid

Dice is the leading career destination for tech experts at every stage of their careers. Our client, VIVA USA INC, is seeking the following. Apply via Dice today!Title: Systems Software Programmer - HybridMandatory skills:Microsoft SQL Server, MS SQL Server, MS SQL 2022 Enterprise Server, MS SQL 2022 Enterprise Server Reporting Services,Microsoft Visual Studio 2022, TFS, Team Foundation Server,C#, ASP.net, .NET, Powershell,Microsoft PowerBI,system architecture, system implementation, system design, system development, software development, application development, project management,database integrations, information architecture, system interfaces, interface objects, interface files,data warehousing, data analysis, data profiling, data cleanse, data quality, data reporting,data patterns, datasets development, data exchange, data assets, data retention, data ownership, database trends,advanced reporting techniques, reports, vendor exports, enterprise data, stewardship metadata,data governance standards, audit requirements, business requirements, regulatory, compliance, policies, standards, procedures, guidelinesDescription:The client is looking for a Systems Software Programmer - AdvancedJOB DUTIES / RESPONSIBILITIES:The client seeks a highly motivated individual who has the skills and experience of designing, developing and supporting enterprise scale web applications in the 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 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 standardsPerforming detailed data analysis and data profiling supporting the development and implementation of data cleanse/create processes and other strategies that optimize data qualityUnderstanding performance, quality, and schedule considerationsInterpreting complex data and communicate it in an effective manner, leveraging advanced reporting techniquesRecognizing data patterns, quantify potential issues, and identify solutionsStandardizing, harmonizing, cleaning, preparing, and using data for datasets development, reporting, and analysisProviding support to the project team in terms of technical specification and build of interface objectsLead efforts to design, test and validate system interfacesWork with client IT staff and Federal partners to design, test and implement interface files and procedures for data exchangeInspect and correct, as necessary, interface partner files in productionServe as primary contact for any interface production file issues during nightly batch process, monitors batch process for errorsAct as liaison between the client team and interface partnersPerform code, technical and logical reviewsMonitor database growth trends and recommend normalization strategies and maintenance improvements to ensure long term performance and scalabilityDesign, develop and manage data analysis reports using Microsoft PowerBI platformServe as primary DBA for client related applicationsParticipate 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 metadataCommunicating and supporting the implementation of corporate policies, standards, and procedures that provide effective architecture, governance, and management of the organization’s information/data assetsDeveloping and maintaining effective and efficient information architecture and data ownership awareness and training programsMonitoring regulatory and compliance guidelines (such as data retention and audit requirements) to determine impact on enterprise information architectureREQUIRED SKILLS:5+ years of experience as a SQL DBA5+ years of large system architectureLarge scale production system implementation experienceExperience overseeing work of Software Development VendorsMS SQL ServerTFS (Team Foundation Server)Microsoft Visual Studio 2022C#, ASP.net, and/or .NETPowershellPREFERRED SKILLS (RANK IN ORDER OF IMPORTANCE):Experience with Child Support Enforcement system design and developmentExperience with PowerBIREQUIRED EDUCATION:Bachelor’s Degree Or Equivalent ExperienceENVIRONMENTS AND TOOLSMS SQL 2022 enterprise server and MS SQL 2022 enterprise server Reporting ServicesTFS (Team Foundation Server)Microsoft Visual Studio 2022C#, ASP.net, .NETPOWERSHELLMICROSOFT POWERBIADDITIONAL 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 client staff.Required Skills5+ years of experience as a SQL DBA5+ years of large system architectureLarge scale production system implementation experienceExperience overseeing work of Software Development VendorsMS SQL ServerTFS (Team Foundation Server)Microsoft Visual Studio 2022C#, ASP.net, and/or .NETPowershellPreferred SkillsExperience with Child Support Enforcement system design and developmentExperience with PowerBINotes:Role is hybrid (3 days onsite per week)VIVA USA is an equal opportunity employer and is committed to maintaining a professional working environment that is free from discrimination and unlawful harassment. The Management, contractors, and staff of VIVA USA shall respect others without regard to race, sex, religion, age, color, creed, national or ethnic origin, physical, mental or sensory disability, marital status, sexual orientation, or status as a Vietnam-era, recently separated veteran, Active war time or campaign badge veteran, Armed forces service medal veteran, or disabled veteran. Please contact us at for any complaints, comments and suggestions.Contact Details :Account co-ordinator: Binodh M.T, Phone : , Email:VIVA USA INC.3601 Algonquin Road, Suite 425Rolling Meadows, IL 60008|