SUMMARY:

• Over 10 years of experience in IT industry as an ORACLE DBA.
• Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies, Strong interpersonal and communication skills in dealing with customers.
• Extensive experience in working with RAC environment.
• Strong experience in working with Automatic Storage Management (ASM).
• Performed migration and upgrade of Oracle version 9i, 10g release 1 to 10g release 2 and 11g .
• Worked in Oracle 11g environment.
• Strong experience in Installation of Oracle 9.2.0.6, 9.2.0.7, 10.2.0.2, 10.2.0.3, 10.2.0.4, 11.2.0.2 binaries.
• Created 8i/9i/10g/11g/12c databases.
• Strong Experience in working with OLTP and Data warehouse environments.
• Designed and configured Oracle Dataguard (10g,11g) - Physical Standby
• Strong experience in working with Oracle streams.
• Strong experience in troubleshooting production issues.
• Strong experience in Physical and Logical Database design.
• Strong experience in SQL Tuning.
• Experience in Remote export/import due to non-availability of space in legacy servers.
• Experience in Tablespace management both local and dictionary.
• Strong knowledge of Veritas volume manager, Veritas Cluster Server and SAN
• Experience in taking HOT and COLD backup of the database and also the individual tablespaces.
• Experience in Backup & Recovery techniques using RMAN.
• Experience working with 24x7 production support
• Extensively worked on monitoring and optimizing the database by performance tuning
• Monitor usage of the databases.
• Strong Experience in SQL TRACE, TKPROF,STATSPACK,AWR,ADDM.
• Extensively used tools like SQL*Loader, Toad, Oracle Enterprise Manager (OEM),Grid Control.
• Setup and maintain documentation and standards.
• Developing UNIX shell scripts, PERL scripts, windows scripts and SQL scripts to carry out routine checks on databases.
• Monitored indexes and analyzed their status for performance tuning and query optimization.
• Developed UNIX shell scripts with embedded SQL*Loader calls and PL/SQL statements to extract data from the legacy application in the form of flat files and load the extracted data into the new application.
• Strong Experience in Oracle Server installation, configuration, client/server connectivity,backup /recovery.
• Experience in installing patches for upgrades and for various problems.
• Implemented proactive monitoring scripts for production databases.
• Experience in writing SQL queries, Stored Procedure, Function, Packages, Views, Triggers.
• Experience in creating different kinds of partitions on tables and indexes for managing large tables.
• Experience in Automation of tasks using scripts for creation of database and configuration of dataguard.
• Strong experience in performance tuning using Automatic Workload Repository (AWR) & ADDM.
• Used DBMS SCHEDULER, DBMS JOB to schedule the jobs.
• Strong experience in moving files from ASM to ASM & ASM to Non-ASM F.S using DBMS FILE TRANSFER.
• Experience working on MS SQLSERVER2008R2, MS SQLSERVER2012
• Configuration and setup of SQL databases
• Performed backup and recovery of SQL databases

TECHNICAL SKILLS:

Database Skills: Oracle 7.x/8i/9i/10g/11g, MS SQL Server SQL, PL/SQL, RAC, Dataguard, Oracle Streams, ASM

Backup planning and implementation: Performance Monitoring, Analysis and Performance Tuning

Database Recovery (DR) strategy planning and implementation: Capacity Planning and implementation

Partitioning, Replication, and Standby Database Administration: Installation, Patch, Upgrade, & Migration ODBC, JDBC

Operating Systems: UNIX (Sun Solaris 8, 9/HP/AIX4.3), Red Hat/Fedora Linux,HPUX-11.23

Applications: Erwin 3.5/4.1,Oracle Designer 8i/9i/10g

PL/SQL : Developer 5.2/7.0, SQL *PLUS, SQL loader

Oracle Management Server (OMS), Oracle Enterprise Manager (OEM): Oracle Utilities (Import / Export, SQL*Loader, 10g Data Pump)

Veritas Netback up 5.3/6.0, Software/Tools: Oracle GoldenGate 10x, Oracle GoldenGate Veridata v2x/3.0, Crystal Report 8.5/9/10, Humming Bird

Language: UNIX Shell Scripting,SQL,PL/SQL.

Protocols: FTP, SFTP, Ssh, Telnet, TCP/IP

PROFESSIONAL EXPERIENCE:

Confidential, Rye, NY

Sr Oracle/SQL DBA

Responsibilities:

• Implement Grid Infrastructure release 12c on a Unix/Linux env
• Setup and administer Oracle database security environment
• Install and configure Oracle upgrades from 11g to 12c release
• Use RMAN duplicates to refresh 11g env.
• Carryout DB performance tuning
• Troubleshoot problems with Oracle Support
• Configure and setup MS SQLServer related software
• MS SQL Server backup/recovery MS SQL 2012/2014
• Experience in using Database Engine Tuning Advisor
• Support 600 Oracle instances and 50 SQL databases
• Support MySql databases
• Backup and restore MySql databases version 5.6.12

Environment: Oracle 11.2.0.2,11.2.0.3, 12.1.0.2, MS SQL 2008,MS SQL 2008R2,MS SQL 2012,SAP.Oracle Hyperion,MySql 5.6.12

Confidential, Philadelphia, PA

Sr Oracle Infrastructure DBA

Responsibilities:

• Installation of 11g GI on Fusion IO on RHEL x86
• Installation of 12c GI on Fusion IO on RHEL x86
• Installation and set-up of golden gate replication on Exadata quarter Rack
• Performed migration using Oracle Golden Gate on 11.2.0.3 database on RHEL5
• Set up Active Dataguard
• Maintainance of Oracle Exadata X2-2 Quarter Rack
• Installation and maintainance of 2,3 node RAC cluster on ASM on OEL5
• Installation of a three node RAC cluster on a dnfs cluster
• Installation and maintainance of Dataguard including Fast Start Failover
• Upgraded single instance database from version 11.2.0.2 to 12.1.0.2
• Changed Oracle database name using NID utility on 11.2.0.1
• Maintained Oracle 11.2.0.2 databases on WIN 2008R2
• Set up Grid infrastructure with ASM
• Installation of 12c agent on linux x86
• Setup 12c Enterprise Manager and configured alerts
• Configured Full and Incremental RMAN backups
• Performed Restore and Recovery for different kind of failures
• Configure Data Domain Boost for RMAN in 11g Database
• Apply PSU patch to RDBMS and grid Infrastructure
• Experience in managing security with tablespace encryption, TDE(transparent data encryption),ASO
• Install and configure audit vault, oracle wallet and Database Firewall.
• Document security procedures, processes, technical specifications, implementation plans
• On-call rotation
• Restore and recovery of MS SQL server 2012 databases
• Export / import of data across MS-SQL 2012 databases
• Scheduling backups Of MS-SQLS 2012 databases
• Creation of objects in MS-SQL databases and helping on Releases
• Setting up Database security

Environment: RHEL5,X86,Oracle 11.2.0.3, Oracle 12c,Oracle 11.2.0.2, Oracle Golden Gate,JIRA,BMC, MS 2005,MS 2008,MS 2008R2,MS 2012,SAP

Confidential, Voorhees, NJ

Sr.Oracle DBA/SQL server DBA

Responsibilities:

• Maintain backups for Oracle and SQL databases
• Install,configure and administer Oracle database(11.2.0.2) in Linux x86, AIX,WINDOWS
• Create and maintain Physical standby databases,including DR and LA
• Participated in Disaster Recovery. Set restore point and flashback database to restore point post DR.
• Apply PSU/CPU patch to all sandbox,development,QA and PROD databases
• Apply PSU to all ASM databases including standby
• Automated SAP bundle Patch(PSU) for SAP databases for primary, standby and local-availability
• Maintenance of oracle STREAMS
• Installation of Oracle audit vault on OEL5
• Used RMAN duplicate to refresh DEV,QA from PROD
• Installed and maintained 2 node RAC on RHEL
• Performance Tuning and Backup workshop
• On-call support
• Performed MS SQLSERVER 2008R2 installaltion
• Configured transactionlog,full and incremental backups with MS Studio
• Creating objects in SQL databases
• Performing export-import of data in SQL databases
• Performed SQL database mirroring in DR and HA technique in 2008 R2
• On call support

Environment: RHEL5,AIX(5.3,6.1)SQL2005,SQL2008,Oracle 10.2.0.4,10.2.0.5,11.2.0.2, 10.2.0.4,10.2.0.5,10.1.0.5) MS SQLSERVER 2008R2

Confidential, Oaks, PA

Oracle DBA

Responsibilities:

• Worked in GWP as a senior oracle DBA, managing more than 100 databases for financial applications.
• Participated in the planning and design of the database server and database architecture to support business goals
• Install, configure and administer Oracle servers, including the design, configuration and operation of n-node clusters, data recovery, and user/group/role definition
• Support Unit, Integration, Load, Performance, System and Migration testing efforts
• Daily monitoring of more than 100 Oracle Databases through OEM Grid, OEM Alert .
• Performance tuning several SQL's/JOBS by changing database parameters and fine tuning the sql's database from Solaris to Linux using transportable tablespace
• Implementation and maintenances of Oracle Streams, CDC,GGS and RAC with ASM
• Implementing Oracle Streams for Data Sharing between production database and Informatica-Data Ware House Applications
• Writing Shell script for monitoring database, database statistics gathering.
• Carrying pager for 24x7 support
• Worked as an Informatica admin.
• Deployed BATCH ETLS and Workflow.
• Analyzed ETL codes and worked with ETL developers to fix code and issues.
• Worked with Documentum admins on Red Hat Linux to analyze and fix issues.
• Support & Maintenance of Production/Development Databases on various servers with on-call support for Production applications.
• Accomplish day-to-day requirements of User Community.
• Setup Client side and Server Side Load balancing in RAC environment.
• Schema & Tables refresh from Production to Development and Test Environments.
• Write scripts for creation of users, creation and assignment of roles, analyze space requirements and maintain tablespaces and other database objects and also did the patch management for oracle upgrade.
• SQL tuning and Database tuning has been done based on reports generated by AWR,ADDM, Statspack, Explain Plans and monitor the database performance on daily basis.
• Stabilized SQL plans by implementing AWR baselining and SQL profiling.
• Install, configure and support uni-directional and bi-directional Oracle-to-Oracle replicated environments utilizing GoldenGate v7. and Data Guard to ensure maximum availability and data protection
• Writing Shell scripts to automate manual DBA tasks.
• Implemented 3 Node RAC on Oracle 11g R2 with ASM.
• Implemented CDC - Change Data Capture for Data Warehouse application.

Environment : Sun Solaris 9/10, Oracle Linux AS5, MS Windows XP, Oracle 9i, Oracle 10gR2, Oracle 11g(11.1.0.7,11.2.0.1, 11.2.0.2), PL/SQL Developer, TOAD, Star Team, MS Shared Point, Control-M,SAP-ERP,AIX(6.1)

Confidential, Jacksonville, FL

Oracle DBA

Responsibilities:

• Migrated database from 9.2.0.1.0 (9i) to 10g.
• Installed and configured Oracle 10g Database on HP-UX and Linux advance Server on Development Test and Production Systems.
• Involved in performance monitoring and tuning of the database by fine tuning the database implementation.
• Performance tuning of PL/SQL queries and advising the application programmer of the opportunities in tuning the application.
• Integrated the Backup Status Reporting for all the databases in the enterprise to enable the web reporting using Oracle SQL, PL/SQL and Korn Shells.
• Troubleshoot Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM). Tuned database for optimum performance.
• Written Stored Procedures and Triggers for database maintenance and management using PL/SQL.
• Communicate and coordinate with Oracle using TAR system for major database issues/ problems; apply the required patches, test (unit test/ system test) and roll out and implement the patches into production
• Used BMC PATROL, PRECISE 7.5, OEM, OEM GRID CONTROL to monitor databases.
• Performance tuning for Oracle Real Application Clusters (RAC)
• Designed and Implemented database security using Oracle roles and privileges.
• Involved in disaster recovery planning; detailed out the processes and procedures of implementing disaster recovery; implemented database backups and disaster recovery strategies using RMAN.
• UNIX Shell scripting, & PERL for backup and monitoring of databases
• Implemented security protocols for the database
• Provided 24x7 on-call supports.

Environment : IBM AIX, Sun Solaris, HP-UX, Linux, MS Windows, Oracle 9i-All Release, Oracle 10g-All Release

Confidential, Houston, TX

Oracle DBA

Responsibilities:

• Worked in Oracle 9i, 10g databases
• Migrated databases from Oracle 8i,9i, 10g release1, sql server to oracle 10g release2 and 11g.
• Upgradation of mission Critical standalone databases to High Availability RAC environment.
• Consolidated over 120 Data Centers to only 3 data Centers.
• Worked in OLTP and OLAP environments.
• Worked in Production/Dev/Test environments.
• Installation of Oracle 8i, 9i, 10g in HP UX 11i.
• Created 8i, 9i, 10g databases.
• Created and configured Dataguard.
• Perform DR Test by every quarter.
• Maintained Physical standby databases.
• Provided 24x7 Production Support.
• Patch Analysis, Patch Installation.
• Worked in SQL Tuning.
• Designed and implemented database (logical and physical data models).
• Strong experience in replication using Oracle Streams.
• Worked with different application teams to carry out different Migration and provided warranty support for 2 weeks after handing it over to app team.
• Carried out various Migration reviews to gather the required information about the legacy database.
• Performed the capacity planning required to create and maintain the databases.
• Wrote various Unix shell scripts in sh,ksh environments to monitor databases and automate tasks such as creation of database, configuring data guard, QA.
• Loading data using SQL Loader and Data Pump utilities.
• Configured the databases for OEM monitoring, RMAN backup
• Created tablespaces and managed tablespaces adding/deleting/ resizing data files.
• Created schema (tables, Indexes, views, sequences, synonyms, roles, packages),DDL,DML, grant roles to users.
• Took remote export of a database residing on a remote server using tns entry (same oracle version) due to non availability of space in legacy server.
• Monitor and tune database performance using Explain plan, STATSPACK, AWR and ADDM.
• Created Procedure, Function, Triggers, Packages using PL/SQL.
• Created db link for inserting large tables directly without taking export.
• Debugged various problems which occurred during db creation
• Utilized various options available in exp, expdp and imp, impdp
• Managed databases of various sizes ranging from 1 GB to 2 TB.
• Underwent SOX data privacy training, handled SR.
• Setting up new environments (Development, Production etc).
• Table Partitioning, Creating Index Organized tables.
• Plans and implements backup and recovery of the oracle database using RMAN.

Environment: Oracle 8i, 9i, 10g, AIX, HP UX 11.11, 11.23, Sun Solaris 5.9, CAPMAN, MARS, APATE,RHEL, Power Designer, OVSD, Grants tool, OEM 10g grid control,, Veritas net backup.

Confidential

Oracle DBA

Responsibilities:

• Improved backup processes resulting in one-minute (downtime) cold backups
• Rebuilt, reorganized and simplified databases, enhancing development, maintenance and performance
• Documented most critical procedures and trained backup staff to run them
• Improved success rate of deployed tasks per test failure by more than 150% as part of development team
• Drastically reduced unscheduled downtime and improved performance
• Gathering of cost-based optimizer (CBO) statistics for tables with stale statistics
• Perform physical database design, database space needs and growth analysis, and future disk need analysis.
• Implement backup and recovery strategies for archiving and non-archiving databases.
• Participate in planning and implementation of off-site Disaster Recovery planning and testing. Monitor databases for performance and tune accordingly.

Environment: Solaris 2.4, AIX 3.2.5, Windows 2000, Oracle 8.1.7, TKPROF, Explain plan, tkproof, UTLB STAT, UTLE STAT, OEM.