Database Administrator IV

Role: Database Administrator IV – EDW

Location: 100% Remote- Only West Coast candidates

Duration : 6+ months

Required Expert Knowledge in Data Warehouse Modeling:

Experience in designing conceptual, logical, and physical data models

Experience with modeling tools such as Erwin and Toad Data Modeler.

Strong knowledge of SQL for data extraction, manipulation, and performance optimization

In-depth understanding of ETL best practices for data integration and transformation

Familiarity with dimensional modeling techniques, including star and snowflake schemas, and fact/dimension tables

Ability to design data structures optimized for analytical querying

Creating and understanding SSIS packages

Writing complex stored procedures and advanced SQL

Developing and maintaining scalable data pipelines and systems

Identifying and resolving performance bottlenecks in data flows

Architect and develop ETL processes using Microsoft SQL Server Integration Services (SSIS)

Install, configure, support, and troubleshoot Microsoft SQL Server and other platforms (PostgreSQL, MySQL)

Design and modify database components (tables, indexes, constraints, stored procedures, functions)

Work with a variety of data types and sources, including JSON, XML, HL7, cloud/web-based data, and Data Lakes

Conduct code reviews and maintain code repositories (Azure DevOps)

Desired Skills:

Understanding of HIPAA requirements

Healthcare industry experience

Agile methodology knowledge

Scrum Master certification

Project management experience

Experience with Visual Studio and Azure DevOps

Familiarity with Data Vault architecture

Experience with Microsoft Azure

Familiarity with cloud-based data warehousing tools (AWS, Azure, GCP)

Knowledge of JSON and other semi-structured data formats

Position Summary:

The Database Administrator IV is responsible for leading all aspects of the organization's database management strategy, ensuring integrity, performance, and reliability. This includes database design, development of ETL processes, optimization, maintenance, and mentoring of development teams. This role also plays a key part in setting technical standards, refining project management methodologies, and collaborating across departments to promote efficiency and data governance.

Technical:

Technical Expertise Required:

Advanced knowledge of ANSI SQL (T-SQL preferred)