PROFESSIONAL SUMMARY:

• Having 8 years of experience in installation, migration, designing, backup, recovery, scripting and performance tuning in development, test and production databases (OLTP and OLAP databases).
• Installed oracle database server on SOLARIS, HP-UX, AIX, WINDOWS NT, RED HAT LINUX.
• Clear understanding of Oracle 8i/9i/10g/11g and RAC Architectures, Oracle Enterprise Manager(OEM), relational database design, database administration, good exposure to UNIX flavors (Solaris, HPUX, Linux, AIX) and Windows operating systems and having strong analytical, problem solving and crises management capabilities.
• Managing mission critical data, planning, installing, and maintaining the Oracle Databases.
• Created schema objects such as Table spaces, Tables, Indexes, Constraints, Views, Materialized Views, Synonyms, Sequences, cursors and Triggers
• Involved in User Management and Database Security operations such as creating users, roles and granting roles and privileges
• Installed and Configured the Oracle Databases (8i/9i/10g/11g) RDBMS, Performing Pre-installation and Post-installation Tasks
• Data loading using SQL*LOADER, Logical backups and recovery using full export, full import and DATAPUMP.
• Moved partitions from expensive storage to cheap storage using RMAN
• Proven experience in SQL and PL/SQL
• Good co-ordination with UNIX administrators for efficient space management and issues on various servers.
• Implemented automated backup strategy and monitoring of databases using UNIX shell script CRON UTILITY
• Provided 24x7 On-call Support for Production databases
• A very good team player, self motivated, dedicated in any work environment.
• Work with on and offshore support teams to accomplish technical efforts in support of the business needs.
• Guide junior DBA staff members.
• Experience in database migration using Golden Gate on Red Hat Linux 4 servers.
• Data and Database replication using snapshots, materialized views, Golden Gate and Streams.
• Good at Implementing PL-SQL Coding Standards and writing policies and procedures like Hints, Indexes and Views.

TECHNIAL SKILLS:

Solaris 10/11, AIX 7.x/8.x, Windows 2003/2008/XP/Windows7, Linux.

RDBMS

Oracle 11g/10g/9i/8i, RAC

Languages

SQL, PL/SQL, UNIX Shell Scripting , Html and XML, ASP.NET, PHP, JAVA

Performance Monitoring Tools

Oracle Enterprise Manager

Tools/Utilities

RMAN, OEM, SQL*Loader, ASM, Export/Import, TOAD, Patch Management, ODBC, Data pump, Dataguard, command line, SQL Developer.

Oracle Net Configuration

Netmgr and Netca

Data Modeler Tools

CA Erwin 7, Oracle Sql developer data modeler

Performance Tuning

EXPLAIN PLAN, Data Dictionary Views, Dynamic Performance Views, Undo Management Advisor, Memory Advisor, MTTR Advisor, Segment Advisor, AWR and ADDM

PROFESSIONAL EXPERIENCE:
Confidential,Frederick, MD Nov ‘11 – Till Date
Sr. Oracle DBA
Wells Fargois a provider of banking, mortgage, investing, credit card, insurance, and consumer and commercial financial services

Responsibilities:

• Provide 24*7 supports to mission critical DBs ranging from 1TB to 15TB.
• Extensively use partitioning to maintain such a large size databases.
• Script and automate partition maintenance jobs.
• Work with Developers to fulfill their requests for new DB changes and tune SQLs/PLSQL code for them.
• Promote DB Schema changes through pipeline databases to production.
• Monitor performance and tune databases using OEM, AWR, in house tools/scripts and SQL tune etc.
• Implement, upgrade, patch and administer Oracle 10g/11g RAC databases running on ASM.
• Perform Database cloning using RMAN.
• Upgraded ASM instance from 11gR1 to 11gR2.
• Support data guard on 10g/11g.
• Moving terabytes of data from one storage to another.
• Re-organize database objects to gain space and improve performance.
• Work with Developers, review database changes and ensure that the database changes adhere to database standards and meet performance expectations.
• Managed database availability by replicating physical database by installing and configuring Golden Gate.
• Support Developers to write efficient database code (SQLs and PL/SQLs) for their applications.

Environment: Solaris 5.X, Windows NT, VMware, Oracle11g R2/10g R2, 7x HP UX 10.2/11.X, IBM AIX, RAC, AWR, ADDM, SQL trace, TKPROF, Golden Gate, TOAD

Confidential,East Rutherford, NJ Aug ’10 – Oct ‘11
Role: Oracle Administrator
The Federal Reserve Banksform a major part of theFederal Reserve System, thecentral bankingsystem of the United States. The 12 Federal Reserve banks together divide the nation into 12Federal Reserve Districts, the 12 banking districts created by theFederal Reserve Act

Responsibilities:

• Involved in Schema management, Table space Management, User Creation and management for the PLM domain. Monitoring the Extraction and loading processes of Data.
• Data Migration as part of enterprise data warehouse project.
• Logical and physical data modeling using Erwin.
• Created and corrected Materialized Views for Refresh Layer Population in Data Mart.
• Worked on Data Replication using Materialized views, Snapshot, Streams.
• Handled Performance and Tuning issues from code level to server level.
• Index creation and management for optimization of DB Processes.
• Installation of ASM into various storage parameters like SAN and NAS.
• Extensive use of tools like Explain Plan, AWR for tuning application and instances.
• Involved in I/O tuning by moving data files and redo log files to faster disks.
• Used analyze table, analyze indexes to tune queries and increase performance.
• Used hints for SQL tuning and optimization.
• Performed Explain Plan analysis for Query Optimization and SQL tuning.
• Monitored and tuned Java Applications. Involved in Java Memory management and Log analysis.
• Import and Export of Schema and databases across various stages of the project.

Environment: Oracle 9i/ 10g, SQL, PL/SQL, SQL plus, TOAD, Oracle Enterprise Manager, RMAN, Sun Solaris, ERWIN

Confidential,Strongsville, OH Nov ’08 – Jul ‘10
Role: Oracle DBA
National City Corporationwas aregional bankholding company based in Ohio, USA, it was once one of the ten largest banks in America in terms of deposits, mortgages and home equity lines of credit. SubsidiaryNational City Mortgageis credited for doing the first mortgage in America

Responsibilities:

• Installing Oracle, Creating Database, Database Support & Maintenance.
• Export / Import and Job Scheduling.
• Database Migration from Oracle9i to Oracle10g.
• Database Migration from Oracle10G to Oracle11g.
• Cloning of the database and applying the Upgradation patches.
• Developed various database monitoring shell scripts.
• Importing Data according to the users request and maintenance of Oracle Production, Development, and Testing Databases.
• Developer’s requests in terms of assisting them in effectively create tables, views, packages, sequences, schema refreshes.
• Issues related to Space Management, Locks, Database Hit Ratios, Backup failures and UNIX related On-Call alerts.
• Resource Management (Create and manage Indexes, Tables), allocate and manage physical storage structures like Datafiles, Redo logs, Control files. Allocate and Manage logical storage structures like Tablespaces.
• User and security management by using auditing, roles and profiles.
• Created databases for the applications keeping in view space & performance requirements for coming months.
• Performance tuning of Oracle 9i database (includes Oracle init.ora, Oracle SGA, I/O balancing and memory tuning)
• Implemented Oracle’s software striping on tablespaces for optimal performance using different disk drives.
• Designed proper indexing strategy on transaction tables for optimal performance.
• Converted very slow and complicated views to tables and implemented database triggers to update them automatically.

Environment: java, ORACLE 9i/10g/11g, Oracle 10g/11g RAC, Unix, ASM, RHEL 4.x, OEM, RMAN

Confidential,West Chester, PA May ’07 – Oct ‘08
Role: Oracle DBA
QVCis amultinational corporationspecializing in televisedhome shopping. QVC\'sU.S.operations are based in the Studio Park complex, which houses its corporate headquarters, studio and broadcasting facilities. Studio Park is the former corporate offices ofCommodore Business Machines.
Responsibilities:

• Created databases for the applications keeping in view space & performance requirements for coming months.
• Designed proper indexing strategy on transaction tables for optimal performance.
• Implemented nightly backup routines, which include database exports, and copying database files to the development server for precautionary measures.
• Implemented physical standby database.
• Customized the SGA (two init.ora files) for different types of requirements during the days & nights.
• Implemented new features of Oracle 8i like Log Miner, Transportable Tablespaces, Locally Managed Tablespaces

Environment: Oracle 9i/10g, SQL, PL/SQL, Linux, Solaris.

Confidential,Hyderabad, India Nov ’05 – Apr ‘07
Role: Oracle DBA

Responsibilities:

• Responsible for installing, upgrading and configuring the Oracle server.
• Created database objects such as tables, views, synonyms, indexes, sequences and database links.
• Responsible for optimizing the queries and application tuning.
• Implement Hot, Cold and Logical backup plans.
• Involved in Analysis & Design of the system that included an extensive interaction with the end users.
• Created Views for reporting purposes.
• Written SQL Loader Scripts for data extraction and transformation
• Developed PL/SQL packages, stored procedures, functions, Cursors, triggers.
• Partitioned large tables to increase the performance.
• Performed SGA tuning to optimize the database performance.
• Involved in SQL tuning with developers.
• Monitored the table space storages for database growth.
• Performed Capacity planning for databases to order SAN as per the database growth.

Environment: Windows 98/NT/2000, Red hat Linux 3, Solaris 5, Oracle 9i/10g, Oracle Enterprise Manager, SQL, PL/SQL, Toad, SQL*Loader.

Confidential,Hyderabad, India Aug ’04 - Oct ‘05
Role: Jr. Oracle DBA

Responsibilities:

• Systems Study, preparation of documents likes functional design specification, detail design specification and basic functional design.
• Involved in Installation of Oracle Software on servers and setting up backup servers.
• Created Non-Prod databases (DEV/SIT) and created schemas for application.
• Created objects in Non-Prod databases.
• Created PL/SQL procedures and SQL queries needed by the application.
• Used SQL* Loader utility to support flat file load into database tables.
• Performed data refresh from higher-level database to lower level databases.
• Involved in preparation of test cases and test scripts.
• Developed reports using Oracle Reports.
• Storage management like table space expanding and adding data files to table spaces.
• Responsible for Data Modeling including Logical and Physical Data Modeling.
• Interacted with end users to document product requirements.
• Performed SQL tuning, Package Tuning and Instance level tuning to improve performance.
• Planned and implemented Backup and recovery strategies.
• Involved in Product documentation.
• Provided 24/7 supports for resolving postproduction issues.

Environment: Oracle 9i/10g, SQL, PL/SQL, Linux, Solaris.