PROFESSIONAL SUMMARY:

• Around 10+ 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) .
• Involved in Oracle Golden Gate installation, configuration, troubleshooting Golden Gate Extract and Replicate issues.
• Working knowledge of SQL Server.
• 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.
• 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 table spaces, 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.
• Working with development team to perform the database tasks related to application enhancements such as creating new tables and/or columns, writing and tuning PL/SQL, SQL scripts and stored procedures and debugging production database issues. Worked in AGILE and WATERFALL projects.
• 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.3, Red 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 6500 / 450, 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/development/UAT/SIT/PFIX databases 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 11g databases on Red Hat Linux.
• Upgrade of Databases from 11.2.0.2 to 11.2.0.4
• ORACLE 11.2.0.4 GI/CRS upgrade to 12.1.0.2 GI/CRS with OCT 2015 PSU
• Databases migrations to new servers as part of Tech-Refresh activity.
• Working with development team to perform the database tasks related to application enhancements such as creating new tables and/or columns, writing and tuning PL/SQL, SQL scripts and stored procedures and debugging production database issues.
• Helping development team and configuration management to make build scripts, rollback scripts and unit test scenarios and ensure deploy to the QA environments for testing and then to the production environment.
• Co-coordinating pre-production and production deployments. Developing deployment plan closely working with developers and rollback plan.
• Worked on compliance using DBSmart drift management and reviewed databases for violations and fix it.
• Handle EXADATA Patching, Maintenance, Upgrades, Migrations, DB Architecture Design, Golden Gate Setup, SOX Database Compliance Audits, Capacity Planning.
• Installed and configured Oracle 11gR2 RAC high availability.
• Installation of Oracle cluster ware, Configuring public and private network and VIP.
• Experienced with SRVCTL, OCR and Voting Disk of 11gR2 RAC .
• Developing and Implementing Disaster Recovery (DR) Plan.
• Implemented DATAGUARD (Standby) for high availability/disaster recovery purpose.
• Daily Health Check Up of the Database.
• Validation of Daily tablespace, ASM Disk Reports, BCP Sync Reports.
• Validating daily RMAN backup reports and troubleshooting failed RMAN jobs .
• Database cloning from Production to ProdFix/SIT with data scrubbing activity.
• Configured and maintained huge OLTP databases.
• Monitoring Table spaces and extent Growth.
• 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/Autosys
• 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.
• Installation and configuration of OGG 11g /12c for high availability, OGG upgrades, patching.
• Troubleshooting daily issues encountered like GG abended due extract trail directory filled/checkpoint table was dropped where non-integrated replicat was running .
• Assisted in designing and management of postgreSQL database schemas and tables.
• Setup/Managing Databases on Amazon RDS. Monitoring servers thorough Amazon CloudWatch, SNS.
• Creating/Managing AMI/Snapshots/Volumes, Upgrade/downgrade AWS resources (CPU, Memory, EBS)
• Create/Managing buckets on S3 (CLI) and store db and logs backup, upload images for CDN serve.
• Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects.
• Assisted in management and database administration of Oracle databases on Exadata platforms.
• 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,Weblogic 11g/12c, RAC, RMAN, Oracle Streams, Unix Shell Programming, Functions and Triggers, SQL Tuning, PL-SQL, Stored Procedures, Sybase PowerDesigner 16, Atlassian JIRA (v4.2.4),TOAD 12.1.0.22, Vandyke secureCRT 6.7.2, PAC2000 7.6, Golden Gate 11.2.1.0.15, OGG 12c, AWS,oracle Exadatax2-8,DBSmart,CA Autosys r11.3,DAM

Confidential, Tallahassee, FL

Sr. Oracle Database Administrator

Responsibilities:

• Supported the projects for EDRS(Electronic Disqualified Recipient System) and IVR Migration.
• Authoring and maintaining a data dictionary using formal changer management processes.
• Logical and Physical data modelling using ERWIN.
• Tuning SQL queries and PL/SQL code for better performance.
• Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace, TKPROF, STATSPACK, AWR and ADDM reports.
• Developed PL/SQL programs (Functions, Procedures, Packages and Triggers).
• Wrote shell/batch scripts to load data from mainframe flat files to oracle database.
• Worked on the ETL to populate the data to tables as per the business requirement.
• Working with Application teams, Business analysts, QA teams to review and deploying the SQL/PLSQL code logics and database structure changes such as tablespaces, schemas, tables, synonyms, sequences, constraints, indexes, roles, table/system level privileges and profile. Reviewing data model review packets.
• Worked with Production DBA to co-ordinate the production deploys. Developing action scripts (deploy steps/implementation steps, rollback plans (contingence plan) and validation steps.
• Provided proactive and reactive measurement for database / server performance. Generating and analyzing performance metrics such as Explain Plan, AWR, ASH, ADDM, OEM 12C, Trace Analysis, SQL Advisors: SQL tuning, SQL Advisors and others
• Creation of database maintenance plans, rebuild indexes and integrity checks.
• Performed full and incremental backups using RMAN.
• Worked on preparing the design documents for project as per the client need.
• Prepared the implementation plan for the release .
• 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.

Environment: Oracle 11gR2,10gR2, Red Hat Linux 5.5, OEM Grid Control, RAC, RMAN, OEM, Unix Shell Programming, Functions and Triggers, SQL Tuning, PL-SQL, Stored Procedures, TOAD 10.6,Putty,winscp, Rational ClearCase version 7.1.2,CA Erwin 9.5

Confidential, West Des Moines IA

Sr. Oracle Database Administrator

Responsibilities:

• 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.
• 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.
• 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).
• Working with Application teams, Business analysts, QA teams to review and deploying the SQL/PLSQL code logics and database structure changes such as tablespaces, schemas, tables, synonyms, sequences, constraints, indexes, roles, table/system level privileges and profile. Reviewing data model review packets.
• 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.
• Configured and built Golden Gate Extracts/Replicat for multiple databases.
• Configured and built heartbeat monitoring in Golden Gate.
• Configured error handling for restart, logging, production support and status reporting in GG.
• Implemented necessary monitoring scripts for Golden gate .
• Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects.
• Assisted in management and database administration of Oracle databases on Exadata platforms.
• 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,Weblogic 11g/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, Golden Gate 11.2.1.0.15, OGG 12c, oracle Exadatax2-8

Confidential, Seattle, WA

Sr. Oracle Database Administrator

Responsibilities:

• Worked as an Oracle 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.

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., DB2 9.1.0, IBM Optim

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.
• 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.
• 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, Weblogic 11g, 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).

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.
• Responsible for optimizing the queries and application tuning. Perform SQL tuning, and managed replication with oracle GoldenGate and oracle streams and assist developers.
• Performed zero downtime cross platform migration and 11g database upgrade with Golden Gate.
• 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, GoldenGate, Oracle Streams, Unix Shell Programming, Functions and Triggers, SQL Tuning, PL-SQL, Stored Procedures, Windows 2003 Servers.

Confidential, Columbus, OH

Oracle Database Administrator

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 .

Confidential

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 .

Confidential

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.