SUMMARY:

• Oracle Certified Database Administrator with experience on Unix, Linux, Solaris, AIX and Windows platforms for Oracle (12c/11g/10g/9i/8i) having hands on experience in database installation, configuration, monitoring & administration in Production, Test & Development environments
• Around 12 years of experience working as resident expert in Oracle(12c/11g/10g/9i/8i) Relational database (RDBMS) design, modeling, mining, development, administration, implementation, and troubleshooting, and quality management.
• Created and managed the project plan for upgrading EBS to 11.5.10.2/10 gR2 - multi-node RAC/ASM/SSL and integration with OAS 10g/Portals and compatibility/upgrade of several third-party products into a single integrated solution for global operations.
• Hands-on experience on installation and configuration and troubleshooting of Oracle products and patches, including RAC, ASM, Cluster ware, Data Guard, OID, Grid/Cloud Control, OEM, RAT, AWR, PL/SQL and manage RAC instances u sing CRSCTL and SRVCTL Utility.
• Expert in Database performance tuning, performing maintenance tasks like indexing, restores, backups.
• Installed 11g 3 node production RAC Grid Infrastructure and DATABASE on Linux.
• Experience in Installation, configuration of Oracle RAC, developed 2 node RAC environments for a 1TB database by implementing WAN technology to reduce the network traffic.
• Hands on experience in both database and program code performance tuning.
• Continuous review of Business-Critical Database to proactively identify space issues, performance tuning issues
• Experience in patching, upgrading of RAC and NON RAC databases
• Expert in controlling migrations of programs, database changes, reference data changes and other DB changes through the development life cycle.
• Expert in Handling Oracle recovery and backup scenarios
• Developed, Implemented & Maintained Proficient in performance tuning, database optimization using Explain Plan, STATSPACK, SQL TRACE, TKPROF, the Conceptual, Logical & Physical Data models.
• Participated in Data modeling activities for creating, and maintaining, conceptual, logical and physical data models for OLTP system using Erwin.
• Administered all database objects, including tables, clusters, indexes, views, sequences, packages and procedures.
• Creating and maintaining all oracle databases required for development, testing, and production usage.
• Advanced skills in ER design, dimensional design, canonical design, object design, UML
• Strong knowledge in Oracle tools, Oracle Security Management and Data integrity
• Experience working with communicating the design with UML and/or ERD, design patterns and Design Documents
• Strong working knowledge of Tape Libraries, SAN Storage Solutions, Oracle Automatic Storage Management (ASM)
• Installed Oracle Cluster ware to provide infrastructure for RAC and configured 2 node Oracle 11g RAC with EMC.
• Strong experience in Oracle Advanced Security and Network Security including Network Encryption and Data Encryption.
• Experience administering all database objects, including tables, clusters, indexes, views, sequences, packages and procedures
• Worked with various tools, such as SQL*Loader, SQL Developer (and/or PL SQL Developer) and Oracle Enterprise Manager (OEM)
• Experience in MS Hyper-V and/or VMware.
• Providing DBA support to multiple Cluster, Non-Cluster and ASM Database in production, development and Testing Servers in UNIX, AIX & Windows Environments.
• Implemented OLTP COMPRESSION, PARTITIONING, Hybrid Columnar Compression for databases
• Worked with ITIL processes
• Worked with Oracle components - Data Warehouse, Partitioning, Security, Streams, and Networking.
• Performed MySQL Replication setup and administration on Master-Slave and Master-Master
• Applying PSU Patches and interim patches whenever required to make the database software up to date.
• Created scripts for RMAN incremental backups and for full
• Providing technical support to application development teams, providing on call support and maintaining databases.

TECHNICAL SKILLS:

Databases: Oracle Database (RDBMS) 8i, 9i, 10g, 11g 12c, Microsoft SQL Server

Languages: SQL, PL/SQL, C, Shell Scripting, RMAN, RAC, ASMTuning/Monitoring: RAC 11gR1/R2, RAC 10gR2, Data-Guard 9i/10g/11g, DB Cloning, Standby Databases, RMAN 9i/10g/11g, TKPROF, EXPLAIN PLAN, STATSPACK

Tuning/Monitoring: RAC 11gR1/R2, RAC 10gR2, Data-Guard 9i/10g/11g, DB Cloning, Standby Databases, RMAN 9i/10g/11g, TKPROF, EXPLAIN PLAN, STATSPACK

Modeling: ER Studio, Erwin, Visio, MySQL Workbench, TOAD

Utilities & Tools: RMAN, Oracle 11g Grid Control, Performance Tuning, EXP, IMP, Data pump, SQL* Loader, RMAN SQL developer, Import/Export data-pump, Database administration tool (patrol), Database assistance, Oracle Management Server, Oracle Migration utility, Oracle network configuration, Shell Scripting, AWR, Grid Control, Data Guard

OS: UNIX (AIX, HP-UX and Solaris), Red Hat Linux, MS Windows NT, 2000, XP, Vista, Windows 7

PROFESSIONAL EXPERIENCE:

Confidential, Laurel MD

Oracle Admin/Apps DBA

RESPONSIBILITIES:

• Installation and use of High Availability and Disaster Recovery components; Oracle GRID Infrastructure /Cluster ware, Oracle 12c two node RAC for the database tier.
• Planning and implementing DR & high availability solutions using ‘’oracle 11g /12c Standby Database using Data guard.
• Implemented DR & high availability solutions using OEL 10g Standby Database using Oracle Data Guard, 11g and 10g RAC.
• Designed and implemented Oracle Real Application Clusters (RAC) on Solaris with EMC Storage for an OLTP application with Transaction Application Failover and high transaction volume.
• Managing, troubleshooting and resolving oracle database, RAC and applications issues.
• Installed new versions of the Oracle RDBMS and its tools and any other tools that access the Oracle database.
• Configured Data Guard Broker and used for switchover and stopping and Starting Media recovery process.
• Responsible for Implementation of Oracle 11g R1 Grid Control and configured nodes for proactive monitoring and auditing.
• Installed 12c grid control and Used Oracle Enterprise Manager Grid control 11g/12c for monitoring databases.
• Participated in Data modeling activities for creating, and maintaining, conceptual, logical and physical data models for OLTP system using Erwin.
• In depth knowledge in Data Modeling, Database administration, Performance and Tuning, application design, implementation and testing.
• Developed Oracle stored procedures, packages, functions, and triggers in support of new applications being deployed
• Performed database re-organizations as required to assist performance and ensuring maximum uptime of the database.
• Conducted time-to-time analysis and monitoring of the software and hardware requirements and act accordingly.
• As part of the GDBA Support team we provided L2/L3 level support to the application teams during high risk issues (escalations) and within normal activities like code migration, Database recovery via RMAN, troubleshoot performance issues, export and import of tables/schemas among environments.
• Design and implemented backup and recovery strategy using Recovery Manager RMAN, traditional Export or Import, Hot or Cold Backups
• Analyzing the AWR/ADDM report to find slow/resource intensive queries degrading system performance. Then resolving these by re-writing SQL or PL/SQL object, indexes, hints, or making necessary change in data-model.
• Provided tuning recommendations and future memory requirements to Primary DBA team to make the changes in Database like table reorg, add enough spaces to database
• Database monitoring and maintenance activities which include checking alert logs, space management, undo management, gathering database statistics, database locking issues, scheduling of jobs, creation of users, schemas, table spaces and other database objects.
• Worked with Application Developers and System administrators to ensure that any new product usage or release upgrade takes place with little to no down time.
• Involved in 24x7 support for 8TB, 4 Node production RAC database with on-call pager.

Confidential, Bethesda MD

Oracle Database Administrator

RESPONSIBILITIES:

• Setup and configured Oracle 10g/11g Physical Standby database (Data Guard) to ensure high availability.
• Monitored performance and availability of the VIS application a high-availability web-based application running Oracle9i RAC on HP-UX cluster with EMC SAN.
• Performed day-to-day database administration tasks like Table space usage, checking alert log, tracing files, monitoring disk usage
• Leading, Designing and Developing the ETL tools for Data Warehouse systems
• Performed capacity planning required to create and maintain the databases and implemented security for all the Oracle Databases.
• Responsible for data modeling of several new and modified systems including OLTP, data feeder systems, and data warehouses. Used ERWin and Quest data modeling tools.
• Cloned schemas, objects and data on new server using Data pump.
• Monitor databases using Mongo MMS cloud service.
• Setup MongoDB backups using MongoDB cloud backup service.
• Worked on MongoDB Shading.
• MongoDB Index Tuning and Performance Tuning.
• Responsible for capacity planning, recovery planning and installing patches.
• Implemented Advanced Security in different database one as Transparent Data Encryption and other as Oracle Data Redaction.
• Used TOAD as third-party software for analyzing the database issues and generating results sets in xls formats.
• Handled all daily DBA activities and experience with PERL/SQL scripting, PL/SQL coding, stored procedures, functions, packages, triggers to enforce the referential integrity constraints and business rules.
• Created standards to ensure that all application design and code is produced with proper integrity, security and performance
• Involved in 24x7 production database maintenance and on-call support.

Confidential, Columbia MD

Sr. Database Administrator

RESPONSIBILITIES:

• Installation, configuration and maintenance of Oracle 10g and 11g databases on OEL.
• Involved in construction of DR sites for all the Production databases.
• Involved in installation and maintenance of Oracle RAC for high availability.
• Performed Oracle and operating system performance monitoring.
• Designed and developed data models with application development teams upgraded the Oracle 10g database to 11g version and applied patch set and interim patches whenever required to make the database software up to date and associated with RMS.
• Monitoring Day-to-Day Backups, Log's & recovering them as per the requirement.
• Performed migrating code, database changes, data and menus through the various stages of the development life cycle.
• Administered and created all database objects, including tables, clusters, indexes, views, sequences, packages and procedures, tracing files, monitoring disk usage, database backup logs
• Successfully implemented Backup & Recovery using RMAN, Hot and Cold backups.
• Extensive experience in RMAN recovery in RAC and stand-alone database.
• Involved in implementing load balancing and testing failover on RAC database.
• Worked on a variety of projects all of which involved the use of Erwin data modeling tool.
• Worked with various Oracle tools and performed Oracle security management.
• Designed and implemented the schema and business rules for the SBA application using ERWin and Oracle best practices.
• Massaged the existing model to create new logical and physical models that formed the basis for the new application.
• Created a Clone Database using RMAN on remote Server and used SRVCTL commands for Real Application Cluster (RAC) Databases.
• Implemented Data Guard with maximum availability, protection and performance configurations and worked with Data Guard Fail over and Switch over cases at the times of up gradation and migration.
• Monitoring the Oracle Instances, Users, Tables, Table spaces, Memory structures, and Rollback segments, Redo logs, Archived Redo logs and Alerts.
• Creation of Users and granting them the required Roles and Privileges accordingly.
• Involvement in space management, rectification of lock problems, managed quotas.
• Resolving the conflicts between the target and source database.
• Designed and implemented backup and recovery strategy using Recovery Manager RMAN, traditional Export or Import, Hot or Cold Backups
• Performed day-to-day activities such as creating users, roles, schemas, tables, views, indexes and rebuilding Indexes and running scripts given by the clients
• Cloned schemas, objects and data on new server using Data pump.
• Assisted customers with issues related to FDA Imports involving issues with PL/SQL code, UNIX shell scripts running in development and production environments.
• Worked extensively on monitoring 10G Grid Control database, configuration of error notifications, installing listeners, and adding them to the grid control.
• Monitored ALERT Log files to keep tracking the Oracle Errors and make necessary actions to rectify them.

Confidential, Winona MN

Database Administrator

RESPONSIBILITIES:

• Upgraded the Oracle 10g database to 11g version and applied patch set and interim patches whenever required to make the database software up to date.
• Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.
• Designed and implemented Oracle Real Application Clusters (RAC) on Solaris with EMC Storage for an OLTP application with Transaction Application Failover and high transaction volume.
• Designed and implemented Oracle Real Application Clusters (RAC) on Solaris with EMC Storage for an OLTP application with Transaction Application Failover and high transaction volume
• Supported more than 130 production and development databases.
• Create new database users as required and managed sharing of resources amongst applications.
• Administered all database objects, including tables, clusters, indexes, views, sequences, packages and procedures.
• Experience must include working with the installation of Oracle software, applying Patch Set Updates, and working with ASM disk storage.
• Have experience in Migrating Single Instance database to RAC Environment.
• Managed all Backup design and implementations.
• Created, monitoring database objects like Tables, Indexes, Views, Users, and DB Links etc.
• Extensively used features such as Data Pump, Flash Back Recovery, ASM, AWR, ADDM for Generating reports
• Initiated a feasibility study for RAC of Oracle 11g.
• Used ERWIN for data modeling (Logical and Physical).
• Design & Implementation of RAC10g development, testing and production.
• Installation of the required software, support in migration and patch application for bug fixes. Tuning the applications and databases.
• Design and implementation of Oracle 11gR2.
• Implementation of BCP and DRP plans.
• Configuration of Oracle Standby/Data Guard databases.
• Enforced and maintained database constraints to ensure integrity of the database.
• System Administration of Linux when required.
• Design and implementation Oracle Enterprise Manager 10g, 11g, 12c.
• Migrations of oracle databases from 8i/9i/10g to 11g.
• Automation of database creation using shell scripts and SQL scripts.
• Database server's installation, configuration, upgrading and trouble-shooting.
• Managing day-to-day database operations
• Automated the database monitoring
• Automated DCU (Disconnected state users) user's database extractions and monitoring field users/inspector’s synchronization activity.
• Transactional database and data warehouse design.
• Designing backup and recovery procedures.
• Monitor disk space, database health checks, database backups and error log scans.
• Involved general system architecture of PHIS and provided high level architectural and technical advices.
• Designed and automated the DCU (disconnected state user's) notification process and deactivation process.
• Redesigned the ETL load process for fast data loading and reliable data warehouse operations. I brought down the ETL loading process from 8 hours to 30 min.
• Provided the technical solution/ proof of concept to client on incremental data load instead of daily full load.
• Consolidation of ASM Disk Groups/Rebalancing.
• Performance Tuning and Query Optimization.
• Creating/Modifying/Locking Logins and Users in Sybase Database.
• Identified System Problems and resolve the issues.
• Provided the technical advices on PHIS database design and performance tuning.
• Cross trained the application developers and DBA's on performance tuning techniques.
• Improved the Assurance Net application performances (resolved the dead lock issues and improved the system performance)
• Designing ETL process (extraction, transformation and loading)
• Database consistency checks, fixing DBCC errors, monitoring of error logs regularly, monitoring of database
• Space allocations, transaction log space allocations.
• Handled all daily DBA activities and experience with PERL/SQL scripting, PL/SQL coding, stored procedures, functions, packages, triggers to enforce the referential integrity constraints and business rules
• Recommending solutions by defining database physical structure and functional capabilities, database security, data back-up, and recovery specifications.