SUMMARY

• Senior Database Administrator / Developer and accomplished IT professional with more than 20 years of experience in engineering database solutions from small applications, web commerce to large retailer backend systems with a focus on Oracle and SQL Server Database Administration and ETL development.
• Worked as a consultant or directly for local and federal agencies in government, financial, pharmaceutical/health care, education, and retail companies.
• Managed large scale migration projects. Supported various applications on Linux, AWS, Azure, Windows, AIX and HP - UX operating systems.
• Primary focus has been on the lifecycle of enterprise databases including installation, maintenance, performance, backup/restore, ETL operations and replication using Oracle and SQL Server suite of products.

TECHNICAL SKILLS

• SQL Server 2000/2005/2008/2008 R 2/2012/2014/2016 on Microsoft Win Server 2000/2003/2008/2012/2016
• Oracle 9i/10g/11g/12c on HP-UX B11.31, RHEL, AIX and Windows
• DB2 and Microsoft Access
• Experience with SSMS, SSRS, SSAS, SSDT/Visual Studio, SQL Server Developer, Microsoft Office, Profiler, Spotlight, SharePoint, SolarWinds, Crystal Reports, OEM Grid Control, Putty, DBArtisan, PerfMon, SQLCMD, WebSphere, KeePass, and Lawson Financials.
• Proficient in software development and installation, application support, and backup solutions including LiteSpeed, NetWorker, Avamar, Data Domain, RMAN, SAN replication, Flash, expdp/impdp, and ArcServe.
• T-SQL, PLSQL, SQL*Plus, VB6, .Net, VB Script, Cobol, PowerShell, SSIS/DTS, VI Editor & HPUX Shell Script

PROFESSIONAL EXPERIENCE

Confidential

SQL SERVER DBA / ETL Developer

Responsibilities:

• Provide 24x7 Oracle and SQL Server DBA services for City of Chicago agencies including CPD & RTA.
• Support current production with primary focus on building a new warehouse in 12c.
• Support ETL maintenance/debugging and develop ETLs using Oracle packages, procedures, triggers, jobs, and MSSQL SSIS packages for production applications.
• Administer access and provisioned services in Azure for web projects and analysis.
• Assisted with MSSQL data migration to INFOR Lawson system specifically tying out GL, PO and Contract Distributions accounts between systems.

Confidential

SQL SERVER DBA

Responsibilities:

• Provide 24x7 global SQL Server DBA services for various clients such as Providence Hospital, SPXFLOW, & FUJI.
• Architect, install, configure, optimize and manage enterprise-wide SQL Server 2000 to SQL Server 2016.
• Consolidate SQL environments reducing administrator management overhead and SQL licensing requirements.
• Setup and manage Windows and SQL Server clustering for Tier 1 applications to ensure high availability.
• Implement and manage SQL Server disaster recovery solutions using native and Quest LightSpeed SQL backup and log shipping. Test failovers twice per year. Perform point-in-time database restores as needed.
• Setup automation with SQL Agent and Database Mail for maintenance jobs errors and alerts.
• Provide Health Check of database environment ensuring backups/maintenance jobs are running properly.
• Create and maintain SQL Server knowledgebase in SharePoint including inventory of Instances/Databases, versions, backups and other maintenance jobs and schedules.
• Manage database design, development, installation, patches, upgrades/migrations, backup/restore, recovery procedures, configuration, data security, server administration, space management, and performance tuning.
• Migrate non-supported SQL Server instances such as SQL Server 2000 & 2005 to SQL Server 2012, 2014 & 2016 including DTS to SSIS package conversions.
• Maintained PCI & SOX compliance with SQL Server database procedures and policies.
• Direct support for Application Development group for implementation, debugging, tuning, and security.
• Provide debugging, query tuning, T-SQL scripts, stored procs & triggers. Purge and archive old data as needed.
• T-SQL development including administration scripts, auditing, reports and triggers to support BIDS environment.

Confidential

TECHNICAL PROJECT MANAGER

Responsibilities:

• Datacenter consolidation/relocation Tech PM for various clients in the Communications, Government, Financial, Education and Pharmaceutical/Health Care verticals.
• Provide critical project management services, coordinating start to finish project plans, timelines, milestones, and team activities to relocate groups of active datacenter servers, apps & databases, without impacting production.
• Organize and conduct site surveys of existing technical infrastructure, validate requirements and preparations.
• Conduct requirements and technology review meetings. Track and manage risks and issues. Lead strategy planning meetings. Facilitate discussions and leading regular status meetings.
• DBA consultant for planning and executing database migrations for SQL Server, DB2, Oracle/RAC, & PostgreSQL.

Confidential

SENIOR DATABASE ADMINISTRATOR

Responsibilities:

• Worked as a lead DBA for Oracle and SQL Server instances 24/7 on over 400TB of databases for large fuel retailer.
• Managed database design, development, installation, patches, upgrades/migrations, RMAN & datapump backup/restore, data security, space management, data partitioning/Archive, and performance tuning.
• Worked with IS Auditors to ensure PCI compliance with Oracle and SQL Server database procedures and policies.
• Direct support for Application Development group for implementation, debugging, tuning, and security.
• Assisted with VMWare, SRM, P2V, SAN Replication, and ArcServe configuration for databases.
• Implemented Database Monitoring using Spotlight for SQL Server and OEM Grid Control for Oracle.
• Built UNIX & PowerShell scripts to automate backups, monitor disk utilization, Oracle alert.log errors & .dmp files.
• Configured & managed SQL Server 2012 database environment on VMWare servers for new Retalix R10 POS used to integrate store data with home office systems including Internal Audit, Marketing, Payroll, and Fuel Accounting.
• Installed and configured Oracle & SQL Server client software for end users.
• Installed and configured SQL Server 2012 database for SharePoint; worked with server team to virtualize SharePoint farm and use VMware Site Recovery Manger (SRM) for failover solution.
• Developed and updated DTS & SQL Server Integration Service packages (SSIS).
• Aided in data transfers & implementation with several company mergers including Flying J and Maxum Petroleum.
• Assisted Server Team with coordination and logistics of database server migration to new Datacenter.
• Lead development, migration, and testing of database disaster recovery project; delivered solution that guaranteed recovery, high availability, and ensured each database server would fail over to remote location.

SENIOR PROGRAMMER ANALYST

Confidential

Responsibilities:

• Developed and maintained VB6 apps, VB.NET apps and VB Scripts along with database builds and designs.
• Integrated and supported third-party applications such as Lawson Financials, Magic Call Tracking software, Mobius Document Management System, WebSphere, and ACT Software.
• Programmed POS scanners for store pricing; created and maintained user accounts on 10,000 + user ‘Open VMS’ system and administered platter disk backups while working for Store Support Department.
• Mentored junior programmers on best practices, code standards, and SQL programming.
• Developed .NET application that allowed quicker purchase of fuel by providing data on daily market change, saving thousands of dollars. Contract purchases were now visible real time versus end of business day.
• Implemented Magic call tracking system & workflow for various departments; enabled increased service desk performance, manageability, organizational alignment, and increased accountability & visibility of IT support.
• Designed and developed in-house document management workflow using Mobius software, including scanning and indexing interface via Kofax software; provided PC hardware/software support for Imaging department.
• Technical assistance with several company mergers including Speedway, Marathon Oil, & Williams Travel Centers.