Sr Database Administrator - Oracle & MongoDB

Ulta Beauty, Inc.•Bolingbrook, IL

12d•Hybrid

About The Position

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.

Requirements

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
2 years plus experience with MongoDB is required
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)

Nice To Haves

Experience with Oracle 21c is a Plus
Experience with MongoDB 7 is preferred
Experience with MongoDB Atlas is a Plus
Migration experience from RDBMS to MongoDB.

Responsibilities

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.
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

Benefits

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.

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume