WORK EXPERIENCE

Confidential

Senior Database Administrator, Confidential Operations Team Lead

Responsibilities:

• SQL Server DBA duties for multiple databases in 14 datacenters around the world.
• Includes indexing and tuning, creating/maintaining stored procedures and triggers, capacity planning, backup, recovery, troubleshooting, monitoring
• Maintain SQL 2008, 2008 R2, 2012, 2014, 2016
• Install SQL Server 2014, 2016 in clustered and non - clustered environments
• Programming with T-SQL, SSIS, PowerShell and .NET (C# in SSIS) on MS SQL Server 2008 R2, 2012, 2014, 2016
• Built T-SQL, PowerShell, and SSIS packages for system maintenance
• Built SSIS packages for ETL
• Coding in Visual Studio 2010, 2015

Confidential

Database Analyst

Responsibilities:

• SQL Server DBA duties for multiple databases.
• Includes indexing and tuning, creating/maintaining stored procedures and triggers, capacity planning, backup, recovery, troubleshooting
• Set up and maintain SQL 2008, 2008 R2 and 2012, MS Reporting Services
• Programming with T-SQL, SSIS, and .NET (C#, ASP.NET) on MS SQL Server 2008, 2008 R2, 2012
• Maintain web sites in ASP.NET and Silverlight
• Coding in Visual Studio 2008, 2010, 2015

Confidential

SQL Server Database Developer

Responsibilities:

• SQL Server DBA duties for multiple databases.
• Includes indexing and tuning, creating/maintaining stored procedures and triggers, capacity planning, backup, recovery, troubleshooting
• Set up and maintain SQL 2000, 2005, 2008, 2008, 2008 R2 and 2012, MS Reporting Services
• Upgrading SQL Servers, all of the above, from 2000 all the way to 2012
• Programming with T-SQL, SSIS, and .NET (C#, VB.NET, ASP.NET) on MS SQL Server 2000, 2005, 2008, 2008 R2, 2012, Crystal Reports 10
• Maintain web sites in ASP.NET
• Coding in Visual Studio 2008, 2010, 2013
• Responding to customer trouble tickets
• Report writing in MS Reporting Services

Confidential, Duluth, Georgia

Developer II

Responsibilities:

• Programming with T-SQL, DTS, SSIS, and .NET (C#, VB.NET) on MS SQL Server 2000, 2008, 2008, 2012, Crystal Reports 11
• SQL Server DBA duties for multiple databases. Includes indexing and tuning, capacity planning, backup, recovery, troubleshooting
• Set up and maintain SQL 2000, 2005, 2008, 2008 R2 and 2012, MS Reporting Services
• Upgrade SQL Server from 2000 to 2012, 2005 to 2008, 2008 to 2008 R2
• Maintain web sites in ASP.NET
• Installation and Maintenance of Windows 2008 Servers
• SQL queries against Oracle 9,10, and 11 databases. Using .NET 3.5, 4, and 4.5 along with Crystal Reports to build custom reports and export files for customer credit unions.
• Also code and maintain the special .NET programs to run the reports for multiple institutions.
• Coding in Visual Studio 2008, 2010, 2012
• Installation and maintenance of Subversion version control system
• Some SharePoint 2013 coding in C#; wrote a system to generate automatic recurring tasks

Confidential, Southfield, Michigan

Senior Systems Analyst

Responsibilities:

• Managed the programming staff. Built the entire staff ( Confidential had no programmers on staff when I was hired)
• Perform R&D on new technologies, such as mainframe/web integration, mainframe to PC migration/integration
• Aid Operations in running 24/7 EFT and Branch Banking network, using best practices to aid in setting up Operations department (did not exist in-house when I was hired)
• Recommended and recruited the current Operations Manager ( Confidential ’s Operations were outsourced at the time)
• Dealt directly with vendors to negotiate for new hardware and software
• Disaster Recovery planning
• Performed initial design of new Data Center
• Primary sponsor behind initiative to bring Data Center in-house from outsourcer - researched cost/benefits, risks and feasibility, and gave presentation to senior management as though I were an outside respondent to the RFP
• SQL Server DBA duties for multiple large (>100GB) databases (one of which was a real time, OLTP database), including clustering of SQL 2000 and 2005. Includes indexing and tuning, writing stored procedures, capacity planning, backup, recovery
• Programming with T-SQL, DTS, SSIS, and .NET on MS SQL Server 2000, 2005, 2008, 2012, Crystal Reports 11
• Installation and maintenance of Exchange 2007 Server, Exchange 2010 Server
• Set up and maintain SQL 2000, 2005, 2008, 2008 R2 and 2012, MS Reporting Services
• Maintain web sites in ASP.NET
• System Admin for Firewall, Exchange and Active Directory
• Installation and Maintenance of VMWare ESX servers for systems consolidation
• Installation and Maintenance of Windows 2000, 2003 and 2008 Servers
• Team member on mainframe to Windows migration, moving mainframe DDB to MS SQL and mainframe COBOL to MicroFocus COBOL
• Hands-on problem solving of mainframe, Windows NT/2000/2003, LAN, and desktop problems (Win 95/98/ME/2000/XP), both hardware, software and integration
• Charter Member of Service Center’s Quality Assurance Task force, a group whose members were initially selected by the company President from managers across the company to promote quality through standards of service, employee morale and awareness programs
• Set up first Service Center’s in-house mainframe, LX 5100
• Aided in setup and cutover from outsourced mainframe to in-house mainframe
• Designed software for concurrent operation of in-house and outsourced mainframe during transition
• Designed National Shared Branch software
• Designed new EFT and Local Branch software
• Integrated QBT MultiPoint (with XML technology) with new EFT/Branch network
• First recommended and aided in migration from bisync to TCP/IP communications protocol
• First recommended and aided in implementation of Linux as new DNS
• Acted as in-house “consultant” to Micro Support, Operations, and Data Communications sections
• Designed, developed and implemented Confidential ’s Internet File Maintenance products interfacing mainframe to Microsoft IIS for web enablement
• Performed initial R&D and showed feasibility for using Microsoft Terminal Services to solve problems with remote users of some applications
• Implemented Microsoft SQL Server linked with Unisys mainframe

Confidential

Assistant Vice President, System Support

Programming Manager, System Support

Responsibilities:

• Responsible for installing and maintaining Operating Systems, System tools, Operational tools, utilities and languages on Unisys mainframes and programmer’s desktops
• Responsible for all Electronic forms and letters sent out to customers from Data Center - design and implementation
• Aid Operations in running 24/7 EFT and Branch Banking network
• Designed all production work flows for Operations
• Designed plan and aided in movement of Data Center to a new building with minimum of downtime
• Responsible for Disaster Recovery/Business Continuity Planning and Testing
• Performed many off-site disaster recovery tests, entirely in charge of a few, otherwise number two person giving detailed direction to Operations staff
• Designated Operations Manager in case of declared disaster
• Tested and recommended for purchase all disk, tape and print peripherals
• Dealt directly with vendors to negotiate for new hardware and software
• Designed and developed software and procedures to install new software and report to management on installations to satisfy both management and audit requirements
• Planned and started conversion from V Series to A Series systems of in-house and IPS applications (conversion halted due to merger). IPS and some other applications were completed.
• Responsible for training programmers in use of 4th generation tool ( Confidential ) and in best practices for programming
• Worked directly with auditors, internal and external, on an ongoing basis, to meet or exceed all requirements
• Budgeted for System Support staffing
• Responsible for the Online Data Entry System, including changes to tailor package into custom software for Standard Federal and ongoing support.
• Integrated PC programming tools with V Series mainframe
• Maintained Internet Firewall and Security
• Designed and wrote real-time tape library for V Series
• Responsible for design of all microfiche produced in Data Center
• Trained in Operation and Maintenance of HP-UX (Unix)

Confidential

Programmer/Analyst

Responsibilities:

• Installed first on-line editing tools for programming staff
• Converted software from Chicago branch for use at Detroit Branch
• Supported Item Processing System