Talent.com
PostgreSQL Developer - L2
PostgreSQL Developer - L2Bharathcloud • Aurora, CO, US
PostgreSQL Developer - L2

PostgreSQL Developer - L2

Bharathcloud • Aurora, CO, US
job_description.job_card.variable_days_ago
serp_jobs.job_preview.job_type
  • serp_jobs.job_card.full_time
job_description.job_card.job_description

We are seeking a skilled and experienced PostgreSQL Developer (Level 2) with 4–5 years of hands-on experience in database development and optimization. The ideal candidate will be responsible for developing, maintaining, and improving PostgreSQL-based database solutions, supporting high-performance applications, and assisting with architecture and automation initiatives.

Key Responsibilities :

  • Design, develop, and optimize complex SQL queries, stored procedures, triggers, and PL / pgSQL functions.
  • Collaborate with architects and application developers to define efficient schema designs and data models.
  • Perform advanced performance tuning using EXPLAIN, ANALYZE, pg_stat_statements, and indexing strategies.
  • Implement and maintain ETL processes for structured and semi-structured data.
  • Manage large-scale data migrations and version-controlled schema deployments.
  • Conduct capacity planning and monitoring to maintain database health and scalability.
  • Implement and manage backup / restore policies, disaster recovery testing, and high availability configurations.
  • Work with DevOps teams to integrate database changes into CI / CD pipelines.
  • Mentor junior developers and participate in peer code reviews.

Technical Skills Required :

  • Strong expertise in PostgreSQL SQL and PL / pgSQL programming.
  • In-depth understanding of PostgreSQL internals : query planner, indexing, vacuum / analyze, and WAL.
  • Experience with partitioning, parallel queries, table inheritance, and advanced types (JSONB, ARRAY).
  • Proficient with performance tuning, database normalization / denormalization, and query optimization.
  • Experience with replication mechanisms : streaming replication, logical replication, or BDR.
  • Good knowledge of PostgreSQL backup and recovery strategies using pg_basebackup, pgBackRest, or Barman.
  • Experience with monitoring tools like pg_stat_activity, pgBadger, Prometheus + Grafana, or Zabbix.

    • Preferred / Additional Skills :

  • Scripting experience (Bash, Python, or Shell) for automation tasks.
  • Familiarity with cloud-native PostgreSQL (AWS RDS, Aurora, GCP Cloud SQL, Azure PostgreSQL).
  • Exposure to Kubernetes-managed database environments.
  • Experience working in Agile environments and participating in Scrum ceremonies.

    • Soft Skills :

  • Excellent problem-solving and root cause analysis capabilities.
  • Strong written and verbal communication.
  • Ability to work independently and as part of a cross-functional team.
  • Mentorship and collaboration with junior team members.
  • Customer-focused and able to manage multiple priorities in a fast-paced environment.

    • Education :

  • Bachelor's degree in Computer Science, Information Technology, or related discipline.
  • PostgreSQL certifications (optional but a plus).

    • J-18808-Ljbffr

    serp_jobs.job_alerts.create_a_job

    Developer Postgresql • Aurora, CO, US

    Job_description.internal_linking.related_jobs
    GIS Developer

    GIS Developer

    VirtualVocations • Lakewood, Colorado, United States
    serp_jobs.job_card.full_time
    A company is looking for a GIS Developer (Artificial Intelligence Analyst).Key Responsibilities Support the client's Resource Uses, Decisions, and Description (RUDD) Program by creating a Small L...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    GCP Cloud Subject Matter Expert

    GCP Cloud Subject Matter Expert

    VirtualVocations • Arvada, Colorado, United States
    serp_jobs.job_card.full_time
    A company is looking for a GCP Cloud SME (Subject Matter Expert).Key Responsibilities : Design and deliver cloud-based architectures and microservices solutions on Google Cloud Platform (GCP) Dev...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
    Power Platform Developer

    Power Platform Developer

    VirtualVocations • Littleton, Colorado, United States
    serp_jobs.job_card.full_time
    A company is looking for a Power Platform Developer to join their engineering team.Key Responsibilities Design, build, and maintain solutions using Power Apps, Power Automate, Power BI, and Datav...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    SAP CPS Developer

    SAP CPS Developer

    VirtualVocations • Arvada, Colorado, United States
    serp_jobs.job_card.full_time
    A company is looking for an Application Support Engineer.Key Responsibilities Develop, configure, and maintain SAP CPS integration between S / 4HANA and SAP CPQ Ensure consistent and accurate data...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
    Mid-Level Developer

    Mid-Level Developer

    VirtualVocations • Denver, Colorado, United States
    serp_jobs.job_card.full_time
    A company is looking for a Mid-Level Developer (Survivor Portal).Key Responsibilities Develop and enhance front-end and back-end modules for the Survivor Portal Implement responsive user interfa...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    Senior Integration Developer

    Senior Integration Developer

    VirtualVocations • Denver, Colorado, United States
    serp_jobs.job_card.full_time
    A company is looking for a Senior Integration Developer to lead the design, implementation, and sustainment of secure data and application integrations. Key Responsibilities Design, develop, and m...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    SQL Developer

    SQL Developer

    VirtualVocations • Denver, Colorado, United States
    serp_jobs.job_card.full_time
    A company is looking for a SQL Developer (Contract) to work remotely.Key Responsibilities Design, develop, and maintain SQL databases and applications Execute complex queries and optimize databa...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    Informatica Developer

    Informatica Developer

    VirtualVocations • Littleton, Colorado, United States
    serp_jobs.job_card.full_time
    A company is looking for an Informatica Developer.Key Responsibilities Convert ETL processes from Data Manager to Informatica and maintain ETL processes for data integration Deploy, upgrade, and...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    Database Developer

    Database Developer

    VirtualVocations • Littleton, Colorado, United States
    serp_jobs.job_card.full_time
    A company is looking for a Database Developer (SQL, DB2, Linux).Key Responsibilities Manage and administer SQL Server databases in both Windows and Linux environments Implement data models and m...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    Internal Applications Developer

    Internal Applications Developer

    VirtualVocations • Arvada, Colorado, United States
    serp_jobs.job_card.full_time
    A company is looking for an Internal Applications Developer to create internal open source tools for employees.Key Responsibilities Develop and design robust and scalable software solutions using...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
    Oracle SQL Developer with Public Trust

    Oracle SQL Developer with Public Trust

    VirtualVocations • Lakewood, Colorado, United States
    serp_jobs.job_card.full_time
    A company is looking for an Oracle SQL Developer to support the modernization of a legacy system.Key Responsibilities Design and develop Oracle PL / SQL packages, stored procedures, and functions f...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
    Senior ETL Developer

    Senior ETL Developer

    VirtualVocations • Lakewood, Colorado, United States
    serp_jobs.job_card.full_time
    A company is looking for a Senior ETL Developer to join their team.Key Responsibilities Design, create, and enhance EDI and ETL processes to support internal teams and business functions Adminis...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    Shopify Developer

    Shopify Developer

    VirtualVocations • Denver, Colorado, United States
    serp_jobs.job_card.full_time
    A company is looking for a Shopify Developer to join a fast-growing eCommerce team focused on building high-performing online shopping experiences. Key Responsibilities Design and build scalable S...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted
    UKG Systems Analyst

    UKG Systems Analyst

    Creative Financial Staffing • Lafayette, CO, US
    serp_jobs.job_card.full_time
    Hybrid (Mon-Wed in office, every other week remote).This position requires deep system knowledge, analytical accuracy, and the ability to identify and resolve data and integration issues across HR,...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_1_day • serp_jobs.job_card.promoted
    Senior DevOps Developer

    Senior DevOps Developer

    ManTech • Denver, CO, US
    serp_jobs.job_card.full_time
    MANTECH seeks a motivated, career and customer-oriented .This role supports key development efforts and will contribute to building scalable, high-quality solutions that align with mission needs.Re...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
    Client Success Developer

    Client Success Developer

    VirtualVocations • Arvada, Colorado, United States
    serp_jobs.job_card.full_time
    A company is looking for a Client Success Developer.Key Responsibilities Launch and support subscription brands, impacting millions of users Code, write unit tests, and collaborate with a team o...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
    Remote Senior Backend Developer

    Remote Senior Backend Developer

    VirtualVocations • Littleton, Colorado, United States
    serp_jobs.filters.remote
    serp_jobs.job_card.full_time
    A company is looking for a Remote Senior Backend Developer for New Gen AI Product Development.Key Responsibilities Design and implement a scalable and secure CDA data platform optimized for AI-dr...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
    GoLang Developer II

    GoLang Developer II

    VirtualVocations • Denver, Colorado, United States
    serp_jobs.job_card.full_time
    A company is looking for a GoLang Developer II with experience in AWS and microservices.Key Responsibilities Contribute to development tasks across various projects Participate in support activi...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
    Developer II

    Developer II

    VirtualVocations • Arvada, Colorado, United States
    serp_jobs.job_card.full_time
    A company is looking for a Developer II to provide complex technical support and enhance data processing systems.Key Responsibilities Develop and enhance software and procedures to improve proces...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_variable_days • serp_jobs.job_card.promoted
    BI Developer

    BI Developer

    VirtualVocations • Littleton, Colorado, United States
    serp_jobs.job_card.full_time
    A company is looking for a BI Developer.Key Responsibilities Develop and fine-tune IT solutions, including coding, testing, debugging, and implementing tools Research and plan solutions for exis...serp_jobs.internal_linking.show_more
    serp_jobs.last_updated.last_updated_30 • serp_jobs.job_card.promoted