Current jobs related to PostgreSQL DBA - Salt Lake City - Morph Enterprise

  • PostgreSQL Architect

    2 weeks ago


    Texas City, United States Pyramid Consulting Full time

    Immediate need for a talented PostgreSQL DBA . This is a 06+ Months contract opportunity with long-term potential and is located in Plano, TX (Onsite). Please review the job description below and contact me ASAP if you are interested. Job ID: 23-46159 Pay Range: $55 - $60/hour. Employee benefits include, but are not limited to, health insurance (medical,...


  • Jersey City, United States Laiba Technologies LLC Full time

    Job DescriptionJob DescriptionTitle :SQL DBA L4Location: Jersey City NJ Must have 15+ years of IT experience. Must have extensive experience working in large environment. Big financial customers domain experience is a plus. Extensive and very strong performance tuning. Must have strong experience in automation scripts. Please talk to the candidates as per...


  • 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...


  • 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...

  • Senior SQL DBA

    4 weeks ago


    Salt Lake City, United States Morph Enterprise Full time

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

  • Senior SQL DBA

    4 weeks ago


    Salt Lake City, United States Morph Enterprise Full time

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


  • 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...


  • 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....


  • Alexander City, United States augmentjobs Full time

    Overview: We are seeking a skilled and detailoriented Database Administrator (DBA) to join our team. As a DBA you will be responsible for the performance integrity and security of our databases. You will work closely with development teams system administrators and other stakeholders to ensure efficient database operations and data management. This role...


  • Lake Mary, United States LHH Full time

    Database Administrator IIHYBRID in Lake Mary, FloridaFully Remote Candidates will not be consideredCurrent Green Card Holders or US Citizens Only Database Administrator II is a function that together with the Database Manager will manage all aspects of database operations. As a Database Administrator II, you will manage all range of RDBMS in highly available...


  • Lake Mary, United States LHH Full time

    Database Administrator IIHYBRID in Lake Mary, FloridaFully Remote Candidates will not be consideredCurrent Green Card Holders or US Citizens Only Database Administrator II is a function that together with the Database Manager will manage all aspects of database operations. As a Database Administrator II, you will manage all range of RDBMS in highly available...


  • Jersey City, United States Raas Infotek Full time

    Job Title - SQL DBALocation – Jersey City NJ(Onsite)Type- Contract Job Description:Must have 15+ years of IT experience.Must have extensive experience working in large environment.Big financial customers domain experience is a plus.Extensive and very strong performance tuning.Must have strong experience in automation scripts. Please talk to the candidates...


  • Jersey City, United States Raas Infotek Full time

    Job Title - SQL DBALocation – Jersey City NJ(Onsite)Type- Contract Job Description:Must have 15+ years of IT experience.Must have extensive experience working in large environment.Big financial customers domain experience is a plus.Extensive and very strong performance tuning.Must have strong experience in automation scripts. Please talk to the candidates...

PostgreSQL DBA

1 month ago


Salt Lake City, United States Morph Enterprise Full time

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 services. The ideal candidate will lead our transition from Informix to a more modern, mainstream database management system; PostgreSQL hosted on AWS cloud services to enhance our data processing capabilities and support future scalability and performance needs. The chosen candidate will also provide interim database maintenance, support, and administration supporting various applications while cross-training in-house support staff to assume those duties and responsibilities long term.

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

  • 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 requirements and performance goals.
  • Lead the migration process, including data cleansing, migration scripting, data validation, and post-migration testing.
  • Collaborate with IT teams to ensure smooth integration with other enterprise applications.
  • Monitor system performance post-migration and optimize as needed to meet performance targets and provide ongoing maintenance, support, database integrity, troubleshooting, performance assessments, and enhancements in database services.
  • Develop and enforce best practices for database management, security measures, and disaster recovery plans.
  • Document all processes related to database migration and routine maintenance as well as documentation of existing database systems.

  • Lead database designs and development for applications based on user requirements and specifications provided by Business or Technical Leads.
  • Build, migrate, and maintain databases for on-premise and cloud services systems.
  • Assist the Technical Project Leads in addressing technical issues.
  • Submit all test and production turnovers to Project Technical Lead to be installed.
  • Provide data modeling support to development projects, as needed.
  • Assist application developers with complex query development and tuning.
  • Create database tables, indexes, constraints, stored procedures, and other database components and functions.
  • Prepare, deliver, install, and upgrade software databases into development, quality assurance, and production environments.
  • Design, implement, and enforce strong security structures and mechanisms for databases.
  • Create and update data schematics and dictionary structures to document and describe system databases, interfaces, and security.
  • Design, create, install, and manage automated databases, data reports and chronological report runs.
  • Perform data validation to test the integrity of data, database relationships, calculations, references, and data reports.
  • Participate in the development of system database standards and development processes.
  • Interact with and support project leaders and teams, business analysts, and users in analysis, design, and testing processes on projects.
  • Coordinate with System Administrators on database installations, upgrades, releases, problem solutions, and technical architecture changes.
  • Accommodate work that needs to be performed both during and after business hours.
  • Other tasks as assigned.