Database Engineer III-ascena
Brand Overview:
ascena retail group, inc. is a leading national specialty retailer offering apparel, shoes, and accessories for women under the Premium Fashion segment (Ann Taylor, LOFT, and Lou & Grey), Value Fashion segment (maurices and dressbarn), Plus Fashion segment (Lane Bryant and Catherines), and for tween girls under the Kids Fashion segment (Justice). ascena retail group, inc. operates ecommerce websites and approximately 4,800 stores throughout the United States, Canada and Puerto Rico.Ready to ? We currently have an opportunity for a Database Engineer III-ascena to join our team located at our Ascena Corp ETNA-ascena-Pataskala, OH 43062.Position Overview:
Oracle Database Administrator III
Ascena Retail Group, Inc. (NASDAQ - ASNA), is a leading national specialty retailer of apparel for women, tween girls and boys, operating through a family of wholly-owned subsidiary brands: dressbarn, maurices, Justice, Lane Bryant, and Catherines.
Through our subsidiaries, we operate over 3,900 stores throughout the United States, Puerto Rico and Canada, with annualized revenues of over $4.5 billion. Although each brand is truly unique, we all share a common goal: We make people feel good about themselves. By offering an engaging customer experience and the latest fashions at a great value, we help our customer’s look and feel their very best!
At Ascena, talented people are our greatest asset. In return for your talent and hard work, we offer career development, excellent benefits, a competitive compensation package and generous merchandise discounts across our brands.
What you'll do:
Under limited supervision, this senior level database administrator manages and maintains all production and non-production databases. Responsible for standards, design of physical data storage, maintenance, access and security administration. Will create detailed architecture and support documentation that can be used by other team members. Performs backup and recovery, configures database parameters and prototype designs against logical data models, defines data repository requirements, data dictionaries and warehousing requirements. This position reviews database access (SOX/PCI) and allocates/re-allocates database resources for optimum configuration, database performance and cost. Works with other team members to troubleshoot complex issues associated with database and applications associated to databases.
Position Responsibilities:
- Designs and build Oracle database RAC environments.
- Design and document database architecture.
- Data Modeling.
- Troubleshooting and performance tuning Oracle databases.
- Working with application owners to resolve database issues.
- Operations and Monitoring of the environment.
- Patching and upgrades.
- Performing backup and cloning.
- Participates in the 24/7 on-call rotation
Minimum Job Requirements:
- Bachelor’s degree in Computer Science, Engineering or related discipline is required, and an advanced degree is a plus
- Minimum of 10 years of Oracle Database Administration experience
- Hands-on experience administering Oracle databases version 9i, 10g, 11g and 12c. Experience with Oracle RAC is required
- Hands-on experience installing, configuring and administering Oracle databases on physical, virtual and RAC environments in production.
- Experience with performance tuning in RAC environment is a must
- Experience with RMAN backup/restore and cloning
- Experience with Oracle Grid 12c monitoring
- Excellent knowledge of P/L SQL
- Demonstrated ability to create batch scripts for task automation
- Experience with mid to large size organizations
- Demonstrated ability to be highly organized and results driven
- Excellent verbal and written communication skills
- Experience supporting Retail application databases is a plus
- Experience with MS-SQL, IBM Netezza, Cassandra or Teradata is a plus
- Relative certifications are plus, such as Oracle OCA, OCP, OCM
- Experience with Sarbanes Oxley and or PCI is a plus.
- Ability to be on call 24x7 and have a flexible work schedule
#LI-JH1
Location:
Ascena Corp ETNA-ascena-Pataskala, OH 43062Position Type:
Regular/Full timeEqual Employment Opportunity
The Company is committed to hiring and developing the most qualified people at all levels. It is our policy in all employment decisions to ensure that all associates and potential associates are evaluated on the basis of qualifications and ability without regard to sex (including pregnancy), race, color, national origin, religion, age, disability that can reasonably be accommodated without undue hardship, genetic information, military status, sexual orientation, gender identity, or any other protected classification under applicable law. We do not discriminate in any of our employment policies and practices. All associates are expected to follow these principles in all relationships with other associates, applicants, or others with whom we do business.
The Company welcomes applications from people with disabilities. Accommodations are available on request for candidates taking part in all aspects of the application process.
Note to Applicants: Smoking is prohibited in all indoor areas of the Company unless designated smoking areas have been established by a particular location in accordance with applicable law.