Consulting in Database Administration - OCI and Exadata• Responsible for administration of Oracle DB infrastructure spreading across multiple flavors like AIX, Linux, Exadata on Oracle Cloud.• Responsible for smooth service delivery of 15 members working for Sodexo on Data related technologies.• Automation of DBA tasks, Code Rewrites, Working closely with Application teams on new implementations and performance tuning.• Maintaining huge data warehouse DB setup on Oracle Exadata hosted at OCI.• Cloud Adoption -Cross platform database migrations from on-premise to OCI. • Golden Gate Replication, RMAN clones, Data refreshes, Patching and upgrades, DR & HA setup and tests.

Worked at NTT Data Services as Specialist Advisor in Database Administration for CitigroupCloud Adoption Specialist/Lead Oracle DBA at Citigroup’s ICG sector n. Assisting apps adopt and migrate to private cloud solution starting from solutioning until go-live.Day-to-day work included engagement with business, app, engineering, solutions and support teams to ensure smooth adoption/migration cloud to make use of new automated features, better management, enforced standards and reduce costs.Primary database contact for many franchise-critical applications like Flexcube Core Banking, Faster Payments and commercial cards.Providing database support through entire SDLC for implementation of Flexcube & Faster Payments in many LATAM countries.Created proof-of-concept setup for Flexcube Core Banking 24x7 using GoldenGate 12.3 Hub based architecture.Setup and supporting Golden Gate bi-directional replications using Integrated Extract/Replicat. Work involves performance tuning, troubleshooting, automated maintenance and monitoring jobs.Established, documented and revision of cloud migration/adoption processes making use of cloud methodologies with no SYSDBA access and custom controls defined by engineering and cloud ops teams.• Cloud & Automation -> Migrations to automated database private cloud environment.• Setup and support of Oracle GoldenGate replication v21,19,12 (Integrated/classic, traditional/hub based, uni/bi-directional), performance tuning and high availability.

Worked as Cloud Adoption Specialist/Lead Oracle DBA at Citigroup’s ICG sector primarily in NAM location. Assisting apps adopt and migrate to private cloud solution starting from solutioning until go-live.Day-to-day work included engagement with business, app, engineering, solutions and support teams to ensure smooth adoption/migration cloud to make use of new automated features, better management, enforced standards and reduce costs.Primary database contact for many franchise critical applications like Flexcube Core Banking, Faster Payments and commercial cards.Provided database support through entire SDLC for implementation of Flexcube & Faster Payments in many LATAM countries.Created proof-of-concept setup for Flexcube Core Banking 24x7 using GoldenGate 12.3 Hub architecture and Oracle Database 12.2. Automated maintenance and monitoring jobs.Established, documented and revision of cloud migration/adoption processes making use of cloud methodologies with no SYSDBA access and custom controls defined by engineering and cloud ops teams.Other responsibilities include• Database upgrades to 12c and 19c • Database cross platform migrations using XTTS incremental and GoldenGate• Capacity planning, performance tuning.• Day-to-day database troubleshooting and L3 support of database infrastructure that use Oracle RAC, Active Data Guard, Golden Gate, Advanced compression and many other features.• Database refreshes, clones, monitoring using OEM 12c & 13c.

Working as Senior Oracle Database Administrator supporting Center Point Energy's Transaction Management Hub, Mobile Data and Other applications. Responsible for regular support and maintenance of huge production and non production databases based on Oracle RAC, Oracle Data Guard Physical and Snapshot Standby on AIX servers. Also responsible for working closely with application teams in all phases of software development.Environment DescriptionOracle 11gR2, 11gR1, 10gR2 and 9i with ASM/file system storage.Oracle 11gR2 clusters with ASM storage.Oracle 11gR2 Data Guard environment.Tivoli Storage Manager tape management tools.Oracle Enterprise Manager Cloud Control 12cService Now Service Automation ToolMajor Job responsibilities include• Providing day-to-day support catering clients and application teams.• Supporting 24X7 clustered databases catering business critical applications for CenterPoint Energy• Upgrading databases to latest versions and releases as & when released.• Maintaining Oracle Data Guard physical and snapshot standby setup.• Streams replication setup and monitoring for Mobile Data databases.• Supporting application level upgrades and releases.• Role/privilege mapping to users and schema management• Reaching out and working with vendor Oracle for various databases related bugs and fixes.• Troubleshooting any performance issues reported by clients/application team and resolving them in a timely manner based on criticality.• Monitoring alerts dispatched through OEM 12c and taking appropriate action.• Performing database restores, export/imports using data pump.• Working on a project to reorganize a huge TMH database (30TB) making use of big file tablepsaces, ASSM, online redefinition, securefiles and advanced compression in 11gR2 to reclaim space and for better management.

Infrastructure Support for DuPont, Newark, Delaware Senior Oracle DBA in a service based environment consisting of 400+ databases on 50+ severs across multiple data centers.Environment DescriptionOracle 11gR2, 11gR1, 10gR2 and 9i with ASM/file system storage.Oracle 10gR2 clusters with ASM storage.Oracle 10gR2 Data Guard environment.Net Backup and Tivoli Storage Manager tape management tools.OEM 11g, 10g and VERITAS active/passive clusteringMajor Job responsibilities include•Providing 24X7 on-call support to client on rotational basis.•Handling and allocation of tasks, escalations as per priority to the team.•Working on data center and client auditing, defining baselines, establishing procedures and standards for all databases.•Working on all phases of project like requirements gathering, designing, implementation, deployment, support and continual improvement. •Representing the team in Incident Resolution, Service Restoration, Root Cause Analysis, Change Management and Advisory meetings.•Participation in DSR (Daily Status Review) meetings and ensuring the resolution of tasks as per established SLAs.•Handling new database, schema and object creation requests from clients, issuing grants and roles, account password resets based on pre-defined SLAs.•Installation, Administration and maintenance of RAC databases and services.•Space management using ASM, Adding/Deleting disks to/from disk groups and rebalancing•Performing database/schema refreshes and restores using exp/imp, data pump and RMAN.•Monitoring the database using 11g Oracle Enterprise Manager. Tasks include registering targets, assigning metrics, creating rules, setup of blackouts for known maintenance schedules.•Working on database software upgrades & migrations across data centers.•Applying cluster and database security patches as soon as Oracle releases them.•Troubleshooting any performance and other database issues reported by end users and application team.

ADP is a product based company that provides payroll and HR services worldwide. Worked as shift in charge and senior team member in a huge environment consisting of 50000+ databases across 5000+ servers spanning across multiple data centers serving over 5 Lakh clients. Environment DescriptionOracle 11gR2, 11gR1, 10gR2 and 9i with ASM/file system storage.Oracle 11gR2, 11gR1 and 10gR2 clusters with ASM storage.Oracle 11gR1/ 10gR2 Data Guard environment.Net Backup and Tivoli Storage Manager tape management tools.OEM 11g, 10g and VERITAS active/passive clustering.Major Job responsibilities include• Serving the clients as point of contact for the shift. • Handling and allocation of tasks, escalations as per priority. • Handling 24/7 on call operational support for escalations and prioritized tasks. • Supporting EHRMS, Payroll, eTime, ADPR applications for production deployments and upgrades.• Providing the status of long running tasks to the next shift to ensure successful completion. • Monitoring the online ticketing system for prioritized database and server tasks. • Installation, configuration and maintenance of large database clusters in both Oracle 11gR2 and 11gR1.• Participating in outage and service restoration calls and CAB (Change Advisory Board) meetings.• Refreshes of QA/TEST/DEV databases from production databases using export/import, RMAN and data pump when required.• Resolving database performance issues reported by clients.• Logical and physical backup failure remediation using SEAMS.• Working on basic SQL Server database tasks like database creations, grants & privileges, backups & restores.

Bombay Stock Exchange is a major trading platform based out of Mumbai, India. Worked as senior team member for BSE Online Trading (running on HP NonStop OS with NonStop SQLMP database) and Integrated Market Operations (running on HP-UX with Oracle database) applications. Environment DescriptionOracle 10gR2 and 9i with file system storage.HP Nonstop systems with SQLMP database.Netscape Web Server and Jrun servlet engine.Major Job responsibilities include• Monitoring online trading application and integrated market operations.• Performing daily start of day and end of day procedures before/after actual trading hours.• Resolving server deadlocks on database tables and prioritizing servers based on live traffic. • Generating database reports as per client’s requirements. • Identifying impact on performance and creation of indexes and partitions on existing tables. • Giving security (Read, Write & Execute) access to tables based on network and yser groups.• Documenting all changes and performing bi-annual quality check of standard practices.• Ensuring the systems comply to audit checklist.• Deploying Java/C programs and SQL codes for QA and production releases.