Oracle Manager

Resume

Resume

Mayur Vegad (Database Administrator - DBA)

Contact: +1-952-***-****

E-Mail: *******@*****.***

Home: *****, ******** ****, *******, *********-28277, NC, USA Objective

I am working in TATA Consultancy Services Ltd. (TCS) from 12+ years during my carrier have worked and perform different role in Data Base technology area (Production DBA/Performance engineer/DBA analyst and Onsite DBA Lead) in different giant client of European and North America geography from onsite and offshore. my technological forte is ORACLE, MySQL, MS SQL and DB2 Database Administrator, Cloud DB Migration, also have a good expertise in Data Migration and worked in various migration projects, In very well exposure in – IT - Infrastructure Services (IT IS), Retails, Manufacturing, Communication Media and Government industry solution unit. I am currently working as Database Administrator in Belk Administration company, Charlotte, NC, In Belk we are delivering and supporting Oracle 11g/12c/ASM/RAC DB server, OEM, MySQL, MSSQL and DB2 DB server support we are supporting round the clock 24/7 days as on call DBA to execute Belk E-Com online and retails stores chain business in North America .

Education Summary

Qualification Subject Percentage/Grade

Bachelor of Engineering in IT Computer Technology First Diploma in IT Computer Technology First

Technical Skills

Software Oracle Web and Middleware products, RMS, Allocation, RPM, Oracle RAC 12C / 11G / 10G with ASM/Non ASM and Oracle Cluster ware software, MySQL Enterprise DB server 5.1,5.5 and 5.6, Hitachi Commvault for Backup/Restore with RMAN, Oracle Linux and IBM AIX operating system flavors

Hardware Super Micro Computer server for Oracle and MySQL DB server with Oracle shared DB in SAN storage, Oracle EXADATA Machine, IBM Tape library

Tools SQL Developer, Toad, DBCA, OUI, Oracle Enterprise Manager 11g/12c/13c, Oracle APEX, EXPDP/IMPDP, AWR/ADDM and ASH, Tkprof, MySQL Migration toolkit, MySQL Administrator Tool, MySQL Enterprise manager, MySQL workbench, MySQL Enterprise Backup, Hitachi Commvault, Ibbackup, Atlassian Jira and confluence, BMC Remedy, CA SDM, Nagios, Autosys, CyberArk. Methods Oracle RAC 12C/11g/10g with 2/3/4-Node in ASM shared Disk Architecture with Data Guard, MySQL Operating System Cluster setup with use of Oracle cluster ware and M-M Replication Domain

Experience

Retails, Media and Information Services, IT Infrastructure Management (ITIS), Finance and Banking, Legal, Manufacturing IT industries.

Achievements

Conducted MYSQL Database Training for Various Projects Associate in TCS. Awarded certified with training from Sun Micro Systems (MYSQL INC). Year-2008. Resume

Resume

Awards

Title Category Sub-Category Received On

Best Team Awards for Excellence Star Awards 19/11/2014 Best Team Awards for Excellence Star Awards 17/08/2012 CLP Faculty Award Learning Awards CLP Awards 17/06/2013 Special Initiative Beyond Performance Awards Initiatives 17/04/2015 Special Initiative Beyond Performance Awards Initiatives 06/02/2015 Service & Commitment Award Service Awards Service Award 03/05/2016 Service & Commitment Award Service Awards Service Award 03/05/2014 External Project Support Beyond Performance Awards Initiatives 12/09/2015 Roles and Responsibilities

Current Role: Oracle Database Administrator / Architect. Current Role Responsibilities

I am working as DBA in Belk Administration company, Charlotte, NC, my day to day work handling and fix Severity 1 and 2 DB Incident tickets, Interact with Oracle using Oracle’s support portal to troubleshoot/resolve product-related issues, working on DBA Task like SQL query performance tune through SQL tuning advisors, assign and change SQL hash value as per COE profile to optimize SQL performance, stats gather, DB server performance check, Tablespace and datafiles storage allocation, DB ASM space management, RMAN Backup report and error resolution, DB Refresh and transitioning from Customer and coordinate and working with onsite and offshore DBA Team, DB Release management by followed change management process, Application and Database deployment and release management, RPM – Retail Price Management and X-store oracle project development support and working with application team in war room and deploy build and fixing error, oracle Primary and standby DB Data Guard replication monitor and issue troubleshooting. Managed Task by OEM and crontab schedule, Managing Oracle RAC through CRSCTL and SRVCTL.

Oracle PSU bug fixing patch scheduling and apply manually and scheduled through oracle enterprise manager for oracle 11g and 12c Grid and RDBMS Home on quarterly release basis for Database server.

RPM, RMS, Bi Publisher, Reims, Allocation, SPO-SAS, X-Store(X-Center) application deployment, user management, Oracle Middleware application support.

DBA On-call support 24/7 round the clock.

Expert in SCM deployment manager.

Working closely with application team for day to day application and DB issue.

Supporting to Belk Inhouse applications running over MSSQL and DB2 DB.

Oracle and DB2 Db server Data purge and table re-org for performance improvement and re-claim storage.

Monitor application processes and resources utilization, work in team environment to resolve issues. Current TCS – USA Experience Summary

Project Belk Administration Company, Charlotte, North Carolina, USA Role Database Administrator – DBA lead

Period 1st Mar 2017 to current date.

Technical Skills Oracle core DBA, MySQL, MSSQL and DB2 DB support and SME in DB Performance engineering, Cloud and Datacenter Migration expertise. Resume

Resume

Previous TCS – USA Experience Summary

Project PETCO Animal Supplies, Inc. San Diego, CA, USA Role Oracle Database Administrator

Period Oct 1st, 2016 to 28th Feb 2017

Technical Skills As DBA in PETCO Animal Supplies, Inc. we Build new Oracle 12C/ 11G VM / Physical DB Server with ASM/File System on Linux and AIX IBM Operating system with Grid Home Installation, Oracle DB Home Installation, ASM configuration by AsmLib and ASMCA,RMAN Backup configuration, OEM agent server monitoring for new DB, Managed Task by OEM and crontab schedule, Table space management, Production DB Monitoring, Alert log checking for DB and Cluster, Managing Oracle RAC through CRSCTL and SRVCTL, Working with Rimini Street for Sev1 and resolution, Taking Backup by Data Pump Export and restore it by Import to target server on daily basis from Data center to clouds DB, with NFS, Golden Gate Basic Usage, Managed standby through Data Guard, Data Base Migration from Data Center to IBM Cloud site. Previous TCS – USA Experience Summary

Project Cargill Inc. Minneapolis, MN, USA

Role Project Oracle DBA analyst

Period Jun 10th, 2015 to Sep 30th, 2016

Technical Skills As DBA in Cargill we work on DB PDM (Project Demand management) on time and material based projects on hourly calculation of DB project and biding with project managers team between TCS and Cargill PM team, my day to day work is for any new Cargill's site we need to Build new DB Server on Linux box and we build and created new DB's Include Oracle 12c CDB and PDB, ASM configuration, Oracle Home setup, RDBMS setup and installation, we build Oracle 12C and Oracle 11G day to day, also we used Cargill's in house IP Frame work for around 3000 DB instances within Cargill to manage USER provision, Also performed RMAN backup setup, RMAN configuration, DB Clone by RMAN, performance tuning, DB refresh through RMAN and Export/Import Data Pump, GRP creation and drop, decommission an Oracle 10g and 11g Database and On call support in week end are my current work. Previous TCS Experience Summary

Customer UNIBET, Stock Holm, Sweden

Role Data Base Administrator- L2 Oracle/ L3 MySQL

Period May 3rd, 2011 to Jun 09th, 2015 - 4 Years 3 Months Technical Skills Task allocation, Task tracking & Ticket handling as per the priority of Jira incident and identify, Interaction with the client and the onsite team member for daily support activities, Maintained coordination in the team and the shift members for project support activities, ITIL approach and methodology, ORACLE/MYSQL database maintenance & support, DB Administering & Performance tuning through Oracle Management Server (OEM 11g & 12c) and MERLIN, Backup, recovery

& Maintenance of database using RMAN, Strategy planning for archival, purging, backup design and implementation, Database cluster Resume

Resume

implementation, monitoring and troubleshooting, Database replication setup, Database Stand by setup / mirroring using Data Guard, Enhancement and maintenance of database releases, performance tuning and troubleshooting of MY SQL database servers by tuning storage engine specific various parameters,Maintenance and configuration of M-S and M-M replications

Description Unibet main business is Online Gaming in Europeans countries, the project involves Infrastructure support to the Unibet IT environment. Support including ORACLE/MYSQL DB, OS, Network, Application and Service Desk support.

Previous company Experience Summary

Organization LSS Logical S/W P Ltd.

Role Database Administrator

Period Feb 01st, 2010 to Apr 24th, 2011 - 13.87 Months Technical Skills Installation of MYSQL DB server on windows2008 (64 bit) and Linux and cent OS by RPM binary distribution, schema and user creation, MySQL parameter tuning of my.cnf and my.ini, resolving all database errors, Implement Backup policy by mysqldump, schema restoration, recovery by MySQL bin-log utility, install more than one DB in same machine with different port, migration of client access DB in MySQL DB by SQL scripting and use of migration toolkit, implement master slave replication and checking replication, query optimization and re write queries, schema normalization by splitting of table in multiple tables. Description PCA is a product based on well-defined e-discovery workflow, for legal professionals to efficiently take control over their e-discovery process and deliver significant cost savings to their organizations. Previous company Experience Summary

Organization TATA Consultancy Services Ltd.

Role Database Administrator

Period Mar 20th, 2007 to Jan 27th, 2010 - 34.83 Months Technical Skills Installation of Oracle and MySQL Software and Application server and configuration, Database creation, maintenance and Database tuning, user/schema and table space management, User Managed Backup and recovery, checking locking activity, Disk space management, Listeners, services, Management of the usage of Data files, table spaces, managing instance memory, checking alert. log file, background trace files, user trace files, Checking & managing archive processes, checking I/O statistics (Physical Reads & writes of data files), checking usage of undo table spaces is part of the duty, SQL query tuning /index tune for better performance in Oracle and MySQL DB, Deployment activity at client side and TCS development center, database monitoring by OEM console for MySQL and Oracle both DB at production server client side, find slow query from slow query log in MySQL.

Database migration from Oracle to MySQL version (that is 80GB size, by MySQL toolkit and our policy for migration) and migrate MySQL DB to Oracle DB (by SQL developer) and manage MySQL database in sync with Oracle production database.

Managing MySQL production DB, monitoring of DB, backup/restore by NET VERITAS backup software, incremental and full-backup, Use Resume

Resume

ibbackup for online DB backup and also created new master / slave DB by ibbackup, checking DB health during peak hours by MySQL commands and EM console graphs, checking replication from master to slave DB, managing users and privileges, checking slow query log and tune / rewrite slow query and give to development team for re implement in application.

Description IFMS is an Integrated Application with a Single Point Interface (Single- Sign On) across all Functions viz. FD, Budget, Director of Treasuries, Directorate of Pension, Treasuries, Sub Treasuries Offices, DDO, PPO and exchange of data with external entities like AGO, RBI, Banks, and other Government departments.

Solved the issues of time lag and information asymmetry and facilitate in consolidation, aggregation and effective dissemination of information in a cost-effective and sustainable manner. Maintain and monitor Expenditure and revenue across treasuries under state. Maintain Financial Accounting across all treasuries. Additional Details.

USA VISA Type: H1B Visa, need Sponsorship and Visa transfer. USA Visa Validity: Valid I94 and I797A Petition till Sep-2021. USA Work and Home Location: Charlotte, NC.

E-Mail: *******@*****.***

Cell Phone: +1-952-***-****.

Contact this candidate