Experience

• 

  Wipro infotech

  Sept 2011 - May 2015

  Oracle dba

  I joined WIPRO Infotech in 2011 (Position was Engineer trainee)I was selected through campus Interview.ORACLE DATABASE ADMINITRATOR (primary skill)SQL Server DBA (secondary skill) High Availability • RAC two node clusters on ORACLE LINUX.• Physical standby on WINDOWS.• ASM diskgrops for RAC setup.• Have knowledge about RAC ,ASM ,DATAGAURD architecture. Server and Network• Knowledge of the operating system ORACLE LINUX,REDHAT LINUX,WINDOWS.• Configured RAC by setting up“Private,public,VIPS”• Have basic idea about partitioning LUNS on LINUX.• Have basic idea about Firewall,NTP• Performance monitoring of server health and the necessary adjustments.• Boosts server performance by adding page files,karnel parameters.• Creates schedulers on server for automation. Backup and Recovery• Plan & implementation of backup and recovery of the Oracle database.• Excellent knowledge of Oracle backup and recovery scenarios.• RMAN backups and logical backups EXP,EXPDP,IMP,IMPDP. Cloning & ORACLE Upgrade & Patching• Performs database cloning.• Performs Database upgrade(Out of place upgrade)• Patching of ORACLE database Added responsibilities• Working as a “SQL SERVER DBA”• Installation of SQL server 2008,2008 r2.• Backup and recovery of SQL Server.• Setting up memories and attaching, detaching the databases. Cloning & ORACLE Upgrade & Patching• Performs database cloning.• Performs Database upgrade(Out of place upgrade)• Patching of ORACLE database Show less

• 

  Tata consultancy services

  Jun 2015 - Jun 2016

  Systems engineer

  Client : Tata Communication,Pune Key Role : CORE ORACLE DBA • Implemented RAC three-node clusters • Database Reorganizations to reduce fragmentation and improve performance.• Applied Quarterly Oracle CPU Patches and other bug fixing patches• Reviewed performance of critical databases on daily basis• Worked on basic Golden gate setup and Exadata • Database upgrade performed.• Worked on shell script automation for blocking session , top queries etc

• 

  Cognizant

  Jul 2016 - Dec 2016

  Technical lead

  Client : Telenet Belgium EuropeKey Role : CORE ORACLE DBA • logical backups EXPDP,IMPDP(Export and Import)• Managing environments, RMAN backups, refreshes, recoveries, and secure connectivity to peripheral systems• Plan & implementation of backup and recovery of the Oracle database• Managing availability, scalability, and usability (performance) through effective capacity and hardware management• Implement Oracle database environment according to the project requirement and Oracle service pattern offerings, including High Availability and Disaster Recovery options Show less

• 

  Vodafone

  Apr 2017 - Mar 2020

  Deputy manager

  Client : Vodafone UKKey Role : Performance tuning expert & DBA Visited : Newbury -UK• Monitored & supported and performed critical 24x7 duty on production databases (Database size upto 15TB)• Report analysis AWR , ASH , ADDM , SQLT report• Baseline ,SQL profiling ,Fixing query plan , SQL query tuning, query optimization• Troubleshooting complex performance issues• Migration on AWS RDS• Database upgrade from 11g , 12c to 18c /19 C • Performs Database version upgradation, Patching and cloning(RDBMS)• 11g ,12c, 18c ,19c Installation, Upgrade, Maintenance• Knowledge on DB Security DB Vault, Oracle Key Vault, Wallet, TDE . Show less

• 

  Nice ltd

  Mar 2020 - Feb 2022

  Tech lead cloud dba

  Role : Tech Lead Cloud DBA Engineer Leading a Team and have problem solving, and good communication skillsInteraction with Project Managers, Stakeholders Key Role : DBA , On-premises to Cloud migration,Hybrid DBA (ORACLE, MYSQL Aurora , MS SQL, PostgreSQL& AWS )Migrated 750+ databases from on-premises to AWS RDS CloudDesigned Cloud databases and worked on migration methodsMigrated DB flavors like ORACLE , MS SQL , MYSQL ,PostgreSQL databases to AWS RDSWorked on Databases migration service ,Export -Import & MYSQL dump , MS SQL backup method formigrating to CloudPerformance tuning when database migrated to cloud and necessary optimizationConfigure monitoring & monitor AWS RDS databases from CloudWatch , Performance insight toolContributed to reducing the cost on RDS like snapshot deletion ,instance class migration and multitenantmigrationManage MY SQL Aurora Cloud Native databases, RDS -ORACLE , MS SQLInstallation and Managing cluster -Reader and Writer NodeAmazon Web services and AWS Infrastructure setup knowledgeVirtualization, Networking and Storage knowledgeAWS Management Console and AWS Account hands onIAM , EC2 , EBS , VPC ,S3 -Have good knowledge and hands onDeploying AWS RDS databases ,Maintaining database snapshots ,performs point in time restoreBacktrack ,Snapshot administration performedCluster setup on MYSQL & PostgreSQLDevops- L1 SkillsKnowledge on GIT ,GITHUBKnowledge on Ansible , Terraform (Database deployments )Knowledge of software containerization platforms like Docker and container Show less

• 

  Oracle

  Feb 2022 - Jan 2023

  Principal advanced support engineer

  I was part of ORACLE ACS TeamPerformance tuning expertKey Role : DBAClient: Leading Bank in IndiaWorks on L3 performance issues, query tuning & optimizationAnalyze DB waits , AWR , ASH ,SQLT reportsTroubleshoot DB wait events ,works on SQL profile and plan fixWorks on PL-SQL development whenever required Performs database patching, upgradesRAC installationWorked on MIRA recovery ,recover from service on standby databasesworked on 19c latest features like Automatic indexing ,AutoupgardeDid grid and database upgarde from 12c to 19c by using autoupgardeProvides ORACLE database product support,pefroms bug fixesImplement the TDE on critical bank databasesWorks on RCA , manage communication with stackeholders Show less

• 

  Data axle

  Jan 2023 - Nov 2024

  Senior dba

  Key role : Cloud DBAHandling Cloud databases such as ORACLE , MYSQL Aurora ,PostgreSQL AuroraHandling complex performance issuesCost optimization ,Performance tunning on AWS RDSHandling ORACLE database 12c to 19c upgrades by Autoupgarde ,Grid upgrade and DB patchingFamiliarity with Cloud technologies such as RDS, DynamoDB, IAM, EC2, S3, AWS CLIExperience with DevOps - configuration management (Ansible), GIT, Infrastructure as Code (Terraform) &containers (Docker)Good in Unix shell scripting, SQL and PL-SQL ,Performs automation on DB levelExperience with database migrations for Operational Support Systems (OSS) database migrations andOracle to open-source databases.Works on OCI databases Show less

• 

  Bnp paribas

  Nov 2024 - now

  Assistant vice president -database