OBJECTIVE:

A challenging position as an ORACLE DBA within an IT organization which provides an opportunity for growth and advancement.

SUMMARY:

• Around 9 years of Oracle DBA experience.
• Worked extensively on Oracle RDBMS.
• Expertise in Oracle DBA activities, Oracle custom solutions and resolving customer issues.
• Experience in High Availability Database Solutions.
• Several production/Dev/test implementations of Oracle 9i/10g of small to VLDB types.
• Upgrade Performed up gradation of Oracle database from 9i to 10g/11g.
• Tuned several production databases using explain plan.
• Performed fine tuning using ASH, AWR , ADDM , stats pack, dbms_stats.
• DR planning, Data Guard and physical, logical standby databases.
• Complete Oracle lifecycle from concept to design, architecture, installation and patches, database creation, database performance monitoring, from production to test databases.
• Devised & implemented back up strategies using Hot, Cold & export based on requirements.
• Managing security of an oracle database using roles & profiles.
• Worked extensively with OEM (Grid Control) and installation of Agents for monitoring purposes for both the Oracle as well as the SQL Server databases.
• Experience in configuration of storage of Oracle databaseson Automatic storage Management (ASM).
• Experience in handling recovery issues using Oracle Flashback Technology.
• Oracle backup using RMAN (Oracle Recovery Manager).
• Performed database design, sizing, UNIX Shell Scripting, PL/SQL Stored Procedures, capacity planning.
• Performed Database Refreshes of Dev/Test from Prod.
• Created and restored backups. Wrote SQL Plus queries to monitor the database.
• Worked with third party tools like Toad for quick diagnosis and end results.
• Resourceful and results-oriented team player with the ability to manage multiple projects concurrently.
• Excellent communication and interpersonal skills together with a positive approach to undertaking challenges.
• Good knowledge in Oracle10g RAC ( Real Application Clusters).

Education:

• Bachelor's Degree in Electronics and Communication Engineering First class with distinction.

Certifications:

• Oracle certified DBA in Oracle 10g (OCP)

TECHNICAL SKILLS:

Operating Systems: DOS, Windows 95/98/2000, Windows XP Professional, Windows NT, Windows Server 2003, UNIX, Solaris, AIX, HP, LINUX
Database: Oracle 8i/9i/10g & 11g, SQL Server
Languages: SQL, PL/SQL, UNIX Shell Scripting.
Oracle Tools: RMAN, OEM, SQL*Loader, OEM Grid Control, SQL*Plus, DBCA, Import/Export, Data Pump, ASM
Tuning Tools: EXPLAIN PLAN, STATSPACK, AWR, ADDM, TOAD, OEM
Others: EMC, NetApp, VERITAS, Netbackup.

PROFESSIONAL EXPERIENCE:

Confidential, NJ April 2011--Present
Sr. Oracle DBA

Confidential offers a broad array of retail, small business and commercial banking products and services to more than 7.8 million customers throughout the Northeast, Mid-Atlantic, Metro D.C., the Carolinas and Florida.

Project Details:
This project involves implementation/support of retail banking databases on a 24x7 support basis.

Environment:
Solaris 10, redhat Linux PL/SQL, Export, Import, Oracle 11g/10g/9i, RMAN, OEM, TOAD, Putty, SQL Navigator

Responsibilities:

• Installed, configured and upgraded the databases on Sun Solaris, HP Unix ,Linux, Aix.
• Plan growth and changes of Database files (Capacity Planning).
• Supported Oracle Databases on 10g&11g versions.
• Proactively monitor the database status and disk space by creating and executing Unix Shell Scripts.
• Continuously monitor and resolve performance issues by tuning the initialization parameter and SQL Queries.
• Applied interim and PSU patch sets to oracle binaries.
• Responsible for maintenance and improvement of production Oracle databases.
• Performs database administration functions including database capacity planning, pro-active performance monitoring and tuning, executing security procedures.
• Responsible for storage & usage of all databases, including rearrangements of the database logical structure and tables as needed.
• Experience in database backup/restore methodologies including RMAN, hot and cold backups, export, import.
• Worked with the server administrators for allocating space to the databases and database memory and sever performance issues.
• Worked with application administrators to resolve the issues related to sql is running slow ,application is down.
• Assess the criticality of the Databases and delivered the support accordingly.
• Troubleshooting application errors and performance issues, implementing solutions to both short and long-term issues and continued refinement of solutions
• Automating common tasks including: Backups, exports and imports, archiving old records and performing verification using RMAN.
• Periodic trimming of Oracle system log files and removal of old redo log archives.
• Support of Oracle Server Database Environments ranging from 1-5 TB.
• Performed database cloning using user managed backup.
• Gathering cost-based optimizer statistics for tables with stale statistics (performance tuning)
• Responsible for Oracle database security, database capacity analysis and planning.
• Responsible for providing and insuring data availability, data integrity, and data security.
• Documented most critical procedures and trained offshore staff to run the same.
• Experience with Change management tools such as Enterprise change management.
• Experience using the Clear case for Code promotion.
• Oracle upgrades from 10g to 11g.
• Support for databases that include installing and upgrading, instance creation & Application database setup.
• Designed & developed database structures (Tables, Indexes, Views, Triggers to implement Business Rules, Procedures, etc).
• Created databases for different applications keeping in view space & performance requirements for coming months.
• Monitoring the Oracle databases using OEM (Oracle Enterprise Manager) and TOAD.
• Tuned the database and sql code using AWR, ADDM, ASH.
• Designed proper indexing strategy on transaction tables for optimal performance.
• Implemented Recovery Manager Utility (RMAN) for easier and well-managed recovery procedures.
• Work to resolve and alleviate failures, problems, or concerns in a timely manner.
• Suggested the management in purchasing of licensed Oracle Software.
• Cloning the Reporting databases using RMAN.
• Worked on Databases Migration from non ASM to ASM
• Developed PL/SQL scripts as needed for database support.

Confidential, VA
Sr. Oracle DBA
Feb 2009 - March 2011

Confidential is a national mortgage finance company. We stand behind mortgage lenders, local and national banks, thrifts, credit unions, and other financial institutions in all 50 states - to securitize or buy the mortgage loans they originate, enabling them to replenish their funds so they can lend to other homeowners. Similarly, we work to keep funds flowing to support affordable rental housing.

Project Details:
This project involves support/upgrades of oracle 10g databases used for mortgage business.

Environment
Solaris 9/10, redhat Linux , Aix 5.3,PL/SQL, Expdp, Impdp, Export, Import, SQL*Loader, Oracle 11g / 10g, TOAD 8.5, RMAN, ADDM, OEM, Clear Case, Putty.

Responsibilities:

• Installation, configuration and upgradation of Oracle Server including Setup, Maintenance and Documentation.
• Plan growth and changes of Database files (Capacity Planning).
• Proactively monitor the database status and disk space by creating and executing Unix Shell Scripts.
• Continuously monitor and resolve performance issues by tuning the initialization parameter and SQL Queries.
• Responsible for maintenance and improvement of production Oracle database
• Responsible for data refreshes for production, development and training databases.
• Responsible for storage & usage of all databases, including rearrangements of the database logical structure and tables as needed.
• Quarterly Internal and External SOX Auditing.
• Experience in database backup/restore methodologies including RMAN, hot and cold backups, export, import,
• Physical and Logical standby,Data Guard.
• Assess the criticality of the Databases and delivered the support accordingly
• Troubleshooting application errors and performance issues, implementing solutions to both short and long-term issues and continued refinement of solutions
• Automating common tasks including: Backups, exports and imports, archiving old records and performing verification using RMAN
• Periodic trimming of Oracle system log files and removal of old redo log archives
• Support of Oracle Server Database Environments ranging from 10-20 TB.
• Gathering cost-based optimizer statistics for tables with stale statistics (performance tuning)
• Responsible for Oracle database security, database capacity analysis and planning
• Rebuilt and reorganized databases, enhancing development, maintenance and performance
• Documented most critical procedures and trained backup staff to run the same.
• Experience with Change management tools such as Enterprise change management.
• Experience using the Tools such as PVCS and Clear case for Code promotion.
• Oracle upgrades form 9i to 10G.
• Support for databases that include installing and up grading, instance creation & Application database setup.
• Created databases for different applications keeping in view space & performance requirements for coming months.
• Monitoring the Oracle databases using OEM (Oracle Enterprise Manager) and TOAD.
• Designed proper indexing strategy on transaction tables for optimal performance.
• Implemented Recovery Manager Utility (RMAN) for easier and well-managed recovery procedures.
• Work to resolve and alleviate failures, problems, or concerns in a timely manner.
• Suggested the management in purchasing of licensed Oracle Software.
• Cloning the Reporting databases using RMAN.
• Developed PL/SQL scripts as needed for database support .
• Tuned the SGA (init.ora parameters) keeping in view the Replication requirements.
• Documented the Backup Procedures.

Confidential, NJ
Sr. Oracle DBA
Apr 2005 - Jan 2009

Confidential Services provides a wide range of technology leasing and financing services to Hewlett-Packard customers in North America, Europe, and Asia. It serves consumers, government agencies, educational institutions, and businesses of all sizes, offering leasing and financing, asset recovery services, and pre-owned equipment. Confidential formed the leasing subsidiary in 2002, which now serves clients in more than 40 countries around the world.

Project Details:
This project involves implementation/support for 8i 9i &10g financial services databases.

Environment:
Oracle 8i/9i/10g, RMAN, OEM, UNIX (HP, AIX), PL/SQL, Export, Import, SQL*Loader, TOAD, SQL Navigator, Windows Server, Clear Case, Putty

Responsibilities:

• Provided DBA support for databases (8i, 9i 10g) that includes installing, upgrading, instance creation, application database setup, database monitoring and tuning.
• Perform database administrative tasks in support of various Oracle applications such as financial, HR, budget, and process oriented workflow packages.
• Implemented Recovery Manager Utility (RMAN) for easier and well-managed recovery procedures such as backups, restores, recoveries, and duplicates/clones (refreshes).
• Perform traditional cold and hot backups in appropriate environments via OS commands as well as logical exports.
• Performs routing database administration functions including database capacity planning, pro-active performance monitoring and tuning, executing security procedures.
• SQL tuning is done using EXPLAIN PLAN.
• Oracle upgrades from 9i to 10G.
• Monitor the databases using OEM grid control.
• Experience using the Code promotion tool such as Harvest .
• Implemented AUDITING to see operations done by different users.
• Maintain backup and recovery strategies as well as capacity planning.
• Administering Oracle 8i, 9i and 10g databases including design, documentation, security, requirements, gathering, capacity planning, backup and recovery.
• Monitoring the Oracle databases using OEM (Oracle Enterprise Manager) and TOAD.
• Worked in database backup/restore methodologies including RMAN, hot and cold backups, export, import, and Physical and Logical standby, Data Guard.
• Performed data modeling, create database objects, table spaces, tables, indexes, views, established security via users and roles, resolved fragmentation, obtained optimum use of extents.
• Support of Oracle Server Database Environments ranging from 1-2 TB.
• Developed PL/SQL scripts as needed for database support.
• Developed and implemented partitioning and archive purge strategies.
• Developed and tested backup and recovery strategies.
• Including on-line and off-line backups.
• Developed and administered processes for performance tuning of databases.
• Followed ECM Standards for all the changes and ESM standards for securing the databases.
• Responsible for managing the development, test and production environments and providing technical support and guidance to project teams.
• Project & Task Management (Database related) coordination & completion.
• Setting up and resolving issues with Oracle Data Guard environments
• Query Optimization & Consulting with Application Developers & Business Analysts.
• Disaster Recovery and Business Continuity Planning & Participation.
• Establishment and Enforcement of Database and Data Integration Standards.
• 24x7 Rotating Database Environment On-Call Support.
• Analyzes and evaluates existing or proposed systems, and related procedures to process data.
• Participates in the design of server/disk architecture working closely with Unix administration.
• Implemented multiple ARCHIVELOG destinations to archive redo logs to the development server to support immediate database recovery.
• Occasionally performs code reviews of developer code.
• Built the Physical standby Dataguard.
• Assists in the troubleshooting of SQL codes and give recommendations to developers. .
• Assists in the tuning of critical SQL statements and other Oracle related processes.
• Did sql and database tuning using AWR,ADDM,ASH
• Applies Oracle patches for bug fixes.
• Creates and maintains Oracle listeners and tnsnames.ora (SQL Net).
• Performs all production database object installations.
• Sizes and maintains all Oracle tablespaces and tables.

Confidential, NJ
Oracle DBA
Aug 2003 - Mar 2005
Confidential is a leader in asset management, investment banking, private banking, treasury and securities services, and commercial banking. Today, the firm serves one of the largest client franchises in the world, including corporations, institutional investors, hedge funds, governments, healthcare organizations, educational institutions and affluent individuals in more than 100 countries.

Project Details:
This project involves support to investment banking databases.

Environment:
Solaris 8, Linux PL/SQL, Export, Import, SQL*Loader, Oracle 10g/9i, RMAN, OEM, Oracle Staspack utility, OEM, TOAD, Putty, SQL Navigator.

Responsibilities:

• Perform Oracle database administration duties including configuration, installation, troubleshooting database systems, backup and recovery, data migration, schema changes, data replication, tuning.
• Resolve database performance issues.
• Perform DB Capacity planning.
• Work with application & database developers to develop and implement solutions.
• Monitor database health and performance status.
• Worked in database backup/restore methodologies including RMAN, hot and cold backups, export, import, and Physical standby, Data Guard.
• Create and maintain procedures and documentation for database environments.
• Cloning the databases.
• Evaluate benefits/risks of enhancements and upgrades being considered for deployment.
• Participate in design and implementation of future database environments.
• Work to resolve and alleviate failures, problems, or concerns in a timely manner.
• Participate in Disaster Recovery Planning and Disaster Recovery Testing efforts.
• Ensure that standards for database performance, availability, and security are being met.
• Developed PL/SQL scripts as needed for database support.
• Developed and implemented automated shell scripts to make database object changes as required.
• Provided 24x7 On-call support.
• Performed DBA duties installing, upgrading and monitoring of Oracle software and databases (8i, 9i & 10g).
• Perform Capacity and infrastructure planning
• Support database on IBM AIX / Windows / Linux platforms.
• Supported Oracle Enterprise Manager.
• Monitor and optimize the performance of the database.
• Support installing and configuring Oracle Application Server 8i and 9i.
• Provide 24x7 supports when needed.
• Develop SQL queries and reports.
• Assist developers with database object and SQL query design.
• Implemented utility RMAN for Backup and recovery operations for both production and staging database environments.
• Implemented multiple ARCHIVELOG destinations to archive redo logs to the development server to support immediate database recovery.
• Manage and apply Oracle patches.