Job Position:Postgres DBA

Experience :2+ Years & Above

Qualification : Any Graduates

Location : Chennai,Bangalore

Job Description :

1.Linux/UNIX expertise

2.Expert in postgresql >=8.4

3.Expert in SQL and PG/PL SQL

4.Ability to set up audit trails for Postgres using functions and triggers

5.Ability to independently monitor and administrator databases.

6.Ability to Create Database, Create users and grant appropriate privileges

7.Ability to identify defects in the environment and proactively intervene to reduce downtime.

8.Performance tuning, Query Tuning by generating and explaining EXPLAIN PLAN for SQL queries.

9.Expert in DBA functions like managing databases, backups & restore, scheduling jobs, space, performance management, principles of database replication, scalability and high availability.

10.Expert in Backup & Recovery including Pg dump, setting up WAL archiving, Point in time recovery.

11.Monitoring Alert Log, scheduled jobs and troubleshooting database problems.

12.Understanding of basic database fundamentals: multi-version control, concurrency, transactions, indexing, locking, caching.

13.Analyze, recommend, and implement configuration for Optimized Performance.

14.Ability to plan hardware capacity requirements for storage, memory and CPU Cycles.

15.Expert with setting and trouble shoot replication.

16.Ability to configure and trouble shoot, log shipping, cascading standbys, partial replication, continuous recovery, detach and reattach slaves.

17.Plan, manage, and execute large scale projects.

18.Understanding of Unix environment with shell scripting.

19.Other duties as per requirement.

To get Expert Software Training Programs with Placement in your location ? Check out : Dot Net Training in chennai | PHP Training in Chennai|Software Testing Training in chennai|Java Training in chennai | Android Training in chennai | IOS Training in chennai |Oracle Training in chennai |Web Designing Training in chennai