Job Title: Senior PostgreSQL Developer
Location: Hyderabad, India
Employment Type: Full-Time
Experience Required: 8+ Years
Job Description
We are seeking an experienced Senior PostgreSQL Developer to join our dynamic team in Hyderabad. The ideal candidate will have extensive experience with PostgreSQL, a deep understanding of database architecture, and a strong background in SQL development. As a key member of our team, you will be responsible for designing, developing, and maintaining our database systems to ensure optimal performance, scalability, and reliability.
Key Responsibilities- Database Design & Development:
- Design, develop, and implement robust PostgreSQL databases to support business applications.
- Write complex SQL queries, stored procedures, and functions to support application development.
- Optimize and fine-tune existing SQL queries for performance improvements.
- Database Maintenance:
- Monitor database performance and implement changes as necessary to improve performance.
- Perform database maintenance tasks such as indexing, vacuuming, and analyzing tables.
- Ensure data integrity and security through regular backups and recovery procedures.
- Collaboration & Support:
- Work closely with application developers to integrate PostgreSQL databases into applications.
- Provide technical support and troubleshooting for database-related issues.
- Collaborate with other IT professionals and stakeholders to gather and analyze business requirements.
- Documentation & Reporting:
- Create and maintain documentation related to database design, development, and maintenance processes.
- Generate reports and perform data analysis as required by the business.
Required Skills & Qualifications- Experience:
- 8+ years of experience in database development, with a focus on PostgreSQL.
- Proven experience in designing and developing complex database systems.
- Technical Skills:
- Proficiency in SQL and PostgreSQL-specific features such as JSONB, PL/pgSQL, and triggers.
- Strong understanding of database architecture, indexing, partitioning, and replication.
- Experience with performance tuning and optimization techniques.
- Familiarity with database security practices and data encryption.
- Additional Skills:
- Experience with cloud-based database solutions (e.g., AWS RDS, Azure Database for PostgreSQL) is a plus.
- Knowledge of other database systems (e.g., MySQL, Oracle) is an advantage.
- Familiarity with version control systems (e.g., Git) and continuous integration practices.
- Soft Skills:
- Excellent problem-solving and analytical skills.
- Strong communication and interpersonal skills.
- Ability to work independently as well as collaboratively in a team environment.
Education
- Bachelor's or Master's degree in Computer Science, Information Technology, or a related field.