Senior Oracle Administrator - Oracle Administration,PostgreSQL,MYSQL, MS SQL

India
Job Description

Senior Oracle Administrator - Oracle Administration,PostgreSQL,MYSQL, MS SQL

Lucknow, Uttar Pradesh

Job Summary

Job Summary : Roles and Responsibilities: • SQL Architecture Concepts. • Backup Restore & recovery. • Hands on Experience in Handling SQL version 2008R2/2012/2014/2016/2017/2019 and 2022. • SQL database performance tuning (Indexing/Instance configuration/ stats/ optimizer/ optimizing query join/ execution plan/ object tuning). • Writing SOP/ Technical documents/ scripts. • Hands on knowledge of Azure cloud. • Always On/Clustering concepts and implementation knowledge. • Database Table export/import/role/privileges/user. • Replication configuration & Administration. • Database installation/creation/upgrade/migration. • Understanding of customer strategy and business requirements. • Experience in supporting huge and mission critical database environment. • Extensive troubleshooting skills in fixing database servers’ issues. • Extensive experience in SQL server high availability solutions- Log shipping, Mirroring, Replication, Clustering and always ON. • Strong experience on the database and application upgrade, migration and patching activity • Strong experience in handing performance issues and query optimization • Strong in security concepts and hardening implementation • Strong knowledge on execution of ITIL processes like incident management, change management and problem management • Strong knowledge on database analysis and suggestion to application team / business • Proactive identification of risks and mitigation of the same • Should have the ability to grasp the application related interfaces and it’s relationship with respective infrastructures. • Knowledge of MYSQL technology is plus.

Job Description : Roles and Responsibilities:\\\\r\\\\n\\\\r\\\\n• SQL Architecture Concepts.\\\\r\\\\n• Backup Restore & recovery.\\\\r\\\\n• Hands on Experience in Handling SQL version 2008R2/2012/2014/2016/2017/2019 and 2022.\\\\r\\\\n• SQL database performance tuning (Indexing/Instance configuration/ stats/ optimizer/ optimizing query join/ execution plan/ object tuning).\\\\r\\\\n• Writing SOP/ Technical documents/ scripts.\\\\r\\\\n• Hands on knowledge of Azure cloud.\\\\r\\\\n• Always On/Clustering concepts and implementation knowledge.\\\\r\\\\n• Database Table export/import/role/privileges/user.\\\\r\\\\n• Replication configuration & Administration.\\\\r\\\\n• Database installation/creation/upgrade/migration.\\\\r\\\\n• Understanding of customer strategy and business requirements.\\\\r\\\\n• Experience in supporting huge and mission critical database environment.\\\\r\\\\n• Extensive troubleshooting skills in fixing database servers’ issues.\\\\r\\\\n• Extensive experience in SQL server high availability solutions- Log shipping, Mirroring, Replication, Clustering and always ON.\\\\r\\\\n• Strong experience on the database and application upgrade, migration and patching activity\\\\r\\\\n• Strong experience in handing performance issues and query optimization\\\\r\\\\n• Strong in security concepts and hardening implementation\\\\r\\\\n• Strong knowledge on execution of ITIL processes like incident management, change management and problem management\\\\r\\\\n• Strong knowledge on database analysis and suggestion to application team / business\\\\r\\\\n• Proactive identification of risks and mitigation of the same\\\\r\\\\n• Should have the ability to grasp the application related interfaces and it’s relationship with respective infrastructures.\\\\r\\\\n• Knowledge of MYSQL technology is plus.\\\\r\\\\n

Key Responsibilities

Job Responsibilities : Roles and Responsibilities: • SQL Architecture Concepts. • Backup Restore & recovery. • Hands on Experience in Handling SQL version 2008R2/2012/2014/2016/2017/2019 and 2022. • SQL database performance tuning (Indexing/Instance configuration/ stats/ optimizer/ optimizing query join/ execution plan/ object tuning). • Writing SOP/ Technical documents/ scripts. • Hands on knowledge of Azure cloud. • Always On/Clustering concepts and implementation knowledge. • Database Table export/import/role/privileges/user. • Replication configuration & Administration. • Database installation/creation/upgrade/migration. • Understanding of customer strategy and business requirements. • Experience in supporting huge and mission critical database environment. • Extensive troubleshooting skills in fixing database servers’ issues. • Extensive experience in SQL server high availability solutions- Log shipping, Mirroring, Replication, Clustering and always ON. • Strong experience on the database and application upgrade, migration and patching activity • Strong experience in handing performance issues and query optimization • Strong in security concepts and hardening implementation • Strong knowledge on execution of ITIL processes like incident management, change management and problem management • Strong knowledge on database analysis and suggestion to application team / business • Proactive identification of risks and mitigation of the same • Should have the ability to grasp the application related interfaces and it’s relationship with respective infrastructures. • Knowledge of MYSQL technology is plus.

Skill Requirements

Skill Requirement : Roles and Responsibilities: • SQL Architecture Concepts. • Backup Restore & recovery. • Hands on Experience in Handling SQL version 2008R2/2012/2014/2016/2017/2019 and 2022. • SQL database performance tuning (Indexing/Instance configuration/ stats/ optimizer/ optimizing query join/ execution plan/ object tuning). • Writing SOP/ Technical documents/ scripts. • Hands on knowledge of Azure cloud. • Always On/Clustering concepts and implementation knowledge. • Database Table export/import/role/privileges/user. • Replication configuration & Administration. • Database installation/creation/upgrade/migration. • Understanding of customer strategy and business requirements. • Experience in supporting huge and mission critical database environment. • Extensive troubleshooting skills in fixing database servers’ issues. • Extensive experience in SQL server high availability solutions- Log shipping, Mirroring, Replication, Clustering and always ON. • Strong experience on the database and application upgrade, migration and patching activity • Strong experience in handing performance issues and query optimization • Strong in security concepts and hardening implementation • Strong knowledge on execution of ITIL processes like incident management, change management and problem management • Strong knowledge on database analysis and suggestion to application team / business • Proactive identification of risks and mitigation of the same • Should have the ability to grasp the application related interfaces and it’s relationship with respective infrastructures. • Knowledge of MYSQL technology is plus.

Other Requirements

Other Requirement : Roles and Responsibilities: • SQL Architecture Concepts. • Backup Restore & recovery. • Hands on Experience in Handling SQL version 2008R2/2012/2014/2016/2017/2019 and 2022. • SQL database performance tuning (Indexing/Instance configuration/ stats/ optimizer/ optimizing query join/ execution plan/ object tuning). • Writing SOP/ Technical documents/ scripts. • Hands on knowledge of Azure cloud. • Always On/Clustering concepts and implementation knowledge. • Database Table export/import/role/privileges/user. • Replication configuration & Administration. • Database installation/creation/upgrade/migration. • Understanding of customer strategy and business requirements. • Experience in supporting huge and mission critical database environment. • Extensive troubleshooting skills in fixing database servers’ issues. • Extensive experience in SQL server high availability solutions- Log shipping, Mirroring, Replication, Clustering and always ON. • Strong experience on the database and application upgrade, migration and patching activity • Strong experience in handing performance issues and query optimization • Strong in security concepts and hardening implementation • Strong knowledge on execution of ITIL processes like incident management, change management and problem management • Strong knowledge on database analysis and suggestion to application team / business • Proactive identification of risks and mitigation of the same • Should have the ability to grasp the application related interfaces and it’s relationship with respective infrastructures. • Knowledge of MYSQL technology is plus.

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 230,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 September 2026 totaled $14.8 billion.