Senior Oracle DBA

Job Description

Requisition Number: SS-16776
Area of Interest: Information Technology
Organization: Corporate
Brand/Division: Shared Services
Position Type: Full-time
JOB DESCRIPTION
About the Team
You will be part of the Technical Infrastructure team responsible for designing, building and delivering critical technical building blocks such as Servers, Storage, Networking, Voice, Databases, Data Centers, Service Desk and Infrastructure tools. Our job is to ensure that every global WSI location, associate and customer has the best experience possible using the vast array of technical solutions we provide.
Day-to-day, you will be part of the team that develops, supports and maintains our Oracle database environment here at Williams-Sonoma, Inc. Our job is to ensure our internal customers get world class support, and we provide scalable and secure solutions to our end users.
About the Role
In this role, your expertise and knowledge of Oracle databases will provide our internal customers excellent support. Your experience will provide the ability to deliver high quality solutions that you and the team are proud to be part of. Your ability to quickly resolve issues, work with your team members and customers to come up with efficient ways of accomplishing our goals along with your strong communication skills will get you quickly recognized and rewarded here at Williams-Sonoma.
This role reports to the Senior Database Manager responsible for all database technologies here at Williams-Sonoma, Inc.
This role can be located in San Jose, San Francisco or Rocklin, California.
You're excited about this opportunity because you will:
* Work with a team that supports over 150 Oracle databases;
* Provide capacity planning and performance monitoring of our database environments;
* Support, administer and maintain production and non-production database environments primarily running on AIX and Linux operating systems;
* Implement and maintain proactive database monitoring;
* Work with engineering and application support teams to identify, triage and resolve performance issues. This requires the ability to analyze, optimize and tune complex SQL queries;
* Deploy and maintain high availability and failover technologies such as Active Data Guard, RAC, Golden Gate;
* Create, clone and upgrade database environments to support implementation activities;
* Define, implement and support database backup and recovery policies using RMAN and/or storage replication technologies;
* Perform database restoration and recovery in the event of a failure;
* Define, implement and enforce database security standards to be compliant with company policies as well as SOX, PCI and PII compliance standards;
* Ensure sensitive data is appropriately protected via industry standard encryption solutions;
* Work with the appropriate teams (Security Compliance, Internal and External Auditors) to review security policies, participate in audits, and implement the appropriate remediation measures;
* Contribute to, and update, systems documentation as required;
* Participate in 24X7 support rotation.
Why you will love working at Williams-Sonoma, Inc.:
* We're a successful, fast-growing company with an entrepreneurial vibe;
* We're a technology and data driven business;
* We're at the forefront of tech and retail, redefining technology for the next generation;
* We're passionate about our internal and external clients and live/breathe the client experience;
* We get to be creative on a daily basis;
* We have a smart and experienced leadership team that wants to do it right and is open to new ideas;
* We believe in autonomy, and reward taking initiative;
* We have fun!
REQUIREMENTS AND QUALIFICATIONS
We're excited about you because...
* You have implemented and supported mission critical systems providing 24X7 support;
* You have experience with data replication technologies like Oracle's Golden Gate, IBM's IIDR and Active Data Guard;
* You have excellent UNIX and Linux shell scripting skills;
* You have proven experience in tuning databases and queries;
* You can drive projects to get the projects accomplished with superior results;
* You deliver winning results and take accountability for your actions;
* You are an expert in diagnosing and solving complex problems;
* You understand the importance of data security, and can implement secure practices and work with SOX and PCI internal and external auditors to provide the needed evidence of the security of our database environments;
* You have very good oral and written communication skills and have the ability to influence others;
* You have 8+ years of Oracle database related work experience;
* You have a BS or MS in Business, Computer Sciences, Engineering or related field (an equivalent combination of related education, training and experience may be considered).
Technical Competencies Required:
* Deep understanding of Oracle DBMS 11.2 and 12c.
* Must have a deep understanding of Oracle Grid/RAC, Oracle Partitioning, Oracle CIS Security Standards, Oracle Enterprise Manager.
* Must understand Oracle performance tuning techniques.
* Deep understanding of database replication using the following technologies: Oracle Active Data Guard, Oracle Golden Gate, IBM IIDR or related data replication products.
* Significant experience with AIX, Linux (RHEL).
About Williams-Sonoma, Inc.
Founded in 1956, Williams-Sonoma, Inc. is the premier specialty retailer of high-quality products for the kitchen and home in the United States. Our family of brands are Williams-Sonoma, Williams-Sonoma Home, Pottery Barn, Pottery Barn Kids, PBteen, West Elm, Rejuvenation, and Mark and Graham. These brands are among the best known and most respected in the industry. We offer beautifully-designed, stylish and functional products for every area of the home, including the kitchen, living room, bedroom, home office, closet, laundry room and even outdoor spaces. We've seen some big changes since our first brick-and-mortar store opened more than half of a century ago. What hasn't changed is our passion for high-quality products, functional design, outstanding customer service, and enhancing the lives of our customers and the communities where we operate. Today, we're a multi-brand, multi-channel, global enterprise supported by state-of-the-art technology and some of the most talented teams in retailing - and we're always looking for new energy and ideas.
Williams-Sonoma Inc. is an Equal Opportunity Employer.
Williams-Sonoma, Inc. will consider for employment qualified applicants with criminal histories in a manner consistent with the requirements of the San Francisco Fair Chance Ordinance.
Benefits:
Once you are here, you can look forward to a wide variety of benefits. Our corporate vision--to enhance our customers' quality of life at home--extends to the lives of our associates. To that end, we offer an extensive benefits package designed to help you grow, personally and professionally, to keep you healthy, to prepare you for the unexpected, to care for your family and to build a secure future. Depending on your position and your location, here's a look at what you might be eligible for:
* A generous discount on all Williams Sonoma Inc. brands through multiple shopping channels
* A 401(k) plan and other investment opportunities
* Paid vacations, holidays and other time-off programs
* Health benefits, including health, dental and vision insurance; health and dependent care tax-free spending accounts; medical, family and bereavement leave; same-sex domestic partner benefits; short- and long-term disability programs; life and travel insurance; an employee assistance program
* Tax-free commuter benefits
* A wellness program that supports your physical, financial and emotional health
* In-person and online learning opportunities through WSI University, LearnIt
* Cross-brand and cross-function career opportunities
* Quarterly sample sales
* A business casual work environment
* Time off to volunteer
* Matching donations to qualifying nonprofit organizations
* Company-sponsored walks and runs
* Discounts on nearby gyms and other local businesses
Williams-Sonoma, Inc. is an Equal Opportunity Employer.
Williams-Sonoma, Inc. will consider for employment qualified applicants with criminal histories in a manner consistent with the requirements of the San Francisco Fair Chance Ordinance, or other applicable state or local laws and ordinances.