OBJECTIVES:

Seeking challenging Sr. Database Developer, Application DBA and/or DBA position

SUMMARY:

• Highly accomplished Sr. Oracle core developer/architect with DBA experience, having more than 19 years trackable record of success in Oracle database application life cycle process including requirement, definition, prototyping, proof of concept, design, development, test, delivery, support and maintenance.
• Technical team leader with 3 - 7 team members.
• Proven ability to tackle and succeed in all endeavors from high profile lifecycle projects to customized enhancement.
• Extensive success experience, solid knowledge of Oracle products and learning capabilities ensure a success career in the future.

TECHNICAL SKILLS:

Database: Oracle 7.x, 8i, 9i, 10g, 11g, 12c, MS SQL Server, Informix, Sybase, MS Access, Ingress, Oracle Warehouse Builder 9i, 10g.

Operating Systems: Red Hat Linux, Solaris Unix, HP Unix, Pyramid Unix, IBM AIX, AWS (Amazon Web Services), MS Windows NT, MS Windows.

Languages: SQL, PL/SQL, C/C++, Shell Script, Pro*C, HTML, DHTML, Java Script, ASP, VB, VB Script, JSP, CSS, Java, XML, Makefile, Pro*COBOL, VAX/VMS COM, FORTRAN.

Tools: /Methods: SQL*Plus, SQL*Loader, Export/Import, SQL Developer, Toad, MS Visual Studio Express 2015, MS OneNote, Agile Methodology with DSD, BRD etc., Oracle OEM, Oracle Streams 10g/11g, Oracle RMAN 8i/9i/10g/11g, SQL Developer Data Modeler 3.0, Oracle Designer 2000/9i/10g, Erwin, Oracle Developer 2000, MS Visio, SQL Developer 4.0, PL/SQL Developer, SQL Navigator, Oracle Reports 2.5/6, 7.3.2/8.0, Oracle Reports Developer 11g, Oracle Forms 4.5/5.0, Oracle Forms Builder 11g, Oracle JDeveloper 2.1, Oracle AS, TKPROF, Explain Plan, Oracle SDP, Oracle Workflow, Oracle WebDB.

Version Control and Tracking Tools: TFS, Jira, SVN, CCC Harvest, PVCS, CVS, VSS, Wiki.

Other software: IBM Cognos 10, Oracle Applications 11i ERP (Order Management, Inventory, Advanced Pricing, Receivable).

Database Development skills: PL/SQL Packages, Stored Procedures, Functions, Cursors, Triggers, Views, Materialize Views, Temporary tables, Indexing, Hints, Partitioning, Oracle, Oracle Web Toolkit/PL-SQL Web Cartridge, etc.

PROFESSIONAL EXPERIENCE:

Confidential, McLean, VA

Sr Database Developer/Architect

Responsibilities:

• Full-time involvement of DSD (Design Solution Document) and BRD (Business Requirement Document) in the agile project. Thoroughly research of ComReg system application programs (SQL, PL/SQL, Oracle Forms, Oracle Report, SQL*Loader) and completed majority of user stores on GL (account class) and ptype (product type) changes for the project.
• Development with SQL, PL/SQL (packages, procedures, functions, triggers, analytical functions, materialized views etc.), Forms Builder 11g, Reports Developer 11g. SQL*Loader.

Tools/Technologies: Oracle 11g, TOAD, PL/SQL, SQL, MS Visual Studio, agile Methodology.

Confidential, Rockville, MD

Sr. Database Developer/DBA/Team Leader

Responsibilities:

• Oracle database development and support team leader (3-4 members) - coding standard and quality control, junior team member mentor, team task management, documentation, etc.
• Development Projects
• HRSA ETL Enhancement development team lead - the real-time application gets grants through Web Service from HRSA database into Confidential staging database, transforms and loads data into ACF GATES databases through DB link. The work included new financial interface module, new grantee module enhancement. It was developed with SQL and PL/SQL, Java, XML and a DB-link.

Tools: /Technologies: Oracle 10g, Oracle 11g, Oracle 12c, OEM, RMAN, Oracle Steams, Cognos, TOAD, SQL Developer, SQL Developer Data Modeler, Oracle data pump (expdp/impdp), Subversion (SVN), Wiki, Jira, PL/SQL, SQL, Java, XML, Erwin.

Sr. Technical Consultant

Confidential, Taylor, Texas

Responsibilities:

• Confidential database development team leader with 3 members.
• Participated in the design of data warehouse systems and data mining, provided analysis and recommendation on database storage capacity, dimension data modeling and initial data loading with SQL, PL/SQL and DB link.
• Configuration and scripting with TIBCO BI (Spotfire)
• S&B BD compute Framework - Event definition and dependency design implementation with TIBCO BW, SQL, PL/SQL.
• S&B BD compute - Technical design, document, and code S&B Bill Determinant (BD) in SQL, PL/SQL. I coded ALL 200 S&B BDs for the entire system in CSI.
• S&B BD compute unit test SQL performance tuning (1.0 Terabyte real-time data process daily) - indexes, materialized views, partitions, analytical function, hints, SQL tracing, and explain plan.

Tools: /Technologies: Oracle9i/10g, SQL, PL/SQL, TIBCO Spotfire, TIBCO BW, Oracle Warehouse Builder 10g, PL/SQL Developer, TOAD, SQL*Plus, Unix Shell Script, CVS.

Confidential, Denver, CO

Responsibilities:

• Install and maintenance of DEV/TST Oracle 10g databases on 2 RH Linux machines, perform daily monitoring, management, backup, and DB performance tuning and trouble-shooting.
• Remote administration of integration testing database (Oracle 10g on HP Unix).
• All kinds of DB support to Confidential development and QA team, including SQL script, PL/SQL coding, data preparation, loading and maintenance, objects and user maintenance.

Tools: /Technologies: Oracle 9.2/10g, OEM, RMAN, RH Linux, Shell Script, TOAD, MS Visio, PL/SQL, SQL, XML, SQL*Loader, Export/Import.

Sr. Database Developer

Confidential, Taylor, Texas

Responsibilities:

• MMS and External interfaces technical design, implementation and data mapping - ERD diagram with Erwin, interface implementation with SQL, PL/SQL coding (packages, procedures, functions, triggers, analytical functions, materialized views).

Tools: /Technologies: Oracle 9.2/10g, TOAD, PL/SQL Developer, Erwin, PL/SQL, SQL.

Confidential, Rockville, MD

Sr. Application Developer/Oracle DBA

Responsibilities:

• Database/DBA group team leader from Oct 2005 - Jan 2007
• Oracle DBA - Plan, install, configure and maintain multiple Oracle databases on Linux. Perform daily monitoring, management, backup, and trouble-shooting.
• Lead Oracle developer - technical assessment and support on developing data dictionary, data models, metadata repository, and data loading strategy. Plan, design, develop, maintain and support of Oracle database applications.
• Database change controller - control and track all database related changes. Database development standards creation and enforce the standard implementation.
• OPHS ETL project technical lead - The application extracts grants from Confidential eGrants database and loads into ACF database through DB link. My duties: 1. Detail technical design, data mapping, data modeling, database design and implementation (with Erwin). 2. Development with PL/SQL, SQL. 3. Unit/Integration test, application installation.
• HRSA ETL project technical lead: The application gets grants, through Web Service, from HRSA database into Confidential eGrants database (stage) and loads into ACF database through DB link. My duties: 1. Interface/communicate with client company HRSA. 2. Data transfer and GUI application design and development with Java, JSP, HTML, XML. 3. Design, data mapping, data modeling, database design and implementation (with Erwin/Visio). 4. Development with PL/SQL, SQL. 5. Unit/Integration test, application installation.
• Support front-end application development team with all kinds of Oracle related issues. SQL tuning with TKPROF and Explain Plan.
• Mentor junior team members in DB team and application development team.

Tools: /Technologies: Oracle 9i and 10g, OEM, RMAN, Sun Solaris Unix, Oracle Designer 9i, Erwin, Visio, TOAD, VSS, TKPROF, Explain Plan, PL/SQL, SQL, Java, Shell Script, JSP, HTML, XML.

Confidential, Miami, FL

Sr. Oracle Developer

Responsibilities:

• Development with PL/SQL and SQL, SQL tuning, unit test and documentation.

Tools: /Technologies: Oracle 8i and 9i, PL/SQL, TOAD, PL/SQL Developer, PVCS. Explain Plan.

Confidential, Houston, TX

Oracle DBA/Developer/Analyst

Responsibilities:

• MAG definition, requirement collection, documentation, technical design, data modeling, database plan, design, install, configure and maintain multiple Oracle 9i databases on Windows NT and HP Unix environments. Perform daily monitoring, management, backup, DB tuning and trouble-shooting. 24x7 production support.
• Database change control with creation of DB development procedure for MAG. Documentation and program code version control with MS VSS.
• Back-end DB development with PL/SQL, SQL. SQL tuning with TKPROF and explain plan.
• Front-end Web development with ASP, VB, HTML, Java Script in MS IIS environment.
• Production support for MAG. Creation of ad hoc reports for management, back-end and front-end enhancement/development.
• Data Warehouse project MCAS (Merchant Credit Analysis System) - Plan, install, configure and maintain Oracle Warehouse Builder 9i on HP Unix environment, Extraction data modeling and coding with Java, Shell Script, SQL and PL/SQL.
• Order management and delivery system project (part-time) for TBS (Former E-Switch.com): 1. Order Entry and Order Management with SQL server and ASP/VB. 2. Financial Management with QuickBooks, Q-Stock.

Tools: /Technologies: Oracle 8i and 9i, Oracle Warehouse Builder 9i, OEM, RMAN, HP Unix, SQL*Plus, TOAD, MS IIS, MS Visual Studio, SQL, PL/SQL, Java, Shell Script, ASP, HTML, VB, Java Script, SQL Loader, Export/Import, TKPROF, Explain Plan, QuickBooks, Q-Stock, SQL Server, Access.