Manager Service

Resume-Ajai Sahni

Professional Summary

Over *+ year’s customer facing, Oracle Database Administration experience, manage 5 DBA’s and SME’s while working with Oracle ACS, Oracle ISM, Oracle Online DBA 24*7. Specializing in architectures, installation, configuration, monitoring, tuning, troubleshooting, backup, security, management and administration of infrastructure on multiple operating systems supporting dev, test and production environments which are mission critical and highly concurrent. I have strong exposure to managing databases on the cloud. Participate in WAR room debates to resolve issues.

Achievements:

Managed databases with highest concurrency: 1 million active sessions,

Largest database size: 34 TB,

Largest Database Migrated: 20 TB,

Maximum RAC Nodes: 4,

Application and Database Tuning Projects: 5, SQL,PL/SQL, Scheduled Jobs, application contention besides highlighting middleware, network, storage, operating system bottleneck and helped resolve them, prepared several root cause analysis (RCA) of incidents.

Maximum WLS instances: 70

Skill Matrix:

Architectures: Maximum Availability, High Availability, Maximum Security, Multi-Threaded, Distributed, Replication

Oracle Database Versions: 11g, 12c, 18c & 19c

Options/Features: RAC, ASM, Grid, Data Guard, Partitioning, Golden Gate, Real Application Testing (RAT), Tuning &Diagnostic Pack, In-Memory, ASO Advanced Security options, Compression, Audit Vault, Native Auditing

OCI: EXACS, Analytical Cloud, OSCSA, Storage, Compute, VPN–IPSec, FastConnect, Log Analytics, Chat etc.

Monitoring: Discover and monitor the targets using Oracle Enterprise Manager viz. Database, WebLogic, host, CPU, N/W, set threshold limits, setting blackout during maintenance, monitoring automation using shell script, sql and plug them with OEM using UDM, etc.

Operations & Maintenance: Backup, performance, troubleshoot, upgrade, code review, compression, encryption, backup, assessment of database health and vulnerability, patching, DR drills, disaster recovery, Help meet with RTO/RPO challenges and associated SLA’s etc.

Migration: Large database migrations using RMAN, incremental RMAN, cross platform, MV2ADB, Sql*Loader, DataPump, GoldenGate, ODI and External Table, some of the migrations needed upgrade from lower version

Backup: Backup using RMAN on NetBackup, monitoring backup, Tune time to take backup large databases using various optimization techniques, restoration and recoveries.

Tools: AWR, ADDM, ASH, trace 10046 trace, expdp, impdp, logminer, SQL*Loader, Utilities: cluverify, OS watcher, EXA Watcher, sar, iostat, glance plus and strace

Programming: Proficient in writing SQL, PL/SQL, procedures, functions, triggers, design and implement Virtual Private Database, shell scripts.

Operating Systems: Oracle Enterprise Linux-OEL, HP-UX, AIX, Solaris, Windows management and tuning and troubleshooting including tracing

Functional: 24*7 Monitoring infrastructure in a ticketing environment, stabilization, customer facing, manage a team of multi skilled subject matter experts, escalation management, project management, service request management – ticketing, writing SOP, attend standup calls, group calls, manage shifting priorities etc.

Analytics: Build a data warehouse model, use Oracle Analytics cloud for visualizing the data and analyze

Teams: Managed a Team of 6 DBA’s, Senior stake holders like CTO,CIO, Information Technology Commissioners and Secretaries in federal and provincial government, extensively resolved customer’s incidents with Oracle Support, Platinum Support and on site customer’s technical teams comprising DBA, OS admin, N/W admin and storage admin etc.

Academic Qualifications

a) Master of - Computer Science and Applications (MCA), Aligarh Muslim University, 1992, 80%

b) Master of Science - Operations Research (M.Sc.) Aligarh Muslim University, 1989, Gold Medalist, 77%

Professional Qualifications

Oracle Certified Master, ITIL Certified, PMP (Trained)

Organizations Served and Projects

Freelancing: For Oracle University 01/2020 to day

Deliver Educational seminars on the following

*On Premise - Oracle Database Administration, Backup and Recovery, Performance Tuning, EXADATA, Real Applications Clusters, Data Guard, Enterprise Manager, GoldenGate, SQL, PL/SQL etc.

*OCI Cloud – IaaS and PaaS, Autonomous Database, Database Cloud Service, Infrastructure as a Service, Storage Cloud Service, Oracle Analytical Cloud Service, Data Integration Platform Cloud, Ansible etc.

Thunder Tool Manufacturing Ltd, Canada, IT Services Analyst, Canada 8/2018 to 01/2020

TTML is a manufacturing organization and I was deployed in a vendor driven IT division, responsible to manage IT incidents, assist in external IT Security Audit, Testing SonicWALL implementation, implement testing strategy for application, Identifying and documentation of application performance issues, DR Drills, automation in monitoring, Backups of IT infrastructure including Database, Email and applications. Identifying new functionality in the application, documenting requirements for business information system, implementing data encryption, masking. Day to day development/testing/upgrade, provide training to the IT team and users, liaison with vendor.

Implementation Success Manager –Database Specialist for PaaS and SaaS Japan & APAC Oracle Corp

6/2017 to 08/2018

ISM is a team of SME’s within Oracle cloud team (CSM) evangelizing new cloud technology, which is customer facing and responsible to resolve lift and shift escalations for the database to cloud. Stabilize the environment on Cloud. Manage, resolve escalated incidents for various cloud services

*Discovery workshops for various technologies at various customer sites and interact with C-Level Executives, prepare roadmap to cloud and present. Develop demonstrations at demo.oracle.com and showcase,

*Cloud adoption workshops, preparation and review of architecture, best practices to follow, demonstration, and benchmark applications.

*Build Cost Calculator for Autonomous Datawarehouse for CSM Community FAQ

*Liaise with various teams to resolve escalations viz. product managers, customer support, A&C partners, OCS, ACS and end customer teams. Some of the accomplishments are as below-

-All Database flavors on cloud: VM, Bare Metal, RAC, Data Guard, GoldenGate, Autonomous, EXACS

-Quest Global & MDI: Backup Cloud Service implementation, perform test recovery, documentation & handover.

-ComViva: Provisioned Infrastructure, Storage and Database Cloud service, Created Schema, loaded data, Test backup and restoration, go live, stabilization

-Quest Global: : RMAN Backup on Storage Appliance-OSCSA

-Syndicate Bank: Provisioned OAC, Loaded ATM switch data, performed various visualization on the data and demonstrated return on investment. Also demonstrated use case and capabilities of Digital Assistant for new employees in the bank. -

-HCL Infosystem : Using Ansible for provisioning IaaS

-Log Analytics : Implemented at Hero Moto Corp.

Technical Account Manager, DBA Services, Advanced Customer Support, Oracle Corp, 07/2009 to 5/2017

ACS is an on-site customer support organization of Oracle support. I started at ACS as a DBA and later led a team of DBA’s to serve North Indian Customers of Oracle ACS. ACS DBAs are annually contracted to perform critical changes to customer databases, write database Health Assessment Reports for highly concurrent, highly available databases of multiple ACS customers belonging to Banking, Telecommunication, Transportation and FMCG industries. Some of the activities performed in both the roles are mentioned below for both of the roles one after the other respectively. First as DBA

Ministry of Finance, Govt. of India, Central Board of Excise and Customs with TCS as SI Partner

*Consolidation of 46 regional databases, changes in schema on account of consolidation, partitioning and Virtual Private Database. Installation of 2 node 10g RAC (HP-UX) using VPD, stabilize the environment with each regional databases consolidation. Maintenance like addition of partition for each of the regional database and corresponding indexes. Install Enterprise manager, Tuning Pack, Diagnostic Pack, enabled alerts, RMAN Backup on EMC Storage. Improve performance of RMAN Backup using all the tuning remedies

*CBEC has five applications viz. import, export, risk management, GXS and ACES. These applications were written by various application vendors in different technologies viz. Oracle Forms, Reports, PL/SQL batch programs (120 no.) & Java. I trended the application performance, identified multiple problems in queries, execution plans, locking and deadlock, application logic change, stats gather, unusable indexes, partitioning, archiving, operating system, network, storage and suggested the changes in all the identified areas and brought down CPU consumption, Disk IO and increased throughput of applications besides implemented best practices.

*Configured database to use distributed transaction between RMS and ICMS databases, resolved distributed database transaction hung, locking issues etc.

*Resolved SLA on RTO/RPO without costly additional network bandwidth and network compression

*Performed quarterly DR Drills, quarterly patching, one off patching

*Clone database from production to test and dev and write SOP for team to follow

*Several RCAs involving node eviction, ORA-600, tuned begin of day program from 28 hours to 2 hours

*Database upgrade from Oracle 10gRAC to 11gRAC

*Implemented M7 hardware refresh plan, migrated multiple databases from HP-UX to Solaris

Employee Provident Fund Organization: Migrated 120 10g regional databases to 12c NON RAC multitenant, stabilized environment, RMAN backup using NetBackup, Installation of Enterprise Manager, enabled monitoring using Enterprise Manager, DataGuard setup and performed RCAs

Ministry of Finance, department of Income Tax, Govt. of India.

Migrated 20TB Income Tax Business Application Oracle 11g database from AIX to Solaris (2 node RAC, Data Guard). Post migration stabilization, monitoring using Enterprise Manager, tuning database, defragmentation, suggested schema changes to reduce the scheduled programs by implementing partitioning.

Punjab National Bank - PNB Core banking application ran on Oracle database 10g, size 34TB, 40K concurrent sessions a) Migrated 10g database from filesystem to ASM, later upgraded the ASM and Database to 11g, migrated from 2 node RAC to 4 node RAC used RAT for performance assurance, perform periodic DR Drill as per regulator’s requirement, Disaster recovery when dire incident occurred, Monitor using Oracle Enterprise Manager, Construction of FSFO for test database etc.

Indian Railways: At Railways there were multiple databases and I carried out the following tasks

*For ticketing application NGET, installed 2 node 11g RAC on Linux, installed Oracle Enterprise Manager 11g, Created schema objects, stabilize the environment. Resolved contention during peak load (100K concurrent session)

*For ticketing application NGET, Installed, configured 70 WebLogic Instances, deployment of application & tuned

*Installation and configuration of Goldengate, implemented unidirectional replication between OLTP and reporting system, configured and integrated mode, written SOP for operations team, Applied Quarterly patches. Code deployment on dev, rest and prod, troubleshooting to handle 100K sessions

*For Freight Operation, tuned database running on HP-UX, implemented Enterprise Manager for monitoring later migrated this database to EXADATA. Patching EXADATA, monitoring through OEM, health check and assessment, testing EXADATA for redundancy, tuned and troubleshoot to high CPU consuming queries, compression, EXAWATCHER utility, written SOP for operations team for various situations etc. worked with Platinum Support team to resolve EXADATA issues.

National Population Registrar India - Migrated biometric (prominent datatype LOB having 23 resident images) database from MySql to Oracle 11g using ODI. Partitioned tables for this data in Oracle and used multi block size support. Validated image data across MySql and Oracle 11g using pl/sql algorithms. Demo recovery of database

RISL Rajasthan state Govt. - Migrated Govt. of Rajasthan welfare database from Linux to EXADATA using datapump, secure backup database on ZDLRA using TDE, test backup and recovery scenario & OEM monitoring

Bharti Airtel-IBM - Oracle Enterprise Manager Implementation at Bharti Airtel to monitor 600 Telecom Databases,

Godfry Phillips - Migrated EBS database from Linux server to EXADATA and demonstrated ROI, RMAN secure backup on NetBackup library using TDE, demonstration of recovery, documenting SOP, handover, implementation of Enterprise Manager, Knowledge Transfer and handover.

Indus Towers: Implementation of Audit Vault

As Technical Account Manager of DBA services, I had following responsibilities

Prepare DBA service proposals, prepare architecture documentation, DBA writing service scope document, effort estimation, strategies to de-risk the scope, project management, help sales team by performing presales effort, work with Global Virtual teams for specialist review, review of project which are large by ACS auditors etc. Participate in XLOB calls for sales leads

Manage a team of SME’s viz. DBA, WLS Admins, Java Developer, OS Admin, N/W Admin, Storage Admins) to manage multiple DBA projects, manage multiple ACS accounts in North India. Grooming the SME’s etc. Manage critical period like year-end, quarter-end and month-end and prioritize service. Recruitment, coaching and retention of the technical team members.

Ensure service delivery as per the scope, service improvement through quality service, ensure service renewal, stakeholder satisfaction, obtain completion of service certificate from the customer etc.

For escalated cases extensive work with Oracle Metalink support, present RCA to stakeholder’s viz. customer’s IT manager, Operating system, Network, Storage, Middle tier and Database Administrators etc.

Periodic review of services to customers with customer stakeholders, run a monthly ACS Chat session for knowledge transfer for ACS Engineers.

Principal Consultant, Online-DBA, Advanced Customer Support, Oracle India 09/2007 to 07/2009

Online DBA Is a 24*7 remote database support organization of Oracle support using Enterprise Manager to monitor and log Service Request.

-Responsible for monitoring & resolve incidents for the infrastructure used by 25+ customers having EBS and custom applications which use RAC, Data Guard etc.

-SR review for quality of service and service improvement, change, outage, downtime, escalation management, monthly service delivery review and service presentation to the customer

-DBA shift schedule, shift management, shift handover, prioritization of service, conflict resolution etc.

-Online DBA Service commissioning, DBA services handover from previous vendor / Customer DBA team etc.

Industries Served

-Government: Department of Income tax, Central Board of Customs and Excise, EPFO,

Indian Railways, National Population Register, Indian Air force, RISL

-Banking: Punjab National Bank, J and K Bank, Oriental Bank of Commerce

-Telecommunications: Bharti Airtel, Mahanagar Telephone Nigam Limited, UNINOR, AIRCEL

-System Integrators: Tata Consultancy Services, Wipro, HCL

-FMCG& Others: Godfrey Phillips India Ltd, Australian Consumers Association -Choice

Awards and recognition at Oracle

Speaker at Oracle Open World, IBM DBA Day, OTN DBA Day, Membership for ST Partnership, Oracle Inner Circle Values Championship, Certificate of Appreciation, First Oracle Leadership Circle Certificate of Appreciation’2007, Pacesetter Award (ACS), represented Oracle India for product readiness in PRP Team of Oracle Corporation, Certificate of Merit for Outstanding Contributor to the Best Team, SPOT award for service delivery excellence by ACS at RajCOMP Info Services Ltd. (RISL)

Community Supported: RED CROSS: Blood Donation & Internal Compliance of Oracle

WHO : Covid-19: Preparedness and Response

Work Status : Permanent Resident (Canada)

Contact this candidate