SUMMARY

• Professional with over 15 years’ experience in IT as an Oracle Database Administrator (9i, 10g &11g) and SQL Server DBA. An in - depth knowledge with Real Application Cluster (RAC), Automatic Storage Management (ASM), Oracle Grid and Oracle Enterprise Manager.
• An extensive background providing technical assistance to developers and end-users to resolve functional errors, prevent down-time, create scripts, research and apply patches to fix bugs, as well as resolving database performance and capacity issues.

TECHNICAL SKILLS:

RDBMS: Oracle Version 8i, 9i,10g & 11g, 12c,SQL Server 2005/2008

APPLICATIONS: Oracle Financials. 11i ( 11.5.10), Web Logic, TIMMS, Quality Center & MAXIMO

UNIX OS: Sun Solaris OS 2.5/2.6/8, Red Hat Linux 0S 5.2/6.2/7.0 & ES4, HP-UX 11x

UNIX Hardware: Sun E450, Sun E250, Compaq Proliant DL380, Sun Stations, IBM/Compaq.

LANGUAGE: PL/SQL, SQL, C++, C, Perl scripting. Vi.

TOOLS: Oracle Enterprise Manager (OEM) 10g & 11g Grid Control, RMAN, TOAD 10.6, Erwin, GoldenGate 11g, Enterprise WebLogic, OBIEE 11g, Oracle SQL Developer (3.0.04), (HP) Quality Center.

PROFESSIONAL EXPERIENCE:

Oracle DBA

Responsibilities:

• Providing technical assistance up to 13 development and production databases (sz: 100 GB - 1 TB) for Capital One fraud detection and Customer Relations department.
• Application tunning ensuring third party compliance, database health checks to monitor table and table space anomalies. Resolve database performance and capacity issues.
• Table and associated index reorganization in databases to avoid row chaining and table space management issues.
• Member of Capital One Enterprise Information Management team enforcing proprietary security procedures for specific user applications.
• Performed Performance Tuning - proactively monitoring memory, queries, space-usage, I/Os, latches for bottlenecks and taking quick corrective measures.
• Physical and logical designing of the database, defining and tuning DML and DDL related statements with project team developers

Environment: Oracle 8.1.7, 9.2.1 Partition and Parallel Server on UNIX HP-UX 11.x

Lead Database Consultant

Responsibilities:

• Senior consultant providing managerial and lead responsibilities on customer proprietary projects including database administration and upgrades as well as user interface support.
• Managed and coordinated the upgrades of 50 AMTRAK Oracle databases from lower versions to a release 11.2.
• Tablespace and associated index reorganization in database to avoid tablespace management issues. Created custom monitoring and forecast reports from 11g Grid Control.

Lead DBA/Task Manager

Responsibilities:

• Manager/Lead DBA to a team of 14 DBAs and managing over 60 DECC development and test databases. Serve as a central point of contact in providing daily database related managerial and technical support to CMS’s Development Effort Consolidated Contract (DECC).
• Managed database projects, develops and directed technical project teams through all phases and activities of the project management life-cycle process that are essential to DECC goals that affect operations on a long-term and continuing basis.
• Determined database project goals and priorities with management, program director and release managers. Managed and communicated a clear vision of the project's objectives, and motivates the cross functional project team to create a project environment that enables peak performance by the entire team.
• Managed resource assignments and tracking to the project plan and project schedule in coordination with the line of business resource managers.
• Coached to clarify assignments and deliverables; mentors others in project management practices; reviews quality of work and manages the integration of team members’ work.
• Manages resource assignments and tracking to the project plan and project schedule in coordination with the line of business resource managers.

System DBA 

Responsibilities:

• Created, configured and resolved Linked Servers issues on both Oracle and SQL databases.
• Installed cloned, partition and hardened Sun SPARC server for disaster recovery purposes.
• Maintained, monitored the health check of three Oracle databases on Sun SPARC and seven
• SQL server databases on Dell Power Edge Server 2650.
• Proactively assisted users with Oracle Financial implementation (PO, AP, GL and FA modules) and resolving functional errors.
• Application tuning; Monitored application key table spaces and error logs to prevent down-time, run bug scripts, researched and applied Oracle patches to fix bugs.
• Support in the conversion of proprietor application from MEI to TIMMS.
• Created scripts to run back-up and verify Oracle instance daily. Assisted developers and web administrators in the design, modification of stored procedures and packages.

Environment: Oracle 11.5.4, 11.5.10, Oracle 8.1.7 on Solaris OS 5.6, Oracle 9i &10g on Red Hat Linux Enterprise 4, SQL Server 2000/2005.

Technical Consultant 

Responsibilities:

• Support the development of Postal Public Key Infrastructure (PPKI) through Cylink application.
• Installing and supporting Oracle versions on Unix Sun Solaris platforms to enable users to an e-commerce transaction.
• Assisting developers enhance codes to comply with restrictions and constraints.
• Worked with team of technical developers supporting SQL Server 7.0 (120 GB) databases on WIN 2000 operating platform. Benchmarking studies in support of the IT senior Leadership team.
• Execute UNIX Perl Scripting to monitor scheduled jobs and send email alerts to DBA’s.
• Implement effective cold / hot backup and recovery procedures to provide data availability.
• Involved in Business Continuity Plan (BCP), Disaster Recovery Planning (DRP), logistics and implementation of recovery procedures to restore critical business functions.
• Setting up staging two 120 GB Oracle databases for application testing.

Environment: Oracle 7.3.4, 8.0.4, 8.0.5, 8.1.7. UNIX Sun Solaris 2.6, 5.8