
Senior Oracle Administrator Oracle Administration,PostgreSQL,MYSQL, MS SQL
HCLTech · Lucknow, Uttar Pradesh, India
Applications are made on HCLTech's own site. We never sit in the middle.
Job description
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
Other jobs you might want
HCLTech
Lead Administrator (Support &Operations)
Lucknow, Uttar Pradesh, India
HCLTech
Engineer Vmware Workspace ONE
Lucknow, Uttar Pradesh, India
HCLTech
Senior Engineer MS System Center Configuration Manager (SCCM)
Gautam Buddha Nagar, Uttar Pradesh, India
HCLTech
Sr Administrator (Support & Operations)
Gautam Buddha Nagar, Uttar Pradesh, India
HCLTech
Support Analyst Customer Care
Noida, Uttar Pradesh, India
HCLTech
Process Manager
Chennai, Tamil Nadu, India