Senior Engineer – Manager- Platform Databases

18 نوفمبر، 2022

0 0 2 دقائق

Job Description

Job Description
Generic Accountability

Senior Engineer – Manager as part of the Core Delivery team aligned to a particular service
Ideally through experience you will enhance your skills across multiple specializations

Specific Accountability

Lead the team of the database engineers/DBAs
Support production Oracle databases on-prem and in public cloud
Oracle database administration, performance tuning & backup
HA management (Real Application Clusters, Oracle Data Guard)
Database performance and problem management
Underlying OS troubleshooting & solving problems related to database
Vendor/OEM coordination
Plan and execute database DR activities
Major incidents/Severity 1 call handling and leading to resolution across multiple teams
Preparation of the RCA (Root Cause Analysis)
Adhere to Change Management Process
Mentor other team members and junior engineers
Implement industry-best practices (Service Improvement Plans)
Document risks/SPOF in databases
Actively participate in various technology projects as a SPOC from the Platform Databases team
Additional work experience with PostgreSQL & MYSQL would be an added advantage

Qualifications

10+ Years of Experience in Oracle Database Management (e.g. Incident, Problem, Change, Configuration, Availability, IT Continuant Management)
Deep expertise in Oracle technology stacks and ability to quickly learn new technologies
Ability to coach and guide the team of Engineers
Ability to identify requirements and create a solution architecture that meets identified requirements
Proficiency in troubleshooting software or infrastructure issues, troubleshooting using tools or debugging a large codebase
Improves team operation practices by incorporating best practices
Successfully launches new features or re-architects old features.
Extensive service Management, scripting, packaging tools, or programming knowledge
Identifies and evaluates new technologies & DB new features for implementation
Strong analytical and reasoning skills with an ability to visualize processes and outcomes
Continually improves system monitoring and alerting
Identifies and fixes the security vulnerabilities
Ability to develop test plans and quality assurance procedures
Recommends changes in policies and procedures
Extensive Oracle database administration experience in senior DBA function for large organization. Deployment, operations, tuning, backup, security.
Expert in performance tuning, capacity management and troubleshooting large Oracle DB deployments with continuous availability requirements.
Responsible for day-to-day monitoring, patch analysis and deployments.
Expertise in cloning / refreshing production application and database to non-production instances.
Coordinate with Team Lead to ensure that the associated hardware resources are allocated to the databases and ensure high availability and optimum performance
Design and implementation of high availability environments utilizing Oracle RAC, Data Guard etc
Proactively monitor the database systems to ensure secure services with minimum downtime
Provide 24.7 support for production systems
Oracle TDE Implementation & network level encryption using Oracle utilities
Respond to database related outages within the SLA timelines and provide detailed RCA
Implement changes/deployments to the production environment as per the change management guidelines.
Ability to work independently on all complex projects and to collaborate with various infrastructure groups (Server, Network, Storage etc)
Proactively monitoring the database's health and taking preventive or corrective action as required
Installation, configuration and upgrading of Oracle server software related products & Patch Management and Version Control
Establish and maintain sound backup and recovery policies and procedures
Implement and maintain database security (create and maintain users and roles, assign privileges)
Perform database tuning and performance monitoring
Setup and maintain documentation and standards
Plan growth and changes (capacity planning)
Ability to handle multiple projects and deadlines
Interface with Oracle Corporation for technical support.
Advance knowledge in Oracle database architecture and features, both in private and public cloud environments. (Azure & AWS)
Experience with Oracle Enterprise Manager
Experience with other RDBMS – MY-SQL, PostgreSQL
Experience in creating and maintaining UNIX shell and Perl scripts.
Experience in ITIL Processes