Responsibilities :
- 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 b e 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 24- 7 support rotation.
- Support complex web-based applications.
- Perform other duties as assigned.
What we need :
- 5-7 years of relevant experience.
- Must have strong analytical, verbal and written communication skills.
- Must have experience in PostgreSQL database architecture, logical and physical design, automation, documentation, installs, shell scripting, pl/ sql programming, catalog navigation, query tuning, system tuning, resource contention analysis, backup and recovery, standby, replication, etc.
- Must have strong knowledge of Linux.
- Strong understanding of command line.
- Knowledge of shell scripting (e.g., bash, Perl).
- Understanding of php and web application framework
Thursday, September 03, 2020
Kanerika - PostgreSQL Database Administrator - PL-SQL/Linux (4-9 yrs) (Kanerika)
