Principal Success Services Engineer, CSS Tech Delivery, Database

Job description / Role

Overview

As a member of the Support organization, your focus is to deliver post-sales support and solutions to the Oracle customer base while serving as an advocate for customer needs. This involves resolving post-sales non-technical customer inquiries via phone and electronic means, as well as technical questions regarding the use of and troubleshooting for our Electronic Support Services. As a primary point of contact for customers, you are responsible for facilitating customer relationships with Support and providing advice and assistance to internal Oracle employees on diverse customer situations and escalated issues.

There are high expectations from the candidate profile to be very skilled in business communications not only with sales, pre-sales, and technical account managers but also with customers. Presentation skills are key too. The candidate nominated for this job should have a passion for participating in business growth with very talented technical skills covering the areas below:

Database Administration

• General Relational Database Management System (RDBMS) issues and DBA activities for versions 11g, 12c, and 19c.
• Installing, designing, configuring, administering, and troubleshooting Oracle 11g/12c databases.
• Administering the complete Oracle environment including databases, applications, and services.
• Monitoring database conditions throughout the network including server-side and client-side.
• Oracle Enterprise Manager installation, configuration, and upgrades.

Backup and Recovery

• Database backup using RMAN and user-managed backup strategies.
• Backup strategies according to workload.
• Database restore using different methods.
• Database recovery using user-managed recovery method or RMAN method.
• Complete recovery to the most current point in time.
• Incomplete recovery using methods such as time-based recovery and cancel-based recovery.
• Tablespace point in time recovery.
• Oracle Secure Backup.
• Fixing corruptions and using DUL (Data Unload Utility) tool.

Oracle Utilities

• Knowledge to export and import any database objects (tablespaces, users, full database).
• Export/import using Oracle Data Pump utility.
• SQL Loader.
• Database character set conversion.

Migration/Upgrades and Loading Data

• Migrating databases of any release into 11gR2, 12c, or 19c databases.
• Performing different database upgrades from/to different releases using all types of upgrades.
• Migrating (moving) databases from one server to another with minimal downtime.
• Loading data into any Oracle database release.
• Database migrations using all methods including Golden Gate, transportable tablespaces, and transportable databases.

Oracle Data Guard

• Configuring, administering, and troubleshooting standby (logical/physical) database environments in single DB instance and RAC/ASM environments.

Oracle Real Application Cluster/ASM

• Installing, patching, upgrading, administering, and troubleshooting RAC environments/ASM.
• RAC high availability testing.

Database Security

• Database Vault.
• Audit Vault and Database Firewall.
• Transparent Data Encryption (TDE).
• Virtual Private Database (VPD).
• Oracle Data Masking and Redaction.
• Oracle Label Security.

Being responsible operationally to support critical customers on-site and remotely with high skills for troubleshooting and solving technical issues.

Systems - Exadata

• Exadata configuration, administration, patching, bare metal restore, performance tuning, migrations, upgrades, DBFS, VLAN tagging, and HCC compression.
• Exadata IORM implementations.
• Exadata high availability testing.
• ZFS storage configuration and administration for backup and recovery.

Oracle Golden Gate

• Golden Gate installation and configuration.
• Golden Gate replications: classic, integrated, and coordinated.
• Oracle database migration using Golden Gate.
• Golden Gate performance.
• Golden Gate Veridata installation and configuration for creating comparisons.
• Golden Gate plugin for OEM.

Oracle Performance Tuning

• Troubleshooting different performance issues.
• Hang analysis and cluster eviction issues.
• SQL tuning with different methodologies, SQL profiles, SPM, and SQL restructure.
• Gathering statistics with different strategies based on workload and business.
• Oracle Real Application Testing (RAT).
• Oracle SQL Performance Analyzer (SPA).
• Database tuning, memory tuning, backup tuning, and data pump tuning.
• Working with different performance utilities: AWR, ADDM, ASH, and others.
• Database Resource Manager (DBRM).

Enterprise Manager & Cloud

• Installation of Enterprise Manager systems.
• Patching and upgrading OEM to different versions.
• Engineered system machine discovery (Exadata, Super Cluster, and ZFS).
• Installing different plugins: Siebel, Golden Gate.
• Email notification for different metrics and thresholds.
• Good knowledge of cloud management including PaaS, DBaaS, service catalog, and Snap Clone.
• Migrating Oracle databases to Database as a Service.

System Skills

• Oracle Cloud IaaS: VCN, ADs, instance, storage, IAM, load balancer, database, and DNS.
• Oracle engineered systems: Exadata, PCA, ZFS storage, and backup appliances, InfiniBand switches, Ops-center, OVM, Enterprise Manager, ZDLRA.
• Oracle Sun Solaris OS, network and cluster administration, Solaris versions 8, 9, 10, and 11.
• Oracle Sun hardware: V/T/M-Series SPARC and x86 design, implementation, and support.
• OVM, Xen, PDoms, LDoms, zones, SVM, UFS, ZFS, NFS, flash archive, jump start, AI installer.

On top of this, the candidate must be self-motivated, a teamwork player, possess leadership skills, and support the sales cycle by driving discussions for needed clarifications and estimating the level of effort for delivery.

Career Level - IC4

Responsibilities

As an Advisory Systems Engineer, you are expected to be an expert member of the problem-solving/avoidance team and be highly skilled in solving extremely complex (often previously unknown), critical customer issues. Performing the assigned duties with a high level of autonomy and reporting to management on customer status and technical matters on a regular basis, you will be expected to work with very limited guidance from management. Furthermore, the Advisory Systems Engineer is sought by customers and Oracle employees to provide expert technical advice.

The engineer will be committed to the CSS scope of services that could be delivered to our customers. For instance, it includes all technology tasks related to Day 1 and Day 2 for on-prem customers, besides all activities for Day 2 customers. However, it is subject to change according to CSS setup.

About the Company

Oracle offers an integrated array of applications, databases, servers, storage, and cloud technologies to empower modern business. For most companies, flexibility is critical. Oracle provides a wide choice of software, systems, and cloud deployment models - including public, on-premises, and hybrid clouds - to ensure that technology flexes to the unique needs of a business.

Oracle Cloud is a complete, integrated stack of platform, infrastructure, and application services. With advanced scalability and security, Oracle Cloud enables technical agility across the enterprise, connects people to information for clearer insights, and fosters efficiency through simplified workflows.

More than 420,000 customers across 145 countries have harnessed Oracle technology to accelerate their digital transformation.