Database Team Lead

Job Description

• Manage ORACLE and SQL Server DBs through multiple life cycle environments – Dev, QA, Staging and Production.
• Use your deep technical knowledge to analyze and solve critical issues, providing end-to-end problem resolution.
• Assist Development with complex query tuning and schema refinement.
• Perform scheduled maintenance and support release deployment activities, after working hours.
• Escalate from the previous tiers when necessary.
• Plans and analyzes risk associated with system upgrades
• Designs, implements and administers backup and disaster recovery solutions for key databases.
• Helping to implement, deliver and test backups in a way which meets key Recovery Point Objectives.
• Prepare and present status and technical reports as required.
• Troubleshooting DB server service outages as they occur, including after-hours/weekend support.
• Help define and implement DB High Availability strategies including DB Clustering and Always On availability groups.
• As new applications are implemented, help choose the best Recovery Time/Recovery Point objectives, including DB High Availability strategies including DB Clustering and Always-on availability groups, log shipping, replication, etc.
• Identifies faults, raise trouble tickets and provides resolution of complex problem requests.
• Act as the subject matter expert for all services under service catalog and to help troubleshoot specific capacity and performance issues.
• Install and configure new DB servers from scratch.
• Develop and maintain capacity and performance metrics to track overall infrastructure trends
• Establish and maintain Service Level Agreements (SLA) with internal and external customers and ensure the SLA standards are maintained.
• Bi-weekly executive summary of the SLA measurement, program achievements and root cause analysis when SLA targets are not achieved.
• Enforce, maintain, and document compliance, maximum up time and performance with all established standards
• Collaborate with IT teams and management to devise a data strategy that addresses industry requirements

Job Requirements

• Bachelor's degree in communication / computer engineering
• 5-7 years working experience in a similar environment
• Experience managing Oracle RAC.
• Experience Database Replication technologies (e.g., Golden Gate and Data Guard).
• Experience installing, upgrading, and managing Oracle Enterprise Manager.
• Strong query tuning and performance problem-solving skills.
• Strong RMAN backup and recovery skills.
• Strong SQL DDL, DML, and PLSQL coding skills.
• Excellent verbal and written communication skills.
• Database administration experience in MS SQL.
• Extensive working knowledge of Windows, SQL SERVER 2008/2016/2017 including DB Clustering and Always-on availability groups, log shipping, replication, etc.
• Troubleshooting SQL Server & MYSQL issues.
• Experience with Database upgrade, enhancement, and migration.