Rajeev Shastri

Rajeev Shastri

Database Engineer

Followers of Rajeev Shastri2000 followers
location of Rajeev Shastriدبي الإمارات العربية المتحدة

Connect with Rajeev Shastri to Send Message

Connect

Connect with Rajeev Shastri to Send Message

Connect
  • Timeline

  • About me

    CLOUD DBA,Senior Dba,Technical Architect,Golden Visa 🇦🇪

  • Education

    • Himachal Pradesh University

      1999 - 2001
      BSC(MATHS) Mathematics
    • Punjab Technical University

      2001 - 2004
      MCA RDBMS,NETWORKS,SYSTEM ADMINISTRATION

      الأنشطة والجمعيات:skit writing,drama quiz compitions

  • 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

  • Licenses & Certifications

    • Microsoft sql server 2014 administration

      Sitepower dubai
    • DAT247x: Managing SQL Server Operations

      Microsoft
      Jun 2018
      View certificate certificate
    • Aws public cloud advanced solution architect

      Jun 2016
    • PMP(certificate of attendance)

      CIMP(sharjah)
      Apr 2011
    • DO081x: Fundamentals of Containers, Kubernetes, and Red Hat OpenShift

      Red Hat
      May 2018
      View certificate certificate
    • ORACLE CERTIFIED ASSOCIATE(9I)

      ORACLE
      Jun 2006
    • Amazon Web Services Data Services

      LinkedIn
      Oct 2016
      View certificate certificate
    • MICROSOFT CERTIFIED SYSTEM ADMINISTRATOR

      MICROSOFT
      Jan 2004
    • Mongodb Administrator

      MongoDB
      Feb 2018
      View certificate certificate
    • Datastax Enterprise Foundations of Apache Cassandra

      DataStax
      Apr 2018
      View certificate certificate