Sr Subject Matter Expert (Support&Ops)

Job description

We are seeking an experienced and highly motivated Senior Database Administrator (DBA) with strong expertise in Oracle, Microsoft SQL Server, PostgreSQL, and Database Automation. The ideal candidate will be responsible for the administration, performance optimization, security, high availability, disaster recovery, and automation of enterprise database environments across on-premises and cloud platforms. The candidate should possess hands-on experience in designing and implementing automation solutions using tools such as Ansible, PowerShell, Python, Shell Scripting, and DevOps pipelines to streamline database operations, improve service reliability, and reduce operational effort. This role requires collaboration with application teams, cloud teams, infrastructure teams, cybersecurity teams, and business stakeholders to deliver highly available, secure, and scalable database services. Key Responsibilities Oracle Database Administration Install, configure, patch, upgrade, and maintain Oracle databases. Manage Oracle RAC, ASM, Data Guard, GoldenGate, and Oracle Enterprise Manager. Perform backup and recovery using RMAN. Conduct database cloning, refreshes, and migrations. Monitor and optimize Oracle database performance. Support Oracle version upgrades and migration projects. Implement security controls, auditing, and compliance requirements. Microsoft SQL Server Administration Administer SQL Server 2016/2019/2022 environments. Manage AlwaysOn Availability Groups, Clustering, Replication, and Log Shipping. Perform database backup, restore, refresh, and migration activities. Monitor database performance and troubleshoot production incidents. Implement indexing strategies and query optimization. Manage SQL Server security, encryption, and compliance controls. PostgreSQL Database Administration Install, configure, and administer PostgreSQL databases. Manage PostgreSQL replication, failover, and high availability solutions. Perform performance tuning and query optimization. Conduct PostgreSQL upgrades and migrations. Implement backup and recovery strategies. Manage schemas, extensions, roles, and security configurations. Database Automation & Platform Engineering Design and implement automation for routine DBA operations. Develop automated workflows for: Database provisioning User management Database refreshes Backup validation Health checks Monitoring and alert remediation Patching and upgrades Capacity management Skill Requirements Ansible PowerShell Shell Scripting Python Git CI/CD Pipelines Develop self-healing mechanisms for recurring database issues. Drive Infrastructure as Code (IaC) and DevOps initiatives within database platforms. Cloud Database Administration Support cloud database platforms including: AWS RDS Oracle AWS RDS PostgreSQL Azure SQL Managed Instance Azure Database for PostgreSQL Support cloud migrations and modernization programs. Optimize cloud database performance and costs. Production Support Provide L3/L4 support for mission-critical production systems. Participate in 24x7 on-call support rotation. Lead troubleshooting during critical incidents and outages. Perform Root Cause Analysis (RCA) and corrective actions. Support Change, Incident, Problem, and Release Management processes. Documentation & Knowledge Management Create and maintain: SOPs Runbooks Architecture Documents Automation Workflows Knowledge Base Articles Conduct knowledge transfer sessions and mentor junior DBAs. Prepare operational and management reports. Mandatory Technical Skills Oracle Oracle RAC ASM Data Guard RMAN OEM SQL Server SQL Server 2019/2022 AlwaysOn Availability Groups Replication Clustering Backup & Recovery Performance Tuning PostgreSQL PostgreSQL 12/13/14/15/16 Replication High Availability Backup & Recovery Performance Tuning Query Optimization Automation Ansible Python PowerShell Shell Scripting Git Jenkins CI/CD Pipelines Infrastructure as Code (IaC) Operating Systems Linux (RHEL, CentOS, Ubuntu) Windows Server Preferred Skills AWS Database Services Azure Database Services Kubernetes & Containers Database Migration & Modernization AI/ML-driven Infrastructure Automation ITIL Service Management Framework Soft Skills Excellent communication and stakeholder management skills. Strong analytical and problem-solving abilities. Experience working in global delivery environments. Ability to lead technical initiatives and mentor team members. Strong customer focus and service-oriented mindset. Other Requirements null Apply now Information at a Glance Why HCLTech? At HCLTech, you'll supercharge your potential. You'll find your career. And you'll find your spark. All at a place that knows that helping its customers stay on top starts by putting its people first. HCLTech is a global technology company, home to more than 223,000 people across 60 countries, delivering industry-leading capabilities centered around digital, engineering, cloud and AI, powered by a broad portfolio of technology services and products. We work with clients across all major verticals, providing industry solutions for Financial Services, Manufacturing, Life Sciences and Healthcare, Technology and Services, Telecom and Media, Retail and CPG, and Public Services. Consolidated revenues as of 12 months ending June 2026 totaled $14.8 billion. Disclaimer Privacy Statement Terms of use Sitemap Raise a Grievance We use cookies on our site. Please read more about cookies policy here. Opens in a new tab. Opens in a new tab. Opens in a new tab. Opens in a new tab. Opens in a new tab. Opens in a new tab. Copyright © 2026 HCL Technologies Limited Cookie Consent Manager When you visit any website, it may store or retrieve information on your browser, mostly in the form of cookies. Because we respect your right to privacy, you can choose not to allow some types of cookies. However, blocking some types of cookies may impact your experience of the site and the services we are able to offer. Required Cookies These cookies are required to use this website and can't be turned off. Required Cookies Required Cookies Provider Description Enabled SAP as service provider We use the following session cookies, which are all required to enable the website to function: "route" is used for session stickiness "careerSiteCompanyId" is used to send the request to the correct data center "JSESSIONID" is placed on the visitor's device during the session so the server can identify the visitor "Load balancer cookie" (actual cookie name may vary) prevents a visitor from bouncing from one instance to another Cookies from provider SAPasserviceprovider are required and cannot be turned off Functional Cookies These cookies provide a better customer experience on this site, such as by remembering your login details, optimizing video performance, or providing us with information about how our site is used. You may freely choose to accept or decline these cookies at any time. Note that certain functionalities that these third-parties make available may be impacted if you do not accept these cookies. Consent to all Functional Cookies Functional Cookies Provider Description Enabled Vimeo Vimeo is a video hosting, sharing, and services platform focused on the delivery of video. Opting out of Vimeo cookies will disable your ability to watch or interact with Vimeo videos. Cookie Policy Privacy Policy Terms and Conditions Consent to cookies from provider Vimeo YouTube YouTube is a video-sharing service where users can create their own profile, upload videos, watch, like, and comment on videos. Opting out of YouTube cookies will disable your ability to watch or interact with YouTube videos. Cookie Policy Privacy Policy Terms and Conditions Consent to cookies from provider YouTube Advertising Cookies These cookies serve ads that are relevant to your interests. You may freely choose to accept or decline these cookies at any time. Note that certain functionality that these third parties make available may be impacted if you do not acce