We provide IT Staff Augmentation Services!

Senior Oracle Dba Resume

Phoenix, AZ

SUMMARY:

  • Around8 yearsof experience as anOracle Database Administrator.
  • Excellent experience in 24x7 production database administration, support, installation, configuration, upgrades,database migrations, patches, performance tuning, backup and recovery, cloning, space management, database security & auditing.
  • Experience inOLTP/DSSdatabase systems, managing large Oracle databases.
  • Proven experience withdatabase performance and tuning techniquesto enhance database optimization plans.
  • Experienced in Performance Tuning usingEXPLAIN PLAN, TKPROF,STATSPACK, AWR, ADDM
  • Experience withOracle 11g RAC/10gRAC/9i/8iin Installation, Administration, Monitoring, Database Backup and Recovery.
  • Knowledge ofSQL analysis toolsand database internal debuggers includingORADEBUG.
  • Proficient withDatabase Cloning, Migration, Standby Database (Data Guard)
  • Experience inOracle Cluster Wareenvironment.
  • Involved in different scenarios ofOLTPas well asDSS(Data warehouse) databases.
  • Have implementedORACLE STREAMSandGoldenGate
  • Extensive Experience withRMAN Backups, Cold Backups, Hot Backups and Logical Backups.
  • Experience inOracle Data warehouseDBA skills relating to administration and management of VLDB environments,Oracle OLTP.
  • Experienced in usingRMAN, Data pump Flash-Back Recovery and ASM.
  • Knowledge ofDatabase Recovery Techniquesand implementation of those recovery techniques to ensure business continuity.
  • Expertise in maintainingDatabase Securityusing auditing.
  • Experience on working withOracle E-business suiteenvironment.
  • Experience inData Migrations.
  • Experience in doingupgradesincludingmaintenance & monitoringimplementation.
  • Extensive knowledge inUNIX/LINUX/Windowsplatforms includesHP, SOLARIS, AIX, andLINUX.
  • Implemented various database solutions such as11g RAC,10g RAC, 9i, Data Guard, Oracle Grid, Oracle Streams, GoldenGate.
  • Experience inUNIX shell scripting, CRON jobs.
  • SQL- Query optimization expertise, including data integrity analysis for application customization testing, and creating analytical metrics.
  • Possesses strong analytical and problem solving skills coupled with very good communication and interpersonal skills.
  • Extensive experience inData Warehousing, ETL (Extraction, Transformation, Loading)
  • Excellent experience in Oracle Support processes for technical requests throughMetalink.
  • Dealing with databasesecurity and auditing.
  • Experience in SOX Controls, compliancereporting andaudit validation.

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,6.1 Red Hat Linux RHEL 3.x, 4.x,5.x and Windows 95/98/ME/NT/2000/XP.

RDBMS

Oracle 11g RAC, 10g RAC/9i/8i ,SQL Server 2000/2005/2008, MySQL

Languages

SQL, PL/SQL, Delphi, VC++, UNIX Shell Scripting, Perl

Tools/Utilities

RMAN, OEM, SQL*Loader, ASM, EXP, IMP, DataPump(expdp, impdp), TOAD, Golden Gate

Tuning Tools

TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM

Database Modeling

Erwin 4.0, Rational rose, Toad Data Modeller, ER/studio

Other

EMC, NetApp, Veritas NetBackup, TSM, HP Data Protector

WORK EXPERIENCE

Client: Confidential, NY
Duration: Apr 2009 to till date
Role: Senior Oracle DBA
Environment:Oracle 11g RAC/10g RAC/9i,Sun Solaris ,Red Hat Linux, HP-UX, OEM Grid Control, SQL, PL/SQL, TOAD, RMAN, TKPROF, STATSPACK, AWR, ADDM,SQL* Loader.

Responsibilities:

  • 24x7 production database administration and applications support
  • Installed Oracle 11g RAC, 10g RAC databases.
  • Skilled with STATSPACK, AWR, ADDM, SAR to check health of database & hardware.
  • Installed CRS in the environment during the implementation of RAC.
  • Configured ASM (Automatic Storage Management) which includes creating disks, diskgroups for the RAC environment.
  • 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.
  • Configured, implemented, 10 RAC/11g RAC
  • Worked on designing, installing & maintainingCRS, RAC and Dataguardcomponents of Oracle.
  • Writing SHELL SCRIPTS for the system and database for effective functionality, report generation, backup and cloning.
  • Upgradation and Migration of Databases and applying patches whenever required.
  • Maintaining schemas and partitioning tables.
  • Oracle Data warehouse database administration and management of VLDB environments, Oracle OLTP.
  • 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
  • Developing SHELL SCRIPTS to automate the processes.
  • Played major role in the migration from Microsoft SQL Server to Oracle 10g.
  • Experienced with SRVCTL.
  • Implemented and developed compliance reports and audit reports.
  • Performed RMAN backup and recoveries.
  • Creating tablespaces, tables, and users for custom applications.
  • Working experience with DATAWARE HOUSING tools like ETL, INFORMATICA.
  • Knowledge of working on Oracle E-business Suite environment.
  • Creating and dropping of users, granting and revoking permissions to users/roles as and when required.
  • Experienced with SPACE MANAGEMENT and SECURITY.
  • RMAN point in time recovery and Instance recovery done on 11g/10g databases.
  • Working with QA team in unit testing.
  • Implemented Oracle Streams for the replication of data.
  • Used all types of Normalization techniques for the normalization of data.
  • Thorough knowledge in setting up infrastructure for databases in huge data centers.
  • Developed numerous PL/SQL Procedures, Packages, Functions and Triggers for various requirements.
  • Implemented oracle high availability solution using oracle PHYSICAL STANDBY.
  • Importing data from flat files into database using SQL loader and External Tables.

Client: Confidential, TX
Duration:Jan 2008 – Apr 2009
Role: Senior DBA
Environment: Oracle 11g RAC/10g RAC/9i/8i, AIX, Sun Solaris, Windows NT / 2000, Red Hat Linux, TOAD, ERWIN, RMAN, SQL server, OEM.

Responsibilities:

  • 24x7 production database administration and applications support
  • Supporting multiple databases for production, development, test and staging purposes
  • Applying upgrade patch, maintenance and interim (opatch etc) patches on all the databases.
  • Refreshing Dev and test instances with data from Production on a regular basis.
  • Installation of Oracle 11g/10g RAC and Standby Database for High Availability and Disaster Recovery purpose.
  • Developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts.
  • Provided performance tuning of Oracle Databases.
  • RMAN point in time recovery and Instance recovery done.
  • Developed compliance reports and performed auditing at higher levels.
  • Worked on the migration of SQL Server databases to Oracle databases.
  • Scheduling repetitive activities like gathering schema statistics, exports, table space usage report usingcrontab.
  • Upgrade and Migration of Database from 9i to 10g, 9i, 10g to 11g. and applying patches whenever required.
  • Monitoring and optimizing the performance of the database/application
  • Capacity planning: Allocate system storage and plan future storage requirements.
  • Creating OEM alerts that provides notifications.
  • Performing housekeeping tasks like checking log and trace files.
  • Responsible for setting and managing USER MANAGEMENT, SPACE MANAGEMENT Granting required privileges to users.
  • Worked on Data modeling
  • Performing monthly and annual performance reports for trend analysis and capacity planning.
  • Assist in SQL tuning and providing consultation such as creating Materialized views, adding indexes, dropping unnecessary indexes.
  • Developed Physical and Logical Models of databases and ERD diagrams using ERWIN.
  • Experienced in working with the ORACLE STREAMS for the replication of data.
  • Troubleshooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, Instance, memory, operating system and java calls.
  • Implemented Normalization techniques for the normalization of data.
  • Maintaining the data warehouse databases.
  • Experience in writing UNIX SHELL scripts.

Client:Confidential, Phoenix, AZ
Role:Senior Database Administrator
Duration:Aug 2006 – Dec 2007
Environment:Oracle 10g RAC/9i/8i,Sun Solaris, Red Hat Linux, HP-UX, Oracle Enterprise Manager, SQL, PL/SQL, TOAD, RMAN, TKPROF, STATSPACK, SQL* Loader, Windows NT/2000.
Responsibilities:

  • Involved in administration of over 150 Oracle instances.
  • Performing all the Database Administration activity like space management in database, user and roles administration, schema management, checking alert log of all the databases
  • Involved in the process of tuning and refining queries of various applications.
  • Installed Oracle 9i Data guard.
  • Wrote several shell scripts for checking Oracle errors in alert file and database backup log files.
  • Cloning of application from production environment to test environment and application of patches.
  • Developed startup/shutdown guides, trouble shooting documents, root cause analysis documents.
  • Performing Backup/Recovery of all the Oracle databases using RMAN, also setup RMAN catalog for the same.
  • Creating tables and indexes, sizing their extent, partitioning and so on.
  • Creating users with restricted access, with default and temporary table spaces.
  • Creating roles and granting to users based on their group requirements.
  • Creating profiles and attaching them with users.
  • Performing hot and cold backups.
  • Restoration and recovery from backup.
  • Conducting sizing and capacity planning for oracle databases.
  • Developed database system build sheets, code review check lists, code promotion process documents, outage reporting documents.
  • Sizing the SGA, db buffers, shared SQL area, log buffer based on the requirements.
  • SQL issues and Tuning Considerations for Different Applications.
  • Monitoring the table growth, database growth, current users, and system resource usage and so on.
  • Experience in SQL*Loader, loading data from text files.
  • Knowledge in writing shell scripts for automating backups, restoration and cloning.
  • Responsible for setting and managing USER MANAGEMENT, SPACE MANAGEMENT Granting required privileges to users.

Client: Confidential, Poughkeepsie , NY
ROLE: Database Administrator
DURATION: May 2005- July 2006
ENVIRONMENT:Oracle 10g /9i/8i, Red Hat Linux, HP-UX, AIX, Oracle Enterprise Manager, SQL, PL/SQL, TOAD, RMAN, TKPROF, STATSPACK, SQL* Loader, Windows NT/2000.

Responsibilities:

  • Provided 24X7 supports for production problems.
  • Installed Oracle 10g, applied patches in various environments and upgraded databases from 9i to 10g.
  • Performed day-to-day DBA tasks.
  • Logical & Physical database design and implementation
  • Experience in OLTP/DSS database systems, managing large Oracle databases.
  • Set up, configured and maintained Oracle data guard(physical/logical standby databases) to ensure disaster recovery,high availability and data protection.
  • Performed maintenance tasks on existing test and production environments that included modifying database sizes and migrating changes through various environments
  • Performed Database and SQL tuning by using various Tools like STATSPACK, TKPROF, explain plan optimizer hints and SQL tuning advisor.
  • Created and implemented Oracle database backup and recovery strategies
  • Recovered successfully two production databases from RMAN backups due to an unexpected media failure resulting in data corruption errors and lost of control files
  • Monitored the various database activities such as backup, error logs, space, object, performance, user and session monitoring to ensure proper capacity and availability
  • Analyzed tables and re-build indexes regularly.
  • Created procedures, functions, packages, and triggers using PL/SQL.
  • Developed ERD diagrams along with physical and Logical models with ERWIN tool.
  • Hands on experience with the normalization of data through normalization techniques.
  • Experienced in ETL (Extraction, transform, Load).
  • Utilized SQL*loader and data pump import to load data into tables.
  • Audited database for statements, privileges, and schema objects.
  • Developed/customized UNIX shell scripts to automate routine DBA tasks.

Client:Confidential.
Role:Database Administrator
Duration:Jan 2004 - Mar 2005
Environment:Oracle 10g/9i/8i/7.3, RMAN, Sun Solaris, AIX, Windows, RedHat Linux
Responsibilities:

  • Managed in-house Oracle Databases running on Windows to Linux.
  • Installation of Oracle Database and Oracle products.
  • Implementing Backup/Recovery Strategies.
  • 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.
  • 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.

Hire Now