Oracle Dba Resume
GA
SUMMARY:
- 7 years of experience as an Oracle Database Administrator, working with prestigious organizations having hands on experience in database administration production, support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management, database security & auditing
- Proven Experience with 10g Release 2, 9.2.0.2 - 9.2.07, 8.1.7.4 and 8x versions
- Proven experience with database performance and tuning techniques to enhance database optimization plans.
- Experienced in Performance Tuning using EXPLAIN PLAN, TKPROF, and STATSPACK
- Experience with Oracle 11g/10gRAC/9i/8i in Installation, Administration, Monitoring, Maintenance, Performance Tuning, Database Backup and Recovery
- Knowledge of SQL analysis tools and database internal debuggers including ORADEBUG
- Proficient with Database Cloning, Migration, Standby Database, Data Guard and Patching of Oracle Databases and Oracle Applications
- Installed Oracle 10g RAC with ASM and OCFS2 File systems.
- Involved in different scenarios of OLTP as well as DSS (Data warehouse) databases
- Have implemented ORACLE STREAMS, and two types of standby databases supported by DATAGUARD, logical standby and physical standby databases
- Extensive Experience with RMAN Backups, Hot Backups and Logical Backups
- Experienced in using 10g features like 10g RMAN, Data pump Flash-Back Recovery and ASM
- Knowledge of Database Recovery Techniques and implementation of those recovery techniques to ensure business continuity
- Expertise in maintaining Database Security using auditing
- Experience in Data Migrations.
- Extensive knowledge in VMS and UNIX platforms includes HP, SOLARIS, AIX, and LINUX.
- Experienced in Disaster Recovery setup.
- Skilled in dealing with ASM environment such as Installation, taking backup, migration from NON-ASM to ASM environment.
- Worked on STANDBY databases.
- SQL- Query optimization expertise, including data integrity analysis for application customization testing, and creating analytical metrics.
- Implementing EDI X12, EDIFACT transaction sets, XML and flat files.
- Awareness on Oracle Support processes for technical requests through Metalink.
TECHNICAL SKILLS
Operating Systems
HP-UX 10.x, 11.x, VMS, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2,
Red Hat Linux RHEL 2.1, 3.x, 4.x and Windows 95/98/ME/NT/2000/XP.
RDBMS
Oracle 10g/9i/8i , SQL Server 2000/2005/2008
Languages
SQL, PL/SQL, UNIX
Tools/Utilities
RMAN, OEM, SQL*Loader, SQL Server, EXP, IMP, expdp, impdp, TOAD,VB
Tuning Tools
TKPROF, EXPLAIN PLAN, STATSPACK
Database Modeling
Erwin 4.0, Rational rose, Toad Data Modeller, Datanamic and start UML, ER/studio
Other
EMC, NetApp, Veritas NetBackup, TSM, HP Data Protector, IBM, VCS, MCSG
WORK EXPERIENCE
Confidential,
GA
Duration: Dec 2010 to till date
Role: Oracle DBA
Environment: Oracle 10g/9i ,Sun Solaris ,Red Hat Linux, HP-UX, Oracle Enterprise Manager, SQL, PL/SQL, TOAD, RMAN, TKPROF, STATSPACK, SQL* Loader.
Responsibilities:
- Skilled with STATSPACK, AWR, ADDM, SAR to check health of database & hardware.
- Using the tools such as TKPROF, EXPLAIN PLAN, ORADEBUG and TRACE FILE to tune SQL Queries.
- Performed database Cloning to setup test and development database.
- Conducting sizing & capacity planning for Oracle databases.
- Worked on designing, installing & maintaining CRS, RAC, Dataguard components of Oracle.
- Writing SHELL SCRIPTS for the system and database for effective functionality and report generation.
- Up gradation and Migration of Database from 9i to 10g and applying patches whenever required.
- Maintaining schemas and partitioning tables.
- Submitted Perl Reports, by pulling the information from the databases.
- Experienced with all kinds(Status, Performance, Trend Analysis) of DB MONITORING
- Provided ERD diagrams using the ERWIN tool and developed physical and logical models of the databases.
- Rebuilding of Indexes for better performance, maintenance of Oracle Database
- Developed RMAN scripts for database backup and recovery including hot and cold backup options for both RAC and stand alone instances
- Creating table spaces, tables, and users for custom applications.
- Creating and dropping of users, granting and revoking permissions to users/roles as and when required.
- Experienced with SPACE MANAGEMENT and SECURITY.
- Upgrade and Migration of Database from 9.2.0.6 to 10.2.0.2 and applying patches whenever required.
- Experienced with precise (DB performance tuning tool)
- Implemented Oracle Streams for the replication of data.
- Used all types of Normalization techniques for the normalization of data.
- Worked on Data modeling tool POWER DESIGNER.
- Implemented oracle high availability solution using oracle 10g PHYSICAL STANDBY.
- Importing data from flat files into database using SQL loader and External Tables.
- Worked with a team working on sql clustering.
Confidential,
NH
Duration: Jan 2009 – Nov 2010
Role: Database Administrator
Environment: Tru64, Oracle 11g, 10g/9i Enterprise Edition, (OWB) Oracle Warehouse Builder 10g, Veritas Clusterware, Veritas Volume Manager, Veritas NetBackup, SQL, SQL*Loader, Exp/Imp, RMAN, Oracle Enterprise Manager (OEM), Windows 2003/XP.
Responsibilities:
- Install and configure Data Guard environments.
- Configure RMAN repository for Oracle 11g and 10g environments, implement RMAN backup/recovery schedules for all the Oracle Databases and configure Veritas Net Backup (TAPE) schedules.
- Configured RMAN for online/offline backups.
- 24X7 Production Support. 11g, 10g, and 9i databases, 10g RAC in UNIX(Tru64) and Windows.
- Implemented database mirroring for constant availability of sales force automation and production routing.
- Migration of SQL Server Database into Oracle DB.
- Involved extensively in installation and configuration of Oracle 10.2 Grid control and configured above 60 DBs under Grid monitoring.
- Developed a performance & tuning system using for Oracle, implemented role-based security, and established SQL*Net
- Implementing Tablespace encryption and column level encryption – Transparent Data Encryption (TDE).
- Extensive experience with Oracle Warehouse Builder creating Star schemas slowly changing dimensions, Partitioned Materialized Views & Logs utilizing, Query Rewrite, Star Transformation, Query Equivalence, Snow Flake Star Schema.
- Create the SQL-BackTrack catalog on the computer that is the primary node in your RAC environment.
- Tuning the performance of the databases with respect to memory, I/O, and contention.
- Managing OLTP/Data Warehousing and OLAP Databases.
- Installed and implemented new databases, Migrated / Upgraded database, applied patches as necessary.
- Implemented designing conceptual model into physical model (schema). Supporting Legato backup configurations.
- Setup Oracle Streams for replication and data.
- Configured the Streams capture process at the Schema level for DML / DDL capture in excluding a specific DML operation from the capture process.
- Manage Oracle Streams Advanced Queuing and Application messaging.
- Installation of Oracle databases and evaluation of the hardware for the Database Servers.
- Created partition of tables & Tuning on UNIX system administration.
- Setting up and creating table partitions using Oracle Spatial for better performance and manageability.
- Storage management using ASM.
- Installed and implemented new databases, Migrated / Upgraded database, applied patches as necessary.
- Installation, configuration of oracle and Instance and database designing.
- Implemented designing conceptual model into physical model (schema).
- Data Modeling and transformation of data from legacy Database using PowerDesigner.
- Run daily Reports on the db parameters and suggested the performance tuning (OS level, Application Level and DB level).
Confidential,
CA
Duration: Apr 2007 to Dec 2008
Role: Database Administrator
Environment: Sun Solaris 2.8, AIX/V5.1, OPS, RAC, Oracle 10g / 9i, Stored Procedures, Functions, Database Triggers, SQL, SQL*Loader, Data Pump, Exp/Imp, RMAN, Oracle Enterprise Manager (OEM).
Responsibilities
- Installation of Oracle 10g/9i and Creating Databases based on specifications.
- Applied patches to Oracle databases in order to configure and connect other applications to databases.
- Performing upgrades of the databases and software to new releases.
- Monitoring growth of the database objects for managing datafiles.
- Regular Monitoring Alert Files on Day to Day Basis.
- Migrating schemas from development to test and test to production databases.
- Created index or rebuild index in order to improve query performance in Oracle.
- Managed System Users, security and system monitoring for development / production environment.
- Administered Oracle 10g / 9i and Infrastructure support (315 GB) VLDB using Oracle OEM.
- Implemented ARCHIVE LOG Process and procedures for automatic copying files to development server as they generated.
- Backup and Recovery set up through RMAN, Data Pump Export / Import utility.
- Performed installation, configuration, deployment, migration and up gradation of oracle database servers
- Good knowledge of Materialized Views concepts.
- Experience using SQL*LOADER.
- Developed Backup and Recovery strategy and Maintained User managed backup and RMAN.
- Performed cloning of Oracle 9i base.
- Performed Database Performance Tuning and Monitoring of Databases.
- SQL tuning using Explain plan. Familiar with Rule and Cost based optimizers.
- Performed Database security and Auditing.
- Creation and Maintenance of Oracle Data Guard.
- Determining the RAC architecture
- Provided System support for both development and 24/7 production environment.
Confidential,
India.
Role:Database Administrator
Duration: Jan 2005 - Mar 2007
Environment:Oracle 8i / 9i, OEM, RMAN, DBCA, TOAD, Erwin, UNIX, Sun Solaris, Red Hat Linux, SQLServer, AIX.
Responsibilities:
- Managed in-house Oracle Databases running on various operating systems like Windows NT and Linux.
- Installation of Oracle Database and Oracle products.
- Implementing Backup/Recovery Strategies.
- Using Enterprise Backup utilities for backup.
- Writing scripts for backup and recovery.
- System tuning for better performance.
- Creating users and maintaining database security.
- Worked with application developers to debug PL/SQL procedure, tune queries and database sizing.
- Designing and enforcing standards and naming conventions.
- Writing technical manuals.
- Co-coordinated, and delivered Oracle courses such as Database Administration, database security, enterprise backup and recovery solutions, PL/SQL concepts.
- Writing UNIX shell scripts for backup and recovery.
- Supervised the installation and configuration of Oracle databases on Linux and Windows NT
- Writing SQL scripts to monitor database performance.
- Writing SQL Loader control files for data loading to the payroll system.
- Problem trouble shooting and resolution.
- Database installation and instance creation.
- Database tuning, backup and recovery and general day to day running of the system.
- Systems analysis and design.
- Creating project plans and implementation schedules.