Database Administrative
- Sara Technologies
- 8 to 12 Yrs
- Chennai
- 7 years ago
- Email to a friend
- Report this job
Job Description
Job Title : DBA
Experience : 8-12 yrs
Notice Period : 30 days
Job Location : Chennai
Description :
- 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 timeIndustry: IT - SoftwareRole Category: Application Programming / MaintenanceFunctional Area: Not ApplicableRole/Responsibilies: Database AdministrativeContact Details:
Company Name: SARA TECHNOLOGIESLocation(s): Chennai+ View Contact
Fraud Alert to job seekers!
₹ 10 - 14 Lakh/Yr
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in