EXPERIENCE SUMMARY

● Having Experience in performing DBA activities among ORACLE RAC and ASM around 13+ years.

● Having experience in a 11G/12c/18c/19c database with pluggable and container database concepts.

● Having Experience in MS SQL Server Log Shipping, Database Mirroring, Always-ON, Clustering configuration around 4+ years

● Having Experience in MySQL Database Administration and install software (PHPMyAdmin) around 3+ years

● Having Experience on PostgreSQL Enterprise Database Administration (PGAdmin) around 2+ years

● Ample Experience in RAC setup, performance tuning and backup administration & DB administration.

● Ability in Creation of oracle DB users, oracle roles and profiles, granting privileges etc.

● Maintaining physical and logical backups via User Managed& RMAN Backups and Recoveries.

● Installation and configuration of Oracle 11g,12c & 19C on Linux/OEL, Sun Solaris, Hp-Ux & windows.

● Using utilities exp, imp, expdp/impdp, RMAN, sqldev, logminer, dbv & Oracle Grid Control OEM.

● Monitor DB space utilization and foretell about upcoming growth using Enterprise Manager.

● Expertise working on medium & large projects encompass noble conduct in prof/personal.

● Knowledge in UNIX installation and configuration, Shell scripting, commands and automation.

● Experience in Installation of oracle DB server/client software, Database Creation, Upgrade & Migration.

● Database Cloning, Data Guard, RAC with ASM, Install em-agents, OEM Grid, Streams & Golden Gate Software.

● Experience in BCV Concepts Production (primary) To Mirror (secondary) instead of logical/physical Standby DB’s.

● Closely monitor the critical Prod databases using OEM Performance graph, DB alert logs, and Oracle Cluster logs.

● Monitor CPU usage, Memory usage, DB size usage, Archive destinations, Oracle Base destinations usage.

● Check Server level wait I/O, load avg, tps, redo sync data file sync & all related to performance tuning & stuff.

● Skills in Third party backup tools using GUI VERITAS Netback up, Hp data protector, Networker and Tivoli.

● Having Involvement in Oracle Apps DBA (EBS suite Applications) about 4+ years of knowledge.

· Node to single node, Space Management, Database security, Performance Management, troubleshooting, Database Migrations

· Tool like PPAS , EPAS, EDB BART , PEM (PostgreSQL Enterprise Manager), EFM , EDB SQL PROFILER.

· Using Enterprise dB Migration Tool Kit (MTK) and EDB Replication server for migration from oracle to PostgreSQL

· MySQL Replication for High Availability, MySQL Asynchronous/Semi-synchronous replication.

· MySQL 5,8 Administration, MySQL Workbench, MySQL Enterprise Monitor, SQL logs

· MySQL NDB Cluster Installation, Administration, Percona XtraDB cluster implementation with Proxysql load balancer

· Partaking trained for IBM DB2, Microsoft SQL SERVER, MYSQL and Postgress SQL Administration Activities.

· Knowledge in Oracle Cloud computing concepts, Exadata, Oracle Virtualization, big data, Greenplum & MongoDB etc.

· Hands on experience in 12c database, OEM Grid, 12C Express & Golden Gate technologies.

· Having experience working overseas like Singapore (UBS, GLOBALFOUNDRIES), Kuala Lumpur and Indonesia.

· Installation of 12c database and 12C centralized Grid/Agents for new and existing databases without Downtime.

· Have been given corporate training for Oracle DBA, ASM, RAC, Data guard & Oracle 12C DB and OEM.

· Experience in Oracle Real Application Testing using Capture /Replay & simulating load and oracle sql tuning Analyser.

· Oracle Cloud Infrastructure 2018 Certified Architect Associate & Microsoft Certified: Azure Administrator Associate

· Working experience with API interfaces (JMS Adapter, ActiveMQ, JBOSS, WebSphere, SOAP, SFTP)

·

Operating Systems

DOS, Windows 2003/NT/2007/XP, UNIX-Sun Solaris, Hp-Ux, RedHat LINUX, OEL, IBM AIX/MAC OS 13+

LANGUAGE

SQL, PL/Sql,C-shell and KShell 10+

DATABASE(S)

Oracle DB 19c/18c/12C/11g/10g, MS SQL Server 2008/2012/2014/2019, PostgresSQL9.4, MySQL, DB2, EBS Suite 11i/12i etc 13+

Oracle Enterprise Manager, RMAN,

Tkprof, Sqlplus, Sql Developer, Statspack, Logminer, AWR, ADDM, ASMCMD, DBverify, putty, SQL*loader, PL sql Developer, OSWatcher, RDA, I-TAR, OEM GRID CONTROL CENTRALIZED, Toad, wrc , SQL Management Studio for SQL Server (EMS Database Management Solutions),Pg Admin,PHPmyAdmin-13+

MM & SYS Monitors

Hp data protector, VERITAS net backup, SecureCRT, Win Scp, X-Manager, Network Performance Monitor, Hp Open View, Web Orion Console, Storage Web Console.ControlM, ignite tool and Zinoss, Help Now ticking tool-13+

● All Critical Production RAC/ASM databases are being supported 24*7 by Our DBA Team.

● I have been recovered 32TB database with less down time which was crashed due to datafile resize and locking/concurrency

● Have brought back firmness of 16 node oracle cluster ware with munificent. Network side activity caused issue.

● Recovered 2 TB ASM disk group which was corrupted DISK GROUP Header due to ASM operations.

● We have resolved block corruption online on the production database in VMware project.

Sep 2021 – Till Date

UBS Group AG

DATABASE AND NETWORK PROFESSIONAL

Project #1

Project Titles: IB & WM group Operations

Version: 9i, 10g&11g, 12c & 19C dB’s & all Linux OS’s & OEL.

Versions: MS SQL Server 2008/2012/2014/2019, Postgres DB

Client: UBS

Role: DATABASE AND NETWORK PROFESSIONAL NEC

PROJECTS & WORK EXPERIENCE

● Working in L3 Support as Sr. Oracle Database Admin & Supporting Exadata (DBaaS) and golden gate technologies

● Closing Working on DC migration and responsible for Oracle Databases for DC exit projects

● Taking care of BCM test (DR) across the APAC regional and primary resource for oracle database activities

● Planning & executing the DC migrations for Oracle, MS SQL, MYSQL and Postgres databases

● Working in L3 Support as Sr. Oracle Database Admin & Supporting Exadata (DBaaS) and golden gate technologies

● Closing Working on DC migration and responsible for Oracle Databases for DC exit projects

● Taking care of BCM test (DR) across the APAC regional and primary resource for oracle database activities

● Organize Data centre

Feb 2021 – Sep 2021

Oracle Corporation Singapore Pte Ltd

Principal Consultant

Project #2

Project Titles: OCC migration

Version: 10g,11g&12c/19c dB’s & all Linux OS’s & OEL.

Client: Singtel

Role: Cloud Administrator (Principal Consultant)

Working for OCC migrations at SingTel customers site

Upgrading & Migration Oracle database 11g/12C from Exadata to ExaCC 19c (cloud at customer)

PROJECTS & WORK EXPERIENC

July 2015 – Feb 2021

UBS Group AG

Sr. Oracle DBA

Project #3

Project Titles: IB & WM group Operations

Version: 9i, 10g&11g, 12c dB’s & all Linux OS’s & OEL.

Versions: MS SQL Server 2008/2012/2014/2019

Client: UBS

Role: Sr.DBA

● Working in L3 Support as Sr. Oracle Database Admin & Supporting Exadata (DBaaS) and golden gate technologies

● Closing Working on DC migration and responsible for Oracle Databases for DC exit projects

● Taking care of BCM test (DR) across the APAC regional and primary resource for oracle database activities

● Planning & executing the DC migrations for Oracle, MS SQL, MYSQL and Postgres databases

● Execution support for all MS SQL Server/My SQL/Postgres DBA related activities for Dc exit project

Feb 2015 – July 2015

GLOBALFOUNDRIES Singapore

Sr. Oracle DBA

Project #4

Project Titles: Next Global Foundries

Version: 9i, 10g&11g, 12c dB’s & all Linux OS’s & OEL.

Client: GlobalFoundries Singapore

Role: Sr. Oracle DBA

Worked as DBA at client place for Global Foundries in Singapore - woodlands industrial area

● Migrating all production databases from OEL 5.5 to RHEL 6.6 with extra hardware resources.

● Involved into end -to -end migration activities including EBS ERPDB and DB2 and MSSQL databases as well.

Feb 2013 - Jan 2015

HCL Info systems (HCL)-India

Associate Oracle Consultant

Project #5

Project Titles: VMware Software India Pvt. Ltd

Version: 9i, 10g&11g, 12c dB’s & all Linux OS’s & OEL.

Company: HCL CommNet Info systems. (HCLISD)

Client: VMware Software India Pvt. Ltd

Role: Associate Consultant

● We are working in 24/7 Support as per SLA from HCL, we have to take care of S3 & S4 requests for productions & project related requests and Apps DBA related S1, S2 and S3 requests thru Helpzilla ticketing tool & Help Now.

● We are Responsible for all requests (S1/S2/S3/S4) from all lower environments (Dev, Test, Stage, Uat, Fut & LT databases) and we have been working under project stream, so we use to take care of all project related stuff like Install & configure of database server / Client, Data Guard setup, Rman Catalog configuration, rman backup Scheduling and scripting, RAC install and manages the cluster ware and ASM config and manages asm instances and all refresh activities. We are working on one cloud and RAC virtualization for all core oracle databases parallely.

● We have installed a 12c OEM grid and configured & installed all target production and development agents by using GUI, Silent mode and thru 12c oem grid.

● Whenever performance issues on lower environments we use to work on those issues based on severities.

(Indonesia)

May 2008 - Sep 2012

TECHMAHINDRA LIMITED-Indonesia- Jakarta

Sr. Database Administrator

Project #6

Project Title: BMSA (HCPT-APAC).

Version: 9i, 10g&11g, ERP (Oracle Apps), Sun, Hp-ux, IBM-AIX&Linux (OEL).

Company: PT. TECHMAHINDRA INDONESIA.

Client: Hutchison Telecom Indonesia (3 mobile).

Role: Lead Oracle DBA

● On-Site DBA Support to Hutchison CP Telecom, Jakarta-Indonesia.

● Involved ANGIE Project new integration to the existing setup

● 11.2.0.3 dB software installation/client installations in OEL & HP–Ux boxes

● Database creation and moving data from SIT/UAT to production.

● Integrated with Applications servers till end to end configurations.

● Involved for cross-platform migration from sun OS to HP-UX Using-Golden Gate project

● a) CLARITY DATABASE which is 6 TB b) SIEBEL DATABASE which is 8TB

● Above databases are 24/7 production dB’s and will have BCV copy which is D-1 data

● So, from BCV copy have taken SCN-NUMBERS then using RMAN CONVERT option data has been copied in to NFS by then restore data to target database. Corresponding source DB started GG extractions and, in the target, DB started Replications finally cutover from source DB to target DB with 0 downtime done successfully.

● Install 11G R2 grid home, cluster ware, database for 5 node RAC in HP-UX boxes & for single node also installed

● Installed 16 node application cluster set up for single-view application and done like add node, delete node for existing cluster nodes

● PSU, CSU patches has been applied for various oracle versions in various operation systems

● ASM installations, configurations, troubleshooting done for 10G & 11G versions & adequate experience in storage

● ERP APPS cloning done for every 3 months once from production to dev., sit & uat environments

● Presently looking for new chucks & challenges in the infra-structure domain.

Project #7

Project Title : BMSA (HCPT-APAC).

Version : 9i, 10g&11g, ERP (Oracle Apps), Sun, Hp-ux, IBM-AIX&Linux (OEL).

Company : PT. TECHMAHINDRA INDONESIA.

Client : Hutchison Telecom Indonesia (3 mobile).

Role: Sr. Oracle DBA

Environments : Oracle (11g/10g/9i) on Solaris 10/9/8, HP-UX 11.5, Linux (all)

Database Size: About from 5GB to 36 TB

No of Databases: 40 Production databases & 100 Dev, Test&UAT Databases.

Applications : Single-View Billing, Infinity, Siebel CRM, Tibco, FMS, ICM, ERP, IVR, etc.

DBA Team Size: 6

On-Site DBA Support to Hutchison CP Telecom, Jakarta, As CORE DBA of the HCPT Indonesia Project, I am responsible for maintaining production databases perform UAT, SIT and Development for all databases and 24*7 production databases support and involving in the entire activities of Database Administration such as

● Performance monitoring and tuning of highly critical databases with biggest size of 36 TB on Solaris, Hp-ux platform and Oracle Enterprise Linux.

● Apply patches, up gradations, migrations, DB cloning & creating DB’s for Oracle databases.

● Planning and maintenance of Backup/restore & recover through RMAN with third party tools like HP Data Protector and VERITAS net backup

● Resolving Service Requests (SR) / Trouble Tickets (TT) within the SLA hours internal as well as external.

● Implementation of Binary Copy Volume (BCV) for both reporting and backup purposes

● Maintaining Oracle RAC, HP Service Guard and Sun Cluster databases & Cross platform migrations from Sun Server to HP E25K Servers.

● Migration of production databases with minimum downtime using standby/data guard and Golden Gate database concept.

● Efficient in TKPROF, Stats pack, AWR, ADDM and utilities like SQL *Loader and Export/import and data pump with Network file system (NFS).

● Maintenance of oracle Data guard databases/standby databases/bcv databases.

● Interaction with application, development, testing, UAT, Network Team and SA Team to resolve production issues.

● Working in Shifts around the clock 24 * 7 supports production database environments.

● Giving on Call support, off-shore support & on-shore support if required.

● Working in a team of 8 members, indeed I am working as DBA Team Lead.

● I have performed Oracle Apps DBA activities for ERP applications.

Project Description:

● In Indonesia 3 mobile is one of big competitors in the race of telecom operators. HCPT is our client to be given E2E support by PT. Techmahindra Company. We have 40 production Databases to be maintained 24*7 L1, L2&L3 support from DBA Team prospective. Roles and Responsibilities: To be closely monitoring Critical databases (24/7) online support like Daily reports, alerts, logs, OCR, Node apps, Voting Disks, LISTENER status, TNS entries, GSD, VIP, CRS, Cluster, data files, Table spaces, Apps, ARCHIVE Mount points, database links etc. To be maintained by using VERITAS volume manager, hp data protector. If we observed any abnormal things not able to handle, then we should escalate to concern vendors. Plan incident reports, user management only one-hour SLA like Db. user creation, password reset, profiles & roles assigned by DBA. Application side some process being fired through dB level should have to check that queries accordingly tune the high cost-based queries, closely monitor Real time system and if we found any locking/blocking between to app queries will be killed after confirmation from related stakeholders.KPI reports for client. Weekly meeting with clients & taking their requirements accordingly respond. Checking backups through third party tool VERITAS volume Manager, Data protector, Schedule the jobs of backups, monitoring backups, start/Stop Backups, Taking Archiving backups, checking backups to be restored in Dev environment. Clone databases from one database to another for developing purpose. Concerning tuning, analyse space issue, adding datafiles, Any Action plans on production will have a planned work for downtime. ERP Application stop All, Start All, Purging Dashboard monitor, Concurrent managers monitoring, Maintain Oracle Apps Services, HTTP, FINLIB & web services.BCV SYNC&SPLIT: FOR ALL PRODUCTION DATABASES Vs. ALL BCV DATABASES->Start Synching with production, unmount archive/disk groups mount points, Complete synching with production Ended pairing with production, start split from production, Mount archive/disk groups mount points, Start-up BCV Database with Read only mode.

WORKSHOPS/TRAINING PROGRAMS ATTENDED

● Oracle 10g DBA: Conducted by Wilshire Technologies, Duration: four weeks, Nov 2007

● Basic telecom training program, Tec Mahindra limited Pune, Duration: 30days, May 2008.

● DBA OCA, Data Guard and RAC Training classes from Oracle Corporation.

● Be present at Oracle Seminars some of like Oracle Cloud Computing, Oracle Exa-data Database Machine.

● Oracle Virtualization, Oracle Enterprise Manager Ops Centre, Big data & some of VMware seminars.

ACADEMICS

● Post-Graduation in Master of Computer Applications (MCA)from Osmania University-HYD-IND-2007

● Graduation in Bachelor of Science in MPCS (BSC) from Sri Venkateswara University-TPT-IND-2004

PROFESSIONAL CERTIFICATIONS

● ORACLE 10G Certified Database Administration-I&II professional (OCA/OCP 10g DBA).

● Certificate Courses of Diploma in RDBMS/Oracle 10G DBA.

● ITIL Foundation Certified.

● Oracle Certified: Oracle Cloud Infrastructure 2018 Certified Architect Associate

● Microsoft Certified: Azure Administrator Associate

PERSONAL DETAILS

Date of Birth : 01-JUN-1982.

Sex : Male.

Nationality : Indian.

Marital Status : Married.

Passport Details : Z2893094 (Validity up to: 06-05-2024)

Visa status : NRIC/EP-G3126730M (Singapore)

Present Address : #1596/03-165-Hougang Ave1-Singapore-530165.

Mobile : +65 90628025

Email : mohan.reddy02@gmail.com | reddy_mohany@yahoo.com mohan.reddy02@hotmail.com |

References & more Project details can be produced on request basis.

COVER LETTER

I would like to apply for the Post of Database Administrator/Cloud DBA

I have been working as DBA for UBS AG client –Singapore

On Behalf of Hays specialist recruitment pte ltd , Having total 12+ years of experience

On Oracle 12C,11G,10G & 9i DB Server & ERP Apps DBA & MS SQL Server (DBA) & DB2 DBA & My SQL DBA.

On OS (Solaris, HP-Ux, all Linux, AIX & all windows etc. as SYS-ADMIN (SA).

I am adhering to handling storage (SAN/NFS/ASM/CFS)-Storage Admin.

Hands on VERITAS, Hp-data protector and Networker and all 3^rd party media managers for backups as Backup Admin.

ORACLE-Utilities/Tools: TOAD, PL/SQL Developer, OEM Grid, lsnrctl, tnsping, netca dbca, dbua, exp/imp, datapump, rman, dbv, asmcmd, dgmgrl, sql loader*, adrci, cluvfy, emctl, oerr, onsctl, oraenv, orapwd, srvctl, sysresv, tkprof, unzip, Zip and etc.

ENV Tools/utilities: yum, xvinfo, whoami, who, which, wc, wall, vmstat, vim, vi, sftp, scp, sar, reboot, ps, ntpstat, nslookup, minfo, Mail, find, env, crontab and HP DP, Veritas Backup Tools, storage web console, HPOV & Orin , SQL Management Studio for SQL Server (EMS Database Management Solutions), dbForge Studio for MySQL,MySQL Workbench,phpMyAdmin,HeidiSQL,Toad Edge for MySQL,SQLyog,Navicat for MySQL,Aqua Data Studio,Valentina Studio,SequelPro,pgAdmin,DBeaver,Navicat,DataGrip,OmniDB

My resume is attached for your review.

I am confident that my experience and Qualifications are meets your requirements.

I look forward to Hearing from you to discuss this opportunity in more Detail.

Skills: SQL, PL/SQL, Shell Scripting, Oracle/Apps Administration, MS SQL DBA, MYSQL DBA, Postgres DBA, System Administration, Backup Administration & comprehension in Network Administration and storage Administration.

Knowledge in all Cloud administrations like Oracle Cloud, Azure, AWS, Google cloud and GoDaddy Cloud

Convenient time to take the interview: Any time to my mobile: +65 90628025