Sr IT Engineer Oracle Database

OVERVIEW 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 Engineer plays a critical role in engineering, design, maintenance, installation, and troubleshooting of Oracle & MongoDB Database systems. They are responsible for full life cycle support of client and internal database(s). The DBA works within an environment of rapid growth and must anticipate and respond effectively to needs as they emerge. This position is expected to design, develop, enhance and monitor all production and test databases that exist within the technical architecture. The Database Administrator will be working with development and customer support, providing technical and operational support activities of Database Servers, including logical and physical database design support, troubleshooting, performance monitoring, tuning, and optimizing. YOU'LL ACCOMPLISH THESE GOALS 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 and MongoDB 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. 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. MongoDB - CRUD Operations, Document based Data Modeling, Design of Collections and Documents Experience with physical collection creation, access pattern tuning, sharding implementation, index creation, and debugging query execution to obtain optimum database performance Excellent understanding of various MongoDB database design patterns and physical architectures for different use cases Data replication and sharding in a distributed database Experienced in MongoDB Security Detecting performance problems using Mongo Profiler Hands on experience in Root cause analysis for business impacting issues Estimate MongoDB database capacities; develop methods for monitoring database capacity and usage. Designing DR (Disaster Recovery)/COB (Continuity of Business) plans as applicable ESSENTIALS FOR SUCCESS: Bachelor's degree in Computer Science, a related field, or applicable work experience 5+ years of database administration experience in a Production database environment Experience with Oracle 11g, Oracle 12c and Orace 19c is required Experience with Oracle 21c is a Plus 2 years plus experience with MongoDB is required Experience with MongoDB 7 is preferred Experience with MongoDB Atlas is a Plus Migration experience from RDBMS to MongoDB. Scripting and programming experience 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 24x7 on-call required Minimal travel required (training/conferences) #LI - HYBRID #LI - ML1 The pay range for this position is $102,900.00 - $145,000.00 / Year with the opportunity for eligible associates to earn additional compensation pursuant to the Company's bonus plan. Exact pay will be based on factors including, but not limited to relevant education, qualifications, certifications, experience, level, shift, geographic location, and business and organizational needs. Full-time positions are eligible for paid time off, health, dental, vision, life and disability benefits. Part-time positions are eligible for dental, vision, life, and disability benefits. For additional information concerning our benefits, visit our Benefits and Career Development page: 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.

Created: 2026-03-11