SUMMARY

• About 6 years of IT experience includes expertise in Database Analysis and Administration of Oracle Databases. Excellent experience in Database upgradation, backup, recovery and maintenance.
• Proficient in Oracle DBA activities including installation, migration, configuration, physical and logical database design, backup, recovery of oracle databases.
• Experience in Confidential - UX, AIX, SUN SOLARIS, LINUX and WINDOWS environments.
• Management of Schemas, Objects, Partitioning the tables & indexes.
• Monitoring and management of various database components (logical & physical) like table-spaces, segments.
• Excellent knowledge in Hot/Cold Backup, Recovery and Cloning of databases using RMAN.
• Worked on export/import, data pump and SQL- loader.
• Worked on Oracle tools: Forms, Reports, SQL Plus, PL/SQL, RMAN, Export /Import/Loader).
• Good performance tuning experience, specializing in Operating System Tuning, SQL Tuning, Database/Instance Tuning.
• Worked on setup, installation and maintenance of Oracle Real application clusters (RAC).
• Extensively Used Database Administration tools like Oracle Enterprise manager, DBA Studio, SQL*PLUS, TOAD.
• Experienced in setup and maintenance of both logical and physical standby database using Oracle Dataguard.
• Good experience in SQL, PL/SQL, Shell Scripting, Partitioning, Data modeling, OLAP, Logical and Physical Database Design, Backup and Recovery procedures.
• Worked as a team member to provide 24x7 on-call production database support.
• Expertise in maintaining Database Security using security compliance auditing, expertise in loading data from flat files using external tables, SQL*LOADER, Oracle Enterprise Manager.
• Experienced in migration of applications: Forms & Reports from 6i to 11g.
• Worked on setup and configuration of Oracle Web-logic server and Access Manager.
• Very good team player, self motivated, dedicated in any work environment as well as keen interest in emerging technologies.

TECHNICAL SKILLS

Operating Systems: Confidential -UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2, IBM, Red Hat Linux RHEL 2.x, 3.x, 4.x and Windows 95/98/NT/2000/XP.

RDBMS: Oracle 11g/10g/9i/8.x/7.x, Oracle 10g Real Application Clusters

Languages: SQL, PL/SQL, VB.NET, C, C++, XML, UNIX Shell Scripting.

DB Management: TOAD 10.x, 7.x, OEM 9.2

Tools/Utilities: RMAN, OEM, Oracle Management Server, SQL*Loader, SQL Server, Export/Import, TOAD, Data pump, Query builder, Net Backup, VB, Crystal Report, MS Access

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK

Database  Modeling: Erwin 4.0

Hardware Platforms: Sun Fire 15K, Sun Fire 6800, Sun V480, V240, Sun Enterprise 6500 / 450, Confidential XP256 / XP512, IBM X series Server, and various PC desktop and servers.

PROFESSIONAL EXPERIENCE

Confidential,Carmel, Indiana 

 Oracle DBA

Environment: Oracle 9i/10g/11g, PL/SQL, Oracle Enterprise Manager, SQL*Loader, Red Hat Linux, Windows XP,Windows Server 2000, Toad, Sql Plus

Responsibilities:

• Installation, Implementation and maintenance of Oracle databases.
• Worked as the primary Oracle DBA for the whole unit of one of the key branches of the U.S Census Bureau.
• Create the users, roles, schemas with suitable permissions.
• Analyzed, designed, and upgraded the application from client-server form 6i architecture to web-enabled 11g architecture.
• Installed and Configured Oracle Weblogic Server for migration of Oracle Forms & Reports to 11g.
• Installed and configured Oracle Internet Directory OID server, Oracle Access Manager OAM server, and Forms and Reports running on Weblogic 10.3.5 server.
• Installed and Configured Oracle Single Sign-On (SSO), Managed SSO with OAM and OID to support Applications in addition to Oracle Forms and Reports services.
• Installed and configured Oracle Access Manager for Single Sign on, integration with OID 11g and Active Directory.
• Member of the pre and post GO LIVE team for production support. Resolving underlying GO LIVE performance issues.
• Upgraded client from 10g to 11g with ASM.
• Assisted developers and/or users with identifying performance issues and tuning queries and scripts.
• Monitored databases and perform tuning enhancements to optimize their performance.
• Upgrade Databases from 9i to 10g and 11g using RMAN.
• Migration and setup of Oracle Windows Servers from 32-bit to 64-bit servers.
• Creating and managing the database objects such as tables, indexes and views.
• Setup profiles for different users with appropriate security measures.
• Schema backup and refresh on a daily basis from prod to dev and dev to prod and test.
• Apply quarterly patches supplied by Oracle on all production and non-production databases.
• Setup and implemented the Oracle Benchmark Security procedures on all the company’s databases.
• Creating and managing the database storage structures, which include index table spaces, rollback table spaces and rollback segments.
• Monitor all database activity for operational improvements to include, but not limited to; CPU, Disk and Memory utilization, replication and consistency of all parameters across the enterprise.
• Upgrading 10g databases into 11gR2 by using both silent mode and DBUA utility
• Analyzed the database objects using TOAD and assigning and altering the profiles of the Database schemas for security purposes.
• Resolving Oracle listener and TNS names problems by using Net Manager and Oracle Net Configuration assistant. Export and import of database objects.
• Loading the database from text-files using SQL*Loader.
• Create Database Links on different databases for interaction with other Oracle and non-Oracle Databases.
• Setup ODBC Connections for interaction with Sql-Server and other non-Oracle Databases.
• Responsible for creating scripts to load data into production databases using Scheduled Jobs.
• Instance cloning done to create test and training environments
• Setup and maintain Oracle Hot and Cold Backup procedures using RMAN.
• Primarily responsible for monitoring database day-to-day jobs and backups.
• Test RMAN backups and restore/recover procedures from time to time by restoring backups on Test databases.
• Test and monitor the logical backups using Oracle DataPump utility.
• Move all Forms & Reports into Production and maintain Backup copies of both source data and executables.
• Responsible to troubleshoot both Oracle applications and backend data base errors.
• Setup meetings and involved in decisions on future database growth and sizing.
• Involved in team for setup and installation of Oracle OAM - Oracle Access Manager.
• Worked on Forms and Reports 6i and 11g.
• Involved in the setup and configuration of Oracle 11g Forms & Reports.
• Database maintenance including backups, recovery, imports/exports.
• Improve the database performance by Using the Hints, Indexes, Explain Plan and TKPROF for effective retrieval and processing of queries.
• Monitoring the database daily activities.

Oracle Database Administrator

Environment: Oracle 10g/9i, Sun Solaris 9/10, Windows NT / 2000, AIX 5.2, TOAD 7.5.0.0/7.6 , ERWIN 4.0, RMAN, SQL server, OEM 9.2, TOAD 7.5.0.0.

Responsibilities:

• 24x7 production support for several mission critical systems, which utilize multiple Oracle databases.
• Installation of Oracle 10g RAC and 10g Non RAC Databases includes CRS and Applying Patches.
• Upgrading databases to Oracle 10g from Oracle 9i .
• System Study & Analysis, Design &Development.
• Created users and roles.
• Creating and managing the database objects such as tables, indexes and views.
• Manage users, privileges, profiles, schemas using Oracle Enterprise Manager (OEM).
• Data Refresh in Prod, Dev and Test Environments using Data Pump.
• Set up, configured and maintained oracle data guard (primary and standby databases) to ensure disaster recovery, high availability and data protection.
• Coordinate with Unix Administrators for space management on various servers and help in Oracle.
• Data Refresh in Test and Integration Databases using Transportable Table spaces.
• Worked on Data Replication using Materialized views, Snapshot, Streams.
• Supported Test and Development environments to ensure smooth transition of applications into production.
• Apply quarterly patches supplied by Oracle on all production and non-production databases.
• Configuration and Installation of Oracle Internet Directory (OID).
• Work and close all Remedy Tickets ranging from database access to user account creation, modification.
• Worked on import/export and datapump.
• Monitor the various database activities such as backup, error logs, space, object, performance, user and session monitoring to ensure proper capacity and availability
• Installed and Implemented Backup & Recovery procedures. Implemented Hot, Cold and Logical backup plans.
• Setup backup and recovery procedures using RMAN.
• Performed Database and SQL tuning by using various Tools like STATSPACK, TKPROF, EXPLAIN PLAN, and optimizer hints.

 Oracle Database Administrator

Environment: Oracle 10g/9i, Sun Solaris 9,Red Hat Linux 3.x/4.x, Confidential -UX, Oracle Enterprise Manager, SQL, PL/SQL, TOAD 7.5.0.0, RMAN, TPROF, STATSPACK, SQL* Loader, Windows XP/2000.

Responsibilities:

• Performed day-to-day DBA jobs for managing Prod/Dev databases.
• Installed 9i, applied patches in various environments and upgraded databases from 9i to 10g.
• Creating Databases, Creating table spaces with storage parameters.
• Performed maintenance tasks on existing test and production environments that included modifying database sizes and migrating changes through various environments.
• Created users and roles. Analyzed tables and re-built indexes regularly.
• Audited database for statements, privileges, and schema objects.
• Creating the database schema, converting VIEWS specific to database.
• Monitoring backups, exporting/importing data, Data Pump, database full backup, incremental backups and recoveries, Flashback, Transportable Tablespaces, Partitioning and Streams.
• Developed/customized UNIX shell scripts to automate routine DBA tasks.
• Recovered successfully three production databases from RMAN backups due to an unexpected media failure resulting in data corruption errors and lost control files.
• Monitored the various database activities such as backup, error logs, space, object, performance, user and session monitoring to ensure proper capacity and availability.
• Part of team which did installation and setup of backups.
• Utilized Oracle Enterprise Manager (OEM) to manage users, privileges, profiles, schemas.
• Utilized SQL*loader and data pump import to load data into tables.
• Created and implemented Oracle database backup and recovery strategies using RMAN.
• Performed Database and SQL tuning by using various Tools like STATSPACK, TKPROF, EXPLAIN PLAN, optimizer hints and SQL tuning advisor.
• Provided 24X7 support for production problems.

Oracle DBA

Environment: Oracle 8i/9i,10g, SQL, PL/SQL, TOAD, Oracle Enterprise Manager, Erwin, SQL*Loader, Sun Solaris, Red Hat Linux, Windows XP.

Responsibilities:

• Installation, Design, Implementation and maintenance of Oracle databases.
• Create the users, roles, schemas, stored procedures with suitable permissions.
• Creating and managing the database objects such as tables, indexes and views.
• Creating and managing the database storage structures, which include index table spaces, rollback table spaces and rollback segments.
• Resolving Oracle listener and TNS names problems by using Net Manager and Oracle Net Configuration assistant. Export and import of database objects.
• Upgrade from 8i to 9i and 9i to 10g and migrate databases of all production databases.
• Schema Refresh from prod to dev when needed and dev to prod and test.
• Setup and test disaster recovery solutions using Active Dataguard.
• Data refresh in test, dev and prod environment using Database links.
• Accomplish day-to-day requirements of User Community.
• Instance cloning done to create test and training environments.
• Responsible to troubleshoot both Oracle applications and backend database errors.
• Maintain the logical and physical structure of tables, indexes, roles etc.
• Database maintenance including backups, recovery, datapump imports and exports.
• Monitor the database daily performance and activities.

 Oracle DBA

Environment: Oracle 8i/9i, SQL, PL/SQL, TOAD, Oracle Enterprise Manager, SQL*Loader, Sun Solaris, Red Hat Linux, Windows XP.

Responsibilities:

• Installation, Implementation and maintenance of Oracle databases.
• Create the users, roles, schemas with suitable permissions.
• Creating and managing the database objects such as tables, indexes and views.
• Creating and managing the database storage structures which include index table spaces, rollback table spaces and rollback segments.
• Resolving Oracle listener and TNS names problems by using Net Manager and Oracle Net Configuration assistant. Export and import of database objects.
• Upgrade from 8i to 9i and 9i to 10g and migrate databases of all production databases.
• Schema Refresh from prod to dev when needed and dev to prod.
• Timing of Database Disaster Recovery & Restoration.
• Routine Reorganization of Databases, hot backup recovery exercises.
• Accomplish day-to-day requirements of User Community.
• Instance cloning done to create test and training environments
• Responsible to troubleshoot both Oracle applications and backend data base errors.
• Performing the logical and physical structure of tables, indexes, modeling normalization and foreign key constraints.
• Database maintenance including backups, recovery, imports/exports.
• Monitoring the database daily activities.

Confidential

Oracle Developer/DBA

Environment: Windows 95, 98/NT / 2000, Oracle 8i/9i, Sun Solaris, AIX, SQL Loader

Responsibilities:

• Installation, Implementation and maintenance of Oracle databases.
• Create the users, roles, schemas with suitable/appropriate permissions.
• Responsible for administering and supporting production and development Oracle 7/8i/9i databases.
• Responsible for installing, upgrading and configuring the Oracle server, creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.
• Creating triggers, sequences. Developing procedures and packages.
• Designed backup and recovery procedures.
• Sizing the databases for future growth.
• Partitioning of large tables to increase the database performance.
• Responsible to troubleshoot both Oracle applications and backend data base errors.
• Configured scripts to monitor activity of the database.
• Resolving Oracle listener and TNS names problems by using Net Manager and Oracle Net Configuration assistant.
• Loading the database with SQL*Loader.
• Responsible for optimizing the queries and application tuning.
• Implement Hot, Cold and Logical backup plans.