Nitin Narayan Kadam

Application support and DB support for Oracle General Ledger on EBS 12.1 and ERP

Tools: Oracle Fusion Financials, Oracle Cloud Applications (Modules Familiar

With: General Ledger, Accounts Payable, Accounts Receivable, Fixed Assets) and Oracle

Utility application (this application is used for uploading data files stages wise for further

validations and processing of GL files).

• Handling General Ledger data (Debit and Credit amount matching) which gets transmitted

to Oracle GL from various source systems like Finnone neo, Finnone Corp, Br.Net,

Treasury etc. and used to tally with these source systems to Oracle GL.

• Coordinating and giving instructions on tasks to be performed by SQL DBA, Oracle EBS

DBA, Windows server team and Linux server team as a part of App and DB support.

• Giving instructions and reviewing on the daily tasks to be performed by team working

under in terms of daily health check.

• Handled BCP DR drill for switching App and DB server from production environment to DR

environment.

• Checking application and DB logs with the help of my team on giving further line of

support to production issues.

• Vendor PO (Purchase Order) management for further approvals from CTO and superiors

for payment release to vendor.

• Preparing queries which is required to give support to application and DB on production

environment.

• Adhering to SLA given by business team to solve production issues.

• Team shift management.

• Handling escalation whenever issues raised by Oracle GL users i.e. Finance team users

and Operations users.

• Handling escalation whenever issues raised users while uploading data file through Oracle

Utility application.

• Representing changes as Change Management through CCB (Change Control Board’s)

meeting.

• Adhering to the instructions given by seniors i.e. AVP, VP and SVP etc. on App and DB

support area.

• Checking and analyzing disk capacity planning.

Checking and analyzing disk capacity planning.

• Performing daily tasks including daily routine checkup of SQL Servers through SQL

error logs and Windows Server Event Viewer Logs.

• Securing database servers by implementing Acer / Hardening points on DB servers.

• Solving production database related issue like blockings, deadlocks, slowness in queries, etc.

• Adhering to SLA given by business team to solve problems.

• Coordinating with business team for new project requirement related with SQL DB

configuration.

• Handling eGurkha monitoring application on Linux and Windows platform used by all IT

teams required for troubleshooting datacenter issues, retrieving App and DB logs, etc.

• Deploying eGurkha monitoring application’s license on Linux server.

• Worked on RA-Dedupe Posidex application related issues with loans and bureaus.

• Worked on various production applications, database related issues.

• I used to coordinate with Vendors for issues resolution.

• Performed daily tasks including daily routine checkup of Oracle Servers.

• Resolving production database related issues like blockings, deadlocks, slowness in

queries etc. with the help of Oracle DBAs.

• Adhering to SLA given by business team to solve problems.

• Coordinating with business team for new project requirement related with application

related, db related issues.

• Handled team of three application support engineers.

• closely worked with business team about new data requirement and given them support as

per the requirement.

• Worked on change, release management related with issues patch / bug fixes to be

deployed in DB and application production servers.

• I handled Unix / Linux environment for Aadhar-UIDAI and Pan Validation application

systems.

• I handled Autosys tool for running business BOD / EOD processes and resolved issues as

and when occurred.

• Sound knowledge on ITIL incident / problem management.

• Checking and analyzing disk capacity planning.

• Performing daily tasks including daily routine checkup of SQL Servers through SQL

error logs and Windows Server Event Viewer Logs.

• Securing database servers by implementing Acer / Hardening points on DB servers.

• Solving production database related issue like blockings, deadlocks, slowness in

queries, etc.

• Monitoring MySQL Master – Slave Replication on Linux OS 5.10, scheduling of cron jobs.

• Taking MySQL DB backups and restoration on DB Servers.

• Adhering to SLA given by business team to solve problems.

• Coordinating with business team for new project requirement related with SQL DB

configuration.

• Tuning of performance related issues by checking through query plans.

• Checking and analyzing disk capacity planning.

• Handling windows clustered servers through FCS Management console.

• Securing DB servers by implementing Acer / Hardening points.

• Installation of Oracle 11g Server and clients. Taking backups using RMAN utility and

restoration of Oracle backups on test servers.

• Given L1 support for DB2 9.1 database server.

• Designing DB restoration strategies depending on business requirements.

• Tuning performance related issues by checking through query plans. Checking and

analyzing disk capacity planning.

• Configuration of Log Shipping, Database Mirroring and Transactional Replication.

• Handling windows clustered servers (Active-Active nodes) through FCS Management

console.

• Involved in trouble shooting and fine-tuning of DB’s for its performances and

concurrency. Securing database servers by implementing Acer / Hardening points on DB

servers. Installation of SQL Servers 2000, 2005, 2008, 2008R2 and 2012 and further up

gradation of security patches.

• Involved in all aspects of DB administration on SQL Server 2000, 2005, 2008.

• Designing DB backup & restoration strategies depending upon business requirement.

• Indexes & Statistics maintenance at regular intervals for better performance of DB.

• Recovery of SQL DB from backups in case of disasters.

• Configuration of SQL alerts on mails, Log Shipping, DB Mirroring and SQL Replication.

• Involved in trouble shooting and fine-tuning of Db’s for its performance and concurrency.

• Installation of SQL Servers 2000, 2005 and 2008 and further upgrading security patches

on production environment.

• T-SQL query creation for data requirement and for report generation as per user’s

Requirement, Backup and restoration of Db’s on UAT / Live environment.

• Attach and detach of Db’s, Export & Import of Data using BCP commands and Export

wizard in SQL Server.

• Given support to Exchanges like MCX, MCX-SX, NSEL, BFX & App. Like CNS, OMX

Exchange Admin, Recovery server (based on Message Queuing) app. related issues.

• Data requirement or report generation as per client’s requirement by creating SQL

Queries, Export & Import Data in SQL Server 2000, 2005.

• DTS Designing and maintenance for data integrity.

• Backup and recovery managements for Db’s

• Processing of Foreign Inward Remittances processing and issuance of certificates (FIRC).

• Processing of Letter of Credit (LC).

• Maintaining Inward Remittances data in Excel and start processing it as per instructions

received from bank.