SQL DBA with GCP/BigQuery

3 weeks ago

Los Angeles, United States Cyborgwave Full time
Job DescriptionJob DescriptionPosition:& Data Warehouse Database AdministratorClient: State of& UtahDepartment: UDCLocation:& 8523 S. Redwood Rd, West Jordan, Utah 84088Position ID:& 133935Projected 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 remote& Job 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 GCP& 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 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.& & 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.& •& & & & & & & & & & & & The amount listed on this scope of work is a current project budget. Additional funding can be added by the requesting agency by amendment to the scope of work. Contractors must not allow work to continue that will cost more than the allowed budget without an amendment first being approved.•& & & & & & & & & & & & The position/project duration listed on the scope of work may be extended by the requesting agency by amendment to the scope of work for a time period up to a total of 5 years. Contractors must not allow any work to be done after the end date without an amendment first being approved.PLEASE NOTE AND PROVIDE TO YOUR CONTRACTORS: ? All consultants hired will be required to follow the DTS 2000-0017 Drug Free Workplace Policy and all Utah drug laws.&

  • Data Engineer

    3 weeks ago

    Los Angeles, United States FILD Search, LLC Full time

    Are you a Data Engineer looking for a growth opportunity with a leading Digital Marketing and Big Data Technology company? Are you a Data Engineer who has a strong skill set in SQL, ETL, Talend, and GCP or AWS, and want to help transform how data influences top brands? Are you a Data Engineer who's worked with real-time streaming or AdTech and are eager to...

  • Data Engineer

    3 weeks ago

    Los Angeles, United States FILD Search, LLC Full time

    Are you a Data Engineer looking for a growth opportunity with a leading Digital Marketing and Big Data Technology company? Are you a Data Engineer who has a strong skill set in SQL, ETL, Talend, and GCP or AWS, and want to help transform how data influences top brands? Are you a Data Engineer who's worked with real-time streaming or AdTech and are eager to...

  • Data Engineer

    1 day ago

    Los Angeles, United States FILD Search, LLC Full time

    Are you a Data Engineer looking for a growth opportunity with a leading Digital Marketing and Big Data Technology company? Are you a Data Engineer who has a strong skill set in SQL Syntax, ETL, Talend, and GCP, and want to help transform how data influences top brands? Are you a Data Engineer who's worked with real-time streaming or AdTech and are eager to...

  • BI Engineer

    9 hours ago

    Los Angeles, United States FILD Search, LLC Full time

    Are you a Business Intelligence Engineer looking for a growth opportunity with a leading Digital Marketing and Big Data Technology company? Are you a BI Engineer who has a strong skill set in SQL Syntax, ETL, Talend, and GCP, and want to help transform how data influences top brands? Are you a BI Engineer who's worked with real-time streaming or AdTech and...

  • Onsite Junior Technical Specialist, SQL, Scripting, Entry Level

    3 months ago

    Los Angeles, United States Intelliswift Software Full time

    Location: Los Angeles, CAType: ContractTitle: Onsite Junior Technical Specialist, SQL, Scripting, Entry LevelDescription:Onsite Junior Technical Specialist, SQL, Scripting for a contract, possibly to hire position. This is an Entry Level to Junior role – 6 months to 2 years of experience. This position is onsite (hybrid), 3-4 days onsite a week.This...

  • Onsite Junior Technical Specialist, SQL, Scripting, Entry Level

    3 months ago

    Los Angeles, United States Intelliswift Software Full time

    Location: Los Angeles, CAType: ContractTitle: Onsite Junior Technical Specialist, SQL, Scripting, Entry LevelDescription:Onsite Junior Technical Specialist, SQL, Scripting for a contract, possibly to hire position. This is an Entry Level to Junior role – 6 months to 2 years of experience. This position is onsite (hybrid), 3-4 days onsite a week.This...

  • Senior Python Developer

    3 months ago

    Los Angeles, United States Bitcoin Devs Company Full time

    Job DescriptionJob DescriptionOverviewAs a Senior Software Engineer II, Lead, you will be responsible for designing, developing, and maintaining software solutions that meet the needs of our organization and our clients. You will work closely with cross-functional teams to understand requirements, propose solutions, and deliver high-quality software...

  • System Administrator/Junior DBA

    3 weeks ago

    Los Angeles, United States Diamond Game Full time $85,000 - $105,000

    Job DescriptionJob DescriptionWHY DIAMOND GAME?When you work at Diamond Game you are part of a diverse, forward thinking, technology focused gaming organization. Diamond Game employees work alongside one another as part of an engaged team, making contributions at all levels to ensure the highest quality and standards.As a Diamond Game employee, you are...

  • System Administrator/Junior DBA

    3 weeks ago

    Los Angeles, United States Diamond Game Full time $85,000 - $105,000

    Job DescriptionJob DescriptionWHY DIAMOND GAME?When you work at Diamond Game you are part of a diverse, forward thinking, technology focused gaming organization. Diamond Game employees work alongside one another as part of an engaged team, making contributions at all levels to ensure the highest quality and standards.As a Diamond Game employee, you are...

  • Junior Software Engineer

    2 weeks ago

    Los Angeles, California, United States Jobot Full time

    About UsWe are the leading online invitation platform, dedicated to transforming the way events are planned and celebrated. Our commitment to innovation has allowed us to grow significantly since our establishment in 1998, now serving millions of users globally.Why Work With Us?We offer an exceptional work-life balance with unlimited PTO and a supportive...

  • Senior Software Engineer

    2 days ago

    Los Angeles, California, United States Jobot Full time

    About UsJobot is a leading digital invitation company, revolutionizing the way people plan and host events. With a strong focus on innovation and user satisfaction, we have established ourselves as a trusted name in the industry.Job SummaryWe are seeking a highly skilled Senior Software Engineer to join our team. As a key member of our development team, you...

  • Lead Python Software Engineer

    2 weeks ago

    Los Angeles, California, United States Bitcoin Devs Company Full time

    Position OverviewWe are seeking an experienced Lead Python Software Engineer to play a pivotal role in our organization. This position involves leading the design, development, and maintenance of innovative software solutions tailored to meet the demands of our clients and the business.Primary Responsibilities:Architecting, developing, and sustaining...

  • Data Engineer

    4 weeks ago

    Los Angeles, United States Robert Half Full time

    A leading Los Angeles-based agency is seeking a talented Data Engineer to join their team in developing cutting-edge industry specific technology. Our client is looking for a highly motivated, web-focused engineer with experience in the full data life cycle. In this role, you will design data science programs, personas, machine learning models, and...

  • Data Engineer

    4 weeks ago

    Los Angeles, United States Robert Half Full time

    A leading Los Angeles-based agency is seeking a talented Data Engineer to join their team in developing cutting-edge industry specific technology. Our client is looking for a highly motivated, web-focused engineer with experience in the full data life cycle. In this role, you will design data science programs, personas, machine learning models, and...

  • Ecommerce Product Strategist

    1 week ago

    Los Angeles, California, United States Pyramid Consulting, Inc Full time

    We are currently seeking a skilled Product Manager for a 12+ months contract opportunity with potential for long-term engagement. This role is positioned within a dynamic and innovative environment.Job ID: Compensation: $52 - $58/hour. Employee benefits include health insurance (medical, dental, vision), a 401(k) plan, and paid sick leave, depending on work...

  • Ecommerce Product Strategist

    2 weeks ago

    Los Angeles, California, United States Pyramid Consulting, Inc Full time

    We are currently seeking a skilled Product Manager for a significant contract opportunity with potential for long-term engagement. This role is pivotal in overseeing the Ecommerce lifecycle and is ideal for candidates with a robust background in product management.Job ID: Compensation: $52 - $58/hour. Employee benefits encompass health insurance (medical,...

  • Product Manager

    1 month ago

    Los Angeles, United States Pyramid Consulting, Inc Full time

    Immediate need for a talented Product Manager. This is a 12+ months contract opportunity with long-term potential and is located in Los Angeles, CA(Hybrid). Please review the job description below and contact me ASAP if you are interested.Job ID: 24-36272Pay Range: $52 - $58/hour. Employee benefits include, but are not limited to, health insurance (medical,...

  • Product Manager

    1 month ago

    Los Angeles, United States Pyramid Consulting, Inc Full time

    Immediate need for a talented Product Manager. This is a 12+ months contract opportunity with long-term potential and is located in Los Angeles, CA(Hybrid). Please review the job description below and contact me ASAP if you are interested.Job ID: 24-36272Pay Range: $52 - $58/hour. Employee benefits include, but are not limited to, health insurance (medical,...

  • Data Engineer II

    3 months ago

    Los Angeles, United States Riot Games Full time

    Data Engineers at Riot bring deep knowledge of specific technical areas and also value the opportunity to work in many broader domains. Our engineers are player-focused and aim to find solutions that make players excited to experience our games. Senior Engineers, at Riot, are often called on to help with the hardest problems on a project by using their...

  • Data Engineer II

    3 months ago

    Los Angeles, California, United States Riot Games Full time

    Data Engineers at Riot bring deep knowledge of specific technical areas and also value the opportunity to work in many broader domains. Our engineers are player-focused and aim to find solutions that make players excited to experience our games. Senior Engineers, at Riot, are often called on to help with the hardest problems on a project by using their...