SQL Database Developer

Job Description

• Design, develop, and optimize SQL queries, functions, triggers, and stored procedures in Postgre
  
  SQL for high‑volume enterprise applications.
• Collaborate with application and integration teams to support end‑to‑end delivery of data‑driven 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 root‑cause 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 Postgre
  
  SQL and associated data platforms.

Note:

The above job description and requirements are general and may change based on the specific needs and requirements of the organization and project.

• 5 years required:
  Experience as a Database Developer or similar role.
• 5 years required:
  Strong hands‑on expertise with Postgre
  
  SQL, including SQL, PL/pgSQL, stored procedures, triggers, indexing, and query optimization.
• 5 years required:
  Demonstrated experience working with large-scale, high-volume enterprise applications and mission critical data environments.
• 5 years required:
  Strong understanding of relational database design, normalization, and data modeling principles.
• 5 years required:
  Proficiency in performance tuning, execution plan analysis, and troubleshooting complex SQL behaviors.
• 5 years required:
  Experience working in Agile/Scrum teams and collaborating on multi-disciplinary project delivery.
• 5 years 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.
• 5 years required:
  Excellent problem‑solving and analytical skills.
• 5 years required:
  Ability to work in a fast‑paced environment with shifting priorities and multiple concurrent projects.
• 5 years required:
  Ability to work independently and as part of a team.

• 1 year preferred:
  Experience with ETL pipelines, data integration tools, and batch processing frameworks.
• 1 year preferred:
  Familiarity with CI/CD processes and database deployment automation.
• 1 year preferred:
  Exposure to cloud platforms (AWS, Azure, or similar) and managed Postgre
  
  SQL services.
• 1 year preferred:
  Experience supporting government or public sector systems.