Job Title: Lead Oracle Database Administrator
Duration: 12+ Months Contract
Location: Conshohocken, Pennsylvania, United States
This role is on W2 only, No C2C or H1B.
Job Description:
- Provide DBA operational support with a high degree of customer service, technical expertise, and timeliness.
- Ensuring assigned Oracle Databases are well tuned and requires in-depth working knowledge of Oracle Performance Tuning tools and strong analytical skills.
- Engage with all efforts related with technical architecture requirements within Oracle solutions. Works with the Lead and team for all Oracle database issues.
- Interface with the Enterprise Architecture and Infosec teams to follow certain company and industry specific standards.
- Strong Infrastructure knowledge for Compute, Network, Storage, Security, HA/DR.
- Knowledge of various Oracle appliances such as Exadata preferred and ZFS/ZDLRA desired.
- Ability to actively participate doing hands-on work in Proof-of-Concept projects to demonstrate certain capabilities for the proposed solution.
- Create Architecture diagrams, HLD, LLD and document the overall solution.
- Will work closely with infrastructure teams (servers, network, etc.) to troubleshoot and resolve problems.
- Coordinate with other team members to ensure software consistency across the Oracle landscape.
- Will participate in the IT Change Management process and validate/approval all Oracle database related changes.
- Proactively keeps abreast of new developments and forecasts of future trends in the areas of database technology.
- Provide input on, and support new projects affecting the Oracle database landscape.
- Engage and interface directly with Oracle as required for product support/questions.
- Defines solutions by identifying requirements and writing functional specifications; consults with technical subject matter experts.
- Participate in on-call rotation with other DBA team members and perform weekend maintenance as assigned.
- Advises on options, risks, costs versus benefits and impact on other business processes and system priorities; contributes to cost versus benefit measures.
- Requires heavy Performance Tuning experience and perform complex analysis of performance issues. Requires in-depth familiarity with SQL Patches, SQL Plan Management, Optimizer behavior, Oracle Parameters etc.
- Must have experience with Oracle RAC installation, patching, and support on Oracle 12c/19c.
- Requires experience with implementation, operating, and performance management of Enterprise systems on Oracle Databases in the Exadata environment
- Extensive experience with RMAN, Data Guard, Oracle Security products/feature such as Data Vault, TDE etc. required.
- Strong working knowledge of Linux shell scripting/Python/Perl for developing automation and monitoring.
- Experience with other tools such as Oracle Enterprise Manager tools a plus.
- Candidates having experience working with 3rd party ‘bolt-on’ applications including but not limited to SAP, Vendavo, StreamServe, and EDI is a plus.
Top 5 Skills Required:
- Oracle Performance Tuning Expertise
- Database Administration
- Infrastructure Knowledge
- Scripting and Automation
- Oracle Enterprise Management Tools