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