Data Warehouse Database Administrator

4 weeks ago

Salt Lake City, United States RICEFW Technologies Inc Full time

Don't Apply if you are not local to Utah


Note: Locals Only

Data Warehouse Database Administrator

Are 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 & 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.

  • Data Warehouse Database Administrator

    4 weeks ago

    Salt Lake City, United States ConsultNet Full time

    Data Warehouse Database AdministratorWest Jordan, UT (hybrid)12month ContractPay Range: $50.00 - $80.00per hr Job Description:Our client is seeking an experienced Database Administrator (DBA) to manage and optimize their data warehouse infrastructure. This role focuses on SQL databases and Google Cloud Platform (GCP) services, particularly BigQuery.Key...

  • Data Warehouse Database Administrator

    3 weeks ago

    Salt Lake City, United States ConsultNet Full time

    Data Warehouse Database Administrator West Jordan, UT (hybrid) 12month Contract Pay Range: $50.00 - $80.00per hr Job Description: Our client is seeking an experienced Database Administrator (DBA) to manage and optimize their data warehouse infrastructure. This role focuses on SQL databases and Google Cloud Platform (GCP) services, particularly BigQuery....

  • Database Administrator

    1 month ago

    Salt Lake City, United States Morph Enterprise Full time

    Job DescriptionJob Description Primary Duties & Responsibilities Develop and implement a comprehensive database migration strategy from Informix to a more modernized and scalable database system.Conduct thorough assessments of current database structures, data volumes, and system integrations.Design and manage database schemas ensuring they meet functional...

  • Data Warehouse Database Administrator

    4 weeks ago

    Salt Lake City, United States RICEFW Technologies Inc Full time

    Don't Apply if you are not local to UtahNote: Locals Only Data 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...

  • Sr. SQL Database Administrator

    1 week ago

    Salt Lake City, United States ConsultNet Full time

    Sr. SQL Database Administrator Salt Lake City, UT (hybrid) 6month contract to hire Pay Range: $50.00 - $65.00per hr / Salary Target: $100K - $120K Job Description: Our client is looking for an expert in SQL Server design and development to provide leadership in creating and maintaining databases and data structures, interfacing with developers and users to...

  • SQL Database Administrator

    4 weeks ago

    Salt Lake City, United States eTeam Full time

    Job Title: Engineering - Middleware Engineering - Sr. Microsoft SQL DatabaseJob Location: 222 South Main Street, Salt Lake City, UT 84101 (Onsite)Job Duration: 12 Months + Possible extension Pay range: $60 - $65 an hourDepartment: Middleware EngineeringJob Category: Technology Description:Provide Primary DBA (Database Administration) responsibilities...

  • SQL Database Administrator

    4 weeks ago

    Salt Lake City, United States eTeam Full time

    Job Title: Engineering - Middleware Engineering - Sr. Microsoft SQL DatabaseJob Location: 222 South Main Street, Salt Lake City, UT 84101 (Onsite)Job Duration: 12 Months + Possible extension Pay range: $60 - $65 an hourDepartment: Middleware EngineeringJob Category: Technology Description:Provide Primary DBA (Database Administration) responsibilities...

  • SQL Database Administrator

    1 month ago

    Salt Lake City, United States SPECTRAFORCE Full time

    Title: Sr. Microsoft SQL DatabaseDuration: 12 MonthsLocation: Salt Lake City, UTDuties:Provide Primary DBA (Database Administration) responsibilities including support of the various application development teams through advising on design, implementing solutions and optimizing databases for the applications.Working as a MS SQL Server (Microsoft’s Database...

  • SQL Database Administrator

    3 weeks ago

    Salt Lake City, United States Spectraforce Full time

    Title: Sr. Microsoft SQL DatabaseDuration: 12 MonthsLocation: Salt Lake City, UTDuties:Provide Primary DBA (Database Administration) responsibilities including support of the various application development teams through advising on design, implementing solutions and optimizing databases for the applications.Working as a MS SQL Server (Microsoft's Database...

  • Sr. Microsoft SQL Database Administrator

    2 weeks ago

    Salt Lake City, United States LanceSoft Full time

    Onsite 5 days a week Pay Range: $62 to $67/hr JOB DUTIES: Provide Primary DBA (Database Administration) responsibilities including support of the various application development teams through advising on design, implementing solutions and optimizing databases for the applications. Working as a MS SQL Server (Microsoft's Database offering) expert for the firm...

  • DataBase Administrator DataBase Administrator

    1 week ago

    Minnesota Lake, United States Kapital Data Corp Full time

    Iceberg's direct St. Paul, MN Client seeks a DataBase Administrator (DBA) who will be a member to the Infrastructure Team, will need to work closely with the Server System Engineers, and collaborate with other Client Enterprise teams. The resource will help migrate to new versions of SQL and ensure the availability and optimization of the current MSSQL 2008...

  • Sr. Microsoft SQL Database Administrator

    1 month ago

    Salt Lake City, United States SPECTRAFORCE Full time

    Title: Sr. Microsoft SQL DatabaseDuration: 12 MonthsLocation: Salt Lake City, UTDuties:Provide Primary DBA (Database Administration) responsibilities including support of the various application development teams through advising on design, implementing solutions and optimizing databases for the applications.Working as a MS SQL Server (Microsoft’s Database...

  • Sr. Data Engineer

    1 month ago

    Salt Lake City, United States ConsultNet Full time

    Sr. Data Engineer Salt Lake City, UT Long-term Contract: $70-$100 per hour Our client is in search of a to join their team on a long-term contract. Our client is looking for an experienced Engineer working on SQL databases hosted on Windows and Linux servers with a strong focus on database migration, re-platforming, and adoption of cloud...

  • Sr. Data Engineer

    1 week ago

    Salt Lake City, United States ConsultNet Full time

    Sr. Data Engineer Salt Lake City, UT Long-term Contract: $70-$100 per hour Our client is in search of a to join their team on a long-term contract. Our client is looking for an experienced Engineer working on SQL databases hosted on Windows and Linux servers with a strong focus on database migration, re-platforming, and adoption of cloud computing...

  • Sr. Data Engineer

    1 week ago

    Salt Lake City, United States ConsultNet Full time

    Sr. Data Engineer Salt Lake City, UT Long-term Contract: $70-$100 per hour Our client is in search of a to join their team on a long-term contract. Our client is looking for an experienced Engineer working on SQL databases hosted on Windows and Linux servers with a strong focus on database migration, re-platforming, and adoption of cloud computing...

  • Junior Database Administrator

    1 day ago

    Elizabeth City, North Carolina, United States CompQsoft Full time

    Job DescriptionJob Title: Database Specialist (Junior)Job Summary:We are seeking a highly skilled Database Specialist (Junior) to join our team at CompQsoft, Inc. As a key member of our IT department, you will be responsible for ensuring the effective management and administration of our databases.Key Responsibilities:Database Design and Implementation:...

  • Database Administrator

    4 weeks ago

    Oklahoma City, Oklahoma, United States ASRC Federal Full time

    Job DescriptionASRC Federal System Solutions supports the FAA NAS ESS (Federal Aviation Administration National Airspace System Engineering Support Services) contract. Join our growing team as a Database Administrator and Database Application Developer in support of the FAA's NAS Communication Air/Ground Communications and Recorders team. This team provides...

  • Database Administrator

    21 hours ago

    Elizabeth City, North Carolina, United States OBXtek Full time

    Job SummaryOBXtek is seeking a skilled Database Specialist to support our team in Elizabeth City, North Carolina. As a Database Specialist, you will play a critical role in the development and implementation of database systems, ensuring the security and integrity of our data.Key Responsibilities:Design and implement database systems, ensuring data security...

  • UDB/DB2 Database Administrator

    3 weeks ago

    Salt Lake City, United States ICONMA Full time

    Perform Database Administration Operational Support activities as part of the Firm's Technology Services Operations Team. Provide production support for Sybase Adaptive Server Enterprise, Sybase IQ, UDB DB2, Sybase Replication, UDB DB2 SQL Rep and Q Replication, Paraccel, Postgres, H

  • Data Warehouse Developer

    3 weeks ago

    Ohio City, United States codesbright Full time

    Responsiblties Gather and document business data requirements into data models and database designs. Work with project leads in analyzing system requirements and specifications and translating those requirements into database designs. Understand business requirements and perform data analysis estimation database programming testing and implementation....