Sr Subject Matter Expert (Support&Ops)
India
Apply now
Job Description
Sr Subject Matter Expert (Support&Ops)
Noida, Uttar Pradesh

Job Summary

All responsibilities associated with Rocket Universe Database Administrator Provide expert support for production Application databases with respect to availability, reliability, and integrity for Rocket Universe Provide expert support for Applications databases in the development and test environments Work with Application developers and their logical data models, create physical Application database designs which conform to industry standards (e.g.,data normalization), optimize performance and efficiently utilize disk space, size tables and indexes for production implementation based on projected row counts provided by Applications Create complex new databases and Application database objects (eg, tables, indexes, procedures), and as requirements change, update data structures/objects in existing databases Coordinate production database deployment including tasks to promote database objects between environments (e.g.,test to production) in support of Application requirements Provide technical leadership to Application developers in database capabilities and features, build efficient queries, database design, Application database Problem Resolution, and the use of database utilities

Key Responsibilities

BA/BS in Computer Science or related field or an equivalent combination of education or experience, Master’s Degree preferred Five to seven years of experience in information technology, with at least four years of experience as a relational database administrator Advanced knowledge of networking concepts, object-oriented technology, data warehousing, and relational database engines Advanced proficiency in analytical, project planning, negotiating, interpersonal, and communication skills (written and oral) SQL database knowledge will be added advantage Oracle or DB2 knowledge will be added advantage

Skill Requirements

Rocket Universe Database Administrator

Other Requirements

Provide technical leadership to Application developers in database capabilities and features, build efficient queries, database design, Application database Problem Resolution, and the use of database utilities \\\\r\\\\n\\\\r\\\\nEvaluate Database Configurations and provide recommendations for improvement \\\\r\\\\n\\\\r\\\\nDocument unsupported Database versions, where they are used, the Applications that use them and actively seek to either upgrade, retire, or migrate them to alternate platforms \\\\r\\\\n\\\\r\\\\nPlan for table space utilization and develop migration plans to ensure data integrity prior to anticipated Technical Changes, expansions, or migrations to new or changed space allocation \\\\r\\\\n\\\\r\\\\nImplement Database archive processes and procedures \\\\r\\\\n\\\\r\\\\nPerform Database re-indexing, stored procedure rebuilds, Database defragmentation, and purging obsolete Database definitions and procedures \\\\r\\\\n\\\\r\\\\nProvide activities including index rebuilds or reorgs, verification of integrity, Database shrinking, and statistics updating \\\\r\\\\n\\\\r\\\\nPerform Database shutdowns and restarts as required \\\\r\\\\n\\\\r\\\\nMonitor Database logging systems including Database lock errors and trouble shoot causes

 
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.