SUMMARY

• 9+ years of experience as Oracle DBA (9i/10g/11g) on UNIX, Sun Solaris, Windows 2000/NT, Red Hat Linux.
• Experienced in full life cycle of database administration in Oracle. Worked both as a Production Support DBA and Development DBA in Oracle.
• Highly experienced in Oracle 9i/10g/11g Administration, Export/Import. Performance Tuning, Oracle SQL / PL - SQL tuning, Monitoring, Backup and Recovery.
• Created Oracle partition tables and applied patches as per the requirements of the partitioning module and upgrade Oracle and DBMS software.
• Experience in Upgrade and Migration of oracle database to higher version (from Oracle 9i to Oracle 10g to Oracle 11g) and other platforms using Oracle Data Migration Assistant.
• Installation, Configuration and deployment of Oracle 10g database and on different nodes with Automatic Storage Management (ASM).
• Working knowledge of SQL Server.
• Experienced on installation, configuration with OracleOEM(10g to 12c).
• Extensively used Oracle Enterprise Manager (OEM) for maintaining and monitoring databases.
• Efficient in SQL query optimization using explain plan, TKPROF reports, gathering statistics.
• Performance tuning of SQL queries and advising the application programmer of the opportunities in tuning the application. And Involved in performance monitoring and tuning of the database by fine tuning the database implementation.
• Configured securities and access to production databases.
• Understanding of OLTP database architectures.
• Configured and built GoldenGate Extracts/Replicat for multiple databases.
• Managing, optimizing and tuning Oracle and SQL Server databases through such tools as Oracle’s Enterprise Manager (OEM), snapshots and AWR Reports.
• Designed and Implemented database security using Oracle roles and privileges. And securities for users and applications…
• Experienced in Database design including creation, modification, and deletion of tablespaces, data-files, rollback segments and schema's, creating schemas (Tables, Indexes, views, sequences, synonyms, roles, and users).
• Troubleshoot Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM). Excellent communication, interpersonal and business interaction skills
• Experience in installation, upgrades, patches and TAR support. Duties included database creation, Performance tuning/reorganization, cloning, backup/recovery, user and security management, auditing, general troubleshooting, and configuring servers.
• Working experience on Flashback databases.
• Designed and implemented backup and recovery strategies. Extensively used conventional and RMAN for backup and Disaster recovery. Logical backup using and full/ partial export/import and Data Pump.
• Production support given to the system 24x7. Ability to work beyond regular hours. Carried primary and secondary support roles with pager rotation to support during weekends, Holidays and beyond regular hours.
• Provided database related services to their development, Production and QA environments.
• Successfully implemented physical standby database using Oracle Data Guard feature for High availability configuration.
• Written Stored Procedures and Triggers for database maintenance and management using PL/SQL.
• Extensively used PL/SQL (Stored procedures, triggers, packages), SQL* PLUS, SQL* LOADER, Explain Plan, and SQL tuning of Oracle database.
• Excellent communication and interpersonal skills.

TECHNICAL SKILLS

Operating Systems: HP-UX HP-UX (11.11, 11.23 & 11.31), Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.2, 5.3Red Hat Linux RHEL 2.1, 3.x, 4.x,5.x and WinSdows 95/98/NT/2000/XP

RDBMS: Oracle /11g/10g/10gRAC, RDBMS, MS-SQL Server 2000, 2005 Versant object database 7.0.1.3

Languages: SQL, PL/SQL, HTML, C, C++, JAVA, UNIX Shell Scripting.

Tools: /Utilities: RMAN, OEM, SQL*Loader, ASM, Export/Import, Patch Management, ODBC, Data pump, Data guard, .

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM

Hardware Platforms: Sun Fire 15K, Sun Fire 6800, Sun V480, V240, Sun Enterprise 0, HP XP256 / XP512, IBM C server p5 model 590, and various PC desktop and servers.

PROFESSIONAL EXPERIENCE

Confidential, West Des Moines IA

Sr. Oracle Database Administrator

Responsibilities:

• 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Performed Infrastructure support of various Oracle Database concepts, including connections, load balancing, failover, active data guard, CRS, ASM, SQL tuning, scheduling.
• Installing 9i, 10g and 11g databases on Red Hat Linux.
• Migration of Database from 9i to 10g and applying patches whenever required.
• Upgrade of Databases from 10g to 11g.
• Monitored all the 11g databases on Red Hat Linux environments by using OEM 11g and 12c.
• Installed and configured Oracle 10g/11g RAC high availability.
• Installation of Oracle cluster ware, Configuring public and private network and VIP.
• Experienced with SRVCTL, OCR and Voting Disk of 10g/11g RAC.
• Developing and Implementing Disaster Recovery (DR) Plan.
• Implemented DATAGUARD (Standby) for high availability/disaster recovery purpose.
• Daily Health Check Up of the Database.
• Database cloning from Production to Test and Development environments.
• Configured and maintained huge OLTP databases.
• Monitoring Table spaces and extent Growth.
• Configured the ESP mainframe scripts to execute the ETL jobs in required order.
• Monitoring the Hit Ratios and tuning the System Global Area (SGA) accordingly.
• Monitoring the operating system response in terms of CPU usage, disk space, and swap space by using various UNIX utilities like SAR, VMSTAT, ISOSTAT and TOP.
• Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace, TKPROF, STATSPACK, AWR and ADDM reports.
• Experience in Identifying performance bottlenecks on high volume transaction systems.
• Analyze SQL statements, reorganize database objects and design indexes to improve response of queries.
• Creation of database maintenance plans, rebuild indexes and integrity checks.
• Job scheduling using crontab.
• Performed full and incremental backups using RMAN.
• Implemented RMAN Backups, Creation of catalog database.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Ensure high availability of Databases Confidential all time.
• Developed PL/SQL programs (Functions, Procedures, Packages and Triggers).
• Support migration and loading of data into oracle database using SQL*Loader.
• Created Users, Roles and Managing Security & Concurrent Managers administration.
• Applied latest CPU patches /PSU db patches
• Provided proactive monitoring of the database instances, and took preventive steps like setting up alerts OEM Grid Control 11g to ensure high availability.
• Working knowledge of GoldenGate 11.2.1.0.15
• Configured and built heartbeat monitoring in GoldenGate.
• Configured error handling for restart, logging, production support and status reporting in GG.
• Implemented necessary monitoring scripts for GoldenGate .
• Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects.
• Provided oversight, mentoring to less experienced staff.
• Provided on-call support for production environment including deployments/migrations, running patch, bug fix scripts, and routine maintenance.

Environment: Oracle 10g/11g, Red Hat Enterprise Linux Server, OEM Grid Control 11g,OEM Cloud Control 12c, RAC, RMAN, Oracle Streams, Unix Shell Programming, Functions and Triggers, SQL Tuning, PL-SQL, Stored Procedures, Sybase PowerDesigner 16, DataStage 8.5, Atlassian JIRA (v4.2.4),TOAD 10.6, Vandyke secureCRT 6.7.2, PAC2000 7.6, GoldenGate 11.2.1.0.15 , oracle Exadatax2-8

Confidential - Seattle, WA

Sr. Oracle Database Administrator

Responsibilities:

• Worked as an Oracle Production DBA (10gR2,11gR2) on Red Hat Linux 5.5
• Involved in the installation of Oracle 10g, 11g on UNIX platform.
• Involved in installation and configuration of Oracle 10g /11g RAC with ASM on Linux/ Solaris.
• Add new nodes to existing RAC and configure instance.
• Install and configure OEM grid control on RAC databases.
• Involved in troubleshooting of 10gRAC node eviction issues and documentation.
• Work with OCR and voting disk corruption issues.
• Implemented FAILOVER using TAF for RAC databases.
• Intensively involved in configuration of ASM related issues.
• Configured ASM instances creating and managing disk groups.
• Experience in Upgrade and Migration of oracle database to higher version (from Oracle 10g to Oracle 11g) and other platforms using Oracle Data Migration Assistant.
• Performance tuning of SQL queries and advising the application programmer of the opportunities in tuning the application.
• Troubleshoot Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).
• Prepared Backup and Recovery Plan.
• Design, optimize, evaluate and modify the databases.
• Created logical and physical data models.
• Created tables, indexes, table spaces, users, integrity constraints and supported all phases of a development cycle.
• Developed stored procedures and complex packages extensively using PL/SQL and shell programs.
• Developed triggers, packages, procedures and functions using PL/SQL.
• User management, creating users, implementing security, assigning table spaces to the users, granting roles and privileges etc
• Audited database for statements, privileges, and schema objects.
• Management of table space growth, monitoring data files additions, extent growth
• Installation, Maintenance and Administration of Oracle for the developers & testers.
• Proactively interacted with client to understand their business practices and configure the system accordingly.
• Fulfilled DBA daily activities including monitoring alert log, memory, disk I/O, CPU, database network connectivity.
• Optimization of the SQL queries to meet the performance requirements.
• Worked with database export & import scripts to backup database structures and automation procedures.
• Test and Manage changes to IT environment quickly and fine tune the changes before putting them to production using Real Application Testing.
• Documented all PL/SQL procedures and user guide for different processes followed.
• Implemented DATA GUARD (Standby) for high availability/disaster recovery purpose.
• Implemented Oracle Data Pump (IMPDP and EXPDP) for refreshing schemas and databases.
• Created and Managed Tablespaces with different block-sizes to prevent row chaining.
• Day to day Performance Monitoring and tuning of database.
• Automation of Startup Shutdown on all Production and Development Database.
• Production support given to the system 24x7. Ability to work beyond regular hours. Carried primary and secondary support roles with pager rotation to support during weekends, Holidays and beyond regular hours.

Environment: Oracle 11gR2,10gR2, Red Hat Linux 5.5,AIX, OEM Grid Control, RAC, RMAN, OEM, Oracle Streams, Unix Shell Programming, Functions and Triggers, SQL Tuning, PL-SQL, Stored Procedures, UC4 9.0A.

Confidential, West Des Moines IA

Sr. Oracle Database Administrator

Responsibilities:

• Worked as an Oracle DBA (/10g/11g) on HP-UX (11.3), AIX 5.2, Solaris 10 & Red Hat Enterprise Linux Server release 5.5(Tikanga).
• Monitoring and optimizing the performance of the SQL scripts running in the Hibernate Application.
• Participated in the stress test, identifying performance bottlenecks and resolving them during stress test.
• Extensively used TKPROF, EXPLAIN PLAN for query refining, analyze execution plans for each query and recommended required indexes, hints and partitioning for query performance.
• Worked with 10g advisories such as SQL Tuning advisor, UNDO advisor, and ADDM.
• Use Grid control and OEM to monitor Stress tests.
• Worked with ODS (Operational Data Source) team. Tuned the autosys jobs(written in procedures, packages, datastage) which were taking lot of time in the production. Did the troubleshooting and bug fixing. Also worked on the tasks and blockers which were the priority in the every quarter release.
• Responsible for optimizing the queries and application tuning. Perform SQL tuning, and managed replication with oracle GoldenGate and oracle streams and assist developers.
• Developed stored procedures and complex packages extensively using PL/SQL.
• Worked closely with data modelers for the implementation of data model changes for different schemas for each release.
• Created tables, indexes, table spaces, users, integrity constraints and supported all phases of a development cycle.
• Performed zero downtime cross platform migration and 11g database upgrade with GoldenGate.
• Deployed biweekly release in the development environment and send the instructions to higher environments for the deployment.
• Was the part of the team for migration from 10g to 11g.
• Worked with data Mapping repository team to support their databases that includes updating database according to the new data model changes in COD and ODS environment. Help them to troubleshoot the problems they are facing in this environment and data clean up.
• Refreshes the development databases as per requirement of the team from higher environments.
• Applied latest CPU patches /PSU db patches.
• Setup, configuration and installation of the RAC environment and ASM.
• Implemented FAILOVER using TAF for RAC databases.
• Intensively involved in configuration of ASM related issues.
• Configured ASM instances creating and managing disk groups.
• Work with OCR and voting disk corruption issues.
• User management, creating users, implementing security, assigning table spaces to the users, granting roles and privileges etc
• Fulfilled DBA daily activities including monitoring alert log, memory, disk I/O, CPU, database network connectivity.

Environment: Oracle 10g/11g, HP-UX ( 11.31), AIX 5.2, Solaris 10 & Red Hat Enterprise Linux Server release 5.5(Tikanga), OEM Grid Control, RAC, RMAN, GoldenGate, Oracle Streams, Unix Shell Programming, Functions and Triggers, SQL Tuning, PL-SQL, Stored Procedures, Sybase PowerDesigner 16, DataStage 8.5, Atlassian JIRA (v4.2.4).

Confidential

Sr. Oracle Database Administrator

Responsibilities:

• Worked as an Oracle Production DBA (9i/10g/11g) on HP-UX (11.11, 11.23 & 11.31), AIX 5.2, Solaris 10 & SUSE Linux 9.3 servers.
• Had supported SAP R/3 4.7, Siebel CRM 7.8 production database.
• Involved in the installation of Oracle 10g, 11g on Windows and UNIX platform.
• Unix/Linux Software installations also includes RAID, NFS configurations.
• Extensively involved in Real Application Cluster (RAC) nodes 10g database migration from EMC drives to HITACHI drives with Automatic Storage Management (ASM).
• Worked on EMC RecoverPoint V3.0, SAN-based platform for concurrent CDP and remote replication in heterogeneous enterprise environments.
• Extensively involved in the migration of Production Real Application Cluster (RAC) and Stand alone Date base to different geographical location.
• Involved in installation and configuration of Oracle 10g /11g RAC with ASM on Linux/ Solaris.
• Add new nodes to existing RAC and configure instance.
• Install and configure OEM grid control on RAC databases.
• Involved in troubleshooting of 10gRAC node eviction issues and documentation.
• Work with OCR and voting disk corruption issues.
• Implemented FAILOVER using TAF for RAC databases.
• Intensively involved in configuration of ASM related issues.
• Configured ASM instances creating and managing disk groups.
• Experience in Upgrade and Migration of oracle database to higher version (from Oracle 9i to Oracle 10g to Oracle 11g) and other platforms using Oracle Data Migration Assistant.
• Performance tuning of SQL queries and advising the application programmer of the opportunities in tuning the application.
• Troubleshoot Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).
• Migration of MySQL to Oracle 10g using SQL developer.
• Prepared Backup and Recovery Plan.
• Design, optimize, evaluate and modify the databases.
• Created logical and physical data models.
• Created tables, indexes, table spaces, users, integrity constraints and supported all phases of a development cycle.
• Developed stored procedures and complex packages extensively using PL/SQL and shell programs.
• Developed triggers, packages, procedures and functions using PL/SQL.
• Configured Autoconfig and listener.
• User management, creating users, implementing security, assigning table spaces to the users, granting roles and privileges etc
• Utilized SQL*loader and data pump import to load data into tables.
• Audited database for statements, privileges, and schema objects.
• Management of table space growth, monitoring data files additions, extent growth
• Installation, Maintenance and Administration of Oracle for the developers & testers.
• Proactively interacted with client to understand their business practices and configure the system accordingly.
• Fulfilled DBA daily activities including monitoring alert log, memory, disk I/O, CPU, database network connectivity.
• Involved in writing Oracle scripts for the SQL and PL/SQL requirements for various applications and Data Modeling.
• Optimization of the SQL queries to meet the performance requirements.
• Worked with database export & import scripts to backup database structures and automation procedures.
• Test and Manage changes to IT environment quickly and fine tune the changes before putting them to production using Real Application Testing.
• Documented all PL/SQL procedures and user guide for different processes followed.
• Responsible for using PERL in scripting for backups and space saver policy.
• Perl Scripting for backup and disk management purpose.
• Scheduled backup jobs using AutoSYS.
• Implemented DATA GUARD (Standby) for high availability/disaster recovery purpose.
• Implemented Oracle Data Pump (IMPDP and EXPDP) for refreshing schemas and databases.
• Created and Managed Tablespaces with different block-sizes to prevent row chaining.
• Day to day Performance Monitoring and tuning of database.
• Automation of Startup Shutdown on all Production and Development Database.
• Performed Monthly Cold Backup, Weekly Hot Backup and daily backups using Export. Testing of Backup’s and Documenting backup strategies using TKPROF, EXPLAIN PLAN for the Better performance.
• Production support given to the system 24x7. Ability to work beyond regular hours. Carried primary and secondary support roles with pager rotation to support during weekends, Holidays and beyond regular hours.

Environment: Oracle 11i/11g/10g/9i, Sybase 11.x, MS SQL 2000/2005, HP-UX 11i v3, SUSE Linux, Solaris, OEM Grid Control, AIX, RAC, RMAN, OEM, DBArtisan 8.1.5,ERwin 7.3,EBS R12, Oracle Streams, Unix Shell Programming, Functions and Triggers, SQL Tuning, PL-SQL, Stored Procedures, Windows 2003 Servers.

State of Ohio Attorney General, Columbus, OH

Oracle Database Administrator

The Ohio Attorney General’s office (AGO) provides and maintains an application to track convicted sex offenders and child victim offenders. This SORN application is available to select Bureau of Criminal Identification and Investigation employees. The AGO also provides a web site for the public to search for and view sex offender information.

Responsibilities:

• The work involved overall Maintenance of Oracle Database, Performance Tuning, Backup, Recovery and other database related activities.
• Taking Backups on scheduled time and Monitoring Scheduled Backups.
• Creating and dropping of users, granting and revoking rights as and when required.
• Checking of Oracle files for abnormal behaviors.
• Day to day Performance Monitoring and tuning of database.
• Diagnose and Troubleshoot Database Problems and failures
• Involved in the Design (Logical & Physical) of Databases
• Preparing Backup and Recovery Plan.
• Involved in the installation of Oracle 9i on Solaris and UNIX platform.
• Creation and maintenance of database
• Handling day-to-day activities.
• Monitoring of database for growth and performance
• Defined backup procedures using daily hot backups and weekly cold backup.
• Oracle database administration on Solaris platform.
• Storage and space management including table spaces and data files.
• Creating Databases and all database objects. Database Designing, Designing Tablespaces and Rollback Segments
• Management of table space growth, monitoring data files additions, extent growth
• Constantly monitor the performance of the Databases and viewing Alert log files & Trace files.
• Using TKPROF, EXPLAIN PLAN for the Better performance.
• Monitoring of database for growth and performance
• Monitoring Database for fragmentation and correcting them
• Creating and implementing backup and recovery strategies team with the database related problems and also in maintaining the code for the project.
• Setting up and maintaining user accounts and profiles, Space management
• Ensuring proper online and offline backup. Periodical reading and checking of backups taken.
• Handling Database storage, logical and physical data modeling using tools like ER/Studio

Environment: Oracle 10g/9i, LINUX (Red Hat Enterprise Server), TOAD, OEM Grid Control, OLTP, RAC, RMAN, Export/Import, UNIX Shell Scripts.

Electronic Data Systems

Oracle Database Administrator

Responsibilities:

• Installation and configuration of Oracle Database Software 10g on Red Hat Linux.
• Creation and configuration of Oracle database.
• Migration of database (from 9.2.0.5 to 10.2.0.1) on LINUX (Red Hat Enterprise Server).
• Creation and configuration of Oracle database Performed storage and space management including table spaces and data files.
• Installed and Configured RAC on Red Hat Linux Advanced Server with 4 nodes server side load balancing using Automatic Storage Management.
• REFRESH/CLONING of Database for Development & Testing environments.
• Planned and implementation of Backup & recovery procedures and maintenance of Database.
• Developed shell scripts for tracing Oracle errors, free space in the table spaces and free disk space in Archive log destination for production databases.
• Developed Unix shell and SQL scripts for database Backups
• Created and managed the Server Parameter file.
• Worked in application tier and database tier to Startup/Shutdown patch database.
• Created users and assigned profile to them through Sys Admin.
• Fulfilled DBA daily activities including monitoring alert log, memory, disk I/O, CPU, database network connectivity.
• Creating/Altering/Modifying database objects like database triggers and indexes.
• Moved the data files to various disks (Transportable table space).
• Making structural changes to databases when database design changes are to be implemented
• Performed database tuning
• Cloned Database from Prod to Test by using RMAN utility.
• Monitoring the growth of Table spaces to see the fragmentation and available space for growth
• Performing Incremental backups using RMAN.
• Setup backup and recovery procedures using RMAN
• Audited database for statements, privileges, and schema objects.
• Troubleshoot Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM). Tuned database for optimum performance.
• Extensive use of SQL* loader for migration of data from flat file to oracle
• Performed Database and SQL tuning by using various Tools like STATSPACK, TKPROF, explain plan optimizer hints and SQL tuning advisor.

Environment: Oracle 10g/9i, LINUX (Red Hat Enterprise Server), TOAD, OEM Grid Control, OLTP, RAC, RMAN, Export/Import, UNIX Shell Scripts.

InfoZen Ltd, Hyderabad, India

Oracle Database Administrator

Responsibilities:

• Upgrading and migrating database from oracle 8i to 9i version.
• Creation and configuration of database on Red Hat Linux, UNIX and SUN Solaris
• Upgrading database from Oracle version 9i to 10g and migration of data.
• Good experience in working with Oracle and SQL server 2005. And Good experience with SQL migration.
• Created Oracle partition tables and applied patches as per the requirements of the partitioning Module and upgrade Oracle and DBMS software.
• Worked with Oracle partition tables and applied patches as per the requirements of the module. Used Oracle replication as databases for read only snapshots to maintain local copy of master tables in OLTP systems. Also done Patches for upgrading Oracle and DBMS software.
• Extensively used Oracle Enterprise Manager (OEM) for maintaining and monitoring databases.
• Performance tuning of application by identifying the SQL, which are not written well; providing inputs to the application programmer; correcting and implementing the right components.

Integrated the Backup Status Reporting for all the databases in the enterprise to enable the web reporting using Oracle SQL, PL/SQL.

• Installation, Configuration and deployment of Oracle 10g database and Real Application Clusters (RAC) on different nodes with Automatic Storage Management (ASM).
• Understanding of OLTP database architectures.
• Working on mentioning and implementing new database on UNIX Platforms.
• Physical standby database for High Availability.
• Identifying issues/ bottlenecks that could potentially cause issues, involving the right teams (such as server admins or application developers) and take a corrective action to rectify the issues.
• Written extensively UNIX Shell Scripts, PL/SQL, Stored Procedures and Triggers.
• Excellent communication and interpersonal skills.

Environment: ORACLE 10g/9i/8i, AIX UNIX, OLTP, OEM Grid Control, TAR, RAC, RMAN, Export/Import, UNIX Shell Scripts.