Track Lead - Oracle Administration,PostgreSQL,MYSQL, MS SQL
India
Apply now
Job Description
Track Lead - Oracle Administration,PostgreSQL,MYSQL, MS SQL
Chennai, Tamil Nadu

Job Summary

Responsibilities: - PostgreSQL

  • Adhering to SLAs.
  • Mentoring / Training Team Members.
  • Handling tickets / requests.
  • Perform root cause analysis.
  • Troubleshooting technical issues.
  • Creating [SOP/MOP's] and ensuring that the processes are adhered to.
  • Oversees and is responsible for successful completion of database tasks.
  • Responsible for maintaining customer database standards.
  • Responsible for strategizing a backup plan and test plan for failure scenario.
  • Improves and maintains customer satisfaction.
  • Suggests Database environment Gaps, Improvements and new technologies.
  • Monitoring and maintaining SLA requirements by the team members.
  • Identify Skill gaps and plan for training / knowledge updating.
  • Escalating P1/P2 to L3/Customer to maintain SLA’s.

 

Technical Requirements                                   

  • Proficient in managing EDB PostgreSQL databases [HADR and replication] - installation, configuration, upgrade, patching, maintenance, security, sysadmin functions and administration.
  • Proficient in managing PostgreSQL DR [Replication] - installation, configuration, upgrade, patching, maintenance, DR Drills
  • Knowledge of PEM [PostgreS Enterprise Manager] - Managing, Configuring, setting up alerts and troubleshooting
  • Maintain Database Standards and Architecture                                 
  • Install, Configure new Postgresql database software’s.
  • Configure new database – HADR, Replication as per the customer standards.                                 
  • Apply database Patches and bugfixes.
  • Upgrade databases as per the customer roadmap.                           
  • Testing and Impact Analysis for Database Migration/Upgrade                                          
  • Technical Consultation to L1 and Customer                                      
  • Vendor Support and Interaction                                        
  • Monitor database environment – Availability, security, capacity and performance.            
  • Troubleshoot database issues, maintain database systems availability and scalability.                                  
  • Performs the capacity planning required to create and maintain the databases.                               
  • Work closely with Server, Backup and storage administrator to meet Backup, Hardware, Storage and Operating system requirements.
  • Work closely customer to understand the requirements and standards.                                           
  • Perform ongoing analysis and tuning of the Postgresql database.                                    
  • Application code promotion and migrations of programs, database changes, reference data changes and menu changes through the development life cycle if applicable.  
  • Performs database re-organizations as required to assist performance and ensure maximum uptime of the database.
  • Troubleshoots with problems regarding the databases, replication and database related Tools.                    
  • Good knowledge of physical database design.                   
  • Ability to perform database and operating system performance monitoring and the necessary adjustments.        
  • Excellent skill in High availability, replication technologies and failover                                            
  • Implement and enforce security requirements for Postgresql databases.                                         
  • Recommend and Review Backup and Recovery Strategies.                               
  • Provides technical support to application development teams.                                         
  • Having experience of DR/Replication Solution/Implementation/Execution through various sync methods.             
  • Good knowledge of the Unix operating system(s)                             
  • Generate DB reports for RCA related to Incident Management
  • Analyze DB performance reports and provide analysis.
  • Generate DB reports for Audit/Compliance exercises.
  • Weekly review of incidents/tickets
  • Weekly review of CHGs completed/Canceled.
  • Weekly review of recommendations made to the DBs.
  • Automate routine DB jobs.
  • Optimize day-today DB activities.
  • Documentation and DB procedures write-up
  • Oracle knowledge is added advantage.

 

Key Responsibilities

Key responsibilities: Oracle DB 

  • Use considerable technical expertise and judgement to define and implement technical database solutions that support the business needs.
  • Provide optimization and design skills, including deployment and support in the oracle database systems both on-premise and cloud.
  • Provisioning and administration of oracle in cloud - OCI, Azure, AWS.
  • Refine / Develop database strategies and capacity planning.
  • Ensure database system desired performance and security baselines are met as per business need.
  • Ensure HA / DR database environments are operational and consistent as per business requirements.
  • Perform housekeeping tasks to maintain the database environment.
  • Identify opportunities for continuous improvement in work practices.
  • Participate in after-hours changes and patching.
  • Provide strategic input to design and quality assurance of database technology solutions.
  • Confer with systems users to develop areas of change in requirements, which permit greater efficiency, systems integration, or cost reduction.
  • Provide effective and efficient database system support to customers meeting all ticket / requests / Change SLAs.
  • Assist application support teams with performance tuning and troubleshooting.
  • Contribute to the creation of technical strategies.
  • Continually evaluate working practices and procedures to help the implementation of cost-effective database methodologies.
  • Mentoring / Training Team Members.
  • Handling tickets / requests.
  • Perform root cause analysis.
  • Troubleshooting technical issues.
  • Defining processes [SOP/MOP's] and ensuring that the processes are adhered to.
  • Oversees and is responsible for successful completion of database tasks.
  • Responsible for maintaining customer database standards.
  • Responsible for strategizing a backup plan and test plan for failure scenario.
  • Improves and maintains customer satisfaction.
  • Suggests Database environment Gaps, Improvements and new technologies.
  • Monitoring and maintaining SLA requirements by the team members.
  • Identify Skill gaps and plan for training / knowledge updating.
  • Ensure Oracle database system desired performance and security baselines are met as per business need.
  • Ensure HA / DR database environments are operational and consistent as per business requirements.
  • Identify opportunities for continuous improvement in work practices

    Additional responsibilities include:

    • Provide strategic inputs / advice on end to end Database Solutions for Technology projects.
    • Research and drive long term database strategies and solutions.
    • Availability for out of hours scheduled work such as change implementation and Disaster Recovery tests.
    • Liaison with customers and vendors.
    • Provide consultancy to other technical and project teams regarding technical issues pertaining to database environments.
    • Develop and maintain installation, configuration and maintenance policies and standards
    • Participate in disk space management.
    • Execution of major and minor database work requests.

Skill Requirements

Oracle DB
Experience in setting up the OCI foundation for the project to start.

  • Worked on setting on Oracle Cloud Resources VCN, Subnet, Compute, Block Storage, File Storage.
  • Good experience in multiple databases offering in OCI like Autonomous DB, DBCS, ExaCS, ExaCC.
  • Good experience with various method of migrating database from On-Premise to Oracle Cloud with minimum downtime.
  • Good experience with various method of migrating database from other cloud to Oracle Cloud with minimum downtime.
  • Experience in network connectivity from Oracle Cloud to On-Premises.
  • Experience in network connectivity between Oracle cloud and AWS/Azure cloud.
  • Experience in Setting up necessary policies, groups, compartments and domains (IAM)
  • Experience in creating and managing users, groups and policies.
  • knowledge of OCI security best practices. OCI governance and compliance
  • Experience in logical segregation of resources using compartment at different level.
  • Expertise of implementing environment hardening at different level.
  • Experience in configuring and optimizing compartments / tags / policies to manage cost effective OCI usage; Identify under- & over- utilized resources.
  • Experience in capacity planning, space management, database upgrades/migration
  • Experience in Logical and Physical Design of Databases for OLTP and Data Warehouse.
  • Expertise in handling Very Large Database (VLDB) and OLTP environment
  • Expertise in Performance tuning. Optimize OCI resources for cost-efficiency and performance
  • Experience in Oracle 12c, 19c – Installation and implementation
  • Expert in ORACLE Database Administration including planning/implementing backup/recovery strategies
  • Experience Installing and Managing RAC environment for Day-to-Day Database administrator.
  • Implement OCI Monitoring solutions for various applications and OCI resources
  • Knowledge of Terraform, Ansible, or shell scripting for Infrastructure as Code (IaC) and automation.




Other Requirements

Role:Oracle database administrator
Total years of experience:10 -15+
YearsRelevant experience for engagement:> 8 Years
Relevant Technology domain

  • Oracle Certified professional
  • Knowledge of other cloud environment – OCI, AWS, Azure
  • Oracle Databases – 12c, 19c and above.
  • Oracle RAC and Data Guard Setup
  • Tools:  OEM, Golden Gate
  • Operating System: Unix, RHEL

    PostgreSQL 
    Experience - 12+ year of hands-on experience working on PostgreSQL database technologies
    Certification -Postgresql Professional [Essential]
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 226,300 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 December 2025 totaled $14.5 billion.
23 Benefits At HCLTech, we believe in empowering our employees with comprehensive benefits that support their professional growth and enhance their well-being. When you sign up for a career with us, you gain access to: https://rmkcdn.successfactors.com/147eb21f/a701dca9-f32d-4fc9-9447-6.svg Industry-benchmarked compensation https://rmkcdn.successfactors.com/147eb21f/b0c54381-ddcc-4a33-9b35-9.svg Best-in-class healthcare benefits https://rmkcdn.successfactors.com/147eb21f/b73027be-7aae-4d36-a090-4.svg Personal time off https://rmkcdn.successfactors.com/147eb21f/d5b4fdfd-2e99-4e26-9878-9.svg Maternity and paternity benefits https://rmkcdn.successfactors.com/147eb21f/3d42b0fc-4652-435a-9ece-c.svg Access to skills / higher education programs/resources https://rmkcdn.successfactors.com/147eb21f/aeddeaf2-9e25-4584-ad11-d.svg Discounts on products and services via Benefit Box https://rmkcdn.successfactors.com/147eb21f/a9609a3b-2700-4b3c-9d90-a.svg Participate in CSR programs and live life with a purpose https://rmkcdn.successfactors.com/147eb21f/c6e33851-710f-4634-bd69-f.svg Opportunities to grow and advance your career Note: The benefits listed above vary depending on the nature of your employment and the country where you work. Some benefits may be available in some countries but not in all.