Lead Administrator - L1

Role Purpose :Oracle Golden Gate

Job Description:
Primary responsibility of this role is to build db level solutions, Performance Optimization of existing app level issues and troubleshooting and at times of need, give in production support to Oracle databases.Ideal candidate should have expert level knowledge of Oracle technology and he should be capable enough to handle complex issues independently and provide resolutions within agreed SLAs, also ensure customer delight, and always adhere to HSBC policies and procedures.Candidate having creative thinking and willing to bring innovations and passionate about working on challenging initiatives will be given preference.Principal responsibilitiesThe job holder is responsible for technical delivery of db level solutions and at times of need, give in production support to Oracle databases.Investigate and provide solutions to database performance related issues.Lead Database team in crisis calls, participate in MIR and PIR calls, also mentor team members.Experience and expertise in maintaining complex High Availability & Replication setups.Provide consultancy for complex setups and Disaster RecoveryIdentify automation and Self-Healing opportunities and develop automation to reduce manual efforts and standardize processes.Required SkillsetStrong technical knowledge of Oracle concepts like RAC, Dataguard & Golden GateExpertise in 12c,19c versions & OEMBuild and Deploy/Implement Solutions. Perform Capacity Planning and DR Planning.Troubleshooting Performance Issues and providing solutions.Expertise in designing Backup & Recovery strategies.Expertise in Role swap & Failover planning and implementation.Strong technical knowledge of database space managementImplementing releases / service requestsExpertise of Golden Gate Replication.Additional SkillsetKnowledge on Oracle CloudKnowledge on UNIX based OSKnowledge of GCP Postgres helps.knowledge of automation tool like Ansible / Puppet / TaniumKnowledge about Agile practices and DevOps tools.Soft skills / Behavioural Qualities:Efficiently manage all tasksTaking ownership of tasks assigned tasks.Proactive approach in taking tasks.Active listening skillsClear, Precise, and Timely communication with Customer/Team Members/ManagementReady to extend help to Prod team as per Business/Project requirements

Do

• Provide adequate support in architecture planning, migration & installation for new projects in own tower (platform/dbase/ middleware/ backup)
  • Lead the structural/ architectural design of a platform/ middleware/ database/ back up etc. according to various system requirements to ensure a highly scalable and extensible solution
  • Conduct technology capacity planning by reviewing the current and future requirements
  • Utilize and leverage the new features of all underlying technologies to ensure smooth functioning of the installed databases and applications/ platforms, as applicable
  • Strategize & implement disaster recovery plans and create and implement backup and recovery plans
• Manage the day-to-day operations of the tower
  • Manage day-to-day operations by troubleshooting any issues, conducting root cause analysis (RCA) and developing fixes to avoid similar issues.
  • Plan for and manage upgradations, migration, maintenance, backup, installation and configuration functions for own tower
  • Review the technical performance of own tower and deploy ways to improve efficiency, fine tune performance and reduce performance challenges
  • Develop shift roster for the team to ensure no disruption in the tower
  • Create and update SOPs, Data Responsibility Matrices, operations manuals, daily test plans, data architecture guidance etc.
  • Provide weekly status reports to the client leadership team, internal stakeholders on database activities w.r.t. progress, updates, status, and next steps
  • Leverage technology to develop Service Improvement Plan (SIP) through automation and other initiatives for higher efficiency and effectiveness

Team Management

• Resourcing
  • Forecast talent requirements as per the current and future business needs
  • Hire adequate and right resources for the team
  • Train direct reportees to make right recruitment and selection decisions
• Talent Management
  • Ensure 100% compliance to Wipros standards of adequate onboarding and training for team members to enhance capability & effectiveness
  • Build an internal talent pool of HiPos and ensure their career progression within the organization
  • Promote diversity in leadership positions
• Performance Management
  • Set goals for direct reportees, conduct timely performance reviews and appraisals, and give constructive feedback to direct reports.
  • Ensure that organizational programs like Performance Nxt are well understood and that the team is taking the opportunities presented by such programs to their and their levels below
• Employee Satisfaction and Engagement
  • Lead and drive engagement initiatives for the team
  • Track team satisfaction scores and identify initiatives to build engagement within the team
  • Proactively challenge the team with larger and enriching projects/ initiatives for the organization or team
  • Exercise employee recognition and appreciation