Oracle Dba Resume
RI
SUMMARY
- Over 6 years of experience as Oracle Data Base Administrator, providing 24/7 support for both development and production 11g/10g/9i/8i databases on Various Platforms.
- Proficient in Oracle Database Administration activities such as production support, installation, configuration, upgrades, patches, TAR support, tuning, backup and recovery, cloning, space management, database security, auditing, script development and documentation.
- In - depth noledge of Oracle internals and architecture.
- Experience in installation, configuration and administration of Oracle 9i/10g/11g databases running on different environments like HP-UX, SUN SOLARIS, AIX, Red Hat Linux and Windows
- Implementation of High Availability solutions with Oracle 10g/11g RAC, Physical and Logical Standby /Data Guard Databases.
- Experience in Installation, configuration of Oracle RAC 10g/11g R1/R2 on different platforms such as Solaris and Linux and AIX.
- Experience in Oracle Streams and Gloden Gate installation and configuration for database replication.
- Hands on Experience in installation and configuration of OEM grid control and administration of databases.
- Extensively worked on logical backups (export/import or data pump), Hot/Cold Backup, Recovery and cloning of databases using RMAN(Incremental and Cumulative)
- Excellent experience in performance tuning using STATSPACK, AWR, ADDM, EXPLAIN PLAN, SQL TRACE, and TKPROF.
- Hands on Experience in Upgradation and Migration of Database by applying patches (CPU, PSU, Interim Patches) using OPatch utility and PatchSet using Universal Installer.
- Worked on OLTP/DW database systems, managing large Oracle databases (VLDB).
- Proficient in using Flashback Technology, Log Miner, Automatic Storage Manager (ASM) & Automatic Database Diagnostic Manager (ADDM).
- Good Exposure in translating business requirements into creation of database objects: tables, indexes, constraints, packages, Triggers, stored procedures and functions using Oracle tools.
- Experience in installation and administration of SQL Server 2005/2008.
- Hands on experience in Install, Configure and troubleshooting all SQL & SSRS related issues.
- Hands-on experience in implementing enterprise databases on enterprise storage solutions using Storage Area Networks (SAN) / Network Attached Storage (NAS).
- Expertise in Data Modeling, Logical and Physical Database design using ERWIN and Rational Rose.
- Good experience in resolving the issues related to installation, upgrades and patches.
- Excellent Troubleshooting skills in OS level and Database level
- Proficient in T-SQL, SQL, PL/SQL, Shell Scripting.
- Excellent experience in providing 24x7 on-call support.
- Excellent interpersonal skills, team player, aggressive, hardworking and result oriented.
- Developed TEMPeffective working relationships with client team to understand support requirements, develop tactical and strategic plans to implement technology solutions, and TEMPeffectively manage client expectation.
TECHNICAL SKILLS
Operating Systems: HP-UX 10.x, 11.x, Sun Solaris 8, 9, 10, AIX 5.1, 5.2, 5.3 Red Hat Linux RHEL 3.x, 4.x, 5.x Unix and Windows 95/98/ME/NT/2000/XP.
RDBMS: Oracle 8i/9i/10g/11g, Oracle RAC 10g/11g, MYSQL, MS Access
Languages: SQL, PL/SQL, UNIX Shell Scripting, Java Script, PERL, C, C++, JAVA
Tools: SQL*Plus, TOAD, Oracle Workflow Builder 2.6 Testing Tools, FTP Tool, ERWIN Tool
Database Modeling: Erwin 4.0, Rational rose
Other: EMC, NetApp, VERITAS Net Backup, TSM, HP Data Protector
Storage technologies: NAS, SAN, QFS, Replication manager (RM), Tape Library
Utilities (Oracle): SQL*LOADER, IMPORT & EXPORT, Data pump, STATSPACK, EXPLAIN PLAN, TKPROF, RMAN, OEM, TKPROF, Data guard, ASM
PROFESSIONAL EXPERIENCE
Confidential, RI
Oracle DBA
Responsibilities:
- Supporting 24*7 production database systems with on-call pager.
- Involved in installation and configuration of Oracle 11gR2 RAC and Oracle 10g RAC in Linux Environment.
- Involved in setting up the ASM for oracle RAC environment.
- Involved in RAC administration using utilities such as CRSCTL, SRVCTL, CLUVFY, ASMCMD, OCRCONFIG, OCRDUMP, and OCRCHECK.
- Installation and configuration of SQL Server 2008 in Windows environment.
- Designed and implemented the SQL Server replication, mirroring, maintenance plans.
- Responsible for SSRS troubleshooting issues.
- Setup of Physical Standby Database (Data Guard) for faster Disaster Recovery.
- Installed and Configured OEM grid control for maintenance administering the databases.
- Successfully done the migration of databases from oracle 10g to 11GR2.
- Involved in implementation of Gloden Gate replication tool.
- Performed full and incremental backups using RMAN for development and production databases.
- Database cloning from Production to Test and Development environments.
- Extensively worked on applying patches (CPU&PSU) whenever required.
- Monitoring Table spaces and extent Growth.
- Daily Health Check Up of the Database.
- Monitoring the Hit Ratios and tuning the System Global Area (SGA) accordingly.
- Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace, TKPROF, STATSPACK, AWR, ADDM.
- Experience in Identifying performance bottlenecks on high volume transaction systems. Analyze SQL statements, reorganize database objects and design indexes to improve response of queries.
- Upgradation and Migration of Database from 10g to 11g and applying patches whenever required.
- Job scheduling using crontab and DBMS SCHEDULER.
- Query optimization for reporting and ETL.
- Creation of database maintenance plans, rebuild indexes and integrity checks.
- Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
- Ensure high availability of Databases at all time.
- Developing and Implementing Disaster Recovery (DR) Plan.
- Performed cross-platform migration (AIX to LINUX) using Transportable Table space (TTS).
- Support migration and loading of data into oracle database using Sql*loader.
- Provided support on performance issues during project development resulting in improved response times and reduced contention.
- Intensively involved in the area of installations of Oracle Software, Configuration for database and day-to-day routine works for database administration.
- Responsible for database, schema refresh and granting roles, privileges, and permissions.
- Developed PL/SQL programs (Functions, Procedures, Packages and Triggers).
- Database Management - Backup, & Recovery, Performance Tuning, Configuration of Database, Table space administration, User management, and Index management.
- Writing UNIX shell scripts for backup and recovery, Import and export procedures.
Environment: Oracle 9i/10g/11g RAC, OEM, RMAN, HP-UX, Sun Solaris, RHEL, TOAD, Data Guard, Data Pump, SQL*Loader, SQL server 2008, Gloden Gate 10.4
Confidential, CA
Oracle DBA
Responsibilities:
- Responsible for installation, up-gradation of oracle (9i, 10g, 11g) software in different Environments, Creating and maintaining oracle development and test databases.
- Supported development and testing databases with database ranging from 100GB to 2TB.
- 24*7 On-Call production support.
- Designed and installed 10g and 11gASM and Flash back Recovery.
- Provided support in maintenance of RAC using ASM.
- Installed Grid control components such as OMR, OMS.
- Configuration of Oracle OEM (Oracle Enterprise Manager) to monitor database and report on events as defined by the DBA group.
- Involved in installation of SQL Server 2005.
- Involved in Implementing and Maintenance of Database availability with Cluster Management, Database mirroring, Log shipping, Replication.
- Moving and deploying Sql Server databases into development or testing environments.
- Responsible for monitoring SQL Error log, Event Log for error and issues.
- Responsible for implementing the table level replication using Oracle Streams (unidirectional),
- Deployed Management Agents on various hosts.
- Enabled secure communications throughout the grid control framework.
- Configured Oracle Streams for replication between two databases.
- Cloning the instances for testing, development and integration testing.
- Responsible for optimizing the queries and application tuning.
- High-Availability Setup using Datagaurd.
- Detect corrupted blocks by using DBVERIFY utility.
- Used Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitor (ADDM) in RAC for Performance Tuning.
- Developed Complex Resource Plans for Optimum utilization of Resources
- Implemented Security through Virtual Private Database and Fine grained Auditing.
- Performed Database Migration from one platform to another using Transportable Table spaces.
- Used RMAN and Oracle Secure Backup to back up and restore the database.
- Used various internal views for monitoring the database.
- Developed RMAN scripts for database backup and recovery.
- Designed and implemented the database servers for two new data centers.
- Generated scripts for daily maintenance activity like analyzing the tables/indexes, monitoring their growth rate, monitoring the TEMPeffective use of SGA etc.
- Perform production system problem analysis and recommend corrective measures in a timely manner.
- Managed security in a complex and sensitive environments.
Environment: AIX, Solaris, Oracle10g RAC/9i/10g/11g, OEM grid Control, Data Guard, Data Pump, SQL*Loader, ASM, Oracle Streams, SQL Server 2005
Confidential, Ashburn, VA
Oracle DBA
Responsibilities:
- Involved in 24x7 support for production database systems with on-call pager
- Designed and implemented the Oracle 10g RAC with ASM in AIX platform.
- Led creation of the Oracle 10g physical standby database. Implemented switch the standby to read only mode for reporting purpose during business hours and switch to recovery mode at night to apply the logs.
- Setup and configure Standby database (Physical & Logical) for high availability using Data Guard.
- Designed, documented, implemented and maintained all Disaster Recovery procedures
- Loaded the huge experiment data to the database via SQL* Loader
- Migrating Oracle 9i database to Oracle 10g. Installing Oracle Patch. Migrating production database to new server.
- Designing the logical and physical database structure.
- Designing the security and database access strategies.
- Logical and Physical data modeling using ERWIN 4.0.
- Taking Backups on scheduled time and monitoring scheduled Backups.
- Performing backups and recoveries using RMAN/ conventional hot backups.
- Establish and Document Backup and Recovery strategies and procedures after evaluating various options including RMAN incremental backups.
- Creating and dropping of users, granting and revoking rights as and when required.
- Cloning databases for development and testing.
- Tuning heavy data loads. Monitoring and Performance tuning.
- Performance tuning Using TKPROF, EXPLAIN PLAN, STATSPACK for the Better performance.
- Performance tuning involving Memory, Disk I/O tuning and SQL tuning.
- Partitioning strategies for very large tables.
- Diagnose and troubleshoot Database problems and failures
- Implementing range, list partitions, hash sub partitions.
- Creating and refreshing materialized views.
- Performing Sql*loader jobs for data loading.
- Monitoring of database for growth and performance
- Ensuring proper online and offline backup.
- Periodical reading and checking of backups taken.
- Monitoring Growth of tables and undertaking necessary re-organization of tables and indexes as and when required.
Environment: Oracle 10g/9i RAC, OEM, RMAN, SQL*Plus, AIX, RHEL, Data Pump, Data Guard, ASM
Confidential, Fort Worth, Texas
Oracle DBA
Responsibilities:
- Responsible for installing, maintaining, performance tuning, and monitoring of Oracle databases version 10g.
- Involved in data extraction and load operations using SQL*Loader utility for data warehousing application. Significantly reduced the time for data load using SQL Loader Direct Path and Parallel Load.
- Involved in Performance/Application tuning at the server level (identifying and modifying Init.ora parameters).
- Used RMAN for Hot/Cold backups and Recovery. Used Export/import Utility.
- Created backup scripts and ensured backups were occurring as expected.
- Fixed errors related to connectivity issues involving SQLNET, TNSNAMES, and Listener etc.
- Setup the Data guard environment, for Maximum Performance operation.
- Analyzed query Explain Plans and Statistics to write efficient Queries/Stored procedures.
- Partitioned tables to improve performance issues.
- De-fragmented the existing databases and Re-organized Objects.
- Monitoring of Oracle Databases using UNIX scripts, ESM for database connectivity, table spaces monitoring, object growth and checking Alert logs for errors etc.
- Initiated and coordinated on database stress tests, analyzed the results and made recommendations for design and coding changes.
- Modified the control files to change the "MAXDATAFILES" parameter.
- Changed the "SID" of the oracle database for testing purpose.
- Worked on Installation of Oracle10g Databases, Migration of Oracle Databases from 9i to 10g.
- Provided DBA support to terabyte Data warehouse databases.
- Configured Standby Database for Disaster Recovery using Data guard.
- Managed Database clusters and failover of databases.
- Logical and Physical Modeling using ERWIN Data Modeler.
Environment: HP-UX 11.0, Red Hat Linux, Oracle 9i/10g, Windows 2000/NT, Oracle OEM, RMAN, SQL *Loader, Data Guard