SUMMARY:

15 years of IT experience and over 11 years as an Oracle DBA and 8 years as SQL Server DBA. Strengths include software design and development with specialization in relational database design Physical and Logical , application development and database administration. Implemented and documented Enterprise Backup and Recovery methodologies, Standby Databases, SQL Server Replication, Performance Tuning, Log Mining, User Administration, User training, Knowledge transfer, Testing, Maintenance and Support. Involved in process changes related to SOX compliance efforts within the IT department. Security monitoring and establishing standardized processes. Implemented Backup Strategy with RMAN and VERITAS Media Manager. Have experience with Data Migration from Legacy systems and open systems Upgrading Databases from 8i/9i to Oracle 10g and SQL Server 2000 to 2005. Have demonstrated excellent talent to quickly adapt to different project environments with excellent communication skills and productive interpersonal skills. Also demonstrated good mentoring skills.

SKILL SUMMARY:

• Hardware/Operating Systems: MS-DOS, WINDOWS-NT/2000/2003, UNIX - HP-UX 10.0-11.11 ,
• SUN SunOS 5.x , IBM-AIX 5.2, Linux Red Hat 3.x, 4.x , VMware
• Development Languages: C, C , PASCAL, COBOL 85, Pro C, HTML, Perl Scripting
• SQL, PL/SQL, SQL PLUS, Shell scripting
• Databases: Oracle 10g/9i/8.x/ 7.x/6.0, SQL Server 7.0/2000/2005
• Application Servers: Oracle Applications E-Business Suite 11.5.9
• Hardware Platforms: IBM-PC Compatibilities, Sun Enterprise Servers E45K/E55K/E10K,
• HP-9000 Server, RS 6000, IBM xSeries/pSeries, Red Hat Enterprise Linux 5,
• EMC SAN
• Tools: RMAN, Veritas Netbackup, LOG Miner, TOAD, OEM, Reporting Services, DBVision, DTS, SSIS,
• SQL Profiler, Plan Analyzer, SQL Navigator, SQLLAB, SQL Server Enterprise Manager/
• Management Studio
• GUI: Oracle Developer 2000, Informatica ETL tool, Erwin, SharePoint
• ERP: Oracle Applications 11.5.9., PeopleSoft 7.X/8.X, JDEdwards XE23

PROFESSIONAL HISTORY:

Sr Consultant/DBA

Confidential

• Supporting a manufacturing environment running on heterogeneous environments including TOLLING, TRINITY, ACIS applications running on Oracle database.
• Refresh Development QA databases, perform Oracle SQL Server database installs,
• configure and setting up the databases, applying patches, perform backups and provide
• day-to-day user support.
• SQL server 2000/2005 databases Administrator for Empire Time Time and Labor database, ISS Real Secure database Internet Email security and E-Commerce applications. SQL server 2000/2005 Database Administration support activities includes database storage file maintenance, backup and recovery of databases, database security and user privileges, performance tuning and monitoring of databases, data archiving and purging, trouble and outage management of production and development databases.

Role:

• Manage day to day production support, including task identification and delegation work to team
• Facilitating issue resolution for all production issues in the databases. This includes being the on-call escalation point 24x7, making suggestions on how issues are resolved.
• Maintain the integrity of the production and development databases.
• Provide subject matter expertise for internal and external units and projects.
• Manage assigned service level performance measures.
• Participate in staffing/recruiting efforts for this organization.

Technical Environment: Oracle 10g/9i/8i, SQL Server 2000/2005, Reporting Services, Red Hat Enterprise Linux 5, Windows 2000/2003, SVRMGR, SQL, PL/SQL, SQL PLUS, OEM, SQL Loader, Import/Export utilities, Shell Scripts, Perl, Toad, Veritas Netbackup.

Sr. Database Administrator

Confidential

• Served as a database administrator managing Oracle and SQL Server databases. Responsible for DB migration from 8i to 10g, upgrades, patches and performance tuning.
• On-Call Support for production and critical database issues on a rotational basis
• Installed, configured and maintained Oracle 10g Real Application Cluster RAC .
• Set up and maintained oracle disaster recovery site using DataGuard.
• Utilized RMAN for backup and recovery strategy.
• Used shell scripting to automate backup
• Scripting Automation -- to save time for day to day activities
• Completed export and import of different databases using Oracle Export / Import utilities
• Table fragmentation tuning, partitioning the large table by date.
• Studied and analyzed the business requirements, designed entity relationship diagram using Erwin
• Installed Oracle database 10g, and upgraded Oracle 9i to 10g.
• Cloned and refreshed production database to testing and development environments.
• Provided all kinds of DBA support to development teams as well as production support to various applications.
• Troubleshot and resolved any database and/or application issues or errors that occurred
• Evaluated database performance statistics STATSPACK Performance Report to tune the environments
• Performed database tuning by using various tools, like Oracle Enterprise Manager and STATSPACK
• Monitored the various database activities by developing shell scripts and using various tools, QL Tuning using explain plan, TKPROF with SQL trace and SQL Tuning Advisor.
• Patched Oracle Database Server 9i and 10g using Opatch.
• Created and tuned Materialized views.
• Done some analysis about, when and what to summarize.
• Components of a materialized view table, metadata etc .
• Query rewrite.
• Complete and fast refresh.
• Fast refresh following conventional path, direct path, and partition DDL operations.
• Propagating changes to the MV data.
• Performance issues with MV.
• Alternatives to MV use and tuning manual refresh of summaries.
• Established database backup/recovery strategy for different databases
• Applied different recovery procedures for complete and incomplete recoveries depending on the type of failure.
• Modified database structures including tablespaces, tables, views, triggers, stored procedures as well as configuration and storage allocation to support application enhancement.
• Developed scripts to monitor the storage usage, object status for daily job
• Provided on-call support regarding production-related database problems
• Performed user and security administration activities, such as enrolling users, granting privileges to users, and maintaining system security.
• Knowledge about Oracle Enterprise Manager 10g GRID
• Assisted in creating logical and physical design of database schemas for new applications.
• Managed various database structures: Tablespaces, datafiles, control files, redo log files and rollback segments using OEM GUI tool and Server Manager
• Backed up a 365x24x7 database using warm backup method and performed bi-weekly exports of the database.

Database Administrator

Confidential

• Served as an Oracle Applications/Core DBA. Responsible for installation, upgrades, patches, TAR support, database tuning, cloning Oracle Apps in Dev environments. Duties included database creation, database tuning/reorganization, SQL statement tuning, backup/recovery, general troubleshooting, fire fighting, developer/integrator relations, script development, and documentation.

Database Administrator

Confidential

• Supporting a manufacturing environment running on heterogeneous vendor environments including Goods for Revenue Order Processing system , Peoplesoft HRMS version 8, JD Edwards, Manugistics Transport Management System, Datawarehouse, Control Tower, Synquest supply chain, Sales Logix system, Customer Relationship Management, Ecommerce, Biztalk EDI processing system, Team Foundation servers and Sharepoint.
• Refresh Development QA databases, perform Oracle SQL Server database installs,
• configure and setting up the databases, applying patches, configure disk arrays, perform backups and provide day-to-day user support.

Role:

• Upgrade the databases from Oracle 8i/9i to Oracle 9i/10g.
• Installed, created, maintained and supported Peoplesoft HRMS on Oracle database running on Windows platform.
• Involved in migrating legacy applications to open systems.
• Implemented enterprise wide backup and recovery solution for Oracle and SQL Server with Veritas Netbackup Datacenter.
• Administered Standby Databases.
• Implemented SQL Server Transactional Replication.
• Tuned the databases by adjusting the parameters based on the recommendations from Statspack reports.
• Improved the performance of the application by identifying and tuning the poor performing SQL statements.
• Estimated the size of tables, indexes, tablespaces, rollback/UNDO segments and redo log files.
• Used Oracle Partitioning and Materialized views extensively.
• Monitored and forecast the growth of the database objects for capacity planning.
• Reorganized the database objects based on the extents growth and size
• Configured RMAN catalog and registered databases in the catalog.
• Implemented Backup Strategy with RMAN and VERITAS Media Manager for Several Databases.
• Configured Oracle templates for RMAN to backup databases using VERITAS NetBackup.
• Installed and Configured Oracle Enterprise Manager OEM .
• Involved in working closely with the application development team for the Bug Fixes and escalations.
• Monitored the system response, archive log area, and rollback/UNDO contention and redo log file contention.
• Assisted programmers during bulk data-migration using SQL Loader and changing the database recovery model from FULL to BULK-LOGGED in SQL Server.

Software:

• Oracle 10g/9i/8i, SQL Server 7/2000/2005, Reporting Services, AIX 5.2, HP-UX,
• Windows 2000/2003, Peoplesoft 7.5/8.1.4, SVRMGR, SQL, PL/SQL, SQL PLUS, ERWIN, Cognos,
• OEM, SQL Loader, Import/Export utilities, Shell Scripts, Perl, Fog light, Quest Central, Toad, Embarcadero Change Manager tool, Veritas Netbackup, Veritas Volume Manager.

DBA/Developer

Confidential

• Worked for FedEx Ground, Pittsburgh, provided services in Administrating Oracle databases, Oracle Data warehouse and OLTAP databases on Oracle8i/8.0x Parallel Server with Advanced Replication, Standby Databases and front-end tools.
• Upgrading Databases from Oracle 7.x to Oracle 8.x.
• Developed utilities using SQL, PL/SQL and Shell scripting

Role:

• Installed Created, Maintained and supported Oracle database on 7/8i database on Sun Solaris and Windows NT platforms.
• Monitored and forecast the growth of the database objects for capacity planning.
• Reorganized the database objects based on the extents' growth and size
• Created tables, indexes, views, synonyms, PL/SQL stored procedures, functions, triggers, roles and assigned privileges to users.
• Performed various Oracle DBA functions including DB instance creation, back-up and recovery, gathering DB stats and improving overall DB performance.

Software: SUN Solaris 8, Windows NT/2000, Enterprise 10000/5500/4500, Oracle 8i/8.0.x., SVRMGR, PL/SQL, SQL PLUS, SQL Loader, PRO C, Import/Export utilities, Shell Scripting, Toad.

DBA/Developer

Confidential

• Worked for Fastech Inc, Philadelphia, provided services in various applications in database and front-end tools.
• Involved in development of Sales Force Automation System that allows users and the representatives of Market Source to feed the day to day data from web clients, replacing an earlier mainframe based application.
• DBA responsibilities include Data Migration from Legacy systems to Oracle, Upgrading Oracle 7.x Databases to Oracle 8.x, User Administration, Performance tuning, User training, Knowledge transfer, testing and maintenance of the system. Developed utilities for database maintenance.

Role:

• Installed, created and configured Oracle 8.x database on AIX UNIX and Windows NT platforms.
• Configured Oracle Application Server for web deployments.
• Developed thirty 30 forms reports using Forms 5.0 and Reports 3.0.
• Did Knowledge transfer to the Database Administrators who is working for Fastech Inc.,
• Created tables, indexes, views, synonyms, PL/SQL stored procedures, functions, triggers, roles and assigned privileges to users.
• Performed various Oracle DBA functions including DB instance creation, back-up and recovery, gathering DB stats and improving overall DB performance.
• Written programs in PRO C to export the data from text files to the Oracle database.
• Tuned the database by adjusting the parameters.

Software: AIX 4.3.3, Windows NT/2000, RS 6000, Oracle Developer 2000, Forms 5.0, Reports 3.0., Oracle Application Server 3.0, SVRMGR32, PL/SQL, SQL PLUS, SQL Loader, Shell Scripts, OEM