PROFESSIONAL SUMMARY:

• Oracle DBA with 8+ years of experience providing 24/7 production and development support for Oracle 11g, 10g, 9i databases across different platforms.
• Extensive knowledge on database administration for Oracle 9i, 10g, 11g and 12c with experience in very large scale database environment and mission critical large OLTP and OLAP systems.
• Experience in successfully migrating database from Non - ASM to ASM and Non-RAC to RAC through Confidential for 10g and 11g databases across multiple host platforms.
• Performed extraction, transformation and load process (ETL). Migrated huge volumes of flat file data into structured data using SQL loader and data pump utility.
• Design and develop methodologies to migrate multiple development/production databases from Mysql to Oracle 11g.
• Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects. Assisted in integration of Exadata applications into current IT actionable events and solutions
• Experience in datawarehouse database installing database software.
• Experience in data warehousing and modeling techniques and procedure
• Expert in analyzing data warehouse systems and using a data warehouse
• Experience supporting and developing data warehouses
• Experience in monitoring applications using bulkmon
• Upgraded Vertex Sale Tax (VSUT) database 2.1 to 3.1 in oracle 10g and configured SAP Applications
• Installed and configured Oracle Identity Manager (OIM) and Oracle Role Manager with integration between the two in demo environment.
• Experience in Oracle Architecture, Capacity planning, space management, Performance Tuning, Backups, Recovery, RMAN backups, Optimization of SQL queries, Networking, Troubleshooting.
• Experience working with Oracle Data Integrator (ODI). Demonstrated expertise utilizing ETL tools, including Oracle Data Integrator (previously known as Sunopsis), Ab initio, Informatica, Datastage
• Programmed ETL functions between Oracle and Amazon Redshift
• Experience with ODI tools - Topology, Security Manager, Designer and Operator
• Experience in Configuration and managing ODI topology manager, designer, ODI agents
• Experience in infrastructure layout, provisioning. Extensive experience in Amazon AWS cloud infrastructure with particular reference to provisioning, security, and management.
• Hands-on experience in configuration of physical and logical backups, upgrade/migration, RMAN Cloning, Data pump, Data guard, Performance Tuning, RAC, ASM, Confidential, on different HP-UX, Sun Solaris, Linux, UNIX AIX, and Windows servers.
• Experience in installation, configuration and administering 2/3/4/6 node Real Application Clusters (RAC) setup, configuration and cluster interconnection with Automatic Storage Management (ASM) including active monitoring of ASM disk groups for their load balancing and redundancy.
• Optimizing database/query performance for mongo databases.
• Configuring Sharing, monitoring, and identify the proper shard key for mongo databases
• Selection, inserting large amounts of data of mongo db
• Performing Security measures, backups and restore backups for mongo database
• User Management - creating users, assigning roles, managing permissions for mongo databases.
• Installed and Administered Oracle 11g ASM & 10g RAC software with ASM & OCFS2 File systems with active failover disk groups.
• Developed and recorded certified processes/procedures for all potential IT downstream support group to maintain and upgrade the Exadata servers.
• Extensively worked on developing new packages and user defined DML and DDL triggers through PL/SQL scripts and created stored procedures.
• Supported in setting up bi-directional replication using Confidential also known as active to active replication to support DML and DDL activities on both databases.
• Implemented Confidential for data recovery and data migration for Oracle 11gR2 RAC multi nodes on IBM AIX and debugging Confidential issues such as extract, replicate rebuild and a bend.
• Implemented Data guard in the production environment and executed active standby database switchover and failover drills to effectively handle mission critical planned and unplanned outages.
• Integration with Oracle Test Data Management masking functionality and Oracle Application testing suite using RAT(Real Application Testing)
• Planned and implemented DR & high availability solutions on OEL 10g Standby Database using Oracle Data Guard.
• Experience in installing Oracle patches and upgrades, Migration of database across different platforms.
• Developed logical and physical data modeling techniques for both applications development and data warehousing.
• Excellent experience in various migration techniques like export/import, Data pump, backup restore, cloning, and data guard.
• Experience with Real Application Testing (RAT )
• Responsible for cleansing the data from source systems using Ab Initio components such as Join, Dedup Sorted, Denormalize, Normalize, Reformat, Filter-by-Expression, Rollup
• Experience in Disaster Recovery set-up using Data Guard for critical environments and performing Disaster Recovery exercises annually.
• Extensive experience with T-SQL in constructing Triggers, Tables, implementing stored Procedures, Functions, Views, User Profiles, Data Dictionaries and Data Integrity.
• Experience in maintenance of Oracle Fail Safe 3.X on Microsoft clusters server configuration.

TECHNICAL SKILLS:

Operating Systems: Sun Solaris 9/10, HP-UX 11i v1.5, IBM AIX 5.3/6.1/7.1, RHEL 3.x, 4.x, 5.x, Linux 6 and Windows.

Databases: Oracle 12c, 11g, 10g, 9i, 8i, Mysql, Microsoft Sql Server 2005,2008,2012, IBM Model 204,PostgreSQL 8.4, 9.2, Real Application Cluster (RAC), ASM,RAT

DB Utilities: SQL*LOADER, Data Pump, RMAN, Opatch, TKPROF, Statspack, AWR, ADDM, SRVCTL, CRSCTL, ASMCMD, ASMCA, DBCA, ADRCI and DBUA,AWS.

Tools: Oracle Enterprise Manager 10g/11g/12c, TOAD 8.5, SQL Developer, Putty,Ab-initio,Informatica.ODI

Languages: SQL, PL/SQL for Oracle, C.

PROFESSIONAL EXPERIENCE:

Confidential, Monroe, LA

Oracle Database Administrator III

Responsibilities:

• 24/7 Monitoring and maintenance of Oracle 10g and 11g databases on HP-UX and Linux environments including ASM and Non-ASM.
• Configured Golden Gate Uni-Directional and Bi-Directional Table Replication.
• Having hands-on experience on implementing, upgrading and configuring the Golden Gate software for Oracle Database.
• Implemented ARCHIVELOG MODE replication of Golden Gate from HP-UX to Linux platform.
• Installed and configured Veridata for monitoring the Confidential replication used during the 10g to 11gR2 upgrade.
• Worked on the High availability of Confidential creating the Confidential VIPs and creating services for RAC databases. In case of one node getting failed Confidential will be failover to other node.
• Performed conversion of Non RAC single instance to Real Application Cluster (RAC) database instances for high availability and vice-versa.
• Involved in 24x7 support for 6 Node production RAC database and maintained through CRSCTL and SRVCTL.
• Supported in datacenter migrations from 11g RAC cluster to a different server using Confidential and Symmetric Remote Data Facility (SRDF).
• Performed CRS and Database Upgrades from 11.1.0.7, 11.2.0.2 to 11.2.0.3 and Applying patches to RDBMS and CRS.
• Experience in datawarehouse database installing database software.
• Experience in data warehousing and modeling techniques and procedure
• Expert in analyzing data warehouse systems and using a data warehouse
• Configured Emcli setup for databases, which relocates the OEM targets when failover is done on Oracle 6 node RAC cluster.
• Scheduling RMAN backups and performing database restoration and recovery from backups.
• Optimization and tuning long running SQL queries using STA, Access advisor, Trace File, Sql Profiles, TKPROF and EXPLAIN PLAN.
• Programmed ETL functions between Oracle and Amazon Redshift
• Experience working with Oracle Data Integrator (ODI). Demonstrated expertise utilizing ETL tools, including Oracle Data Integrator (previously known as Sunopsis), Ab initio, Informatica, Datastage
• Experience in SQL optimized for Redshift, Hive, and reporting
• Experience in Installation and configuration of ODI
• Experience in performance monitoring and troubleshooting with respect to ODI
• Involved in performance tuning by generating and analyzing ADDM, AWR and ASH reports.
• Performed database refreshes and schema refreshes using Data pump (Expdp and Impdp), RMAN Duplicate, DBPITR and Cloning.
• Experience in infrastructure layout, provisioning. Extensive experience in Amazon AWS cloud infrastructure with particular reference to provisioning, security, and management.
• Created Dblinks between Oracle and SQL Server using database gateway for SQL Server.
• Performed Database migrations from old version to new version of hardware to meet the standard using RMAN Duplicate.
• Experience with AWS deployment activities.
• Developed and recorded certified processes/procedures for all potential IT downstream support group to maintain and upgrade the Exadata servers.
• Integration of Exadata monitoring into our existing IT monitoring framework. Provide and implement performance and tuning recommendations of all components in the Exadata machines.
• Implemented active Data Guard to provide high availability of databases and for disaster recovery (DR).
• Performed all node patching and rolling patch upgrades on RAC environment for bug fixing.
• Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with ASM.
• Optimizing database/query performance for mongo databases.
• Configuring Sharing, monitoring, and identify the proper shard key for mongo databases
• Selection, inserting large amounts of data of mongo db
• Performing Security measures, backups and restore backups for mongo databases
• User Management - creating users, assigning roles, managing permissions for mongo databases.
• Upgraded Vertex Sale Tax (VSUT) database 2.1 to 3.1 in oracle 10g and configured SAP Applications
• Experience in monitoring applications using bulkmon
• Checking Databases Backup and Restore validity periodically and Data refreshes from Production to Non-Production environment, Creation Duplicate Databases using RMAN Backups.
• Performed Database migration, which includes migrating data from SQL Server 2008R2 to Oracle OEL. Loaded data into oracle tables using SQLLDR.
• Monitoring the tablespace management, database management, schema management, and system resource usage.
• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
• Worked with Oracle on various issues related to database hang/crash, used system state dump and hang analyze to gather information of the hung process.
• Analyzed the user requirements and designed partitioned tables for improving performance of Data marts.
• Developed back-end logic for business applications, e.g. views, procedures/functions, triggers.
• Involved in installation of an oracle database on exadata platforms.
• Design and develop methodologies to migrate multiple development/production databases from Mysql to Oracle 11g.
• Backup and restore Mysql databases.
• Mysql user management.
• Mysql database performance and tuning.
• Install oracle 11g software on UNIX server for server and client.
• Create Oracle 11g database databases and replicate Mysql schema objects to Oracle.
• Troubleshoot PL/SQL procedures and functions to support corresponding Mysql functionalities.
• Installation of Oracle RDBMS server software and version upgrades.

Environment: HP-UX, Red Hat Linux 6.0, Oracle RAC 10g/11g, Oracle 10g&11g, PL/SQL, SQLLDR, Golden Gate, Oracle Enterprise Manager 9.2.0, Oracle 12c GRID, Oracle RAC, Data guard, TOAD 8.6, SQL server.

Confidential, Columbus, IN

Oracle DBA

Responsibilities:

• Migration from AIX to Linux using Confidential and Upgrades from 10g to 11gR2RAC.
• Implemented Oracle 11g Active Data guard with maximum performance mode for FSFO and snapshot data guard.
• Experience on Oracle RAC with SRDF Implementations for cross datacenter replication.
• Converted databases from Non-ASM to ASM.
• Patching security vulnerabilities as part of quarterly release, applying mini packs, maintenance pack, family pack and one-off patches.
• Responsible for cleansing the data from source systems using Ab Initio components such as Join, Dedup Sorted, Denormalize, Normalize, Reformat, Filter-by-Expression, Rollup
• Storage Management Managing Space, Tablespaces, Segments and Extents, Rollback Segments & Data Dictionary
• Handling Escalations, Sev1 Cases and other Critical cases.
• Highly experience in Cloning of Oracle application environment using Rapid clone and ad configuration.
• RMAN Backup and cloning Database using RMAN Active Duplicate
• Configured and managed ODI topology manager, designer, ODI agents
• Exposure to Oracle Application tools and ad utilities like adpatch, adadmin, adconfig, adctrl etc. for the management and maintenance of Applications.
• Managing Workflow and its components through OAM.
• Implemented Oracle 11g Confidential for data replication through configuring the GGSCI and other Confidential processes.
• Experience in Creating procedures, interfaces and packages in ODI
• Troubleshooting network issues with respect to SCAN listeners and local listeners, configuring the virtual IPs and monitoring the load balance level of the RAC clusters.
• Performance Tuning for Optimized results using Explain-Plan, SQL-Trace, STATS PACK Reports and AWR Reports.
• Checking Databases Backup and Restore validity periodically, and Data refreshes from Production to Non-Production environment using RMAN utility.
• Responsible for SQL Server 2008 Database Backup and recovery. Monitoring the database backup, drive space, log space and Critical errors for all production servers.
• Used normal import and export and also data pump import and export for exporting and importing schemas, tables etc. from one database to another.
• Responsible for tuning the database performance issues like query tuning and memory tuning (SGA tuning) and also partitioned the tables and indexes for better performance.
• Have used different tools like TOAD (10.1), EXPLAIN PLAN, AWR, ADDM, Oracle enterprise manager (GRID CONTROL) 10.2.0.4 to solve the performance issues.
• Application user creation / responsibilities assignment, applying minipacks, maintenance pack, family pack and one-off patches.
• Design and develop methodologies to migrate multiple development databases from Mysql to Oracle 11g
• Experience with Real Application Testing (RAT )
• Experience in SQL optimized for Redshift, Hive, and reporting
• Troubleshooting application failures including performance and database connectivity problems and job failures.
• Monitoring the table space growth and resizing the table space on 10g RAC environment.

Environment: HP-UX, Windows, Solaries, AIX, Oracle 11g/10g, SQL, TOAD(10.1), Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), Data Guard, Confidential, AWR, ADDM.

Confidential, Cary, NC

Oracle Database Administrator

Responsibilities:

• Worked on production environments of 9i, 10g and 11g databases through On-call pager support and assisted in daily performance tuning tasks.
• Installed, Configured and administered RAC andsupported in moving non RAC databases to RAC.
• Migrated SQL Server 2005 database to SQL Server 2008 database in Microsoft Windows Server 2012 Enterprise Edition.
• Worked on generating AWR and ADDM reports and configuring explain plan for high load sql queries.
• Administered the CRON job scheduler for datacenter automation tasks and coordinated strategies to move data between databases using expdp/impdp.
• Handled connection requests from clients to net service name and resolving listener issues through net configuration assistant(netca) and oracle net manager (netmgr).
• Documented the necessary procedures as per the industry requirements for data guard, RAC installation and Datapump setup processes.
• Worked on configuring the ASM system on the storage server through appropriate oracleasmlibraries.
• Auditing the actitvies of the all the users logged to the database server through audit trail logs and administered the security of the user sessions.
• Configured a catalog database for RMAN and taken backups on different incremental levels.
• Worked on resolving tickets through various ticketing tools like HP service manager, and monitored the alerts through OEM grid enterprise manager.
• Monitored the automatic diagnostic repository(ADR) for storing the diagnostic data and has created oracle support service request if the problem persists.
• Maintaining stripping, mirroring and online storage reconsideration and dynamic rebalancing through Oracle ASM and manage raw partitions.

Environment: Oracle 9i/10g/11g, SQL, PL/SQL, Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), Data Guard, Shell Scripts, AWR, ADDM, RHEL 4.0.

Confidential

Junior Oracle DBA

Responsibilities:

• Provided 24x7 Support of Critical Databases and worked on enhancing the Database Monitoring process.
• Upgrading database from 8i to 9i and troubleshooting issues during upgrade, applying patches to fix issues.
• Responsible for refreshing/cloning test instances with Production Instance periodically.
• Administration of databases- Physical and logical structures.
• Creating and Managing users, Granting and Revoking privileges for the users in order to ensure the Database security.
• Automated jobs to run backups, disk cleanup for logs and archive logs, gather statistics.
• Identify and troubleshoot long running queries, locked sessions to improve overall performance.
• Established and wrote the Database Administrators Procedures document for the IT department.
• This document highlights all standards for the DBA Group including installing/upgrading Oracle, creating databases, DBA tools, administration and monitoring, naming standards, policies, practices and procedures.
• Generated Automatic Workload Repository (AWR) report to collect processes and maintained performance statistics for problem detection & self-tuning purposes.
• Monitored the databases and added the data files to the tablespaces or resizing the tablespaces and monitored the sessions running on the databases.
• Managed and supported users by creating roles and privileges for database access and data manipulation.
• Reported the database storage capacities to Project Management and organized the capacity planning of the production database.

Environment: Oracle 9i/8i, Solaris, Linux, RHEL 3.0, HP-UX.

Confidential

Database Administrator

Responsibilities:

• Providing Production support and troubleshooting user issues.
• Performing daily database operations, maintenance and support.
• Administration of databases- Physical and logical structures.
• Regular SQL Server Maintenance Activities Index rebuilds and updates statistics, Database Backup, Data Imports and Exports.
• Configured and troubleshooting replication, log shipping, mirroring, clustering and database maintenance jobs.
• Export/Import data to/from Production and Non Production systems as required.
• Taking database backup and recovery management (Hot/Cold, Exp/Imp).
• Identifying and resolving resource contention issues and monitoring database performance.
• Solving the issues based on Alert logs.
• Maintaining of Space requirements on the Tablespaces by adding/re-sizing data files based upon the space available on the file systems and existing volumes.
• Creating and Managing Users, Granting, Revoking privileges for the users in order to ensure the Database security.
• Creation of Database Links and Materialized Views between different databases.
• Monitor the operating system response in terms of CPU usage, disk space, and swap space by using various like VMSTAT, ISOSTAT and TOP.