Profileimage by Elayaraja Ganesana Oracle and SQL Server DBA and Pl/SQl from Krishnagiri

Elayaraja Ganesana

available
Contact

Last update: 25.06.2021

Oracle and SQL Server DBA and Pl/SQl

Graduation: MCA
Hourly-/Daily rates: show
Languages: English (Limited professional) | Hindi (Limited professional)

Keywords

Oracle Application DBA oracle migration PL/SQL programming SQl Database administrator SQL Databases Shell script SQL and PL/SQL implementation & Maintenance Oracle Data Pump

Attachments

Elayaraja_CV.docx

Skills

Over all 14 Year in IT Sector as Technical Specialists in Oracle and SQL Server (DBA, PL/SQL).
 • Expertise in Software architecture, Gap Study, Design, Analyst, Development, Debug, and Implementation.
 • Domain Expertise in Banking Sector (Payment Gateway, Card Operation, Retail Banking, Loans) and Others.
 • Experience in Oracle (SQL, PL/SQL), DBA (Installation and configuration, Fine-Tuning, Backup/Recovery,     Patches, Database Migration/Upgrade, Data Warehouse, Account Activity, Replication, Golden Gate)
 • Experience in SQL Server (SQL, PL/SQL), installation and configuration, Fine-Tuning, Backup/Recovery, Replication, User and Groups)
• Working Experience in ITIL process (Change Management, RMS & Incident ticket).
• Working Experience in SDLC Life Cycle, Agile Methodology, Scrum (Sprint Planning).  
• Working Experience in job scheduling (Crone, Bat, Control M Job) in Linux and Windows environment. • Experience in Co-ordination with Business Team Location (IN, BD, PK, AE, BH, USA) and vendor (ATOS, HOGAN, 3i info Tech, Southern California Edison, MasterCard).
• Having Experience in Team handling, Project Co-ordination, Project Lead.
• Having Experience in document in Technical (LLD and HLD), Functional Specification.
• Working Experience in Tools (Control m, TOAD, SQL Developer, IBM MQ, AWS (RDS)
• Working Experience in GIT, Bit Bucket, Flyway, Jenkin Pipeline.
.
Professional Experience:
• Oct 2020 to Mar 2021 -> eSoft Labs Pvt Ltd at Bangalore.
• Feb 2019 to Dec 2019 -> eSoft Labs Pvt Ltd at Bangalore.
• Aug 2017 to Feb 2019 -> JK Technosoft Ltd at Bangalore.
• Jan 2012 to Jul 2017 -> Standard Chartered Global Business Services Pvt Ltd at Chennai.
• Nov 2006 to Jan 2012 -> In-Solutions Global Pvt Ltd. at Mumbai.
Banking Domain Experience:
 • Expertise knowledge in Card Operation (Credit Card Production), Loan Processing System.
 • Expertise knowledge in Card Operation (Credit & Debit Card), Payment System, Interchange System.
 • Working knowledge in Retail, Consumer Banking and Core Banking.
 • Knowledge about PowerCard System (Card Production).
 • Knowledge in Islamic Bank, RBGMS and IFRS9 MIS Reports.
 • Worked with Master card project (Customer on-Boarding, Batch Simulator).

Project history

10/2020 - 02/2021
Technical Specalist
eSoft Labs Pvt Ltd (50-250 employees)
Internet and Information Technology
Database Administration for Oracle and SQL Server for that Project.
Need to create New Database in Local server .
1.Need to restore Database in Local Server
2.Need to create New User to access database
3.Need to create Partation, Index  as per performance issue,
4. Performance Tunning, Checking Query standard,Index,Explain Plan. and check AWR report and Log File.
5.Database Migeration involved in 11g to 12 C using export and import.
6.Creating PL/SQL and writing Queries

02/2019 - 02/2021
Technical Specialists and DBA
eSoft Labs Pvt Ltd (10-50 employees)
Internet and Information Technology

Role & Responsibilities:

  • Database Setup (Installation and Configuration), Creation Schema through Flyway.
  • Database Design, Migration, Backup and Restore in UAT Environment.
  • Configuration AQ jobs and XML, JSON Storing in table.
  • Find all logic involved in each process and making document.

Skills: Windows, Oracle 11 G with API development Team, Bit Bucket, Git, Flyway, Jenkin Pipeline, Golden Gate.

Description:

 Need to create new database and configuration in local Environment. Need to do table design and need to configure Flyway setup to create object in Mastercard Server .AQ setup need to create in database to run job. Need to load XML and JSON file into database table through Procedure.


08/2017 - 12/2018
Technical and Project Lead
JK Technosoft Ltd (500-1000 employees)
Internet and Information Technology

 

Role & Responsibilities:

  • Requirement gathering from Business, Analysing requirement, Development.
  • Data Migration from SQL Server to Oracle 12 C Database.
  • Developing PL/SQL Procedure for Data Transfer from SQL Server to Oracle Database.
  • Migration SAP BO Report which are Free Hand SQL to PL/ SQL Procedure.
  • Developing PL/SQL Procedure for the RBGMIS, Islamic Bank.
  • Writing SQL Query as per Business requirement and for reconciliation data between different Systems.
  • UAT Co-ordination between Business User and BO Team.
  • Front End model developed using Java and J2EE to upload Excel Sheet and PDF Files.

 

Skills: Windows, SQL Server, Oracle 11 G & 12 C, SAP BO 3.1 and 4.2, Java and J2EE

Description:

              Database Migration from SQL Server to Oracle including Tables, Procedure, Function with Data and Migration SAP BO report of Free Hand SQL to PL/SQL Procedure implemented in UAT Server as per Business User Logical. Writing PL/SQL Procedure for the Data Mart to populate data from different system on Daily& Monthly Basics. IFRS9 Report preparation for Default Report and Reconciliation Report between different system data. Islamic Report generated check with budget for reconciliation between them. UAT and Production Deployment Co-Ordination with different team like DBA, AQC and Business Team. Upload Excel and Pdf files into database.


01/2011 - 07/2017
Technical Lead
Standard Charted Bank (5000-10.000 employees)
Banks and financial services

Role & Responsibilities:

  • Gathering requirement from Business, analysing requirement, designing.
  • Developing PL/SQL Procedure for Data Purging as Business rules.
  • Deploying module at UAT Level & Testing Co-Ordination with India Business Team.
  • Change process activity through Remedy Tool for implement in Production server.
  • UVT Co-ordination with user and Business User.

 

Skills: Linux, Java, IBM WAS 8.5, Oracle 11 G.

 

Description:

              Database purging activities and implemented as per business rules & Logic given by Business user.

    Writing PL/SQL Procedure as per business logic provide Business user and Scheduling Daily and Weekly job in Oracle Scheduler to purge data as per Logic. Configuration Module provide to business user to configure through screen level to delete data from the table

 

Role & Responsibilities:

  • Gathering requirement from Business, analysing requirement, designing.
  • Allocating work with timeline, developing major module.
  • Deploying module at Linux server.
  • Change processing before implementation & approval.
  • Emboss File Format change both upload /Download.

 

Skills: Linux, Java, DB2, IBM WAS 8.5, EJB, MQ Connection & Cluster.

Description:

              Credit Card Application System: Credit card booking for all type of customer.

  • Primary card and Supplementary card booking system for single and multiple customers.
Emboss File Format change in both upload and download and Encryption and decrypting key change, key has generated at eCAPS Team using PGP Software and share to C400 and Vendor Team to upload EMBOSS File.

10/2006 - 01/2011
Senior Product Developer
In-Solutions Global Pvt Ltd (1000-5000 employees)
Internet and Information Technology

Role & Responsibilities:

 • Gathering Requirement, Design, Developing script for download data files from IBM DB2 Server.

Skills: Java, Oracle, SQL Server, Jasper Report, Shell Script and Windows (Bat Script).

Description:

                 We are getting raw files from the different bank like Switch file, B24, Visa and MasterCard. We are processing all files and storing into database and doing reconciliation for Issuer and Acquirer. We are matching transaction details with Settled to Acquirer and Issuer. Generating report using Jasper Report and providing reports like Reconciled and Un-Reconciled transaction including Incoming and Outgoing (Chargeback, Representment and Fee Collection) Sales, ATM transaction details to bank. Merchant Wise and Payment Gateway Variance for daily based for monitoring fraud cases.

Time and spatial flexibility

As per project requirement can travel .

Other

I am intertested work fleable timing and like to learn new thinks.
I looking for same skill and support service also.
Please provide job describtion in English and provide clear information.
Right now i cannot login through premium member,right now free user.
I need some job and need to earn money for family member and for me.
Please contact me through E-mail:elaya.g@gmail.com or Mobile Number:8870188340.

Contact form

Contact details