SUMMARY:

• Sr. Database Administrator/Team Lead with extensive development experience
• Oracle Database Professional with 18 years of extensive technical experience focusing on providing high quality IT solutions in commercial and federal government environments.
• In a last 10 years served as Oracle Database Administrator, Principal Data Warehouse Architect, and the Team Lead on Federal Government projects managing highly effective end - to-end data processing environment leveraging data accessibility, security, and flexibility of the database infrastructure and data processing using cutting edge Oracle 11G Relational Database technologies.
• Possesses broad hands-on programming experience developing applications in client server and web environments.
• Has diversified technical background in consulting & product-engineering assignments consistently focused on technology innovation and leveraging current environments into emerging service oriented architecture (SOA), and establishing common language for business-IT alignment.

TECHNICAL SKILLS:

• Oracle PL/SQL
• SQL
• Java
• JavaScript
• VB Script
• ASP
• C #
• SQL*Plus v. 12c
• VM ESX Server 3.5
• Microsoft Visual Studio .NET v.5
• Management Studio v 8
• Oracle Enterprise Manager 12c
• Oracle Designer v 10G
• Oracle Forms v 10G
• Oracle Reports v 10G
• Oracle Procedure Builder 10G
• J Builder v 10G
• TOAD v 12c
• JIRA Software
• Jenkins Server v12.1

PROFESSIONAL EXPERIENCE:

Confidential

Database Administrator

Responsibilities:

• Researched business processes and client’s data mining needs.
• Prototyped and designed database entities and software objects to closely satisfy customer business requirements for data integrity and 24X7 availability.
• Developed, tested and implemented multiple Oracle 10G/11G based PL/SQL packages containing over 200 stored procedures and functions in support of the web application and reporting queries.
• Used advanced features of Oracle technology, such as dynamic cursors, XML file exchange, data retrieval and manipulation of the binary objects (LOB), etc.
• Designed and developed Database objects (materialized views/partitioned tables) in support of user reporting environment. Wrote ETL queries/scripted database jobs for data loads, resolved technical issues with ETL/reporting instances/schemas.
• Worked on database and software performance tuning projects, establishing and/or re-designing tables and indices, rewriting existing slow performing PL/SQL code, reviewing database server parameters and space allocations for optimal performance.
• Served as a member of the CWP Database support/DBA Counsel. Participated in monthly discussions on Database issues and Database support needs, provided quality technical expert analysis and opinion on Database matters involving Database integrity, performance improvement, database security, and data management automation.
• Designed and supported various project related documentation - Database Design and Overview, Relational Database Diagrams and Data Dictionaries, Software Specifications and Implementation/Deployment Guides and others. Documentation produced has met FAA customer specific contractual requirements and technology high standards and practices.
• Produced high quality results on all assigned tasks, volunteered for application reviews and quality assessments. Continuously assisted FAA users in understanding new technology advances through leveraging data accessibility and visibility, streamlined management’s decision making process, and improved quality of the everyday business processes.

Confidential

Sr. Oracle Datawarehouse Architect

Responsibilities:

• Installed Oracle 10G database and supporting entities, wrote programming objects for data extraction, transfer, load (ETL) and manipulation.
• Performed software upgrades, patch maintenance and integration with vendor software on Windows platforms.
• Developed and improved PL/SQL software for fast performing, and cost-effective Data Warehouse ETL in Oracle 10G environments.
• Researched business processes and clients’ data warehousing needs. Prototyped and designed database closely integrated with Production database environment. Designed data flows and supporting processes.
• As principal Data Warehouse architect, designed entities and processes in support of the mission critical management decisions. Designed and created Business Intelligence environment consisting of over 40 custom reports and data queries.
• Served as database programming technical support, conducted software technical design reviews and specifications.
• Worked on database and software performance tuning projects, establishing and/or re-designing tables and indices, rewriting existing slow performing PL/SQL code, adjusting database server parameters and space allocations for performance boost.
• Performed key role as technical lead during Oracle 9i/10G database and application server migration.
• Performed maintenance and functional upgrades on Oracle Developer 10G Suite, including Oracle Forms and Reports 10G. Worked extensively with libraries, triggers, stored procedures and functions.
• Participated in design and integration of the interface between the Data Warehouse and SQL Server production databases, designed and wrote reports using .NET integrated environment.
• Participated in migration of the Oracle Data Warehouse database 10G to the Virtual Environment on the VMWare (ESX Server 3.5). Oracle server virtualization provided ability to consolidate hardware resources, reduce data centers’ energy consumption, increased Data Warehouse availability, efficiency and cost-effectiveness of the daily IT operations.

Confidential

Sr. Software Engineer

Responsibilities:

• Implemented original Oracle database design during conversion of the Legacy Cobol system to the Oracle 8i relational architecture.
• Participated in enhancements of the Oracle Database and application side entities (Forms, Reports) in versions 8i, and later version 10G.
• Developed multiple software units using Database side objects and application side software (Oracle forms and reports).
• Designed and programmed software for release of the Financial Reconciliation System (FRS). The FRS provided integrated reporting environment which substantially improved management of the accounts receivables and accounts payables and the efficiency of the operational procedures.
• Developed, tested and implemented software releases and patches in accordance with the CMMI best practices and procedures. Produced quality designs in timely manner and in accordance with requirements specifications.

Confidential

Sr. Programmer/Analyst

Responsibilities:

• Performed software development and upgrades using Oracle Developer Suite; wrote stored procedures, functions and triggers using PL/SQL.
• Enhanced software development productivity by applying best CM and SQA practices.
• Provided user application technical support, wrote system and functional software designs and specification documentation.
• Prepared and executed unit, system and integration test plans.
• Displayed high quality results, always adhered to the due dates and timelines.