SUMMARY

Oracle certified DBA with 6 years of database & systems administration experience. Additional experience includes project management, training, and data analysis. Proficient in database design, implementation and maintenance of database management systems across multiple platforms. An analytical professional driven by challenges and committed to achieving best practices within a multifaceted environment.

EXPERIENCE

Junior Oracle DBA 2012 to Present
Confidential - Arlington, VA

• Installation, setup & configuration of Oracle 10gR2 RAC & single instance databases.
• Perform monitoring, administration & troubleshooting of Oracle databases.
• Respond to trouble tickets and customer requests.
• Monitor and troubleshoot database backups, disk space, and server availability.
• Setup, configuration and management of Oracle Enterprise Manager.
• Deploy application, database & OS upgrades as required.

Applications Specialist II 2012 to 2012
Confidential, Baltimore, MD

• Responsible for coordination and performance of analysis, design, development, testing and validation of clinical report projects.
• Provide system administration of Business Objects applications & servers.
• Troubleshoot report and server performance and tune components accordingly.

Database Analyst 2010 to 2011
Confidential - Hunt Valley, MD

• Supported the configuration, deployment and administration of vendor and in-house applications interfacing with Oracle and SQL Server databases.
• Identified and made recommendations for resolution of system performance issues.
• Made necessary enhancements in order to add and/or maintain optimal functionality of the application(s). These modifications include creating and updating of data entry screens, tables, data dictionaries and rules.
• Wrote database documentation, including data standards, procedures and definitions for the data dictionary.
• Implemented and monitored user access and security.
• Developed complex SQL queries and procedures to analyze, manipulate and investigate data problems.
• Analyzed data requirements used in the creation of system reports utilizing integrated report-writing tools.
• Participated in system workgroup and planning meetings tasked with analyzing migration and continuous application improvement strategies.

Database Specialist II 2008 to 2010
Confidential, Pikesville, MD

• Primarily administered Oracle development and OLTP databases integrated with various applications department-wide.
• Supported SQL Server 2005 Audit Collection Services (ACS) database components of a System Center Operations Manager 2007(SCOM) implementation: Manage maintenance plans, tune reporting services, respond to SCOM alerts and follow up with appropriate hotfixes.
• Managed occasional projects involving maintenance of the agency\'s Microsoft Access databases.
• Developed logical and physical database designs and ensure appropriate modifications to the design models or schemas.
• Conducted system analysis, define user requirements and develop or recommend optimal database solution.
• Wrote and edited SQL and batch file scripts.
• Monitored database performance through the use of proactive tools, including ADRCI (11g), ADDM statistics, and various dynamic and data dictionary views.
• Tuned applicable SQL code or system component(s) based on monitoring findings with memory and network bottlenecks as high priority issues.
• Resolved performance issues through specific feedback from users, collection and analysis of database diagnostic data and tuning isolated components while observing each effect.
• Conducted and managed full and incremental database backups via RMAN.
• Documented database and related server equipment & procedures.
• Configured and updated user security in accordance with agency policy.
• Troubleshot errors related to availability of data to system users, space, database software, or data access.
• Migrated data via data pump, ODBC, SQL*Loader or internal import/export features.
• Created reports in response to a variety of data needs.

Database Manager 2008 to 2008
Confidential - Lutherville, MD

• Worked at the American Institutes for Research: Managed several Microsoft Access databases containing data involved in randomized controlled trial.
• Created Access database objects (tables, queries, reports, macros, and modules) to support staff reporting needs.
• Maintained data dictionaries and other database documentation for datasets.
• Performed data cleaning and imported data into various databases.
• Merged data, created and recoded variables to prepare data for analyses.
• Ensured that staff adhered to Institutional Review Board (IRB) Standards and Regulations.

HMIS Specialist 2006 to 2008
Confidential - Baltimore, MD

• Managed Baltimore County\'s web-based Homeless Management Information System containing 75 users spanning 16 agencies.
• Implemented new agencies onto system.
• Trained users & provided software support.
• Monitored agency compliance with HUD, HIPAA and system policies & procedures.
• Analyzed system data quality.
• Prepared adhoc and routine statistical reports.
• Participated in a variety of homeless services stakeholder committees.
• Prepared renewal contracts and grant applications.
• Managed project budget.
• Maintained & updated system policies & procedures.

Coordinated annual Point-in-Time Study: Comprehensive survey research project involving 50+ volunteers charged with the collection of vital data on the homeless population within Baltimore County. Process included detailed analysis and reporting of survey data to federal and congressional sources.

EDUCATION & CERTIFICATION

Oracle Database 11g Administrator Certified Associate (OCA)2010

Business Administration & Computer Information Systems
Confidential, Towson, MD - Dean\'s List: 2003-2005
BA, Sociology, Minor: Modern Languages & Linguistics 2001
Confidential, Catonsville, MD

TRAINING, SKILLS & SEMINARS

• Crystal Reports XI Level 2, System Source, Hunt Valley, MD, November 2009
• Crystal Reports XI Level 1, System Source, Hunt Valley, MD, September 2009
• Oracle Database 10g: Backup and Recovery, Fujitsu Consulting, System Source-Columbia, MD, August 2009
• Oracle Database 10g: Performance Tuning Ed 1, Fujitsu Consulting, System Source- Columbia, MD, July 2009
• Oracle Database 10g: Administration Workshop I Ed 3, Fujitsu Consulting, System Source-Columbia, MD, July 2009
• Oracle Day Baltimore, Oracle, Baltimore Marriott Waterfront-Baltimore, MD, August 2008 - Conference featuring Oracle Database 11g and Oracle Fusion Middleware
• Oracle Database 10g: Introduction to SQL, UMBC Training Centers, Halethorpe, MD, May 2008
• HMIS Grant Administration Training, US Department of Housing & Urban Development, Hilton, Minneapolis, MN, September 2007
• Windows Server 2003/2008, Oracle Enterprise Linux
• MS Office Professional (Visio, Access, Word, PowerPoint, Excel, Outlook)
• Oracle Database 10g/11g & Tools: SQL Plus, RMAN, SQL Developer, Enterprise Manager, TOAD for Oracle
• PL/SQL
• SQL Server 2005/2008 & Tools: Visual Studio, SQL Server Management Studio, SSRS, SSIS
• Business Objects XI, Crystal Reports 2008
• SPSS
• ServicePoint & The Advanced Reporting Tool (HMIS)