Support Specialist Oracle Dba

RAJEEV SHASTRI

Email: ******.*****@*****.***

Contact Number: +971*********

Linkedin:www.linkedin.com/in/rajeev-shastri-112b81b

Github: https://github.com/rajeevshastri81

PROFILE SUMMARY

IT professional with 17 years of technical experience in delivering high quality IT Solutions and support.

13 year’s banking experience with leading banks like Emirates NBD, Rak Bank, Sharjah Islamic Bank, First Gulf Bank (FAB) etc.

Wide exposure to IT field including database administration, application support, infrastructure support, quality assurance and architecting end-to-end DevOps implementations.

Highly skilled in designing and implementing an effective & resilient IT database architecture, improving processes, reducing costs, etc.

Certifications and good knowledge of single/multi cloud environments including AWS and AZURE.

Fostering and leading collaboration between various IT teams such as designers, architects, testers, developers to successfully deliver IT solutions including migrations and upgrades.

IT skills expertise in areas of database administration –SQLServer,Mongodb,Oracle and Cloud RDS

Good knowledge on IT best practices such as Agile Methodology, Scrum Framework, IT Security (CIS benchmarks), Project management (PMP) etc. Coach and lead team on execution of Agile methodologies; lead the cultivation of a continuous improvement culture through transparent communication and high collaboration.

Experienced in infrastructure automation to apply configuration to thousands of nodes using configuration tools.

IT Education - Masters in Computer Application (MCA) from Punjab Technical University- Jallandhar, India

IT Certifications- Oracle certified Associate, Mircosoft sql server operation, Microsoft Certified Azure Fundamentals, Hadoop foundation, Bigdata foundation, Data Science Foundation, Scrum Fundamentals Certified, Redhat containers and Kubernetes fundamental, Datastax Cassandra Enterprise

EDUCATION

Master in computer application from Punjab technical university Jallandhar India

CERTIFICATIONS

Oracle certified Associate

Microsoft Certified Azure Fundamentals

HCIA-Big Data

Azure Database Administration(DP-300)

Microsoft SQL Server operation

Hadoop foundation

Bigdata foundation

Data Science Foundation

Scrum Fundamentals Certified

Redhat containers and Kubernetes fundamental

Datastax Cassandra Enterprise

WORK EXPERIENCE DETAILS

Employer:- Huawei Technologies Pvt Ltd(UHRS)-G42CLOUD—Cloud Database Architect-Mar 2022 – Till Date

Managing Mongodb,Oracle,Sql Server, G42 cloud RDS,NOSQL and Big Data Services

Implementation of Data management platform on the G42 cloud for a high-profile public organization (Abu Dhabi Digital Authority) that uses a variety of services, such as ECS, RDS, Containers, map reduce, Data lakes,Elastic Search, MRS, Data governance, Data Ware house and security services using cloud-based data migration solutions, such as cloud data migration and data recovery services.

Translating project-specific requirements into a cloud structure that meets those requirements, as well as taking into account the project’s resource use and scalability requirements.

Develop a well-informed cloud approach and monitor the transition

Implement and oversee all aspects of the cloud environment including provisioning, scale, monitoring, and security

Collaborate with Enterprise Architecture, Data Platform, DevOps, and Integration Teams to ensure cloud adoption follows standard best practices

Experience in upgrading and migrating various application from different platforms to cloud Platform.

.

Employer:- Coforge Middle East Technical Architect Sept 2021 – FEB2022

Key Highlights:

Experience in managing oracle19c,db2,MongoDB 5 environment from availability, performance and scalability perspectives and Monitoring.

SQL Tuning including analyzing existing code and providing recommendations for improvement

Experience in upgrading and migrating various versions of Mongo database on different platforms.

Coordinates and works with other technical staff to develop database architectures, coding standards, and quality assurance policies and procedures

IBM MQ,DB2,Cognos,websphere,Appconnect and Apache and Tomcat Administartion.

Database Migration Plan execution from Legacy Application to Microservice Architecture with Latest Technologies I.e Mongo db,Elasticsearchdb,Datastage,Oracle DB,Kafka,zookepper,Cloudera and Kudu Datawarehouse.

Employer:- Netzone Technical Solution Db Consultant Nov 2019 – Aug 2021

Key Highlights:

Manage Mysql,Oracle, SQL Server and NOSQL DB mongodb and AZURE cloud for High Profile Public Entity

Strong DevOps with AWS RDS /AZURE Cloud database setup, config, sizing, automation and disaster recovery

Knowledge in scripting language like BASH jobs, Kron jobs, Powershell, Ansible.

Automation of DB scripts, filtering data from different tables and migrating that to another DB

Proficient understanding of code versioning tools such as Git and integration of Git in SQL file management

Understands DevOps, Continuous Build and Continuous Integration/Deployment processes, combining and automating

Setup High Availability and DR For Oracle,SQL Server by using Data Guard and Always on.

Experienced in using array of monitoring tools (sitescope,AppDynamics, Nagios)

Employer:- Emirates NBD Infra Support Specialist Aug 2018 – Oct 2019

Key Highlights:

Managed SQL Server as Primary and NOSQL DB Mongodb,Sybase iq db as secondary resource through multiple product life cycle environments from development to mission – critical production systems to internal Private Cloud as DAAS.

SQL server Consolidation to Distributed SQL SERVER 2016 Always on and Private Cloud DAAS.

Experience in configuring SQL Server HA & DR strategies with Clustering, Mirroring, AlwaysOn Availability Groups and Disaster Recovery plans with DR Drills

Adherence to and engineering of database and data security policies

Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.

Strong knowledge in understanding to use the best cloud provider (AWS, Azure) to host the underlying infrastructure for the microservices and/or applications

Employer:- RAK BANK Senior DBA May 2012 – July 2018

Key Highlights:

SQL Server Administration, SQL Server Consolidation to SQL server 2016 Always on

NOSQL Administration For Datastax Cassandra DB and Mongo dB

MySQL 5 and PostgreSQL 9 administration

Independently analyse, solve, and correct issues in real time, providing problem resolution end-to-end.

Refine and automate regular processes, track issues, and document changes

Assist developers with complex query tuning and schema refinement.

Provide 24x7 supports for critical production systems, Automation of db. tasks.

Perform scheduled maintenance and support release deployment activities after hours.

Share domain and technical expertise, providing technical mentor ship and cross-training to other peers and team members.

Employer:- Sharjah Islamic Bank. DBA July 2009 – May 2012

Key Highlights:

Installing and maintaining databases SQL server 2012 and Oracle 10g and db2

Administration of the database including performance monitoring and tuning.

Taking part in the preparation and execution of technical tests.

Populating a database with new information or transfer existing data into it.

Creating backup copies of data.

Oracle application dba like rapid clone, family packs

IBM TSM administration and DR replication for tape Library

Policy Planning and implementation for Security, Backup and infrastructure operations.

Disaster Recovery Planning and Execution.

Employer:- Gulf Computers Pvt.Ltd Oracle DBA Nov 2007 – May 2009

Key Highlights:

Database Sizing, Table space Management,sql server Migration

Production Movements At Database And Application Level Approved By Quality Team authorized by visual source safe

Deciding on Data purging & Retention Policy.

Migrating data from Test to the Production database using migration scripts in Oracle.

Doing the performance tuning of oracle database using tools like AWR and ADDM & checking the cost of application by seeing their execution plan from the plan table.

Performing the replication of database from production environment to test environment so as to test the application policies.

Migration from windows oracle 10.1.0.0.0 to Linux Oracle 10.2.0.3.0

Implemented Oracle 10g Grid for all Databases, application server and Web Server.

Employer:- HFCL Infotel Limited Oracle DBA Dec 2006 –Nov 2007

Key Highlights:

Creating Oracle database, table spaces, and tables with integrity constraints and creating necessary indexes over the tables.

Managing more than 21 databases running in different environments.

Managing Production database having size around than 6 TB and 100 application users.

Performing regular DBA Activities such as Backups, Modifying Database Structures, Managing Database Storage, Maintaining System Security, Profiles, and Roles etc. using Oracle Enterprise Manager.

Monitoring and optimizing the performance of the database using tools such as OEM.

Implementing Recovery Strategies and recovering the database in case of Crash to minimize downtime of the Database.

Employer:- Pugmarks Interweb Pvt. Ltd Oracle DBA July 2006-- Dec 2006

Key Highlights:

Installed and configured Oracle 9.2.0.4, Oracle 10g on Linux platforms multi-nodes and multi- instances like Prod and Test.

Remote DBA for Oracle databases size 10TB of data users and running Veritas/. Involved in migration, reorganizing, performing day to day DBA tasks and debugging problems on database.

Installed and configured different Oracle products including Oracle server, Enterprise manager (OEM)

Performing tuning of queries, applications and database including GB database using explain plan, views, SQL trace, events, tipoff, and stats pack.

Formulated Backup strategies and performed numerous Recovery operations

Performed backup and recovery using Recovery manager (RMAN)

Employer:- Telecom Software Corp Oracle DBA June 2004- - Jun 2006

Key Highlights:

Provided primary administrative support for Oracle7/8/8i databases in UNIX and NT environments.

Migrated SQL and SQR patches, refreshed development and test databases. Created domains, configured App Server, setup Process Scheduler, recompiled and relinked source code, setup 2-tier and 3-tier environments.

Participated in the design, analysis and implementation for a space shuttle engineering database system.

Installed upgraded and patched Oracle software and associated applications.

Managed and resolved design issues during development stage. Worked closely with developers.

Moved database Schema changes to stage or production.

Developed Oracle backup and recovery strategy and scripts.

Implemented database refresh using full export. Used EXPORT/IMPORT to do table level and full

Training

AWS Cloud Solution Architect advanced @ JPA Solutions Chennai

Azure Designing and implementing cloud data @ Udemy

Oracle 12C Workshop@ Rak Bank

Oracle Rac and Grid Infrastructure @ Udemy

SQL Server Cloud Architect ON AWS @Udemy

PMP Exam @ Cambridge Institute (Sharjah)

Lean Six Sigma @ Eibfs Dubai

Mongodb Administration @ rak bank dubai

Microsoft Sql Server 2014 admin@ site power

Contact this candidate