SUMMARY

• 7+ Years of experience as Oracle 8i,9i,10g / SQL Server 2000/2005/2008 DBA on different Unix environments like HP - UX, Sun Solaris, Linux, AIX, and Windows 2000/2003/NT.
• Performing Backup and Recovery for SQL Server Databases and Oracle Databases.
• Creating/Scheduling maintance jobs on SQL Server 2000/2005.
• Migration of databases from SQL Server to Oracle using DTS packages, SSIS/SSMA.
• Installed and configured Oracle 9i/10g Database on HP-UX and Linux advance Server on Development, Test and Production Systems.
• Migration of databases from SQL Server to Oracle and SQL Server .
• Extensive Experience in K-Shell scripts and PL/SQL procedures.
• Designed and implemented backup and recovery strategies.
• Hot and cold backups were used. Also used RMAN, methods like PITR and full/ partial export/import and Data Pump.
• Apply Patches SP2/SP3/SP4 on SQL Server 2000/2005.
• Experience of installing, upgrading, patches, TAR support. Duties included database creation, tuning/reorganization, backup/recovery, user and security management, auditing, general troubleshooting, and configuring servers.
• Specialist in functions, stored procedures, T-sql and triggers.
• Working knowledge of high availability SQL Server solutions, including Log shipping, Replication.
• Extensive understanding of data warehousing concepts.
• Troubleshooting Database performance using Automated Workload Repository and Automatic Database Diagnostics Monitor.
• Extensive Knowledge of SQL Server Mirroring.
• Configured and Maintained Physical Data Guard for High Availability and offline reporting.
• Experience in full software development life cycle (SDLC) of database administration.
• Efficient in SQL query optimization using Explain Plan, AWR, gathering statistics, pinning the objects, and running scripts.
• Backup and Recovery of SQL Server databases and Scheduling jobs using Management Studio.
• Responding and working with Application Development teams.
• Designed logical and physical Data Models using ERWIN forward-engineered into DDL and executed on large scale to create database.
• Maintained and Monitored multiple databases using Oracle Enterprise Manager.
• Supported the system 24x7. Ability to work Confidential regular hours.
• Excellent communication and interpersonal skills.

TECHNICAL SKILLS

OPERATING SYSTEM: HP-UX, AIX, WINDOWS NT, LINUX (Red Hat Enterprise Server), Sun Solaris

DBMS: ORACLE 8i/9i/10g, RDBMS

TOOLS: Oracle Migration Workbench, SQL-Backtrack, Platinum - Performance Monitor, Veritas Volume Manager, ERWin and DBArtisanSQL* Loader, Crystal reports 2.5

LANGUAGES: SQL, PL/SQL, UNIX Shell scripting, C++, VB.net

HARDWARE: IBM RS 6000 servers, Sun sparc E 4500/5000/450 with EMC symmetrix 8530and Raid 1 disk storage, HP 9000/E39, DELL Edge 2550/4500.

PROFESSIONAL EXPERIENCE

Confidential, Champaign, IL

Oracle/ SQL Server DBA

Responsibilities:

• Configuration and maintenance of Oracle Database Software 10g on HP-UX 11.22
• Completed a full life cycle from conversion to production.
• Focal Point for Conversion Process to Production environment.
• Installing SQL Server 2000/2005 on Windows 2000/2005 with creating/scheduling monitoring jobs using SQL Management.
• Installation and Configure Timesten DSNs, Creating, loading, unloading DSNs.
• Provided Support for Production Databases and Test Databases.
• Install, configure and administer Oracle 10g databases from scratch.
• Refresh SQL Server databases from Production to Test/DWH Databases.
• Performance tuning of SQL queries and advising the application programmer of the opportunities in tuning the application
• Work on Documentation/updating Oracle/SQL Server Installation, deletion and workflow.
• Work on SQL Server Agent for remote accessing in SQL Server 2005.
• Involved in performance monitoring and tuning of the database by fine tuning the database implementation.
• Creation, Deletion and upgrade of Data Warehouse management systems in oracle.
• Creating mirror server and implemented witness server on SQL Server 2005.
• Designed and Implemented database security using Oracle roles and privileges
• Written Stored Procedures and Triggers for database maintenance and management using PL/SQL; T-SQL, UNIX Shell Scripts for backups and database-monitoring activities.
• Working knowledge of high availability SQL Server solutions, including Log shipping, Replication.
• Coordinated 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.
• Extensive use of DBMS packages for creating scripts and troubleshooting the database.
• Apply patches or upgrading databases from 9.2.0.4 to 9.2.0.8 and from 9.2.0.8 to 10.2.04.
• Created tons of Shell scripts for Conversion process.
• Creation of stand-by, Disaster recovery databases on Oracle 9i/10g environments.
• Monitor the overall performance of the database to recommend and initiate actions to improve/optimize performance.
• Create and/or maintain clear documentation regarding all components of database administration.
• Open tickets for Storage requests.
• Creating Champs/Change Control for Space, resize VGs (raw devices), security etc and attend conference calls for approval.
• Coordinate with IT-Team to in regards to server, storage and other hardware requirements for deploying and maintaining Oracle production Instance and the development Instances.
• Setting up Proactive monitoring tools at database level and system level alerts for proactive action.
• Manage multiple databases with different Oracle versions on Unix operating systems.
• Team member in a 12 member DBA team.
• Team member of Backup and Recovery Group responsible for Disaster recovery and Standby Database.
• Supporting around 80+ Oracle production databases, 90 developments and 90 test databases on Unix and Linux. Instances of 5+ TB with more than 500 concurrent users.
• Supporting around 50+ SQL production databases, 40 development and 50 test databases. Instances of 1+ TB.
• Worked on creating reports using SQL Server Reporting Services (SSRS).
• Implemented and used OEM for monitoring and maintenance of VLDBs.
• Performing Backup and Recovery for SQL Server Databases and Oracle Databases.
• Created SSIS/DTS packages on SQL Server 2005.
• Worked extensively on Process documentation, database tuning, Advanced Queuing and OEM.
• Designed logical and physical Data Models using ERWIN forward-engineered into DDL and executed on large scale to create database.
• Creating workflow diagrams using MS Visio.
• Worked on RMAN and Netbackup.
• Provided 24x7 production support to Oracle and SQL Server databases.

Environment: Oracle 8i/9i/10g running on HP-UX, Toad, MS Visio, SQL Server 2000/2005, SQL*Loader, OEM, AWR, Query Analyzer.

Confidential, DC

Oracle/SQL Server DBA

Responsibilities:

• Migrated database from 9i to 10g.
• Installed and configured Oracle 10g Database on HP-UX and Linux advance Server on Development (& Windows 2003), Test and Production Systems.
• Involved in performance monitoring and tuning of the databases.
• Creating mirror server and implemented witness server on SQL Server 2005.
• Performance tuning of PL/SQL queries and advising the application programmer of the opportunities in tuning the application.
• Working knowledge of SQL Server Replication.
• Troubleshoot performance issues on SQL Server databases using DTA and SQL Server Profiler.
• 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 query issues and dead lock issues on SQL Server 2000/2005.
• Written Stored Procedures and Triggers for database maintenance and management using PL/SQL, T-SQL.
• Troubleshooting Server issues for SQL Server databases using Task manager and Event Manager.
• Involved in Logical & Physical Schema Design and data modeling using ERWIN.
• 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.
• Working knowledge of high availability SQL Server solutions, including Log shipping, Replication.
• Performing Backup and Recovery for SQL Server Databases and Oracle Databases.
• Creating/Scheduling maintance jobs on SQL Server 2000/2005.
• Migration of databases from SQL Server to Oracle using SSIS/DTS packages.
• 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.
• Successfully implemented physical standby database using Oracle Data Guard feature for High availability configuration.
• UNIX Shell scripting for backup and monitoring of databases.
• Implemented security protocols for the database.
• Provided 24x7 on-call production support. Willingness and flexibility to work Confidential regular hours based on business demands.

Environment: Oracle 10g, RMAN, Cluster failover, Unix Shell Programming, SQL Server 2000/2005, Functions and Triggers, SQL Tuning, PL-SQL, Stored Procedures, TOAD, Korn, Linux/Windows 2003 Servers.

Confidential, Columbia, MD

Oracle/SQL Server DBA

Responsibilities:

• Migration & configuration of Oracle 9i to 10g.
• Performance, Monitoring, determines the size SGA/PGA using AWR and ADDM, Hit ratios, estimate the number of users, CPU and Disk space requirement.
• Design and implement database backup and recovery procedures using RMAN.
• Creating various scripts for monitoring and better performance.
• Installing SQL Server databases on Windows 2003.
• Reorganization of existing databases to meet standards or better require efficiency.
• Managing database security. Creating and assigning appropriate roles and privileges to users depending on the user activity and auditing.
• Running imports/export utilities, off-line backup, on-line backup various PL/SQL server Applications utilities.
• Performing Backup and Recovery for SQL Server Databases and Oracle Databases.
• Creating/Scheduling maintance jobs on SQL Server 2000/2005.
• Written Stored Procedures and Triggers for database maintenance and management using PL/SQL, T-SQL.
• Migration of databases from SQL Server to Oracle using SSIS/DTS packages.
• Identifying bottleneck and rectifying it, fine-tune store procedures to improve performance, database loads, performance improvements, proper setup of database files.
• Troubleshooting the standby database and restore it with corrupted datafiles.
• Partitioning strategies for very large tables implementing range, list partitions, hash sub partitions.
• Managing operational database, gathering statistics using various methods.
• Provided 24x7 on-call production support. Worked Confidential regular hours based on business demands.

Environment: ORACLE 10g, AIX 4.3, OEM, DB2, DELL EDGE 2500, SQL Server 2000/2005, Performance and Troubleshooting, SSIS/DTS packages, SQL Server Profiler, DTA.

Confidential, Danbury, CT

Oracle/SQL Server DBA

Responsibilities:

• Installed and configured Oracle 9i Database on HP-UX and Linux advance Server on Development, Test and Production Systems.
• Performed Backup and Recovery for SQL Server Databases and Oracle Databases.
• Creating/Scheduling maintance jobs on SQL Server 2000/2005.
• Migration of databases from SQL Server to Oracle using SSIS/DTS packages.
• Created and maintained Databases and their objects like tablespaces, tables, indexes, views.
• Partitioned appropriate tables to optimize performance and simplified maintenance work.
• Administered database using Oracle Enterprise Manager.
• Created and executed various database queries.
• Performed RMAN and user managed backup also hot /cold backups
• Monitored and tuned rollback segment, temporary tablespace, redo log buffer, sort area size.
• Implemented security protocols for the database.
• Scheduled jobs to run on daily/weekly/monthly basis.
• Extensively involved in design physical and logical models of the database.
• Provided 24x7 production support. Willingness and flexibility to work Confidential regular hours based on business demands.

Confidential, Hartford, CT

Oracle DBA

Responsibilities:

• Configured and Maintained Oracle Physical Standby Database for High Availability.
• Development of product, quality testing and production database for new 10g server.
• Refreshed databases from production to create test, development and UAT instances.
• Performed heavy data transfer using import/export utility and data pump.
• Familiar with third party backup media tools as legato and MML for RMAN. And oracle media manager for tape backup.
• Performed heavy data loads using SQL*Loader.
• Worked on space estimation and space management.
• Data needed to be extracted from different tables in different schemas/databases for analysis.
• Performed RMAN and user managed backup also hot /cold backups
• Developed the tools and utilities (using Shell Scripts extensively) through the extensive usage of Shell Scripts on UNIX Platforms with alerting facility.
• Implemented and used OEM for monitoring and maintenance of VLDBs. Integrated OEM and Backup solutions using RMAN.
• 24/7 Sys Admin Activities and technical production Support in a team oriented environment.

Confidential

Oracle DBA

Responsibilities:

• Installed and configured Oracle 9i Database on HP-UX and Linux advance Server on Development, Test and Production Systems.
• Created and maintained Databases and their objects like tablespaces, tables, indexes, views.
• Partitioned appropriate tables to optimize performance and simplified maintenance work.
• Created and executed various database queries.
• Tested and Implemented different physical and logical Backup and Recovery methods like point in time, Media recovery, Full/partial export/import.
• Performed Query Tuning, Testing & Implementation
• Administered database using Oracle Enterprise Manager.
• Tuned and optimized SQL Query, using Oracle Enterprise Manager and by monitoring the statspack report generated from snapshots taken at the peak business hours.
• Monitored and tuned rollback segment, temporary tablespace, redo log buffer, sort area size.
• Implemented security protocols for the database.
• Scheduled jobs to run on daily/weekly/monthly basis.
• Extensively involved in design physical and logical models of the database.
• Provided 24x7 on-call supports

Confidential

Jr. Oracle DBA

Responsibilities:

• Performed requirement analysis, designed the Database (Logical and Physical).
• The work involved generating the Database structure at the client site.
• Optimized performance, allocated system storage and planned future storage requirements, configured the Database of clients in client-server mode.
• Created Production Database from Development Database at client site.
• Inspected alert log file, monitored table spaces and partitions that span across several table spaces.
• Studied the client specification for creating Table and sizing Tablespace.
• Troubleshoot performance issues and bugs within packages, forms, and reports using dbms output, Forms debugger, explain plan and TKPROF.
• Planned, designed and implemented Backup & Recovery Strategies.
• Took Hot backups every night and Cold backups every weekend.