Role: Data Warehouse/Database Administrator 

Location: West Jordan, Utah 84088

#DataWarehouse #DatabaseAdministration #DatabaseAdministrator #DBA #SQL #DataProfessionals #DBACommunity #urgenthiring #hiring #newopening #utahhiring

Data Warehouse Database Administrator Job Description:

Preferred/required skills: We are seeking a skilled professional who has proven experience working with databases in GCP

Are you a Database Administrator (DBA) looking for a great career doing important work that makes an impact?

Looking for an experienced Database Administrator (DBA) working on SQL databases hosted on Windows and Linux servers and Google Cloud Platform (GCP) with a strong focus on BigQuery and GCP services. The ideal candidate will be responsible for establishing, managing, and optimizing our data warehouse infrastructure to support business intelligence and analytics initiatives. Your role will be critical in ensuring the reliability, scalability, and performance of our data systems. You will collaborate closely with data analysts, engineers, and business stakeholders to deliver actionable insights and support data-driven decision-making.

The chosen candidate will also provide database maintenance, support, and GCP administration supporting our data warehouse and analytic needs. This role is crucial for ensuring that the State of Utah remains competitive and capable of meeting the demands of our customers with efficient, reliable, and scalable database solutions.

Primary Duties & Responsibilities

● Design, create, implement, and manage BigQuery data warehouses, including table structures, stored procedures, Linux shell scripts, and optimizing query performance.

● Develop and maintain data pipelines to ingest, transform, and load data from various sources such as on-premise Informix databases and eventually PostgreSQL from AWS into BigQuery in GCP.

● Monitor and tune data warehouse performance, including query optimization and debugging, indexing, and caching strategies.

● Implement data security best practices, manage access controls, and ensure compliance with relevant regulations and standards.

● Set up monitoring and alerting for data warehouse systems, troubleshoot issues, and ensure high availability and reliability.

● Develop and enforce data governance policies, data quality standards, and best practices.

● Work closely with data analysts, engineers, and business stakeholders to understand data requirements and deliver solutions that meet their needs.

● Document data warehouse architecture, processes, and best practices. Provide training and support to team members and end-users.

● Accommodate work that needs to be performed both during and after business hours.

● Create, manage, and maintain secure database access user roles.

● Other tasks as assigned.

Typical Qualifications

● Proven expertise with BigQuery on Google Cloud Platform (GCP), including hands-on experience in designing and optimizing BigQuery datasets along with some experience working with Informix databases.

● Extensive knowledge of database design and documentation.

● Knowledge of the development and management of computer system databases and data warehouses.

● Proficiency in SQL for data querying, analysis, and performance tuning.

● Experience with data integration tools (e.g., Dataflow, Apache Beam, Airflow) and ETL processes.

● Understanding of data security practices, access controls, and compliance requirements (e.g., GDPR, HIPAA).

● Experience with other data warehouse technologies (e.g., Redshift, Snowflake) and cloud platforms (e.g., AWS, GCP).

● Knowledge of data modeling, data warehousing concepts, and best practices.

● Familiarity with data visualization tools (e.g., Looker, PowerBI)

● Strong analytical, research, and organizational skills, with impeccable attention to detail.

● Understanding and experience with cloud services such as GCP and AWS.

● System administration skills are desired.

● Knowledge of CI/CD Pipelines.

● Good understanding of GitHub database version control.

● Ability to test and troubleshoot using appropriate methodologies and techniques.

● Excellent written/verbal communication, interpersonal, and organizational skills required.

● Understand the principles, theories, and practices of computer science.

● Deal with people in a manner that shows sensitivity, tact, and professionalism.