PostgreSQL DB Developer

Sriven Systems Inc.
Texas City, United States of America
2 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Texas City, United States of America

Tech stack

Batch Processing
Code Review
Databases
Continuous Integration
Data Governance
Data Infrastructure
Data Integration
ETL
Relational Databases
Database Development
PostgreSQL
Performance Tuning
Scrum
Query Optimization
SQL Stored Procedures
SQL Databases
Data Streaming
Enterprise Software Applications
Database Optimization
Indexer
Data Management
Data Inconsistencies

Job description

  • Design, develop, and optimize SQL queries, functions, triggers, and stored procedures in PostgreSQL for highvolume enterprise applications.
  • Collaborate with application and integration teams to support endtoend delivery of datadriven solutions.
  • Analyze complex datasets and data flows to ensure reliability, integrity, and accuracy across systems.
  • Lead performance tuning initiatives, including indexing strategies, query refactoring, and database optimization techniques.
  • Support data modeling activities, ensuring alignment with enterprise architecture and application scalability needs.
  • Troubleshoot database issues and provide rootcause analysis for performance bottlenecks and data inconsistencies.
  • Participate in code reviews, design sessions, and sprint planning as part of an Agile delivery team.
  • Ensure all database objects and processes adhere to agency policies, data governance standards, and compliance requirements.
  • Assist in migration, upgrade, and modernization efforts involving PostgreSQL and associated data platforms., Experience as a Database Developer or similar role.

5

Required

Strong hands-on expertise with PostgreSQL, including SQL, PL/pgSQL, stored procedures, triggers, indexing, and query optimization.

5

Required

Demonstrated experience working with large-scale, high-volume enterprise applications and mission critical data environments.

5

Required

Strong understanding of relational database design, normalization, and data modeling principles.

5

Required

Proficiency in performance tuning, execution plan analysis, and troubleshooting complex SQL behaviors.

5

Required

Experience working in Agile/Scrum teams and collaborating on multi-disciplinary project delivery.

5

Required

Foster effective collaboration and communication within the project team, including developers, testers, and stakeholders. Actively participate in meetings, discussions, and code reviews to ensure alignment and efficient workflow.

Requirements

Ability to work in a fast-paced environment with shifting priorities and multiple concurrent projects.

5

Required

Ability to work independently and as part of a team.

1

Preferred

Experience with ETL pipelines, data integration tools, and batch processing frameworks.

1

Preferred

Familiarity with CI/CD processes and database deployment automation.

Apply for this position