- Responsible for the monitoring and uptime of all production/Development/UAT databases and also worked in PostgresEnterprise Manager (PEM)
- Estimate PostgreSQL database capacities; develop methods for monitoring database capacity and usage.
- Develop Stored Procedures and Database Triggers in support of application development.
- Participate in application development projects and will be responsible for the database architecture and design.
- Participate in the creation of development, staging, and production database instances, and the migration from one environment to another
- Responsible for developer SQL code review to ensure queries are optimized and tuned to perform efficiently prior to production release.
- Responsible for regular backups and recovery of databases.
- Responsible for regular maintenance on databases (e.g., Vacuum, Reindexing, 2rArchiving).
- Responsible for proactive remediation of database operational problems.
- Responsible for Query tuning and preventative maintenance.
- Experience with postgres version 9.x, 10.x , 12.x,13.x
- Ability to proactively identify, troubleshoot and resolve live databasesystems issues
- Anticipate and handle critical situations database issues
- Knowledge of disaster recovery principles and practices, including planning, testing, backup/restore
- Experience in replication, Load balancing, connection pooling using pgpool and Pgbouncer
- Experience with Enterprise DB tools like PEM, BART, EFM and some open source tools like Pgbackrest, Barman, Pgbadger etc.
- Knowledge of PostgreSQL replication(hot,cold,warm), cascading, Shared clustering (active, passive).
- Ability to implement automation to reduce manual administrative tasks through use of jobs, scripts, cron or other techniques
- Expert level of PostgreSQL RDBMS installation/configuration, patching,upgradation, troubleshooting on Linux environment
- Strong commitment to following SDLC/Change management principles.
- Selfstarter and be able to perform work with minimal supervisory direction.
- Knowledge of data quality, data management and data testing strategies and practices.
Keyskills: postgresql database postgres