Oracle DBA - L3

Job Title: Oracle DBA - L2

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

Summary:

1. Oracle DBA with 4-6 yrs. of exp maintaining databases running on Red Hat Linux(and others Linux systems) and Windows.

2. Should be well versed with installing, upgrading, and configuring large databases and mission critical large OLTP and OLAP systems.

3. Experience in PostgreSQL Database installation, configuration, and DR setups

4. Experienced DBA involved with backups, recovery, replication, and migration of databases. Experience with user administration and performance tuning.

5. Extensive experience in Database Backups RMAN (Full/Incremental backups) and in traditional hot/cold backups and Block recovery solutions using RMAN/ manual procedures wherever applicable.

6. Performance tuning on large systems on Oracle and PostgreSQL

7. Good experience in RAC Cluster ware administration, Configuration and Patching.

Involved with installation and maintenance of ORACLE 11g RAC/oracle 12C RAC/oracle 19C RAC and standby database for High Availability and Disaster Recovery purpose.

Responsibilities:

• Strong knowledge of Oracle & PostgreSQL Architecture.
• Oracle and PostgreSQL Database installation, maintenance and upgrades.
• Experience on applying Oracle patches including CPU patch, interim patch and bugs fixing using OPatch.
• 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 devlopment 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 datapump 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 Encrytion: Ensure data integrity and security according to departmental standards and procedures
• Backup Management

- Using RMAN

- Taking export Backups through data pump utility.

- Recovery Management

• Working on Goldengate replication, Monitoring and troubleshooting Lag issues
• Prepared scripts for database monitoring and other space alerts
• Good Communication and Interpersonal Skills.
• Experience in PostgreSQL Database on 11v to 15v
• 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) Oracle (Primary) and PostgreSQL(Secondary)

2) ASM and RAC, Golden Gate(Optional)

3) Linux and Windows

4) Shell/power shell scripting

5) OEM