L1/L2 core banking support/development work from client location Worked extensively on Oracle SQL query writing.
Execute batches/EOD in production env. Every day.
Strong PL/SQL coding skills.
Basic DBA and unix administration skills.
To ensure availability of application and first line support for any critical issues arising out of application usage.
Deployment of product patch in all production environments and tracking the same.
Technical and functional application support for retail banking including lending, term deposits, savings, payment systems, clearing and other modules.
Regular interaction with business users (and BA) to understand their requirement/concerns and provide resolution for their queries.
Analyze, troubleshoot & fix production issues in banking application.
To execute end of the day, end of the month batch processing in production system.
Performance tuning and query optimization skills.
Deployment of source code and data fix in production system.
Extensive knowledge and experience working on Toad, Oracle SQL developer and Oracle Enterprise manager tools.
Troubleshooting Application Configured on Linux and Unix Platform, Debugging errors based on log files.
Making use of database objects, tables, views, procedures, functions, triggers etc. to generate different reports and execute business logic as per client requirement.
Designs, develops, implements and tests changes in application.
Administering application hosted on UNIX Solaris 5.9/5.10 OS and database running on Oracle 9i, 10g versions.
Designing and developing database objects.
Liaising with internal and external audit teams to discuss and demonstrate security feature of production applications and to identify areas of improvement.
Experience handling multi-entity systems.
Monitoring Operational activities and reviewing daily checks.
Operating system performance monitoring including space management, review of processes running in background etc.