ROLE/RESPONSIBILITIES:
1. Continuously monitor production systems and applications for performance issues or errors, and promptly troubleshoot and resolve identified problems.
2. Tuning PL/SQL Blocks & queries using hints and utilities such as DBMS_PROFILER, Explain Plan.
3. Familiar with UNIX functions and writing Shell Scripts, Scheduling jobs using Cron tabs and CA7 scheduler.
4. Analysis, design and development of modules and troubleshooting job failures involving Oracle, PL/SQL, Informatica, SQL and Python, Axiom controller view and Connect Direct (NDM).
5. Debug the data related issues and fix the defects raised by the Testing team and Business team in various regulatory reports and prepare the deployment plan.
6. Analyze application and server logs to identify issues in various environments and resolve it.
7. Collecting, analyzing CPU and memory utilization data from various sources (servers, applications, etc.) and recommend to adjust application settings, upgrade hardware, or optimize the code based on the analysis of collected data.
8. Perform Go-Live Production activity to have smooth and seamless deploy to production environment for various application objects including PL/SQL packages, unix scripts, Axiom controller view objects, Sql and Python.
9. Create Incidents, Change Requests, release documentation, support procedures to ensure smooth transitions with minimal downtime.
10. Respond to and manage incidents and outages, ensuring minimal disruption to services, user impact and assist in on-call duties.
MUST HAVE SKILLS:
1. Oracle, PL/SQL, SQL, MongoDB
2. Unix commands, Shell scripting
3. Informatica
4. Connect Direct (NDM)
5. Toad
6. OpenShift Platform.
FLEX SKILLS:
1. Axiom controller view (Regulatory Reporting)
2. Python
3. Oracle Analytics (OAS) Reports
4. ServiceNow, Big Panda, Dynatrace
5. Tomcat application servers, Apache and Windows IIS servers.
EDUCATION:
" Bach Min