SUMMARY

• 7+ years of extensive experience as an Oracle DBA in Production, Test and Development Databases.
• Worked in 24/7 Production Environment and Managing project ranging from simple to complex implementation.
• Designing, Installing, Migrating, Updating, Configuring, Exporting, Importing, Recovery, Tuning the Databases.
• Managing, planning, installing, and maintaining the Oracle Databases and upgrading the database to the new releases.
• Better understanding of Oracle 8i/9i/10g/11g and RAC Architectures, Oracle Enterprise Manager(OEM), good knowledge in Unix and as well as Windows operating systems and having strong analytical, problem solving capabilities
• Coding PL/SQL using cursors, triggers, stored procedures, functions and packages. .
• Installed and Configured the Oracle Databases (8i/9i/10g/11g) RDBMS, Performing Pre - installation and Post-installation Tasks.
• Involved in User Management by creating grants, roles and profiles to the users thereby providing Security to the Databases.
• Assigning Roles to the different users and creating / modifying different Privileges to the Particular Roles and Creating profiles and assigning the profiles to the Different users.
• Involved in Password Management by creating/ managing passwords of the different users and managing the password attributes such as grace time, life time and No. Of attempts etc.
• Configured Oracle Flashback Database by using Flashback drop, Flashback Query, Flashback Transaction, Flashback Table features in Oracle 11g databases to recover or restore the Database.
• Configured in RMAN-Managed backups to create Hot and Cold database backups. Performed Backup/Recovery with RMAN/Script to the Disk and SBT Tapes. Performed Consistent, Inconsistent Backups in Archive and No Archive Modes subsequently.
• Perform hot and cold backups using scripts and also using Oracle Enterprise Manager.
• Worked in Stream Environment . Replicating Data Using Oracle Streams.
• Involved in Loading and Transforming Data using SQL*Loader and External Tables and have Working Experience using Toad, Putty, and SQL Developer tools.
• Worked extensively onsite-offsite co-ordination as lead. Monitoring the Remote site operations and assist them in solving the problems.
• Implemented Export and Import using original Export/Import method and Data pump in Oracle 11g Databases.
• Worked on Very Large Oracle databases(VLDB) Memory ranging from 100’s of GB up to 100 TB
• Installed, configured and maintained ASM enabled RAC. Creating and configuring the Clusterware and its components. Creating and configuring voting disks, oracle cluster registry (OCR) in Unix Operating systems.
• Performing the backup of RAC of all the instances. Also applying critical patches and patch sets to the database.
• Created databases by Database Configuration Assistant (DBCA) and as well as scripts and Performing the database upgrades in oracle database from 10.2.0.3 to 11.1.0.6
• Configured the Flash back recovery area in 11g oracle for single instance and RAC with multiple instances.
• Involved in Performance Tuning by SQL Tuning, Index Tuning, Top Activity List Using Oracle Enterprise Manager (OEM ), Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM).
• Monitoring the Active Session History (ASH) and Tuning the Performance by the Top Activity List.
• Problem Solving, Critical Thinking Skills, leadership qualities, expert level manageability skills. Very strong analytical skills and willingness to work in any environment. A very good team player, self motivated, dedicated in any work environment.

TECHNICAL SKILLS

Operating Systems: Red hat Linux (4.0/5.0), UNIX, Windows 7/XP/ 2003/2008

Databases: Oracle 9i/10g/11g R1/R2, RAC, MS-ACCESS

Database Tools: SQL Developer, Toad, OEM

Tuning: OEM, ADDM, ASH, AWR, EXPLAIN PLAN, Memory Advisor

Languages: SQL, PL/SQL, HTML,XML, C, C++, C#, UNIX Shell Scripting, Java, PHP

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Senior Oracle DBA

Responsibilities:

• 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Installation, Configuration and Administration of Oracle 10g/11g databases include Database cloning for test environment and applying patches, tuning etc. Installed the database software and selected from various options in the product to configure it for the purpose being deployed. New releases and patches are appropriately decided and applied.
• Cloned or refreshed the database using the production backups in the development and test environments.
• Developed PL/SQL programs (Functions, Procedures, Packages and Triggers).
• Database Management - Backup, & Recovery, Performance Tuning, Configuration of Database, Table space administration, User management, Index management
• Developed UNIX shell and SQL scripts for database monitoring and database backups.
• Successfully implementing Data Guard on physical and logical standby databases.
• Implementation and support of Oracle standby databases, and multimaster advanced replication in an environment.
• Worked in Streams Environment. Used to replicate data using Oracle Streams. Replicating tables to the Remote nodes.
• Designed and implemented Oracle 10g RAC on a 3 node cluster on RHEL 4 for the Pricing Enhancements project. Designing the RAC on 2 node cluster on windows 2008.
• Creating and configuring the ASM (Automatic Storage Management). Creating voting disk and OCR (at least 5 partitions 280 MB each). Configured SCAN and SCAN Listeners on 11g R2 RAC.
• Handling management and administration of Oracle Clusterware components like backing up Voting disks and OCR periodically.
• Experience with DBUA/Export and Import to migrate the database. Successfully export / import from/to Crash Dump file.
• Perform Instance tuning using tools like Stats pack etc. Generated regular Stats-Pack reports for the performance tuning of the databases.
• Running ADDM/AWR reports periodically to analyze the performance of Instances/Services/Databases.
• Responsible for optimizing data access and performance by tuning indexes, SQL Tuning. Assisted developers in tuning SQL statements in the applications. Monitoring the Active Session History for each session. Effective use of OEM to find the Cause of performance degradation.
• Identified bottlenecks like large query process time that are slowing down processing and proposed a strategy to remove them using Explain Plan, hints, Toad and Enterprise Manager.
• Used SQL TRACE, TKPROF, EXPLAIN PLAN, AUTOTRACE, STATSPACK, AWR and ADDM reports for performance issues resolution.
• Generated Automatic Workload Repository (AWR) report to collect processes and maintained performance statistics for problem detection & self tuning purposes.
• Generated Automatic Database Diagnostic Monitor (ADDM) in order to analyze data in the Automatic Workload Repository (AWR) in order to identify potential performance bottlenecks
• Designed and implemented crash recovery strategies, and Hot, Cold and Logical backup plans. Taking periodic Backup of the Database and the software using Recovery Manager

Environment: Red Hat Linux 4,5, UNIX, ORACLE 10g R2, 11g R1, R2, OEM, OAM, Data Pump, RMAN, Toad, Data Guard, Unix shell scripts .

Confidential, Sacramento

Senior Oracle DBA

Responsibilities:

• Maintenance and monitoring of oracle 10g database instances hosted on Linux and Sun platform. Oracle installation, creation of database, which includes physical and logical design. Oracle Security Patches Installation on Oracle 10g R2.
• Installation and configuration of Oracle Database Software Creation and configuration of database development, testing and production purposes.
• Designed and implemented Oracle 11g RAC on a 4 node cluster on RHEL 4 to support OLAP and OLTP applications with a 4 node Data guard configuration. Created database services for Workload management and Load balancing.
• Frequent Database audits to maintain the security standards.
• Managing RAC databases. Adding nodes and applying patches to the nodes.
• Testing the problems of database connectivity and troubleshooting.
• Administrated all database objects, including tables, clusters, indexes, views, packages and procedures.
• Cloned database for development needs.
• Documenting the database setup, backup details and other procedures. Performing test restore of database backups periodically
• Performing logical backups using export/import
• Recovery management and supervision of the technical team to restore the database in-case of system failure.
• Monitor and test database backup periodically by restoring them. Monitoring database backup status.
• Performing test restore of database backups periodically, testing and validating backups using Recovery Manager.
• Performed Import and Export using Oracle Data pump utilities, Export/Import.
• Experience in configuring Data guard for physical standby database.
• Partitioning of large tables (List, Hash, and Range) for fine tuning performance.
• Running ADDM/AWR reports periodically to analyze the performance of Instances/Services/Databases.
• Worked on training DBA team and Data analyst on the tool to explain about how code changes across source and target for various workflows could be tracked and analyzed for any potential impact on overall performance

Environment: Red Hat Linux 4, Oracle 11g R1, 10g R2Data Guard, Oracle Streams, Toad, Data Pump, RMAN, PL/SQLUNIX Shell Script

Confidential

Oracle DBA

Responsibilities:

• Providing 24x7 on call support for the business critical production real application cluster databases.
• Installed and configured oracle9i databases on Red-Hat Linux servers. Installing patches and upgrades for the database. Performed Database migration from Oracle 9.2.0. To 10.1.0.3.
• Managing two nodes Real Application Cluster databases on Red hat Linux advanced server 2.1. Managing ASM instances for RAC.
• Identify the training needs of the team. Participated in data model review meetings with other Data designers and Data Architects internally and across multiple teams
• Identified and trouble shot everyday issues like locking, scripts execution, Data Audits etc.
• Performing various test recovery scenarios at database, tablespace, datafile levels.
• Managing database structure, storage allocation, table/index segments, rollback/undo segments, constraints, database access, roles and privileges.
• Granting different privileges, roles to the user as well as application. Creating profiles and allocating to the different users to access the particular applications.
• Created and managed both system level and object level roles and privileges for various users. Killing sessions and revoking user privileges and roles.
• Worked on export and import utilities. Performing logical backups using export/import as and when required
• Loading external data into the database using SQL*Loader
• Backup and recovery utilizing RMAN. Responsible to see that database backup and recovery strategies are in place, and to coordinate with Network
• Involved onsite-offsite co-ordination as lead.
• Services and/or Data Center personnel to keep the integrity of the physical system backups.
• Responsible for optimizing data access and performance by tuning indexes.

Environment: Red Hat Linux 4, Oracle 9i, 10gRMAN, Data Guard, Oracle Streams, Oracle Enterprise ManagerPL/SQL, UNIX shells scripts.

Confidential, Garland, TX

Oracle DBA

Responsibilities:

• Analyzing, Creation of database, database structure, database users, and provide technical support. Managed physical and logical components of database.
• Creation of Table spaces, tables, users, roles in Oracle Space Management, which includes table space creation, adding new data files. Monitoring disk space and tablespace usage.
• Security administration such as privileges, roles and assigning passwords on the tables, stored procedures, and Firing triggers and constraints objects depending on role.
• Performing hot/cold backups of the database. Implemented RMAN using recovery catalog
• Used SQL*Loader to load data from flat files to Oracle database. Loading external data into the database using SQL Loader
• Actively involved in Backup Management of Disaster Crash recovery supporting 24-7 assurance.
• DBA activities including creation, management, startup and shutdown of Oracle databases, management of data files, redo log files, control files, tablespaces, segments, extents.
• Backups and Recovery i.e. exports/ imports, hot backups and cold backups, etc.
• Monitoring and Management of database users
• Worked as Production Support for Oracle based systems and UNIX based Server environments. Implemented automated backup strategy using the UNIX shell script
• Performed Backup and Recovery using RMAN. Using optimizer for the RMAN backups. Creating retention and deleting policies whenever required.
• Using flashback database recovery to particular timestamp or SCN.
• Tuning performance using AWR, ASH and ADDM. Also Tuning by SQL Tuning, Tuning by Indexes.

Environment: Oracle 9i, 10g, Red Hat Linux 4

Confidential

Data Admin

Responsibilities:

• Responsible for Oracle 9i administration and maintenance. Managed and resolved design issues during development and suggested standards to ensure that all design was produced with proper integrity, security and performance
• Responsible for writing database programming to Store/Retrieve the information from the database using SQL
• Actively planned to ensure that any new product usage or release upgrade takes place with minimal impact along with the application developers and System administrators.
• Handling Database storage. Planned and initiated disaster recovery strategy.
• Scheduling jobs through Oracle job Scheduler.
• Used SQL*Plus to query the data Monitoring temporary tablespace.
• Monitoring diskspace usage at the OS level and tablespace level.
• Performed Table space Management and Rollback table space Management, Transaction Management and Security Management.
• Maintain Physical Standby database and performing switchover/failover when required.
• Re-org of tables, indexes as and when required.
• Creation of tables, indexes, constraints, procedures, functions and packages based on the design.
• Involved extensively in development of PL/SQL Packages, Stored procedures, Triggers,
• Monitoring of database for growth and performance
• Defined backup procedures using daily hot backups and weekly cold backups.
• Database Tuning using init parameters, optimizing rollback segments, redo log configuration, and I/O distribution.
• Tuning of I/O includes separating data files and redoing log files on different locations, separating of data files and index files on different locations, reducing disk contentions.
• Running ADDM/AWR reports periodically to analyze the performance of Instances/Services/Databases.
• Moved database Schema changes to stage or production and Work as part of a team and provide 24X7 support when required.

Environment: Oracle 9i, Red Hat Linux 4