Sr Oracle Database Administrator

Position: Sr Oracle Database Administrator

Location: San Jose CA (4 days a week Onsite)

Duration: 6Months

Client: Williams Sonoma

Interview: Phone and Video

Job Description:

Project Description

Team is seeking a highly skilled Senior Oracle DBA with expertise in Oracle GoldenGate to support and enhance their mission-critical database environments. This role is ideal for a seasoned professional who thrives in high-availability performance-sensitive environments and is comfortable collaborating across development application support and infrastructure teams.

Duties/Day to Day Overview

• Support administer and maintain production and non-production database environments primarily running on the AIX platform
• Disaster recovery planning and execution.
• Implement and maintain proactive database monitoring for space issues database locking performance issues and other key metrics
• Work with the development and application support teams to identify triage and resolve performance issues using diagnostic tools such as AWR ADDM etc.
• Analyze optimize and tune advanced complex SQL queries and their associated execution plans using command line tools
• Deploy and maintain high availability and failover technologies such as Data Guard and Real Application Clusters to maximize database availability
• Create clone and upgrade environments to support implementation activities as required
• Define implement and support Backup and Recovery policies using RMAN and / or storage level replication technologies

Top Requirements (Must haves)

• 8 years of Oracle DBA experience in a production environment working with Oracle 11g and above
• Proven experience managing Oracle Real Application Clusters
• Experience supporting mission critical 24x7 e-Commerce and ERP systems
• Excellent UNIX / Linux shell scripting skills
• Proven experience in tuning databases / queries
• Experience with security monitoring and encryption tools
• Exposure to Oracle Retail (RMS) Sterling and e-Commerce platforms.
• Experience working closely with application teams to implement and support database-backed applications.
• Familiarity with performance monitoring tools such as OEM and custom scripts (e.g. NuSoft).