SUMMARY

• Sixteen+ years of IT experience in various industries that support Service, Production & Information Technology.
• Ten+ years of experience as Oracle DBA Including work of Database Management, Backup & Recovery, Performance Tuning, Configuration of Database, Tablespace administration, User management, Index management and managing data dictionary objects.
• Extensive experience in installations of Oracle Software, Configuration for database and day to day routine works for database administration, System User administration, Index organization, Cluster creation. V$Views checking for daily performance Tuning of database.
• Experience with Installation of SQL Server 2k or 2k5 or 2k8 in cluster and non - cluster environment as per company policy and maintaining documents for configuration.
• Hands-on experience in RDBMS (Oracle 8, 9, 10g, 11g, MS Access, MS SQL Server 6.5/7.0/2000 , 2005, 2008).
• Experience with Oracle Enterprise Manager (OEM) for configuration and monitoring multiple instances.
• Experience in Data Migration from SQL Server 2005 to Oracle10g, SQL Server2005 to SQL Server2008.
• Experience in writing Shell Script in VI Editor, Stored Procedures, Functions, Packages and triggers using PL/SQL to implement business rules and processes.
• Fine-Tuned and optimized SQL queries and performed code debugging using TOAD, SQL Profiler.
• Worked on Database size up to 4TB.

TECHNICAL SKILLS

Database: Oracle (versions 7.3, 8.0, 8i, 9i, 10g, 11g), SQL Server 2k, 2k5, 2k8, Microsoft Access

Software: Developer 2000 (2.1) (Oracle Forms 3.0, 4.5, 5.0, Reports 1.1, 2.5, 3.0), Pro*C 1.5, 2.2, Visual Basic 5.0.

SAP: SAP R/3 Basis Administration in V 3.x, 4.x, NW, BW.

Languages: C, C++, SQL, PL/SQL, Basic, and COBOL.

Networks: TCP/IP, MS Windows NT, MS Cluster.

PROFESSIONAL EXPERIENCE

Confidential

Sr. Oracle DBA

Responsibilities:

• Work on Production support for Oracle and SQL Server environment on cluster (RAC) and non-cluster environment.
• Database backup & Recovery performed on Archive and non-archive database using RMAN and Data Pump export and Import.
• Worked on Flashback Database for restore to point in time with SCN and restore point.
• Work with Oracle Enterprise Manager 12c for monitoring production and non production system in addition to Exadata environment.
• Apply Oracle-supplied patches to production and non-production databases for Linux and AIX environment to keep all databases up to date at current patch level.
• Performance tuning activity with SQL Command and parameter setting, Index management with index organization. Rebuild, Re-organize index as and when required in Oracle database and scheduling Update stat job for database as per business policy.
• Working on Creating Commands script for daily monitoring and maintaining production and non-production environment.
• Working with PUTTY, PSFTP, WINSCP, for transferring backup file from remote location to local.
• Working on 24/7 database support environment.

Environment: Oracle 11g, SQL Server 2k8, Linux, AIX, Windows Server 2003.

Confidential - Portsmouth, NH

Sr. Oracle DBA

Responsibilities:

• Installation of Oracle 11g and SQL Server 2008 software with cluster (RAC) and non-cluster environment. Configuration of Database, User Creation, Role & Profile Assignment.
• Database backup & Recovery performed on Archive and non-archive database using RMAN and Data Pump export and Import.
• Creating maintenance plan for Full Backup, Differential Backup, TLog Backup in SQL Management Studio and Lite Speed for SQL Server.
• Work with Grid Control and configure multiple instances for monitoring and managing in Oracle Enterprise Manager.
• Work on Disaster Recovery Project (high availability) and successfully configured and tested in Oracle production database.
• Work with DB Artisan & Toad for monitoring and managing in Oracle and SQL servers.
• Apply Oracle-supplied patches to production and non-production databases for Linux and AIX environment to keep all databases up to date at current patch level.
• Create script for resolution gap between replication and successfully tested in production and non-production replication environment.
• Performance tuning activity with SQL Command and parameter setting, Index management with index organization. Rebuild, Re-organize index as and when required in Oracle database and scheduling Update stat job for database as per business policy.
• Working on Creating Commands script for daily monitoring and maintaining production and non-production environment.
• Working with PUTTY, PSFTP, WINSCP, for transferring backup file from remote location to local.
• Working on 24/7 database support environment.

Environment: Oracle 11g, SQL Server 2k8, Linux, AIX, Windows Server 2003.

Confidential - Warren, NJ

Sr. Oracle / SQL Server DBA

Responsibilities:

• Installation of Oracle 11.2 on Standalone and Cluster environment with DMA (Database Middleware Automation). Create workflow for User Creation, Role & Profile Assignment for database users in DMA in Linux and AIX environment.
• Successfully implemented workflow for Database backup & Recovery on Archive and non-archive database using RMAN and Data Pump export and Import.
• Creating maintenance plan for Full Backup, Differential Backup, TLog Backup in SQL Management Studio and Lite Speed for SQL Server.
• Work with Grid Control and configure multiple instances for monitoring and managing in Oracle Enterprise Manager.
• Create Patching workflow for DMA to apply on standalone and cluster environment.
• Apply Oracle-supplied patches to production and non-production databases for Linux and AIX environment to keeping all databases with up to date patch level.
• Install DMA services on servers and configure with DMA environment for creating new workflow and installed HP workflows for Database automation.
• Performance tuning activity with SQL Command and parameter setting, Index management with index organization. Rebuild, Re-organize index as and when required in Oracle database and scheduling Update stat job for database as per business policy.
• Working with 11g XML Database configuration, storage model, DB repository and creating XML Indexes for better performance.
• Working with PUTTY, PSFTP, WINSCP, for transferring backup file from remote location to local.
• Working with OS team for scheduling Data backup job from Disk to Data-protector to avoid issue of performance of DB server and conflict of database job and OS backup job.

Environment: Oracle 11g, SQL Server 2k8, Linux, AIX, Windows Server 2003.

Confidential - Charlotte, NC

Sr. Oracle & SQL DBA

Responsibilities:

• Installation of Oracle and SQL Server software with cluster (RAC) and non-cluster environment. Configuration of Database, User Creation, Role & Profile Assignment in SAP and Non-SAP environment.
• Database backup & Recovery performed on Archive and non-archive database using RMAN and Data Pump export and Import.
• Creating maintenance plan for Full Backup, Differential Backup, TLog Backup in SQL Management Studio and Lite Speed for SQL Server.
• Work with Grid Control and configure multiple instances for monitoring and managing in Oracle Enterprise Manager.
• Work on Disaster Recovery Project (high availability) and successfully configured Oracle and SQL production database.
• Configure and manage Data warehouse system on Baan Application environment.
• Perform Daily check for all SAP System with Global SOLMAN and working with BRTOOLs for database maintenance. (Daily checks Using Tcodes ST04, DB02, DB13, DB12, SM20, SM21, SM35, BD87, SM37, ST22 etc.) And perform Oracle and SQL database according to company policy.
• DBA support on 24X7 environment, Supporting Central Administration Service Desk for Database related issue and work on Ticket to resolve the identified issues.
• Performance tuning activity with SQL Command and parameter setting, Index management with index organization. Rebuild, Re-organize index as and when required in Oracle database and scheduling Update stat job for database as per business policy.
• Apply Oracle-supplied patches to the databases of each OS. Keep all databases with up to date version and patch level.
• Working with Database Refresh, Migration from Oracle 7 to 9i and Datacenter Move from one location to another.
• Domain migration for Database servers.
• Hands on work experience with 11g new features like High availability, RMAN archive log management for streams and data guard, optimize undo backup, Data Pump to use for compression and encryption of backup, transportable partitions, Manageability with memory target parameter for auto memory management, auto SQL turning, and more.
• Working with PUTTY, PSFTP, WINSCP, for transferring backup file from remote location to local.
• Working with OS team for scheduling Data backup job from Disk to Data-protector to avoid issue of performance of DB server and conflict of database job and OS backup job.

Environment: Oracle 9i, 10g, 11g, SQL Server 2k, 2k5, 2k8, SAP NW, SAP R/3, BI, XI, Vertex, Oracle E-Business Apps, Oracle Golden Gate, Linux, IBM Unix, SUSE, HP-Unix, Windows Server 2003.

Confidential - New York, NY

Sr. Oracle / SQL Server DBA

Responsibilities:

• Installation of Oracle software. User Creation under client as per specific Role Assignment, Profile Assignment.
• Database backup & Recovery with Data Pump Utilities (dpexp and dpimp) for offline (non archive) database and online backup and Recovery for Archive database with RMAN.
• Work with Oracle Enterprise Manager for managing Database. (Administration of Database, Adding Tablespace, Datafile, Rollback Segment, Redo Log, Startup & Shutdown of your database instance, Managing Sessions, Releasing Locks, Backup and Recovery through backup management and much more.)
• Database administration on basis 24X7, Ticketing for problem resolution.
• Performance Tuning with SQL Command and parameter setting, Index management with index organization.
• Apply Oracle-supplied patches to the databases of each OS. Keep all databases at the same version and patch level.
• Working with SQL Server Management Studio for SQL Server 2005 and made some maintenance plan for Backup, Rebuilding Index and Reorganizing Index. Check the SQL Server Logs for error and backup status.
• Database monitoring and maintaining in TOAD Software.
• Working with PUTTY, PSFTP for transferring backup file from remote location to local.

Environment: Oracle 8i, 10g, 11g, SQL Server 2k5, Sun Unix, Windows Server 2003

Confidential - Hermitage, TN

Oracle DBA

Responsibilities:

• Data Migration from SQL Server2005 to Oracle10g.
• SQL Job scheduling in TOAD 8.6.1 for migration.
• Performance Tuning, Index management, Database configuration for database on the day-to-day basis analyses or weekly or monthly.
• Fine-Tuned and optimized SQL queries and performed code debugging using TOAD.
• Database backup & Recovery with Data Pump Utilities (dpexp and dpimp) for offline (non archive) database and online backup and Recovery for Archive database with RMAN.
• Working with Oracle Enterprise Manager (OEM) for database administration.
• Remote work for database administration on basis 24X7, Ticketing for problem resolution.
• User administration, Profile Creation, Role Assignment.
• Database tuning, using STATSPACK, Oracle trace, Partitioning, re-indexing.
• Performance Tuning with SQL Command and parameter setting, Index management with index organization.
• Wrote Stored Procedures, Functions, Packages and triggers using PL/SQL to implement business rules and processes
• Created Shell scripts to access and set-up runtime environment, and to run Oracle Stored Procedures, Packages
• Working with PuTTY, PSFTP for transferring backup file from remote location to local.

Environment: Oracle 9i, 10g, SQL Server 2k5, Windows Server 2003, UNIX (Solaris).