1 W2-Data Warehouse Database Administrator [Hybrid] Job in West Jordan, UT
SORT BY
R
W2-Data Warehouse Database Administrator [Hybrid]
$76k-96k (estimate)
Full Time
3 Weeks Ago
Remoteworker Us is Hiring a W2-Data Warehouse Database Administrator [Hybrid] Near West Jordan, UT
Job DescriptionJob Description
Position: Data Warehouse Database AdministratorClient: State of UtahDepartment: UDCVisa: USC/GC only (need pp number of GC candidate to check i94)Location: 8523 S. Redwood Rd, West Jordan, Utah 84088Projected Duration: 1 years from projected start dateTentative interview dates: Tuesday September 3rd and Wednesday September 4thRemote or onsite: 60% onsite 40% remote, about 2 days onsite and 3 days remoteJob Description:Scoring:Technical Expertise - 40%Past Experience - 40%Cost - 20%Preferred/required skills: We are seeking a skilled professional who has proven experience working with databases in GCPData Warehouse Database AdministratorAre you a Database Administrator (DBA) looking for a great career doing important work that makes an impact? The State of Utah Department of Government Operations, Division of Technology Services (DTS) is looking for an experienced DBA to support the Department of Corrections.
DTS is 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 & ResponsibilitiesDesign, 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 QualificationsProven 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.
In the event of a tie in the total score between candidates in the top/winning positions, the technical score will be calculated (sans the cost factor), and the highest technical scorer of the tied candidates will be awarded the position. Should this method fail to yield an ultimate "winner," the candidates will be asked to participate in a best and final offer process.
Position: Data Warehouse Database AdministratorClient: State of UtahDepartment: UDCVisa: USC/GC only (need pp number of GC candidate to check i94)Location: 8523 S. Redwood Rd, West Jordan, Utah 84088Projected Duration: 1 years from projected start dateTentative interview dates: Tuesday September 3rd and Wednesday September 4thRemote or onsite: 60% onsite 40% remote, about 2 days onsite and 3 days remoteJob Description:Scoring:Technical Expertise - 40%Past Experience - 40%Cost - 20%Preferred/required skills: We are seeking a skilled professional who has proven experience working with databases in GCPData Warehouse Database AdministratorAre you a Database Administrator (DBA) looking for a great career doing important work that makes an impact? The State of Utah Department of Government Operations, Division of Technology Services (DTS) is looking for an experienced DBA to support the Department of Corrections.
DTS is 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 & ResponsibilitiesDesign, 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 QualificationsProven 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.
In the event of a tie in the total score between candidates in the top/winning positions, the technical score will be calculated (sans the cost factor), and the highest technical scorer of the tied candidates will be awarded the position. Should this method fail to yield an ultimate "winner," the candidates will be asked to participate in a best and final offer process.
Job Summary
JOB TYPE
Full Time
SALARY
$76k-96k (estimate)
POST DATE
08/21/2024
EXPIRATION DATE
09/17/2024
Show more
Similar Jobs
Popular Articles
Top 10 Things to Avoid Putting on a Job Application
Read Article
How to Describe Your Education in a Resume
Read Article
How to Write a Memorable Cover Letter in 5 Ways
Read Article
4 Personal Finance Tips to Make During Job Transition
Read Article
4 Best Camera Setups for Interview
Read Article
Keeping a Job Search Journal: 9 Types of Journaling You Can Do
Read Article
