Senior Database Administrator

Hybrid in Bakersfield, CA, US • Posted 16 hours ago • Updated 16 hours ago
Contract W2
Contract Independent
12 Months
Hybrid
$60 - $68/hr
Company Branding Image
Fitment

Dice Job Match Score™

✨ Finding the perfect fit...

Job Details

Skills

  • DATABASE ADMINISTRATOR
  • DATABASE ADMINISTRATION
  • MICROSOFT SQL SERVER
  • POSTGRESQL
  • MYSQL
  • ETL
  • DATA INTEGRATION
  • DATA WAREHOUSING
  • AGILE METHODOLOGY
  • SCRUM MASTER
  • PROJECT MANAGEMENT
  • DATABASE DESIGN
  • DATA MODELING
  • DATABASE ARCHITECTURE
  • T-SQL
  • ANSI SQL
  • AZURE DEVOPS
  • VERSION CONTROL

Summary

Position Summary

The role is responsible for all aspects of the organization''s database management strategy, integrity, and design with subject matter expertise of the data stored within the database systems. This includes database design; table definition design and creation; ETL (Extract Translate and Load) design and development from conception to implementation; database maintenance, tuning, backup, and upgrades. The role leads discussions and mentors application and database development staff with database design, automation and validation of data load routines involving application databases. In addition, the role provides team leadership, establishes technical standards for the database team, and works closely with the management team to continuously refine the project management and agile development methodology, procedures, and policies in order to promote efficiency and productivity. The position will be required to lead, work with, and mentor people of various professional, vocational, and educational backgrounds.

Essential Duties and Responsibilities

<>Leadership
  • Provide strong technical direction and guidance, project management skills using the Project Management Institute (PMI) methodology, and related abilities to facilitate, execute, and accomplish corporate and maintenance project deliverables.
  • Provide technical leadership for all aspects of Database development and operations, lead technical teams using the Agile methodology for incremental product delivery, independently perform Scrum Master duties, and promote Agile best practices for continuous improvement.
  • Facilitate and lead collaborative cross-functional workgroups to resolve complex problems in real-time to reduce or mitigate operational interruptions.
  • Mentor and provide leadership to junior team members.
<>Technical
  • Architect and develop ETL using Microsoft SQL server Integrations services and catalog that are used to collect and store the data from external sources, so that data can be accessed by internal or external business and technology partners or users.
  • Install, configure, support, and troubleshoot Microsoft SQL Server, or other relational database platforms like PostgreSQL or MySQL, supporting OS and associated hardware.
  • Design, create, or modify database tables, indexes, constraints, links, stored procedures, and functions.
  • Expertise in working with different types of data (JSON/xml/HL7/etc.) and heterogeneous data sources from web/cloud-based solutions to Data Lakes or warehouses.
  • Perform code review and troubleshoot in development of custom database packages and maintain code repository in Azure DevOps.
  • Ensure that routine or special database software upgrades, maintenance, security audits, and patches are performed.
  • Manage and review database server administration including but not limited to data and database backup and recovery, system performance, system monitoring, and database security.
  • Provide leadership in the overall database designs and setup in support of the KHS and industry standards and establish best practices to govern database server users, roles, or permissions.
  • Provide direction and methodology for the data warehouse design, creation, and maintenance to include data schemas and associated ETL in conjunction with business needs.
  • Establish standards for data integrity in the KHS data warehouse through data reconciliation techniques, data analysis, or ETL design issues.
  • Provide design and structural recommendations for database application tuning and performance enhancements to development team.
  • Advanced knowledge of ANSI SQL (T-SQL preferred).
<>Administrative
  • Independently evaluate, select, and integrate third party tools.
  • Proactively interacts with management, business and technical analysts in review and design of new concepts and ideas, project implementation, and problem resolution.
  • Provide technical feasibility studies in support of projects and ensure system documentation is accurate and current.
  • Provide user database education and acts as liaison in database support for various business functions that will include multiple KHS departments.
  • Supervise and coordinate deployment of database code and related change management process, including collaboration with technical resources such as systems engineers.
  • Works in coordination with system engineers on all major infrastructure changes to assess business impact and communication methods.
  • Analyze and monitor system and database impact metrics prior to deploying code to production.
  • Supervise and coordinate database demonstrations, user acceptance testing, new implementations, and upgrades.
  • Proactively assume ownership of initial or escalated help desk incidents, change management requests, problem tickets, and other work as assigned that cannot be resolved at a lower level.
  • Actively attend webinars and conferences as they pertain for database maintenance, direction, and industry standardization.
  • Determine industry changes and make appropriate recommendations to management for future technical direction.

Education and Experience

  • Bachelor''s degree from an accredited school or equivalent in Computer Science, Mathematics, or related field and eight (8) years of progressive experience in a Database Administration or Database programming in a medium to large organization with a structured IT department preferably in healthcare. Education can be substituted with Programming work experience on a year for year basis.
  • OR
  • Twelve (12) years of progressive experience in a Database Administration or Database programming experience in a medium to large organization with a structured IT department preferably in healthcare.

Join our team in beautiful California (CA), where you can enjoy a vibrant lifestyle and a wealth of opportunities for professional growth and development in the field of database administration.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 91138017
  • Position Id: 26-00583
  • Posted 16 hours ago

Company Info

About OP Consulting Group LLC

OP Consulting Group was formed by an IT Consultant who was frustrated with the current practices in the staffing industry. With a determination to bring change in the staffing practices, we came up with some bold business practices. We also offer complimenting services of Training and Consulting.

We are not just a middleman but are your partner to help turn your goals into reality. We do not see a job opportunity as a single transaction but the beginning of a long-term relationship.

OP Consulting Group’s promises to you are:
• Upfront and transparent pay rate
• We keep low margins
• Frequent and proactive communication of submission status
• We only work with direct clients or prime vendors
• On-time payment

About_Company_OneAbout_Company_Two
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Hybrid in Bakersfield, California

Today

Easy Apply

Contract

Depends on Experience

Remote

3d ago

Easy Apply

Contract

$40 - $46

Hybrid in Lansing, Michigan

Yesterday

Easy Apply

Contract

$58 - $62

Search all similar jobs