Oracle DBA

• Over 6 years of experience as an Oracle Database Administrator, Responsible for database administration, production support, installation, configuration, upgrades, patches, backup and recovery, database security, auditing and space management.
• Installation and configuration of Oracle 8i, 9i, 10gRAC, 11gRAC databases in LINUX, HP-UX, SOLARIS, IBM AIX and Windows environments.
• Planned and implemented Oracle 10g RAC, 11g RAC and Standby Databases Data Guard for High availability and Disaster Recovery DR .
• Experience in upgrading the database from Oracle 9i to Oracle 10g oracle 10g to oracle 11g and migration of the databases using transportable database, tablespaces export/import, data pump utilities.
• Used Opatch utility for applying CPU and One-off patches RDBMS patch set Upgrade PSU .
• Installed and configured oracle Grid control and deployed agent on managed targets.
• Good experience with Oracle grid control, Oracle enterprise manager OEM , ASM, AWR, ADDM, Flashback Technology, SQL tuning advisor, SQL access advisor, and SQL server undo advisor.
• Experienced on creating DB links across databases and performed advanced replications using Oracle Streams and Golden Gate.
• Designed and implemented centralized backups and recovery strategies using recovery manager RMAN .
• Expertise on performing cold backups, hot backups, advanced recovery methods like PITR and TSPITR, flash back recovery.
• Cloning of the databases
• Experience in using SQL, PL/SQL stored procedures, indexes, materialized views, shell scripting, partitioned and non-portioned tables, packages and triggers for improved performance of the database.
• Performance Tuning: Experience in identified poor SQL statements using EXPLAIN PLAN, STATSPACK, TKPROF, SQL TRACE, OEM Grid Monitoring.
• Expertise in maintaining Database Roles, Users using Security Compliance Auditing, expertise in loading data from Flat Files using SQL LOADER and External Table.
• Experience in using the oracle support Metalink for Service Requests SR database log files related performance issues, Remote Diagnostic Agent RDA .
• Good experience in managing Very Large OLTP and Datawarehousing databases.
• Involved in Data modeling, logical and physical database designs and worked as on-call support team member for administering OLTP 24X7 production databases.
• Excellent communication skills, strong analytical logical abilities, problem solving skills and fast learning.

Technical Skills:

• Databases: Oracle 8i, 9i, 10gRAC, 11gRAC, SQL Server 2005 and 2008.
• Operating Systems: Red Hat Linux, HP-UX, Sun Solaris and Windows.
• Languages: SQL, PL/SQL, C, Shell Scripting, Pearl Scripting.
• Utilities: RMAN, Oracle 11g Grid Control, Data Guard, Performance Tuning, EXP, IMP, Datapump, SQL developer, Veritas NetBackup.
• Tools: TKPROF, TOAD, EXPLAIN PLAN, AWR, STATSPACK, ADDM, ASH, AUTO Trace.

Responsibilities:

• Installed and configured Oracle Enterprise Manager 10G/11G Grid Control for Enterprise.
• Configured and managed physical standby database using Data Guard for disaster recovery on a different node for different production servers.
• Performed Data Guard switchover/failover as per the requirements.
• Created monitoring scripts to send alerts in case standby is out of sync.
• Configuring and Managing two nodes UNIX RAC environment for high availability, highly busy databases.
• Worked in Oracle 10g/11g RAC environment and troubleshooting for RAC issues.
• Worked on RAC/ASM interconnect issue.
• Worked with Developers and change management team to ensure smooth life cycle progress from development through testing and production implementation.
• Provided 24/7 production support for infrastructure and performance areas.
• Performed the migration and up-gradation of Oracle databases by using import/export, Oracle Data Pump, and Transportable tablespaces.
• Day to day troubleshooting like adding space in data files, rebuilding indexes, check alert log file and monitoring of system.
• Cloned databases on same node and also on different server nodes using custom shell script with hot and cold backups of source database.
• Upgraded and patched Oracle binaries in the development environment and production environment.
• Upgraded Oracle from 11.2.0.1 to 11.2.0.3.
• Worked on shareplex replication for databases through multisite databases.
• Performed load testing on pre production multisite database servers.
• Coding and optimizing objects for data access.
• Responsible for setting up production, development, performance and staging database environments.
• Reorganized existing database to standardize the placement of various databases related files.
• Managed logical/physical backups for these databases depending on the nature of database set up either full export, partial export or export of just the structure of schema objects.
• Monitored and audited database access for unauthorized access.
• Work as part of team and provide 24x7 supports when required.
• Do general technical trouble shooting and give consultation to development teams.
• Have Applied Patches to existing versions.
• Created tablespaces and managed tablespaces adding/deleting/ resizing data files.
• Utilized SQL Loader ETL to perform bulk data loads into database tables from external data files.
• Use of Crontab, DBMS JOBS to automate the monitoring jobs.
• Performance tuning of application by identifying the SQL, which are not written well providing inputs to the application programmer correcting and implementing the right components.
• Administered all database installation, creation, modification, and tuning issues of Oracle.
• Performed SQL tuning by using Explain Plan and AWR/ADDM.
• Tuned SQL by buffer gets and I/O.
• Generated working documentation for the DBA team use.
• Analysis of alert log for error tracing.
• Resolved different locking issues.
• Worked on daily DBA activities.

Environment: Oracle 10g/11g, Sun Solaris, AIX, TOAD, OEM, ADDM/AWR, SQL, RMAN, OEM12c, SQL Loader, ERWIN Data Modeller, Dell Shareplex, Refelection X, Humming Bird Exceed .

Responsibilities:

• 24x7 product database support. Served as a member of 24-hour on call support staff.
• Supported round the clock deployments for OLTP and DWH environments.
• Installed the 11gR2 databases for test, development, production-like, production and standby databases
• Migration of the database from Solaris to Linux
• Upgraded Oracle Database from 10g to 11g
• Cloned 10g and 11g oracle homes for setting up standby databases and recovery purposes.
• Installed grid agents and setup the databases per standards for monitoring and scheduling jobs.
• Used traditional export-import and DataPump for refreshing schemas, tables and different objects.
• Used Export/Import, Data Pump Utilities to move the data between different databases and for backups.
• Applied security related CPU and One-off patches using Opatch utility, Applied RDBMS Patch set Utility PSU .
• Recovery of Database Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption .
• Generated performance reports and Daily health checkup of the database.
• Monitoring heavy data loads from tools like Informatica and optimizing the performance bottleneck.
• Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL Trace, TKPROF, STATSPACK, AWR and ADDM reports.
• Worked closely with the project teams to deploy their changes in the database and servers.

Environment: Oracle 9i/10g/11g, Linux, Solaris, PLSQL, Shell Scripting, RMAN, Grid control, Data Guard, EXP, IMP, Data Pump, TKPROF, EXPLAIN PLAN, AWR, STATSPACK, ADDM, ASH.

Responsibilities:

• 24x7 product database support
• Installed and maintained 10g/11g databases for testing, development and production
• Database Monitoring and administration of database using Enterprise Manager Grid control OEM .
• Upgraded Oracle Database from 9i to 10g, 10g to 11g.
• Migration of the database from HP-UX to Linux.
• Planned and implemented Oracle 10g RAC, 11g RAC, Standby databases fro High Availability and DR solutions
• Cloning of the database from Production to the Test and Development environments using RMAN and conventional methods.
• Applied security related CPU and One-off patches using Opatch utility, Applied RDBMS Patch set Utility PSU .
• Installed and configured oracle grid control.
• Used Oracle Streams for replications of data between remote databases
• Performed Cold backup, hot backup using conventional back ups and RMAN, recovered various and critical Production databases.
• Prepared backup schedule which include offline, online and logical backups.
• Used Export/Import, Data Pump Utilities to move the data between different databases and for backups.
• Worked on transportation of Tablespaces, Data Archival, Re-organization of tables and restoration.
• Tuning of Shared Pool, Library Cache, and Data Dictionary Cache.
• Monitor CPU usage, I/O contention, memory paging on UNIX server. Identify resource and performance bottleneck. Provide technical direction to system administrators
• Rebuilding of Indexes for better performance, maintenance of Oracle Database.
• Generated performance reports and Daily health check up of the database using utilities like AWR, Statspack and ADDM to gather performance statistics.
• Identified and tuned poor SQL statements using EXPLAIN PLAN, SQL TRACE and TKPROF, Analyzed tables, indexes for improving the performance of the Query.
• Analyzed SQL statements, re-organized database objects and created indexes to improve the performance of the queries.
• Partition of tables to improve performance.
• Created users and allocated appropriate table space quotas with necessary privileges and roles for all databases.
• Worked with Oracle Support for resolving the database related unresolved issues.
• Worked on SQL Loader to load data from flat files, Checking for Row Migration and Chaining on Highly used transaction tables.
• Configured TNSNAMES.ORA and LISTENER.ORA for SQL NET connectivity.
• Created DB links across databases and Solved Database connectivity issues by continuously monitoring the status of the listeners and instances.
• Monitored overall system performance and Database growth.
• Served as a member of 24-hour on call support staff.
• Checked alert logs and background trace files on daily basis and resolved problems.
• Scheduled jobs in the database using CRON Jobs and DBMS JOBS.
• Implemented backup for production database. Simulated few possible crucial recovery scenarios using the current available backups to check the effectiveness of the backup plans and also to get a rough estimate of the recovery time involved.
• Automated shell scripts and scheduled batch jobs.

Environment: Oracle 9i/10gRAC/11gRAC, Red Hat Linux, Windows, HP-UX, Sun Solaris, AIX, SQL Server, PLSQL, Shell Scripting, RMAN, Grid control, Data Guard, SQL Loader, EXP, IMP, Data Pump, TOAD, TKPROF, EXPLAIN PLAN, AWR, STATSPACK, ADDM, ASH.

Responsibilities:

• Installed and configured Oracle RDBMS on UNIX and Windows environments.
• Responsible for administering and supporting production and development Oracle 9i Databases.
• Responsible for installing, upgrade and configuring the Oracle Server, Creating Databases, Storage Structures and Objects, Database Backup and Recovery, Monitoring and Optimizing Database Performance.
• Creating primary database Storage Structures table spaces, rollback segments, etc .
• Participated in Disaster Recovery Drills, documented database and application validation steps
• Cloned Environments to create Patch Test, Development and QA Environments.
• Applied patches using Opatch utility, keeping applications software bug free, and improving data integrity.
• Applied High priority, Security Patches downloaded from Metalink.
• Establish and Document Backup and Recovery strategies and procedures after evaluating various options including RMAN.
• Maintained all documents of Oracle Database operations. Prepared documentation of database backup and recovery standards.
• Developing, Testing and Implementing Sound Backup and Recovery Strategy.
• Developing Hot, cold and logical backup scripts to automate the backup procedures.
• Planning for storage spaces requirements and placing them for optimum I/O performance.
• Tuning the databases for optimal performance.
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.
• Monitoring Scheduled jobs of the daily activities for the performance of all the databases
• Partitioning Tables by determining the suitable methodology to improve performance and manageability.
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Prepare the documents of the process and knowledge transferring about the project to the new team members.
• Monitoring the Database storage and Day to Day activities.
• Configured Scripts to monitor activity with database.
• Partitioned large tables to increase the performance.
• Created PL/SQL procedures jobs to automate maintenance tasks.
• Performing all daily Maintenance tasks. Interacting with Oracle Customer service as and when required.
• Generated scripts for daily maintenance activity like analyzing tables/indexes, and monitoring their growth rate.
• Having systems administration experience managing enterprise application.

Environment: ORACLE 8i/9i/10gRAC, RedHat Linux, SUN SOLARIS, IBM AIX OEM, RMAN, Tkprof, Windows NT, EXP, IMP.

Responsibilities:

• Installed and maintained Oracle 9i software on Linux systems.
• Migration of the database from sun Solaris to Linux.
• Monitoring of hot backups, exports on Linux and Windows.
• Performed Refresh of databases on Linux servers
• Create Schema Tables, Indexes, views, sequences, synonyms, roles, and packages , grant roles to users.
• Monitor databases using OEM, re-organization of database tables and indexes.
• Tested and implemented different physical, logical Backups and Recovery methods like point in time recovery, Media recovery, full and partial recovery using export, import.
• Partitioned appropriate tables to optimize performance and simplified maintenance work.
• Write various SQL and PL/SQL scripts and procedures to support applications.
• Set up and administered tablespaces, data files, tables, indexes, views and sequences Configured and managed users, security and Redologs.
• Performed database cloning to create Test and Development environments from Production.
• Implemented Physical Standby database using DataGuard in ORACLE9i/10g.
• Performance tuning for Oracle Day-to-day maintenance and management of the several different databases in development, test, regression and production environments proactively monitoring production environment for any exceptions/ issues.
• Have written shell scripts for automation of various database-monitoring activities.

Environment: Oracle 10g, 8i, 9i, SQL, PL/SQL, Linux, Sun Solaris, TOAD.