SUMMARY OF QUALIFICATIONS:

• Over SEVEN years of experience as DatabaseAdministrator in Production, Development and Testing Environments. Good experience in 24/7 Production Environment Support and considerable experience as an Oracle Apex Developer.
• Responsible for, both manage and support all Production, Development and Staging instances of Oracle Version 8i, 9i, 10g and 11g. Managing Very Large Database. Database backups and recovery using RMAN, Import/Export, Hot/Cold Backups, Data Pump tools.
• Experience in project life cycle includes Requirement gathering and Analysis, Databasedesign, Database development (SQL,PL/SQL), Test, Implementation & Support. Upgrading and Migrating of Database from lower version to higher version.
• Experience with Enterprise Manager Grid Control. Backup: Using OS backup (Hot and Cold).Oracle backups, generally through Export - Import utilities, also through Recovery Manager (RMAN). Worked on Database PerformanceTuning, SQLTuning and Optimization.
• Worked with SQL& other tools including creating database objects liketablespaces, tables, views, indexes. Administrating Database in various platforms like WINNT / 2000/ 2003, SUN SOLARIS 8/9, HP UNIX, Red Hat Enterprise Linux.
• Maintaining data integrity and tune database for optimum performance and availability. Excellent in troubleshootingOracleNetwork issues. Quick learner with ability to develop proficiency and adapt to new technologies and methods in a short period of time.
• Designed a solution with timelines by planning the Data Center Migration using standby configuration.
• DataCenter Migration options used are Export/Import with Data Pump, Cross-Platform Transportable Tablespace and Application specific methodology to capture changes and replay.
• Ability to develop Web Application by enhanced PL/SQL coding through Oracle APEX.
• Ability to move a group of databases within the same downtime window.
• Installation, Configuration and Automation of Oracle DBA Monitoring Tools. Ability to support and work within standard software development life cycle (SDLC) practices. Applying Patches for Database& Upgrading Database Versions.
• Implemented Graceful Switchover and Switchback between Production and Standby Databases. Ability to handle Projects and worked efficiently with other team members, Project managers, System Administrators & Application Developers. Also refreshing Database as per the requirements of the clients (CLONING).
• Implemented Disaster Recovery for Oracle Databases in Production .
• Evaluated and ensured the efficiency of application database backup and recovery procedures.
• Ensure that the database systems are well documented and that documentation is maintained in a timely fashion Develop and publish database administration best practices.
• Ability to perform database code migration, change management and data management through the various stages of the development life cycle.
• Ability to independently investigate, analyze and troubleshoot problems, to determine and provide accurate resolution and root cause.
• Excellent communication skill & Interpersonal skill.

CERTIFICATIONS:
SAP Business One Module.

TECHNICAL SKILLS:
Database: Oracle 8i/9i/10g/11g with Real Application Clusters, Data Guard, APEX.
Application Server: Oracle 7.3, 8, 8i, 9i, 10g,11g, 12c MS Access, (DBA admin) Oracle - Advanced Database, Backup Recovery, Database Architecture, System Architecture, Server Manager, (Tools): SQL, Exports/Imports, APEX.
Oracle Tools/Utilities: RMAN, EXP/IMP, EXPDP/IMPDP, SQL * Loader, DBVERIFY, TKPROF and STATSPACK, AWR, ADDM, OEM, ODM, Datagrid control, Dataguard, RAC, STATAPACK, TKPROOF, Replication, export, import, APEX, Datapump, Transportable tablespaces, OEM 12c.
ERP: Oracle DBA, Business Analyst, SAP – Business One Module.
Languages: SQL, PL/SQL.
Backup Tools: Cold, Hot, Export/Import, RMAN.
Operating System: Linux,Unix, Solaris and Windows NT/2000, XP, Windows 7.

PROFESSIONAL EXPERIENCE:

Nov. ‘12 – Current Confidential,
Oracle DBA/Apex Developer Bethesda, MD.
(Possess Active Public Trust Clearance)

Profoundly endowed myself as Oracle DBA to support the migration from the Legacy system to the New system by understanding the database structure and setting up the environment for Oracle database by installing 11g and later, per the requirement upgrading it to 12c.
Also, designed the backup procedures and the Disaster Recovery procedures to support the new system. I also worked as the Apex developer to Develop the iProcurementApplicationsystem roots and head it to the production bridge successfully.

Responsibilities:

• Provided strategic and technical expertise in Oracle database Infrastructure and Project application by developing on APEX.
• Planned database upgrading and designed platform for Oracle based application.
• Maintained monitoring and backup procedures for the database by automating the backupsand disaster recovery support for the production and development of Oracle database.
• Defined, documented and automated maintenance procedures to be used by offshore team in support of the environments.
• Configure listener and local service names to use load balancing, failover, dynamic serviceregistration and multi-threaded architecture for shared servers, RAC and data guarddatabases. Also use naming servers, hostname and service name resolutions depending on the connections requests.
• Worked extensively on 11G gridcontrolespecially monitoring the database, configuration of different notifications, installing and configuring agent, listener and databases and adding them to the grid control. Worked on setting up off Oracledataguard for the production database.
• Installing and setting upmanagementserver and enterprise manager. Generate and analyze STATSPACKreports and monitoring statistics for performance tuning of databases. Development support, coding standards, application&database tuning. Used OMS to gather the statistics highly efficiently.

• Critical Patch Update on all Oracle Components in every quarter. Capacity planning for all the Production and Stage Servers (Performance Analysis, Storage Growth and Automatic Storage Management and Grid Implementation).
• Oracle Enterprise 11g R2 installation and configuration in Linux.
• Perform RMAN operations (Incremental Backups). Helped developer to install OracleClient, troubleshoot and establish the connection to Oracle database through ODBC, JDBC. Performed SQLTuning by using explainplan and TKPROOF.
• Was responsible for incident management, identification, documentation and resolution.
• Ability to configure cluster databases and worked extensively with cluster configuration standards and an ability to troubleshoot RAC related OS and network integration issues on Linux and/or Solaris platforms.
• Cluster Database Installations and Upgrades (9i to 10g, 10.1.0.2 Patchset to 10.1.0.4 Patchset, 10.1.0.4 Patchset to 10.1.0.4.2/10.1.0.5 Patchset and 10.1.0.4.2 Patchset to 10.2.0.0 Patchset). Handling Critical, Emergency Issues in All Production Environments and On Call Support over the weekend (24X7 assistance).

Feb. ‘12 – Nov. ‘12 Confidential,
Oracle DBA Boca Raton, Florida.

Served as an DBA to enhance the Database administration capabilities by demonstrating trade-offs between logical design and system performance for Oracle databases with expert understanding of database performance tuning, data backup, recovery and security processes/ procedures.

Responsibilities:

• Worked on database performance tuning, data backup, recovery, architecture, security processes / procedures and Oracle Auditing in compliance with SOX/PCI policies.
• Defined, documented and automated maintenance procedures to be used by offshore team in support of the environments.
• Managed Offshore team in respect to all the environments constituting Production/Development and testing.
• Worked as an Apex developer too for creating in-house application for Oracle database infrastructure.
• Shared rotating on-call responsibilities for incident escalations, peer reviews and approving tasks prior to implementation.
• Performed some continuous capacity planning and analysis of existing infrastructure usage as it pertains to both physical and logical CPU memory and storage.
  Worked with remote and on-site resources in the planning and coordination of project implementation tasks.
• Was responsible for incident management, identification, documentation and resolution while in an on-call rotation.
• Accountable for partnering for application development and support teams on company project initiatives and is responsible for the project estimation review, capacity analysis, design, validation of standards and successful implementation of core responsibilities in a timely manner by even supporting internal technical support teams to design, implement and support database disaster recovery plans.
• Performed Database upgrade patching including the planning, testing and analysis using SQL Performance Analyzer to determine execution plan changes with 11g.
• Involved in strategic planning of upgrades and CPU/PSU patch rollouts across the enterprise.
• Used Datapump Export/Import Utilities for User migration, Tables, Databases, etc.
• Configured and done tuning of the Oracle RAC infrastructure using ASM in accordance to cluster configuration.
• Ability to configure cluster databases and worked extensively with cluster configuration standards and an ability to troubleshoot RAC related OS and network integration issues on Linux and/or Solaris platforms.
• Also, worked on cluster cloning from binary backups.
• Implemented RMAN - including cloning, recovery with and without catalog, catalog maintenance, archive management and catalog reporting.
  Also, held accountable for Virtual Tape libraries and the configuration requirements and monitoring of RMAN using Net Backup.
• Worked on OEM – agent management, application-tier management and configuration,
  Gateways – Configuration and management.
• Implemented Data Guard/Standby database both logical and physical.
• Performed Disaster Recovery on a quarterly basis in integration to other enviroments in the company.
• Worked on Oracle APEX for developing in-house web application for OD employees.

Environment: Unix, Linux, Sun Solaris, Toad, SQL Developer, ASM, Dataguard, Disaster Recovery, Grid Control, SDLC, SOX/PCI Audit, Audit Vault, OEM 12c.

Sept. ‘11 – Jan. ‘12 Confidential,
Oracle DBA Exton, Pennsylvania

Emphasized in providing database support to the application development teamsand in some cases, directly to end-users. Lead the team supporting the database management systems. Help the Technical Support staff and management to prioritize and implement the tasks necessary for the stable operation of the database management systems.

Responsibilities:

• Worked as a Central DBA by developing & maintaining naming standards for database objects such as tablespaces, tables, indexes & views and worked with database migrations.
• Upgradedthe current Oracle database version to 11gR2 in production, development and testing environments.
• Provided functional guidance to the systems programmer & the operator for oracle databases to the Unix System Administrators for evaluating & testing DBMS related software, develop operational procedures and supporting, monitoring & tuning the database subsystems & instances.
• Developed &implemented database administration policies & procedures including subsystem or instance security guidelines.
• Developed purge/archive criteria and procedures for historical application data and monitored and tuned memory usage for Oracle databases.
• Implemented, maintained, and tested backup & recovery strategies.
• Createdinstances and databases with appropriate initialization parameters and database structures (i.e., datafiles, rollback segments, tablespaces, etc.)
• Reviewed and monitored system and instances to insure continuous database operations (i.e., database storage, memory, CPU, network usage, and I/O contention)
• Performed database maintenance by moving, rebuild, or change database objects as required in production environments.

Environment: Red Hat Linux,Unix, PL/SQL Developer V6, TOAD, ASM, Dataguard, Oracle 11g/10g/9i RAC, , Auto-sys, SDLC, Plan view, SQL*PLUS, OEM, Grid Control, SQL Developer.

Oct ‘09 – Aug. ‘11 Confidential,
Sr. Oracle DBA San Antonio, TX

Supported over 200 Oracle Non-ERP Databases as well ERP databases. Few were sized in TBs. Worked on Data Center setups and Data Center move projects.

Responsibilities:

• 24/7 support for 200+ Production/Development/Testing databases.
• Worked on Database upgrades from 10g to 11g for 30 database in span of 3 months. Creating the database, tables, tablespaces, data objects, setting privileges, indexes, user logins, password (security).
• Creating new databases, configuring backups and maintaining the databases. Tune the databases and SQL queries. Backups using vendor specific tools and Oracle utilities like RMAN. The tuning and indexing the database and schema for efficient query executionplan.
• Provide Primary CARE DBA support for Oracle Administration, Configuration and Maintenance of RAC (Real Application Cluster) and Non-RAC Databases. Work within the production support team and maintain operational consistency and efficiency.
• Provide input to the Project and Enhancement teams to define database storage structures (tablespaces) after application developers have designed an application. Implementation of reviewed changes to the production databases. Developed some UNIXShell scripts to automate database operation and database monitoring.
• Used Export/Import to do table level and full database defragmentation. Provided on-call production database support. Creating Indexes and Monitoring Performance. Data loading using SQL Loader (from Text files to Database). Perform Daily Logical backups using exp.
• Extensive testing of all mission critical databases at different level (unit, system, integration)
• OEM 10g Grid Implementation for Production Monitoring.
• Application of Oracle 11g upgrade for OEM Grid.
• Oracle Enterprise 11g R2 installation and configuration in Linux.
• Perform RMAN operations (Incremental Backups). Helped developer to install OracleClient, troubleshoot and establish the connection to Oracle database through ODBC, JDBC. Performed SQLTuning by using explainplan and TKPROOF.
• Daily Monitoring Database and Tablespaces Growth and MonitoringSpace Availability at operating System.

Environment:Red Hat Linux, Sun Solaris 9.0, RHEL 5.2, PL/SQL Developer V6, TOAD, ERWIN 7.x, ASM, Dataguard, Oracle 11g/10g/9i RAC, Oracle 11g, Auto-sys, SDLC, Plan view, SQL*PLUS, OEM, Grid Control.

Nov ‘08 - Sep ‘09 Confidential,
Oracle DBA Secaucus, NJ

Worked on DBA Support for Oracle Collaboration Suite, Oracle Application Server Environments and Replicated Databases.

Responsibilities:

• Primary DBA for production, development and testing databases. Install and configuring Oracle database 9i, 10g, Linux. Implemented 10g flashback database features. Extensively worked on SQL Tuning using AWR, ADDM, ASH and tuning advisor in Oracle 10g.
• Cluster Database Installations and Upgrades (9i to 10g, 10.1.0.2 Patchset to 10.1.0.4 Patchset, 10.1.0.4 Patchset to 10.1.0.4.2/10.1.0.5 Patchset and 10.1.0.4.2 Patchset to 10.2.0.0 Patchset). Handling Critical, Emergency Issues in All Production Environments and On Call Support over the weekend (24X7 assistance).
• Oracle) Upgrades from 9i to 10g and Maintenance of Application Server Components like Email, Files, Content, I-meeting etc. Maintaining and Administer Oracle Databases and Applications.
• Oracle Enterprise Manager (OEM 10g) installation, configuration and implementation.
• Maintaining the existingOEMand customize monitoring environment.
• Monitoring and performance tuning.
• Supporting, monitoring & tuning the database subsystems & instances, this includes starting and stopping the instances, listeners.
• Carrying out application performance tuning and testing.
• Review SQL performance and Tuning.
• Critical Patch Update on all Oracle Components in every quarter. Capacity planning for all the Production and Stage Servers (Performance Analysis, Storage Growth and Automatic Storage Management and Grid Implementation).
• Gather Database and User Level Statistics and Analyze OverallSystemPerformance. New Production/Stage RAC (Real Application Clusters) and Non-RAC Database Environment Setups, configurations, maintenance and administration. Applying Database patches.
• SQL/Database InstanceTuning by running AWR/ADDM reports, Using SQL trace and analyzing trace files generated with trace events (High level of tracing of Optimizer and SQL performance with events 10053 and 10046 etc), recommend any changes required.
• Database Backup/Recovery - Monitoring hot backups and Monitoring Archive log Destinations (Setup RMANRepository andwriting Backup and Recovery Scripts). High Availability - RAC, Standby Setups. Logical and Physical DatabaseDesign (Structural Design ofDatabases).
• Tablespace Management, objects creation and user management.

Environment: Oracle 10g/9i/11g, Sun Solaris, Red Hat Linux, HP-UX, Oracle Enterprise Manager, SQL, PL/SQL, TOAD, RMAN, TKPROF, Stats pack, SQL* LOADER, Windows NT/2000.

Dec ‘07 - Oct ‘08 Confidential,
Oracle DBA Offshore, India.

• Worked as a DBA for maintaining 130 Oracle Instances versions 8i, 9i and 10g Rel2. Interacted with application owners in understanding their requirement and issues with respect to Oracle databases and applications.

Responsibilities:

• Supporting Database running on 4 node RAC setupConfigure ASM database for space management. Configured Physical Standby Database as DR for Productiondatabase using Data Guard. Configured 10g Gridcontrol for Oracle Databases located in different servers.
• Implemented 10gLoad Balancer advisor used by 4 nodeRACsetup. Implemented 10g segmentManagement for De-fragmentingdatabase. Develop, implement and schedule database backups using RMAN.
• Performance monitoring, tuning and troubleshooting production Oracledatabases. Tuningincludes - SQL, memory, I/O, O.S, procedures and packages. Major De-fragmentation of tables and indexes extensively used for DMLs over a year and released space over 70 GB.
• Worked on Patching, Cloning for Oracle 11iApplication along with Application DBA. Used RMAN extensively for backup and recoveries/restorations. Documenting procedures about change management, Work order, new configuration and Installations.
• Installed different database for development and testing databases. Creation of user accounts, security aspects, access controls and profile handling. Granting roles and privileges to the users and compilation of procedures etc.
• Created primary database storage structures, primary objects like views, indexes and Modifying database structures, as necessary once application developers have designed an application.
• Actively involved in implementing the requests and provide services such as creating Logical and PhysicalStandby\'s, SQL tuning, SQL and PL/SQL coding and review. Export & Import of Databases from one server / schema to another server / schema.
• Backup & Recovery implementations for both Application and DB.

Environment: HP-UX 11.23, Solaris 9, Windows XP, Oracle 9i/10g, RAC, OEM, RMAN, Grid Control, DBCA, Data Guard, HTML, Java, XML, Load Runner 8.0, TOAD 8.1, UNIX, Linux 4.0.

May ‘07 - Nov ‘07 Confidential,
Oracle DBA Richmond, VA

Involved in Functional Design Review and preparing the Detail Design Document. Also involved in creating and maintaining database objects including scripts to build all database objects, coordinating, scheduling and implementing database schema and software changes on all the environments.

Responsibilities:

• Responsible for 24 X 7 Production database administrations, support and monitoring. Coordinate and work closely with the Application team, gather requirements from application team. Design databasestorage layout plans based on requirements of application team for databases.
• Tweak databases for performance and tuning using Explain Plan, hints, AWR/ STATSPACK and Enterprise Manager. Moved database Schema changes to stage or production. Planned, tested and implemented backup strategies using RMAN, OracleUtilities (Export/Import) and OS methods.
• Involved in loading the partner flat files into the OLTPdatabase. Also, developed the T-SQL stored procedures/functions to process these data and populate them in the appropriate destination tables. Created and configured an OLTP replicationdatabase for disaster recovery purpose.
• Troubleshooting and Tuning of production&RAC databases.
• Configure listener and local service names to use load balancing, failover, dynamic serviceregistration and multi-threaded architecture for shared servers, RAC and data guarddatabases. Also use naming servers, hostname and service name resolutions depending on the connections requests.
• Worked extensively on 10G gridcontrolespecially monitoring the database, configuration of different notifications, installing and configuring agent, listener and databases and adding them to the grid control. Worked on setting up off Oracledataguard for the production database.
• Worked with backup team and was responsible for configuration and implementation of backup strategies using RMAN. Monitoring of filesystem, Table spaces and OEM during ETL loading. Most recently Implemented Apps 11i and 10g as Portal integration. Proficient in using Oracle EnterpriseManager.
• Evaluated new features and enhancements in later versions of Oracle(10g) for possible implementations like Data Pump (EXPDP/IMPDP), Transportable Tablespaces, External Tables and Partitions.
• Worked on Database Resetting and Database Cloning. Cloning of various databases using various methods including create control file, RMAN. Define, enforce, document & track standards for managing databases in terms of capacity, integrity, security, performance and version control.

Environment: SQL, TOAD, RMAN, TKPROF, STATSPACK, SQL* LOADER, Windows NT/2000, DBCA, Data Guard, HTML, Java, XML, Load Runner 8.0, TOAD 8.1, UNIX, Linux 4.0.

Jan ‘06 - Oct ‘06 Confidential,
Jr. Oracle DBA / DB Developer India

Confidential,is a privately-held, international company. Megasoft Technologies wanted to migrate all of its historic data for the last 10 years as well as existing data along with applications to a RDBMS platform. Worked as a Junior DBA, interacted with the users for studying the existing running Applications.

Responsibilities:

• Participated in design discussions to support project and baseline work. Worked with application development staff to develop database architectures. Installing, configuring and managingOracle 10gRACcluster and ASM. Intensively worked on OEM Grid.
• Installation of patches and performed server software upgrades to latest releases of Oracle 9i. Plan database capacity and growth. Created and configured Datagaurd. Designed and implemented a failover solution based on an Oracle 9.2.0.7 standby database and developed scripts to monitor the transfer of archived redo logs.
• Installing and setting upmanagementserver and enterprise manager. Generate and analyze STATSPACKreports and monitoring statistics for performance tuning of databases. Development support, coding standards, application&database tuning. Used OMS to gather the statistics highly efficiently.
• Used AWR&ADDM for database performance and statistics. Managed day-to-day production databases. Created and managed users, roles and profiles, audited and monitored databases and user access. Created database objects, managed partitioned tables, managed table spaces.
• Monitored and tuned the Shared Pool, Database BufferCache and Redo Log Buffers for best performance. Troubleshooting and Recovery of Database from Data file losses. Backup and Recovery involving archiving, redo logs, datafiles using RMAN.
• Performing regular DBAActivities such as Backups, Modifying DatabaseStructures, Managing DatabaseStorage, Maintaining System Security, Profiles and Roles. Loading flat file data into tables using SQL*loader. Extensively used Exp, imp and data pumputilities to build changes.

Environment: Red Hat Linux, Sun Solaris 9.0, RHEL 5.2, PL/SQL Developer V6, TOAD, Erwin 7.x, ASM, Dataguard, Oracle 10g/9i.

Jul ‘04 - Dec ‘05 Confidential,
Oracle DBA India

Worked on a large environment as a member among team of 11 DBA’s, responsible for support of about 120 Oracle instances The project was to support Oracle database, managing user creation, patching, cloning, log file checkup, performance tuning of applications configuring Oracle application and backup and recovery.

Responsibilities:

• Responsible for administering and supporting production and development Oracle 9i Databases. Responsible for installing, upgrade and configuring the Oracle Server, Creating Databases, Storage Structures and Objects, Database Backup and Recovery, Monitoring and Optimizing Database Performance.
• Responsible for setting and managing user accounts, Granting required privileges to users. Creating primary database storage structures (table spaces, rollbacksegments, etc). Monitoring Scheduled jobs of the daily activities for the performance of all the databases.
• Prepare the documents of the process and knowledge transferring about the project to the new team members. Applied patches, keeping applications software bugfree and improving data integrity. Developing Hot, cold and logical backupscripts to automate the backup procedures.
• Oracle Database and SQLtuning using SQL Trace, Statspack, Explain Plan, TKPROF. Partitioning Tables by determining the suitable methodology to improve performance and manageability.
• Maintained all documents of Oracle Databaseoperations. Prepared documentation of database backup and recovery standards. Performing all daily Maintenance tasks. Interacting with Oracle Customer service as and when required.
• Writing scripts for the system and database for the effective functionality and report generation. Developed scripts for daily maintenance activity like analyzing the tables/indexes and monitoring their growth rate. 24X7 on-call database support for the production and development databases.

Environment: Linux, UNIX, Windows XP, Oracle 8i/9i, PL/SQL.

EDUCATION:
Master’s in Business Administration – MBA.(Information Technology Management).
Bachelor of Business Administration (Information Technology Management).