SUMMARY

• IT Consultant with 4 + plus years’ experience of progressive experience as an Oracle DBA. With experience in Database administration, installation, Planning, configuration, management and troubleshooting of Oracle 10g, 11g and 11gR2 databases.
• With expertise working on Linux, Solaris and Windows OS. 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 Manager and or Director level personnel on all new and existing company programs and initiatives.
• Highly adaptable to change and 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 10g,11g and 12c databases on Linux and Windows OS
• 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.
• 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.
• Tuned various slow running query
• Performed instance tuning, memory tuning query tuning and complete database tuning.
• 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.
• Helped Upgrade Oracle 10g database to 11g.
• Upgraded Oracle 11g databases from 11.2.0.1 to 11.2.0.3 using patch set
• Configure and setup Oracle 11gR2 Data Guard.
• Managed Data Guard using Data Guard broker.
• Troubleshoot and resolved log gap in Data Guard Configuration

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: Export/Import, RMAN, Data Pump, Toad, 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 60 + 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), scheduling jobs.
• Designing and developing SQL procedures, query performance tuning.
• Performed hot and cold backup and recovery using RMAN and UNIX Scripts
• Monitored database and SQL performance using Stats pack, 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).
• Handled daily production problems/change requests with Oracle.
• Performed daily database administration tasks: User management, Space monitoring, Performance monitoring and tuning, Alert Log monitoring and backup monitoring.
• 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
• Perform RMAN configuration, database backup which included (hot and cold) and recovery, troubleshoot and resolve related issues.

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.
• Develop and enforce database related policies, standards, naming conventions, operating procedures and best practices. Develop a strategic plan for the database development that supports the organizations operational requirements.