SUMMARY:

• To pursue a challenging career as an Oracle DBA in a dynamic organization in information technology by making a long term contribution to the organization successfully through consistent hard work, sincerity and dedication

TECHNICAL SKILLS:

Database Administration: Oracle 8i - 11g, SQL Server, Access 97-2005, DB2Teradata, Sybase

Platforms: UNIX, Solaris, Linux, Windows 2003-Server 2005, HP-UX, AIX

High-Availability: Real Application Clusters (RAC) 9i-11g, Data Guard, RMAN, HP Service Guard, VERITAS Cluster Server, Oracle Failsafe

Enterprise Database Tools: Oracle Designer, CA Erwin, OEM/EM Grid Control (Enterprise Manager), Toad & Quest Central Suite of Products, Oracle Warehouse Builder (OWB)

Application Servers: OAS 4.X.X, 9iAS, OAS 10g, Weblogic 6-8, Apache/Tomcat, IIS

Application Systems: Oracle Applications 10.7-11i, SCT Banner, Siebel

Programming: SAS, VB, Java/J2EE, PL/SQL, SQL, C++, Java Script, HTML, PHP, Perl

Other: Project Management, Business and System Analysis, ETL, Data Integration, Data Modeling, Data Architecture Design, Data Warehouse, OLTP and OLAP, Apache 1.3, Shareplex, Advanced Replication, Oracle Streams, Oracle financial application systems (GL, AR, AP, HR), Oracle CRM, TCA, UWQ, Forms, Report Writer, MS Project 2000/2002, ERP systems, SDLC, EDI, MS Office Suite (Word, Excel, PowerPoint, Outlook, Visio), ODBC, ftp, Microsoft Internet Explorer, Netscape and Opera Internet browsers, ISO 900 Toolkit, Statistical and Econometric Analysis

PROFESSIONAL EXPERIENCE:

Confidential, Peoria, IL

Mid-Level Oracle DBA

Responsibilities:

• Responsible in providing Level 2 and Level 3 support of 300+ Production Oracle databases (most of them are RAC and Data-Guard environments) with on-call production support on rotation basis in 24/7environment.
• Provide customer production and developer support
• Support medium scale production database applications on multiple operating systems
• Troubleshooting oracle errors and providing support to customers and developers.
• Apply patches for oracle databases; Management of Physical Standby database using oracle Data Guard.
• Recovery of production databases at the crisis situation in time.oracle
• Administration of Backup and Recovery using RMAN.
• Management of backup pieces and backup sets using RMAN.
• Writing Shell Scripts on various UNIX, AIX, HP-UX and Linux Servers for automation of day to day database jobs like Start up - Shutdown, Export Backups as per necessary.
• Management of User Policies, Roles and Profiles for production Databases.
• Alert log monitoring of Oracle Database.
• Managing Users: creating users, synonyms, privileges, roles, quotas
• Managing table spaces, objects, profiles, storage parameters.
• Work on BMC remedy and incident tickets and update / resolve the tickets within the SLA.
• Involved in working with TSM and Storage architects and Network professionals in relevant Issues and change management.
• Architect Golden Gate (11.x) replication solutions to facilitate data flow between

Environment: s: Oracle (9i-11g), Rac,Data Guard, ASM, BMC, SLA, Grid Control, Aix, Hp-UX, Linux and Window 2008 Servers, Putty, WinCp, Toad, Grid Control, TSM, RMAN, Oracle Support, Golden Gate

Confidential

Independent Contractor

Responsibilities:

• Installed and Configured 3 Node RAC and added 1 Node to make it a 4 Node RAC.
• Upgraded the database from 10g to 11gR2
• Installed & Configured Oracle 10g Grid Control for monitoring over 80 Prod / Non Prod Hosts.
• Maintaining Production and Development Instances of Oracle.
• Installing, Upgrading/migrating, Security Administration of Oracle Server/databases 10g, 11g.
• Cloning of different versions of Oracle.
• Installation and Maintenance of RMAN 10g for Full and Incremental backups and working with Oracle Enterprise Manager (OEM 10g) grid control for Management Reporting and control.
• Regular maintenance of database including creating databases, tables, tablespaces, data objects, privileges, indexes, Security User Management, Roles, Auditing, Profiling, Authentication.
• Applying Application Patches, Developer Patches and Server Technology/OPatch Patches to Oracle.
• Upgraded the Oracle 10.2.0.4 Grid Control Setup Including OMS, Database and Agent to version 11g
• Troubleshoot Database Performance Tuning issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM). Tuned database for optimum performance.
• Data Modeling, Database Design and Creation
• Created Partitioned tables using Range, hash, list partitioning to improve performance and manageability
• Writing scripts for backup and recovery, Import and export procedure.
• Setting up new environments (Development, Production etc)

Environment: s: UNIX, Linux Servers, Powerbroker, Windows Servers 2008, Oracle 11g/10g, 11i-12R, CA Erwin, Informix, Datapump, Toad

Confidential, California

Oracle DBA

Responsibilities:

• Installed and configured oracle 9i and 10g, 11g database on Dev/Test/Prod system.
• Day to day monitoring like availability of system, listener, database, alter log file, trace file. Developed UNIX shell script to monitor database.
• Performed Daily Monitoring of Oracle instances using OEM Grid Control, TOAD to monitor users, table spaces, memory structures, rollback segments, logs, and alerts.
• Created Partitioned tables using Range, hash, list partitioning to improve performance and manageability.
• Provided disaster recovery by configuring and maintaining physical standby database using oracle Data Guard.
• Worked on database cloning to make Production instance available for Test and Development.
• Created users and involved in database security by granting roles, privileges, and profile to users.
• Configured Auditing to audit information about database activity.
• Created database object like tables, indexes, views, synonyms, sequences.
• Developed PL\SQL stored procedure, package, triggers, cursors, and views.
• Performed, developed and maintained database backup and recovery using RMAN.
• Performed logical backup of database, schemas, tables using Export/Import and DATA PUMP utility.
• Analyzed database object tables, indexes to get statistics.
• Worked closely with Development DBA teams on trouble-shooting SQL issues impacting database performance and uptime.
• A six member DBA team providing support for 10 oracle instances with database sizes for 100 GB to 5 TB.
• A 4 member of Oracle DBA team and oracle database size was 100 GB to 5 TB

Enviornments: Linux Server, Autosys, Crontab, Unix, Oracle 10g r2/11g r2, ASM, RAC, Golden gate, Exadata, Windows Server 2003, Sybase, Dashboards, Toad, SQL Developer.

Confidential

Oracle DBA from

Responsibilities:

• Database capacity Planning and Volumetric Analysis for the database more than 0.5 PB. Involved in the Implementation of Data Guard and RAC technologies in mission critical systems and configured Switch over and Failovers with Physical standby database on UNIX environments.
• Upgrade/Migration databases from Oracle 9i to Oracle 10g
• Installation, Configuration and Administration of Oracle 10g RAC
• Configured the Public Network/Private Interconnect for Oracle 10g RAC
• Converted a single instance database to Oracle 10g RAC.
• Installing ASM environment and migrating database from NON-ASM to ASM.
• Setting up and testing the backup and recovery strategies.
• A 10 member of oracle DBA team database size was half petabytes (500 Terabytes) with 100 test data instances and 15 production instances.

Environment: s: Data Guard, OEM, Oracle 10g r2, RAC, non-ASM and ASM, AIX, Linux Servers

Confidential, Tampa, Florida

Oracle DBA from

Responsibilities:

• Fulfill customer service requests for SQL and database tuning, software patches and upgrades, as well as database migration and duplication. Major projects include migrations to upgrade Oracle 9i database to Oracle 10g and hardware and software testing.
• Responsible to trouble shooting requests for Oracle bugs, suggestion as an expert development and implementation of backup/recovery strategies, configuring replication environments, as well as database process automation.
• Proactively monitor 10g Oracle environments for multiple customers. Resolve database incidents to ensure database availability and stability.
• A 5 member of oracle DBA team with database size 50 gb to 450 gb and 30 test and development databases and 10 production instances.
• Performed disaster recovery for a production database which went offline after the server was moved to a new Sun box. Recovered a testing server after accidentally deleting all its syslogins entries including sa login

Environment: s: Crontab, Oracle 10g, AIX, HP-UX, Window Server 2003, Solaris, Export-Import Utilities, Putty, PHP

Confidential, Tampa, FL

DBA from

Responsibilities:

• Coordinated Back-ups, Restores, Scheduling, Maintenance and Disaster Recovery planning for SQL
• Perform security updates for all user types
• Responsible in Transitioning from SQL 2000 to SQL 2005. Develop plans and manage and execute complex technical efforts
• Perform DTS packages, Perform Link Servers and work with T-SQL, write Stored Procedures, perform Database storage migration
• Develop Documentation for all Databases by understanding of complex logical to physical DB structures

Confidential, Manhattan, NY

Project Manager

Responsibilities:

• Led a team of 45 employees for website creation that included production timetable, cost control and project coordination. Maintained documentation for a possible clients’ requirements
• Conducted one on one session with the clients to assess client needs and expectations and ensure project delivery within deadline.
• Responsible for status reporting, client communication & coordinating with the project management team for timely completion and quality maintenance of projects
• Implemented new production methodologies that resulted in optimizing employee’s time to finish the tasks, thus enhancing employee efficiency
• Responsible for streamlining work processes in various teams that include quality control, human resource, communication management and design
• Contributing to company’s growth by means of business development, Client retention and securing strategic partnerships
• Interacted directly with CEO, project managers, VPS, developers for the relevant technical issues of this Human Resource Management Portal development company.