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.