SUMMARY:

Over 4+ years of experience as an Oracle DBA in Production, Development and Test environments, and transforming business strategies of various organizations into efficient and integrated global business solutions.

• Expert in Oracle 11g/10g/9i/8i, 11g/10g RAC installation, administration, performance tuning, upgrades on Solaris, HP-UX, AIX, Redhat Enterprise Linux, Windows platforms.
• Good experience in Oracle Database Installation, configuration and Administration, Backup and Recovery, Database Migrations.
• Excellent experience in Performance tuning of oracle databases using Oracle Grid Control AWR, ADDM, STATSPACK, and tuning of SQL scripts using SQL Trace, TKProf, Explain Plan,and Hints.
• Skilled in developing RMAN scripts for database back up including hot and cold backup options for both RAC and standalone instances.
• Good experience in applying Critical Patch Update (CPU Patches) on Databases, Application Servers and Middle Tiers.
• Interface with Oracle technical teams for upgrades, latest version and utilities.
• Well versed in using Oracle Tools (SQL*Loader, Svrmgr, Export/Import), Oracle Enterprise Manager(OEM), SQL* Plus, SQLServer Enterprise Manager
• Disk space management (Tablespace, rollback segment), monitoring (alert log, memory, disk I/O, CPU, database network connectivity). Dealing with Oracle Parameters, SGA tuning.
• Experience in Flashback Versions Query, Flashback Table, Flashback Database, Oracle Data Pump, Export, Import, SQL* Plus, Toad Automatic Workload Repository, performance Tuning.
• Experience in Transportable Table spaces, Automatic Shared Memory Management, Backup & Recovery using hot backups, cold backups, Rman backups with the use of SQL skills.
• Experience with SQL, PL/SQL coding, stored procedures, triggers, functions, packages, UNIX Shell Scripting, Partitioning, Indexes, ERWIN Data modeling, Logical and Physical database design.
• Management of schemas, objects, partitioning the tables, indexes, USERS and PRIVILEGES 10g OEM Grid Monitoring.
• Performance testing and tuning, capacity planning, and database monitoring.
• Performed Database Refreshes.
• Written shell scripts to enable general users to startup, shutdown databases, automate export, backups.
• Strong experience in providing 24/7 support for corporate databases, timely resolution of tickets, and on-call rotation.
• Resolved database network problems using Oracle Net Configuration Assistant(NETCA)
• Strong experience in working with various project, application and infrastructure teams, in large enterprise projects.

Technical Skills

UNIX (Solaris 9, 10, AIX 3.2, 5.3, HP-UX11), Red hat 2.1, 3.x, 4.x, 5.x (32bit, 64bit), Windows 95/98/NT, Windows 2000/XP, Linux, AIX.HP-UX, SCO UNIX, Sun Solaris, Linux, AIX, Windows NT (4.0), Windows. Sql Server 2005/2003/2000,

Databases

Oracle 11gR2, 10gR2, 9i,8i, SQL Server 2005

Oracle Database Tools

SQL*Loader, TKPROF, Toad, SQL Developer, OEM Grid Control, Data guard, SQL*Loader, STATSPACK & AWR, DBCA, Automatic Database Diagnostic Monitor (ADDM) and ASM (Automatic Storage Management), Export/Import, Data Pump, RMAN, SRVCTL, DBCA, Oracle Net,

Tools & Utilities

Winscp3, ERWIN. Putty,Toad 7.5, Unix utilities (awk, sed, vi), ksh, bash. SQL Server 2005/2000, SSIS, SSRS.

Languages

C, C++, JAVA, Unix shell scripts, PL/SQL, Perl

Web Tools

HTML and XML, SQL NET, ODBC, TCP/IP

PROFESSIONAL EXPERIENCE

Confidential, CT Jan 2011 to May 2012

Role: Database Administrator

Maintenance of databases Oracle 9i, 10g on Linux platform, maintaining Oracle databases, Provided on going production support for Oracle Databases. Provided support for IT department with Active Directory, Exchange 2003 and Windows 2003 server technologies.

Responsibilities:

• Daily Health Checkup of the database using Statspack, AWR, ADDM.
• Responsible for administration and supporting Oracle 11g, 10g and 9i databases in DEV, QA, UAT and Prod environments
• 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Downsizing and defragmenting the Large Databases by export/import
• Utilized Oracle Enterprise Manager (OEM) to manage users, privileges, profiles, schemas
• Database monitoring and performance tuning using OEM (Oracle Enterprise Manager), AWR and ADDM
• Performed Upgrade of development, production and QA databases from oracle 10.2.0.3 to Oracle 11gR1.
• Migration of database from oracle 10g to oracle 11g on Sun Solaris server.
• Worked on Automatic Storage Management (ASM) for managing data in SAN
• Monitoring and resolving tickets in different environments
• Export and Import of database objects to copy from one database to another database between different environments
• Planning Backup/Restoration Strategy, Scheduling Backups, Schema backups, taking Logical Backups (with Export/Import Data Pump utilities)
• Extensive Performance Tuning, Memory (SGA) Tuning, Net backup.
• Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups
• Created UNIX shell scripts to automate batch jobs through Cron
• Developed and modified scripts to work efficiently for alerts for ORA error backup and recovery, automatic startup and shutdown databases
• Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc

Environment: Red hat Linux 4.X, IBM-AIX 5.2, Windows2000 Server, Oracle 10gRAC/9i, Toad, Sql-navigator 2000 & 2005, PL/SQL 8.0, SQL*Loader, ODBC, ASM, PL/SQL, OLTP, OEM, Erwin 4.1.2, VERITAS Net backup.

Confidential May 2009 to Dec 2010 
Role: Oracle Database Administrator

Provide Oracle DBA Support for multiple large databases in production and development /test environment .Part of two-member DBA team managing 20 databases. This included 9 Production and 11 development /test. Database were Oracle 10g and 11g where running on Linux platform Sizes of databases varied from 30GB to 2TERABYTE
Responsibilities:

• Administration configuring and monitoring daily backups, troubleshooting errors, to improve performance.
• Managing Security, User groups and Users by using roles, grants, privileges and Profiles.
• Creating new environments for data loading and manipulation for various states in the US, according to the specification provided by Century Link.
• Assisting the ETL team to improve performance by analyzing SQL statements, reorganizing database objects and design indexes to improve response of queries.
• Involved in the documentation of every task involved in the recovery issues or backups.
• Setting up and monitoring Cron jobs to schedule database backups with the help of RMAN scripts and daily night exports.
• Monitoring Growth of tables and undertaking necessary re-organization of tables and indexes as and when required.
• Tuned and optimized SQL Query, SGA and monitoring the statspack report generated from snapshots taken at the peak business hours.
• Monitored and tuned rollback segment, temporary tablespace, redo log buffer, sort area size.
• Monitored & maintained as necessary the following: Alert logs for instances, backups, database connection availability directly & via SQL*Net, database process count, exports & their backups, listener for SQL*Net and space in Oracle owned file systems.
• Extensively involved in design physical and logical models of the database using ERWIN.
• Used Explain Plan to monitor the query execution and views to make sure the operations run without roadblocks.
• Troubleshooting Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).
• Creation of various database objects including materialized views.
• Troubleshooting errors and using the expdp/impdp utiliy on a very regular basis for copying data across schemas.
• Running scripts and monitoring the load process to avoid roadblocks in ETL jobs running for a long duration.
• Troubleshooting expdp/impdp errors, configuring storage accordingly.
• Monitored Database growth and provide Database capacity planning for applications expansion.
• Upgraded from 9.2.0.x to 10.2.0.x.
• Performing Database Administration activities like space management, user and roles administration, schema management, checking alert log of all the databases.

Environment: Oracle 10g , Oracle 9i/10i, PL/SQL, SQL*Plus, SQL*Loader, Toad, UNIX, Sun solaris, Oracle Enterprise Manager, RMAN, performance tuning, Data pump.

Confidential Jan 2008 to May 2009

Role: Jr.Oracle Database Administrator

This project focused on the support activities carried out for the Database Administration activities. Provide database support to production and test servers. Database was running on Linux platform. Part of two member DBA team managed the databases.There were 4 instances of Oracle databases, 2 running on solaris and 2 on SQL Server. Maintenance of Oracle Databases
Responsibilities:

• Installation of Oracle Databases for the Development environment on Redhat Linux and Windows 2000.
• Managing access rights to various users/schemas.
• Monitored the utilization of Database Objects.
• Proactively monitoring the database’s health and taking preventive or corrective actions.
• Defining the system parameters according to the database requirement
• Ensure data consistency in the database
• Looking into day-to-day activities of Production database, Monitoring its growth and performance.
• Monitoring and Managing Storage space (physical and logical structures).
• Monitoring Alert logs, Audit and trace files, Archive logs, and Diagnostic files.
• Performing Backup and Recovery activities at different levels of Hot backups, Cold backups, Export and Import (logical).
• Performing other activities like Script running , Scheduling activities, Generating Stats pack reports, Tkprof , SQL*Loader.
• Providing 24x7 DBA support during the implementation phase.
• Oracle database creation and cloning for test and development instances.
• Estimated database capacity managed system disk space and system resources.
• Estimation, Sizing & Tuning for various databases objects.
• Backup and Recoveries(RMAN)
• Creating database using OMF on ASM Disk Groups.
• Upgrading database to oracle 10g. Applying patches.
• Giving DBA support to 25 applications teams, performance issues, and structure changes as per the requirements. Using Erwin model to design the schemas.
• Monitoring Data guard and RAC databases.
• Database up gradation to Oracle 10g.
• Using list partitions for large tables and bitmap indexes for the OLAP databases.

.Environment: Redhat Linux, Sun Solaris, Windows 98/NT/2000, Oracle 9i, 10g, Oracle Enterprise Manager, STATSPACK, TKPROF, EXPLAIN PLAN, RMAN.

EDUCATION: Master’s in Computer Science