We provide IT Staff Augmentation Services!

Oracle Dba Resume

Washington, DC

SUMMARY:

  • IT Consultant with 7+ plus years experience of progressive experience as an Oracle DBA. With experience in Database administration, installation, planning, configuration, management and troubleshooting of Oracle 11g, 11gR2, 12c databases working on a Linux platform. Experience in many systems development life­cycles such as Agile, SDLC, requirement development, architecture design, testing, and post implementation revisions.
  • Able to work on a variety of database related projects to streamline processes and improve overall database performance. Can work with cross functional teams such as Business teams, IT Operations, Managers or Director level personnel on all new and existing company programs initiatives.
  • Highly adaptable to change, able to learn and implement new ideas per business request. Ability to work well in teams with good oral, written, and interpersonal skills. Adapt at routine database administration tasks including automated installation, creation and replication of databases, management of tablespaces, logs, grants, roles, users, etc.
  • Planning, installation, configuration, management and troubleshooting of Oracle 11g and 12c databases on Linux.
  • Expertise in the creation of databases, table spaces, tables, indexes and other database objects.
  • Install and configure relevant network components to ensure database access as well as database consistency and integrity
  • Provide database administration on production, testing and development database servers.
  • Managing Schema Objects.
  • Regular Monitoring Alert Log Files and trace files on Day to Day Basis.
  • Identifying and removing Fragmentation, row migration/chaining of database objects.
  • Analyzing the Tables and Indexes on performance base regularly
  • Managing Undo Tablespaces, Redo Logs, Control files and Archive logs.
  • Implemented multiplexing control files and redo log files
  • Identify and recover the corrupted db blocks using Block recover option in RMAN utility
  • Performing Complete Media Recovery of Database depends on the nature of failure.
  • Configure and implement the use of Oracle Recovery Manager (RMAN) for cold and hot backup to the databases
  • Mildly using DATAPUMP and Export /Import utilities for logical backups.
  • Monitoring the user sessions and take appropriate action to kill the inactive sessions
  • Creating and rebuilding indexes as necessary.
  • Performed various performance goal oriented database tuning.
  • Use explain plan, AWR, ADDM and various Oracle Advisors to tune the database.
  • Created and tuned various materialized views.
  • Tuned various slow running query
  • Creates and implemented various table partitions for large tables
  • Resolved various complex issues with the database.
  • Apply quarterly CPU patches to different version of databases.
  • Upgraded Oracle 11g databases from 11.2.0.1 to 11.2.0.3 using patch set
  • Configure and setup Oracle 11gR2 Data Guard.
  • Helped Upgrade Oracle 10g database to 11g.
  • Managed Data Guard using Data Guard broker.
  • Troubleshoot and resolved log gap in Data Guard Configuration
  • Installed, configured and managed 11gR2 (RAC) on ASM storage
  • Manage RAC databases using CRSCTL, SRVCTL and grid control

TECHNICAL SKILLS:

Operating System: Windows 2003, Solaris, Red Hat Linux 5.0, 5.4

RDBMS: 10gR1 & R2, 11gR1 & R2

Tuning Tool: TKPROF, EXPLAIN PLAN, AWR, ASH, STATS PACK and ADDM

Backup Tool: Cold, Hot backup, RMAN, Import/Export

Script: Having knowledge of UNIX\Linux shell script

Language: Having Knowledge of SQL, PL/SQL

Web Technology: Having Knowledge of HTML, XML

Virtual Machine: VM Ware server 2.0 to 2.2, Oracle VM Virtual box 4.0

Environment: Oracle 10g/11g R2 server, SQL server

Oracle Database Tools: SQL*Loader, TKPROF, Toad, OEM, SQL Developer, Grid Control Tools & Utilities exp/imp, Data Pump Toad, NETCA,NETMGR, LSNRCTL, DBCA, DBUA, ADDM, Remedy.

PROFESSIONAL EXPERIENCE:

Oracle DBA

Confidential, Washington, DC

Responsibilities:

  • 24x7 Production database administration, support and monitoring to ensure proactive problem recognition and resolution of database issues.
  • Worked on a team of Five DBA and Software developer who manages 40 + database with sizes ranging from 30G to 2TB.
  • Day - to-day DBA activities including schema management, user management (creating users, synonyms, privileges, roles, quotas, tables, indexes, sequence), space management (table space, rollback segment), monitoring (alert log, memory, disk I/O, CPU, database connectivity).
  • Designing and developing SQL procedures, query performance tuning.
  • Performed hot backup and recovery using RMAN.
  • Monitored database and SQL performance AWR, OEM, EXPLAIN PLAN and tuned problem areas to enhance performance.
  • Monitored database and system performance.
  • Configured the Event Manager to notify support personnel.
  • Worked on application and database security (data access, passwords, network, etc.)
  • Performed Physical backup (hot and cold) as well as Logical backup (Export/Import).
  • Proactively managed the databases set up alarms for managing any exceptions in day to day management of the databases and discovering issues that could potentially cause disasters
  • Monitored the server's memory, disk, CPU I/O and network to establish baseline and peak performance for applications using UNIX command line utilities.
  • Analyzed SQL queries causing performance problems.
  • Administer database user accounts. Create, modify and deactivate user accounts assign
  • Work cooperatively with developing team to make structural changes to the databases.
  • Implement table partitioning/indexes etc. to improve performance and data management and monitor user access rights
  • PL/SQL Tuning and bottlenecking: Tuning and fixing some performance problems using AWR/ADDM and Optimizer.
  • Manage RAC databases using CRSCTL, SRVCTL and grid control

Jr. Oracle DBA

Confidential, Washington DC

Responsibilities:

  • 24x7 Production database administration, support and monitoring to ensure proactive problem recognition and resolution of database issues.
  • Worked on a team of three DBA and we manage 7 + database with sizes ranging from 10G to 780GB.
  • Developed best practices based on associated security policies, industry security standards, and audit regulations to ensure devices are appropriately secured from security breaches Resolve compliance break fix incidents based on vulnerability testing, audits, and/or associated security monitoring systems
  • Performed fine grain database auditing.
  • Maintained stored procedures, functions, triggers, packages and views used by the database instance
  • Documented database structure, changes, problems, issues for future reference
  • Developed and enforced database related policies, standards, naming conventions, operating procedures and best practices.
  • Developed a strategic plan for the database development that supports the organizations operational requirements.
  • Administered database user accounts. Created, modified and deactivated user accounts assigned and monitored user access rights
  • Upgraded and patched database, as required
  • De­fragmented, reorganized database/tablespace, as required
  • Monitored database security by controlling and monitoring user access
  • Developed and Maintained Stored Procedures, Functions, Triggers, Packages and views used by the database instance.
  • Documented Database structure, changes, problems, issues for future reference.

Jr. Oracle DBA/ Quality Assurance

Confidential, Washington DC

Responsibilities:

  • Performing physical backups using RMAN utility.
  • Identify and recover the corrupted db blocks using Block recover option in RMAN utility
  • Performing Complete Media Recovery of Database depends on the nature of failure.
  • Configure and implement the use of Oracle Recovery Manager (RMAN) for cold and hot backup to the databases
  • Extensively using DATAPUMP and Export /Import utilities for logical backups.
  • Performing database cloning using RMAN.
  • Monitoring the user sessions and take appropriate action to kill the inactive sessions
  • Creating and rebuilding indexes as necessary.
  • Performed various performance goal oriented database tuning.
  • Use explain plan, AWR, ADDM and various Oracle Advisors to tune the database.
  • Created and tuned various materialized views.

Hire Now