Jobs
>
Dallas

    Data Architect with Postgres - Dallas, TX, United States - Tanisha Systems, Inc.

    Tanisha Systems, Inc.
    Tanisha Systems, Inc. Dallas, TX, United States

    2 weeks ago

    Default job background
    Technology / Internet
    Description
    Job Role:
    Data Architect with Postgres
    Location:
    Austin or Dallas TX (Onsite)

    Hire Type:
    FTE/Permanent

    Job Description:

    As a data architect working with PostgreSQL, you play a pivotal role in designing, implementing, and optimizing the database infrastructure to meet the organization's needs.

    Here's an overview of your responsibilities and some best practices:

    1.


    Database Design:
    You are responsible for designing the database schema to ensure efficient storage, retrieval, and manipulation of data. This involves understanding the data requirements, normalization principles, and denormalization where necessary for performance optimization.

    2.


    Performance Tuning:
    PostgreSQL offers a plethora of features for performance optimization such as indexing, query optimization, and partitioning.

    You need to analyze query performance using EXPLAIN and EXPLAIN ANALYZE, identify bottlenecks, and optimize queries and database configuration accordingly.


    3.


    Data Modeling:
    You create data models that reflect the business requirements and ensure data integrity and consistency. This involves defining tables, relationships, constraints, and data types to accurately represent the data.

    4.


    High Availability and Disaster Recovery:

    Implementing strategies for high availability and disaster recovery is crucial to ensure the database remains accessible and data loss is minimized in case of failures.

    This may involve setting up replication, failover mechanisms, and backups.

    5.


    Security:
    Ensuring the security of the database is paramount. This includes setting up user authentication, authorization, and implementing encryption for data at rest and in transit. Regular security audits and updates are necessary to mitigate vulnerabilities.

    6.


    Data Migration and Integration:
    You might need to migrate data from legacy systems or integrate with other systems. This requires careful planning, data cleansing, and transformation to ensure data consistency and integrity.

    7.


    Scalability:
    As the organization grows, the database needs to scale to handle increased load. You design scalable architectures using techniques like sharding, clustering, or scaling vertically/horizontally.

    8.


    Monitoring and Maintenance:

    Regular monitoring of database health, performance metrics, and proactive maintenance are essential to prevent issues and ensure optimal performance.

    This involves setting up monitoring tools, alerts, and performing routine maintenance tasks like vacuuming and analyzing logs.

    9.


    Documentation:

    Documenting the database schema, configurations, procedures, and best practices is important for knowledge sharing and maintaining consistency across the team.


    10.


    Continuous Learning and Improvement:
    PostgreSQL is constantly evolving with new features and improvements.

    As a data architect, you need to stay updated with the latest advancements, best practices, and community resources to continually improve the database infrastructure.

    By excelling in these areas, you can ensure that the PostgreSQL database meets the organization's needs for reliability, performance, and scalability.

  • Iris Software Inc.

    Postgres DBA

    6 days ago

    Iris Software Inc. Dallas, United States

    Iris's client, one of the world's largest multinational investment banking and financial services corporation is looking to hire a Postgres DBA in Dallas, TX /Austin, TX. · Our direct client is a is a world-leading financial services company, provides consumers, corporations, gov ...

  • Iris Software

    Postgres DBA

    1 day ago

    Iris Software Dallas, United States

    Iris's client, one of the world's largest multinational investment banking and financial services corporation is looking to hire a Postgres DBA in Dallas, TX /Austin, TX. · Our direct client is a is a world-leading financial services company, provides consumers, corporations, go ...

  • Diverse Lynx

    Postgres DBA

    4 days ago

    Diverse Lynx Dallas, United States

    Job Title: Postgres DBA · Location:Dallas, Texas (Onsite) · Type : Full Time Employment · Job Description: · Work independently with vendor and guide Ops team. · Point of Contact support for any major incident escalation · Perform architecture reviews and aid application te ...

  • Copart

    Sr. Postgres database administration

    1 week ago

    Copart Dallas, United States

    Copart is seeking an experienced Sr. Database Administrator (DBA) to manage PostgreSQL & MariaDB/MySQL Database environments running on Linux OS platform, including support of DB software and maintaining DB instances and databases. The DBA collaborates with Application Developmen ...

  • Copart

    Sr. Postgres database administration

    4 days ago

    Copart Dallas, United States

    Copart is seeking an experienced Sr. Database Administrator (DBA) to manage PostgreSQL & MariaDB/MySQL Database environments running on Linux OS platform, including support of DB software and maintaining DB instances and databases. The DBA collaborates with Application Developmen ...

  • Diverse Lynx

    Sr. Postgres DBA

    5 days ago

    Diverse Lynx Irving, United States

    Job Title: Sr.Postgres DBA · Location:(Remote100%) · Duration: (Contract) · Essential Responsibilities:Role: Sr.DBA (Postgres, Data Modeling ,Data migration, cloud migration) · Proven working experience as a Database Administrator with Postgres, MySQL etc. · Install and mainta ...

  • ALLTAKE LLC

    MySQL, Postgres and MongoDB DBA

    2 weeks ago

    ALLTAKE LLC Plano, United States

    Position: MySQL, Postgres and MongoDB DBA · Location: Remote · Contract · Job Description · Database Administrator with expertise in MySQL, Postgres and MongoDB. Should able to handle other DBs like MySQL, Postgres, MongoDB. · Design, deploy, and maintain databases on OCI to ...

  • Tucker Parker Smith Group (TPS Group)

    Senior Database Administrator

    2 weeks ago

    Tucker Parker Smith Group (TPS Group) Dallas, United States

    Aurora Postgres Database Administrator · Location: California (remote) · Pay Rate: $87.59/hr. · 6-month assignment (potential to extend) · Our leading ride share client is looking for a Postgres database administrator that will ensure reliability, scalability, security, and cost ...

  • Tucker Parker Smith Group

    Senior Database Administrator

    2 weeks ago

    Tucker Parker Smith Group Dallas, United States

    Aurora Postgres Database Administrator · Location: California (remote) · Pay Rate: $87.59/hr. · 6-month assignment (potential to extend) · Our leading ride share client is looking for a Postgres database administrator that will ensure reliability, scalability, security, and ...

  • Tucker Parker Smith Group

    Senior Database Administrator

    2 weeks ago

    Tucker Parker Smith Group Dallas, United States

    Aurora Postgres Database Administrator · Location: California (remote) · Pay Rate: $87.59/hr. · 6-month assignment (potential to extend) · Ensure you read the information regarding this opportunity thoroughly before making an application. · Our leading ride share client is ...

  • Turing IT Labs

    Data Modeler

    2 weeks ago

    Turing IT Labs Dallas, TX, United States

    Data modeling · Dallas, TX · Hybrid · RDBMS experience with Erwin data modeling, · DB2, snowflake and mysql or postgres · table modeling experience · AWS cloud experience · Data Modeler - Local to Dallas, TX ...

  • Yoh, A Day & Zimmermann Company

    Senior Python Developer

    1 week ago

    Yoh, A Day & Zimmermann Company Dallas, United States

    Senior Python/Django/AWS Developer · Direct Hire (U.S. Citizen/GC ONLY) · 100% Remote (CST ONLY) · We are looking for an experienced Senior Python Developer with a strong background in the Django framework and a keen interest in the financial services industry. The ideal candidat ...

  • Bayone

    Java Developer

    5 days ago

    Bayone Dallas, United States

    4-6 Years of IT / Java Development exp. · 4+ years as a developer using Java and frameworks such a Spring Boot and Spring Cloud · Min 3 year's Experience with microservice design and development. · Experience designing and developing cloud-native, scalable, and highly availabl ...

  • Piper Companies

    Full Stack Software Engineer

    2 days ago

    Piper Companies Dallas, United States

    Piper Companies is seeking an experienced Full Stack Software Engineer which will be part of a team responsible for the development and maintenance of software. This person will play a crucial role in designing, developing, and maintaining the backend components of web applicatio ...

  • Code Report

    Java Software Engineer

    1 week ago

    Code Report Dallas, United States

    Skills to be familiar with: · Mid-level candidates welcome to apply · Java - (Minimum Version 8) · Experience Spring Framework (Spring MVC, Spring Boot, Spring Batch etc.) · Rest APIs understanding and designing · Any Database experience: Relational (Oracle, SQL Server, Postgres) ...

  • Code Report

    Java Software Engineer

    2 days ago

    Code Report Dallas, United States

    Skills to be familiar with: · 0-1 years welcome to apply · Java - (Minimum Version 8) · Experience Spring Framework (Spring MVC, Spring Boot, Spring Batch etc.) · Rest APIs understanding and designing · Any Database experience: Relational (Oracle, SQL Server, Postgres) or No SQL ...

  • Piper Companies

    Full Stack Software Engineer

    4 days ago

    Piper Companies Dallas, United States

    Piper Companies is seeking an experienced Full Stack Software Engineer whichwill be part of a team responsible for the development and maintenance of software. This person will play a crucial role in designing, developing, and maintaining the backend components of web application ...

  • Ampstek

    MuleSoft Developer(Telecom Domain experience)

    5 days ago

    Ampstek Dallas, United States

    Role :: MuleSoft Developer(Telecom Domain experience) · Location :: Atlanta, GA/Dallas, TX(Onsite) · Type :: Contract · Primary skills: · o Required to have minimum 8+ years of development experience. · o Lead MuleSoft development projects, ensuring high quality integration solut ...

  • Wells Fargo

    Lead Database Engineer

    1 day ago

    Wells Fargo Dallas, United States

    Be a lead database engineer, specifically with highest technical expertise in design, administration, high availability, and operational support experience with the next generation database platforms like MongoDB, Postgre. SQL, Yugabyte. DB, will joi Database Engineer, Database, ...

  • TEPHRA

    Full Stack Java Developer

    5 days ago

    TEPHRA Dallas, United States

    : · Minimum Qualifications: 7+ year's professional experience in Software Development · Proficiency in Front-end Coding and Design (JavaScript, CSS, HTML, jQuery, and libraries or frameworks such as React, Angular, Backbone) · Proficiency in Back-end Coding and Design (JAVA, . ...