Oracle Database Administrator - Real Application Clusters (4-8 yrs)

Job Title : Oracle Database Administrator 8354-1.

Location : Noida.

Experience Required : 4-8 Years.

Availability : Immediate Joiners.

Work Mode : Onsite.

Duration : Contract (6+ Months).

Job Summary :

As an Oracle Database Administrator (DBA), you will be responsible for the installation, configuration, management, and maintenance of Oracle databases, both standalone and RAC (Real Application Clusters).

Your role will involve performing backups, recovery operations, and managing database performance and availability. You will also be tasked with troubleshooting issues related to database synchronization, managing Data Guard and GoldenGate, and ensuring the smooth operation of Oracle database systems.

Additionally, you will be responsible for performing database patches, data export/import, and database housekeeping tasks.

About Us :

This position is being recruited by Smartwork IT Services, a leading recruitment and product-based company. In addition to staffing solutions, Smartwork IT Services is involved in developing cutting-edge products like SWITS ATS (Applicant Tracking System) and SWITS HRMS (Human Resource Management Services). We focus on delivering exceptional value through innovative solutions and top-tier talent acquisition.

Roles & Responsibilities :

- Install and upgrade Oracle standalone and RAC databases in Linux and Windows environments.

- Manage Oracle database users, passwords, and profiles.

- Perform tablespace management (add, resize datafiles, add tablespaces).

- Configure and maintain RMAN catalogs, and perform manual RMAN backups (Incremental/Full).

- Restore database backups using RMAN.

- Check and troubleshoot Data Guard standby sync issues, ensuring synchronization is in place.

- Perform database failovers to the Data Guard standby server and vice-versa.

- Check the GoldenGate sync status and troubleshoot sync lag issues.

- Analyze AWR/ASH & ADDM reports to identify and address database performance issues.

- Generate trace files using Tkprof and OS Watcher tools for performance analysis.

- Perform database housekeeping tasks such as purging, defragmentation, and index rebuilds.

- Ensure the database environment is optimized, secure, and regularly updated with PSU/RU/OJVM patches.

- Perform export/import of databases, tables, and schemas using Datapump.

- Troubleshoot and resolve database performance issues, implementing performance tuning techniques as necessary.

Must-Have Skills :

- Proficiency in Oracle Database Administration (DBA).

- Expertise in Oracle RAC (Real Application Clusters).

- Experience in RMAN backup and recovery processes.

- Strong understanding of Data Guard and GoldenGate configuration and troubleshooting.

- Ability to analyze AWR/ASH & ADDM reports for performance tuning.

- Expertise in performing database patches, export/import using Datapump, and housekeeping tasks.

- Good-to-Have Skills.

- Familiarity with statistical analysis and machine learning algorithms.

- Experience with data visualization tools such as Tableau or Power BI.

- Experience with data munging techniques, including data cleaning, transformation, and normalization.

- Soft Skills.

- Excellent problem-solving and analytical abilities.

- Strong communication skills, with the ability to clearly explain technical concepts.

- Ability to work independently and manage multiple tasks effectively.

- Collaborative mindset, working well with cross-functional teams.

Educational Qualifications : Completion of at least 15 years of full-time education in a relevant field.