Apex Systems is looking for an experience Oracle Database Administrator with experience with 10c/12 administration and supporting DEV, QA and PROD environments. The Oracle DBA will be working with development teams on performance tuning as well as production level database administrator duties.

Title: Oracle Database Administrator

Location: Horsham, PA (hybrid; 2 days' in office preferred)

Duration: 1 Year+ Contract - conversion to FTE

Primary Responsibilities:

• Work closely with development and architecture teams to properly engineer effective database solutions that ensure reliability, quality, and scalability
• Perform database administration tasks in QA and development environments, create database objects (tables, indexes, views, packages, etc.), define security policies, create and maintain SQL/PL-SQL and shell scripts to automate deployment tasks
• Resolve complex incidents (e.g., Data issues, performance tuning, security)
• Create and maintain roles and privileges
• Provide capacity projections and monitor space utilization
• Monitor Oracle processes and logs for any anomalies, provide corrective actions as necessary
• Provide assistance to developers for resolving technical Oracle issues, document and implement Oracle best practices
• Interface with developers regarding physical database design decisions and PL/SQL coding design
• Act as point of contact for all database-related issues and take ownership of the relationship with Optum Managed Services Oracle DBA team
• Support all phases of the software development lifecycle
• Support the data governance processes
• Review and enforce coding standards

Required Qualifications:

• Undergraduate degree or equivalent experience
• Solid knowledge of Oracle 19c/12c and technical database concepts, such as: logical relational data modeling, physical data modeling, tuning large instances, resource management, data replication and backup/recovery techniques
• Expert knowledge of SQL and PL/SQL
• Experience with Oracle 19c RAC Exadata
• Experience with database and system maintenance procedures

Preferred Qualifications:

• Organizational skills with the ability to handle multiple priorities
• Ability to troubleshoot and debug complex technical problems
• Proficiency in Oracle RDBMS database management in Linux
• Command administering database security, data recovery, performance monitoring and tuning
• Proficient in writing and optimizing SQL statements

Required Skills : Oracle 19c/12c and technical database concepts Oracle 19c RAC Exadata SQL and PL/SQL
Basic Qualification : • Undergraduate degree or equivalent experience • Solid knowledge of Oracle 19c/12c and technical database concepts, such as: logical relational data modeling, physical data modeling, tuning large instances, resource management, data replication and backup/recovery techniques • Expert knowledge of SQL and PL/SQL • Experience with Oracle 19c RAC Exadata • Experience with database and system maintenance procedures
Additional Skills : • Undergraduate degree or equivalent experience • Solid knowledge of Oracle 19c/12c and technical database concepts, such as: logical relational data modeling, physical data modeling, tuning large instances, resource management, data replication and backup/recovery techniques • Expert knowledge of SQL and PL/SQL • Experience with Oracle 19c RAC Exadata • Experience with database and system maintenance procedures
Background Check :Yes
Drug Screen :Yes
Notes :*** IMP*** • This is a contract to hire role, and the client does not provide any form of visa sponsorship. To qualify, candidates must be eligible to work in US without sponsorship now or in future." - . We can consider Remote only candidates but they need to be in MD, NY, PA, NJ, DE and able to come on-site quarterly for meetings. - This is not a production Oracle DBA; I want to know "What environments you support" and we are looking for individuals who support QA and DEV (Development) environments; not just production DBA's. - Ask if they work with developers on performance tuning and how extensive they have with PL/SQL coding. - Need experience with Oracle 19c/12c.
Selling points for candidate :
Project Verification Info :
Candidate must be your W2 Employee :Yes
Exclusive to Apex :No
Face to face interview required :No
Candidate must be local :No
Candidate must be authorized to work without sponsorship ::No
Interview times set : :No
Type of project :Administration/Support
Master Job Title :Misc: Non-Technical
Branch Code :Philadelphia