Oracle DBA Lead Architect - Lorven technologies

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, Stream Serve, and EDI is a plus.