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.