Job description

Top 3-5 Must Haves • Build & Release Automation • Pipeline Design and Development experience • Software configuration process optimization Technical Skills & Knowledge: Consultant shall possess 7+ years technical knowledge and experience with the following systems, platforms, applications skills: • Deep technical experience working with relational database solutions (MS SQL Server 2019 and above). • Significant experience with database design & data modeling, performance analysis, advanced query writing, optimization, and scripting. • Significant experience in Software configuration process optimization, Pipeline Design, Build & Release Automation. • Knowledge with TFS, Azure DevOps, Git, Liqubase, Jenkins and automation frameworks. • Ability to automate Database Deployment functions and work extensively with DevOPS engineer to seamlessly incorporate database release into the software development CI/CD pipelines. • Knowledge in Information Management Practice a plus Deliverables: The day to day tasks, responsibilities, and deliverables for consultant include, but are not limited to the following: • Work with development teams to understand full scope of applications and participate in the big picture design. • Provide database design direction and work as a database design leader of a large, complex projects. • Ensure adherence to database best practices, coding standards, and quality assurance policies and procedures. • Promote database methodologies and standards. Ensure DB standards are followed through design reviews. • Design and implement framework for automation of Database change (schema changes) deployments with the releases and integrate Database change deployments with CI/CD pipelines. • Devise Strategy and Engage with Enterprise DBAs & Solution Architects, to define & execute Database strategy. • Ensure that data strategies and architectures are in regulatory compliance • Support and assist development team in the testing, tuning and implementation of database applications. • Train & mentor Front End Database Developers and Oracle DBAs. • Lead and administer Oracle in non-production environments.

Requirements