Job Description
- 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
- 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
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.
