SUMMARY

• He is a Solution - centric, analytical, data-driven IT Consultant with a passion for technology and innovation backed by 17 Years of experience in large-scale production environments across multiple domains like Retail, Telecom, Banking and Energy, Implementing and supporting Disaster Recovery, High Availability plans and solutions based on multiple platforms as Data Architect and Oracle DBA.
• International career includes experience in diversified fields, driving innovative enterprise / information architecture initiatives to success while planning strategies aligning to Organizational vision.
• Currently Managing database support teams to Confidential Home office and Confidential e-Commerce databases across multiple platforms (i.e. Oracle, Exadata, SQL Server, Casandra, Postgres, Bigdata Hadoop) running on (Aix, Linux virtual server) operating systems.
• A Team Leader contributing to change-oriented operational results while maintaining cutting-edge IT skills and up-to-date industry trend awareness, as well as rising above operational issues to quickly adapt to evolving scenarios and achieving winning outcomes.

TECHNICAL SKILLS

• Oracle Exadata
• Oracle 11g/12c/13C/18c/19c Data Guard
• Oracle11g RAC
• Oracle E-business suit
• Expertized in SQL tuning
• Oracle Provisioning
• Oracle Goldengate
• Oracle Goldengate
• Tivoli and Symantec Net backup python
• Azure
• Big data Hadoop
• Casandra
• Postgres
• Kafka and tableau.

PROFESSIONAL EXPERIENCE

Senior Manager DBA

Confidential

Responsibilities:

• High level Design and implementation of 24/7 support model, Security model for productions support databases.
• Scooping and planning process definitions, including post go-live enhancements and Disaster recovery.
• Installation, upgrade and configuration in oracle 11g, 12c,18c,109c, RAC ASM instance in on-prem and Azure cloud.
• Linux kernel tuning for optimizing oracle database performance using transparent huge pages.
• Expert technical skills in the area of Oracle provisioning, Installation, Physical/Logical Database Design, Administration, Core Performance Tuning, Migration, Backup and recovery,
• Proficient in Production Support, Installation, Configuration, Upgrades, Patches, Cloning, Capacity Planning, Space Management, Database security, Auditing & Troubleshooting.
• Defragment / Rebalance ASM Disk to reduce ASM disk I/O.
• Migrate On-prem oracle database to Exadata 4 node RAC Machine.
• Management of best-practices deployment for database production support.
• Root cause analysis for every critical production issue minimalizing negative business impact.
• Extensive experience leading complex cross-functional teams while facilitating growth and development through training opportunities.
• Reduced the monthly ticket count and pager count from 1200 to double digit by Identifying the root cause, optimizing duplicate incident and permanent fix.
• Have worked in highly secured and compliance environment.
• Resource management and deployment for various projects and providing training to end users.
• Training and guiding team members and enabling knowledge sharing among the team.
• Well versed in Change management.
• Always take care of business-critical database like Replenishment (JDA), Schaeffer DC, Return center Jira, International pricing, GLMS, JDA transportation.
• Attending all Business-Critical WAR Schaeffer DC, return center, Providing Solution-intents & Resolving the issues.
• Provisioning of Bare metal and VM instances using ansible for 3 node Oracle Real Application Cluster.
• Experience with database support in IaaS or PaaS preferred.
• Consolidation of oracle databases to Exadata machines including capacity planning, right sizing, high availability and business continuity using Maximum availability (MAA) architecture.
• Dashboard and Confidential Home office and e-commerce traffic/performance monitoring using NAGIOs and Oracle EM.
• Oracle Data guard setup between on-premises and Microsoft Azure cloud for International pricing and JDA Transport management system.
• Linux kernel tuning for optimizing oracle database performance by transparent huge pages.
• Oracle enterprise manager OMS Active-Active configuration setup
• Installation, upgrade and configuration in oracle 11gr2, 12c,13c ASM instance in AIX, Linux and HP boxes.
• Automate to apply quarterly PSU patch and one-off patch for each version of database.
• Monitoring and setting up an alert in Oracle Grid enterprise manager from 13c.
• Migration of databases from Exadata, Oracle 13c to Bare-metal and vice versa using RMAN.
• Provides hands on technical expertise, provides senior level technical guidance to staff, project leaders and other teams as necessary.
• Analyze AWR report, ASH report based on the performance issue and implemented workaround.
• Researching and analyzing emerging Oracle database technologies, techniques, and protocols and making recommendations.
• Configuration and trouble shoot RMAN backup for production test and UAT databases on IBM Tivoli.
• SQL tuning through advisory central and SQLT and SQL baseline.
• Configuring ASM and Migrated Non-ASM Databases to ASM databases Using RMAN
• Analyzing repetitive issues for space and growth. Implemented automatic space management tool for space growth by accumulating facts and findings.
• Administer oracle Cluster ware using: crsctl, crs stat, ocrdump, ocrconfig utilities.
• Managing distributed teams including my offshore support team
• Automated process to reduce incident count for Home office server.
• Supporting One of the World’s Largest Memory Database for Confidential Environment.
• Create weekly report using Tableau and Analyzing report reduce incident count and scoping for automation.
• Proficient in process management, CICD, Agile methodologies like Scrum, Kanban, Lean, XP, tracking tools like JIRA.

Senior systems Analyst

Confidential

Responsibilities:

• Provided Level 2, 3 support (Technical support for Oracle.)
• New Database Implementation, Capacity Planning, Database Security Implementation,
• Continuously managed performance through trending analysis and work with development teams on identifying tuning opportunities.
• Monitored Periodically Hit Ratios for Database Buffer, Redo buffer, Library Cache and took actions accordingly.
• Responsible for database backups, design, development, testing, and performance tuning.
• RMAN Backup Implementation and Resource Monitoring.
• Developed and monitored database backup and recovery processes.
• Monitored dead lock and row exclusive lock object.
• Proactively Reorganized Space for tablespace.
• Maintained all the source code for the development server through Git.
• Loaded data from external file through SQL loader.
• Maintained and improved high Availability and Disaster recovery. Recovered the production database whenever required.
• Instance monitoring through no. of users connected and resource occupied by memory. Killed the idle user session release virtual memory.
• Analyzed database through user level and dropping unused index and recreated the same index and validated.
• Monitored Multiple Database activity through Quest Spotlight.
• Extensively used RMAN for database backup, restore, and duplicate copy on the same as well as on different node.
• Monitored alert log file for ora-0600 error periodically and took actions accordingly.
• Created split partition for each financial year.