Oracle DBA

• 10+ years of experience as a Database Administrator with Oracle, PL/SQL

• 2+ years of experience with Oracle 19c Multi-Tenant Architecture and database infrastructure design on RAC

• Databases

• Experience in Red Hat Linux & Oracle Linux Operating Systems.

• Experience in following processes and procedures to standardize Database installations and configuration

• Experience automating, scripting, and streamlining processes for efficiency and accuracy utilizing Unix shell scripting or other scripting tools

• Broad experience in the art of performance tuning, utilizing OEM or third-party tools to finely tune objects and queries in Oracle 19c

• Comprehensive understanding of Oracle backup methodologies.

• Monitor alert logs, OEM and system alerts, and acting on the results

• Willingness to participate in after-hours Production support.

• Proficiency in Linux, Unix, Java, and DBA

• Understanding of production environments, technical support and troubleshooting

• Knowledge of Automatic Storage Management (ASM)

• Experience with Oracle Exadata

• Experience working in UNIX operating system

• Ability to write simple to complex Linux/Unix shell scripts and Perl scripts

• Strong knowledge in Unix/Linux System administration

• Ability to work independently and to resolve complex Oracle issues

• Experience with data pump and working knowledge to use expdp and impdp

• Ability to effectively diagnose, isolate, and resolve complex problems pertaining to data infrastructure

• Ability to write, SQL, PL/SQL, Oracle Stored Procedures functions, Package and Database Triggers

• Ability to Tune Oracle SQL and PL/SQL performance

• Experience in logical database design and data models

• Understanding of the software development lifecycle process

• Practical experience in monitoring and tuning a database to provide a high availability service

• Experience with Oracle Enterprise Manager (OEM)

• Knowledge of data privacy and protection initiatives

• Strong communication and collaborative skills

• Excellent verbal and written communication skills

• Knowledge of data masking using Test Data Management Tool to

• Develop and maintain enterprise-wide data masking standards for Oracle databases

• Define masking rules, algorithms, and transformation logic aligned with business and compliance requirements

• Ensure masked data remains referentially intact across schemas and applications

• Configure and execute masking workflows using the organization’s Test Data Management tool

• Build reusable masking templates, rule sets, and automation pipelines

Preferred KSA’s:

• Excellent working skills with Oracle Exadata and

o 5+ years; experience with SQL performance tuning and database architecture.

o Experience in converting traditional databases to Container Model - Oracle Multitenant architecture

o Experience working with Test Data Management Tool