Database Administrator Resume

SUMMARY

Over 7+ years of experience as an Oracle DBA on Linux, UNIX & Windows platforms.
Database Administrator with extensive experience in Installation, Upgradation, Migration, Backup and Recovery, Cloning, Replication, Database Security, Memory Management, Data Modeling, Performance Monitoring, Tuning, RAC, Data Guard, Grid Control, Golden Gate, Space management and Supporting Application development.
Extensive knowledge on database administration for Oracle 12c, 11g, 10g, 9i with experience within a very large scale database environment and mission critical large OLTP systems in a variety of environments like Linux, HP - UX, IBM-AIX, Sun Solaris, RHEL and Windows.
Expert in planning, creation, administration and troubleshooting of Oracle 11g/10g/9i, OLTP (multiple instances)/OLAP databases.
Expertise in setup, installation, configuration, maintenance and troubleshooting of several Oracle tools and utilities like Oracle Grid Control, Cloud Control, Oracle Enterprise Manager (OEM), TOAD, Oracle SQL Developer in various versions.
Experience in Real Application Clusters (RAC) setup, configuration and cluster interconnection with Automatic Storage Management (ASM), configured user log on load balancing and failover on RAC database for high availability.
Strong experience in migrating database from Non-ASM to ASM and Non-RAC to RAC.
Have Hands on experience in Oracle 10g, 11g 3-Node RAC implementation & administration (Oracle Cluster ware setup and configuration, RAC installation using ASM, Configuration and Patching, RAC Backup and Recovery).
Experience in using GoldenGate to support data replication in the Oracle database environment.
Experience in installing and configuring GoldenGate v10.4, v11.1
Experience in upgrading GoldenGate from v9.5 to v10.4 and from v10.4 to v11.1
Proficiency in Installation and maintenance of replication tool Golden Gate by creating extract process, extract pump, and replicate.
Solid experience in disaster recovery, Database backup concepts and options such as user-managed backup, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental, cumulative backup and implementing backup and recovery strategies.
Skilled in developing RMAN scripts for database back up including hot and cold backup options for both RAC and standalone instances.
Extensive knowledge in Database Cloning using RMAN, VERITAS Net Backup, IBM Tivoli Storage Manager (TSM).
Have implemented replication and two types of standby databases logical standby and physical standby databases supported by DATAGUARD for DR high availability.
Excellent experience in various migration techniques like export/import, Data pump, backup, restore, cloning, and data guard.
Experience on Data Replication using Snapshot, Materialized views, import/export.
Writing scripts in the UNIX based environments for managing the users roles and privileges, scheduled backups (using data-pump /cold backups), manage statistics, Disk space management.
Experience on Oracle monitoring tools including Oracle Application Server monitoring and Oracle Linux monitoring using NMON and TOP commands.
Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, AWR, ADDM and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes.
Expertise in using EXPLAIN PLAN for query optimization and Performance diagnostic tools like SQL Trace and TKPROF.
Experience in writing PL/SQL Stored Procedures, Functions, Packages and Triggers, various UNIX Shell Scripting.
Experience using Erwin as a Data Modeling tool.
Excellent interpersonal and strong analytical, problem-solving skills combined with strong customer service attitude.
Proven abilities in establishing effective task priorities, working independently, and participating as an integral part of a team in fast-paced and multitasking environment.
Provided 24*7 on-call production database support and maintenance including remote database support.

TECHNICAL SKILLS

Operating Systems: AIX 7.1/6.1/5.3/5.2/5.1 , HP-UX 10.x,11.x, Sun Solaris 2.6,8,9,10, Red Hat Linux 4.x,5.x,6.x and windows 2008/2003/XP

Databases: Oracle 12c/11g/10g/9i, Oracle 11g/10g Real Application Cluster (RAC), ASM, IBM DB2 v10.1/v9.1/v9.5, Microsoft SQL Server 2005/2008.

Tools and Utilities: RMAN, OEM, TOAD, SQL*Loader, Export/Import, Data pump, Query builder, Net Backup, Tivoli Storage, SQL Tuning/Access Advisor, SQL Performance Analyzer, Data Guard, Cloning, Migrations

Languages: C, SQL, PL/SQL, UNIX Shell Scripting, COBOL

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship