SUMMARY

• Over *+ years of IT industry experience in administering Oracle Database, experience in Cloud environments (AWS) and willingness to learn new technologies

• Oracle Certified Associate (OCA), Oracle Cloud Infrastructure Foundations 2021 - Associate Certified

• Experience in various Oracle consulting practices and procedures in database administration which includes installation, configuration, upgradation, cloning, migration and backup/recovery on different Operating Systems in various cycles of development, testing and production.

• Well versed with Oracle High Availability solutions like Data Guard and Real Application clusters

• Upgraded/Migrated Oracle Databases (10g/11g/12c/19c) based on the client requirements like size, cut over time, character set & endianness, by using different methods like Data Pump Conventional export/import, Data Pump Transportable Tablespace, Data Pump Full Transportable Tablespace, RMAN Transportable Tablespace with Data Pump, RMAN Cross-Platform Transportable PDB, Golden Gate replication

• Experience in upgrading databases from 11g/12c to 19c using DBUA, Manual and Auto Upgrade methods, handed over fully tested and operational DB to users

• Exporting and Importing database backups using Export & Import Data Pump utilities. Experience in Cloning production databases using RMAN.

• Configure physical & logical standby databases using Oracle Data Guard.

• Involved in User Management - creating roles, assigning privileges and roles to database users

• Involved in SQL tuning by generating explain plans, ADDM, AWR, ASH. Using TKPROF utility performed SQL tracing on session/user level and converting trace files to text files

• Monitoring and optimizing the performance of the database through Database Tuning

• Experience in Installation and Maintenance of RAC (using SRVCTL/CRSCTL) with ASM

• Managed and monitored multiple Oracle instances using Oracle Enterprise Manager (OEM)

• Worked on 12c/19c multitenant databases to lead the migration from conventional to multi-tenant

• Hands on experience on container and pluggable databases - handled cloning of non-multitenant container

databases to pluggable databases

• Good experience in solving performance related issues on production databases

• Health check and remediation of oracle Databases

• Configuring Oracle DataGuard (Physical – Standby)

• Performance debugging and monitoring - interpreting alert log and trace files

• Use of SQL diagnostic and tuning tools like AWR/ADDM reports

• Experience in managing the team, mentoring and resource allocation

• Involved in applying the CPU, PSU and RU patches in non-prod and prod environments

• Monitoring EXADATA db nodes, cell nodes and disks through 13c OEM, dbcli and cellcli

• Demonstrated proficiency in shell scripting languages to create and maintain scripts for system administration, troubleshooting, and performance optimization

• Performed refresh activities by Import/Export of schema, table and full database

• Working knowledge of RAC

• Handling space issues and performance issues

• Performed migration of the database on-prem to AWS RDS

• Experience on creating AWS new RDS instances and also from Snapshot backups

• Managing basic administration on MySQL DB

• Supported and worked on Priority 1 SR’s with Oracle Support during the Go-Live period. Provided off hours support, as needed, to support product enhancements, data uploads and technical issues

• Excellent analytical and communication skills combined with interpersonal skills and ability to work cohesively in a team. At ease in interacting with people at all levels, and able to work under pressure.

SUMMARY OF DB2 :

• Provide DBA support for various applications on AIX and Linux.

• Work on a data migration project from AIX to Linux system.

• Provide DBA support for all IMS tools including BMC and UBS products.

• Create tables/indexes and promote to various subsystems, including production using BMC change manager.

• Provide on-call coverage for a worldwide 7x24 online distribute OLTP application on an AIX platform.

• Involve in writing several UNIX shell scripts to monitor table space usage, buffer pool usage.

• Develop ETL routines using DB2 load, unload utilities, DB2 connect, (data warehousing) and imports/exports.

TECHNICAL SKILLS

Database: Oracle (10g, 11g, 12c, 19c), AWS RDS, MySQL, PostgreSQL, DB2

Operating Systems: Linux, Windows (NT/2000/2003/XP), Solaris, AIX, OEL

Languages: PL/SQL, Shell Scripting

Tools & Utilities: OEM, SQL*Loader, SSH, Export/Import & Data Pump (EXPDP, IMPDP), DBCA, DBUA, OUI, RMAN, SQL*PLUS, Data Guard, AWR, ADDM, Explain Plan, Real Application Clustering, Putty, SQL Developer, Cronjob (UNIX), Amazon Web Services (AWS), WinSCP, Filezilla, Golden Gate

Backup Tools: RMAN (Recovery Manager), OS Hot and Cold Backups

Cloud: AWS, OCI

Ticketing Tools: Service-Now, Jira, Remedy

PROFESSIONAL EXPERIENCE

Tata consultancy services – TEXAS INSTRUMENTS

Duration : May 2023 – Dec 2023 Team size. 12

Roles & Responsibilities:

• Managing and supporting Oracle databases

• Managing tablespaces, data files, redo logs, tables and its segments

• Managing data integrity also managing profiles, resources and password security

• Managing Users, Privileges and Roles

• Physical Database Backup and recovery (Hot and Cold Backups) and Logical Backup

• Database Links, Creating and Managing Tablespaces and Datafiles, Creating and Rebuilding Indexes, Managing Database Security

• Performance information and monitoring/interpreting alert log and trace files

• Use of SQL diagnostic and tuning tools like AWR/ADDM Reports

• Troubleshooting and maintenance of Oracle Database

• Performed refresh activities by Import/Export like schema, table, full database etc

• Setup of Standby database for faster disaster recovery and Data Guard setup. Load balancing, databases/schema/table reorganization for faster performance

• Participate in 24x7 on-call rotation for production databases and attend meetings on upcoming and ongoing projects

Environment: Oracle Database 10g, 11g, 12c, Oracle Enterprise Manager (OEM), RedHat Enterprise Linux, Database Upgrade Assistant (DBUA), Database Configuration Assistant (DBCA), Amazon Web Services (AWS), DataGuard, Oracle Universal Installer (OUI), WinSCP, Putty, RAC, RMAN, Data Pump, Export/Import.

Oracle Financial Services Software – ACCESS BANK

Duration : Sep 2022 – Apr 2023 Team Size 4

Roles & Responsibilities:

• Performed GRID and DB Installations, DB creations and upgrading the ASM and databases from lower version to Higher version

• Performed migrations of the database from lower version to higher version

• Managing and supporting Oracle databases

• Enforce best practices in all areas of database administration and architecture

• Creation and Maintenance of database storage structures such as Tablespace, Data files etc

• Monitored Tablespace, Data files usage and growth and created automated monitoring alerts

• Review and implement database changes

• Performing regular Oracle database maintenance like clearing Flashback, archive logs on various instances

• Worked on ASM for installation, configuring various Disk Groups and creating Oracle Database Instances

• Worked in Planning and implementing the Backup strategy using RMAN, Hot backup, Cold Backup, Logical backup

• Regular RMAN backup and recovery activities based on requests

• Experience in using tools SQL Developer & Toad

• Lead the team in upgrading the database from 11g/12c to 12c/18c with DBUA and manual upgrade methods

• Deploy and maintain High Availability & failover technologies such as Data Guard and Real Application Clusters to maximize database availability

• Experience in Performance tuning, Application tuning and Query Optimization using Oracle supported tools such as EXPLAIN PLAN, TKPROF, AUTOTRACE, etc

• Monitored and tuned long running jobs by working with the application and development team and analysing objects, creating or rebuilding indexes. Using SQL TRACE, Explain plan

• Generated AWR reports on Oracle 11g database and analysed the reports for Oracle wait events, time- consuming SQL queries, tablespace growth, and database growth

Environment: Oracle Database 10g, 11g, 12c, Oracle Enterprise Manager (OEM), RedHat Enterprise Linux, Database Upgrade Assistant (DBUA), Database Configuration Assistant (DBCA), DataGuard, Oracle Universal Installer (OUI), WinSCP, Putty, SSMS, SSCM, RAC, RMAN, Data Pump, ODA, Export/Import.

Oracle Financial Services Software – ECO BANK & BSP BANK

Duration : Feb 2022 – Sep 2022 Team Size 5

Roles & Responsibilities:

• Health check and remediation of oracle Databases

• Managing and supporting Oracle databases

• Managing table spaces, data files, redo logs, tables and its segments

• Managing data integrity also managing profiles, resources and password security

• Managing Users, Privileges and Roles

• Physical Database Backup and recovery (Hot and Cold Backups) and Logical Backup

• Database Links, Creating and Managing Tablespaces and Datafiles, Creating and Rebuilding Indexes, Managing Database Security

• Performance information and monitoring/interpreting alert log and trace files

• Use of SQL diagnostic and tuning tools like AWR/ADDM Reports

• Troubleshooting and maintenance of Oracle Database

• Performed refresh activities by Import/Export like schema, table, full database etc

• Setup of Standby database for faster disaster recovery and Data Guard setup. Load balancing, databases/schema/table re-organization for faster performance

• Participate in 24x7 on-call rotation for production databases and attend meetings on upcoming and ongoing projects

Environment: Oracle Database 10g, 11g, 12c, Oracle Enterprise Manager (OEM), RedHat Enterprise Linux, Database Upgrade Assistant (DBUA), Database Configuration Assistant (DBCA), DataGuard, Oracle Universal Installer (OUI), WinSCP, Putty, RAC, RMAN, Data Pump, Export/Import, OCI.

HCL Technologies – Shared Clients (UNILEVER, TOTAL ENERGIES)

Duration : Jan 2021 – Feb 2022 Team Size 9

Roles & Responsibilities:

• Exporting and Importing database backups using Export & Import and Data pump utilities. Experience in Cloning production databases using RMAN

• Involved in SQL tuning by generating explain plan, ADDM, AWR, ASH. Using TKPROF utility performed SQL tracing on session/user level and converting trace files to text files

• Monitoring and optimizing the performance of the database through Database Tuning

• Experience in upgrading databases from 11g/12c to 19c using DBUA, Manual and Auto Upgrade methods. Handover of fully tested and operational DB to users

• Experience in Installation and Maintenance of RAC (using SRVCTL/CRSCTL) with ASM

• As per the requirement and need installed various versions of Databases

• Setup and maintain all database backups for all production Oracle servers. This includes using native Rman backup

• Monitor all production Oracle Databases for disk usage to plan future disk space needs per database

• Successfully apply new patches/version upgrades

• Checking of Log files (Alert) and Trace files

• Applying Patches for Oracle11GR1, 10G Database. Database creation in Development, Test and Production for databases

• Modified the existing shell scripts to work as per current requirement of the application

• Peer Review of code before turning over to production

• Developed Pl/Sql program unit to test the business logic in testing environment

• Created indexes, constraints, triggers, synonyms in different schemas

• Loaded Data into Oracle Tables using SQL Loader

• Performed modifications on existing data objects as per change request and maintained it

• Maintaining Archive logs and their spaces for routine administration, alert and trace monitoring

• Participated in whenever there is a requirement of applying Patches using Opatch utility and upgradation is required on Prod or Pre-Prod Instances

• Cloned Databases from Production to Test, Dev instances to Test. Coordinate with teams from testing and Development if they have any issues

Environment: Oracle Database 10g, 11g, 12c, Oracle Enterprise Manager (OEM), RedHat Enterprise Linux, Database Upgrade Assistant (DBUA), Database Configuration Assistant (DBCA), Amazon Web Services (AWS), DataGuard, Oracle Universal Installer (OUI), WinSCP, Putty, RAC, RMAN, Data Pump, Export/Import.

HCL Technologies - BRIGHSTAR Duration : Mar 2019 – Dec 2020 Team Size 7

Roles & Responsibilities:

• Managing and supporting Oracle databases

• Managing table spaces, data files, redo logs, tables and its segments

• Managing data integrity also managing profiles, resources and password security

• Managing Users, Privileges and Roles

• Physical Database Backup and recovery (Hot and Cold Backups) and Logical Backup

• Database Links, Creating and Managing Tablespaces and Datafiles, Creating and Rebuilding Indexes, Managing Database Security

• Performance information and monitoring/interpreting alert log and trace files

• Use of SQL diagnostic and tuning tools like AWR/ADDM Reports

• Troubleshooting and maintenance of Oracle Database

• Performed refresh activities by Import/Export like schema, table, full database etc

• Setup of Standby database for faster disaster recovery and Data Guard setup. Load balancing, databases/schema/table re-organization for faster performance

• Participate in 24x7 on-call rotation for production databases and attend meetings on upcoming and ongoing projects

• Handling space issues and performance issues

• Performed migration of the database on-prem to AWS RDS

• Experience on creating AWS new RDS instances and also from Snapshot backups

• Managing basic administration on MySQL DB

Environment: Oracle Database 10g, 11g, 12c, Oracle Enterprise Manager (OEM), RedHat Enterprise Linux, Database Upgrade Assistant (DBUA), Database Configuration Assistant (DBCA), Amazon Web Services (AWS), DataGuard, WinSCP, Putty, RAC, RMAN, Data Pump, Export/Import.

HCL Technologies - NBCU (National Broadcasting channel Universal)

Duration : Feb 2017 – Mar 2019 Team Size 10

Roles & Responsibilities:

• Managing and supporting Oracle databases

• Managing table spaces, data files, redo logs, tables and its segments

• Managing data integrity also managing profiles, resources and password security

• Managing Users, Privileges and Roles

• Physical Database Backup and recovery (Hot and Cold Backups) and Logical Backup

• Database Links, Creating and Managing Tablespaces and Datafiles, Creating and Rebuilding Indexes, Managing Database Security

• Performance information and monitoring/interpreting alert log and trace files

• Use of SQL diagnostic and tuning tools like AWR/ADDM Reports

• Troubleshooting and maintenance of Oracle Database

• Performed refresh activities by Import/Export like schema, table, full database etc

• Setup of Standby database for faster disaster recovery and Data Guard setup. Load balancing, databases/schema/table re-organization for faster performance

• Participate in 24x7 on-call rotation for production databases and attend meetings on upcoming and ongoing projects

Environment: Oracle Database 10g, 11g, 12c, Oracle Enterprise Manager (OEM), RedHat Enterprise Linux, Database Upgrade Assistant (DBUA), Database Configuration Assistant (DBCA), DataGuard, WinSCP, Putty, RAC, RMAN, Data Pump, Export/Import.

PROFESSIONAL CERTIFICATION & TRAININGS

• Oracle Cloud Infrastructure Foundations 2021 - Associate Certified

• 1Z0-062 Oracle Database 12c: Administration

• 1Z0-061 Oracle Database 11g: SQL Fundamentals

• MongoDB training from MongoDB university

EDUCATION

Bachelor of Technology (B-TECH) in Computer Science & Engineering (2012 - 2016)

Sreyas Institute of Engineering and Technology, JNTUH University, India

Contact this candidate