PostgreSQL DBA - L2

Title: PostgreSQL DBA - L2

Location: Hyderabad (Work from Office only). Candidates looking for remote/hybrid work opportunities need not apply.

Summary:

• Minimum 4-6 years of experience in PostgreSQL Core DBA Role and Responsibility
• Excellent Knowledge on PostgreSQL Installation, configuration and troubleshooting replication tools - -Troubleshoot issues involving Unix levels commands.
• Fix issues related to Backup and Recovery with commands. -Migration tool from Oracle to Postgresql setup.
• Good Hands-on on troubleshooting related to any user related problem like access management, space management, generic errors, etc
• Database upgrades and migrations on any Cloud Environment
• Different type of replication concepts like Group replication, Multi master replication
• Excellent performance troubleshooting using pgadmin commands, tools like pgpool, repmgr, oswatcher, etc
• Troubleshooting issues related Database upgrades and migrations. -Install, configure and troubleshooting replication tools
• Troubleshoot issues involving Unix, storage or network problem.

Responsibilities:

• Strong knowledge of PostgreSQL Architecture.
• PostgreSQL & Oracle Database installation, maintenance, and upgrades.
• Established database backup/recovery strategy for different databases : Oracle and PostgreSQL
• Performed cloning of database from production database to test
• Database Object optimizations, explain plan, query plan and supporting development team on Stored procedures and triggering and others
• Creating and Maintaining Physical Standby database for both PostgreSQL & Oracle
• Experience on RAC databases
• Managing logical backups using data pump utility.
• Working on automation scripts for production databases.
• Automated database environment using SHELL SCRIPTS to monitor different environments.
• Monitor hardware resource utilization, recommending to management additional hardware necessary for forecasted levels, working with staff to maximize performance
• Perform testing of designed transaction processing environment, testing for performance, stability, fail over, and new database versions
• Keep up to date on current and new releases of database platforms and technology, planning migration strategy accordingly
• Assist in the development of automation scripts, documentation, and procedures for database administration, testing, and production
• Database Transit and Encryption: Ensure data integrity and security according to departmental standards and procedures.
• Backup Management

- • Working on Goldengate replication, Monitoring and troubleshooting Log issues

• Prepared scripts for database monitoring and other space alerts
• Good Communication and Interpersonal Skills.
• Experience in PostgreSQL Database on 15v to 17v
• PostgreSQL Streaming replication
• Experience in working different OS platforms in Linux(Ubuntu, RHEL) and Windows

Education: B.E / B.Tech graduate

Experience: 4-6 Years

Technical Skills:

1) PostgreSQL(Primary) and Oracle (Secondary)

2) Postgre Streaming Replication

3) Linux and Windows

4) Shell/power shell scripting

5) OEM