Experience

• 

  Sk international

  Feb 2011 - Aug 2013

  Jr oracle dba

  Database Installation and Maintenance.Implementation Oracle Advance Technology (DataGuard, Failsafe RAC etc.).Backup and Recovery Strategy using RMAN.

• 

  Netmagic solutions (an ntt communications company)

  Aug 2013 - May 2014

  Sr. database administrator
• 

  Clover infotech

  Mar 2014 - May 2015

  Senior database administrator

   Provide support in maintaining database applications. Communicate with customers in requirements gathering and solution definition for assigned Oracle projects. Provide technical support to different departments in SBI Bank. Installing, upgrading and configuring the Oracle environment as per application requirement. Create, Patching & Managing Database Structure, Storage Allocation. Trace the frequently called procedures/packages and pinning them to improve the performance. Data Guard, DG Broker configuration and perform BCP drills. Comprehensive monitoring of production database for any sort of issues Pro-active approach to prevent issues from cropping up in production Env Creation of DB and on Test Env using duplicate DB Regular DB maintenance for Space and performance on regular interval basis Shell scripting for maintenance purpose. Involved in various audit procedures carried out such as Internal Audits, IS Audits, RFIA, etc. Provide information to auditors as and when required by the Bank. Creation/maintenance of UAT and development environments. Implement environment access control / security.Client Name : SBI (Corporate office) Show less

• 

  Capgemini

  May 2015 - May 2018

  Consultant

  My current role is that of a DataBase and Application Administrator.My prime responsibilities included, serving as DBA for these on a leveraged (or shared) basis are as below: Responsible for all database related activities and actively play a lead role.  Perform actions as and when we receive ticket in ITSM and maintain the defined SLA.  Design, Plan, Implement and setup Infrastructure, configure FRT and DR setup for failover  Automating tasks using Shell scripts and windows bash such as SFTP, Log rotation, RMAN backup to tape, Load csv file using loader etc. Perform FRT and DR activities every quarter and note the timing of the activity to share with management. Refresh Dev, Acc, and Test database every quarter using Datapump and RMAN from tape. I have also automated this task using shell scripts. Applying regular security patches for Database and other applications.  Provide support to Oracle Ebs Suite 12.1.3.  Performed Oracle Apps tasks such as patching (adpatch), Cloning (Rapid Clone), Managing Concurrent requests, Custom Forms deployment, and Workflow management. Provide Oracle Apex and Weblogic support for hosting Apex application. Installed Oracle Fussion Middleware with Forms and Reports application which is used by Netherlands Finance team Understanding on SSL and SSO configuration for application. Compiling Forms and deploying forms as per developer’s requirement. Provide support to third party financial applications with activities such as Version upgrade, Patching, Bug Fixing. Performed migration activity such as SUSE-RHEL, RHEL5 to RHEL6, Non-ASM to ASM, Domain migration from SGTI to CORP.  Client co-ordination, regular meetings and sharing reports such as KPI, MSR, IMD. Show less

• 

  Hdfc bank

  May 2018 - now

  Senior manager

   Problem Management: Work on the problem tickets logged by the L1 team. Analyze the issue and provide permanent solution. Managing multiple projects to ensure they are completed on time. Tracking the progress and update the same to all stakeholders.  Weekly/Monthly review meeting with management for project update.  Change / Release & Documentation - Ensure the change and release management process followed as per bank process. Application documentation for projects and change management are completed and ensured no failure in audit. Audit and Compliance - Ensure that applications are compliant to IT policies, processes and Internal, external, RBI & SoX audit guidelines. Application Performance Management and solutioning: Review the performance of the system on periodic basis to identify potential bottlenecks by analyzing application performance trend over the period and its relative growth. Application Obsolescence and Capacity Management: Review the application technology stack for technology Obsolescence and capacity planning to cater future business growth.  Vendor Management – Periodically document and review the performance of the vendors, do necessary escalations and initiate service improvement plans wherever applicable.  Budgeting planning and funding approvals - Do the annual budget planning for recurring AMC & professional services payments to be made to application vendors, budget planning for technology refresh and obsolescence projects. Approval of funding and release of payments on time. Automation and Deployment of IT infra using autosys and shell script. Review the Infrastructure components and give the recommendation as per application to enhance the performance and availability. By analyzing current application performance and future growth redesign the application design if required with all internal approvals. Implementing SSL configuration on Web & App Layer. Show less