Ulta Beauty Hiring For Sr IT Engineer Oracle Database at Bolingbrook, IL Full Time

Live the experience. From professional empowerment to continual learning opportunities. From ongoing investment in new and emerging technologies to a career of self-determination. At Ulta Beauty, our tech team is critical to our scalability-and is recognized that way. We’ve been defined as a “mature start-up.” A place where interdepartmental exposure, open doors, and genuine collaboration is ubiquitous. Where challenges come fast and furious, requiring agility, mental dexterity, and creativity. Where our passion for better solutions drives us and is core to who we are.

We’re engineering for the future of retail, and it’s no-holds-barred. But for those motivated by continual change and ambiguity, by superior leadership, by whip smart colleagues who will press you daily for your very best, you’ll find that virtually nothing’s impossible at Ulta Beauty.
THE IMPACT YOU CAN HAVE:

The Senior Database Engineer plays a critical role in design, maintenance, installation, and troubleshooting of Oracle & PostgreSQL Database systems. This position is expected to design, develop, enhance, tune, optimize and monitor all production and test databases that exist within the technical architecture. The Database Administrator will also be working with the development team and customer support, providing technical and operational support activities of Database Servers.

YOU’LL ACCOMPLISH ALL OF THIS BY:

• Project Management: Defines, documents and carries out small projects. Carries out project approach with stakeholders, and prepares realistic plans (including quality, risk and communications plans) and documents activities against the project schedule, liaising with stakeholders as appropriate.
• Systems Integration: Designs and builds integration components and interfaces. Leads practical integration work under the technical direction of the system /service designer. Contributes to the overall design of the service and assesses the technical criteria for product or component selection.
• Business Process Improvement: Analyzes business processes; identifies alternative solutions, documents feasibility, and recommends new approaches. Contributes to evaluating the factors which must be addressed in the change program. Helps establish requirements for the implementation of changes in the business process.
• Capacity Planning: Develops and maintains standards and procedures for service component capacity management. Pro-actively reviews information in conjunction with service level agreements to identify any capacity issues and specifies any required changes.
• Customer Service Support: Liaises as the routine contact point, receiving and handling requests for support. Contributes to creation of support documentation.

ADDITIONAL RESPONSIBILITIES:

• Perform day-to-day DBA activities including performance tuning, capacity planning, database security management and backup & recovery.
• Perform maintenance tasks on database environments that include modifying database sizes and migrating changes through various environments.
• Install, patch and maintain all Oracle software.
• Tune all Oracle instance components including SQL and PL/SQL.
• Perform in-depth performance tuning and capacity monitoring to troubleshoot performance issues.
• Perform database recovery and troubleshoot failures of backup processes.
• Work closely with Application teams to resolve the performance of SQL queries by creating SQL Profiles, SQL Baselines, SQL tuning, Index tuning and database tuning.
• Perform database recovery using RUBRIK, RMAN-Managed Recovery and performed FLASHBACK features to handle efficient database recovery.
• Support backup and recovery strategies and operational procedures to safeguard against data loss.
• Use Data Pump utilities and traditional export import utilities for logical backup and recovery.
• Manage high availability of production systems. Experience with installation, configuration and administration of Oracle RAC (Real Application Clusters) is required.
• Encrypt sensitive information within the database and implement Encryption keys on relational database management systems by using Oracle TDE.
• Review Oracle Stored Procedures/Functions/Packages using advanced PL/SQL features and dynamic SQL.
• Shell scripting for automating maintenance tasks
• Configure and maintain physical, Logical standby databases using Data Guard (Active & Passive) to ensure disaster recovery and data protection.
• Use OEM (Oracle Enterprise Manager) Monitoring or monitoring using SQL scripts to identify run-time performance problems with resource intensive long-running sessions.
• Responsible for the monitoring and uptime of all production databases.
• Estimate PostgreSQL database capacities; develop methods for monitoring database capacity and usage.
• Lead efforts to develop and improve procedures for automated monitoring and proactive intervention, reducing any need downtime.
• Develop Stored Procedures and Database Triggers in support of application development.
• Participate in application development projects and be responsible for the database architecture and design.
• Participate in the creation of development, staging, and production database instances, and the migration from one environment to another.
• Responsible for developer SQL code review to ensure queries are optimized and tuned to perform efficiently prior to production release.
• Responsible for regular backups and recovery of databases.

THE ESSENTIALS FOR SUCCESS:

• Bachelor’s degree in Computer Science, a related field, or applicable work experience
• 3+ years of database administration experience in a Production database environment
• Experience with Oracle 11g and Oracle 12c is required
• Experience with Oracle 19c is a Plus
• Experience with EDB PostgreSQL is a Plus
• Experience with PostgreSQL 9.5, PostgreSQL 11 and PostgreSQL 12 is preferred
• Experience with EFM (Enterprisedb Failover Manger) is a Plus
• Demonstrate decision making, problem solving and analytical skills with particular attention given to detail and accuracy
• Strong team player with proven experience to collaborate with other server, network, storage engineers and administrators
• Excellent communication skills; feels comfortable working with non-technical business partners
• Able to follow-up, follow through and deliver quality and timely results
• Able to prioritize workloads and adjust schedule to meet deadlines
• Able to adapt to rapidly changing technologies and apply them to evolving business needs
• Off-Hours support including 24×7 on-call required
• Minimal travel required (training/conferences)

#LI-CS1

COLORADO PAY RANGE

At this time, Colorado residents are not eligible for this position.

ABOUT

At Ulta Beauty (NASDAQ: ULTA), the possibilities are beautiful. Ulta Beauty is the largest North American beauty retailer and the premier beauty destination for cosmetics, fragrance, skin care products, hair care products and salon services. We bring possibilities to life through the power of beauty each and every day in our stores and online with more than 25,000 products from approximately 500 well-established and emerging beauty brands across all categories and price points, including Ulta Beauty’s own private label. Ulta Beauty also offers a full-service salon in every store featuring-hair, skin, brow, and make-up services.

We will consider for employment all qualified applicants, including those with arrest records, conviction records, or other criminal histories, in a manner consistent with the requirements of any applicable state and local laws, including the City of Los Angeles’ Fair Chance Initiative for Hiring Ordinance, the San Francisco Fair Chance Ordinance, and the New York City Fair Chance Act.