Postgres DBA

Job Responsibilities:

· Adhering to SLAs

· Reporting to the Track Lead / Team Lead

· Helping team members in case of Issues/Technical Problems

· Handling tickets / requests

· Troubleshooting technical issues

· Ensuring that the processes are adhered to

· Responsible for successful completion of Installation, configuration and migration

· Ensure maximum uptime according to the SLA

· Responsible for building / maintaining a test environment

· Improves and maintains customer and employee satisfaction

· Implementing new technologies and design changes

· Implementing Backup/Restoration Strategy for 24x7 operation support

· Applying patches/upgrades to maintain security level Technical Requirements

· Installation of Client Software/Database Pre-requisites

· Client Database Basic Administration and Latest Features

· Maintain instance parameters and system settings

· Migrating databases using various tools such as SQL*Loader, Import/Export and Data pump

· Applying and Testing security patches to the databases

· Managing User Accounts

· Experience in cloning using cold backup, hot-backup and RMAN backup

· Capacity Planning in terms of Growth of Database

· Automated File and Storage Management

· Good knowledge of 10g/11g features as Data Pump, ASM and Flash back recovery

· Experience in basic Performance Tuning and Monitoring using various tools such as AWR, TKPROF

and Explain Plan

· Availability Management for Databases

· Database Resource Management and Task Scheduling

· Scheduling Database Backups, taking Logical Backups & Physical Backups

· Implementing Database Security Policy.

Soft Skills:

· Excellent communication and conversation skills (Verbal and Written)

· Good documentation skills

· Good working knowledge of MS OFFICE

· Should have a good customer handling skill

· Able to handle unforeseen situations

· High level of acceptance

· Can drive Client’s value and its methodology

Other Skills / Experience: · Worked on Production systems · Experience with Database Migration, Installation, Upgrades and Patching - Datacenter understanding · Knowledge of Other RDBMS is a Plus · Experience in PL/SQL and worked on ER Diagrams · Working Knowledge on Cluster ware

Job type: Contract Division: Darwin Rhodes Reference: 22-03416