Sr Subject Matter Expert (Support&Ops) (IN)

HCLTech

Fresher Warsaw, Łódź Full Time Hybrid (office + remote)
HCLTech logo
Posted : today
Actively hiring

Job description

Seeking a Senior Database Support Specialist to enhance database support for an Oracle Stabilization project. You will collaborate with a dedicated team of employees and external consultants to drive improvements in Nordea's database operations.

This role involves close partnership with the Database Engineering team, focusing on governance, security, architecture, and future infrastructure development. You will also work with an external company responsible for daily support operations in India. The primary goals include minimizing major incidents, optimizing resources (personnel, servers, licenses), and bolstering support for IT operations and development teams.

You will engage in BCI and Root Cause Analysis for escalated Oracle support issues and incidents violating MTTR SLAs. Additionally, you will conduct performance and tuning tasks for Oracle infrastructure and databases experiencing significant stability and performance challenges. This includes addressing the top 5 critical databases with the lowest performance index scores and highest customer impact on a monthly basis.

Responsibilities

Act as a Senior Oracle Administrator (L3) and Subject Matter Expert (SME).

Key responsibilities include: - Leading Oracle database stabilization efforts. - Reducing the frequency and duration of critical incidents. - Optimizing database resources, including server and license utilization. - Enhancing support for internal IT operations and development teams. - Performing deep-dive analysis for escalated Oracle issues and SLA violations. - Conducting performance tuning and investigations for databases with severe stability and performance problems. - Contributing to strategic infrastructure planning and development.

Qualifications

To excel in this role, you should be: - Results-oriented with a proactive approach to automation and optimization. - Analytical, accurate, detail-attentive, and quality-focused. - Accountable for delivering high-quality results. - Collaborative and possess a strong team-player attitude.

Essential knowledge and experience include: - Experience managing a substantial number of Oracle databases (hundreds). - Proficiency in daily DBA management, including diagnosing and troubleshooting issues, rapid service restoration, and providing technical consultation. - Strong SQL development and tuning background (DML/DDL). - Familiarity with concepts like locking, latching, contention, and rollback handling. - Solid understanding of performance testing and capacity planning principles. - Expertise in planning and controlling IT operations, including SOPs, compliance, patching, upgrades, hardening, and monitoring. - Proficiency in spoken and written English at a B2 level. - Prior experience working within a financial institution is highly valued.

The team operates in a hybrid model, requiring at least two days per week in the office.

Essential Skills

Oracle DBADatabase SupportTroubleshootingPerformance TuningSQL DevelopmentRoot Cause AnalysisIncident ManagementEnglish (B2)

Good to Have

Query Plan AnalysisDatabase MonitoringLockingLatchingContentionRollback HandlingCapacity Planning

Highlights

  • Actively hiring

More Details

RoleSr Subject Matter Expert (Support&Ops) (IN)
IndustryBanking, Financial Services
DepartmentOperations
Employment TypeFull Time, Hybrid (office + remote)

About the Company

HCLTech logo

HCLTech

Banking