Summary:

Over 9 years experience as ORACLE DBA (8i/9i/10g/11g) on different Operating systems including: AIX, Linux, Red Hat Enterprise Linux, HP-UX, Sun Solaris (5.6/5.7/5.8/5.9) and Windows 2000/NT/XP.

• Experience with working in production (24x7), staging, development and test databases.
• Responsible for performance tuning and optimization at both the application level and database level.
• Expert in installation and configuration of Oracle 8i/9i/10g database on various operating systems including: Sun Solaris, HP-Unix, Red Hat Linux and Windows 2000/NT/XP servers in production and development.
• Installing/Configuring and maintaining Real Application Cluster Database. This includes: determining the cluster architecture, choosing the best MPP RAC servers and hardware configuring the raw disks for Oracle RAC.
• Worked on Data Replication to improve performance and increase availability of applications.
• Experienced in tuning and diagnosing database performance by query optimization and trace utility. Used AWR, statspack, ADDM, utlbstat, utlestat utilities, explain plan, and tkprof.
• Extensively used Oracle Enterprise Manager (OEM), Toad and SQL Navigator for maintaining and monitoring databases.
• Involved in logical and physical Data Modeling using ERWIN forward-engineered into DDL and executed on a large scale to create database.
• Experience with VERITAS File System on Solaris. Experience with installing, configuring and administrating VERITAS Net Backup software.
• Experience in various large critical OLAP and OLTP databases.

Technical Skills:

Operating Systems UNIX, Sun Solaris 5.6/5.7/5.8/5.9, Windows NT, Windows 98/2000, Windows XP,
HP-UX 10
Languages SQL, PL/SQL, Shell Programming, UNIX, C, C++
RDBMS Oracle 8.0, 8i, 9i, 10g,11g
Tools ERWIN 3.2, 4.0, 4.14, Oracle Enterprise Manager OEM, TOAD 8.5/8.6/9, F-Secure Client 5.3, VERITAS Volume Manager, VERITAS Net Backup, RMAN, UTLSTAT, Explain plan, TKPROF, HUMMING BIRD 10, SQL*Net/Net8 , AWR and ADDM.
Utilities SQL Loader, Exp/Imp, Data Pump expdp / impdp, TKPROF, statspack
Protocols FTP, SFTP, SSH, TELNET and TCP/IP

CERTIFICATIONS:

• Oracle Certified Professional (OCP) 9i and upgrade to 10g for DBA

Introduction to Oracle: SQL and PL/SQL 1Z0-001
Oracle 9i Database: Fundamentals I 1Z0-031
Oracle 9i Database: Fundamentals II 1Z0-032
Oracle9i Database: Performance Tuning 1Z0-033
Oracle Database 10g: New Features for Administrators 1Z0-040

Professional Experience:

Confidential, Apr 2008 - Till date
Los Angeles, CA

Role - Senior Oracle DBA

Description: Confidential, is a diversified financial services company providing banking, insurance, investments, mortgage and consumer finance through almost 6,000 stores, the internet and other distribution channels across North America and internationally. With their headquartered in San Francisco, but they are decentralized so that every local Wells Fargo store is a headquarters for satisfying all their customers\' financial needs and helping them succeed financially. Wells Fargo has $609 billion in assets and 160,500 team members across our 80+ businesses.

Responsibilities:

• Installation, upgradation and maintenances of Oracle databases on Linux and Windows platforms.
• Performed upgrades with the team and upgraded all machines from Oracle 10g to Oracle 11g
• Responsible to test and implement the new features of Oracle 11g including: working on aspects
  of Database Replay, partitioning, Transaction Management, SQL Performance Analyzer, etc.
• Explored and worked on innovative new features of Oracle 11g in terms of Automatic Health Monitor, Automatic Diagnostic Repository and other resiliency features.
• Backup of database using Logical and Physical (hot and cold) procedures and also RMAN.
• Recovery of database in case of database crash, disk/media failure, etc.
• Provided system support for both development and 24/7 production environment.
• Strong and extensive use of DDL and DML tools. Maintained database schemas and dictionaries.
• Performed capacity planning and sizing of databases based on input from business.
• Took care of all alerts for space issues and user requests.
• Created and managed the Server Parameter file.
• Configured optimal Oracle 9i/10g RAC architecture.
• Performance Tuning for Oracle Real Application Clusters (RAC).
• Involved in developing initiatives as well as business as usual. Interacted with business users and created software requirements specifications.
• Performed database monitoring, capacity planning and performance tuning.
• Managed database security. Create and assign appropriate roles and privileges to users depending on the user activity.
• Prepared plans for upgradation of all critical Production Databases from 9i to 10g on Linux and DATAGUARD implementation.
• Analyzed the database so as to allow Oracle optimizer to choose best plan in executing the queries.
• Performed logical design, modeling, E-R diagram activities using Data Modeling Tools, normalization, indexing, foreign key, and constraints.
• Loaded data from flat files using SQL Loader.
• Configuration of tnsnames.ora, listener.ora and sqlnet.ora files after upgrading databases.
• Performed database cloning from old system to new system.
• Deactivated unnecessary reports and programs from the system.
• Converted rollback segment tablespaces from Dictionary managed to locally managed tablespaces.
• Used EXPORT/IMPORT for table level and full database de-fragmentation.
• Implemented and tested backup strategies.
• Used VERITAS NET BACKUP SOFTWARE to protect, and recover data across storage tiers, locations, and operating systems.
• Transported tablespaces between production and development databases.
• Deleted large number of records from the tables and reorganized all tables for better performances.
• Ran scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation, etc.
• Experienced in escalation of different critical TARs.

Environment: Oracle 10g, 9i RAC, Server Red Hat Enterprise Linux Advanced Server/Enterprise 2.1/3.0, Windows Server 2000, UNIX Shell Scripts, VERITAS NET BACKUP,TOAD, Tkprof and SQL*Net/Net8

Confidential, Apr 2007 - Mar 2008
Allen Town, PA

Role - Senior Oracle DBA

Description: PPL Corporation has emerged as a company that is reinventing the way customers and investors think about electricity and natural gas. PPL Corporation believes the future belongs to energy companies that understand customer needs and are focused on deliberate growth that maximizes share owner value. Headquartered in Allentown, Pa., PPL controlsmore than 11,000 megawatts of generating capacity in the United States, sells energy in key U.S. markets, and delivers electricity toabout 4 million customers in Pennsylvania andthe United Kingdom.

Responsibilities:

• Set up and maintained Oracle disaster recovery site using DATAGUARD.
• Performed performance tuning by using Oracle utilities like Stats Pack, Tkprof for addressing performance bottlenecks.
• Utilized RMAN for backup and recovery strategy.
• Completed export and import of different databases using Oracle Export/Import utilities.
• Table fragmentation tuning and partitioning the large table by date.
• Installed, configured and maintained Oracle database 10g and upgraded Oracle 9i to 10g.
• Provided DBA support to development teams as well as production support to various applications.
• Created and maintained different database entities including: tablespaces, data files, redo log files, rollback segments and renaming/relocating of data files on servers.
• Troubleshooting and resolution of any database and/or application issues or errors that occurred.
• Responsible for checking Oracle database MAX parameters and planning for recreation of control file whenever required.
• Resolved users problems, recovered database on demand. Created and managed database objects. Partitioned when implementing Oracle VLDB.
• Performed tuning using OMS.
• Implemented the access control and security using profiles, roles and privileges.
• Performed database tuning by using various tools like: Oracle Enterprise Manager and STATSPACK.
• Performed daily monitoring of Oracle instances using Oracle Enterprise Manager, TOAD, users, tablespaces, memory structures, rollback segments, logs, and alert.
• Monitored the various database activities by developing shell scripts and using various tools.
• SQL Tuning using explain plan, TKPROF with SQL trace and SQL Tuning Advisor.
• Installed and configured 10g Enterprise Manager and Grid Control.
• Patched Oracle Database Server 9i and 10g using Opatch.
• Established database backup/recovery strategy for different databases.
• Applied different recovery procedures for complete and incomplete recoveries depending on the type of failure.
• Applied upgrades and patches, developed development standards and naming conventions, consulted developers, conducted code review and integrated third party tools with Oracle application.
• Setup and support of Oracle replication (replication and conflict solution).
• Modified database structures including tablespaces, tables, views, triggers, stored procedures as well as configuration and storage allocation to support application enhancement.
• Developed Shell scripts to monitor the storage usage and object status for daily job.
• Provided on-call support regarding production-related database problems.
• Worked with IT managers and application developers to ensure the database integrity, high availability and security.

Environment: Oracle 9i /10g, HP-UX 10.2/11.0,SUNOS 5.8, Windows NT 4.0, Windows Server 2000, Erwin 4.14, Unix Shell Scripts, TOAD and SQL*Net/Net8

Confidential, Mar 2006 - Mar 2007
Reston, VA.

Role - Oracle DBA

Description: Confidential, has a federal charter and operates in America\'s secondary mortgage market to ensure that mortgage bankers and other lenders have enough funds to lend to home buyers at low rates. Fannie Mae helps those who house America. Fannie Mae has a unique duty to the public it serves -- and the private investors that fuel its service -- to be a model company focused on service, reliability, and value.

Responsibilities:

• Administered all database installation, creation, modification, and tuning issues of Oracle.
• Database Security Administration involved: creation of users and management of their roles and privileges.
• Configured databases using latest features of Oracle 9i like Undo-Tablespace, Locally Managed Tablespace, and Sorting Parameters.
• Experience with installing/configuring and maintaining Oracle 9i Real Application Cluster Database for high availability, scalability and performance which included: determining the Cluster architecture, choosing the best MPP RAC servers and hardware and configuring the raw disks for Oracle RAC.
• Analyzed the database to allow Oracle optimizer to choose best plan in executing the queries.
• Performed capacity planning and sizing of databases based on input from business.
• Ran Oracle stats pack to tune the databases.
• Performance tuning of Oracle 9i/8i databases included optimization of Oracle init.ora, Oracle SGA, I/O balancing and memory tuning.
• Partitioning of large tables.
• Responsible for understanding the existing Database Structure and suggesting the database reorganization.
• Pinned most widely used Tables/Objects in the Oracle Shared Pool.
• Tuned the Database Operations. Range Based Partitioning for Large Tables.
• Used Materialized Views/Views for Generating Reports.
• Wrote SQL scripts for DB monitoring, and online backups.
• Implemented Oracle Replication to enable database fail over incases of system or database crash.
• Checking of Alert log and Trace files to monitor the database on a daily basis. Also wrote monitoring scripts to check reports for space, Max. Extents, coalescing etc which are kept in CRONJOB.
• Installed, upgraded, configured and patched Oracle server and application software.
• Created users, granted permissions and coped with the day-to-day demand as well as troubleshot their connectivity, permissions and performance problems.
• Worked with users to determine system requirements.
• Database activities included: allocation and maintenance of Rollback Segments, Automatic Undo Management, table spaces, data files, redo log files, mirroring of redo log files across multiple disks.
• Experienced in using utilities like Export/Import and SQL Loader.

Environment: 10g/9i/ RAC, Linux Cent OS, SUNOS 5.7, WINDOWS NT/2000, RMAN, SQL*Plus, SQL, PL/SQL, SQL*LOADER, Oracle OEM, Import/Export Data pump, STATSPACK

Confidential, Apr 2005 - Feb 2006
Canton, MA.

Role - Oracle DBA

Description: Confidential, is an American-inspired, global brand that creates and markets sports and lifestyle products built upon a strong heritage and authenticity in sports, fitness and women's categories. The brand is committed to designing products and marketing programs that reflect creativity and the desire to constantly challenge the status quo.

Responsibilities:

• Performed Database performance tuning and monitoring.
• Designed and implemented security policies.
• Deployed roles, privileges, profiles and policies for a group of users
• Configured the auditing of a database at DB or OS level to monitor illegal use of database
• Utilized Oracle Export and Import utilities to perform logical database backup and recovery, move Oracle data from one machine, database or schemas to another and to detect database corruption
• Controlled and monitored user access to the database.
• Used File Transfer Protocol to transfer files from one location to another on local disks and across the Internet.
• Created schemas with partitioned external tables for a production environment using SQL Plus.
• Used Hints in Select Statements for Best Execution Plans. (After gathering statistics through Explain Plan, Analyzing the Table, Indexes).
• Configured the database for maximization of disk space utilization and memory utilization.
• Minimized the disk I/O to make the application faster.
• Administered Oracle 9i and infrastructure support using Oracle OEM.
• Performed tests and implemented upgrade of Oracle 8i databases to latest Oracle version (9.2.0) on UNIX.
• Performed requirement analysis and capacity planning for databases and system infrastructure.
• Created and managed multiple instances on one server for testing and development.
• Recovered and rebuilt databases on crashes and media failures.
• Configured and used Oracle Log miner and Oracle Flash Back for minor recovery of the objects.
• Populated Oracle tables with data from external and non- Oracle files using SQL*Loader utility.
• Used stored procedures for performing complex business logic involving database access and validating information
• Responsible for supporting the database with logical backup as well as cold and hot backups
• Created variety of triggers for object create, alter, drop, server errors, startup/shutdown and for logon/logoff.
• Built databases and refreshed them by executing the scripts.
• Developed Shell scripts for day to day database administration activities.

Environment: Oracle 10g/9i/8i, AIX 4.3/5L, Sun Solaris (SUNOS 5.9), Oracle 10g Client, Toad,
WINDOWS NT/2000, RMAN, ERWIN 3.2, SQL*Plus, SQL, PL/SQL, UNIX Shell Scripting, SQL*LOADER,
Oracle OEM

Confidential, Feb 2003 - Mar 2005
Madhapur, Hyderabad, India.

Role - Oracle DBA

Description: Confidential, is part of one of Asia\'s largest conglomerates, the Tata Group, which has interests in areas such as energy, telecommunications, financial services, manufacturing, chemicals, engineering and materials. Tata Consultancy Services Limited (TCS) is an Indian software services and consulting company. It is one of the world\'s largest providers of information technology and business process outsourcing services. As of 2007, it is Asia\'s largest information technology firm and has the largest number of employees among Indian IT companies with strength of over 110,000[1] employees in 47 countries. The company generated consolidated revenues of US $4.3 billion for fiscal year ended 31 March 2007 and is listed on the National Stock Exchange and Bombay Stock Exchange in India.

Responsibilities:

• Responsible for Oracle 8i logical and physical databases design, implementation and maintenance on UNIX.
• Active participation in a system study.
• Installed, upgraded and patched Oracle software. Set up brand new machines including Oracle software installation.
• Managed and resolved design issues during development.
• Moved database schema changes to stage or production.
• Migrated and upgraded databases from version 7 to 8i.
• Developed some UNIX Shell scripts to automate database operation and database monitoring.
• Developed or modified some Oracle backup and recovery scripts. Used Oracle backup utility RMAN to implement Oracle backup and performed a number of times of disaster recovery.
• Responsible for supporting the database with logical backup as well as cold and hot backups.
• Recovered database due to loss of data files either because of programs with bugs or accidental deletion during the regular purging by system administrators.
• Installation and configuration of Statspack and analysis of Statspack performance report and subsequent tuning of production databases.
• Implemented database refresh with the hot backup using DUPLICATE or full export. Used EXPORT/IMPORT to do table level and full database defragmentation.
• Performed database tuning using: Explain Plan, hints, utlbstat/utlestat, Toad, Power Explain, and Enterprise Manager.
• Use of Query Rewrite feature for efficient query running in materialized views.
• Managed and resolved design issues during development.
• Developed various tools for space management, recovery, data management, indexing, etc.
• Helped developer to install Oracle Client, troubleshot and established the connection to Oracle database through ODBC.

Environment: ORACLE 8.0/8i, HP-UX, Sun Solaris (SUNOS 5.6) RS 6000, ODBC, TOAD, SQL *PLUS, RMAN, Shell Scripts, Korn Scripts

Confidential, Aug 2001 - Jan 2003
Hyderabad, India

Role: Junior Oracle DBA

Description: Confidential, formed in October, 2000, is World\'s 7th largest Telecommunications Company providing comprehensive range of telecom services in India: Wire line, CDMA mobile, GSM Mobile, Internet, Broadband, Carrier service, MPLS-VPN, VSAT, VoIP services, IN Services etc. BSNL is the only service provider, making focused efforts and planned initiatives to bridge the Rural-Urban Digital Divide ICT sector. In fact there is no telecom operator in the country to beat its reach with its wide network giving services in every nook & corner of country and operates across India except Delhi & Mumbai.

Responsibilities:

• Installed and maintained Oracle 9.x/8.x for development, testing and production purposes.
• Installed and loaded new patches necessary for Oracle and other applications relevant to the Oracle versions.
• Managed and resolved design issues during development.
• Moved database schema changes to stage or production.
• Implemented database refresh with the hot backup using DUPLICATE or full export. Used EXPORT/IMPORT to do table level and full database defragmentation.
• Worked extensively on database sizing, rollback segments and queries.
• Created and maintained UNIX scripts for Oracle maintenance and statistics.
• Created stored procedures and triggers using PL/SQL for database managing utilizing TOAD developing environment. Worked with SQL queries in the Oracle database.
• Created tables, views, index, partitioned tables, and cluster table.
• Tuned application with explain plan and tkprof.
• Oracle installations/upgrades/backup and recovery.
• Configured databases for adequate performance and availability.
• Helped developer to install Oracle Client, troubleshot and established the connection to Oracle database.
• Implemented backup/recovery and database monitoring strategies using Unix Shell scripts and Oracle enterprise manager (OEM).

Environment: Oracle 8.x, 9i, SQL, PL/SQL, Sun Solaris, Windows NT/2000, OEM, statspack, Rman, ftp, SQL*Loader, ERWIN, Tkprof