SUMMARY

An Information Technology professional offering expertise in Database Architecture, Database ,Administration (DBA), and Data Modeling and Database Applications Design in ORACLE,INFORMIX and SYBASE DBMS on the UNIX and Windows platforms. Extensive experience in design, development, administration, and implementation of OLTP, OLAP, DSS, data warehouse andmulti - tier web based projects for Government and Commercial clients. 

TECHNICAL SKILLS

Computer Languages, Databases and CASE Tools,AIX/IBM,UNIX/C,ORACLE 12c/11g/10g/9i/,8i - PL SQL/PRO-C,SOLARIS/Oracle,UNIX SHELL,Oracle Warehouse Builder, TOAD, COOL Gen, Visio,Linux,CA-ERwin,INFORMIX 5/7/9 SQL/ESQL/4GL,MS-Windows,C++,SYBASE / MS SQL Server

PROFESSIONAL EXPERIENCE

Database Architect/Oracle DBA

Confidential, Reston, VA

• Provided Architectural assessment and roadmap to migrate the current IBM (z/OS) Cobol based VSAM database to Oracle/Unix environment. Presented FCG management withdatabase solutions and pros/cons alternatives Analyzed the AS-IS flat file mainframe structures and modeled the TO-BE normalizedtransactional data model via ERWin data modeling tool
• Utilized Oracle Warehouse Builder (OWB) To Extract, Transfer/cleanse and Load legacydata into new Oracle data environment. Developed database schema and scripts to meet development team requirements in an agilesoftware development.
•  Installed OWB and Oracle 12c /11g RDBMS engines to configure ETL environment andmigrate data from mainframe to Oracle.
•  Assessed and designed the initial BI architecture of Fairfax County Public School (FCPS)data warehouse (star schema). The new architecture utilized Oracle/Linux and IBMCognos BI tool to provide data hosting, ETL and reporting services.
•  Advised county management and stakeholders on Oracle best practices to incorporatedatabase strategy, standards, optimization, backup, and Disaster Recovery procedures.
•  Reviewed FCG’s transitions and all production SQLs and performed production query andanalysis to enhance performance and meet FCG SLA requirements.
•  Provided DBA and SQL know-how and optimization expertise to the development and testteams.

Database Architect/Oracle DBA

• Provide architectural solutions to the US-VISIT modernization efforts in areas such asperformance, backup, image storage (BLOB), and reporting to meet various clients ServiceLevel Agreements (SLA).
•  Implemented and advised US-VISIT management, stakeholders, and customers toincorporate database strategy, standards, optimization, backup, and Disaster Recoveryprocedures.
•  Perform periodic production top query and index analysis and customized statistics andgathering as deemed necessary to meet workflow SLA
•  Reverse engineering of US-VISIT/IDENT database and maintenance of physical and logicaldata model in the SBA’s ERwin modeling tool.
•  Analyze and assess current and new database requirements from modeling and DBAperspective and provide management with database solutions and alternatives.
•  Incorporate Oracle table partitioning and SecureFile storage to improve maintenance andSQL performance of our VLDB imaging system.
•  Develop, test, and support Oracle Advanced Queuing (AQ) implementation of MessageOriented Middleware technology (Enterprise and Local BUS).
•  Provide Oracle DBA assessment, planning, and technical support to the development, test,and production teams.
•  Design reporting datamarts and develop customized reports in Oracle Pro*C and PL-SQL.
•  Plan and develop data replication (Materialized Views), data migration mapping, and ETLscripts to support reporting and analytical applications.
•  Collaborate closely with integrated project teams and Change, Configuration, and ReleaseManagement (CCRM) teams to develop, test, and document production database releases.
•  Update and maintain database baseline scripts in CVS and Version Manager (VM)Configuration Management tools.
•  Install and configure Oracle 11g/10g/9i/8i RDBMS engines, clients, and tools on UNIX andWindows environments.
•  Provide SQL know-how and optimization expertise to the development and test teams.

Lead Database Analyst/DBA

Confidential, Falls Church, VA

•  Analyzed the FFEL legacy data model and business rules.
•  Reverse engineered the FFEL IDMS database schema to Oracle9i via CA-ERwin DataModeler.
•  Created staging and mapping databases to facilitate the legacy (non-relational) database migration to Oracle normalized model.
•  Merged multiple Oracle schemas into one common centralized database sharing the common information and avoid replication or duplication of data.
•  Installed and configured Oracle 9i RDBMS and tools.
•  Performed day to day DBA activities such as adding users, providing backup and restoring, and conducted performance monitoring.
•  Provided Oracle DBA and SQL technical support to development and test teams.
•  Designed and developed ETL scripts in PL-SQL and TOAD.

Senior Database Analyst/DBA

Confidential, Reston, VA,

• Provided technical and customer support to the IRS management and stakeholder teamsensuring identified problems were tracked and resolved timely with the vendors and DSSB’s internal customers.
• Successfully developed, organized, and implemented migration of Informix and Oracle legacy systems to DSSB consolidated environment.
• Conducted assessment and review of database objects and scripts and provided insight that enhanced the quality database code where necessary.
• Provided technical expertise and leadership to IRS projects such as TAPS, ALERTS, TELEFILE, ACES, and EPS to ensure performance and scalability of IRS databases perations.
• Effectively served as the DSSB project manager for TAPS and EPS projects, ensuring efforts were completed on schedule and budget. Successfully conducted application Infrastructure Migration Tests (IMT) and generated the required reports as required by the IMT process.
• Installed and configured Oracle 8i, 9i, and Informix in IRS development, test, and production environments running under Solaris 2.6/2.8 on SUN E10K/F15K platforms.
• Successfully migrated and upgraded multiple IRS Oracle 8i (8.1.6.x and 8.1.7.4) databases to the 9i version in the development and production environments with a constrained timeframe, meeting client’s key deadlines and satisfaction.
• Created procedures and documented transmittals to install, migrate, and upgrade IRSOracle databases.
• Enforced and maintained database constraints to ensure integrity of the database.
• Collaborated closely with system administration staff to coordinate and implement software installation practices.
• Effectively conducted ongoing monitoring and tuning of the database instances.
• Planed and implemented backup and recovery of the database.
• Successfully planned and implemented database security policies. 
• Enforced enterprise-wide Oracle and Informix standards to ensure application design
• Effectively conducted review and assessment of the design and code to ensure and code are produced with proper integrity, security, and performance.adherence to the site standards.
• Administered database objects such as tables, clusters, indexes, views, sequences,packages and procedures.
• Create new database users, roles, and profiles as required by the applications.
• Utilized Oracle database Import/Export utility to backup and restore databases.
• Performed online (hot) and offline (cold) backup of various databases at IRS.
• Provided Oracle/Informix DBA and SQL technical support to application development
• Installed and configured MapInfo SpatialWare DataBlade Modules 4.0 in conjunction with Informix Dynamic Server 2000.
• Automated DBA tasks such as database backup and baseline creation utilizing k-shellscripting.
• Provided technical support to the development, test and CM teams.
• Conducted impact and physical database analysis.
• Performed database configuration, optimization and security, data migration and integrity, storage capacity planning, database backup and recovery, query optimization, technical support.
• Provided Unix administration, volume/disk management (raw/cooked volumes configuration), Unix tools, and applications installation such as Informix database and tools, compilers, print server and drivers.
• Performed key activities on the network-based system, LAWNET, by conducting logicalmodeling, physical database design, and development of the software application. The
• LAWNET System is utilized by law enforcement officers in the U.S. Bureau of Land
• Management (BLM) to collect and submit crime incident reports created on officers' laptop computers. LAWNET central server is an IBM RS6000 utilizing AIX/UNIX Operating System and INFORMIX 7.x.
• Other responsibilities included database administration, imposing data constraints using stored procedures and triggers, assisting team members in their design and

 Senior Database Analyst

Consultant, Chantilly, VA

• Performed DBA tasks such as: database backup and restoring, trouble shooting and recovering, granting and revoking privileges, monitoring performance and fine tuning.
• Created forms and reports utilizing INFORMIX RDBMS tools.
• Provided technical assistance to the members of development team.

 Database Analyst

Consultant, Reston VA

• Analyzed user and system requirements.
• Designed the EFMP Logical and Physical Data Model using ERwin CASE tool.
• Developed Database Specification documentation based on Army's documentation standards.

Database Consultant

Confidential, Washington, D.C.

• Utilized SilverRun CASE tool to design, develop and maintain physical database models.
• Analyzed requirements for physical implementation, security and integrity of database schema.
• Planed and documented database migrations and contingency strategies.
• Prepared and executed database recast/rebuild via SQL and UNIX scripts.
• Provided technical support to the application development team.

Database Administrator

Consultant, Reston, VA

• Designed, coded, tested, and installed database objects such as stored procedures, rules andtriggers.
• Programmed and implemented data migration tools for data transfer between servers.
• Performed query optimization, logic review and debugging of database codes.
• Analyzed SQL Server space requirement for database objects.

Database Administrator Lead (DBA)

Confidential , Vienna, VA

• Directed all database related and standard DBA activities of T&I team.
• Managed and coordinated DBA and System Administration Tasks.
• Administered RCAS computer performance evaluation using PERFORMIX Remote X Terminal Emulator . PERFORMIX RTE is a performance benchmarking tool for X Window- based computer systems.
• Developed Embedded SQL/C parsing routine for data mapping purposes and SQL query performance evaluation.
• Created SQL/C programs to obtain before and after snapshot of database during application testing.
• Designed, coded and implement many tools and reports utilizing INFORMIX SQL, Embedded SQL/C and 4GL.
• Guided and cross trained the T&I personnel to fulfill their database needs and tasks.