Rajeev Shastri

Experience

• 

  Telecom software corp

  Jun 2004 - May 2006

  Database Engineer
• 

  Pugmarks

  Jul 2006 - Dec 2006

  ORACLE DBA

  • 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 handling 300 GB of data users and running Veritas/. Involved in migrating, reorganizing, performing day-to-day DBA tasks and debugging problems on database. • Installed and configured different Oracle products including Oracle server, Enterprise manager (OEM) • Performed tuning of queries, applications and database including GB databases using explain plan, views, sql_trace, events, tkprof, statspack.• Formulated Backup strategies and performed numerous Recovery operations • Performed backup and recovery using Recovery manager (RMAN) • Carried out both Physical and Logical database design and database reorganization عرض أقل

• 

  HFCL

  Dec 2006 - Nov 2007

  ORACLE DBA

  • Creating databases (Production/Clone/Test), creating users, assigning profiles depending upon the application requirement & monitoring their performance. • Creating Oracle database, tablespaces, 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 200 GB 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.• Using Oracle Utilities like Export, Import and SQL*Loader. عرض أقل

• 

  Gulf Computers, LLC

  Nov 2007 - May 2009

  Oracle Core Dba

  Job Responsibility Database Sizing, Tablespace Management,• Production Movements At Database And Application Level Approved By Quality Team authorized by visual source safe• Deciding on Data purging & Retention Policy..• Migrating the data from Test to the Production database using migration scripts in Oracle.• Participated in Disaster recovery testing.• 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.• Using operating system tools like vmstat, SAR, top, df ­k to check the performance on UNIX level.• Migration from windows oracle 10.1.0.0.0 to Linux Oracle 10.2.0.3.0• Critical patch update Oct 2007 for 20 Databases Given By Oracle Corp.. عرض أقل

• 

  SHARJAH ISLAMIC BANK

  Jul 2009 - Jun 2012

  Database Administrator

  Db2 version 9 installations, Application component and oracleDatabase approved by quality with the use of Industry best PracticesCarried out both Physical and Logical database design and database reorganizationImplemented High Availability and Load Balancing on Both Operating system and Database Level .Provided Standards Document for Database security, Patching,Operting system baselingImplemented Industry Best Practices for Databases Backup by using third party tool IBM-TIVOLI StorageEnvironment: Oracle versions 9i/10g , Oracle Enterprise manager, Toad for Oracle&db2,IBM-AIX-HACMP,Sql Server 2005,Websphere Cluster ,IBM-broker and Message queues,Oracle Rac عرض أقل

• 

  RAKBANK

  May 2012 - Jul 2018

  Senior Database Administrator

  Installing and upgrading the RDBMS, NOSQL database and Managing DB on Cloud Allocation system storage and planning future storage requirement for the database systemModifying the database structure as per help desk ticketing policy Enrolling users and maintaining system securityEnsuring compliance with database vendor license agreementControlling and monitoring user access to the databaseMonitoring and optimizing the performance of databasePlanning for backup and recovery of database informationMaintaining archived dataDatabase high availability setup عرض أقل

• 

  Emirates NBD

  Aug 2018 - Nov 2019

  Infrastructure Support Specialist

  Database Operation , SQL Server,Sybase IQ,Nosql,Private Cloud Daas,SQL Server Always on, Distributed availability Group

• 

  Netzone technical solution

  Nov 2019 - Sept 2021

  Information Technology Consultant

  Information technology Consultant For Highly Profile Govt Entity ,Managing Oracle,SQL Server, Devops engineer and Azure Cloud .

• 

  Coforge

  Sept 2021 - Mar 2022

  Technical Architect

  Migration Team Member for Legacy Application from Oracle DB to Database Services Mongo, Oracle, Elasticsearch DB, Kafka, and Big Data Cloudera setup using Ansible

• 

  Ultimate HR Solutions

  Apr 2022 - Sept 2023

  Cloud Database Architect

  Data management platform on the G42 cloud for a high-profile public organization that uses a variety of services, such as ECS, RDS (MySQL), containers, map-reduce, data lakes, data governance,POSTGRESQL Datawarehouse and security services. Using cloud-based data migration solutions, such as cloud data migration and data recovery services, data movement from different sources accomplished.

• 

  Invest Bank P.S.C.

  Sept 2023 - now

  Senior Database Administrator

  Managing data requirement for bank