Oracle DBA (remote option)
About The Position
This is a temporary project role for an Oracle DBA with an estimated duration of 12+ months, offering a remote work option. The position requires extensive experience in Oracle Database Administration, PL/SQL, and specific Oracle technologies like 19c Multi-Tenant Architecture and RAC Databases. The role involves administering, monitoring, and maintaining Oracle databases, ensuring data integrity through backup and recovery strategies, automating processes, and performing performance tuning. Additionally, the DBA will be responsible for data masking using Test Data Management tools and standardizing database installations and configurations.
Requirements
- Experience with Oracle Database Administration and PL/SQL (10+ years)
- Experience with Oracle 19c Multi-Tenant Architecture and RAC Databases (2+ years)
- Experience with Red Hat Linux and Oracle Linux operating systems
- Experience in following processes and procedures to standardize Database installations and configuration
- Experience with Java, Linux and Unix
- Experience with Unix/Linux shell scripting (bash, Perl, or equivalent scripting tools)
- Experience with Oracle performance tuning using Oracle Enterprise Manager (OEM) or third-party tools
- Experience with Oracle backup methodologies, data pump (expdp/impdp), and Automatic Storage Management (ASM)
- Experience with logical database design, data models, SQL/PL/SQL, Oracle Stored Procedures, Functions, Packages, and Database Triggers
- Experience with data masking using Test Data Management tools (developing masking standards, rules, algorithms, and automation pipelines for Oracle databases)
- Experience working with CDB/PDB environments
Nice To Haves
- Experience with SQL performance tuning and database architecture 5+ years
- Experience with Oracle Exadata
- Experience with converting traditional databases to Oracle Multitenant Container Model architecture
Responsibilities
- Administer, monitor, and maintain Oracle 19c databases on RAC and Exadata infrastructure in production and non-production environments
- Monitor alert logs, OEM alerts, and system alerts; respond to and resolve database incidents and complex Oracle issues
- Design and implement Oracle backup and recovery strategies; execute and validate backup operations
- Automate, script, and streamline database administration processes using Unix/Linux shell scripting and other scripting tools
- Perform database performance tuning of SQL, PL/SQL, objects, and queries using OEM and third-party tools
- Configure and execute data masking workflows; develop and maintain enterprise-wide data masking standards, rule sets, and automation pipelines using Test Data Management tools
- Standardize database installations and configurations
- Support production environments, troubleshoot data infrastructure issues, and participate in after-hours production support as needed
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Career Level
Senior
Education Level
No Education Listed
