SUMMARY:

• Accomplished Database Developer with 8+ years of demonstrated success designing and implementing database solutions that improve business functionality. Extensive experience designing, coding, testing and supporting next generation database solutions in Oracle enterprise and SQL Server environments. Proven ability to implement technologies that decrease cost, increase performance and positively affect the bottom line. Oracle Database 11g Administrator Certified Associate (OCA)
• Database Development
• Database Management
• Database Performance Testing
• Database Maintenance
• Data Migration
• Data Quality
• Data Analysis
• Operating Systems

TECHNICAL SKILLS:

Technology and Tools: Expert - PL/SQL, SQL Navigator, SQL Plus, Oracle 11g, COBOLExperienced - Oracle 10g/11g RDBMS, RAC, ASM, RMAN 11g, Oracle BULK Processing, AWR, Oracle Archive, Oracle Backup and Restore, Oracle Developer Suite10g, Toad 11, Oracle Enterprise Manager Cloud 12c Grid Control, SQLLDR, Export/Import Utility, Data Pump, Oracle Optimizer Explain Plan, Oracle SQL Developer 4.0, Oracle Developer(Forms 6i, Reports 6i), Oracle Designer 10, WEB PL/SQL Dev 10, Oracle8i Spatial, TCP-IP, iPlanet Web Server, Crystal Reports 9, MicrosoftOffice 365, MS Access 2016, HTML, Perl, C/C++, Remedy 5.1.2, Remedy 6.3, Linux Red Hat 4, MS SQL Server 2008 (SSMS,SSIS,SSRS,SSAS), ETL(SSIS), MS Visual Studio, ASP.NET, T-SQL, Oracle MySQL, Java Script, Oracle 9i, XML, SQL Developer Data Modeler, Sr. Programmer Analyst (COBOL:UNISYS), Pivotal Tracker

PROFESSIONAL EXPERIENCE:

Confidential, Grounds, MD

Software Developer

Responsibilities:

• Develop and maintain Oracle stored packages, procedures, functions, and PL/SQL code necessary to group related objects supporting the assigned projects. These objects included cursors, nested subqueries and scripts, collections types, merges, and AD-HOC reports.
• Handling tickets / request
• Migrated Sybase tables into Oracle 11g platform using Oracle ETL tool SQLLDR, SQL Developer 4.1, and TOAD 11.
• Investigate and resolve customer complaints with software and responds to suggestions for software modifications.
• Assist Database Administrators with database migrations from Oracle 10g to Oracle 11g. Debugged and resolved over 2500 invalid objects from the migration process.

Confidential, Beltsville, MD

Software Developer

Responsibilities:

• Create Oracle SQL scripts and PL/SQL stored procedures, functions, and triggers supporting the Admissions Information and Midshipmen Information Systems.
• Maintained Web Accessed Enterprise Resource Planned Systems using Oracle Web PL/SQL, Oracle Designer, and SQL Developer.
• Maintained designs to define entities, attributes and Entity Relationship Diagrams (ERD).
• Assist Database Administrator to modify and correct PL/SQL problems experienced with USNA Oracle databases.

Confidential, Columbia, MD

Database Administrator

Responsibilities:

• Member of DBA team supporting 83 database instances
• Migrated seven databases from Oracle 10g to Oracle 11.2.0.3 onto a new server using Data Pump utility.
• Configured a new Oracle database sandbox to evaluate backup and recovery plans, and validate all user schema privileges, stored packages, procedures, functions, triggers, and other required objects functionality for the seven migrated databases. Utilized Oracle Enterprise Manager Grid Control and SQL Developer to assist with these tasks.
• Monitored and maintained Oracle packages, stored procedures (bulk loads), functions, table partitioning, bulk deletes, archive logs, trace files, and Explain Plan for performance maintenance. Performed daily backups, patches, and weekly backups using RMAN supporting seven databases.

Confidential, Annapolis Junction, MD

Database Administrator

Responsibilities:

• Performed data management functions to include installation, configuration and support of Oracle 11g database.
• Maintained Oracle database and associated objects such as schemas, tables, views, indexes, stored procedures and functions, and SQL scripts.
• Monitored Oracle database space and capacity statistics. Created spreadsheet report from capacity statistics.
• Assisted in daily backup and recovery tasks to include incremental and full backups.
• Collaborated with analysts to resolve database level issues by creating stored procedures and functions.
• Applied database patches and upgrades.
• Maintained shell scripts required for database monitoring and performance metrics.
• Designed, created and implemented Oracle PL/SQL scripts to automate processes.

Confidential, Parsippany, NJ

Responsibilities:

• Microsoft SQL Server 2008 Master Program. Designed and created database structures. Created projects using T-SQL and MS service tools.

Confidential, Suffolk, VA

Database Administrator

Responsibilities:

• Managed Oracle database administration assignments for diverse Department of Defense (DOD) clients.
• Installed and configured an Oracle10g Real Application Cluster on a Linux server DBMS environment, with four node text database and three node spatial database.
• Created an Oracle PL/SQL script to restructure a text file into a header, detail, and trailer records and later Imported into several tables.
• Designed Oracle procedures to sync Oracle text data within the database. Generated reporting scripts to list targeted information for analysis of distribution data.
• Generated Oracle scripts and triggers to purge data from several tables.
• Created Oracle roles, privileges and assigned roles to users.
• Designed new schemas from specifications.
• Created replication between Oracle databases using database links and Materialized Views. Used SQL Developer and SQL Navigator tools to perform the required modifications and unit testing of user stored procedures, functions, SQL scripts and packages.
• Developed and managed stored packages, procedures, functions, triggers, sequences, and views.
• Imported and exported selected data from external databases and flat files into production and test environment using SQL Loader and database replication.
• Monitored and resolved all serious Oracle alert log messages. Monitored and maintained Oracle Logical Storage, and tested implementation of Oracle patches and upgrades. Performed backup and restore using RMAN and OEM tool.

Confidential, Chantilly, VA

Commercial Application Software Engineer

Responsibilities:

• Played pivotal roles of Remedy Database Administrator, Oracle Database Administrator, and Oracle Developer for Inventory Tracking System and Solutions Guide Application.
• Installed, configured, and maintaining Virtual Information Processors servers for production, test, and development environments. Installed and configured stand-alone computer laboratory to support the Information Management Team.
• Converted a Microsoft Access application into an Oracle 10g platform application. Transformed MS Access functions into an Oracle 10g stored procedures, functions, and triggers format.
• Designed, developed, and maintained Remedy applications. Created Crystal Reports and Oracle application modules supporting the Inventory Tracking System and Solutions Guide Application.
• Created and maintained Oracle stored packages, procedures, functions, triggers, indexes, and abstract objects for relational tables to support these applications.
• Imported external data from flat files and spreadsheets into the targeted tables via Oracle SQL Loader and Data Pump Utilities.