SUMMARY:

• About 14+ Years of experience in IT industry, 11+ years’ experience as an Oracle Database Administrator having hands on experience in database administration production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management, database security. Oracle DBA 12c Certified (OCP) & SQL server DBA.
• Extensive knowledge on database administration of Oracle 8i, 9i, 10g, 11g & 12C with experience within very large scale database environment and mission critical large OLTP and OLAP systems.
• Excellent experience in installation, setup and configuration of Oracle 8i, 9i, 10g 11g & 12C on Windows, Solaris 10,Linux,HP Unix & RHEL platforms.
• Install configure and troubleshoot Oracle and Grid Infrastructure on multi node RAC cluster with 11GR2 & 12c ( 12.1.0.2)
• Rolling upgrade of Oracle and Grid Infrastructure on multi node RAC cluster with 11gR2
• Install configure and troubleshoot 12c OEM.
• Monitor database performance, diagnose performance problems, and tune the database as necessary. Investigate, gather diagnostic data for, and report to Oracle Support Services any critical database errors.
• Hands - on experience with of Oracle Data Guard setup, maintenance and troubleshooting for high Availability.
• Experience in Disaster Recovery activities RAC & non RAC environments.
• Coordinate the implementation of technical controls to support and enforce defined security policies.
• Experience with IBM AIX, Linux, SUN Solaris & UNIX operating systems.
• Experience in applying APR 2017 PSU patches to the databases across all environments.
• Requirements gathering with the application team and building new environments, Prod,Test,UAT,stage and Dev.
• Creating TAR/SR with Oracle and follow up.
• Building up new environments, setup, configure backup scripts and OEM metrics configurations.
• Managing the databases on Automatic Storage Management (ASM).
• Performing database cloning and restoration of very large sized databases using RMAN.
• Perform Object and schema refreshes using data pump.
• Coordination with UNIX team for platform migrations.
• Troubleshoot Performance issues in databases using OEM and all available tools like AWR, ADDM, SQLT, SPM and other functions/ packages.
• Experience in identifying TOP SQLs consuming OS and database resources and perform tuning using Unix/Linux utilities like SAR, IOSTAT, TOP, and VMSTAT.
• Effective troubleshooting of database and Performance problems.
• Good experience in Data Migration using Golden gate 12c, RMAN, and export/import across plat forms.
• Installation and configuring of Golden gate replications
• Oracle Goldengate replication expert DML, DDL unidirectional and Bi directional.
• Experience in EMDiag,OEM Fixes.
• Ticket resolutions and meeting SLA’s for MS-SQL and Oracle environments.
• Installation of SQL Server 2008 R2/ configurations/ Administrations
• Installation/configuration/Administering of SQL Server 2008/2008 R2/
• Version upgrade of SQL Server 2005 to 2008 R2
• User access management- MS-SQL /Oracle
• Service packs installation and upgrades
• Good Interpersonal communication skills and Documentation Skills.
• Supported for 1 year, Teradata DBA for Confidential.
• Experienced in fulfilling regulatory compliance (SOX compliance database standards)
• Worked on data center migration projects & Company separation works.
• Knowledge on Exadata, Cellcli commands.
• Trained on Mongo DB.

TECHNICAL SKILLS:

Operating Systems: HP-UX 10.x, 11.x, Sun Solaris 10.0, Red Hat Linux RHEL 2.1, 3.x, 4.x, 5.x,6.x,7.x and Windows 98/NT/2000/2003.

RDBMS: SQL SERVER 2008/2008 R2/ 2012 & Oracle 12C/11g/10g/9i/8,Teradata

Languages: SQL, PL/SQL, C, C++, UNIX Shell Scripting, XML,JAVA

DB Management: TOAD, OEM 12C

Tools: /Utilities: RAC, OEM Grid Control, ESM, SQL Navigator, SQL* Loader, ASM, Export/Import, RMAN, TOAD, Patch Management, SQLNET, Oracle Streams,Goldengate10g/11g&12C Data pump, Data Guard, VMware MS Office & Putty.

Tuning Tools: TOAD, DBaritician,OEM 12C, Oracle Developer

Backup Tools: BMC control M,SQL backtrack, veritas NetBackup,Data Domain & Commvault simpana

PROFESSIONAL EXPERIENCE:

Confidential, Framingham, MA

Sr. Oracle & SQL server Database Administrator

Responsibilities:

• It helps people with debilitating and complex conditions that are often difficult to diagnose and treat.
• Joined DBA team and started learning the new environment.
• Undergoing various trainings related to pharmaceutical standards, procedures to follow for changes and new builds.

Environment: Oracle 10g/11g & 12C RAC, RDBMS, RMAN, Data Guard, 12c, Toad, RHEL, 6.x, SQL Server /2008/ 2008 R2/ SQL Server 2012, shell scripting, OS, windows servers, Linux,HP Unix & Solaris servers. 12C OEM Grid control & backup tool Data Domain.

Confidential, Lancaster, PA

Sr. Oracle Database Administrator

Responsibilities:

• Install configure and troubleshoot Oracle and Grid Infrastructure on multi node RAC cluster with 11GR2 & 12c (12.1.0.2)
• Day to Day database activities like space management, security and user Management.
• DR exercise on every quarter
• Creating TAR/SR with Oracle and follow up.
• Applying patches CPU/PSU on priority basis .
• Building up new environments, setup, configure backup scripts and OEM metrics configurations.
• Company Separation Data migration and new environment building.
• Managing the databases on Automatic Storage Management (ASM).
• Performing database cloning and restoration of very large sized databases using RMAN.
• Perform Object and schema refreshes using data pump.
• Coordination with UNIX team for platform migrations.
• Troubleshoot Performance issues in databases using OEM and all available tools like AWR, ADDM, SQLT, SPM and other functions/ packages.
• Experience in identifying TOP SQLs consuming OS and database resources and perform tuning using Unix/Linux utilities like SAR, IOSTAT, TOP, and VMSTAT.
• SQL and PL/SQL or T-SQL programming.
• Prod, Test, Stage and Dev.
• Unix shell, Perl or OS scripting language.
• Installation of SQL Server 2008 R2/ configurations/ Administrations Provided L3 support Glodengate 12c installation and configuration at source and target.
• DML, DDL replication using Oracle unidirectional and bi-directional.
• Windows to Oracle replication Glodengate.
• Replication setup using materialized views.
• Installation/configuration/Administering of SQL Server 2008/2008 R2/
• Version upgrade of SQL Server 2005 to 2008 R2
• User access management- MS-SQL /Oracle
• Online ordering support for Flooring/Ceilings sites.

Environment: Oracle 10g/11g & 12C RAC, RDBMS, RMAN, Data Guard,Glodengate 12c, Erwin Data Modeler, RHEL 5.x, 6.x, SQL Server /2008/ 2008 R2/ SQL Server 2012 shell scripting, OS, windows servers, Linux,HP Unix & Solaris servers. 12C OEM Grid control, CommVault,Simpana, & VERITAS NetBackup.

Confidential, Bloomington

Sr. Oracle Database Administrator

Responsibilities:

• Real Application Clusters (RAC), Oracle 10g and 11gR2.
• Upgraded the test, development & prod databases from 10g to 11g R2.
• Performed performance monitoring through Oracle Enterprise Manager and SQL Scripts.
• Day to Day database activities
• Applying patches CPU/PSU on priority basis.
• Building up new environments, setup backup scripts and OEM metrics configurations.
• Monitoring of resources consuming high CPU and memory utilizations.
• Glodengate 11g installation and configuration.
• DML, DDL replication using Oracle 11g unidirectional and bi-directional.
• Windows to Oracle replication Glodengate 11g.
• Application database changes implementation on all environments.
• Oracle 11g active data guard building.
• Experience in creating TAR/SR with Oracle and follow up when required.
• Patch applying, upgrading, cloning step by step document creation according to the requirements & mentoring team.
• DR exercise on every quarter.
• Requirements gathering with the application team and building new environments, Prod, Test, Stage and Dev.
• Ticket resolutions and meeting SLA’s for MS-SQL and Oracle environments.
• Installation of SQL Server 2008 R2/ configurations/ Administrations Provided L3 support
• Installation/configuration/Administering of SQL Server 2008/2008 R2/
• Version upgrade of SQL Server 2005 to 2008 R2
• User access management- MS-SQL /Oracle
• On call support for production support DBA

Environment: Oracle 10g/11g & 12C RAC, RDBMS, RMAN, Data Guard,Goldengate 11g Erwin Data Modeler, RHEL 5.x, 6.x, SQL Server /2008/ 2008 R2/ SQL Server 2012 shell scripting, OS, windows servers, Linux,HP Unix & Solaris servers. 12C OEM Grid control, Data Domain & Toad.

Confidential

Senior Oracle DBA

Responsibilities:

• Sql back track backup tool
• OEM monitoring tool
• Upgraded the test, development & prod databases from 10g to 11g R2.
• Performance Tuning.
• Applying patches CPU/PSU on priority basis.
• Data guard 11g setup and monitoring.
• Oracle 10g and 11g database basic administration on Linux platform
• Database design, Created physical database model
• Multiple schema design for Data planning and Security
• Optimized database performance by analyzing database objects, gathered statistics, created indexes
• Improved performance of batch jobs, many reports. Performance fixes typically reduced batch runtime by hours. Recommended and implemented partitioning adjustments, materialized views, summary tables, Oracle parallelism, indexing improvements, as well as improved SQL techniques. Coordinate developers on more efficient ways to write database queries. Tracked down the source of troublesome locking problems
• Identified and tuned SQLs in production databases

Environment: Oracle 10g/11g RAC, RDBMS, RMAN,SQL backtrack, Data Guard, RHEL 4.x, 5.x, shell scripting, Oracle 9i, 10G, and 11G OEM Grid control.

Confidential

Senior system specialties

Responsibilities:

• OEM monitoring tool
• Upgraded the test, development & prod databases from 10g to 11g R2.
• Teradata DBA support.
• Applying patches CPU/PSU on priority basis.
• Data guard 11g setup and monitoring.
• SOX compliance databases support.
• Agent Installation and discovering targets in OEM
• Applying monitoring templates in OEM
• Creation of tablespaces, datafiles, users etc., for project requirement
• Backup Configuration
• Database Cloning and DR Rebuild
• Schema refresh using export/import and Data Pump
• Administering databases of size in Tera bytes
• Performed capacity planning to avoid tablespace issues
• Building administering physical standby database and RAC systems
• Coordinating with different departments like, Applications, UNIX, Storage, Change Management team.

Environment: Oracle 10g/9i, Sun Solaris, Windows NT / 2000, Red Hat Linux, HP-UX, SQL, TOAD, ERWIN, RMAN, OEM.

Confidential, SANANTONIO, TX

Associate Consultant

Responsibilities:

• On call support for Confidential production support DBA.
• Day to Day database activities like space management, security and user Management.
• Applying patches CPU/PSU on priority basis.
• Database upgrades and regular maintenance activity as assigned by L3 Dba team.
• User, password and space management activities
• Creating Change Requests and Support Call tickets
• OEM Grid control - configured RMAN backups, Agent Installation
• Oracle Streams troubleshoot
• Database Performance and SQL query tuning with tools like Statspack, AWR, ADDM, OEM
• Reporting activities related to password expiry, change meeting, audit review, high risk review, Teradata daily statistics, user transfer and termination, permissions audit etc.
• Checking system storage requirements for the databases (health checks) DB growth capturing.
• Installing Oracle server software, Upgrades from 9i to 10g with DBUA/manual

Environment: Oracle 9i/10g RAC, RDBMS, RMAN, Data Guard, Streams, RHEL 4.x, 5.x, shell scripting, Oracle 9i, 10G, and 10G OEM Grid control and BMC control M backup tool.

Confidential

Senior Analyst

Responsibilities:

• Day to Day database activities like space management, security issues.
• Applying patches CPU/PSU on priority basis
• Application team code moving to stage, test, prod and UAT environment.
• Data refresh for testing & cloning DB for application team.
• Resolving user tickets with in SLA.
• Streams replication supported.
• Suggesting the DB changes for application team.
• Migrating the Oracle 9i database to 10g using Export / Import & RMAN
• Backup and Recovery Management through (RMAN/HOT/COLD)
• Analyzing the schema and database for performance upgrade and identify the table growth
• Export / Import of Database, Schemas & Tables using exp/imp & Data pump
• Creation of Database links for remote databases
• Proactively monitoring alert log files and perform database health check up
• User Management - Allocating Quota, Managing Profiles and Granting / Revoking privileges, locking / unlocking the User Accounts
• Querying different advisors and performing the tuning based on the advisors results in order to maintain the performance of database

Environment: Oracle 9.0.1, 9.2.0.4,& 10g RAC, RHEL, Windows 2003, Enterprise Manager, Data Pump, RMAN, Data Guard, Streams, SQL, PL/SQL, shell scripting & shareplex.