Experience

• 

  Mindspace networks pvt. ltd.

  Mar 2007 - Nov 2007

  Junior dba trainee

  Worked as part of the DBA team in administration and day-to-day maintenance of Oracle Databases. Activities performed include installation of Oracle server/client, designing and configuring the memory database logical structures, Administering users and privileges and taking backups. Worked on a project to migrate the data in legacy systems into Oracle 9i. Involved in the RDBMS design for the databases structures.Roles and Responsibilities====================Creating Users and granting those privileges and roles. Maintenance of tables, indexes and tablespaces.Cold and hot file backups.Statistics collection on tables for CBO. Constant tuning of queries and memory structuresConfiguring and using statspack reports.Technologies Used: Oracle 9i, SQL Loader, SQL* Plus scripts Show less

• 

  Oracle

  Nov 2007 - now

  Managing the Tech Admin within the OCI org that takes cares of Run &Maintain function for both On-Premise and OCI customers.Leadership experience of managing a diverse team of more than 30 resources via team building meetings, 1:1 coaching and goal-oriented management. Have been able to achieve operational efficiency YoY.Work and engage extensively with pre-sales team, solution architects and customer management in defining strategy, delivery model, SOW's, Solutioning, Labor estimation & skill building for Cloud Delivery. Actively involved in succession planning, talent acquisition and engagement strategies to ensure seamless operations.Conduct Client Workshops to articulate the business requirements and challenges.Skill-gap-analysis for the team, Operation schedules, Role distribution.Part of operations review with higher management to review if resources are being utilized to the optimum level.Assist in the alignment of executive management goals and processes via written reports, presentations and other communication to executive leadership (Metrics report, Dashboards, KPIs and statistical information).Lead business analysis efforts to best manage attrition and ensure appropriate staffing for all shifts and high-volume holiday times.Assist in Project planning, implementations and analyzed deliverables. Review Analysis of Version UpgradeLead new bookings and managing budget with an expected target margin of around 48%.Handle quarterly revenue forecasting and head count reporting.Task assignment, team review and productivity/performance reviews via TRBs, appraisals and check-in conversations. Show less Team level initiatives like defining processes, knowledge sharing, hiring, quality improvement tasks, etc.Conduct Knowledge Training and Workshops for immediate team as well as Global Change Management organization. Develop training documents and provide functional training through classroom and individual training sessions.Responsible for seamless transition of newly live OCI customers from migration to Run & Maintain support.Troubleshoot complex issues and resolve problems, communicating solutions clearly to help limit problems reoccurring.Assisted special & premium Oracle customers through the customer account ownership/primary POC role. Clients - WorleyParsons and MVS Dish.Support for OCI post-migration activities & operational readiness. Primary responsibility for any specific customer requests, escalations, etc and ensured enhanced support services were provided.Responsible for seamless transition of newly live OCI customers from migration to Run & Maintain support.Chalk out plans to leverage automation to enable touch free issue resolution thus making it less people intensive and ensuring optimum utilization of available resources.Automation tools (ATOM/CMP/ACE) – Responsible for weekly/overall analysis of executions (submissions/failures/interventions) and taking corrective actions on actionable items to improve success percentage for all automations.Co-ordinated multiple internal projects till completion by accomplishing goal within the timelines.Establishing, refining procedures and other IT processes to detect errors and inconsistencies.Successfully lead a TechAdmin 7 member team providing 24X7 dedicated end-to-end support involving all activities of delivery lifecycle. Responsible for all management decisions for the team. Show less Handle Escalation Tasks in the role of Shift Lead for coordination of resources and workload between engineers from the US , APAC and EMEA timezones.Responsible for handling escalations from MCS customers & ensure escalations are closed in a timely manner.Build strong relationships across teams to foster effective teamwork and maximize efficiency.Instrumental in recruiting, mentoring and imparting training to new recruits to the global team (India, Egypt, Chile and Dalian).Part of management team involved in knowledge management (process & technical) and sharing best practices with the global team.Internal Auditing of engineer work for quality improvement and providing corrective actions wherever required.POC for escalations to management level to get faster resolution on critical issues – Change Management.Responsible for coordinating, reviewing and sending maintenance notifications at storage, network, windows and EM Grid level.Participation and active contribution to Global team Projects and Initiatives.Handle High touch project initiated for highly escalated customers. Main role was to be the SPOC for these customers and coordinate with operations to ensure a high level of service with acceptable turnaround time for escalated issues.Coordinating and working with Oracle Support on SR/RFC. Show less 24x7 Oracle Applications & databases support for multiple clients in Production & Non production environments.Responsible for Installation, Patching, Cloning, Maintenance, & Administration.Involved in planning/execution of R12 upgrades. Performed multiple complete iterations of upgrade from 11.5.10.2 to R12.1.3, R12.1 to R12.2, R12.2.2 to R12.2.7.Performed Database upgrades (9i - 10gR2, 9i – 11gR1, 10gR2 – 11gR1, 10gR2 - 11gR2, 11gR1-11gR2 and 11g to 12c) & Cluster Upgrades (11g, 12c, 18c & 19c) across various platforms including Solaris, Linux, Exadata, Exalogic, SuperCluster and AIX servers.Work experience in OCI (Oracle Cloud Infrastructure), Exadata and Supercluster platforms.Performed DB refreshes and cloning of 11i/R12 Applications using rapid clone utility.Applications and database monitoring/tuning using Oracle Enterprise Manager Grid control.Experience in duplicate & cloning/restore/recovery from hot/cold backup using RMAN.Worked on HA & DR environments.Performance tuning of Oracle Database, applications and queries.Experience in implementing best practices for maintenance, monitoring, growth management, contention resolution scenarios for various environments.Troubleshooting Oracle Apps components like forms, apache, concurrent manager and reports servers in 11i/R12.Technologies Used: Oracle Applications: 11.5.10.2/R12.1.1/R12.1.2/R12.1.3/R12.2.x/Oracle Application Server 11gAS & 10gAs Databases: Oracle 9i/10g/11gR1/11gR2/12c and 19c.Platforms: Red Hat Linux, Sun Solaris, Sun T4, AIX, Exadata, Exalogic, SuperCluster, OCITools: OEM, Net Backup, RMAN, SVN, TKPROF, Explain Plan, ORADEBUG, etcOthers: AD Utilities, SQL*Loader, TOAD, XML/BI Publisher, Unix Shell scripting, Weblogic, MWA, GRC, SSO, Avalara, Discoverer, etc. Show less Responsible for L1 IT Support for MCS customers via Service Requests, Phone Support, E-mail Support.Support Oracle’s hosted customers and provide DB and application support to Oracle products and services.Handled escalated customer issues & service requests.Rapid Resolve Work which includes Data Fixes, instance bounces, patching, etc.Performed DBA activities as part of express services with minimal lead time.OWC (Oracle Web Conference) assistance when needed from support, development or Customer.Involved in co-ordinating, handling and diagnosing outages for customer hosted instances (production and non-production).Provided communication and technical training session to the Global team. (India, Chile and Egypt).Involved in preparing monthly team statistics for different operations teams as requested by upper management. Show less

  • IT Manager - Managed Cloud Services

    Apr 2021 - now

  • Team Lead

    Jun 2016 - Apr 2021

  • Senior Technical Analyst

    Nov 2013 - May 2016

  • Technical Analyst

    Jul 2010 - Oct 2013

  • Associate Technical Analyst

    Nov 2007 - Jun 2010