Database Developer/ContractorThe Database Developer/Contractor will be working on the Client Trails Product and shall provide the services in an agile environment as follows:Lead/Mentor other developers in solutions, system analysis, code feedback and reviews and oversee best development practices.Provide guidance and support to Application DevelopersDesign stable, reliable and effective database structures (tables, indexes, views).Optimize and maintain legacy systemsSolve database usage issues and malfunctionsLiaise with developers to improve the Trails product and establish best practicesDevelop technical and training documentation/manualsAnalyze the needs of the Trails product and produce an effective database object according to the needs and specifications. This could include collecting data, analyzing the data, drawing flowcharts and implementing code.Work with the Quality Assurance and Database Administrators to test various database objects / run performance testing.Develop database documentation.Implement bug fixes and enhancements to the Trails environment utilizing tools AzureDevOps, Oracle and Visual Studio.Provide support and debug issues identified within the Colorado Child Welfare System environmentCreate and enhance scripts/snippets of code for the application to be run on the RedHat Enterprise Linux environment.Document the required system information.Identifying bottlenecks or bugs and troubleshooting integration issues.Maintaining the automation and quality of the code.Be capable of maintaining source repositories using AureDevOps/Team Foundation Server.User Acceptance Testing (UAT) coordination with state program staff on changes and meeting user story requirements.Minimum Resource Requirements - RequiredBachelor's degree in computer science or related information technology field5-7 years of experience with programming languages such as PL/SQL codingImplement and manage company data management practices and policies5 years of experience in administering, managing and tuning databases5 years of experience with Oracle RAC, Oracle Stand-alone or SQL ServerGood understanding of data and schema standards and conceptsGood understanding of database design, implementation, troubleshooting and maintenanceExpertise in SQLTeam PlayerGood time-management skillsGreat interpersonal and communication skillsExperience with Windows, Unix, LinuxBack End Technologies/Concepts: ASP.NET MVC, C# and RESTful API designPowershell & Unix Bash Shell ScriptingResource Requirements a PlusFront End Technologies/Concepts: HTML, CSS, Javascript, JQuery.Experience with real-time logging and monitoring tools like Splunk and Dynatrace