Experience: 2 to 3 Yrs.
Salary Range: 6 to 8 LPA
Skills And Qualifications:
- Expert in writing DB Query, Procedures, Functions.
- Excellent Analytical and Debugging skills with SQL, PL/SQL.
- Managing DBs Instances.
- Strong in PostgreSQL Database performance analysis and SQL/ pgSQL performance tuning
- Responsible of Deploying, Designed, and developed databases, tables, views, and store procedures
- Identifying and Resolving Blocking and Deadlock issues
- Backup and Restore
- Monitoring Clusters
- Improving efficiency in Databases by doing Re-indexing and Updating stats
- Scheduling maintenance with the PostgreSQL pg_cron extension
- Managing PostgreSQL partitions with the pg_partman extension
- Upgrading the PostgreSQL DB engine for Aurora PostgreSQL
- Experience to Data Quality, Security, Governance
- Experience in AWS Aurora PostgreSQL is an added advantage
Key Skills: PL/SQL, PostgreSQL