Senior Database Architect Resume Profile
OBJECTIVE
To obtain a full time clearance required permanent senior system engineering, integration, or architect position in which to use my extensive database, software, and systems experience to the advantage of your organization's continued success.
SKILLS
Active US government Top Secret / SCI security clearance.
- Current CI Polygraph.
- Database and data warehouse design and implementation.
- Systems hardware and software architecture, analysis, design, management, and integration.
- Systems and database administration.
EXPERIENCE
Systems and Data Integration Engineer
Confidential
- Worked with a team of Analysts and Engineers to support data analytics and large data processing, for a large US government customer.
- Worked with a team of four engineers to support multiple servers, using a variety of OS and application software, on Virtual machines, hosted on VM Ware, at multiple remote locations.
- Installed and configured Red Hat Enterprise Linux RHEL , CentOS, Windows Server 2008 R2, and Windows server 2012 R2 to support multiple Cots, Gots, and custom software applications for data sharing and analysis.
- Performed Linux performance tuning, resource allocation, and management.
- Worked with Bourne Again Shell Bash to create shell scripts used to automate data exchange and data processing on RHEL/CentOS.
- SSH and SFTP were used to transfer data securely over the WAN. PKI was used for authentication.
- Installed and configured MS SQL Server 2008 R2, and 2012 to support database instances that functioned as part of the distributed application instance.
- MS SQL Server database administration including RDBMS installation, configuration database design and implementation, backup, restore, migration, object scripts, ER diagrams, normalization, stored procedures, functions, and triggers.
- Used MS SQL Server Management Studio to create SQL queries, views, DDL, and DML statements
- Modified and updated custom application in SQL Server to route data between agencies.
- Worked with XML documents used to transfer data over the WAN.
- Worked with XPath, XQuerry, and XSLT to manipulate XML, extract, and transform data.
- Emulated threading and parallel processing using only MS SQL Server stored procedures. This process employs SQL Agent jobs, polling, and interprocess communication to speed up a single query by approximately 600 , while preserving the original hardware, operating system, and application software platform.
Software Systems and Database Engineer
Confidential
- Worked with a team of Analysts and Engineers to support the Altiris IT Management Suite, and Symantec Workflow Solution development, for a large US government customer.
- Installed and configured the Altiris Management Suite of servers including: VMware Workstation 8 - 9, Windows Server 2008 R2, Domain Controller, DNS, Exchange, MailEnable 7.0, MS SQL Server 2008 R2 SP2, Symantec SMP Server 7.1 SP2, Workflow Server 7.1 SP2 7.5, and Service Desk Server 7.1 SP2 7.5.1.
- Worked with a team of three Workflow Engineers to develop a large custom software application using Symantec Workflow Solution 7.1 SP2 7.5 to support System Access Requests for a large government customer. Two developers worked remotely. The system was hosted on VMware ESX server 4.0.
- Used the Workflow development environment to create Workflow Dialog, Web Application, Web Form, Web Service, and Integration Library projects.
- Developed custom Workflow components using the Workflow API with Visual Studio 2012 in C .
- Developed custom Object Relational Mapping ORM code with Visual Studio 2012 in C to support custom Workflow data types and database relationships.
- MS SQL Server database administration including RDBMS installation, configuration database design and implementation, backup, restore, migration, object scripts, ER diagrams, normalization, stored procedures, functions, and triggers.
- Used MS SQL Server Management Studio to create SQL queries, views, DDL, and DML statements.
- Used Business Intelligence Management Studio BIDS to interface with other database instances, and MS Excel Spreadsheets.
Confidential
Database / Software Engineer
- Chief Data Architect and Applications Architect for the design, development and improvement of a web-based database application using Oracle 8-11g, MS SQL Server 2000-2008, MySQL and Access, Eclipse Indigo v3.7 and Java EE 1.5-1.7 to design an extensive SQL database to catalog a major museum collection.
- Java Web services were created using Jersey, Axis2, and Apache CXF on Linux and Windows for RESTful and WSDL based services. Apache ANT and Maven. Services hosted on Apache Tomcat and JBOSS AS.
- JavaGUI development using JDK 1.7, and Eclipse Indigo, with WindowBuilder plug-in, PuTTy for port tunneling, Batik plug-ins for Scalable Vector Graphics, Inkscape for SVG editing, and Cygwin for the Windows X server environment. This design was extensively XML data driven.
- Supported Virtual Private Network using Public Key encryption.
- Supported Windows XP and Red Hat Enterprise Linux as the delivery platforms.
- C was used to interface with unmanaged code and Windows API. Visual Studio.NET was used with C .NET for some web interfaces.
- Reviewed Access database designs to prepare transition to SQL database. ETL Third party and custom built tools were used to transfer data from the existing Access databases to Oracle and MySQL instances.
- Wrote extensive SQL adhoc queries to support reporting and data migration.
- Software architecture support using Windows 98/2000/XP/Vista/Windows 7, UNIX Solaris and Red Hat Enterprise Linux RHEL , Oracle 8 -11g, and MS SQL server 2000 - 2008.
Systems Architecture Integration Engineer
Confidential
Worked with a team of engineers to support the Distributed Common Ground Station DCGS Bulk Release 10B. Supported the Critical Design Review CDR and tracked CDR action items. Investigated and resolved system design problems including: overall system performance, enterprise integration issues, and COTS/ GOTS software product issues. Served as lead for two task orders supporting sub-contractors from other companies.
The activities of this position included:
- Supporting the Enterprise Portal EP , the Enterprise Management Cell EMC , the Mission Enclave Management Cell MEMC , the Mission Enclave Application Cell MEAC , and the Containerized Clustered Virtual Environments CCVs .
- Migration of systems design and implementation towards a more open architecture environment.
- Supporting Sun T2/T3/T4 hardware architecture platforms using Solaris 10 with zones, database systems using Oracle 11g, and X86 hardware platforms using Windows Server 2008 R2.
- Resolved NFS mounting schemes issues using different NFS and Server fully qualified domain names.
- Supported DNS domains to supply name resolution for the enterprise.
- Supported Host based Security System HBSS and with LDAP authentication using IAAS.
- This position was eliminated due to a contract related change in project funding.
Senior Programmer Analyst Principal with confidential Worked with a team of engineers to provide enterprise hardware, software, and O M support for Windows 2000 and Windows XP workstations. Developed software applications used to monitor system performance, generate automated alarms, and automate the configuration of workstations to interface with desktop applications via a SharePoint MOSS 2007 portal interface. Supported a customized proprietary records management system build in HighView SDK 4.1
The activities of this position included:
- Using Windows Script Host Object Model WSH and VBScript VBS to create scripts that would directly edit the system registry to set the required Internet Explorer 6.0 user permissions.
- Using custom developed alarms to report on blocking locks detected using a custom built SQL query running on Oracle 10.2.0.1 via an ODBC connection using ADO with VBScript, TOAD 7.6, and Ultra-Edit32 10.0.
- Implementing coding standards, code development, reusable software libraries, and management best practices.
- Supporting Solaris 9, Windows Server 2003 R2, and Oracle 10g 10.2.0.1.
- Providing direct support to end users. Worked with several trouble ticket reporting systems.
- Working with a team of developers and system support personnel to manage trouble tickets generated by users.
- Providing SAN design support.
- Supported the migration from Windows 2000 to Windows XP for developers, and the VS .NET development environment.
Senior Database Architect
Confidential
Developed technical requirements, performed object oriented analysis and design, validation, and implementation of windows based and web based applications. Analyzed, designed and tested network and server architectures to support multiple proposed thin client solutions. Supported the Distributed Common Ground Station - Special Operations Forces DCGS-SOF Program Team. Developed metadata schema and resolved cross-platform integration issues. Responsible for selecting, purchasing, installing, testing, and evaluating, both Hardware and Software COTS / GOTS .
Performed heterogeneous platform and architecture development, and systems integration. Mentored and coached less experienced team members.
The activities of this position included:
- Using HTML, Classic ASP, and ASP.NET 1.1-2.0-3.5, AJAX, VB, C , and VS .NET 2003 2008.
- Using Microsoft SQL Server 2000 - 2008, MS SQL Server Integration Services SSIS , MS SQL Server Reporting Services SSRS ,
- Developing T-SQL stored procedures, functions, and web services.
- Reviewing and extending the ER design of SQL database instances, including data warehousing and datamarts.
- Supporting the development of portal technologies using Microsoft SharePoint 2007.
- Creating applications to provide access to DOD approved Active Directory extended attributes on Windows Server 2003.
- Simulating simultaneous multiple client loading on thin client architectures under test conditions using VBScript and VMware 3.5.
- Providing tier three support to resolve CA Unicenter trouble tickets.
- Supporting Solaris 10, Linux, and Microsoft Windows XP based systems.
- Using Java, Oracle Web Logic, Oracle 10.2g, OpenMap, and the Multi-Media Analyst and Archive System MAAS .
- Supporting the DCGS Integration Backbone DIB using SOA architecture and XML web services.
Database / Systems Administrator and Software / Systems Engineer
Confidential
- Worked with a team of engineers to support Ballistic Missile Defense C2BMC at the Joint national Integration center JNIC , located at Schriever AFB. Many duties were performed while supporting this project:
- Database Administration using Oracle 8i-9i-10g / MS SQL Server 2000 / Oracle PL/SQL stored procedures, Oracle packages, and MS T-SQL. Designed and implemented Oracle 8i-9i-10g databases. Ongoing database performance monitoring, and tuning. SQL query design, development, and support.
- Used TOAD 7.x-8.x, Oracle Enterprise Manager, and Grid Control 10.1.0.3 for Oracle database support.
- Used MS SQL 2000 Enterprise Manager and SQL Query Analyzer for MS SQL Server 2000 support.
- Used Perl 5 and Bourne shell scripts to automate Oracle database startup/shutdown, and backups.
- Performed database migration, restoration, and ported databases to new platforms.
- Systems Administration using UNIX and Windows 2000/XP for servers and workstations. Solaris and IRIX support provided. Hardware used included Sun Ultra-60, E420, 480, V880, SunBlade2000, and SUN 3510 FC StorEdge array, and various SGI platforms.
- ClearCase Administration using version 2002.05 Multisite on Solaris 8 / 280R platform with integration to ClearQuest. Worked with ClearCase clients on Windows 2000 platform. Supported the Rational Unified Process UCM .
- Data Warehouse/Datamart Engineering and support including ETL activities and implementation using J2SE 1.4.2 09 with NetBeans 4.1, PL/SQL stored procedures, and Perl 5 on Solaris 9 and Windows XP using Oracle 10g clients and server. IA compliance issues were addressed and resolved.
- Software Engineering and support using VB.NET 2003 Enterprise edition. Created application for Asset configuration management. Used MS SQL server 2000 to develop and implement database backend.
- Systems Architecture Integration Engineering. Designed and implemented a Storage Area Network SAN solution using hardware from multiple vendors. Performed Systems / Network Engineering, Systems Administration, and Project Management tasks in this effort. Performed engineering analysis for replacement and upgrading of existing computer and networking equipment including equipment specifications and cost-benefit analysis to meet acquisition objectives.
Consultant
Database/Software Engineer
Confidential
Worked alone and with other engineers to support a variety of projects. Provided system software and hardware architecture support and integration. Performed database design and development, including implementing ETL processes and procedures. Ongoing training in RDBMS concepts. Supported PeopleSoft ERP upgrade for HR and Payroll.
The activities of these positions included:
- Creating and modifying Custom PeopleSoft SQR's.
- Using Perl V 5.005 and Excel Macros to perform data transformations and Excel reports.
- Working with PeopleSoft ERP 7.02 - 8.3 upgrade for HR and Payroll.
- Performing ETL from Informix V. 7.31 on HP-UX B.11.00 to DB2 on MVS OS/390 using various Informix dbexport, dbschema, dbaccess , compression, ASCII-EBCDIC conversion, and DB2 DB2 Load tools.
- Supporting AIX and on Windows.
- Using PeopleTools 8.14 to work with PeopleSoft Objects such as Records, Fields, Pages, etc.
- Working with PeopleSoft in two-tier, three-tier, and Web-based modes.
- Performing Oracle 8i/9i database ER design, development, SQL custom queries, and documentation.
- Creating and maintaining PL/SQL stored procedures, triggers, forms and reports.
- Supporting UNIX Solaris 10 and AIX , Windows 98/2000/XP, Windows Advanced Server 2000, and MS SQL Server 2000.
- Working with VB, VB script, classic ASP, ASP.NET, DHTML, XML, Java Script and Apache Web Server.
Software Developer
Confidential
Worked with a team of engineers to support a variety of projects. Created a Web based commissions tracking tool. Automated a complex manual process. The automation of this manual process took the place of three FTE positions. Created, and performed maintenance, and data import for a datamart for telephone records auditing purposes. Implemented an ETL system to gather information from one Sybase 11 database and three Oracle 8.16 instances to reconcile Primary Interexchange Carrier Charges PICC .
The activities of this position included:
- Using SQL Server 7.0 to design and implement a 27 table relational database.
- Used Visual Interdev 6.0, Active Server Pages, IE 5.5, and T-SQL Stored procedures.
- Used Perl 5.600, the Tk kit for Perl, and ACR Detail Unitech Corporation to automate a manual process.
- Using Powermart Informatica 4.7, Embarcadero Rapid Sql 5.7, Sql Navigator 3.2.
- Using Oracle Developer 2000 for NT, Oracle 8.16 Client and stored procedures , and Brio Query Designer 6.2.2 a web-based reporting tool
- Worked with Web Focus to review its potential as an OLAP tool.
- Supported the data warehouse and Operational Data Store.
- Over 10 million dollars in revenue identified for recovery.
Software Developer
Confidential
Worked with a team of engineers to develop and implement a web-based telephone records and expense tracking tool.
The activities of this position included:
- Using Java Forte for Java, Visual Caf , Java Script, VB Script, Visual Interdev 6.0, and Active Server Pages.
- Using IE 5.0 and Netscape 4.7.
- Using Visual Basic 6.0 to develop and implement COM objects on Microsoft Transaction Server.
- Using Visual Basic 6.0, SQL Server 7.0, Active X Data Objects, and Microsoft Access 8.0.
- Implementing changes to an existing desktop database application and update tool.
Architecture Analyst, Systems Integrator
Confidential
Worked with a team of engineers to provide software and hardware architecture analysis for a web based development effort for the United States Postal Service. VeriSign certificates were used to implement SSL. An Oracle 8.x database was installed and configured. Produced documented analysis of the current application architecture and provided recommendations for improvements.
The activities of this position included:
- Using Solaris 7.0 2.7
- Performing software and hardware systems administration.
- Supporting Sun Enterprise 3000 Server,
- Using Solaris for ISP 2.0, Sun Web Server SWS 2.1, HTTP, and HTTPS.
- Using Secure Socket Layer SSL , Java 1.1-1.2, Sun Hot Java browser, and Netscape 4.05.
- Using Windows 95/NT 4.0, Microsoft Internet Information Server IIS , and Microsoft Sql Server 6.5.
- Using Microsoft Internet Explorer 4.0, Visual basic 5.0, DCOM, and Microsoft Message Queue.
Volunteer work Electronics Engineer with amateur radio clubs including disaster response and antique radio clubs. January 1969 to present .
Working alone and with other EMS support personnel I designed, built, repaired and restored antique and amateur radio equipment including receivers, transmitters, and antenna systems. Extensive training in crisis response and planning.
Participated in EMS support and activities.
The activities of this position included:
- Utilizing extensive experience with antenna design, electromagnetic wave propagation, communications and electronics principles and technology.
- Working with antique and modern ground terminals and satellite and computer radio technologies.
- Utilized HAM radio Amateur Extra license.
- Worked in radio and color television repair.
TECHNICAL EXPERIENCE/SKILLS DETAILS:
- Languages: Altiris Workflow 7.1 SP2 7.5, JAVA 1.1-1.5, J2SE 1.4.2 09, J2EE, Java Script, C, C C , VB .NET 2003-2012 Enterprise Edition Visual Basic for Windows Professional/Enterprise Edition 3.0-6.0 Active X Components and Controls, Active Server Pages, ActiveX Data Objects, Data Access Objects 3.5, Remote Data Objects 2.0, COM, DCOM, OLE Automation , Microsoft Visual C 5.0-6.0, Microsoft C 6.0, PeopleSoft 7.02-8.3 / SQR / PeopleTools, UNIX Shells: Bourne, C, K, T, Bash, Perl 4.0-5.8, DHTML, HTML, XML, XPATH, XSD, XSLT, SOAP, WSDL, BPEL, SOA, Web Focus, Java Script, VB script, Visual Basic for Applications, Ada, FORTRAN 77, MUMPS, Basic, Assembler, PL/1, MVS JCL.
- Operating Systems: Windows 3.1/3.11/95/98/NT/2000/XP/VISTA/7, Windows NT 3.5.1-4.0 Windows Server 2000-2008 R2 SP1, AIX 4.1.4 HP-UX B.11.00, Solaris 1.1.1-2.4, 8-9-10 SunOS 4.1.1-4.1.4 IRIX 4.0-6.5.6, OS/2 2.0-2.11 DOS 3.3-6.22 MVS: OS/390, TSO/ISPF, RJE, JCL, IMS AT T System V 3.5.1, DEC ULTRIX VAX/VMS 5.5, OSF1 3.2-4.2 Mac OS 8.0, Linux SUSE, Slackware , Red Hat Enterprise Linux RHEL 5.3-5.4., CentOS, Fedora
- Hardware: IBM / PC Compatibles and Notebooks: ISA, EISA, PCI, PCIe, PCMCIA, SCSI Peripherals Sun X86 / Sparc: SLC, IPC, IPX, Classic, LX, Ultra, 2, 5, 10, 20, 60, 80 Sun Server 4/330, 1000, 2000, Sun Enterprise 3000, Sun E420, 480 V880, 3510 FC StorEdge array, V210, V240, V440, Blade 150 and 1500, and Sun peripherals Silicon Graphics Indigo, Indy, Indigo2, O2, Octane, Origin 200 and 2000 Other: IBM 3090 Mainframe DEC VAXCLUSTER DEC ALPHA Macintosh, Routers, Switches, Firewalls, Print servers.
- Software, Tools, and Utilities: MS Exchange, MailEnable 7.0, Visual Studio .NET 2003 - 2012, Rational Rose 2002 and UML, ClearCase Server Multisite 2002.05, ClearCase Client 2002.05 for Windows 2000, Clear Quest, PeopleSoft 7.02-8.3, PeopleTools 8.14, SQR, Forte for Java, NetBeans 4.1, Visual Caf , Visual Studio 6.0, Visual Interdev 6.0, Common Gateway Interface CGI , Netscape Navigator 2.0-4.7, Microsoft Internet Explorer 3.02 - 10.0, Apache Web Server, Microsoft Internet Information Server IIS , Microsoft Visual SourceSafe 4.0-6.0a, Sun Web Server SWS 2.1, Solaris for ISP 2.0, Network Time Protocol NTP , Robo Help 4.0, Crystal Reports 4.0-7.0, Rumba for NetWare 3.1-3.2, Rumba APPC 3.2-4.0, Rumba Office 1.0, Rumba Tools for Visual Basic 1.0-2.0, McAfee Anti-Virus 1.14-2.27, Norton Utilities 5.0-9.0, Symantec / Norton Anti-virus, Pro/Engineer 11.0 CAD package , ProComm Plus 2.0-3.0, Reflections for Windows 4.0, Smarterm 240 Microsoft Excel 4.0-2000 for Windows, Microsoft Office Professional Edition 4.2-2007 for Windows 95/98/NT/2000/XP. IEF Toolset 5.0 For Microfocus Cobol , WhatsUp Gold, Remedy Trouble Ticketing System, Multitier systems implementation, E-mail services, Domain Name Service DNS , Network Information Service NIS, NIS , Network File System NFS , File Transfer Protocol FTP , Remote Access Service RAS , DHCP, LDAP, Active Directory.
- Databases and tools: TOAD Tools for Oracle Application Developers 7.x-9.x, JDBC, ODBC, Oracle Enterprise Manager 8i-9i-11g, MS SQL server RDBMS 2000-2008R2SP2, SQL Server Management Studio, SQL Server Business Intelligence Management Studio BIDS / SQL Query Analyzer, Integration Services, Reporting Services, PeopleSoft 7.02-8.3, PeopleTools 8.14, SQR, Informix V 7.31 on HP-UX B.11.00, DB2 on MVS OS/390, Oracle Forms 6i and Reports 6i, Oracle Developer 2000 for NT, Oracle 7.0-8.16-8i-11g Database, Client, SQL, PL/SQL, and SQL Plus , Microsoft Access 2.0-2007, Microsoft SQL Server 6.5-7.0-2008R2, T-SQL and SQL server toolset ISQL stored procedures, functions, and triggers, Sybase 11 Database, Client , DB2 via Sybase Gateway, Powermart Informatica 4.7, Embarcadero Rapid SQL 5.7, SQL Navigator 3.2, DB2 / SQL, VAX RDB.
- Networks: HTTP, HTTPS, SSL FTP, NTP, TCP/IPV4, DHCP, IPX/SPX, NetWare 3.1.2 server -4.10 client , NetWare for SAA 1.3 server SNA / SDLC 3270, lu 2.0-6.2. DECNET/Pathworks 4.0 Sockets, LAN / WAN.