Lead Database Administrator - Oracle
J OB SUMMARY
Leads in the design, implementation and maintenance of production databases in compliance with application specifications and company policies, standards and procedures. Manages and maintains all production and non-production data bases to include Oracle, SQL, and Teradata).
MAJOR DUTIES AND RESPONSIBILITIES
Actively and consistently supports all efforts to simplify and enhance the customer experience.
- Perform installations and configurations of grid infrastructure, databases, clients etc.
- Design and maintain access and security administration.
- Design, implement and maintain backup and recovery strategies on Database Management Systems.
- Design, install, configure and maintains High Availability (RAC, RAC One Node, Data Guard etc.) Database solutions.
- Plan and organize the team's project and work responsibilities by defining project scope, establishing timelines, organizing project teams, and tracking/assigning deliverables, and working with internal/external departments to achieve project objectives.
- Serve as escalation point in absence of leadership in the troubleshooting of alerts (alert log, jobs, disk group, tablespace, etc.) and performance issues.
- Provide recommendations to team around designs, installs, configures, maintains and troubleshoots High Availability (real application clustering-RAC, RAC One Node, Data Guard etc.) Database solutions.
- Install, configure, troubleshoot and monitor GoldenGate replication.
- Expertise in setup using OEM as a monitoring and diagnostics tool and identifies/resolves the performance issues.
- Troubleshoot and resolve alerts (alert log, Jobs, Disk Group, Tablespace etc.) and performance issues.
- Perform capacity planning of different server environments and provides recommendations to management to sustain business growth.
- Proactively works with development teams to improve database design and procedures on PL/SQL best practices etc.
- Coach and mentor junior Database Administrators as well as provide guidance on work assignments.
- Guide database administration team members and advise leadership by communicating issues to a wide variety of internal and external departments to include technical teams, senior leadership, and vendors.
- Gather business requirements and designs, implements multiple projects along with the production support.
- Create standard operational procedures and templates.
- Perform research and provides plans to remediate complex business problems.
- Represent the database operations team working closely with clients and partners.
- Participate in on call rotation.
- Performs other duties as requested by management.
REQUIRED QUALIFICATIONS
Required Skills/Abilities and Knowledge
- Demonstrated knowledge of Oracle 11g and 12c database architecture and its implementation
- Demonstrated understanding of best practices in maintaining medium to large scale database systems (Oracle, SQL, and/or Teradata)
- In-depth knowledge in Oracle RAC and ASM
- Demonstrated knowledge of Instance, database and query tuning to improve the performance of the database/application
- Demonstrated knowledge of Linux operating systems and shell scripting
- Demonstrated experience with Oracle OEM monitoring
- Expert knowledge of Oracle GoldenGate
- Knowledge of MySQL database
- Advanced knowledge of business awareness, critical analysis, and integration of information as well as the ability to develop action-oriented plans
- Advanced leadership skills and ability to manage instances with multiple operating system platforms.
- Ability to present technical concepts to non-technical audiences.
- Ability to assign tasks to small teams and follow-up on assigned tasks in a 24x7 database support environment.
- Ability to communicate orally and in writing in a clear and straightforward manner
- Ability to communicate with all levels of management and company personnel
- Ability to handle multiple projects and tasks
- Ability to make decisions and solve problems while working under pressure
- Ability to prioritize and organize effectively
- Ability to show judgment and initiative and to accomplish job duties
- Ability to work independently
- Ability to work with others to resolve problems, handle requests or situations
Required Education
BA/BS in Information Technology, Computer Science, or related field or equivalent work experience
Required Related Work Experience and Number of Years
Oracle and various database management systems in testing, implementation, maintenance and administration in a multiple platform environment - 10+ years
Experience working with Oracle/SQL/Teradata and various database management systems in testing, Implementation, maintenance and administration in a multiple platform environment - 8+ years
WORKING CONDITIONS
Office environment
24x7 on-call support
IDB365 315734-1 315734BR
Here, employees don't just have jobs, they build careers. That's why we believe in offering a comprehensive pay and benefits package that rewards employees for their contributions to our success, supports all aspects of their well-being, and delivers real value at every stage of life.
The pay for this position has a salary range of $85,900.00 to $152,300.00. The actual salary offer will carefully consider a wide range of factors, including your skills, qualifications, experience and location. Also, certain positions are eligible for additional forms of compensation such as bonuses.