PostgreSQL-DB Administration

• The job holder is responsible for technical delivery of 24x7 production support to Oracle and Postgres preferred databases and work as a Subject Matter Expert for the production support team
• Expertise in Oracle RAC and Database
• Perform troubleshooting Root Cause Analysis and provide permanent fixes
• EXPERT knowledge in Investigate and provide solutions to database performance related issues in Oracle Database
• Lead Database team in crisis calls participate in MIR and PIR calls also mentor team members
• Experience and expertise in maintaining complex High Availability Replication setups
• Provide consultancy for complex setups and Disaster Recovery
• Identify automation and SelfHealing opportunities and develop automation to reduce manual efforts and standardize processes
• Knowledge on PostgreSQL architecture background processes and storage structure
• Knowledge of database objects such as schemas tables indexes constraints and partitioning
• Awareness of replication concepts and high availability architecture
• Hands on experience of WAL mechanism archiving and basic backup recovery concepts
• Knowledge of transaction management locking and concurrency control
• In Postgres Basic performance monitoring concepts including query behaviour and database growth management
• Experience on autovacuum process and database maintenance activities
• Knowledge of rolebased access control authentication methods and security best practices
• Familiarity with production support processes and incident handling in PostgreSQL environments

Required Skill

• Strong technical knowledge of Oracle concepts like RAC Dataguard OGG
• Expertise in 12c19c versions OEM
• Build and DeployImplement Solutions Perform Capacity Planning and DR Planning
• Expertise in Troubleshooting Performance Issues and providing solutions
• Expertise in RMAN BackupRestoreRecovery
• Expertise in Role swap Failover planning and implementation
• Strong technical knowledge of database space management
• Implementing releases service requests
• Expertise in GoldenGate
• Expertise in Database upgrades and migrations

Additional Skill

• Knowledge on Oracle Cloud
• Knowledge on UNIX based OS
• Knowledge of MongoDB Db2 LUW technology
• knowledge of automation tool like Ansible Puppet Tanium
• Knowledge about Agile practices and DevOps tools