Buxton Consulting
MS-SQL Server DBA
Buxton Consulting - Pleasanton, California, United States, 94566
Work at Buxton Consulting
Overview
- View job
Overview
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.
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.