SUMMARY:

• 8 years of experience as an Oracle DBA (19c,12c,11g,10g,9i ) in Production, Development and Test environments.
• Expertize in Oracle 19c, 12c, 11g, 10g, 9i administration, performance tuning, upgrades on Solaris, HP - UX, AIX, Redhat Enterprise Linux, Windows .
• Secondary Skills: MSSQL,MySQL,Postgresql,AWS,Exatada,GlodenGate
• Patch teh Oracle databases to teh latest Quarterly PSU’s to adhere to teh Deutsche bank security standards.
• Patch teh RDBMS as well as GRID on RAC, Non-RAC and DB standard environments.
• Expertized in Patching teh databases using manual method.
• Good experience in Oracle Database Design, Installation, configuration and Administration, Backup and Recovery of databases.
• Extensive experience in Recovery Manager (RMAN) and Export/Import/DataPumps backups.
• Recovery of entire Database, Data files, Tablespaces using RMAN and User managed recovery.
• Automated many common tasks using crontab including Backups, exports and imports, housekeeping old records.
• Schema / Table level and query based normal Export & Import and also Data Pump Export & Import utility.
• Scheduling and maintaining level 0 and level 1 RMAN (Recovery Manager) backups to teh FRA.
• Skilled in developing RMAN scripts for database back up including hot and cold backup options for both RAC and standalone instances.
• Migrating database between datacenters. Creating DataGuards in different datacenters as and when requested by teh clients or application teams.
• Worked as primary DBA for Switchover and switchback activities all over Comcast project.
• Configuration of Oracle Data Guard and Physical Standby using RMAN backup.
• Rebuild standby if their is a large gap in DataGuard.
• Setting up production databases for Go-Live. Testing wif Switch-Over/Switch-Back before go-live.
• Setup, configuration and maintenance of standby databases (Oracle Data Guard) to ensure disaster recovery, high availability and data protection.
• Automate switchover wif dataguard broker.
• ImplementingOracle TDE Transparent Data Encryptionin all of our new/existing databases for Tablespace encryption.
• Used OraclesTransparent Data EncryptionandOracle Walletto encrypt some of teh data in teh database.
• Strong experience in providing 24/7 support for corporate databases, timely resolution of tickets, and on-call rotation.
• Responsible for administration and supporting Oracle 12c,11g and 10g databases in DEV, QA, UAT and Prod environments.
• Supported production database servers and applications that provided secure mission and critical services.
• Worked on Change management Requests (CMR), Incident Management Requests (IMR).
• Handling Customer Query, Work on change requests, Weekly Maintenance Activity, troubleshoot common SQL codes, Error Messages and Database issues.
• Adhering to SLAs Reporting, Handling tickets/requests, Troubleshooting technical issues.
• Ability to grasp new technologies quickly and adapt to teh same.
• Good communication skills to handle end-users effectively and an excellent team player.
• Managing Security, User groups and Users by using roles, grants, privileges and Profiles.
• Assisting teh ETL team to improve performance by analyzing SQL statements, reorganizing database objects and design indexes to improve response of queries.
• Used Explain Plan to monitor teh query execution and views to make sure teh operations run wifout any issues.
• Troubleshooting Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).
• Performing Database Administration activities like space management, user and roles administration, schema management, checking alert log of all teh databases.
• Used OEM to monitor Blackout Servers in case of any maintenance activity. Database health, Bottlenecks, session information, table privileges, user roles and grants.
• Designed and Implemented database security using Oracle roles and privileges. Set up teh password for new users and then managed users and their respective sessions.
• Expertize in Performance tuning of oracle databases using AWR, ADDM, STATSPACK.
• Monitoring teh databases locks and blocking sessions using OEM or SQL Scripts.
• Standardizing controlfiles, logfiles according to teh project standard.
• Monitoring Growth of tables and undertaking necessary re-organization of tables and indexes as and when required.
• Capacity planning of teh databases.
• Creation of databases, tablespaces, Schemas on request.
• Maintain DB admin owner login, Schema owner login and users supports.
• Created different users and assigning default tablespace, temporary table spaces, privileges, profiles.
• Creation/Altering of profiles, roles and granting privileges.
• Resolved database network problems using Oracle Net Configuration Assistant (NETCA) and also manually.

TECHNICAL SKILLS

RDBMS: Oracle 9i,10g,11g,12c,19c, RAC, ASM, MS SQL Server 2005,2008 and 2012 R2

Replication Tools: Oracle DG, Glodengate

Database Utilities: OEM, Statspack, AWR, ADDM

Application Server: Oracle Application Server

Backup Software: VERITAS Net backup, Data Domain

Tools - Toad, SQL: developer, BMC Patrol, Service Now, SQL Server Management Studio

Scripting Languages: PL/SQL, Shell Scripting, Unix

GUI: OEM12c, Oracle Support Links

Cloud: Oracle Enterprise Manager Cloud Control 12c

O/S: Windows, Solaris, Linux, AIX

PROFESSIONAL EXPERIENCE:

Confidential, NYC, NY

Database Consultant

Environment: RHEL Oracle 12c and 19c, OEM 13c,RMAN, RAC, DATAGUARD, EXPDP/IMPDP, ASM, AWR, ADDM, ASH,TDE Encryption, Oracle Key Vault (OKV), Crontab.

Responsibilities:

• My role in SMBC mainly was to upgrade a database which was running in 11g into 19c Multitenant environment.
• Teh database has to be created throughout DEV,QA,REL and PROD environments.
• Also worked to support all other databases in teh bank.
• Worked on Database, Schema refreshes from prod to lower environments.
• Worked on cloning pluggable databases. Plugging/unplugging PDB’s.
• Duplicates Prod database to lower environments if they want to restore teh database wif a point in time.
• User Management activities such as create accounts, password resets, unlocks.
• Change management activities on Production databases as per teh requirement.
• Worked wif RMAN backups, Catalog Database. Upgrading catalogs after PSU patching.
• Participated in Disaster recovery activities many times such as Unit Testing, Application level Testing which happens every 3 months or after any major changes for teh databases.
• Applying Quarterly PSU’s, Part of teh patching are automated. But certain databases patching are still manual. For eg: Multitenant databases.
• Worked on TDE Encryption. Encrypting databases either only application tablespaces or complete database level.
• Worked very closely wif Oracle support team if their are issues.
• Worked on Shell scripting, created multiple scripts for various purposes like refreshing databases, exporting databases or any other tasks to make works quicker.
• Setting up incremental RMAN backup scripts (Level 0, Level 1, archive log) . Knowledge working wif TWS jobs.
• Worked wif Cyberark.
• Worked wif DataGuards, Switchover, SwitchBack. Rebuild of standby databases if their are any issues.
• Deep Working noledge on SDLC policies and Enterprise level ticketing tools like Service Now.
• Worked on Performance tuning issues, like analyzing any locks/blocks, SQL plan changes, CPU, Memory or other resource utilization issues.

Confidential

Oracle DBA

Environment: RHEL, AIX, SOLARIS, Linux Oracle 10g/11g/12c,19c, RMAN, RAC, Standby, SQL, EXP/IMP, EXPDP/IMPDP, ASM, SQLLOADER, AWR, ADDM, Explain Plan, MS SQL Server 2005,2008 and 2012 R2

Responsibilities:

• Responsible for administrating and supporting Oracle databases running on all teh Linux, Real application clusters (RAC), ASM platforms, DataGuards.
• Worked extensively on Exadata machines.
• Installation, Patching, Upgradation, Cloning and migration of databases.
• Handling Customer Query, Work on change requests, Weekly Maintenance Activity, troubleshoot common SQL codes, Error Messages and Database issues.
• Setup teh backups and restore them when required from backup disks/tapes.
• Patch teh Oracle databases to teh latest Quarterly PSU’s to adhere to teh Deutsche bank security standards.
• RDBMS as well as GRID on RAC, Non-RAC, Data Guard in DB standard environments should be patched.
• Expertized in Patching teh databases both through Blade Logic and manual methods.
• Creation and re-organization of database, tablespaces, rollback segments.
• Performing activities such as adding, dropping and rebalancing disks as per teh requirement in ASM.
• Monitoring teh data growth and re-organize teh table structures in separate tablespaces and develops appropriate support structure like indexes and partitions.
• Resizing teh online redo logs in production and in standby database according to teh needs.
• Rebuild standby if their is a large gap in DataGuard.
• Setting up production databases for Go-Live. Testing wif Switch-Over/Switch-Back before go-live.
• Setup, configuration and maintenance of standby databases (Oracle Data Guard) to ensure disaster recovery, high availability and data protection.
• Automate switchover wif dataguard broker.
• Generating ADDM/AWR/ASH reports from databases and analyzes teh reports for Oracle wait events, time consuming SQL queries, tablespace growth and database growth.
• Involve in SQL Query tuning and provided tuning recommendations to ERP jobs, time/CPU consuming queries.
• Installing and setting up of Oracle RAC Grid Infrastructure. Implemented 2 Node RACs, 4 Node RACs and 8 Node RACs.
• Organizing Oracle Database operations, installation, creation, configuration, laying out database tables and database schema design, startup and shutdown of Databases.
• Assisting teh ETL team to improve performance by analyzing SQL statements, reorganizing database objects and design indexes to improve response of queries.
• Troubleshooting Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).
• Performing Database Administration activities like space management, user and roles administration, schema management, checking alert log of all teh databases.
• Setting up production databases for Go-Live. Testing wif Switch-Over/Switch-Back before go-live.
• Participated in many DR activities.
• Development and maintenance of packages and jobs to perform filtering operations and to import teh data on daily basis from teh Oracle DB to MS SQL server. Worked as MS SQL Server administrator.
• Monitoring Event viewer, MS SQL Error logs and Log File Viewer for Software and hardware related errors.
• Refreshing production data to lower environments for test purposes.
• Migration of Data from Excel, Flat file, Oracle to MS SQL Server by using SSIS, BCP utility.
• Installation of Mysql on Linux .
• Monitoring Mysql Backup.
• Installation of Postgressql 12 on Windows and Linux server.
• Participated in Exadata Patching Activities.
• Migration of Oracle Database from on Prem to AWS Coud .

Confidential

Oracle DBA

Environment: RHEL, AIX, SOLARIS, Linux Oracle 10g/11g/12c, RMAN, RAC, DATAGUARD Broker, Standby, SQL, EXP/IMP, EXPDP/IMPDP, Glodengate, ASM, SQLLOADER, AWR, ADDM, Explain Plan, Exadata.

Responsibilities:

• Expertise in pre-requisite verification, installation, upgrading, migrating and configuration of Oracle RDBMS 18c,12c and 11g in Linux, AIX and Solaris platform.
• Identifying and resolving numerous performance issues like top wait events, sub-optimal execution plans, outdated statistics, data fragmentation, latch contention, CPU constraints, physical & logical I/O, disk usage, query optimization, hard/soft parsing by application tuning, disk I/O and memory tuning.
• Maintenance of ASM instance, creating disk groups, configuration ACFS file system and checking disk header, ASM rules files before adding/creating disk groups to avoid storage issues.
• Uses flashback queries to restore database to SCN, TIME or SAVE Point.
• Installing and setting up of Oracle RAC Grid Infrastructure. Installation and setting up monitoring using OEM 12 cloud control.
• Every Quarter Oracle will release Patches for teh databases. These patches will be first applied and tested in teh UAT databases and later applied on all teh Production databases. dis has to be followed as per Israel Discount Bank audit requirement and policies, else teh databases will remain non-Compliant.
• Setting up incremental RMAN backup scripts (Level 0, Level 1, archive log) and optimally scheduled RMAN backups across databases to relieve load on TSM/NetBackup and Data Domain Servers.
• Generating ADDM/AWR/ASH reports from Oracle 11g/12c and 18c databases and analyzes teh reports for Oracle wait events, time consuming SQL queries, tablespace growth and database growth.
• Administration of MS SQL Server 2008, 2012,2014 and 2017 R2. Worked on refreshes and data migration between different servers.
• User Management on SQL Server.
• Setting up Log shipping, database mirroring.
• Monitoring Event viewer, MS SQL Error logs and Log File Viewer for Software and hardware related errors.
• Responsible for administrating and supporting Oracle databases running on all teh Linux, Real application clusters (RAC), ASM platforms, DataGuards.
• Worked extensively on Exadata machines.
• Installation, Patching, Upgradation, Cloning and migration of databases.
• Handling Customer Query, Work on change requests, Weekly Maintenance Activity, troubleshoot common SQL codes, Error Messages and Database issues.
• Setup teh backups and restore them when required from backup disks/tapes.
• Patch teh Oracle databases to teh latest Quarterly PSU’s to adhere to teh Deutsche bank security standards.
• RDBMS as well as GRID on RAC, Non-RAC, Data Guard in DB standard environments should be patched.
• Expertized in Patching teh databases both through Blade Logic and manual methods.
• Creation and re-organization of database, tablespaces, rollback segments.
• Performing activities such as adding, dropping and rebalancing disks as per teh requirement in ASM.
• Monitoring teh data growth and re-organize teh table structures in separate tablespaces and develops appropriate support structure like indexes and partitions.
• Resizing teh online redo logs in production and in standby database according to teh needs.
• Rebuild standby if their is a large gap in DataGuard.
• Setting up production databases for Go-Live. Testing wif Switch-Over/Switch-Back before go-live.
• Setup, configuration and maintenance of standby databases (Oracle Data Guard) to ensure disaster recovery, high availability and data protection.
• Automate switchover wif dataguard broker.
• Generating ADDM/AWR/ASH reports from databases and analyzes teh reports for Oracle wait events, time consuming SQL queries, tablespace growth and database growth.
• Involve in SQL Query tuning and provided tuning recommendations to ERP jobs, time/CPU consuming queries.
• Installing and setting up of Oracle RAC Grid Infrastructure. Implemented 2 Node RACs, 4 Node RACs and 8 Node RACs.
• Organizing Oracle Database operations, installation, creation, configuration, laying out database tables and database schema design, startup and shutdown of Databases.
• Assisting teh ETL team to improve performance by analyzing SQL statements, reorganizing database objects and design indexes to improve response of queries.
• Troubleshooting Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).
• Performing Database Administration activities like space management, user and roles administration, schema management, checking alert log of all teh databases.
• Setting up production databases for Go-Live. Testing wif Switch-Over/Switch-Back before go-live.
• Participated in many DR activities.

Confidential

Oracle DBA

Environment: RHEL, AIX, SOLARIS, Linux Oracle 10g/11g, RMAN, RAC, DATAGUARD Broker, Standby, SQL, EXP/IMP, EXPDP/IMPDP, ASM, SQLLOADER, AWR, ADDM, Explain Plan.

Responsibilities:

• Handling Customer Query, Work on change requests, Weekly Maintenance Activity, troubleshoot common SQL codes, Error Messages and Database issues.
• Responsible for administration and supporting Oracle 11g, 10g and 9i databases on different linux OS such as AIX, HP-UX, Solaris in DEV, QA, UAT and Prod environments.
• Installation and Setting up of Standalone databases,2 node 11g RAC in Linux environment and 11g ASM on RAC databases.
• Installation of Oracle 11g on standalone and RAC 3 nodes on HP UX, Linux, AIX and Solaris environments.
• Upgradation and migration of databases.
• Addition of new node to teh existing 2 node RAC.
• Applying PSU patches in a rolling upgrade manner in RAC environment.
• Gloden gate installation on linux environments.
• GlodenGate schema replication, online change synchronization, ddl synchronization.
• Replicate schemas using GlodenGate schema replication which includes online change synchronization and ddl synchronization.
• 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Configuration of Oracle 11g Data Guard. DG broker has been configured on all of them as per client requirement. Rebuild standby if their is a large gap in DataGuard.
• Setting up production databases for Go-Live. Testing wif Switch-Over/Switch-Back before go-live.