Job Description :
We are looking for an experienced PostgreSQL Database Developer to join our dynamic team. The ideal candidate will be responsible for the design development and maintenance of PostgreSQL databases in a high-performance scalable environment. You will work closely with other teams to build manage and optimize databases to meet business needs and ensure system efficiency.
Key Responsibilities :
Design and implement efficient database structures using PostgreSQL ensuring scalability availability and security.
Write complex SQL queries stored procedures and triggers to support business logic and application performance.
Design and implement database schemas and data models for enterprise-level applications.
Optimize queries and database performance using techniques such as indexing partitioning and query rewriting.
Collaborate with development teams to integrate PostgreSQL with applications and resolve data issues.
Maintain and enhance PostgreSQL databases ensuring they run efficiently are properly maintained and meet the required SLAs.
Develop backup and recovery strategies to ensure data integrity and system reliability.
Monitor database performance troubleshoot issues and implement tuning strategies.
Work on database migrations including data migration schema changes and version control for databases.
Provide expert-level support in PostgreSQL architecture maintenance and troubleshooting.
Ensure database security by implementing access controls encryption and backup / recovery solutions.
Collaborate with DevOps teams to automate and manage database deployments in cloud environments like AWS Azure or GCP.
Implement data integrity and ensure adherence to data governance standards.
Skills & Qualifications :
Proven experience as a PostgreSQL Database Developer / Administrator.
Strong knowledge of PostgreSQL architecture and management.
Proficient in writing advanced SQL queries PL / pgSQL and developing stored procedures and triggers.
Experience with performance tuning query optimization and database indexing strategies.
Knowledge of database replication clustering and high-availability setups in PostgreSQL.
Experience with backup and recovery solutions including PITR (Point In Time Recovery).
Proficiency in data modeling and schema design.
Experience working with PostgreSQL on cloud platforms (AWS Azure GCP) is a plus.
Familiarity with PostgreSQL extension tools like PostGIS (for GIS applications) or Foreign Data Wrappers.
Experience with CI / CD pipelines for database changes using tools like Jenkins GitLab CI etc.
Familiarity with Linux / Unix environments and shell scripting.
Good understanding of database security principles including user roles permissions and encryption.
Excellent problem-solving skills and the ability to work in a fast-paced collaborative environment.
Bachelors degree in Computer Science Information Technology or a related field (or equivalent experience).
Key Skills
Cost Accounting,Credit Risk,Attorney At Law,HRMS,Administration Support
Employment Type : Full Time
Experience : years
Vacancy : 1
Postgresql Database • St. Louis, Missouri, USA