SUMMARY:

Over 15+ years of IT professional experience in a variety of roles ranging from programmer/analyst to systems, ETL, database administrator and architect

PROFESSIONAL EXPERIENCE;

Confidential, Falls Church, VA

Sr. Data Architect/Application DBA

Responsibilities:

• Contract in Confidential . Provide support in CA/ACS/ECAS Oracle and SQL Server 2008/2012 multiple database.
• Architected and maintained database design, modeling, ETL, and implementation. Using ER/Studio Data Architect V11 by Embarcadero to design logical, physical model, and submodel. Data/datatype mapping, database generated, and repository for data dirctionary. Reverse engineer an existing database, includes table, view, object type, package, procedure, synonym, trigger, data security and accessibility, compare and merge utility, data loading, and edit macro code.
• Oracle DBA on UNIX and Windows to perform business analysis, data analysis, and support develop team. Toad 12C to manage database, table, view, user, replication, process performance tuning & optimization experience.
• Backup and restore of data, service guard, disaster recovery. Creating and updating PL/SQL, PostGreSQL, JSON, T - SQL, SSIS, XML, JDBC, JPA, UNIX script code, package, index, stored porcedure and trigger creation, job scheduling and alert management.

Confidential, Fort Meade/Army Base, MD

Sr. Oracle/MySQL DBA

Responsibilities:

• Contract in Defense Information System Agency. Support DoD DISA/NDSS (Network Design Support Systems) multiple Oracle/MySQL/SQL Server production and test database on UNIX&Linux, Windows platforms. Provide database architecture, design, database patches, and all its associated products to include applications tools.
• Database management, monitoring, clustering, ETL operations, query performance tuning and optimization. RAC, SharePlex v7 Replication, TOAD for Oracle 12.6, OEM 12c, PL/SQL, PowerPoint, package, function, loading and analyze weekly data, maintain production database, logical and physical data modeling, data migration, Global traffic engineering, performance assessment module (PAM), Network usage and GOS analysis and review, circuit sizing calculation, VoLP performance, partition table/index, weekly/monthly backups, export/import and refresh database, Perl data loading scripts.
• MySQL 5.6&5.7 DBA/Developer, installation, configuration. Support GUI to create & view & modify data, and packages. PHP v5.x to access MySQL data to support NDSS. Using Java, JavaScript, Apache, .NET, Drupal v7 design Web server/UCEP, Python, form and report are for dynamic Web sites.
• Strong Oracle APEX (Application Express) 3.2/4.1 DBA/Dev for administration, design, development, deployment, workspace, application wizard, data loading, create page, and application, LOVs, validations for SQL, PL/SQL, forms/reports, and PLPDF report for CONUS/OCONUS using functions.
• Support customer facing web applications. Manage Oracle Communications Operation Monitor 3.3, and monitor communication process at Palladion/JITC labs. Use OBIEE 11g on repository, dashboards, ad-hoc analysis/query, published reporting from data source/models for Call data.
• ETL processes, data modeling, Informatica v9, DataStage v7/8, ERWin, ETL code for data migration, it includes database, package, functions, and procedures. Performance tuning and troubleshooting are on database and application. Weblogic servers are on forms and reports.

Confidential, Falls Church, VA

Sr. DBA/Data Analyst

Responsibilities:

• Support DHS/ICE Oracle/SQL Server/DB2 development team in architecture, design, standby DB, replication, development of database schema and processes for new and existing applications.
• Support DHS database, it includes baseline architecture, data modeling, new structure, production DBA file download, manual Informatica v8 source, target, mapping, post-processing, data validation from legacy database to SQL Server and Oracle.
• DDL, DML, TOAD, CMM, RAC, Dataguard. Erwin, write document for database design and mapping, Materialized Views, SQL*loader, RMAN, SSIS, SSRS, Export/Import schema/tables. Crystal report.
• ETL processes, reporting load, package, procedure, function, trigger, troubleshooting, performance tuning use Explain Plan and Quest SQL Optimizer, bug fix, User Case mapping, Merant Tracker.

Confidential, Vienna, VA

Sr. Oracle DBA/Developer

Responsibilities:

• Support Confidential database, it includes Confidential, RAC environment using Unix and HP servers, troubleshooting, fix bug, different database's performance, monthly and weekly usage statistics, and public synonym switch.

Confidential, Washington, DC

Responsibilities:

• Support HUD database for mainframe application (IDIS), Windows client application (SNAPS). DBA is for multiple Oracle/SQL Server database. Main job is for ETL data conversion, analyze legacy database and table, federal financial like general ledger, fixed assets, data mapping, use data modeling tool CA ERwin for logical data, physical database to design reengineered tables, columns, and lookup tables, generate DDL, create new database, schema, database sizing, database security management, export/import, data conversion scripts using PL/SQL and loader.
• After data loading, check error data, discuss with application team for data and datatype, recreate packages, procedures, and triggers for new database, performance tuning, and new architecture for conversion all HUD data (house finance and funding) from DB2/Sybase to SQL Server and Oracle on Oracle 9i, 10g, OEM, ETL, T-SQL, Batch Process, UML, Visual SourceSafe, Excel, MKS Source Integrity, Solaris, and Windows.

Confidential, Reston, VA

Sr. Oracle DBA

Responsibilities:

• DBA support Nextel production, QA and test multi-terabyte sized databases (24x7).
• Provide Physical Database Design and Architecture, testing, performance tuning.
• Participate in the strategy, design, and implementation for backup, restore, high availability, data migration, and environment creation on Oracle 8i, 9i, 10g, OEM, Sqlnav3, SOLARIS, PL/SQL, PVCS Tracking, SQLHOGE, and SharePlex replication.
• Maintain Schema objects, estimate sizes, space maintenance. Export/Import of statistics, and refresh QA/Dev databases from Production on parallel server in Sun environment.
• OLTP and VLDB database tuning, and debugging. Perform technical troubleshooting and give consultation to development team. Wrote PL/SQL to support data migration.
• Develop Advanced Query for data access with SQL, PL/SQL, Pro*C, ETL, Parallel Execution, BI with 10g, JIRA to tracking, Discoverer, 9iAS, JDBC, SQLJ, Subversion, Packages.
• Take training class Oracle Warehouse Builder for administration and operations on Nextel.

Confidential, McLean, VA

Sr. Oracle/SQL Server DBA/Developer

Responsibilities:

• Supported Internet Wireless Services on Oracle 8i/9i, Solaris 8, Microsoft Internet information Service Web Server Windows, and Windows 2000.
• Provided database services and database support for Web Application Infrastructure Support (WAIS terabyte-sized databases) on a daily basis, including all maintenance and support services related to multiple database in test, development and production environment.
• Performed tuning on using SQL Navigate, Oracle Enterprise Manager, optimizer hints.
• Supported web data marts, implemented and monitored the replications. Evaluated system update architecture (RAC, OPFS, OPS, Solaris 8, and Sun Cluster).
• Performed logical and physical data modeling (data warehouse/stat query), entity relationship diagramming, dimensional modeling with ERwin.
• Created database schema, table structure, indexes, constraint, stored procedures, users, and developed database backup and recovery strategy. Performance tuning, ASP, T-SQL.
• Utilized BCP utility to import and export data, and BULK INSERT to load data into SQL Server

Confidential, Fairfax, VA

Oracle DBA/Application Developer

Responsibilities:

• Contract for TRAM Data Conversion and Migration system on Windows NT/Unix platform for PTO (Patent Trademark Office). Transfer/convert all PTO data from COBOL (on VAX) to Oracle8i.
• Participated in large-scale system (TRAM) life cycle activities including requirement analysis, design and implement, detail system design, system development, parallel DML and queries, partitioning tables/indexes, mapping, filtered error analysis, validation, synchronization testing.
• Designed PTO secure gateway for service secure authorization's database and system.

Confidential, Falls Church, VA

DBA/Developer

Responsibilities:

• supports Confidential in managing on Oracle8 and Sybase.