Overview
Skills
Job Details
Position: SQL server DBA
Location: Remote
Duration: Long Term
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, Liquibase, 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.