PROFILE:

Highly motivated, success driven engineer with 17 years of professional work experience in analysis, design, development, testing and maintenance of software applications. Over six years of work experience in Oracle database administration. Highly proficient in application development and RDBMS design, maintenance, tuning and migration of various databases. An excellent team player with outstanding communication skills.

SOFTWARE SKILLS:

DBMS:  Oracle 9i/10g/11g, Microsoft SQL Server, Microsoft Access, PL/SQL, TOAD

Development Environments:  Visual Basic, C/C++, PowerBuilder, PL/SQL, XML, HTML, Java, ColdFusion

Operating Systems:  Windows 2000/XP/NT/Vista/7, Windows Server 2008 R2 Enterprise, HP UNIX, Linux

Software Configuration Management:  Rational Rose, ClearCase, ClearQuest, TestManager

Office Productivity:  MS-Word, MS-Excel, MS-PowerPoint, MS-Outlook, MS-Publisher, MS-Photoshop

PROFESSIONAL EXPERIENCE:

Sr. Oracle Database Administrator

Confidential, Bethesda, MD

Responsibilities:

• Installing and configuring Oracle 11gR2 on VM servers.
• Daily monitoring of the system for availability by checking listener, database, alert logs and trace file.
• Providing disaster recovery by configuring and maintaining physical standby database using Oracle Data Guard.
• Migrating from 10g to 11g in production environments.
• Creating database objects such as tables, indexes and views.
• Managing database storage structures and space allocations for multiple applications.
• Performing database startups and shutdowns as required. Monitoring database backup and recovery operations using RMAN.
• Performing exports, import schemas, logical and physical backups of databases.
• Managing user access and security for multiple databases including establishing user accounts, issuing new user passwords, granting roles, privileges and resolving user access problems.
• Installing latest version of Oracle Application Express 4.1.1 and administrating the applications.
• Installing and providing support for the latest version of Oracle Business Objects (OBIEE) and Weblogic enabling clients to complete their tasks.
• Upgraded Weblogic 10.3.5 to 10.3.6 and upgraded Oracle Business Intelligence 11.1.1.5 to 11.1.1.7.0
• Deploying applications, managing administrative accounts, monitoring the environment in BI.
• Applying quarterly patches for Oracle databases, Weblogic and OBIEE.

COTS Administrator

Confidential, Arlington, VA

• Provided analytical and technical support for the identification, evaluation, installation, implementation and maintenance of commercial-Off-The-Shelf (COTS) software for the clients.
• Conducted market research to identify COTS software products with the potential to fulfill the established software requirements.
• Developed software product and installed on to Oracle10g and Oracle11g servers.
• Worked with clients to coordinate the deployment plan of products.
• Developed and executed software test plans, test scripts and test data to test the COTS software products.
• Provided user training and developed training materials for clients

Oracle Database Administrator

Confidential, Arlington, VA

• Installed, configured, upgraded and applied patches for Oracle 10g and Oracle 11G server software, features and related products
• Installed Oracle 11g release 1 (11.1 32-bit) RAC on Linux (Oracle Enterprise Linux 5 32-bit) using VMware.
• Monitored the availability of the system daily including checking listener, database, alert log and trace file.
• Provided disaster recovery by configuring and maintaining physical standby database using Oracle Data Guard.
• Worked on database cloning to make production instance available for test and development.
• Managed database objects such as tables, indexes and views.
• Managed database storage structures and space allocations for multiple applications.
• Performed database startups and shutdowns as required. Monitored database backup and recovery operations when required.
• Performed exports, import schemas, logical and physical backups of databases.
• Managed user access and security for multiple databases including establishing user accounts, issuing new user passwords, granting roles, privileges and resolving user access problems.
• Managed and monitored access to Oracle Application Express for over 4,000 users and created reports for client management.
• Maintained the Tnsnames.ora file for production, test and development environments for all servers.

Senior Software Engineer

Confidential, Arlington, VA

• Managed over 21 application systems, one of which was used in over 200 different office locations nationwide.
• Utilized Visual Basic, MS Access, Oracle and SQL server.
• Implemented design, modeled data, developed and enhanced application software, tested, trained and provided technical support for users.
• Analyzed requirement specifications and database objects in Oracle 10G to support application design layouts.
• Created Oracle scripts and created functions and procedures using PL/SQL for applications.
• Connected front end of the application to an Oracle backend database using ODBC.
• Designed application databases from conceptual to logical model to physical database for new applications.
• Directed and coordinated assignments as the project lead for a team of 3 programmers.

Senior Software Engineer

Confidential, Arlington, VA

• Developed the DEA’s Law Judges/Case Management System (LJ/CMS) using Microsoft Access and Visual Basic.
• Designed, developed, and implemented enhancements to the existing system. Extensively interacted with end-users for requirements gathering, daily usability criteria and modified the system accordingly.
• Conducted Joint Requirements Planning (JRP) sessions for enhancements, fixed user identified problems promptly and documented business and technical details required by DEA standards and guidelines using the Rational toolset.
• Designed and modified system components such as tables, forms, queries, reports, and application code.
• Developed unit-testing designs and test scripts for the QA testing team using Rational TestManager.
• Conducted demonstrations and trained end users on all modifications prior to implementation;
• Provided technical support for the system.

Software Engineer

Confidential, Vienna, VA

• Provided analysis and design for the migration project.
• Created and tested triggers, tables, procedures and packages for data transformation using Oracle 9i.
• Created data elements using MS Access for analysis.
• Created ICD documents for clients on a periodic basis.
• Created an in-house CLOB tool to parse and load the legacy data into an Oracle database using PL/SQL, TOAD, and XML.
• Performed integration testing using TestManager.
• Monitored data usage on periodic basis and produced reports to the team.
• Participated in code review.