SUMMARY

• Hands - On, Talented, Strategic Leader with 19+ yrs. of extensive IT experience in different capacities: Operation Support, Database Management, Client Engagement, Delivery Management and Production Support across various domains such as Financial, Health, Retail etc.
• Strong experience in managing small & large teams in 24x7 mission critical Production environments.
• Successfully executed & managed Tier-1 Business critical projects ON-PREM involving technologies like Oracle, DB2, Vertica, MemSQL, MySQL and PostgreSQL on LINUX, AIX and Solaris platforms and in Google CLOUD
• Excellent in aligning technology solutions and architecture to meet business needs while leveraging innovative strategies.
• Possess financial acumen to establish budgets that are driven by plans, accurately forecast costs, efficiently manage variances and improve service value.
• Highly collaborative, accountable and results driven, especially strong in build-ups and build-outs of teams, technologies and processes.
• Highly effective self-driven, motivated leader with strong analytical and problem solving skills, able to make effective decisions under pressure and always excited to learn.
• Proven track record of executing through global teams, creating high performing teams. Excellent in hiring, coaching, mentoring resources and building individuals based on their core strengths.
• Excellent organizational, communication, interpersonal, presentation, leadership skills and who can prioritize well and very comfortable to interact with all level of an organization, vendor and partners.

TECHNICAL SKILLS

• Operating System: RHEL 7.7, CentOS 7.8, AIX 7.2, Solaris, Windows 2016, UBUNTU 16,18
• RDBMS: Oracle 12c, 18c RAC, MySQL 5.7/8.0, PostgreSQL 10.x/11.x, DB2 11.1, MemSQL 6.x, Vertica 9.0.1, SQLServer2008, MongoDB, GOOGLE CloudSQL 5.7, GOOGLE - PostgreSQL 9.6
• Replication Tool: Shareplex, Oracle ACTIVE DATAGUARD, Oracle GOLDEN-GATE, PostgreSQL STREAM Replication, MySQL replication (MASTER-MASTER, MASTER-SLAVE). MySQL GROUP REPLICATION
• Middle-tier /Middle ware/Webserver: WebSphere MQ, Apache Tomcat
• Languages: SQL, PL/SQL, SQL Scripting, Unix SHELL SCRIPTING
• Interfacing Tools: Exceed, Winscp, Kea X, Cygwin, Putty, SuperPutty, SecureCRT
• Web Performance Management: KEYNOTE, YOTTA, GOMEZ
• Server/Storage: NetApp Filer + Snapshots - (Creating/Restoring), Oracle EXADATA 5-2/7-2
• Utilities: MS Visio, LogMiner, MySQL Enterprise Backup (MEB), Trace Analyzer
• Version Control: GITHUB
• Monitoring Tools: OEM 13c, MEM, DSM, MemSQL OpsCenter, MONYOG, SiteScope, SPLUNK, Percona-PMM, STACKDRIVER, Grafana, Prometheus
• Migration Tools: Ora2PG, EDB xDB, SQLines
• Communication & Other Tools: Skype, Microsoft TEAMS, SharePoint, Clarity, Campfire, ServiceNow, CyberArk, MySQL Workbench, pgadmin4, DOCKER
• Project Tracking Tools: MS Project, JIRA, CONFLUENCE
• PUBLIC CLOUD: GOOGLE CLOUD PLATFORM (GCP), IBM Soft-layer.

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

Senior IT Manager

Responsibilities:

• 100% Hands-On and seasoned Senior IT MANAGER, managing 25 members team globally consisting of DBA’s, System Admins and Cloud Architects. Team includes both FTE and Contractors.
• Responsible and accountable for optimal performance, stability and 24*7 uptime of Macy’s business critical Tier -1 databases and systems On-PREM and in Google Cloud Platform (GCP).
• Especially proud for the project BACKSTAGE (off-price stores) that went live for last holiday season 2019 running on Google Cloud under my supervision. In GCP this was the FIRST live customer facing project for Macy’s.
• As a Stakeholder on multiple business critical projects that went live under my supervision, I efficiently handled the budget and sized capacity, resources, technology solutions that resulted in savings of thousands of dollars.
• MIGRATED multiple business critical projects running on Oracle Exadata to PostgreSQL and from Oracle to MySQL to save cost and Oracle to Google CloudSQL to leverage flexibility and scalability of the cloud which is much needed during peak retail seasons like Black Friday, Cyber Monday and the holidays.
• Responsible for planning, sizing, right database technology, OS, physical vs. Virtual, Storage, Backup and BCP strategy for new projects, review Build vs. Buy solutions to keep projects within optimized costs and on time
• Accountable and responsible for disparate database technologies (Oracle, MySQL, PostgreSQL, DB2, Vertica, MemSQL, cloudSQL) implemented and running across multiple datacenters of Confidential, Google Cloud and third party owned datacenters like IBM Soft-layer. Fully hands-on and into the weeds on each of the DB technologies.
• Work closely with Information Security, Legal, compliance and software asset management team to periodically review existing licenses, approve renewal or purchase of new licenses for the DB & OS technology stack at Confidential .
• Dedication to full development of each team member, approve trainings and conferences to keep them abreast with current technologies of the industry and to keep high engagements, motivation and commitment.
• Created clear roadmaps with priority & timelines for the team aligned with company goals. To meet the pace, deadlines took initiatives and carried out the required work and prepared documentation for the team to follow.
• Excellent skills in creating high performing rock star team, HIRING, RECRUITING, COACHING and have right techniques under my sleeves to keep the team engaged and motivated.
• Active member on CAB committee to review and approve change requests (CR’s) and maintenance requests (MR’s).

Environment: Google Cloud (GCP), Oracle 12c, 18c, MySQL 5.7, 8.0, PostgreSQL 10.11, 11.6, DB2 11.1.4, Vertica 9.0,1, MemSQL 6.7, VMWare, Oracle Exadata, DSM, OPM, OEM, MEM, MONYOG, CONFLUENCE, JIRA, ServiceNOW, Oracle Goldengate, Active DataGuard, Linux 7.7, CentOS 7.7, AIX, Ubuntu 18, Control M, Splunk, Chef, Sharepoint, MySQL Workbench, PgADMIN 4, MS Visio, HP SiteScope, VMWare, Skype, Putty, sCRT, Teams, Office 365, Percona PMM, GRAFANA. Prometheus, CyberARK, ORA2PG, SQLines, Docker

Confidential, San Francisco, CA

IT Manager - Database

Responsibilities:

• Led team of 10 members (onsite/ offshore) in 24*7 Production support environment with skill sets including Database Administration, Apache Tomcat Administration, IBM MQ Administration.
• Involved in planning, tasking, delegating, monitoring, providing feedback to upper management & mentoring the team.
• Monitor, track and report PROJECT STATUS to STAKEHOLDERS & management.
• Facilitated daily SCRUM MEETINGS with the onsite & offshore team.
• Collaborated with the client to gather PROJECT REQUIREMENTS, regular update on MILESTONES and DELIVERABLES for the project as per schedule.
• Reviewed and approved change requests (CR’s) and maintenance requests (MR’s).
• Successfully HANDLED PROJECT and RESOURCES involving installation and maintenance of 11gr2 Rac databases on Linux platform and setup of Active DataGuard for 11gr2 RAC databases using latest 11g Rman features.
• AUDITED and REVIEWED SECURITY gaps and created AUDIT REPORTS for senior leadership and closed the gaps by implementing latest Oracle Advance security features i.e. data encryption & integrity, TDE, Oracle Wallet.
• Successfully LED the PROJECT of bi-directional replication CROSS DATACENTER using REPLICATION tool ORACLE GOLDENGATE in production RAC env. Proactively generated TREND REPORTS like database growth, system performance metrics, CPU usage etc for the management
• COORDINATED with VENDORS such as GOMEZ, KEYNOTE & Yottaa and worked with LEGAL team to PROCURE web monitoring tools to monitor health and performance for company’s website across the geography.
• Handled various critical functional deployment releases from END TO END with stringent SLA’s.
• Competently managed project risks & issues, assessed impacts, discussed and carried out the solutions.
• Coordinated activities and project requirements with the clients and delegated the task to the onsite and offshore team and tracked progress.
• Proactively MENTORED & COACHED the team to keep them engaged, motivated and to bring the best of them.

Environment: MS Project, MS Visio, SHAREPOINT, JIRA, Oracle 11gr2 RAC, Linux 5.x, Active DataGuard, ASM, CVU, RMAN, 11g EM Grid Control, Toad, AWR, ADDM, Data Pump, Oracle Wallet, Data Encryption (TDE), Apache Tomcat 6.0.29, IBM Web Sphere MQ 7.0, Keynote Web monitoring, OSW.

Confidential, San Francisco, CA

Team Leader

Responsibilities:

• LED small team consisting of 4 DBA’s & 2 System Admin’s in 24*7 Production support environment.
• ESTIMATE Effort/ TIME requirements/ RESOURCE requirements/ Sequencing of activities for the projects.
• Created and TRACKED PROJECT MILESTONES and PROJECT DELIVERABLES within schedule timeframe.
• Breakdown of the work into smaller and more manageable pieces using WORK BREAKDOWN STRUCTURE style.
• Involved in end-to-end project management and provided regular project STATUS REPORT to stakeholders & MANAGEMENT.
• Executed and delivered PROJECT of upgrading Oracle 10g RAC to 11G RAC on Linux platform with minimal downtime.
• Successfully MENTORED setup of Active DataGuard for 11gr2 Rac databases using latest 11g RMAN features.
• Successfully handled various releases / configuration/post go live management.
• Planned & supervised hardware upgrade in pre-prod, DR and Prod environment, keeping minimum downtime window
• Presented and gave demo to the business on how to leverage Oracle Advance security features across various layers for the existing model.
• PLANNED, Tested, successfully implemented & DOCUMENTED Oracle Advance security features i.e. DATA Encryptions & integrity at various layers such as database, application and over the network of the existing model to avoid from various possible kinds of attacks, verified the packets by using third party tools like WIRESHARK.
• Presented to business and team for various HA (high availability) options available in the market option such as GoldenGate and Shareplex.
• Successfully handled the implementation project of GoldenGate in production RAC environment.
• MENTORED DBA TEAM in installation/configuration and setting up of replication for MySQL 5.1/5.5 on Linux 5.5.
• Successfully handled project for migrating 11gR2 Oracle database application schemas to MySQL5.1 database using MySQL GUI tools and setup of MySQL monitoring tools like MySQL Workbench 5.2.31, MySQL Monitor
• Performed POC on migration of 11gR2 Oracle database to Postgres8.4AS as per business needs.

Environment: MS PROEJCT, JIRA, MS VISIO, Oracle 11gr2 RAC, 10g RAC, Oracle 11g/10g, GOLDEN GATE 11.1, Solaris 10, Linux 5.x, Active DataGuard, ASM, SQL*Loader, RMAN, Toad, sCRT, AWR, ADDM, CVU, Data Pump, Shell Scripts, MySQL5.5, MySQL Workbench 5.2.31, MySQL Monitor v2.3, MySQL Enterprise Backup, Postgres 8.4AS, 11g EM Grid Control, Oracle Wallet, Oracle TDE, SHAREPOINT