Postgresql Developer
- Centilytics
- 2 - 4 years
- Noida, Gurugram
- 2 months ago
- Email to a friend
- Report this job
Job Description
Job Overview:
We are seeking a talented PostgreSQL Developer with 2-4 years of experience to join our data engineering or application development team. The ideal candidate will demonstrate strong expertise in database development on PostgreSQL, including schema design, writing and optimizing complex queries, and supporting data-driven applications. The role also encompasses providing 24 by 7 support as per business need, including planned and scheduled activities during weekends or night hours.
Key Responsibilities:
- Design, develop, and maintain relational database structures, including tables, views, indexes, and constraints in PostgreSQL.
- Write efficient SQL and PL/pgSQL functions, stored procedures, and triggers to support application logic and business requirements.
- Optimize and refactor queries for performance, ensuring minimal latency and efficient resource consumption.
- Collaborate with backend and application developers to translate business requirements into scalable database solutions.
- Assist with data migration, ETL, and integration tasks between various sources and PostgreSQL.
- Enforce data integrity, security, and compliance best practices throughout the database lifecycle.
- Monitor and troubleshoot database performance, identify bottlenecks, and propose solutions.
- Participate in database version control and release management following established SDLC practices.
- Contribute to documentation of database structures, processes, and procedures.
- Support production issues, analyze and resolve database-related bugs, and participate in on-call rotation as required.
- Provide 24 by 7 support as part of an on-call rotation, ensuring critical production issues are addressed promptly at any time.
- Perform planned and scheduled maintenance activities (e.g., patching, upgrades, data migrations) during night hours or weekends to minimize business disruption and maintain service availability.
Required Skills & Qualifications:
- Education: Bachelors degree in Computer Science, Information Technology, or a related field, or equivalent hands-on experience.
- Experience: 2-3 years of practical experience as a PostgreSQL/PGSQL developer.
Technical Skills:
- Strong knowledge of SQL and PL/pgSQL programming.
- Experience with schema design, normalization, and data modeling.
- Proficiency in building and optimizing complex queries and stored procedures.
- Familiarity with database indexing, partitioning, and other optimization techniques.
- Understanding of database security, access controls, and role management.
- Exposure to ETL processes, data migration, and integration.
- Experience with Linux/Unix environments for general database operations.
- Familiarity with source code/version control systems (e.g., Git).
- Exposure to cloud-based PostgreSQL deployments (e.g., AWS RDS, Azure Database for PostgreSQL) is a plus.
- Knowledge of reporting tools or extensions (e.g., PostGIS, TimescaleDB) is an advantage.
Desired Attributes:
- Strong analytical and troubleshooting skills for solving database and data issues.
- Effective communication and collaboration skills for cross-functional teamwork.
- Ability to manage multiple tasks and deadlines in a fast-paced environment.
- Eagerness to learn new technologies and stay updated with PostgreSQL advancements.
- Commitment to maintaining standards and best practices in database development.
- Flexibility to work outside standard business hours for planned maintenance or urgent support requirements.
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: Engineering - Software & QARole Category: DBA / Data warehousingRole: Database AdministratorEmployement Type: Full timeContact Details:
Company: CentilyticsLocation(s): Noida, Gurugram
Keyskills: Postgresql Query Optimization AWS rds Stored Procedures Scheme Design Etl Process Database Migration Performance Tuning Production Support
Similar positions
Centilytics
Zarthi is a technology service provider that acts as a catalyst for businesses. We have established relationships with companies and organizations such as Haldirams, Thirdwave Coffee, m-Pocket, UNICEF, and UNDP. Beyond providing technology support, we also specialize in cloud management. Our offer...
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in