Career Summary More than twenty five years software industry experience, reflecting involvement in software development life cycle, data modeling, database designing, data migration, business analysis and including twelve years of database administration activities on NT, Linux and various UNIX platforms. Professional Skills Summary

• Served as Sr. Oracle Database Administrator on development, testing and production environments.
• Performed Oracle installation, database planning, applied patch, upgrade database, database recovery, database migration, database maintenance, supporting, monitoring, performance tuning on Real Application Clustering RAC and Standalone databases.
• Setup Oracle environment, OEM, 12C Cloud, RMAN, ASM, data guard, and conventional way auto backup cold and hot, database security, network setup, implement SQL Server 2005 databases, admin and support, auto database mirroring and failover.
• Database and SQL tuning using AWR, STATEPACK, TKPROF, ADDM, DBMS SQLTUNE, Explain Plan, TOAD, OEM advising, SQL Profile, OUTLINE and SPM.
• Performed Data migration and Data Loading from Mainframe, AS/400, VAX - RDB, DBMS, DB2, SQL DB to Oracle environments using Pro C, Sql Loader, PL/SQL, SQR, KALIDO DIW 8.0.
• Performed physical and logical database design for various Data Warehouse and Real Time applications using Designer-2000/6i, Erwin 4.0
• Installed and worked on Apache Tomcat, Netbeans, MS Visual Studio 2010.
• Expertise in development, maintenance, implementation, testing client server application using Developer-2000/6i, PL/SQL, SQR, C and Pro C.
• Developed Web application using ASP.NET, PHP, XML, HTML, Java, Developer-6i, Designer-6i.
• Developed stored package procedures and functions, and triggers.
• Developed and designed stored package procedure to generate any kind of auto dynamic SQL statement to load data from vertical data model to horizontal data model.
• Extensively worked on PL/SQL stored procedure for back end development
• Development of UNIX Shell scripting csh, ksh, TCL, sed, awk, window shell script.
• Development ad-hoc report for DSS system on COGNOS 7.2
• Formal training on MicroStrategy architecture and report, and Kalido DIW 8.0
• Experienced on Business analysis, user requirement, project planning, system design.
• Strong oral and written communication

Technical Skills Summary

• Hardware Platforms: IBM-RISC-6000, Unix, VAX, HP-3000/9000, ORG-SUPER MAX 68030, Sun-Solaris, ORG-RISC 6000, DEC-ALPHA, NT, Windows-2000/2003/2005, Virtual Machine.
• Operating Environment: AIX, UNIX, MS-DOS, VMS, Sun-Solaris, HP-UNIX, DEC-ALPHA, NT, Windows-2000/2003/2005, Linux.
• Oracle tools others: Forms 2.5/3.0/4.5/5.0/6i, Sql Plus, Reports 1.1/2.5/3.0/6i, Developer-2000/6i, Designer-2000/6i, ERWine-4.0, ER/Studio, Sql Net8, Sql Loader, ClearCase, VSS, OEM 10g/11g/12c, TOAD, COGNOS 7.2.
• Programming Languages: Java, XML, PL/SQL, C, Pro C, SQR, Unix Shell Script ksh, csh, TCL, HTML, Perl, MS-COBOL.
• Databases: Oracle 6.0/7.x/8.x/9.2.1/10g/11g, MySQL, SQL Server 2005/2008, DB2, PostGresSQL. Applications: Company Shares Holdings, Inventory Management, Financial Accounting, Banking System, Payroll, Order Processing, Manufacturing, Shipping, Pharmaceutical, Data Warehousing, SURS, Medical Claim Processing System, Health Care System and Database Maintenance Applications. Professional Experience Summary

Confidential

Sr. Database Administrator

• Recently working for DOT as a contractor for a short term project in implementing, migrating and managing Oracle databases to newer Solaris server with all the responsibilities as a Sr. DBA including data loading, and supporting users. The client has major applications for supporting DOT Web applications for US resident on Solaris environments. My job responsibilities as follow:
• Managed daily database operation and activities.
• Database administration, support, implantation, configuration and upgrade
• Implemented and configured OEM Cloud 12c with all the databases.
• Upgraded and migrated Oracle databases from 8i to 11g R2
• Migrated databases from old system to new system.
• Perform Oracle databases backup through RMAN utility
• Restore 8i and 11g databases in different servers using RMAN
• Perform SQL optimization using Oracle OEM, TOAD tuning advisor.
• Perform data migration through data pump and exp utilities.
• Designed and developed automated data load processes using batch file and SqlLoader
• Wrote shell script to backup database.
• Setup advance data security by data encryption transparent data encryption TDE

Environment: RMAN, OEM Cloud 12C, TOAD DBA Unix for Oracle 8i/11g.

Confidential

Sr. Database Administrator

• Recently worked for DOH as a contractor in implementing, migrating, supporting, and managing Oracle databases on RAC and Standalone environments with all the responsibilities as a Sr. DBA including data modeling, data loading, and supporting users. The client has major applications for supporting DC residences in providing them food and medical supplies, and immunization process, and the databases are setup on RAC and Standalone environments on Windows 2008 and Linux environments. My job responsibilities as follow:
• Managed daily database operation and activities.
• Database administration, support, implantation, configuration and upgrade
• Implemented and configured OEM Cloud 12c with all the databases.
• Upgraded and migrated Oracle databases from 9i to 11g R2
• Perform Oracle databases backup through RMAN utility
• Perform SQL optimization using Oracle OEM, TOAD tuning advisor.
• Gather daily database performance statistics using AWR report and ADDM advisor.
• Perform data migration through data pump and exp utilities.
• Performed ASM admin activities for maintain database file system.
• Installed and configured standalone database in replacement of RAC environment
• Designed and wrote ETL scripts to load data using batch file, Sqlldr and PL/SQL
• Performed daily maintenance and backup of nodes on RAC database.
• Wrote shell script to backup database.

Environment: RMAN, OEM Cloud 12C, TOAD DBA, ASM, RAC, Agent on Windows and Linux for Oracle 9i/11g.

Confidential

Database Team Lead

• Previously working as a contractor at US Mint for supporting and managing their Oracle and SQL Databases with due response of all kind of database activities, including upgrade and improvement database operation. There are 45 Oracle databases and 38 SQL servers support various applications for development, QA and production environment for non-commerce, financial, transportation, documantum and manufacturing etc. As a Sr. database administrator, leading a team of three database administrators, managing database projects and resources, maintaining, supporting and implementing all applications' databases such as Hyperion, OTM, Maximo, and Peoplesoft are running in Oracle and SQL Server on Linux and Windows platforms. My job responsibility as follow:
• Manage database projects, daily database operation, client requests and resources
• 24x7 database support on rotation basis
• Database administration, support, implantation, configuration and upgrade
• Implemented and supporting Data Guard, OEM Grid, OMS App., Oracle WebServer,
• Installed, troubleshoot and configured 11g Agent with OEM Grid.
• Upgraded and migrated Oracle databases from 9i to 10g and 11g R2
• Upgraded SQL Server 2000 to 2005 and 2008
• Implemented database partitioning on large databases with interval and range partition.
• Applied Oracle CPU/PSU patches on regular basis.
• Developed SQL script to remove Oracle DB vulnerabilities as per STIG requirements.
• Perform Oracle databases backup through OEM and script using RMAN utility
• Perform SQL tuning using DBMS SQLTUNE, SQL PROFILE and auto explain plan
• Gather daily database performance statistics using AWR report and SQL scripts
• Setup auxiliary databases through RMAN, data migration through DB dump and exp utilities.
• Installed Linux O/S, missing rpm libraries and configured kernel parameters for Oracle.

Environment: RMAN, Data Guard, OEM Data Grid, TOAD DBA, WebLogic, Shell Script, Agent on Linux/Windows for Oracle 9i/10g/11g, SQL Server 2005/2008.

Confidential

Database Administrator

• Worked at an Army Hospital, Walter Reed Medical Center, as a database administrator in performing database duties for Oracle and SQL Server databases in production and development environments. Several applications were used by Army personnel, Doctors and other DOD employees to get mandatory training certifications, medical information and other confidential information. My job responsibility as follow:
• Database administration, monitoring, implementation, configuration, support and tuning.
• Provided suggestion and improvement in database design and SQL coding.
• Provided support to the application users for database issues.
• Installed physical standby database of production database and configured Data Grid Control
• Installed and configured OEM Data Grid admin tool, Agent and OMS Application server.
• Gathered database performance statistics using AWR report and SQL scripts
• Implemented RMAN backup and Data Guard setup, and automated the backup process
• Upgrade database 10g to 11g.
• Configured OEM Grid control to monitor SQL Server 2005 databases.
• Applied Oracle and SQL server latest patches.
• Wrote a process to automate database mirroring and failover on SQL Server 2005 for 69 databases.
• Setup SSIS to load dynamic flat file information into SQL server database.
• Setup heterogeneous service setup with Intersystem CACSE' DB.
• Physical and logical database design for MILPERSIS application.

Environment: RMAN, NT Script, Data Guard, OEM Data Grid on Windows 2003 for Oracle 10g/11g, SQL Server 2005.

Confidential

Oracle DBA

• Worked at a health insurance organization which is a subsidiary of Blue Cross and Blue Shield insurance company, provides various web based marketing tools to help their consultants and sales persons to present BCBS's medical plans network, discount, employee and employer search, plan scope and network comparison with the competitors like Aetna, Cigna, United Health Care etc. There were 25 various sizes of Oracle 9i and 10g databases from 150G to 2TB in size to support development, test and production applications, data warehouse and data mart. Job responsibilities included:
• Installed Oracle databases on Linux and window environment.
• Performed database support and maintenance on development, test and production environments.
• Performed database backup and recovery using RMAN and conventional method.
• Performed physical and logical database design for data warehouse and data mart design.
• Managed table partitioning on data warehouse and data mart.
• Applied latest CPU and PSU patches for the databases.
• Performed database and SQL performance tuning.
• Database migration and database upgrade from 9i to 10g,
• Wrote Unix shell scripts to perform database online and offline database backup.
• Attended formal training for Micro Strategy architecture and reporting.
• Setup failover databases data guard for all production databases.
• Wrote Unix shell script to switch over primary to standby and standby to primary.
• Automated data loading process of various data sources using PL/SQL, SQL Loader and Unix script.
• Actively participated in business analysis, requirement gathering, data modeling and database design.
• Designed and developed data loading process auto generated dynamically SQL scripts to load data from vertical to horizontal data model in the datamart using PL/SQL.
• Worked on Kalido DIW tool to setup data model and load data in the application databases.

Environment: ERWin, PL/SQL, RMAN, NetVault, Sql Loader, Unix Script, TOAD, Kalido DIW 8.0, OEM, Oracle 9i and 10g, Micro Strategy, Linux