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
• Over 14 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.
• Installation, Upgradation, Configuration and troubleshooting Goldengate 12c software.
• 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.
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• 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
• Extensive experience in the installation, configuration, and maintenance of Oracle RAC, Data Guard, Golden gate in Unix environment.
• 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, production usage.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• 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 designing database, administration and maintenance in various environments
• Experience with DBMS backup solutions including RMAN, Oracle Zero Data Loss
• 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
• Knowledge about replication tools like Oracle Golden Gate and Oracle Streams
• Worked with Oracle components - Data Warehouse, Partitioning, Security, Streams, 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.
• Working experience in a fast-paced Agile & Scrum environment
• 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, Golden Gate

Languages: SQL, PL/SQL, C, Shell Scripting, RMAN, RAC, ASM.

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

ETL Tools: Informatica (PowerCenter 5.1/6.2/7.1/8.6.1/9.1.0, Power Mart 5.1, Power Connect/Power Exchange for SAP R/3, Main Frame and Oracle Change Data Capture (CDC), AB Initio 1.8 and SQL*Loader.

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.
• Installation, configuration and administrating Oracle Golden Gate replication.
• 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.
• Handled Physical and Logical Corruptions and recovery using RMAN (Recovery Advisor).
• Translated Business Requirements into working Logical and Physical Data Models.
• MySQL database administration on a large-scale MySQL installation.
• MySQL database backup and recovery strategies and Replication and synchronization.
• MySQL processes and queries optimization. Exported and Imported database 10g objects from development to production.
• Provide support and consultation to the application development team in all database related areas including table and index design and creation and SQL tuning
• Provided database support for development and deployment of database scripts in Development, Test, Pre-Production and Production environments.
• Implemented Data Guard with maximum availability and performance configurations for production databases.
• Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions and packages to migrate data from SQL server database to Oracle database.
• Performance tuning of Oracle databases using Sql Access Advisor, Sql Performance Analyzer, Sql Tuning Advisor.
• 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.
• Designed and implemented backup and recovery strategy using Recovery Manager RMAN, traditional Export or Import, Hot or Cold Backups
• 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
• Provided L2 and L3 production support depending upon the ticket assigned to meet the corresponding SLA's.
• Developed scripts to proactively monitor and databases and alter the DBA on events such as running out of extents, disk space and actively involved in shell scripting for various CORN jobs to be run.
• 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.
• Working with the Oracle Support Mechanisms; My Oracle Support (Metalink), Raising Service Requests.

Confidential, Bethesda MD

Oracle Database Administrator

RESPONSIBILITIES:

• Created and maintained all oracle databases required for development, testing, production usage.
• Created and modified SQL*Plus, PL/SQL and SQL*Loader scripts for data conversions.
• Implemented Data Guard with maximum availability, protection and performance configurations and worked with Data Guard Fail over and Switch over cases.
• Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling.
• 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.
• Configured and maintained MySQL database servers.
• MongoDB Index Tuning and Performance Tuning.
• Effectively configured MySQL Replication as part of HA solution.
• Developed stored procedures, triggers in MySQL for lowering traffic between servers & clients.
• Performed MySQL Replication setup and administration on Master-Slave and Master-Master.
• Responsible for capacity planning, recovery planning and installing patches.
• Maintained Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
• Performed cloning and refresh of Database from production environment to test environment using RMAN Duplicate database and Data pump import export.
• Installed 12c agents on hosts and discovered targets.
• Expertise in creating Oracle Tables, Table Partitions, Views, and Materialized Views.
• Install, maintain and monitor Web Logic server as part of OEM Grid Control setup.
• Implemented Oracle Advanced Security to provide the most cost-effective solution for comprehensive data protection.
• 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.
• Installed, security, and maintenance of Linux based systems including Apache and MySQL 5.0.22 configuration.
• MySQL database administration on a large-scale MySQL installation.
• Experience with MySQL on both Linux and Windows.
• 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.
• Taking the RMAN incremental and cumulative 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.
• Working experience in a fast-paced Agile & Scrum environment

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.
• MySQL database administration on a large scale MySQL installation.
• MySQL database backup and recovery strategies and Replication and synchronization.
• MySQL processes and queries optimization. Exported and Imported database 10g objects from development to production.
• 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).
• Developed Star-Schema and did Dimension Modeling for the data warehouse.
• 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.