SUMMARY:

• I am a result - oriented IT professional with the ability to work within a dynamic environment.
• Dedicated team player known for being resourceful, passionate, creative in problem solving.
• Able to effectively manage client expectations, explain complex concepts and ideas to technical and non-technical individuals.
• I am looking for a challenging position in Oracle Database Administration where I can utilize my skills in database management, security, configuration, implementation, and support.
• Over 8 years aggregate IT experience with strong troubleshooting skills
• Six plus years of experience of installing, upgrading, and patching Oracle software
• Over six plus years of using OEM, RMAN, ASM, Shell scripting, Data Pump, Partitioning, Oracle DB Console, DataGuard, and Real Application Clusters (RAC)
• Five plus years of working within a VMware, Unix and Linux, and Windows operating systems
• Experience with Oracle 9i, 10g, 11g, 12c, PL/SQL, MySQL, SQLDeveloper, JDeveloper, NetCa, ADDM, and NetConfig
• Experience working in a production, testing, and application-developing environment
• Experience working in an Agile environment
• Four years plus of experience in creating logical and physical database design
• Excellent report writing, proposal defense, and presentation skills
• Three years of working in a J2EE application environment

AREAS OF EXPERTISE:

Databases : Oracle 9i, 10g,11g and 12c RDBMS, MS access, MySql, PostgreSQL

Oracle Tools: Data Pump, Export/ Import, Oracle SQL*Loader, Oracle Universal Installer, Database Configuration Assistant (DBCA), Database Upgrade Assistant (DBUA), SQL*Plus, Oracle Grid Control (OEM), Oracle Net Manager, Recovery Manager (RMAN), Network Configuration Assistant ( Netca), Putty, TOAD, SQL developer, J2EE, and Command-line tools

Operating Systems: Windows Client (2000, XP, Vista, 7, 8), Windows Server (2003, 2008, 2012), Unix( HP-UX, Solaris), Linux (Red Hat, Centos)

Programming: Assembly, Pascal, C, C++, Java, visual basic, html, XML, Python, JavaScript, SQL, PHP

Software: VMware Workstation 6.5, Eclipse, Visual Studio, Visual Basic, CVS, AVR Studio, WinSCP, MS Project, MS Office suite, MySql, Apache, Tomcat, JBoss, Dreamweaver, Photoshop, UML, Filezilla, disk partitions, Matlab

Languages: Fluent in English and French

PROFESSIONAL EXPERIENCE:

ORACLE DATABASE ADMINISTRATOR

Confidential, Lanham, Maryland

Responsibilities:

• Install, upgrade, and patch Oracle Database software 11g on Linux environment
• Create and configure Oracle databases and manage database objects such as tables, indexes, and views.
• Optimize database access and allocates/re-allocates database resources for optimal configuration of performance
• Migrate database from Windows server 2003 to Oracle Linux version
• Upgrade Oracle database using DBUA or Data Pump Export/Import
• Develop and test a backup and recovery strategy that adheres to department policy, backup Oracle databases regularly in development and testing environment, and recover them in case of failures
• Ensure daily RMAN backups are completed and valid for restore and recovery
• Configure Flashback database setting the necessary parameters and Flash Recovery Area, then using RMAN to issue Flash Recovery Commands
• Manage databases and instances using DataGuard, RAC in a real time production, testing, and Development environment
• Monitor and tune database performance
• Utilize Automatic Workload Repository (AWR) to generate snapshots of key performance data, such as time-model statistics, which shows you how long each database activity is taking and high-load-SQL statistics that aids in identifying resource-intensive SQL statements
• Perform database migration from Oracle version 9i to 10g & 11g respectively
• Work closely to support software and application developers in various system design tasks
• Restructure the Oracle RAC configuration by adding and removing nodes along with resolving issues
• Generated Reports and preparing memo to communicate progress and providing early alerts for major updates
• Maintain up-to-date documentation to comply with C&A requirements.
• Provide a 24/7 availability and coverage of technical assistance through the use of emails and cell phones for mission critical Databases
• Manage space allocation and work with the Storage and Network Engineer.

ORACLE DATABASE ADMINISTRATOR

Confidential, Germantown, Maryland

Responsibilities:

• Installed of Oracle 10g and 11g on Linux Red Hat version 5.5, and Windows Server 2008 platform
• Created and configured Oracle databases using DBCA or manually by using scripts
• Created user accounts and granted appropriate privileges as well as maintaining database security
• Performed database design and development for instances used in test, development and production environments
• Established a backup and recovery strategy using daily hot backups, RMAN and weekly full backup
• Configured Flashback database setting the necessary parameters and Flash Recovery Area, then using RMAN to issue Flash Recovery Commands
• Designed, tested, deployed and documented Oracle RAC databases procedures
• Implemented Oracle ASM and resolved ASM related issues
• Restructured the Oracle RAC configuration by adding and removing nodes along with resolving issues
• Performed database maintenance by applying required patches and software updates
• Worked closely to support software and application developers in various system design tasks
• Performed database migration from Oracle version 9i to 10g & 11g respectively
• Cloned of production databases as needed for testing, development using RMAN or scripts
• Maintained up-to-date documentation to comply with C&A requirements

ORACLE DATABASE ADMINISTRATOR

Confidential, Hagerstown, Maryland

Responsibilities:

• Installed and configured Oracle 11g software on Sun Solaris version 5.10 and Oracle Linux version 5.4 operating system
• Implemented and maintained Oracle Dataguard Physical and Logical standby databases for disaster recovery. Ensure that standby database is always in Sync with production database by checking archivelogs and copying missing ones over to the standby database when required.
• Applied Oracle quarterly patches to the Oracle 11g software.
• Cloned of production databases as needed for testing, development using RMAN and Grid Control.
• Utilized Automatic Workload Repository (AWR) to generate snapshots of key performance data, such as time-model statistics, which shows you how long each database activity is taking and high-load-SQL statistics that aids in identifying resource-intensive SQL statements.
• Installed and configured Oracle 11g RAC databases for development, test and production environments on multiple environments
• Used Oracle Advanced Security option such Lightweight Directory Access Protocol (LDAP) - based directory service, such as Oracle Internet Directory (OID) to perform authentication
• Utilized Automatic Database Diagnostic Monitor (ADDM) to reduce DB time by diagnosing key problems such as Expensive SQL statements, I/O performance issues, locking and concurrency issues, Excessive parsing, Resource bottlenecks (including memory and CPU bottlenecks) and recommending a solution.

QA Tester

Confidential

Responsibilities:

• Reviewed Business Requirements, Functional and Technical specifications with business analyst and QA manager to learn the functionality and process.
• Involved in preparing Test Plan and defined the testing approach, resources and time lines..
• Involved in creating Test strategies, Status Reports and Test Timelines that clearly communicate to business owners the history of UAT Testing activities and results.
• Maintained Requirement Traceability Matrix (RTM) to make sure that test plans were written for all the requirements.
• Developed and maintained Test data and Test cases.
• Conducted Back-End Testing Using SQL queries.
• Extensively inserted transaction points to Test performance of the server.
• Used SQL statements to query the Oracle Database for Data Validation and Data Integrity.
• Executed Test cases found errors reported defects, determined repair priorities, did Regression Testing and closed by using Mercury Quality Center.
• Conducted the defect review meetings to track status of the defect resolution and discussed the issues with the developers.
• Validate the Web Services, both request and respond using SOAPUI
• Perform functional and Regression Testing using QTP Automation Tool.

APPLICATIONS DEVELOPER

Confidential

Responsibilities:

• Built a MS Access database to collect products information and generate needed commands and different monthly reports upon request
• Developed Visual Basic scripts to automate table updates in Embarcadero ER/Studio
• Created a Visual Basic script to automate updating table and column names in STM files to match Oracle database schema
• Updated scripts in Excel to generate reference tables
• Used Eclipse debugging (local/remote) with Tomcat to test and troubleshoot applications
• Created SQL scripts to query SQL database, developed VB.NET/ASP.NET forms via SQL that significantly decreased data entry and transactional processing times
• Desktop (client) application development experience in JAVA especially using Eclipse RCP (Rich Client Platform) Framework