Tampa, Florida, United States
Active Security Clearance An innovative and analytical information technologist, with a demonstrated track record of achievement in database administration, data warehousing, application development, web server development, programming, system upgrades, back-end architecture, user interface development, data quality and testing, and backup and disaster recovery. Excels at developing, revising, and maintaining applications and procedures to increase efficiency and reduce load times. A proven aptitude for mitigating downtime and enhancing each user’s experience.
Database Administrator ● Serving as a Database Administrator (DBA) for over 50+ instances of SQL Server and Oracle RDBMS. ● Implemented AAG clusters with read only secondaries to offload reporting burden. ● Created redundant DR solution using Azure based blob storage container backup process. ● Managed SSRS reporting for multiple applications. ● Implemented a standardized set of maintenance tasks and upkeep procedures for all instances. ● Created an automated process to map databases to applications and owners. ● Created extensive documentation for all repeatable administrative procedures. ● Wrote batch processes to generate reports that reduced the burden on dept staff. ● Implemented SQL Enterprise Ed. on Azure VM’s in support of Delek 8 application upgrade. ● Created MS Graph integrations for Outlook Calendar and SharePoint. ● Migrated ASP Forms based web site to Blazor Web Assembly.
Netezza Database Administrator for one of the largest non-governmental data warehouses in the world. • DBA for massive Netezza based consumer behavior tracking data warehouse. • Management of very large fact tables, some 5 to 10 terabytes in size. • Creation of Netezza stored procedures to improve daily/weekly maintenance processes. Creation of Netezza stored procedures to implement custom data federation processes. • Extensive use of ASP.NET to display Netezza system utilization information not well instrumented by IBM. • Re-writing of SAS based dimension table loading (traditional “ETL” model) over to Netezza based direct load (“ELT”). Dimension rewrites resulting in load times being reduced from hours to minutes. • Extensive use of Korn shell scripts and SAS scripting to perform nightly and weekly batch loads. • Administrator for Autosys job scheduling environment with upwards of 50,000 individual production job steps. • Wrote an ASP.NET based interface for Autosys allowing users a simplified read only view of the entire Autosys environment. • Worked as part of a data quality team, testing the unified next gen warehouse schema against previous and new data sources.
• Production DBA for 6 Oracle v9.2 servers. • Production DBA for 5 SQL 2005 servers. • Developed and maintain an ASP.NET application that allows agents to track offline activity time. This app made heavy use of Ajax extensions (Update Panels, server side timers, etc), function callbacks, stored procedures and all relevant DML in a SQL 2005 db. • Developed and maintain an ASP.NET application that allows agents to schedule customer callbacks by presenting them with a graphical representation of their own work schedule, which is queried in real time from the corporate data warehouse. • Developed and maintained a multi-tenant RMA database that integrates RMA requests generated via a call tracking system and end user/dealer web site with a shop floor control system via Websphere MQ. • Developed a VB.NET sockets based web server for the RMA process which accepts HTTP post requests marked up in XML, which then are inserted into Oracle using ADO.NET prepared statement calls. • In 2007 upgraded six production servers running 24 database instances to Oracle 9.2.0 from Oracle 8.x. All upgrades were performed off hours on weekends to mitigate user downtime. • In 2006 upgraded five production SQL 2000 servers to v2005.