SUMMARY:

• Having more than Nineteen years of professional experience in IT industry. 12 years of experience in Oracle Database administration and Four Years of SQL Server administration running on Sun Enterprise servers and Sun Sparc servers (Unix),HP Unix, IBM AIX Servers, Windows NT,2000 with client/server applications. This includes install, manage, administer, maintain and tune Oracle in 12c,11i,R12,11g RAC, 10G RAC, 10g, 9i, 8i, 8.0.6, 7.3 RDBMS, AWS administration and NETEZZA.
• Extensive experience in Software installations, Migrations, Database Capacity Planning, Automated Backup Implementation, Clustering, Tuning of Oracle 12c,11g,10g RAC/10g/9i/ 8i /8/7.x on Unix, Linux and Windows NT/2000/2003 platforms.
• Experience in analysis, design, development, testing and implementation of applications.
• Experience in handling production and development boxes under client/server environments on flavors of UNIX/NT operating systems throughout the life cycle of the application.
• Had excellent communication skills and a versatile team player with leadership qualities, with emphases on building strong client relationships, building result - oriented teams, aptitude to learn, integrity and ability to put in sustained quality effort consistently.
• Administered the NPS appliances on Linus operating env on Twin Fin Appliances.
• Actively participated in Upgrading the NPS versions from .
• Performing nzbackups & nzrestores on nps appliances.
• Installing Oracle7.x, 8i, 9.2.0, and 10g RAC, 11g on UNIX as well as Win NT, 2000 Operating systems for necessary databases, their storage space requirements and placing them for optimum I/O performance.
• Creating and Managing Oracle servers of 24TB sizes and Standby Servers
• Configured and Maintain oracle instances on veritas cluster and RAC envs.
• Extensively Used ASM to manage storage of the 10g databases.
• Upgrading the databases from 8i to 9i, 9i 10g and 11g and Oracle apps: 11i and R12
• Daily monitoring and interpreting of Alert Log files and Trace files.
• Automated the monitoring scripts through cron and OEM GRID.
• Extensively used Sqlbacktrack, RMAN tools to backup and restoration
• Resource Management (create and manage indexes, allocate and manage physical storage structures like data files, redo logs, control files. Allocate and manage logical storage structures like tablespaces, schemas, and extents).
• Database Creation for development, testing and Environments.
• Software Maintenance and operation (configure and manage SQL*Net, configure the oracle instance using the initialization parameters).
• Creating users, allocating tablespaces to users, managing privileges with role based access. Familiarity with profiles.
• Ensuring data, database security and integrity with auditing features
• Installed and supported SQL server databases 2000 and 2005 of sizes 750GB.
• Maintained and supported databases on UNIX file systems and raw devices.
• Performance Tuning and Troubleshooting (diagnose and resolve locking conflicts, using data dictionary tables and views, monitor the instance, collect and analyze relevant database performance information, identify and implement appropriate solutions for database performance problems).
• Exporting data from various RDBMS into flat files and Loading into Oracle database
• SQL*Loader, data transfer using EXPORT/IMPORT and data pump.
• Used Erwin, Power Designer data modeling tools extensively.
• Fixing data related errors and handling data loading issues.
• Installed and configured oracle Streams and data guard.
• Implementing and testing DR Strategies
• Backup and Recovery (develop backup and recovery strategies, implementation of backup procedures and recovery of database).

IT SKILLS:

RDBMS: ORACLE 7.x / 8.0.5, 8i, 9i, 10g, RAC, 11g, 12c Oracle11i (CRM), R12, SQL Server 2000, 2005, 2008; Timesten, DB2 MYSQL, NETEZZA

Languages: SQL, PL / SQL, PERL, AWK

Software Tools: SQL* Plus, SQL* Loader, Import / Export, data pump, data guard, OEM, Golden Gate, Toad, RMAN, SQLBACKTRACK. Tkprof, Discoverer 9ias, Mercator, Remedy, Dbartisan, Sqlnavigator, Erwin, Fast Copy.

Operating Systems: Sun Solaris 2.6, 2.7, 2.8, IBM AIX 5.2, HP UX11.0, Linux5.2 (Red Hat), Sco UNIX MS-DOS, Windows NT, 2000, 2003.

Protocol: Net 8, SQL* Net v2, TCP/IP, FTP, TELNET

PROFESSIONAL EXPERIENCE:

Confidential, FL

Netezza Admin/Oracle DBA

Responsibilities:

• Used data pumps to load data migrations.
• Installation of the oracle software, migration and patch application for bug fixes. Created the Development, testing, UAT, and Production RAC databases.
• Implemented cluster ready service and two-node RAC.
• Implemented 11g Automatic Storage Management (ASM).
• Managed disk groups using ASM for multiple databases using one ASM instance.
• Migrated a regular database Non-Asm instance to 10g Asm.
• Migrated 10g data bases to 11g in RAC Env.
• Supported databases of sizes more than 4 terra bytes.
• Monitoring and optimizing the performance of Databases and assisting developers in tuning the SQL and Analyzed performance bottlenecks and provided appropriate solutions using AWR and ADDM.
• Created, migrated and restored databases, configured for distributed OLTP and DSS databases.
• Install and Setup the RMAN backup for ORACLE Database and database maintenance plan for backup SQL Server database backups.
• Implemented Physical Hot stand by database as part of implementing DR strategies as per Business Requirements

Confidential, Irving,Tx

Netezza admin/Oracle DBA

Responsibilities:

• Supporting the infrastructure team as netezza dba throughout the life cycle of the project.
• Actively working on supporting activities like: creating DATABASES, setting the privileges required for the Functional Ids, application users, identification of failure of jobs and providing the resolutions, taking care of maintenance activities like running statistics jobs, running groom jobs, taking incremental, full backups and performing restores across appliances, performing data migrations, upgrading the nps from lower versions to highier versions (6.0.3 - 7.0.2 ), query tuning, preparing the shell scripts for performing backups, running grooms, statistics.working with IBM in replacing failed disks or any other failure components through PMRs on Twin fin appliances.
• Extensively worked on work load management to better manage the application jobs.
• Extensively worked on work load management to better manage the application jobs.
• Supported oracle dbs as backup/secondary dba as and when needed for production support activities on 12c databases on linux environment.
• Supported activities like: db monitoring, performing backups and recovery in highly ciritical environment

Confidential, Atlanta, GA

RAC DBA

Responsibilities:

• Installed the 6.0.3 NPS. Applied Patches and upgraded to 6.0.8.Supported the database maintenance tasks.
• Provided user access and resolving access issues. Worked with IBM on issues like failed disksUpgrades.
• Monitoring the databases through cron and setting up the nz events.
• Performed backup and restore opertations.
• Handled performance issues. Setting up resource groups to better manage the regular jobs.
• Built a 3 node cluster Oracle 11gR2 RAC database on ASM instances running on Linux.
• Tested RAC failover scenarios.
• Applied Rolling Patches.
• Configured SCAN listeners.
• Restored ocr and voting disks.Migrated Databases from Non-Asm to ASM.
• Installed and Configured Data guard for a 3 node RAC to Single instance on 11gR2 environments.
• Cloned 11i apps database and application env.
• Built Data guard for physical standby databases and RAC databases.
• Administring postgresql databases.

Confidential, Champaign, IL

Prod DBA

Responsibilities:

• Installed Golden Gate in Linux Evns.
• Configured Golden Gate for replicating for two remote sites
• Upgraded the Golden Gate in from version 9 to 10
• Identified and Resolved lag issues in Golden Gate env.
• Installed and configured 11i and R12 Oracle Apps for E-Business Suite.
• Cloned the Applications and Databases in 11i and R12 Envs from Production to Test Envs.
• Administered the Oracle Apps in single node and multi node envs.
• Administered AD utilites.
• Installed and Tested the apps on RAC for couple of applications.
• Converted a Single Standalone databases to RAC using rconfig utility.
• Supported Timesten in a Production Env.
• Handled Replication issues in a Timesten Env.
• Created Timesten in memory dbs

Confidential, Atlanta, GA

DBA

Responsibilities:

• Installed and created 11g databases in AIX Unix servers on IBM clusters.
• Installed Redhat Linux 5 on multiple servers.
• Performed troubleshooting and fixed system related issues in Linux servers and network related issues.
• Installed and configured a two node 10g RAC cluster in Redhat Linux Environments..
• Configured +ASM instances on both the nodes.
• Optimized Queries to fix performance related issues.
• Administered the State Lottery databases of: Ohio, South Carolina and Montana dbs.
• Implemented Steams to refresh data across multiple databases of state lottery databases.
• Responsible of managing a team of 3 oracle dbas.

Confidential, Atlanta, GA

Sr. Oracle DBA/SQL DBA/Unix Admin

Responsibilities:

• Installed Oracle 9i, 10g oracle binaries.
• Built 4 oracle 10g instances each of size 500GB.
• Built the required file systems from shared disks which are connected SAN for the VERITAS cluster.
• Installed VERITAS volume manager, storage foundation suite and built a two node VCS cluster.
• Created and configured three 10g oracle instances and configured them into two node cluster.
• Configured Oracle rman backups.
• Worked on Logical Design/data modelling of the schemas.
• Planned and worked towards Migration of the application with Data Architects and migrated two instances from 9i to 10g, instances running on E10k machines.
• Performed administration of Oracle Application Server.
• Starting and stopping application services as needed.
• Changed the forms mode from servelet to socket mode(OC4J)
• Supported stand alone and clustered (active-active, active-passive) SQL SERVER dbs.

Environment: Oracle 9.2.0, 10g, 10gias and VERITAS clustered databases, Sun Solaris 2.9 Oracle Enterprise Sun Enterprise Servers 4500, E10k

Confidential, Atlanta, GA

Sr. Oracle/SQL DBA/Netezza DBA

Responsibilities:

• Configured and monitored all the databases through OEM GRID.
• Worked with Data Architect teams on database consolidation project to stream line databases
• Used data pumps to load data migrations.
• Installation of the oracle software, migration and patch application for bug fixes. Created the Development, testing, UAT, and Production RAC databases.
• Implemented cluster ready service and two-node RAC.
• Implemented 10g Automatic Storage Management (ASM).
• Managed disk groups using ASM for multiple databases using one ASM instance.
• Migrated a regular database Non-Asm instance to 10g Asm.
• Migrated 10g data bases to 11g in RAC Env.
• Supported databases of sizes more than 4 terra bytes.
• Implemented and configured Oracle Streams in 10g
• Supported systems for high Availability/replication envs using GOLDEN GATE.
• Monitoring and optimizing the performance of Databases and assisting developers in tuning the SQL and Analyzed performance bottlenecks and provided appropriate solutions using AWR and ADDM.
• Created, migrated and restored databases, configured for distributed OLTP and DSS databases.
• Install and Setup the RMAN backup for ORACLE Database and database maintenance plan for backup SQL Server database backups.
• Implemented Physical Hot stand by database as part of implementing DR strategies as per Business Requirements
• Installed, configured and administered Oracle 10g IAS server..
• Maintained database using Oracle Enterprise Manger, Toad, Sqlnavigator and DB Artisan.
• Responsible for Capacity, Scalability Planning and Growth analysis and Co-ordination with Infrastructure team for implementing business solutions.
• Restored the data and objects using DR Environment in the event of Human mistakes.
• Created multiple databases in Netezza server of size 3TB and performed backups.
• Created users, groups in Netezza environment and assigned privs.
• Supported ETL/Inforamitca developers, resolved data mapping issues.
• Involved in the technical analysis of data profiling, mappings, formats, data types and development of data marts.
• Used workflow Manager for Creating, Validating, Testing and running the sequential and concurrent worklets, workflows and sessions.
• Created ETL scripts to load data into Oracle and SQL server.
• Performed loading of the data into Netezza Data Warehouse environment using nzload.
• Identifying the hung user process and resolve the issues.
• Worked with SAS developers in loading the data.
• Extensively used ERWIN tool for data modeling and for schema building scripts etc
• Identified data loading errors and fixed as and when necessary.
• Resolved the load issues into data warehouse netezza environment….using NZLOAD.
• Reclaimed the used space using: nzreclaim and scheduled through cron.
• Performed backups, restores on netezza servers in Data Warehouse Env.
• Administered the Netezza servers on Linux operating systems.
• Extensively involved in troubleshooting of Netezza and Oracle databases.
• Creating the application users with role based access, setting up of system profile options, responsibilities etc
• Implemented session level triggers to restrict the unauthorized access.
• Enforced the complex passwords and expiry of passwords for every 60 days for the users through profiles.
• Created application equivalent accounts to protect schema accounts.
• Applied oracle recommended security patches to protect the dbs from vulnerabilities.
• Supporting of Sarbanes - Oxley compliance databases and PCI standards by implementing User and Security Management in 24X7 environments.
• Installed and configured server software and hardware for SQL Server development and production environments 750GB.
• Create and manage SQL SERVER database maintenance plans and design and implement backup and disaster recovery plans.
• Configured and installed clustered active-active 2005 SQL SERVER dbs.
• Upgraded number of production servers from SQL Server 2005 to SQL Server 2008.
• Configured SQL Server Mirroring for High Availability solution.
• Configured replication technologies: Transactional Replication and Peer 2 Peer replication.

Environment: Oracle 9.2.0, 10g RAC, 11g RAC systems, and VERITAS clustered databases, Sun Solaris 2.8, 2.9 Oracle Enterprise Sun Enterprise Servers 4500, E10k, IBM, Windows XP,SQL Server 2008, and NETEZZA Servers, Informatica 7.1 Business Objects, Erwin.

Confidential, GA

Sr. Oracle/SQL DBA

Responsibilities:

• Configured, automated and monitored the 42 databases, checking alert log files, Contacting Oracle for issues and errors through metalink.
• Installed and configured oracle Apps on 11.5.9 Envs.
• Administed 11i Oracle Apps in multi node envs.
• Used ad utilities in 11i Administration.
• Configured the OEM Grid Control to monitor databases.
• Configured Instances to send alert emails through OEM Grid.
• Ran awr and addm reports through OEM Grid.
• Created and Administered databases with RAW file systems and monitored BCVs.
• Installed and configured the veritas cluster databases and maintaing 15 clustered databases. Switching the dbs onto failover nodes and failing back as necessary.
• Upgraded 15 instances from Oracle 8.1.7.4 to 9.2.0 in VERITAS clustered environments.
• Restored and recovered the databases 500GB databases from backups.
• Installed and configured datamarts, created star schemas in Dataware Housing dbs.
• Worked extensively on tuning….reduced the bactch jobs time from 12 hours to two hours in HR module of People Soft Project.
• Hands on experience in performance tuning: Monitored CPU utilization, identifying high resource intensive processes and fixing the bottlenecks.
• Implemented and enabled audit logging of users.
• Configured and scheduled the jobs through OEM Grid control.
• Advised and worked in removing the operating system access to end users.
• Installed and configured data guard solution to production databases.
• Enforced the auditing of specific user actions.
• Implemented and enable secure roles, privs and implemented sox regulations.
• Applied oracle recommended security patches to protect the dbs from hackers & buffer overflow.
• Password complexity and expiry is enforced to all the database users.
• Implemented and configured Oracle 9ias application server.
• Install and Setup the SQL Backtrack for oracle database backup and extensively used SQLbacktrack for db backups, db cloning etc.
• Creating the application users, setting up of system profile options, responsibilities etc
• Migration of People Soft running on Oracle databases in Solaris Environment..
• Extensively involved in troubleshooting of application and database. Used DB Artisan, Toad, SqlNavigator, ERWIN, Rational Rose tools extensively.
• Performed cloning of the database independently.
• Administered over 50 SQL Server instances of sizes 750GB sizes.
• Ensure that adequate backup procedures exist for all critical SQL Server instances.
• Apply latest SQL Server service packs and hot-fixes to ensure maximum security.
• Designed and configured a SQL Server 2005 cluster system to be used by an internal trouble ticket tracking application.
• Upgraded number of production servers from SQL Server 2000 to SQL Server 2005.
• Configured and implemented SQL Server Log Shipping.
• Created and maintained daily backup and restore jobs. Automated existing tasks as well as created new jobs, DTS packages.
• Supported stand alone and clustered active-passive SQL SERVER dbs.

Environment: Oracle 8.1.7.4,9.2.0,10g RAC Sun Solaris 2.8,2.9 Oracle Enterprise Manager 2.1,Server Manager, Instance Monitor, Sun Enterprise Servers 4500, E10k, IBM AIX, HP UNIX Servers, Windows, SQL Server 2000,2005, People Soft, Business Objects, Micro Stratagy, Erwin, Sqlbacktrack, RMAN

Confidential, Birmingham, GA

Sr. Database Administrator

Responsibilities:

• Configured, automated and Monitored 14 databases, checking alert log files, Contacting Oracle for issues and errors through metal ink.
• Created two Standby Servers and managed them.
• Implemented data guard solution for the critical production databases.
• Refreshing two standby servers to see both Primary instance and standby are sync weekly basis.
• Ran specific scripts to check the process and database node and application nodes.
• Finding the processes, which are taking excessive CPU resources and taking necessary action.
• Performed restoration from backup whenever it is required.
• Bouncing the database and application including stopping the services and starting the services.
• Creating the application users, setting up of system profile options, responsibilities etc
• Extensively involved in troubleshooting of application and database. Used DB Artisan, Toad, SqlNavigator, Erwin, Rational Rose tools extensively.
• Performed cloning of the database independently.
• Supported Peoplesoft Payroll applications on Oracle Database in Unix Env.
• Fixed SQR running issues and worked with developers
• Extensively supported the application users, developers in association with help desk.
• Documented the activities performed.
• Coordinated with different teams involved in the project.

Environment: Oracle 8.0.5, 8.1.6, 8.1.7, 9.2.0 Sun Solaris 2.6, Windows NT, Oracle Enterprise Manager 2.1, Server Manager, Instance Monitor, PeopleSoft, ERWIN, cc Harvest, Sun Enterprise Servers 4500, E10k

Confidential, Atlanta, GA

Apps DBA

Responsibilities:

• Monitoring the two Apps CRM databases of 4TB size, checking alert log files.
• Ran specific scripts to check the process and database node and application nodes.
• Finding the processes, which are taking excessive CPU resources and taking necessary action.
• Performed restoration from backup whenever it is required.
• Installed and configured 9ias application server.
• Bouncing the database and application including stopping the services and starting the services.
• Creating the application users, setting up of system profile options, responsibilities etc
• Extensively involved in troubleshooting of application and database
• Performed cloning of the database and application independently.
• Extensively supported the application users, developers in association with help desk.
• Coordinated with different teams involved in the project.

Environment: Oracle 8.1.6, 8.1.7,9i Sun Solaris 2.7, Windows NT, Oracle Enterprise Manager 2.1,Server Manager, Instance Monitor, Sun Enterprise Servers 4500, E450