SQL & Oracle DBA

Responsibilities

Serve as Senior engineer for Microsoft SQL Server, Oracle and other database technologies.

Responsible for database backup and restore functions including scheduled tests of DR availability, including knowledge of MS SQL restoration and availability technologies such as Clustering, Replication and especially Always‑On.

Actively participate in CAB meetings, DORM Calls, escalation calls, improvement sessions.

Perform MS SQL production instance / database level performance tuning.

Understand SQL parameter / configuration file enhancements and deep tuning.

Participate in SQL code‑reviews for application teams to enforce SQL coding standards.

Build and report on SQL environment performance and availability metrics and take appropriate actions to implement best practices and optimize performance.

Assist in the technical analysis and design for current and future projects.

Write appropriate SQL scripts to extract data efficiently and in a timely manner.

Install database software / features on servers as needed.

Monitor databases for performance and issues using monitoring tools.

Ensure all database servers are managed to Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO).

Work closely with vendors and external support to provide a stable environment.

Architect and maintain Oracle RAC, Data Guard, ASM, and backup / restore strategies.

Lead performance tuning, patch management, and complex incident resolution.

Manage Oracle database lifecycle : provisioning, migration, upgrades.

Ensure high availability and replication readiness across DCs.

Maintain database consistency at a high level.

Implement automation for routine tasks using PowerShell / T‑SQL / PL‑SQL scripting, Cron jobs and SQL jobs.

Ensure NCA and NDMO compliance, secure data handling, and auditing.

Mentor L2 Oracle / SQL engineers and interface with solution architects.

Mandatory Skills

Bachelor’s degree in a relevant field or equivalent combination of education and experience.

Typically 6+ years of relevant work experience in industry, with a minimum of 2+ years in a similar role.

Advanced skills in Oracle 19c+, RAC, Data Guard, RMAN, OEM, SQL 2014, SQL 2017, SQL 2019, SSIS, SSRS.

Expertise in SQL optimization and schema tuning, capacity tuning and deep database troubleshooting.

Expertise in using tools such as SQL Profiler, extended events, default trace, Windows performance counters.

Experience with large database environments.

Experience in hybrid cloud database setups.

Knowledgeable with automation, reporting, automatic performance tuning.

Strong knowledge of industry‑standard database management practices and methodologies.

Nice‑to‑Have Skills

Oracle Certified Professional (OCP).

Professional certification in database administration.

PowerShell.

Windows & Unix administration.

ITIL.

#J-18808-Ljbffr