Job Description :
- Linux/UNIX expertise
- Expert in postgresql >=8.4
- Expert in SQL and PG/PL SQL
- Ability to set up audit trails for Postgres using functions and triggers
- Ability to independently monitor and administrator databases.
- Ability to Create Database, Create users and grant appropriate privileges
- Ability to identify defects in the environment and proactively intervene to reduce downtime.
- Performance tuning, Query Tuning by generating and explaining EXPLAIN PLAN for SQL queries.
- Expert in DBA functions like managing databases, backups & restore, scheduling jobs, space, performance management, principles of database replication, scalability and high availability.
- Expert in Backup & Recovery including Pg dump, setting up WAL archiving, Point in time recovery.
- Monitoring Alert Log, scheduled jobs and troubleshooting database problems.
- Understanding of basic database fundamentals: multi-version control, concurrency, transactions, indexing, locking, caching.
- Analyze, recommend, and implement configuration for Optimized Performance.
- Ability to plan hardware capacity requirements for storage, memory and CPU Cycles.
- Expert with setting and trouble shoot replication.
- Ability to configure and trouble shoot, log shipping, cascading standbys, partial replication, continuous recovery, detach and reattach slaves.
- Plan, manage, and execute large scale projects.
- Understanding of Unix environment with shell scripting.
- Other duties as per requirement.
Location : Chennai, India
Team : DBA
Position : Postgres Database Administrator
Vacancy : 2
Experience : 3+ Years & Above
Qualification : Any Graduates
Apply :
To apply please send resume to in.careers@comodo.com