SUMMARY:

• An oracle professional, leader and Oracle DBA with 14 years of IT experience, 10 years of expertise with Oracle RDBMS includes, 8 years of Oracle (8.X/8i/9i/10g/11g) administrator, developing and managing functions in fast - paced business environments.
• Extensively worked on the installation and configuration of production, development and test databases on multiple platforms. Involved in the design, development, and delivery of cost-effective, high-performance technology solutions to meet challenging business demands.
• Worked with application development of financial and event management systems using Oracle Forms and Oracle Designer
• Decent knowledge of network, operating system and SAN administration to make database available to customers 24/7
• Translated logical database model into optimal physical database design for implementation required for business solutions.
• Upgraded Oracle Database using Migration Assistant and Export/Import utilities in a highly compressed time frame for smooth and successful migration up to 11g.
• In-depth knowledge of Data modeling using Oracle designer
• Worked with Systems Analysts to design database objects (tables, stored procedures, index and triggers) to maintain the application’s business rules.
• Apply database/security patches.
• Tuned databases to ensure transactions are executed at peak performance.
• Perform backup and recovery using both traditional backup and recovery and RMAN.
• Member of the Disaster Recovery team to perform off site bi-yearly drills for database recovery in both physical and virtual environments.
• Implementation and use of the Oracle Enterprise Manager as well as the Performance Tuning and Diagnostics Packs. Implemented various secondary-monitoring scripts.
• Worked with Oracle support on various SRs for production issues.
• Oracle Database tuning for long running concurrent jobs using Stats pack, TKPROF, etc.
• Excellent analytical, communication and organizational skills.
• Upgraded and migrated 9i databases to 10g and from 10g to 11g databases on multiple platforms.
• Installed and configured 10g and 11g Application server for Forms, Reports and Designer
• Install, configure and maintain MYSQL database for various application.
• Experience with VMWARE 5.1 virtual environments managing the hosts and the Guest servers.
• Experience with Backing up virtual servers with VCB and other third party tools i.e Symantec, Veeam.

SOFTWARE/HARDWARE:

Oracle Database, SQL-PL/SQL, Designer/2000, Developer Tools, Oracle Forms Fusion Middleware 11g, MYSQL Database, SQL Server Database, Toad, Oracle Enterprise Manager Grid, SUN Solaris, RHAT Linux, VMS, Windows Servers, VMware, and Oracle VM

EXPERIENCE:

Confidential, MD

Systems Engineer

As an Oracle DBA:

• Installed and upgrade Oracle Database on multiple operating systems for production, development, and test database servers.
• Supported Oracle Developers with analysis, logical and physical design, PL/SQL, SQL tuning, and developing Oracle forms and reports.
• Actively participated in application development life cycle with developers, and provided necessary inputs during logical and physical design.
• Design a solid security data model using table functions and PLSQL tables to enforce compliance for HIPAA Data.
• Developed SQL and PL/SQL scripts, triggers, procedures, packages, and data security structures for various projects assuring compliance to database and programming standards through the entire development life cycle.
• Migrated 10g to 11g using Import export utility.
• Responsible for providing performance monitoring, tuning, backups, upgrades/patches, and system maintenance.
• Perform backup and recovery using RMAN.
• Monitoring all systems using Oracle Enterprise Manager and command line access
• Wrote scripts for performance monitoring and tuned existing codes accordingly to ensure smooth operations on production systems.
• Performed physical and virtual database backups and recoveries. Lead the Database team on Disaster Recovery drills at SunGard facility for past 10 years. Successfully recover all production databases during several drills in past ten years.

Additional duties:

• Installation and configuration of Windows servers.
• Define and configure backup strategies for Oracle Servers, including database servers and application servers
• Maintain and support Oracle application servers and other web servers.
• Installation and configuration of VMWare virtual server environment running on HP Blades
• Configuration of SAN array.
• Primary responsible person for disaster recovery solutions for Oracle database

Confidential

Suitland MD

Database Administrator

Responsibilities as an Oracle DBA

• Installation and configuration of new Oracle 10gR2 databases.
• Creation of multiple database instances on Solaris, Linux VMS and Windows platforms
• Day to day Maintenance of over 50 databases on various platforms that includes,
• Creating and troubleshooting RMAN backup policies
• Maintaining tablespaces and datafiles
• Resolving user issues for database links, application privileges, query performance, locking issues, schema setup etc.
• Setting up, maintaining and troubleshooting Oracle Queues for messages transfers between two or more databases
• Migrating data from one database to another
• Create development, beta environment by cloning databases.
• Installation of Quarterly security patches on the database servers
• Upgrade 9i databases to 10g databases
• Implementation of security policies on the databases
• Documenting Standard Operation Procedures (SOPs) for all standard procedures of a DBA.
• Written Unix shell scripts for backup and to automate other OS jobs

As an iAS Administrator:

• Installation and configuration of Oracle 10g/11g Application server components on Solaris and Windows
• Applying security and upgrade patches on the application server and/or infrastructure database.
• Implementation and deployment of Forms, Reports, Portal Meta Repository and Mod PLSQL application on these application servers.
• Create Database Access Descriptors for PLSQL applications.

Confidential, MD

Senior Oracle Database Administrator

As an Oracle DBA:

• Installed and upgrade Oracle on VMS, Linux, Windows operating systems for production, development, and test database servers.
• Supported Oracle Developers with analysis, logical and physical design, PL/SQL, SQL tuning, and developing Oracle forms and reports.
• Developed/wrote SQL and PL/SQL scripts, triggers, procedures, packages, and data security structures for various projects assuring compliance to database and programming standards through the entire development life cycle.
• Written scripts for performance monitoring and tuned existing codes accordingly to ensure smooth operations on production systems.
• Migrated 8i databases to 9i, 10g using command procedures and Upgrade Assistant.
• Responsible for providing performance monitoring, tuning, backups, upgrades/patches, and system maintenance.
• Perform backup and recovery using both traditional backup and recovery and RMAN.
• Monitoring all systems using Oracle Enterprise Manager and command line access
• Researched, evaluated and recommended the use of new features in Oracle and their applicability to current application databases to end-users, developers and project managers.
• Performed physical database backups and recoveries. Lead the Database team on Disaster Recovery drills at SunGard facility. Successfully recover all production databases during several drills in past three years.

Confidential

El Segundo, California

Decision Support Analyst

• Perform analysis and design for the HEDIS (Healthcare Effectiveness data and Information Set).
• Coordinated with 7 different healthcare organizations to develop the HEDIS compliance system.
• Detailed Documentation for each measure of HEDIS
• Build Reports application using PowerBuilder 5.0