SUMMARY

• Over 8 years of experience as an Oracle DBA in Production, Development and Test environments, and transforming business strategies of various Fortune 500 and MNC organizations into efficient and integrated global business solutions. Proficient in an assortment of technologies, including Oracle 9i/10g/11g, MS SQL Server 2008, JDBC, Visio, VB.NET C#, Windows and Linux, Unix Environment.
• Experience in Configuring Single instance to multimode, Oracle Real Application Clusters (RAC) and Automatic Storage Management (ASM) and Data guard .
• Good exposure of Oracle DBA tasks Installation, Patching, Cloning, Upgrade of Oracle Databases.
• Management of schemas, objects & Partitioning the tables & indexes, USERS and PRIVILEGES.
• Worked extensively on created development, testing, staging, production, RAC and standby databases for OLTP and Data Warehousing using customized shell scripts and stepwise.
• Excellent knowledge in Hot/Cold Backup, Recovery, Cloning of databases using RMAN, VERITAS Net Backup and Experienced in Linux and Solaris using 11g network configuration (NETCA) Listeners, PL/SQL,UNIX Shell Programming.
• Worked in the setup of OEM cloud management.
• Worked on the setup and deployed self - service portal.
• Worked on the deployment of database lifecycle management.
• Integrated OEM with third party tools.
• Worked in solving complex technical issues.
• Worked on best practices and standard documentation.
• Backup of Databases (Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup etc.) using RMAN and other backup techniques.
• Recovery of Databases (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption etc.)
• Experience in using Tools like OEM, TOAD, Data Migrations & export/import.
• Excellent experience in Performance tuning of oracle databases using Oracle Grid Control, AWR, ADDM, TKPROF, STATSPACK, and tuning of SQL scripts using SQL Trace, Explain Plan, and Hints.
• Skilled in developing RMAN scripts for database back up including hot and cold backup options for both RAC and standalone instances.
• Data loading using SQL*LOADER, Logical backups using full export and DATAPUMP.
• Excellent experience in applications using ORACLE SQL Scripts, PL/SQL, Shell Programming.
• Ability to function successfully in a highly stressful, 24x7 mission critical environment.

TECHNICAL SKILLS

Operating systems: LINUX, SOLARIS, MS-DOS, NT, Windows 95/98/XP/7/ 2000, Windows Advanced Servers 2000/2003.

Databases: Oracle 11gR3, Oracle 11gR2, 10gR2 RAC, 9i, 8i, SQL Server 2008.

Oracle Database Tools: TKPROF, Toad, OEM, SQL Developer, Grid Control.

Tools: & Utilities: Export/Import, RMAN, Data Pump.

Languages: C,VB.NET C#, Unix shell scripts, PL/SQL, Perl.

Web Tools: HTML, SQL NET, ODBC, TCP/IP.

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

Oracle Database Administrator

Responsibilities:

• Configuration, Installation and maintenance of Oracle 11g RAC databases including ASM and CRS.
• Responsible for upgrade & migrating databases 11g from HP-UX to Linux.
• Performed upgrades from Oracle 10g to 11g and applied patches.
• Worked on this project as Oracle Core DBA. Planning and scheduling Backups, Database Recovery, taking Logical Backups (with Export /Import), Database backup (Hot & cold).
• Assisted in management and database administration of Oracle database applications on Exadata platforms.
• Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects.
• Worked on Features: Data Pump, ASM and RMAN. Data Base Recovery (complete & Incomplete).
• Proficient in managing Oracle Instance, database storage structure, schema objects.
• Experienced with SRVCTL, OCR and Voting Disk of 10g, 11g RAC.
• Involved & performed Data Base Change Requests for major DB changes. New DB creation, Existing DB deletion, various DB Housekeeping activities. Implemented 11g RAC on a test basis.
• Administration of all database objects, including tables, Indexes, views, sequences, packages and procedures.
• Installing ASM environment and migrating database from NON-ASM to ASM.
• Experience in Planning Database, Sizing table space, Create database, scripts, Monitor databases, Interact with developers, Oracle Install, Upgrade, 24x7 production support.
• Skilled with STATSPACK, AWR, ADDM, SAR to check health of database & hardware.
• Adding the required User Logins, Groups and Users, Granting and Revoking Permission to/from the users. Co-coordinating with on-site counterpart as well as Clients and understanding requirements.
• Installation of Oracle database 11g software with RAC using Oracle Clusterware. Oracle Data Guard setup done for RAC. Installation of Oracle 11g management agent and grid control.
• Developed PL/SQL packages, Dynamic SQL, DML, DDL, Oracle tables, stored procedures, functions, Cursors, triggers and UNIX Shell scripts.
• Experience in Performance and Tuning databases using various techniques. Collected performance statistics memory usage, data storage.
• Generating Statspack reports and AWR and ADDM reports for Database for Application tuning and also database Partitioning.
• Created Cluster database, Cloning of Cluster database on Linux, start and stop Cluster database services.
• Exposure to Oracle Utilities and Tools like OEM, Import-Export, Auditing, RMAN.
• Worked in the setup of OEM cloud management.
• Worked on the setup and deployed self-service portal.
• Upgraded OEM 12.1.0.1 to 12.1.0.3.

Environment: Operating Systems: SunSparcSolaris64bit, RedHat Linux Oracle Database Server 10g/11g Programming Language/Tools: TOAD, PL/SQL Developer, OEM 12 C

Confidential, Richmond, VA

Oracle Database Administrator

Responsibilities:

• Responsible for installing, upgrading and configuring the Oracle environment by creating multiple databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance. -
• Create & Managing Database Structure, Storage Allocation.
• Used RMAN for backup and recovery jobs.
• Trace the SQL.
• Trace the frequently called procedures/packages and pinning them to improve the performance.
• Worked extensively on Performance Tuning.
• Cloned databases using scripts -setup and configuration of Data guard.
• Installed and configured Oracle Database on Red Hat Linux advance Server on Development -Involved in performance monitoring and tuning of the database.
• Involved in backup and recovery tasks using RMAN.
• Involved in disaster recovery planning.
• Administration of all database objects, including tables, Indexes, views, sequences, packages and procedures.
• Implemented database backups and disaster recovery strategies using RMAN. Developed technical documentation for disaster recovery.
• Work Confidential regular hours based on business demands. Provided 24x7 on-call production supports.

Environment: Operating Systems: SunSparcSolaris64bit, RedHat Linux Oracle Database Server 10g/11g, Programming Language/Tools: TOAD, OEM 12 C

Confidential

Oracle Database Administrator

Responsibilities:

• Installed Oracle 10g database on Sun Solaris, Red Hat Linux.
• Installed RAC on Oracle 10g and worked on ASM feature of Oracle and managed disk groups.
• Installed and administered Real Application Cluster (10g RAC) environments; adding and removing nodes to the cluster and handled performance tuning using AWR.
• Reviewing of database design document and creating ER diagrams, providing conceptual and logical data model and translating into physical database.
• Have worked on different environments like test, development and production databases.
• Haveworked on backup/recovery, performance tuning.
• Worked on OLTP and OLAP database systems.
• Installation and creation of Oracle 9i databases on Production and Test Solaris servers. Responsible for upgrade & migrating databases from 9i to 10g, applying patches.
• Experience in handling GUI software and OS.
• Database Restore using RMAN, Cold Backup and Export.
• Involved in Design and implementation of oracle 10g Data guard both physical/logical standby databases.
• Responsible for configuring database memory structure, managing storage allocation, creating user accounts, roles and privileges for DB operations and security maintenance.
• Managing database instances for production and test environments to ensure strong testing environment and smooth transition to production.
• Used impdp /expdp and SQL- loader to load data into tables.
• Utilized Oracle Enterprise Manager (OEM), Grid control to manage users, privileges, profiles, and schemas.
• Optimize JDBC and java stored procedure code. Provide stress testing and scalable using thin vs OCI driver. Web Logic EJB performance tuning.
• Automated monitoring the databases, performance parameters, and backup/recovery activities by RMAN and VERITAS Net Backup, running Cron jobs and write UNIX shells scripts for job automation.
• Performed database and memory tuning using tools like STATSPACK, TKPROF, EXPLAIN PLAN, OPTIMIZER and SQL tuning advisor.
• Interacted with data modelers, developers, application owners for gathering the required information and resolving various issues.

Environment: AIX 4.3.3, HP -UX 11.23, Solaris, Windows XP, Oracle 9i/ 10g RAC, OEM, Grid Control, RMAN, DBCA, Data Guard, Putty, TOAD 8.1,UNIX, Linux 4.0.

Confidential

Oracle Database Administrator

Responsibilities:

• Involved in performing migration from Oracle 10g to Oracle 10g RAC database.
• Supported Remote DBA Support for Oracle 9i/10g.
• Involved in Large data conversion project (Wachovia - wells) converting sql-server, Seibel and Oracle data to Oracle.
• Wrote PL/SQL Scripts, Packages and views to extract load and create data files using DTS and Sql server integration services (SSIS) in the Sql server 2005.
• Involved in NDM (Network Data Mover) and secure plus setup for file transmission between wells and Wachovia.
• Implemented Oracle Streams for the replication of data in Development to Production.
• Upgrade and Migration of Database from 9.2.0.6 to 10.2.0.2 and applying patches whenever required.
• Configuring database entries, monitoring and maintaining user security for all of the databases using Oracle Enterprise Manager (OEM) Grid Control and Enterprise Security Manager (ESM).
• Used Oracle Retek Extract, Transform and Load supporting replication and de-normalization for OLAP.
• Monitoring experience includes Oracle Enterprise Manager Grid Control and Quest Fog light.
• Troubleshooting on the databases for Application Server and Oracle database related issues.
• Used ERWIN for logical and Physical database modeling.
• Developed PL/SQL packages, Dynamic SQL, DML, DDL, Oracle tables, stored procedures, functions, Cursors, triggers and UNIX Shell scripts.
• Developed Perl Scripts in order to provide reports.
• Involved in Peoplesoft Project Migrations and responsible for configuring and running applications servers and Process Schedulers.
• Used Oracle Audit vault for generating reports of the databases, User priviliges and permissions.
• Involved in development and implementation of Data ware house and Data mart Design.
• Administration of Oracle networking using Sqlnet, Tcp/Ip and Listener setup for oracle databases.
• Created Heterogeneous services for accessing the database links from an Oracle database to SQL server database.
• Data Refresh from Production to Test and Development environments using RMAN Duplicate Database.
• Daily Health Checkup of the database using statspack, AWR, ADDM.
• Involved in Oracle Warehoused Builder creating Star schemas, Partitioned Materialized Views and logs utilizing Query Rewrite and Start Transformation.
• Created database objects like tables, indexes, synonyms, views etc. using SQL* Plus, used SQL*Loader control files to load data from external data sources into Oracle database.
• Perl Scripting, Shell Scripting, bash scripting and PL/SQL Programming to resolve business problems of various natures.
• SQL statement Tuning using Explain Plans and SQL Trace using TKPROF utility and AUTOTRACE utility.
• Created scripts for data migration from flat files and MS Access to Oracle.
• Involved in reviewing business object reports using Cognos.
• Developed ETL Process to load the data from .DAT files
• Analyzing tables and indexes for performance tuning. Optimizing database objects and streamlining applications.
• Optimizing Oracle RMAN and ASM environment.
• Monitoring CPU usage, I/O Contention, memory paging on UNIX server. Provide technical direction to system administrator.
• Worked with the business analysts throughout the development cycle, and provided post-implementation support, for data and report issues identified by customers.

Environment: Oracle 11g/10gRAC/10g/9i, Sun Solaris 9.0/10.0, IBM-AIX, SQL Server 2005, Oracle Streams, Toad, SQL*Loader, Network Data Mover (NDM), ASM, PL/SQL, OEM Grid, RMAN, Erwin 4.1.2.

Confidential

Oracle Database Administrator

Responsibilities:

• Installing and configuring Oracle 10gRAC database on Windows Platform.
• Installation and configuration of 9i/10g on Linux.
• Used SSIS to migrate data from Sql-server 2000 and 2005 to Oracle.
• Installation of Oracle 9i Data Guard.
• Implemented Oracle Streams for setting up reporting server.
• Involved in database design using Erwin and Relational/OLTP Modeling.
• Worked with DBA Team of 8 members and 24*7 Support.
• Maintained instances of around 1.5TB having around 3500 Users and 80 Production/ Development instances.
• Use of Oracle Advanced Security for Data Protection.
• Involved in Oracle Golden Gate Installation for replication.
• Monitoring includes Oracle Enterprise Manager, Grid Control, and Quest Fog light.
• Capacity Planning: Allocate system storage and plan future storage requirements.
• Database move from one node to other and Reorganize.
• Database Schemas Creation based on the logical models.
• 24 X 7 on call support of all production environments in --group supported by our team.
• Used Oracle Audit vault to manage audit policies across Oracle Databases.
• Utilized Various Raid levels such as mirroring and stripping with parity.
• Monitoring and maintenance of multiple databases for production, development, testing and Staging purposes using utilities like OEM and Toad.
• Perform Daily Monitoring of Oracle instances using Oracle Enterprise Manager, monitor users, table spaces, memory structures, rollback segments, logs and alerts.
• Applying upgrade patches, maintenance and interim patches on all the databases.
• Fetching, Analyzing and Loading data into the tables using Perl Scripts.
• Developed Extensive sub queries, PL/SQL procedures, Dynamic SQL, DML AND DDL functions, database triggers and Packages.
• Written Shell Scripts for the digitization of the Process
• Wrote Perl Script and ksh script to schedule multiple load tests during off-peak hours.
• Primarily responsible for 12 applications databases and for all applications supported by the team While in on call.
• Develops and executes a backup / disaster recovery plan for all databases and performance tuning of the database as and when required.
• Taken Backup and Recovery using RMAN.
• Involved to review and improve a VERITAS Net backup system.
• Controlling database changes and ensuring synchronization amongst different environments.
• Maintain database security and adhere to security policies designed by the client.
• Develop and Implement robust backup and recovery strategies for production as well as Development databases, which includes hot backup, cold backup, and export backup.
• Troubleshooting and Investigation of application Bugs, Oracle Bugs and Job failures.
• Tuning the database performance through STATSPACK/AWR/ADDM report.
• Guiding the application team to understand how the database works with their application.

Environment: Oracle 10gRAC/10g/9i, Red hat Linux 4.x, Windows 2003, SQL-Server 2000 & 2005, Oracle Streams, Data Guard, Toad 7.6, GoldenGate 9.5, RMAN, OEM Grid Control, and ERWIN.

Confidential

Oracle Developer/Oracle Database Administrator

Responsibilities:

• Oracle Configuration. Oracle Tuning.
• Coordinating Backup and Recovery operations over all databases, ensuring 100% recoverability.
• Performing Daily, Weekly and Monthly Oracle monitoring and maintenance tasks.
• Wrote Stored Procedures according to specs and control files for input to SQL*Loader utilities for loading data from external files into the Oracle database.
• Planning, Installation and Configuration of Oracle Database on the Server.
• Creation of Table space, Data files, Indexes, Rollback Segment and monitoring them.
• Creation of Users and Granting them privileges and roles.
• Performed Database Tuning. Performed Database Security and Integrity.
• Used extensive Sub Queries, PL/SQL procedure, DDL functions, database triggers and packages.
• Responsible for writing database programming to Store/Retrieve the information from the database using SQL.
• Designing and creating schema objects like Database tables, indexes, views, synonyms, and all schema objects in Oracle.
• Writing Pl/Sql procedures and functions. Writing shell scripts to automate the data loading.
• Monitoring the data loading jobs and tuning the Sql queries.

Environment: Oracle 8i, SQL Server 2000, UNIX (Sun Solaris), Windows (NT/2000/Advanced Server), TOAD, OEM, SQL*PLUS, Explain Plan, UNIX Shell Scripting, Quest software tools, PL/SQL navigator.