Ravindra Saini, Database Administrator

Currently I am managing around 150+ databases with different flavours (Oracle/MSSQL/Progress..etc).

Having good experiences in Oracle ERP / OSB /API Gateway to integration with third parties systems.

Having Good experience in managing Data Guard / CI & CD and Kafka CDC.

Strong in performance Tuning & Upgrade the databases.

Strong experience in Data Warehouse Snowflake and OCI.

Managing Scheduled tasks on weekly & monthly basis : Cloning / database refreshing / Patching and helping the application team in solution design.

Currently Finished major operation : - Upgrade database on 19c / OCI migration / Design Data Warehouse and Implemented CDC.

Version Experiences :- Oracle DB 10g/11g/12c/19c & working on 21c (RAC and non-RAC & ASM / DR /Data Warehouse )

MS SQL :- Always-On 12/16

Oracle :- 9i to 19c (upgrade)

Oracle ERP :- R12.1.x R12.2.X

OBIEE :- 11g /12c

OEM :- 12c/13c

O/S :- Linux / Ubuntu / RedHat / Solaris Sparc / Oracle Supercluster M7-8 (Exadata).

Languages :- SQL / PL-SQL / Python / Shell scripting

Emirates Post

Sr. Oracle Apps & Database Consultant

March 2017 - Today (7 years and 9 months)

Dubai - United Arab Emirates

Design, implementation and administration of Oracle ERP, Oracle ESB (OSB & OAG), Oracle Hyperion, Halogen Talent Application, SAS, Microstrategy, OBIEE 12c, Discover 1 1g, DR, OEM 13c, Oracle RAC (HA) Databases, MS SQL 2016/2012/2008 (Always-on HA) and Postgres. Platform Migration, Upgrade & Maintaining :

• Migrated all Oracle database from Linux to Sun Solaris super cluster (M7-8) in High Available mode, This creative & innovative refresh resulted in saving of 20% OPEX.

• Migrated all MS SQL (2016/2012) databases in High Available mode (Always-On).

• Upgrade ERP application from R12.1.3 to R12.2.6 and configure Finance tool "Excel4app".

• Upgraded Oracle databases from 1 1g to 12c & 1 1g to 19c.

• Implemented Security on all the critical database (encryption, data masking, audit on object levels and implement SSL on application level).

• Maintaining various application along with application patching, security, upgrade and configured in High available mode.

• Configured One platform tool to monitoring all database in center location (OEM).

• Designed and implemented disaster recovery with RTO/RPO of 4 hours for all database infrastructure.

• Successfully conducted quarterly DR drills.

• Achieve NESA & TRA compliant (Evaluated the DB plantation against the NESA standards & remediated all non-compliances.)

• Implemented Oracle Enterprise Service Bus (ESB) to centralized the all custom & in-house application through APIs.

• Exposing & Consuming the APIs (REST & SOUP) through OSB & OAG on intra & internet.

• Managing P1/P2 incidents relevant to O/S, Databases & Application with in SLA.

• Managing multi OS (Linux , Windows , Sun Solaris, etc..) along with cron, CPU, patching.

• Managing ExaData and NetBackup appliance.

• Managing Backup, Cloning, Patching and performance tuning (Application & DB level).

• Maintaining & create process & policy for Audit , Security & inventory (relevant to infra).

• Met with SLA of 99.9% uptime of all databases.

Raqmiyat

Consultant

January 2015 - February 2017 (2 years and 1 month)

Dubai - United Arab Emirates

Worked With Raqmiyat as Consultant for multiple client: Client : Health Authority Abu Dhabi & General Women's Union.

• Re-architected the backend DB infrastructure for 100+ applications for better reliability, agility, performance and security compliances.

• Achieved maximum performance tuning of database and application modules.

• Managing Oracle ERP R12.1.3.

• Managing all databases and implemented security compliance.

• Managing backup , cloning , patching & upgrade.

• Migrated the legacy DBs/data to newly built RAC as the applications get migrated to Finance.

• Designing Backup/Recovery policies.

• Design Cloning strategies.

• Provides on-call support on a rotating basis for production system emergencies.

• Migrated the legacy DBs/data to newly built RAC as the applications get migrated to Finance.

• Met with SLA of 99.9% uptime of all databases.

Fujitsu Consulting India

Senior Technical Consultant

August 2014 - January 2015 (5 months)

Noida, Uttar Pradesh, India

• Managed 7 production and non-production ERP environments ranging from 11 i to R12.2.3

• Implemented upgrade from EBS R12.1.1 to R12.1.3 while also upgrading underlying database. Part of the pre and post GO LIVE team for production support. Resolving underlying GO LIVE performance issues. This is around 1 TB environment on Oracle Linux 5.5.

• Architected and implemented disaster recovery procedures in compliance with SLA availability clauses which included RMAN setup and configuration and Data Guard installation.

• Upgrade 11 .x to R12.1.3 and R12.2.x to R12.2.4

• Installed RAC 1 1gR2 on dual node with ASM on Solaris 10.

• Installation R12.2.0 and upgrading R12.2.0 to R12.2.3 on Linux server and Solaris.

• Installation Oracle portal Web Logic Server 1 1g and configuration with other applications.

• Installation SOA & Fusion Applications. Http://ravindrasainidba.blogspot.com/

Check out Ravindra's experience

Master Diploma in Computer Applications, Computer and Information Sciences and Support Services

CDAC NOIDA

2009

Master Diploma in Computer Applications, Computer and Information Sciences and Support Services

Bachelor of Science

CCS University

2004

B.Sc, Physics, chemistry, math