Database Lead (Oracle)

1

ORACL DBA & RAC

Expert Troubleshooting & Resolution: Act as the final escalation point (L3/L4) for all

critical, complex, and high-impact production issues related to Oracle Database, Oracle

RAC, ASM, and Data Guard. Perform root cause analysis (RCA) and implement

permanent solutions.

● High Availability & Disaster Recovery (HA/DR):

○ Design, implement, and manage complex HA/DR solutions using Oracle RAC,

Data Guard (Physical and Logical), and Active Data Guard.

○ Perform multi-node cluster configuration, maintenance, and advanced

troubleshooting for Oracle RAC.

○ Lead disaster recovery planning, testing, and execution.

● Performance Tuning & Optimization:

○ Perform advanced SQL and PL/SQL tuning, query optimization, and

application-level performance analysis.

○ Proactively monitor and tune database parameters, memory structures (SGA/PGA),

and I/O to ensure peak performance for VLDBs (Ver y Large Databases).

○ Utilize tools like AWR, ASH, and OEM for in-depth performance diagnostics.

● Database Management & Strategy:

○ Lead major database upgrade and migration projects (e.g., cross-platform,

version upgrades).

○ Develop and enforce database security policies (e.g., encryption, auditing,

user/role management).

○ Design and implement capacity planning and storage strategies for future growth.

● Mentorship & Automation: Mentor L1/L2 DBA teams. Drive the automation of complex

and routine DBA tasks using scripting (Shell, Python, Ansible) and Oracle management

tools.

● Architecture & Design: Collaborate with Solution Architects and Development teams on

new database deployments and architectural standards.

2

SQL DBA, MSSQL

High Availability & Disaster Recovery (HA/DR):

○ Design, configure, and manage high-end HA/DR solutions, including Always On

Availability Groups (AGs), Failover Cluster Instances (FCIs), Replication, and

Log Shipping.

○ Expertly troubleshoot complex AG and FCI failovers, synchronization issues, and

network dependencies.

● Performance & Query Optimization:

○ Perform deep-dive performance analysis, including analyzing execution plans,

identifying bottlenecks, and optimizing highly complex T-SQL queries and stored

procedures.

○ Manage and optimize indexes, statistics, and buffer pool configurations.

○ Tune SSIS packages and SSRS reports for efficiency.

● Database Strategy & Security:

○ Plan and execute major SQL Server upgrades, patching, and migrations (cloud

and on-premise).

○ Implement and audit security controls, including encryption (TDE), authentication

modes, and granular permission management.

○ Develop and maintain standards for database design and configuration hardening.

● Automation & Scripting: Develop advanced PowerShell and/or Python scripts to

automate monitoring, maintenance, capacity reporting, and patching processes.

● Cross-Functional Leadership: Partner with infrastructure, development, and application

teams to define database standards, provide technical guidance, and ensure optimal

resource utilization.