Application Support Engineer

Project Role : Application Support Engineer
Project Role Description : Act as software detectives, provide a dynamic service identifying and solving issues within multiple components of critical business systems.
Must have skills : PostgreSQL Administration
Good to have skills : NA
Minimum 3 year(s) of experience is required
Educational Qualification : 15 years full time education
Project Role: App/Cloud Support Sr. Analyst Skill Required: Tech for Operations – PostgreSQL Database Administration Project Role Description: Review and integrate all application requirements including functional, security, integration, performance, quality, and operations. Align technical architecture with business and operational needs. Provide inputs on final decisions for hardware, network products, system software, and database security. Management Level: 10 Work Experience: 5-7years Work Location: Noida Must Have Skills: PostgreSQL Database Administration, PostgreSQL on AWS (RDS/Aurora), Cloud-native PostgreSQL architecture Good To Have Skills: Replication (Streaming/Logical), Performance Tuning, Upgrades and Migrations, HA/DR Solutions and MySQL Database Administration. ________________________________________ Job Requirements: Key Responsibilities: • Administer, monitor, and support PostgreSQL databases running on-prem and on cloud platforms like AWS RDS, Aurora, or Azure Database for PostgreSQL. • Perform database installation, configuration, upgrades, patching, and security hardening. • Handle backup and recovery using native PostgreSQL tools (pg_basebackup, pgBackRest, Barman). • Tune and optimize SQL queries and database parameters to improve performance and resource usage. • Design and implement high availability and disaster recovery (HA/DR) solutions such as Streaming Replication, Logical Replication, and Failover Clustering. • Work with DevOps/Cloud teams on infrastructure automation using tools like Terraform, Ansible, or CloudFormation. • Troubleshoot database issues, including corruption, lock contention, replication lag, and unexpected downtime. • Manage storage, partitioning, archiving, and connection pooling for large-scale production databases. • Develop automation for routine DBA tasks using shell scripts, Python, or PL/pgSQL. • Participate in 24x7 on-call support rotation and P1/P2 incident handling. • Collaborate with development and operations teams for application onboarding and schema design. • Monitor logs and metrics using tools like pg_stat_activity, pgBadger. ________________________________________ Technical Experience: • Strong experience with PostgreSQL 11+ in production environments (on-premises and cloud). • Experience with Amazon RDS PostgreSQL and Amazon Aurora PostgreSQL. • Familiarity with PostgreSQL backup and recovery using pg_dump/pg_restore, pgBackRest, and WAL archiving. • Experience in PostgreSQL upgrades (in-place and dump-based) and major version migrations. • Knowledge of PostgreSQL security, roles, SSL setup, and row-level security. • Familiarity with PostgreSQL extensions like PostGIS, pg_partman, pg_repack, etc. • Hands-on experience with replication, logical decoding, and failover handling. • Exposure to containerized PostgreSQL deployments (Docker, Kubernetes). • Ability to perform health checks, audit configurations, and enforce compliance standards. ________________________________________ Professional Attributes: 1. Strong communication skills and ability to articulate technical issues in business terms. 2. Excellent problem-solving and analytical skills under pressure. 3. Ability to multi-task and participate in large, complex, and concurrent projects. 4. Good to have PostgreSQL certification (EDB/PostgreSQL CE) or AWS Database Specialty. 5. Working knowledge of ITIL processes and documentation. 6. Good to have AWS Solution Architect Associate / AWS Database specialty certified. ________________________________________ Educational Qualification: 16 years of full-time education. Preferably with a degree in Computer Science, IT, or a related field. Additional Information: Should be flexible for a 24x7 environment and willing to handle P1/P2 calls.