Suma

E-mail: adjnrc@r.postjobfree.com

Phone: 845-***-****

PROFESSIONAL SUMMARY

Around 7 years of IT experience in Oracle products on multiple platforms and environments

Experience in On-Call 24x7production DBA support, application/development DBA.

Extensive knowledge on database administration for Oracle 8i, 9i, 10g, 11g,12c and 19c with experience in very large scale database environments and mission critical large OLTP and OLAP systems.

Experience working in EXADATA X6 RAC environment

Migrated 11g databases to different server using goldengate with minimal Down time

Installed and upgraded oracle GOLDENGATE 11.2.1.0.x one-way and Bi-directional replication on Oracle database 11gr2

Configured oracle 11g,12c and 19c Goldengate classic and Integrated capture modes on Linux servers

Installed Oracle 10g,11g,12c and 19c databases on standalone and RAC servers

Upgraded databases from 11.2.0.2 to 11.2.0.4 and 12.1.0.1 on Linux boxes

Installed 11g 6 node production RAC Grid Infrastructure and DATABASE on Linux

Experienced in installation and maintenance of ORACLE 10g and 11gr2 RAC 2 & 4 node and adding/deleting a node to this cluster

Experience in a variety of hardware and software platforms including; MS-Windows, NT Server, UNIX/Linux, Sun Solaris, HP-UX & AIX and RHEL.

Hands on experience in Oracle 10g/11g RAC implementation & administration (Oracle Clusterware setup and configuration, RAC installation using ASM, Grid Installation)

Patched all non-prod and production RAC and standalone databases and configured Backup and Recovery

Refreshed and Cloned All non prod databases from Production using DELPHIX Engine

Installed MONGODB on Linux servers

Updating and generating oracle DDL's using SYBASE Power Designer 16.1tool

Data modelling experience including Reverse Engineering process

Migrated databases from sql server 2008r2 to Oracle 11gr2 using sql for small sized databases

Extensive experience in Dataguard configuration, implemented DR and monitored all standby databases.

Experience in SQL Server 2008 including backups, recovery and refreshes

Hands on experience in Grid control, Streams, Goldengate Replication

Performance Tuning: Tuned various large critical OLAP and OLTP databases of Tera bytes size using various tools like STATSPACK, AWR, SQLTrace, Tkprof, Analyze, ADDM and Explain Plan Methods.

Setup Oracle Enterprise Manager (OEM) 10g, Grid Control 11g, Cloud control 12c and 13c for database monitoring/performance/Reports/Alerts

Extensive knowledge in Database Backup and Recovery concepts using RMAN utilities (scheduling full/incremental/cumulative backups, hot/cold backups writing/editing UNIX Shell Scripts for RMAN).

Experience in LOGICAL BACKUPS and Database migration tools with DATA PUMP, Export/Import and Transportable tablespaces

Expertise in upgrading Oracle Development and Production databases from 9i to 10g &11g, 11g to 12c

Extensive knowledge and experience on Data Warehouse using ETL.

Proficient in SQL, PL/SQL, Stored Procedures, Functions, Cursors and Triggers and extensively used TOAD for querying databases etc.

Exposed to Data Warehouse assignments in various domains like Shipping services, Sales, Insurance, Financial & Bank, Inventory Distribution and Production Data warehouses

Extensive experience in configuring and implementing ASM and proficiency in using ASMCMD and ASMLIB, Flash-Back Technology, Log Miner.

Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) / Network Attached Storage (NAS)

Experience in maintaining databases on large Production, Testing and DEV environments.

Excellent Communication skills, co-ordination and communication with system administrators, business data analysts and development teams

TECHINICAL SKILLS:

DBMS & RDBMS

Oracle 8i,9i,10g,11g,12c, 19c and MS–Access.

High Availability, Tuning

& Monitoring Products

Oracle 10g, 11g, 12c RAC, ASM, Streams, Data Guard, 10g,11g,12c,13c Grid Control (OEM), Tkprof, Statspack, AWR, SPM, GOLDENGATE, ADDM, ASSM, Veridata, OS Watcher

Operating Systems

Solaris 9/10, Linux RHEL 3/4/5/6/7, HP-UX 10.x/11.x, AIX 5.2/5.3, Microsoft Windows 2000/2003/2005/2008

Tools & Utilities

Oracle SQL Developer, PL/SQL Developer, TOAD, SQL Loader, SCP, FTP, SFTP, MAVEN, JIRA, Service Now

ETL & Reporting Tools

Informatica, Power Center 8.5/8.0,Data Stage6.0,1.0, Cognos,

Business Objects Xi R26.1, Oracle Data Integrator

Backup Tools

Veritas Net Backup, NetApp, TSM, EMC, RMAN, Data pump, AVAMAR,HP Data Protector,

MS Office Tools

Excel, Word, PowerPoint, Outlook, Visio

Programming Languages

C,C++,Asp.Net, XML, HTML, DHTML, CSS, Java

Work Experience:

Verizon, silver springs, MD Jan 2019 – Till date

Sr. Database Administrator

Responsibilities:

Provide support and on call DBA for all non-prod and production databases for the entire organization

Refreshing All non prod databases from Production standby's

Created and cloned databases on EXADATA servers

Installed ORACLE 12c,19c database and Cloud control 12c & 19c on Linux servers

Installed OEM 13C on RHEL 7 and promoted all Production databases

Upgraded 13.1 OMS to 13.2 OMS and upgraded all related agents

Cloned 12c databases from production standby databases using RMAN

Configured 12c and 19c GOLDENGATE INTEGRATED Capture for Data warehouse databases

Goldengate troubleshooting using logdump utility

Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.

Standby database management across data centers and performing switchovers

Performance tuning of oracle Databases and poor SQL queries using OEM, toad, sql developer tools

Configured RMAN backups and restores from Tapes using HP Data protector

Cloned database and schemas using Data pump for 10g and 11g versions.

Applying interim/oneoff/CPU/PSU patches whenever required

Maintaining Security policies and Generating database reports though 13c OEM for SOX Compliance

Backup production databases using RMAN and recover during any issues

Do performance tuning for poor queries using oracle SPM, AWR, ADDM, BASELINE, etc

ASM Disk storage Management including convertion from Filesystem to ASM move

User management for all databases and audit compliance

Regular Day-Day activities and provide support to developers

Automating daily repetitive tasks using Shell scripts and documenting the same

Support During patching PSU/CPU/One-off patches and OS maintenance activities

JIRA tracking tool for any deployment/issue tracking

Environment/Tools: JIRA, Jenkins, Oracle 12c/11g/10g/9i, HP-UX, INFORMIX IDS, Solaris, VMWARE, RHEL 6.x/7.x, 12c,13c OEM (Cloud Control),RMAN, HP Data Protector, Data Guard, Goldengate 12c, TOAD,SQL Developer, Data Pump, Online redefinition, Toad 12.5.11, PUTTY,FTP, SFTP,SCP,DELPHIX, Confluence, EXADATA

Barclays bank, Wilmington, DE Aug 2017 – Nov 2018

Database administrator

Responsibilities:

Experience in Design, Creating and maintaining Oracle Databases 9i, 10g and 11g from the scratch on UNIX, LINUX,AIX and WINDOWS environments.

Installed 10g & 11g 2 Node RAC & Clusterware installation on RHEL 5.x server

Installed 11g 6 node production RAC CLUSTERWARE and DATABASE on Linux server

Installed Oracle12c Web logic server on LINUX server

Upgraded oracle database from 11.2.0.2 to 11.2.0.3 and from 11.2.0.3 to 12.1.0.1

Installed, Configured and Monitored STREAMS and GOLDEN GATE unidirectional replication

Installed VERIDATA tool for comparing data for Goldengate replication databases

Implement Oracle TDE (Transparent Data Encryption) column encryption for advanced security.

Implemented Oracle database WALLET for TDE

Regular Refreshing of schemas from oracle database on AIX server to LINUX server using Datapump

Experience in Administering Oracle 10g and 11g Databases using Oracle Enterprise Manager (OEM), Toad, SQL Developer and PL/SQL Developer

Involved in the Migration projects by using Data pump and RMAN utilities

Applying CPU and PSU patches for all the development and UAT servers when required

Upgraded all the development databases from 9i,10g to 11gr2 using Manual and DBUA Methods

Configured Oracle Data guard(ADG) for Oracle Disaster recovery on standalone databases using 11g ACTIVE DUPLICATION

Migrated 100GB database from Windows SQL server to Oracle server using SQL Developer tool

Writing SQL scripts using SPOOL command when required

Excellent experience in using Data pump utility for refreshing databases

Performed Online Redefinition for the large development and production tables

Involved in the migration of huge databases of sizes ranging from 100GB to 7TB

Daily Health Check Up of the Database and SQL Queries using OEM, Statspack, AWR, ADDM and TKProf

User management and security management

Experience in moving the data from one server to another server using SFTP,FTP and SCP

Building new databases and schemas from the scratch on Linux and UNIX Boxes.

Used Database Configuration Assistant (DBCA), Database Upgrade Assistant (DBUA) for upgrading Oracle10gR2 to the latest Oracle 11gR2 and applied patches as required.

Regular schema, table and database refreshing from production to development, UAT and SIT environments using RMAN and datapump utility.

Cloned 10g and 11g databases using RMAN duplication(with and without backup)

Involvement in space management, rectification of lock problems, user management.

Responsible to provide24 x 7 database administrative activities over different database servers

Configured Oracle Data guard(ADG) for Oracle Disaster recovery on standalone databases using 11g ACTIVE DUPLICATION

ASM Disk storage and user Management

Performance Tuning for the SQL queries by scrutinizing long running sql queries

Creation of database objects like Tables, Indexes, Views, Users, and DB Links using sql scripts

Scheduled Oracle Jobs and Backups using CRONTAB and OEM grid control.

Experience in Online and Offline backups and recovery.

Experience in backups and recovery using RMAN shell Scripts.

Environment: Oracle 11g/10g/9i, HP-UX UNIX, RHEL 4.x/5.x, ASM 10.2, 11g, 12c OEM (Grid Control), RMAN, Data Guard, STREAMS, Goldengate, Explain Plan, Tkprof, SQL Developer, PL/SQL Developer, power designer, Data Pump, Online redefinition, Business Objects, Toad 9.7.2.5, PUTTY,FTP, SFTP,SCP

Fedex Corp, Colorado Springs, CO Jun 2016 – Jun 2017

Oracle DBA

Responsibilities:

Experience in Design, Creating and maintaining the Oracle Databases 9i, 10g and 11g from the scratch on UNIX, LINUX and WINDOWS environment.

Configured GOLDENGATE unidirectional in classic capture mode on LINUX

Installed and monitored STREAMS one-way replication

Involved in the 10g 2 Node RAC installation on RHEL 5.4 server

Experience in Administering Oracle Database 10g and 11g using Oracle Enterprise Manager (OEM), Toad, SQL Developer and PL/SQL Developer.

Involved in the Migration projects Extensively using Data pump and Rman utilities

Migrated 100GB database from Windows SQL server to Oracle server using SQL Developer tool

Excellent in writing SQL scripts using SPOOL command

Proficient in using Data pump

Involved in the migration of huge databases of sizes ranging from 100GB to 7TB

Daily Health Check Up of the Database and SQL Queries using Statspack, AWR, ADDM and TKProf.

Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.

Experience in moving the data from one server to another server using SFTP,FTP and SCP

Building new databases and schemas from the scratch on Linux and UNIX Boxes.

Used Database Configuration Assistant (DBCA), Database Upgrade Assistant (DBUA) for upgrading Oracle10gR2 to the latest Oracle 11gR2 and applied patches as required.

Schema Refreshing of databases using normal copy method and exp/imp utility.

Cloned database and schemas using Data pump for 10g and 11g versions.

Cloned 10g and 11g databases using RMAN duplication(with and without backup)

Involvement in space management, rectification of lock problems, user management.

Responsible to provide24 x 7 database administrative activities over different database servers

Regular Data Refresh from Production to Test and Development environments using RMAN Duplicate Database or Data Pump utility for oracle 10g and 11g servers.

Configured Oracle Data guard for Oracle Disaster recovery on standalone database

Troubleshooting ORA errors when occurred

ASM Disk storage and user Management

Performance Tuning for the SQL queries by scrutinizing the long running sql queries

Creation of database objects like Tables, Indexes, Views, Users, and DB Links using sql scripts

Scheduled Oracle Jobs and Backups using CRONTAB.

Experience in Online and Offline backups and recovery.

Experience in backups and recovery using RMAN shell Scripts.

Environment: Oracle 11g/10g/9i, HP-UX UNIX, RHEL 4.x/5.x, ASM 10.2.0.4, OEM (Grid Control), RMAN and Data Guard, STREAMS, Explain Plan, SQL Developer, PL/SQL Developer, Data Pump, Business Objects, Toad 9.7.2.5, PUTTY,FTP, SFTP,SCP.

Bhaskara Biotech, India Mar 2014 – Dec 2015

Developer/Associate DBA

Responsibilities:

Collaborated with cross-functional teams on new products and product support

Worked in a team to understand the architecture and business models

Analyzed existing transactional database schemas and designed star schema models to support the end users

Knowledge in 10g and 11g 2 Node RAC installation on RHEL 5.4 server

Implemented and Monitored Data Guard (physical standby) for standalone Oracle 10g

Developed scripts for various reports base on end user requirements

Export and import of database objects using EXP and IMP.

Analyzed data requirements and developed data logical models.

Involvement in space management, rectification of lock problems, managed quotas.

Table partitioning to improve I/O access

Performance Tuning for the SQL queries which are running slow and taking more CPU cost

Creation of database objects like Tables, Indexes, Views, Users, and DB Links etc.

Scheduled Oracle Jobs and Backups using CRONTAB.

Restoration and Recovery of databases at the times of occurrence of critical failures

Experience in Online and Offline backups and recovery.

Environment: Oracle 10g/9i, RHEL 4.x/5.x, ASM 10.2.0.4, 10g OEM (Grid Control), RMAN and Data Guard, Explain Plan, SQL Developer, PL/SQL Developer, Data Pump, Business Objects, Toad 9.7.2.5, PUTTY,SFTP,SCP

Contact this candidate