We provide IT Staff Augmentation Services!

Senior Database Administrator Resume

Southfield, MichigaN

WORK EXPERIENCE:

Confidential, Southfield, Michigan

Senior Database Administrator

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, Madison Heights, Michigan

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, Bingham Farms, Michigan

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

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 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 (Service Centers 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, Troy, Michigan

Programming Manager

Responsibilities:

  • Managed programming and mainframe support group of programmers
  • 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 programmers in use of 4th generation tool (Progeni) 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 Confidential 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)

Programmer, System Support

Confidential

Responsibilities:

  • Wrote system utilities for V Series systems
  • Performed numerous data conversions as Confidential Federal took over other institutions
  • Responsible for electronic forms produced in Data Center for mailing to customers
  • Responsible for design of microfiche produced in Data Center

Hire Now