CR280-MS SQL DBA

Job Title: MS SQL DBA- CR280

Location: Pleasanton-CA OR Vacaville-CA

Duration: 1 year

Project Introduction:

Consultant will perform high-level professional services in support of Client s systems providing expert database administration services Oracle databases as needed. Services include but are not limited to project planning systems development systems design systems maintenance helpdesk/user support documenting system requirements and changes and Mentoring/Skills Enhancement to Client s employees.

MUST HAVES

• Build & Release Automation

• Pipeline Design and Development experience

• Software configuration process optimization

TECHNICAL KNOWLEDGE AND SKILLS:

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 engineers to seamlessly incorporate database release into the software development CI/CD pipelines.

Knowledge of Information Management Practice is a plus.

DELIVERABLES OR TASKS:

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 for 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.

PREFERRED SKILLS:

Experience with various industry standard project management methodologies (e.g.: Agile SCRUM Waterfall etc.)

Strong oral and written communication skills.

Strong analytical skills with the ability to analyze information identify and formulate solutions to problems.

Provides more in-depth analysis with a high-level view of goals and end deliverables.

Complete work within a reasonable time frame under the supervision of a manager or team lead.

Plan and manage all aspects of the support function.

Extensive knowledge of and proven experience with data processing systems and methods of developing testing and moving solutions to implementation.

Strong knowledge in project management practices and ability to document processes and procedures as needed.

Work collaboratively with other support team members and independently on assigned tasks and deliverables with minimum supervision

Communicate effectively with users at all levels from data entry technicians up to senior management verbally and in writing.

Self-motivated working closely and actively communicating with person to accomplish time critical tasks and deliverables.

Ask questions and share information gained with other support team members recording and documenting this knowledge.

Elicit and gather user requirements and/or problem description information and record this information accurately.

Listen carefully and act upon user requirements.

Convey and explain complex problems and solutions in an understandable language to both technical and non-technical persons.

Present technical solutions to management and decision makers Follow the lead of others on assigned projects as well as take the lead when deemed appropriate