SUMMARY

• Extensive experience in leading technical teams in design, development and deployment of OLTP databases as well as OLAP data warehouses to include user requirement analysis, data analysis, logical and physical data model design, data profiling, data extraction, transformation, and loading. Also experienced in database storage, system hardware and I/O planning, physical server implementations, security lockdown, database encryption, administration, maintenance, and performance optimization. Agencies supported include FBI, Joint Chief of Staff, DSS, DISA, DLA, Defense Cyber Crime Center and DHS.
• Most recent experience includes designing and developing online transactional databases for DHS USCIS Electronic Immigration System with SDLC/Agile methodology; architecting and building enterprise database systems for Defense Cyber Crime Center; and re - designing/re-engineering an existing snow flake database to dimensional STAR database for Defense Logistics Agency with SDLC/Waterfall development methodology to achieve performance optimization.

SUMMARY

• Oracle 10g Database Administration, Oracle Database Performance Tuning, Oracle Database Fundamental I & II, Oracle Corporation, 09/2005 - 09/2006
• Programming Language and Software Products: ERWin, InforSphere Data Architect (IDA), Rational Software Architect (RSA), Oracle Designer, JDeveloper, SqlDeveloper, SQLLoader, TOAD, Oracle 8i - 11gR2, MSSQL, SQL, PL/SQL, UML, Weblogic, Apache, IIS ServerHTML, Adobe Photoshop, Macromedia MX, MS Office, MS Project, SharePoint, CVS, Subversion, ClearCase, ClearQuest, APEX
• Operating Systems: HP Unix, Solaris, TSOL 8, Unix Tru64, IBM AIX, Linux, SELinux, Windows
• Networking and IS Security Knowledge: Computer Systems Security Planning and Risk Analysis, Network Security Control and Management
• Business Development and Management Knowledge: Project Management, Financial Planning for IT Managers, IT Business Analysis and Development
• Database Research Project: A research study of concurrency control focusing on deadlock detection and prevention
• Operating System Benchmarking Project: This project benchmarked the processing speed of SUN’s Netra 1400 with four Sparc Ultra-80 CPUs and with Solaris 2.8 operating system under a multi-user environment by using two tools: Runtime Program (A “C” program which calculated the total runtime of fixed number of instructions) and “top” (A Solaris operating system utility that monitors the CPU utilization by all of its users)
• Local Area Network Security Management: This study discussed multiple security threats to Local Area Networks, and proposed Access Control and Network Management as methods of defense
• Internet Business Analysis: This paper provided an analysis on Internet Business opportunities and proposed an Internet Business Model
• Information Risk Assessment and Security Management Project: This project explored the risks of the Computer Systems used by the Configuration Management Group at a local Networking company in Maryland, and proposed specific security controls to improve system security

PROFESSIONAL EXPERIENCE

Consultant IT/Data Architect

Confidential, Washington DC

Responsibilities:

• Attend weekly meetings with clients, Data Architecture Working Group, for Design needs assessment and Architecture requirement review.
• Analyze the requirements of data models/database systems, and work with other Data Architects, System Architect and SOA architects to deliver Enterprise IT Solutions using Agile development methodologies.
• Design and develop logical data model and physical database with data team for USCIS Electronic Immigration System in compliance with FISMA.
• Lead the design and development effort in creating a Master Data Management database using Oracle 11gR2 to manage the metadata and change requests on Reference Data.
• Develops technical, structural and organizational specifications to include access methods, access time, job control language, statistical methodologies, device allocation, validation checks, protection and security.
• Convert Logical Data Model to UML Model by using both IBM InfoSphere Data Architect (IDA) and IBM Rational Software Architect (RSA) helping developers to understand the design of data model.
• Design and create UML Objects, including Message Classes, XML schemas, UML Profiles, Stereotypes.
• Work with developers on Message Model design and development, and generate XML schemas from Message Model for web services using IBM Rational Software Architect.
• Recommend Database Management Strategies to DBA Team on Loading Data, Moving Data, Database Replication, Database Optimization such as data import and export routines for data loading automation, table partitioning, I/O Optimization, database processing and storage.
• Mentor junior database developers developing database applications.
• Version and Maintain Data Artifacts and development efforts (files) using IBM ClearCase and ClearQuest.
• Prepares reports and recommendations of new/changing processes products.
• Remain abreast of and analyze new and emerging technologies and tools for applicability to field.
• Attended conferences and seminars in Big Data Management presented by Informatica, Hadoop, MapReduce, and Cloudera.

Database Manager and Administrator

Confidential, MD

Responsibilities:

• Architect and establish the first Oracle Enterprise Environment for Defense Cyber Crime Center.
• Design and build Enterprise Information Systems including Capacity Planning in an On demand usage environment, building Database and Web Application servers to support multiple database development efforts.
• Install and configure Oracle database 11gR2 and Weblogic Fusion Middleware for development.
• Install and configure OCI8 on Apache/PHP server to enable the connection between Apache/PHP Web application and Oracle 11g R2 database.
• Install, configure and test Oracle 11gR2 RAC with ASM on VMWare Virtual Machine with RHEL5.5 operating system.
• Review Database systems for any vulnerability.
• Perform Security Lockdown (STIG) on Oracle Database 11g and MSSQL 2000/2005 according to the Security Checklist published by Defense Information Systems Agency.
• Upgrade and Apply Oracle Critical Patches to the database servers.
• Encrypt database/tablespace to protect PII data using Oracle 11g Advanced Security Transparent Data Encryption (TDE).
• Assist data modelers and developers with effective use of the tools and software including ERWin, JDeveloper, SqlDeveloper, and Subversion.
• Deploy production databases and applications by installing database DDL and Web application code on to the production systems.
• Load/Move data using SQLLoader, Export/Import using Oracle Data Pump.
• Implement database backup and log retention policy using Oracle Recovery Manager (RMAN).
• Work with System Administrator to back up entire databases server using Veritas.
• Configure and enable Flashback feature for database recovery.
• Successfully restore the database after Oracle Sys was corrupted.
• Mentor/advise supporting staff, Linux/Windows administrators and Help Desk personnel, on technical requirements and implementation methodologies in support of Oracle database development/operations.
• Document database installation, backup, restoration, replication and security lockdown procedures.
• Provide project management and customer service in a dynamic environment - Planning and organizing, meeting project deadlines while maintaining high customer service and quality controls.
• Generate and provide to the customer Monthly Report of Technical Services provided.

Data/Database Architect and Administrator

Confidential, VA

Responsibilities:

• Primary Data Architect/Modeler for DLA Asset Visibility Project and DBA for DCGS-A project.
• Analyze data and Design logical/physical data models using ERWin data modeling tool including re-engineering a SNOWFLAKE data model to STAR schema to tremendously improve the data warehouse performance.
• Generate DDL install scripts from physical data model, and install on to database server.
• Work with ETL (Informatica) developers helping them understand the data model for the accuracy of the data mapping workflow.
• Manage change requests to the Data Models and databases.
• Work with testers helping them create test cases, especially for data that are not straight mapping from source to target and that require lookups.
• Perform Database Administrator function to support databases/Data Warehouse development.
• Perform Database and application Tuning including working with Business Object developers, Partitioning tables, tuning SQL statements, developing index strategy and implementing appropriate indexes, writing recommendations on setting database initial parameters, sizing data files, sizing redo log files and configuring undo space for performance.
• Replicate/Backup/Recover databases by using Oracle Data Pump export/import and RMAN.
• Develop Text Indexing strategies and Implement Text Indexes onto Database Schemas.
• Resolve reported database related problems and issues.
• Perform Security Lockdown on both Oracle and MSSQL production databases by STIG (including security patches and version upgrade).
• Build and configure Oracle 11gR2 database on RHEL 5 server replacing the default VCenter database, MSSQL, to support VMWare VCenter for scalability.

Senior Database Management Specialist

Confidential, Washington, DC

Responsibilities:

• Manage the development of database projects.
• Provide daily supervision and direction to support staff.
• Ensure the security and availability of the production Oracle and MSSQ databases.
• Plan and apply security patches for Oracle databases on Windows, Red Hat Linux and Sun Solaris.
• Plan and coordinate with system engineers to upgrade operating systems and database servers.
• Install Oracle 11g database on Sun Solaris 10 server and set up Windows clients to connect to the Oracle.
• Build a LINUX RHEL5 server with Oracle 10g Installed and database created to support the newly upgraded mail application server.
• Plan staff and database resources, and when necessary, reallocate resources to maximize benefits.
• Prepare and deliver presentations on database management systems (DBMS) status.

Database Development Team Lead/ Technical Lead

Confidential, Alexandria, VA

Responsibilities:

• Successfully lead the team to design and deliver the database that hosted Java applications/web services in a J2EE environment within a very short time frame.
• Manage and provide technical guidance to the software developers including Oracle PL/SQL developers, C programmers, and Java programmers.
• Manage data and database to support the software development effort.
• Manage multiple corporate financial, payroll and business Oracle production databases on IBM AIX and MSSQL on Windows.
• Develop and document database backup and recovery strategies for the corporation.
• Perform database space management including tablespace (datafile) resizing and relocation.
• Optimizing database performance by tuning SGA, collecting statistics and analyzing/tuning SQL queries.

Principal Specialist in Database

Confidential, Fairfax, VA

Responsibilities:

• Support Application Software Development through database schema implementation with Oracle 10g in a data warehouse environment.
• Use Oracle Designer to capture and re-generate database.
• Present and explain the application software capabilities and functions to the customer.
• Perform database O& M tasks including monitoring, space management, performance tuning and backups.
• Perform Testing and Configuration Management for software development.
• Design and implement the Multi-level Security Systems.
• Present and demonstrate to the customer the capabilities of Multi-level Security Systems.
• Build Multi-Level Database Servers and Workstations.
• Integrate and test Multi-Level PL/SQL database application.
• Install and Patch Trusted Solaris 8.
• Install and patch Oracle 9i with Oracle Label Security on Trusted Solaris 8.
• Configure Oracle Label Security Policies on the database server.
• Install and Configure General Dynamics Trusted Network Environment products including Database Bridge and Web Server.
• Perform the DCID 6/4 Administration.
• Develop Homeland Security SCI Systems Handbook with DCID 6/3 compliance.

Systems Networking and Database Manager

Confidential

Responsibilities:

• Perform Database Administration for an Air Force Special Program contributed to Microsoft-centric system and Oracle 9i DB administration to include all facets associated with duties of user account creation, report generation, and DB modifications.
• Schedule & perform recurring operating systems & Oracle database backup/recovery.
• Build a Windows 2000 server with Oracle 9i database and IIS installed.
• Configure and administer Oracle Data Guard management
• Successfully completed a variety of network management functions.
• Implement information systems security mechanisms.
• Made changes to the application, reports, and database fields as directed by the customer.
• Provide IT risk assessment to inter-agency government personnel.
• Install Oracle database software on Windows and Unix.
• Perform scheduled Database hot/cold backups.
• Upgrade Oracle 7.3.4 to Oracle 9i on UNIX/Tru64 Server.
• Manage Database Storage Structure.
• Manage and monitor Users and database Security.
• Import and Export data by using exp/imp utility.
• Monitor and improve database performance.
• Contract Language Specialist at Federal Bureau of Investigation, Washington, DC
• Interpret and translate Foreign Intelligence Information, and prepare reports.