Responsible for the monitoring and uptime of all production databases.
Estimate PostgreSQL database capacities; develop methods for monitoring database capacity and usage.
Lead efforts to develop and improve procedures for automated monitoring and proactive intervention, reducing any need downtime.
Develop Stored Procedures and Database Triggers in support of application development.
Participate in application development projects and 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, Archiving).
Responsible for pro-active remediation of database operational problems.
Responsible for Query tuning and preventative maintenance.
Participate in a 247 support rotation.
Support complex web-based applications.
Perform other duties as assigned.
Responsible for database migration from on-promise to AWS cloud.
Responsible for database migration from different clouds (azure, HEROKU) to AWS cloud.
Responsible for database monitoring through different third-party monitoring tools .
Responsible for multi-slave asynchronous replication system for Postgresfrom bucardo.
Responsible for database migration from other databases like oracle, MySQL toPostgreSQL
Responsible for automating database backup jobs through shell scripts.
Responsible for configuring pgpool and pgbouncer
Responsible for configuring hot standby and streaming replication and monitoring.
Employement Category:
Employement Type: Full time Industry: IT - Software Role Category: Application Programming / Maintenance Functional Area: Not Applicable Role/Responsibilies: Database Administrative
Contact Details:
Company Name: SARA TECHNOLOGIES Location(s): Chennai