Required Skills- Requires a minimum of ten (10) years directly related and progressively responsible experience in supporting architecture design and implementation.
- 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.
- Must have experience handling large databases of over 100+ TB size running on RAC with high memory and CPU requirements.
- 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 TDE 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 is a plus.
- 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.
- Strong Infrastructure knowledge for Compute, Network, Storage, Security, HA/DR.
- Knowledge of various Oracle appliances such as Exadata preferred but not a requirement.
- 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.
- Engage and interface directly with Oracle as required for product support/questions