SUMMARY

• I have 9 plus years of experience as a Database Administrator in Oracle, MySQL, MariaDB, PostgreSQL on UNIX, LINUX,AIX,and Windows Platforms and Have experience for DB2 UDB Database administrator on UNIX, LINUX and Windows Platforms. I am Having good knowledge in Exadata,RAC,Dataguard,RMAN,ASM and performance tuning and implemented 4 Node RAC on Linux/AIX boxes. Having very good knowledge on E - Commerce oracle databases with application on IBM.
• Experienced in Database optimization and developing stored procedures, Triggers, Cursors, Joins, Views, Cursors and SQL on databases: MySQL/Mariadb and Oracle12c,18X,19X.
• Experienced in designing, modeling, developing and support web based projects with responsibilities including analysis, design, development, implementation and maintenance.
• Experienced inPerformance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using different Utilities.
• Huge experience in MySQL replication setup and configuration
• Expertise in snapshot, import/export, db optimization with the help ofexplain plan.
• Expertise in database migration fromMyISAM format to Innodb storageengine to increase performance and betterment of integrity constraints.
• Strong Skills with Oracle database administration in Production 24x7, Production and Development environment.
• Handling performance issues, tuning database, backup and recovery, configuring standby Database.Resolving and troubleshooting RAC and ASM issues. Implemented 4 Node RAC and ACTIVE-PASSIVE(one node) RAC on various OS platform(Linux/AIX).
• Monitored for Space and User Management in DB2. Having ving strong knowledge on RAC.
• Experienced inPerformance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using different Utilities
• Expertise in database migration fromMyISAM format to Innodb storageengine to increase performance and betterment of integrity constraints.
• Huge experience in MySQL replication setup and configuration.
• Monitoring standby databases and troubleshooting if the DB is not in sync with Primary. Migrated database from standalone to DATAGUIARD.
• Applied Patch on Exadata’s database and grid Homes as like BP,PSU patches..
• Worked with Oracle support team to plan and upgrade/Patch IB switches, Cell Nodes and storages.
• Working and configured Transparent Data Encryption on 12c database and converted non-TDE tablespaces to TDE tablespaces to make more secure on tablespaces.
• Manual Database refresh from production to other development environment and doing thought RMAN DUPLICATE method from prod to dev/test environment.
• Having good knowledge on performance tuning and good exposure to analyze the AWR,ASH,ADDM,SQL-T,TKPROF etc..
• Having good knowledge on SQL Plan baseline management like SQL profile,SQL baseline,SQLT etc..
• Having Good knowledge to troubleshoot performance issue using OSwacther,TFA tool analayzer on RAC/Standalone database.
• Having good exposure on exadata and cell storage and working with oracle support to apply bundle batch on storage cell, Infind Band switch and databases.
• Upgraded database from various lower level version to 11.2.0.4 and 12c and applying PSU patch based on every release from oracle.
• Database refresh from existing database backup and from Legato tape drives.
• Implemented Capacity planning on PROD and NONPROD databases.
• Backup and Recovery Management through tape and physical backup.
• User Management - Managing Profiles and Granting / Revoking privileges, locking / Unlocking the User Accounts.
• Job creation\scheduling\modification\migration using Autosys &TWS job scheduler
• Worked on migration from NON-ASM to ASM and have good knowledge in ASM.
• Migrated standalone to 2 NODE RAC database.
• Worked on Exadata servers and oracle support if any issue on Exadata servers.
• Having good knowledge on performance tuning .Providing fix for various level of performance from Database and application end. Involved query tuning(STS) and worked parameter level changes.
• Trouble shooting backup level issue RAMN and Involved restore activity(INCOMPLETE/COMPLETE) depends upon the scenarios.
• Refreshed database from Production to Development using RMAN backup,Hot backup method and Duplicate method.
• Involved in partition to create monthly and yearly on depends upon the application team requirement.
• Involved backup issue in Sql Server and various level of database activity in sql server.
• Schedule monitoring jobs and perform database maintenance activities such as reorg, runstats and reorgcheck
• Working on application level lock issue using DB2 snapshot.
• Performed restore and recover on various level issues and recovered dropped table using restore option in DB2.

TECHNICAL SKILLS

Oracle Database Administration: Oracle 7i, 8i, 9i, 10g,11g and 12c

DB2 DBA LUW: V8.5,8.7,9.1,9.3,9.5,9.7 and 10.1

SQL SERVER DBA: Sql server 2005,2008 and 2012

Microsoft Azure /AWS cloud: Monitoring database using colud and Sql server MS studio 2017 and having strong knowledge on AWS cloud.

Mysql/Mariadb: Mysql 5.5,5.6,5.7 and 8.0, Mariadb v10.2.X,10.5.X

Application Server: RMS,RPM and weblogic,E-commerce IBM

Hardware: IBM AIX server, Sun Solaris and LinuX Read hat,Hp-Ux,Windows

Networking Technologies: TCP/IP, OSPF, BGP, Cisco, Juniper, FTP, HTTP, DNSDHCP

PROFESSIONAL EXPERIENCE

Senior Oracle Database Administrator and AWS cloud architect

Confidential

Responsibilities:

• Upgrade Oracle database from 11.1.x, 12.2.0.X,12.1.0.X to 18.0.X.X,19.0.X.X
• Lead development team in designing/migrating AWS cloud based solutions
• Knowledge of agile software development practices and release management
• Work with distributed teams to design and develop frameworks, solution accelerators, proofs of concept, and external customer facing products
• Deep expertise in the AWS components & APIs o Expert working knowledge of Operating Systems (Windows and Linux). o Advanced knowledge of databases (SQL Server and MySQL) + Advanced knowledge of relevant web services, mail, backup, and application monitoring
• + Good knowledge of networking fundamentals + Good knowledge of server hardware + Good knowledge of application developments using Agile, and DevOps good practices
• J2EE frameworks (Spring etc) with focus on Data Mutation/ Transformations
• Design, both technically compliant and secure Cloud solutions, as well as value-based, on-demand services to facilitate the effective transition and migration of projects and programs into unique and adaptive cloud environment
• Evaluation/design/development/deployment of additional technologies and automation for managed services on AWS
• Investigate and debug issues in the Database and Services you create and work with QA & Data Analysts to ensure highest quality within the system
• Support the business development lifecycle (Business Development, Capture, Solution Architect next migration path, cost reporting and impartments
• Create and execute a strategy to build mindshare and broad use of AWS within a wide range of customers and partners
• Work with onboarding internal clients
• Solution design for client opportunities in one or more AWS Competencies or general cloud managed services
• Create a lift and shift process model clearly defining the individual steps of the lift and shift process.
• Support third party applications such as PhpPgAdmin to monitor and administer database operations for PostgreSQL
• Backup of PostgreSQL databases using pg dump and restoring from backup.
• Designing database structures, creating indexes, views and partitioning tables for better performance.
• Working on performance tuning based on user request.
• Performed Restore activity due to various level of issue.
• Configuring RMAN backup for new build database
• Worked on schema refresh using Export and import
• Performed for Database refresh using RMAN.
• Resolving performance issues in production and pre-production environment, tuning the queries, creation of indexes, real time monitoring on performance issues.
• Having good exposure on Exadata (X3-2 Quarter Rack) and worked with oracle support to apply Patch/upgrade Infind Band switches/Cell storage.
• Implemented data Gurad and having good knowledge on Physical and logical standby databases
• Worked on exadata setup and having required exposure on storage level and network level.
• Adding Disk to diskgroup and having good exposure on ASM.
• Working and configured Transparent Data Encryption on 12c database and converted non-TDE tablespaces to TDE tablespaces to make more secure on tablespaces
• Having good knowledge on Flashback,Garntee restore point,and FRA
• Build multiple standby database and converted snapshot standby for application testing purpose.
• Installation and implementation of oracle 11g and 12c database in various env.
• Managed HADR setup on DB2 database and perform switchover whenever required.
• Perform regular reorg check and gather stats on tables on DB2 database
• Perform log file rotation and management when log file become full.
• Worked with application team when DB was running slow using DB2 Snapshot/finding lock.

Senior Oracle/Mysql,Mariadb and postgres Database Administrator

Confidential

Responsibilities:

• Upgrade Oracle database from 11.1.x, 12.2.0.X,12.1.0.X to 18.0.X.X,19.0.X.X
• Having strong exposure on performance tuning on OLTP &E-Commerce database.
• Having strong experience to migrated database between data center and higher version.
• Helped setup MySQL replication (Master-slave and Master-Master)
• PostgreSQL and MariaDB installation, configuration, migration, upgrades and patches
• Planning, installation, configuration, management and troubleshooting of MySQL and PostgreSQL databases on Linux.
• Setup, troubleshoot and fix backups and restore data using tools such as mysqldump, Mydumper, MySQL enterprise backup and percona Xtrabackup.
• Support third party applications such as PhpPgAdmin to monitor and administer database operations for PostgreSQL
• Backup of PostgreSQL databases using pg dump and restoring from backup.
• Designing database structures, creating indexes, views and partitioning tables for better performance.
• Working on performance tuning based on user request.
• Performed Restore activity due to various level of issue.
• Configuring RMAN backup for new build database
• Worked on schema refresh using Export and import
• Performed for Database refresh using RMAN.
• Resolving performance issues in production and pre-production environment, tuning the queries, creation of indexes, real time monitoring on performance issues.
• Having good exposure on Exadata (X3-2 Quarter Rack) and worked with oracle support to apply Patch/upgrade Infind Band switches/Cell storage.
• Worked on block level corruption as like physical and logical block corruption.
• Worked on datafile movement between own diskgroup.
• Worked on materialized view issue and Creation and modification of primary database storage structures (table spaces) and primary objects ( tables,views, indexes).
• Implemented 4 node RAC and setup with multiple database .
• Implementation of MySQL stored procedures, triggers and views.
• Implemented data Gurad and having good knowledge on Physical and logical standby databases
• Worked on exadata setup and having required exposure on storage level and network level.
• Adding Disk to diskgroup and having good exposure on ASM.
• Working and configured Transparent Data Encryption on 12c database and converted non-TDE tablespaces to TDE tablespaces to make more secure on tablespaces
• Having good knowledge on Flashback,Garntee restore point,and FRA
• Build multiple standby database and converted snapshot standby for application testing purpose.
• Installation and implementation of oracle 11g and 12c database in various env.
• Managed HADR setup on DB2 database and perform switchover whenever required.
• Perform regular reorg check and gather stats on tables on DB2 database
• Perform log file rotation and management when log file become full.
• Worked with application team when DB was running slow using DB2 Snapshot/finding lock.
• Taking care of backup failure issue
• Handling replication issue between Oracle and sql server
• User creation and grant the required privileges
• Working on FS level issue and DISK level issue.
• Having good skill set on Microsoft Azure database and applied all the new features on Azure databases.
• Managing offshore and onsite team. Taking all the responsibly and leading team with high volume.

Senior Oracle/Exadata Database Administrator &DB2 DBA LUW

Confidential

Responsibilities:

• Upgrade Oracle database from 11.1.x to 12.2.0.X,18.0.X.X,19.0.X.X
• Having strong exposure on performance tuning on OLTP &E-Commerce database.
• Applying PSU and bundle patch on every 3 months.
• Working on performance tuning based on user request.
• Oracle database administration
• Performed Restore activity due to various level of issue.
• Configuring RMAN backup for new build database
• Worked on schema refresh using Export and import
• Performed for Database refresh using RMAN.
• Resolving performance issues in production and pre-production environment, tuning the queries, creation of indexes, real time monitoring on performance issues.
• Having good exposure on Exadata (X3-2 Quarter Rack) and worked with oracle support to apply Patch/upgrade Infind Band switches/Cell storage.
• Worked on block level corruption as like physical and logical block corruption.
• Worked on datafile movement between own diskgroup.
• Worked on materialized view issue and Creation and modification of primary database storage structures (table spaces) and primary objects ( tables,views, indexes).
• Implemented 4 node RAC and setup with multiple database
• Implemented data Gurad and having good knowledge on Physical and logical standby databases
• Worked on exadata setup and having required exposure on storage level and network level.
• Adding Disk to diskgroup and having good exposure on ASM.
• Working and configured Transparent Data Encryption on 12c database and converted non-TDE tablespaces to TDE tablespaces to make more secure on tablespaces
• Having good knowledge on Flashback,Garntee restore point,and FRA
• Build multiple standby database and converted snapshot standby for application testing purpose.
• Installation and implementation of oracle 11g and 12c database in various env.
• Managed HADR setup on DB2 database and perform switchover whenever required.
• Perform regular reorg check and gather stats on tables on DB2 database
• Perform log file rotation and management when log file become full.
• Worked with application team when DB was running slow using DB2 Snapshot/finding lock.
• Taking care of backup failure issue
• Handling replication issue between Oracle and sql server
• User creation and grant the required privileges
• Involved on Performance issue L1 and L2 level.
• Managing the growth of database by monitoring and space management.
• Creating database as per the client requirement and managing database files.
• Checking alert log files and to make necessary actions to rectify them.
• Restart the RMS,RPM and weblogic server based on user request
• Restart the workflow notification mailer based on user request
• Working on FS level issue and DISK level issue.
• Having good skill set on Microsoft Azure database and applied all the new features on Azure databases.
• Managing offshore and onsite team. Taking all the responsibly and leading team with high volume.

Senior Oracle Database Administrator

Confidential

Responsibilities:

• Upgrade Oracle database from 11.1.x to 11.2.0.4,12,1.0.2, 12.2.0.1
• Having strong exposure on performance tuning on OLTP &E-Commerce database.
• Applying PSU and bundle patch on every 3 months.
• Working on performance tuning based on user request.
• Oracle database administration
• Performed Restore activity due to various level of issue.
• Configuring RMAN backup for new build database
• Worked on schema refresh using Export and import
• Performed for Database refresh using RMAN.
• Resolving performance issues in production and pre-production environment, tuning the queries, creation of indexes, real time monitoring on performance issues.
• Worked on block level corruption as like physical and logical block corruption.
• Worked on datafile movement between own diskgroup.
• Worked on materialized view issue and Creation and modification of primary database storage structures (table spaces) and primary objects ( tables,views, indexes).
• Implemented 4 node RAC and setup with multiple database
• Implemented data Gurad and having good knowledge on Physical and logical standby databases
• Worked on exadata setup and having required exposure on storage level and network level.
• Adding Disk to diskgroup and having good exposure on ASM.
• Working and configured Transparent Data Encryption on 12c database and converted non-TDE tablespaces to TDE tablespaces to make more secure on tablespaces
• Having good knowledge on Flashback,Garntee restore point,and FRA
• Build multiple standby database and converted snapshot standby for application testing purpose.
• Installation and implementation of oracle 11g and 12c database in various env.
• Having strong experience to use SQLT,SQLHC,AWR and ADDM reports.
• Having good exposure on Large Securefile LOB objects and managing when growing high.

Senior Oracle Database Administrator

Confidential

Responsibilities:

• Handling Critical database issues which is escalated by L1/L2 DBA teams
• Handling Performance issue which is escalated with high criticality
• Specialist in implementation in RAC,Data Guard as standby databases,ASM using OEM DP provisioning.
• Having experience to apply patch on OMS/OEM databases in 12c/13c.
• Extensive experienced in Oracle Performance Tuning(Overall Database Performance from Core Level to Application Level).
• Worked on performance issues on Exadata and ODA machine database on various level.
• Worked on various level of clustering issue and high availability issues.
• Performed on various database restore/refresh based on user request using duplicate RMAN method.
• Working closely with architect team to optimize the database and make upto standard level.
• Worked on secure database using DBSAT tool and SOX scripts and make proper changes based on suggestion from report.
• Have strong experience on OEM 12c/13c to monitor database and setup alerts.
• Having Good experience on Golden Gate with bi-directional &uni-directional replication
• Having strong experience to use SQLT,SQLHC,AWR and ADDM reports.
• Having good exposure on Large Securefile LOB objects and managing when growing high.
• Having strong experience to upgrade and migrate database from lower to 12.1.X/12.2.X.
• Having experience to working on PDB/CDB databases on 12.1.X.
• Having strong experience to tune SGA issues as such like ORA-04301/ORA-00600 error.

Senior Oracle Database Administrator &DB2 DBA LUW

Confidential

Responsibilities:

• Troubleshooting and managing ASM and RAC issue in Production and non-production environment Oracle Database Migration from 9i/10g to 11g R2.
• Database capacity planning
• Resolving and troubleshooting RAC and ASM issues
• Worked on log file sync gap issue and build physical standby for migration activity.
• Tuning the shared pool, large Pool, Buffer pool, Redo Log Buffer
• Involved various level of performance tuning on database level and
• Testing of various types of time-bound incomplete recovery (point-in-time-recovery) and complete recovery
• Actively involved in monitoring the lock processes, releasing locks in case of resource blockage.
• Usage of Export and Import utility
• Creating monthly and yearly partition for production Databases
• Backup & Recovery strategy
• Upgraded database depends upon the requirement for standalone and RAC database and apply PSU Patch.
• Working on Table Re-Org on big table and Transport tablespace between different database
• User,tablespace,Schema creation and monitoring tablespace alert
• Troubleshooting and managing database connectivity issues (Listener service)
• Involved in Day to day DBA duties in production & Non- Production environment.
• Converting from Dictionary to locally managed tablespace for better performance.
• Maintenance of tables pace, File system space management and providing Root Cause Analysis for the issues.
• Additional responsibility
• Taken care of L1 level team under my lead.
• Attended daily CAB approval meeting to push CRQ changes in Prod.
• Team Management

Junior Oracle DBA and DB2 DBA LUW DBA

Confidential

Responsibilities:

• Database Performance Tuning by configuring DB & DBM parameters.
• Monitored for Space and User Management in DB2
• Schedule monitoring jobs and perform database maintenance activities such as reorg, runstats and reorgcheck
• Creating and Managing Tables, including Constraints.
• Working on application level lock issue using DB2 snapshot.
• Performed restore and recover on various level issues and recovered dropped table using restore option in DB2.
• Supporting Oracle database (9i,10g R2 and 11g R2).
• Oracle user creation and resolving space issue on tablespace level.
• Scheduled the backup job in crontab.
• Generating and analyzing AWR reports for DB performance analysis.
• Resolved various tickets pertaining database issues.
• User creation and taken care of tablespace level issue
• Managing backup report and taking action based on backup failure
• Performing export and import for schema /table level refresh based on customer request.