Senior PostgreSQL Developer / Database Engineer at Sequoia Applied Technologies Inc.

Chennai, tamil nadu, India -

Full Time

Start Date

Immediate

Expiry Date

23 Jun, 26

Salary

0.0

Posted On

25 Mar, 26

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

PostgreSQL, Database Design, Query Optimization, Performance Tuning, SQL, Indexing, Stored Procedures, Data Modeling, Replication, Disaster Recovery, Python, Bash, Linux/Unix, CI/CD, Transaction Management, Concurrency Control

Industry

Software Development

Description

Role Overview We are looking for an experienced Senior PostgreSQL Developer with strong expertise in database design, query optimization, and performance tuning. The ideal candidate will be responsible for designing scalable database solutions, writing efficient queries, and ensuring high availability and performance of PostgreSQL systems. Key Responsibilities Design, develop, and maintain robust and scalable PostgreSQL database schemas. Write, optimize, and troubleshoot complex SQL queries for high-performance applications. Perform query tuning, indexing strategies, and execution plan analysis. Manage database performance, identify bottlenecks, and implement improvements. Develop and maintain stored procedures and functions. Handle database migrations, upgrades, and version control. Ensure data integrity, security, and compliance standards are maintained. Work closely with application developers to design efficient data models. Monitor database health, backups, replication, and disaster recovery processes. Implement and manage high availability solutions (replication, clustering). Troubleshoot production issues and provide timely resolutions. Contribute to CI/CD pipelines for database deployments. Required Skills & Qualifications 6–8 years of hands-on experience with PostgreSQL. Strong expertise in database design, normalization, and data modeling. Advanced knowledge of SQL and query optimization techniques. Experience with performance tuning, indexing, and query planning. Familiarity with PostgreSQL internals (vacuuming, indexing, WAL, etc.). Experience in backup and recovery strategies. Knowledge of replication techniques (streaming, logical replication). Proficiency in scripting languages (e.g., Python, Bash) for automation. Understanding of transaction management and concurrency control. Good to Have Experience with cloud platforms (AWS RDS, Azure Database for PostgreSQL, GCP). Knowledge of partitioning and sharding strategies. Exposure to NoSQL databases is a plus. Experience working in Linux/Unix environments. Experience with monitoring tools (Prometheus, Grafana, pgAdmin, etc.). Familiarity with DevOps practices and CI/CD pipelines. Understanding of microservices architecture. Soft Skills Strong analytical and problem-solving skills. Excellent communication and collaboration abilities. Ability to mentor junior team members. Proactive approach to identifying and solving performance issues.

Responsibilities

The role involves designing, developing, and maintaining scalable PostgreSQL database schemas, writing and optimizing complex SQL queries, and managing overall database performance and high availability. Key tasks include troubleshooting production issues, handling migrations, and ensuring data integrity and security standards are met.