Experience

Boeing Intelligence & Analytics

• United States
• Defense and Space Manufacturing
• 300 - 400 Employee

• Database Architect

  • Apr 2019 - Present

  As Database Architect, coordinated database architectural changes with team members; Assisted in troubleshooting and resolving database performance issues; Designed and implemented a data bulk transfer function to move data from one schema and/or database to another; Designed and developed a data bulk loading package to insert information into the database en mass; Mapped application objects into database objects and methods utilizing Oracle’s Object-oriented database capabilities; Migrated the database schema from Oracle12c to PostgreSQL 11.5, mapping Oracle objects and data types to their equivalent PostgreSQL objects and data types; Migrated and transferred data from the Oracle12c database to the PostgreSQL database; Assisted other teammates with the design and implementation of the team’s application database; SSL-enabled the databases so that the databases can be accessed in a more secure manner; Assisted in the design and development of a prototype to demonstrate the replication and failover capabilities available with PostgreSQL. Also provided support to task technical lead, assisting to keep the task objectives and measures on-target. Brought to the attention of task technical lead any risks that might negatively impact task performance; Worked with task technical lead to define, prioritize, and schedule realistic, attainable goals and commitments; Responded to data calls in support of proposals and other projects, as well as responded to marketing/company surveys; Provided a technical review of plans and designs, providing as feedback to the author a set of technical comments that improved the clarity and correctness of the documents/designs; Collaborated with other database team members to identify and resolve technical and functional database issues in areas such as replication, failover, design, and performance. Show less

• Senior Database Administrator

  • Apr 2015 - Apr 2019

  As Lead Database Administrator of the Database team, managed and supervised the activities of several Database Administrators, and provided operational database administration support to the organization through partnering with architects, developers, and support personnel. Primary responsibilities included: Database administration and maintenance; identifying, tracking, and resolving database-related incidents; fulfilling requests and resolving incidents within the scope of the applicable service level agreements (SLAs); ensuring backups are performed regularly; maintenance, upkeep and security of the databases; responding to database related alerts and escalations; working with architects, project application engineers, and other database engineers to come up with strategic solutions to recurring problems; providing Tier 2 support to operational systems and is on call to provide support after regular working hours; and providing operational and user support to members of the user community. Applicable technologies include: Oracle v12, including Oracle GoldenGate, Oracle Streams, and RMAN; Oracle database auditing using both Traditional and Unified Auditing; backups, restores, and recovery models; native tools for importing, exporting, and loading data into the database; clustering, mirroring, replication, and failover; High Availability and Disaster Recovery options; indexing and index management techniques; partitioning and partition management techniques; native tools for gathering and evaluating database statistics; Structured Query Language (SQL*Plus); distributed computing architecture; virtualized machines and databases hosting thereon; native tools used for troubleshooting and resolving database problems; native tools used for database performance tuning and optimization. Show less



General Dynamics Mission Systems

• United States
• Defense and Space Manufacturing
• 700 & Above Employee

• Database Engineer

  • Jul 2002 - Apr 2015

  Provide database and programming support to the project team. Responsible for designing, developing, implementing, and maintaining Sybase database solutions to support the requirements of the team. Implements database procedures and functions using a combination of shell scripts, Transact-SQL (T-SQL), and ISQL. Maintains database backup and recovery procedures implemented using Sybase’s Bulk Copy (BCP) utility. Prepares daily and weekly reports conveying the status and performance of system components. Also provides guidance and assistance to project developers and managers concerning the application of database technologies, as well as with the resolution of database-related problems. Responsible for designing, developing, implementing, and maintaining Oracle11g database solutions to support the requirements of the enterprise. Performed database monitoring and tuning activities to ensure databases and related applications were performing within expected parameters. Implemented database procedures and functions using a combination of shell scripts, PL/SQL, and SQL*Plus. Maintained database backup and recovery procedures implemented using Oracle’s Recovery Manager (RMAN) and Data Pump utilities. Show less



CSC

• United States
• Information Technology & Services
• 700 & Above Employee

• Computer Scientist

  • Sep 1983 - Jul 2002

  Recommended technical solutions to database problems. Supported business efforts preparing technical solutions in response to proposals. Designed and implemented database systems. Maintained data models using Oracle Designer CASE tool. Performance tuned databases. Prioritized database tasks to ensure adequate support was provided to each system. Provided database administration and programming support to multiple systems. Monitored database performance. Served as database administrator for the CSC NASA missions in support of Landsat 7 and Hubble Space Telescope. Other technical responsibilities included the design and implementation of application programs in C. Designed and implemented a Defect Causal Analysis tool in Oracle and MS Access that correlates problem reports and identifies trends and systemic problems. Nominated for CSC Civil Group President’s Excellence award, in the area of process improvement, in recognition of this effort. As task leader, supervised and participated in the analysis, design, and development of a PC-based civil engineering contingency planning tool. Responsible for preparing task plans, assigning personnel to work units, and integrating all task activities. Performed requirements analysis and definition activities requiring close interaction with the client and user community. Designed and implemented the database using Oracle, as well as the database maintenance and reporting modules using SQL*Forms, SQL*Plus, and SQL*ReportWriter. Provided technical and functional support in design and implementation of the Ada requirements generation and analysis modules. As task leader, supervised personnel responsible for the maintenance and enhancement of the the predecessor of the system under development. This predecessor system is a batch-oriented system operated on the Honeywell DPS-8 and was programmed in COBOL and FORTRAN. Also provided technical support to the user community in the areas of problem resolution and system operation. Show less



United States Department of Defense

• United States
• Armed Forces
• 700 & Above Employee

• Software Engineer (Co-op position)

  • Jun 1981 - Aug 1983

  In support of the J-4 user area, responsible for designing, documenting, installing, and maintaining an automated airfield facilities information retrieval system. In support of the J-4 user area, responsible for designing, documenting, installing, and maintaining an automated airfield facilities information retrieval system.