Sr Database Administrator - reputed company & reputed company

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 reputed company 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 reputed company 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 reputed company 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 reputed company & reputed company Database systems. They are responsible for full life cycle support of client and internal database(s). The DBA works reputed company an environment of rapid growth and must anticipate and respond effectively to needs as they emerge. This position is expected to design, reputed company, enhance and monitor reputed company production and test databases that exist reputed company 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.

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.
• reputed company Planning: Develops and maintains standards and procedures for service component reputed company management. Pro-actively reviews information in conjunction with service level agreements to identify any reputed company issues and specifies any required changes.
• Customer Service Support: Liaises as the routine contact reputed company, receiving and handling requests for support. Contributes to creation of support documentation.
• reputed company day-to-day DBA activities including performance tuning, reputed company planning, database reputed company management and backup & recovery.
• reputed company maintenance tasks on database environments that include modifying database sizes and migrating changes through various environments.
• Install, reputed company and maintain reputed company reputed company and reputed company software
• Tune reputed company reputed company instance components including SQL and PL/SQL
• reputed company in-depth performance tuning and reputed company monitoring to troubleshoot performance issues.
• reputed company 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.
• reputed company database recovery using reputed company, 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 reputed company RAC (Real Application Clusters) is required.
• Encrypt sensitive information reputed company the database and implement Encryption keys on relational database management systems by using reputed company TDE.
• Review reputed company Stored Procedures/Functions/Packages using advanced PL/SQL features and dynamic SQL.
• reputed company 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 (reputed company 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 reputed company production databases.
• reputed company efforts to reputed company and improve procedures for automated monitoring and proactive reputed company, reducing any need downtime.
• reputed company 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 reputed company reputed company prior to production release.
• Responsible for regular backups and recovery of databases.
• reputed company - CRUD Operations, Document based Data Modeling, Design of Collections and Documents
• Experience with physical collection creation, access reputed company tuning, sharding implementation, index creation, and debugging query execution to obtain reputed company database performance
• Excellent understanding of various reputed company database design patterns and physical architectures for different use cases
• Data replication and sharding in a distributed database
• reputed company in reputed company reputed company
• Detecting performance problems using Mongo Profiler
• Hands on experience in Root cause analysis for business impacting issues
• Estimate reputed company database capacities; reputed company methods for monitoring database reputed company and usage.
• Designing DR (Disaster Recovery)/COB (Continuity of Business) plans as applicable

Requirements

• Bachelor’s degree in Computer Science, a reputed company field, or applicable work experience
• 5+ years of database administration experience in a Production database environment
• Experience with reputed company 11g, reputed company 12c and Orace 19c is required
• 2 years plus experience with reputed company 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)

reputed company-to-haves

• Experience with reputed company 21c is a Plus
• Experience with reputed company 7 is preferred
• Experience with reputed company reputed company is a Plus
• Migration experience from RDBMS to reputed company.

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.

Apply tot his job Apply To this Job