Associate Consultant

1 Month ago • All levels

Job Summary

Job Description

Support ongoing efforts and provide technical support for multiple database re-platforming efforts to Exadata. Review and implement data loading scripts related to Golden Gate data replication. Optimize and tune SQL queries and indexes in Oracle. Work with Oracle 12c/19c/Exadata capabilities and functionality. Develop strong programming/development skills using PL/SQL (packages, procedures, functions, triggers). Proficient in performance tuning (PL/SQL) using SQL Trace, Explain Plan, Indexing, and Hints. Possess strong knowledge of database triggers, indexes, and partitioning. Expertise in Oracle architecture. Proficient in reading Query Execution Plans to evaluate and improve SQL performance. Manage database objects like tablespace, users, indexes, roles, privileges, profiles, and synonyms. Monitor database performance related to memory usage, backups, active sessions, long-running queries, tablespace configuration, and space allocations. Coordinate with data architects and analysts on building schemas, tables, functions, views, stored procedures, and roles. Coordinate with the automation team for scheduling various AWA/RMJ jobs. Provide DBA supervision and Oracle best practices guidance for custom application development and routine database administration.

Must have:

Support database re-platforming to Exadata
Implement Golden Gate data replication scripts
Optimize SQL queries and indexes in Oracle
Proficient in performance tuning (PL/SQL)
Strong knowledge of database triggers, indexes, partitioning
Expertise in Oracle architecture
Manage database objects
Monitor database performance
Adhere to quality standards and policies
Ensure positive customer experience

Good to have:

PL/SQL programming/development skills
Reading Query Execution Plans
Coordinate with data architects/analysts
Coordinate with automation team
Provide DBA supervision/guidance
Contribute to service improvement plans
Independently resolve tickets and meet SLAs
L3 level support and incident/problem management
Knowledge base update and management
Train freshers and conduct interviews

2 skills required

2 skills required for this role

Add these skills to join the top 1% applicants for this job

oracle

sql

Job Details

Job description:

Support ongoing efforts and provide technical support for multiple database re-platforming efforts to Exadata.\r\n Reviewing and implementing data loading scripts related to Golden Gate data replication.\r\n Optimization and tuning of SQL queries and indexes in Oracle.\r\n Working knowledge of Oracle 12c/Oracle 19c/Exadata added capabilities and functionality.\r\n Strong programming/development skills using PL/SQL (package, procedures, functions, triggers) a plus.\r\n Proficient in performance tuning (PL/SQL) using SQL Trace, Explain Plan, Indexing, and Hints.\r\n Strong knowledge of database triggers, indexes, and partitioning.\r\n Expertise in Oracle architecture. \r\n Proficient in reading Query Execution Plans with the ability to evaluate and improve performance characteristics of SQL.\r\n Manage database objects like table space, users, indexes, roles, privileges, profiles, and synonyms.\r\n Monitoring of the database performance as it relates to memory usage, proper backups, active sessions, long-running queries, tablespace configuration, and space allocations. \r\n Coordinate with data architects and analysts on the building of schemas, tables, functions, views, stored procedures, and roles.\r\n Coordination with the automation team for the scheduling of various AWA/RMJ jobs to be executed on multiple databases.\r\n Provide DBA supervision and Oracle best practices guidance for custom application development and routine database administration efforts.

To adhere to quality standards, regulatory requirements and company policies
To ensure positive customer experience and CSAT through First Call Resolution and minimum rejected resolutions / Reopen Cases
To participate or contribute on EN business in creation of proposals to drive Service improvement plans.
To independently resolve tickets & esnure that the agreed SLA of ticket volume and time are met for the team.
To provide support for on call escalations /L3 level support and doing incident & problem management
Work on value adding activities such Knowledge base update & management, Training freshers, coaching analysts & conducting interviews/participation in hiring drives.