Senior Technical Specialist (Bengaluru)

Senior Technical Specialist (Bengaluru)

21 Nov
|
HCLTech
|
Bengaluru

21 Nov

HCLTech

Bengaluru

Job Summary

Must:

- Minimum 10-15 years of experience and technical expertise in Oracle PL SQL.

- Strong expertise in Oracle Database (12c/19c/21c) architecture and administration.
- Hands-on experience with Oracle Autonomous Transaction Processing (ATP).
- Advanced SQL and PL/SQL knowledge.
- Experience with AWR, ADDM, and performance diagnostics
- Excellent design and technical skills with Oracle PLSQL and SQL Development (including stored procedures, packages, functions, triggers)

- Proficiency in data modeling and database design
- Proficiency in XML Publisher Reports generation
- Excellent understanding of Entity Relationship Diagrams (ERDs) and the translation of business requirements into them
- Expertise in the Interfaces, conversion and data migration between different Oracle ERP modules, Oracle Cloud, Salesforce and 3rd party applications.
- Robust understanding of relational databases (including tables, views, indexes, table spaces etc.)

- Experience with change management tools and processes, including source code control, versioning, branching, defect tracking and release management.
- Experience in supporting CI/CD pipelines for database changes and schema deployments
- Support migrations from on-prem Oracle databases to OCI ATP.
- Perform schema/data migration using Data Pump, OCI tools, or GoldenGate (where applicable).
- Assist in database modernization initiatives and cloud cost optimization.
- Ability to identify system impact for small and large scale initiatives

- Experience with global implementations of Oracle database-based solutions
- Work closely with application teams, cloud infrastructure, security, and business stakeholders.
- Prepare technical documentation, runbooks, and operational procedures.
- Participate in architectural reviews and provide database best-practice recommendation

Key Responsibilities

Must:

- Minimum 10-15 years of experience and technical expertise in Oracle PL SQL.

- Strong expertise in Oracle Database (12c/19c/21c) architecture and administration.
- Hands-on experience with Oracle Autonomous Transaction Processing (ATP).
- Advanced SQL and PL/SQL knowledge.
- Experience with AWR, ADDM, and performance diagnostics




- Excellent design and technical skills with Oracle PLSQL and SQL Development (including stored procedures, packages, functions, triggers)

- Proficiency in data modeling and database design
- Proficiency in XML Publisher Reports generation
- Excellent understanding of Entity Relationship Diagrams (ERDs) and the translation of business requirements into them
- Expertise in the Interfaces, conversion and data migration between different Oracle ERP modules, Oracle Cloud, Salesforce and 3rd party applications.
- Strong understanding of relational databases (including tables, views, indexes, table spaces etc.)

- Experience with change management tools and processes, including source code control, versioning, branching, defect tracking and release management.
- Experience in supporting CI/CD pipelines for database changes and schema deployments
- Support migrations from on-prem Oracle databases to OCI ATP.
- Perform schema/data migration using Data Pump, OCI tools, or GoldenGate (where applicable).
- Assist in database modernization initiatives and cloud cost optimization.
- Ability to identify system impact for small and large scale initiatives

- Experience with global implementations of Oracle database-based solutions
- Work closely with application teams, cloud infrastructure, security, and business stakeholders.
- Prepare technical documentation, runbooks, and operational procedures.
- Participate in architectural reviews and provide database best-practice recommendation

Skill Requirements

Must:

- Minimum 10-15 years of experience and technical expertise in Oracle PL SQL.

- Strong expertise in Oracle Database (12c/19c/21c) architecture and administration.
- Hands-on experience with Oracle Autonomous Transaction Processing (ATP).
- Advanced SQL and PL/SQL knowledge.
- Experience with AWR, ADDM, and performance diagnostics




- Excellent design and technical skills with Oracle PLSQL and SQL Development (including stored procedures, packages, functions, triggers)

- Proficiency in data modeling and database design
- Proficiency in XML Publisher Reports generation
- Excellent understanding of Entity Relationship Diagrams (ERDs) and the translation of business requirements into them
- Expertise in the Interfaces, conversion and data migration between different Oracle ERP modules, Oracle Cloud, Salesforce and 3rd party applications.
- Strong understanding of relational databases (including tables, views, indexes, table spaces etc.)

- Experience with change management tools and processes, including source code control, versioning, branching, defect tracking and release management.
- Experience in supporting CI/CD pipelines for database changes and schema deployments
- Support migrations from on-prem Oracle databases to OCI ATP.
- Perform schema/data migration using Data Pump, OCI tools, or GoldenGate (where applicable).
- Assist in database modernization initiatives and cloud cost optimization.
- Ability to identify system impact for small and large scale initiatives

- Experience with global implementations of Oracle database-based solutions
- Work closely with application teams, cloud infrastructure, security, and business stakeholders.
- Prepare technical documentation, runbooks, and operational procedures.
- Participate in architectural reviews and provide database best-practice recommendation

Must Have Skill

Oracle Golden Gate

Good to Have Skill

Other Requirements

Nice to have

- Experience with Oracle GoldenGate for replication/migration.
- Exposure to Edition-Based Redefinition (EBR) for zero-downtime deployments.
- Knowledge of working with application stacks such as ADF, Java/Spring Boot, or microservices.
- Strong analytical and troubleshooting skills.
- Excellent communication skills with the ability to explain complex database topics clearly.
- Proven experience working in global, enterprise-scale environments.
- High level of ownership, accountability, and documentation discipline.
- Ability to work independently and collaboratively across cross-functional teams.

📌 Senior Technical Specialist (Bengaluru)
🏢 HCLTech
📍 Bengaluru

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: senior technical specialist (bengaluru) / bengaluru

Subscribe to this job alert:

Get the latest job offers by email for: senior technical specialist (bengaluru) / bengaluru