SUMMARY:

• My career in IT has extended over a range of responsibilities including a variety of operating systems, database systems and front end tools for reporting and content delivery. My background and experience enables me to understand, translate and articulate responses and solutions to cross platform problems and interactions. I successfully identify, document and resolve operational issues with creative and inclusive uses of technology to provide visibility and accountability.
• While at Confidential my focus has been on identifying and addressing gaps in infrastructure, systems and processes, while providing creative solutions and resolution. I am particularly effective working across the organization from the Infrastructure team to the application owners and their support staff to provide assistance in keeping systems, efficient, effective and available.
• I have wide experience with a variety of development methodologies, have strong collaboration skills, I am effective at translating technical information to non - technical end users, and have hands on experience providing training and managing projects.

PROFESSIONAL EXPERIENCE:

Lead Operations SQL Server DBA

Confidential

• Work with Idera SQL Diagnostic Manager to setup configuration for multiple responses, templates for alerts, and customer needs.
• Coordinate support needs of new customers including migrating to licensed environments, removing obsolete installations, identifying decommissions, and updating of inventory/ITIL tool.
• Coordinate, plan, and schedule service account password changes involving several weekends with several team members
• Plan, test, and make recommendations for backup strategy changes for cost and time savings
• Work with patching team to coordinate regular Microsoft Windows patching as well as specialized patching like ActiveClient for smartcard access
• Setup DR procedures such as AlwaysOn and log shipping
• Work with security and compliance teams to meet security and compliance requirements.
• Perform builds for new SQL Server installations and migrations
• Perform maintenance such as monitoring of backups and space needs as well as trouble shoot SQL server issues.
• Work with application teams to provide DBA support that met their needs including during installations, upgrades, maintenance and troubleshooting
• Train other DBAs on common SQL Server procedures, enforce standards and develop library of SOPs for common SQL Server procedures

Technologies and skills: SQL 2008R 2/2012/2014/2016, TSQL, SSIS, Idera SQL Diagnostic Manager, AlwaysOn, ServiceNow (ITIL)

Lead SQL Developer

Confidential

• Develop plan and implement data migration of derivatives from legacy system to newly developed application. Plan included creating plan for migration, data mapping using Excel, data flow diagram using Visio, and release documents using Word. I worked with the ETL developer, analyst from Wall Street application for integration of new data, business owners, and BA. I also worked with QA team on testing and various release personal (Informatica admin, Oracle DBAs, MS SQL Server DBAs) for release implementation. Create change requests for schema creation, connections, and login/ID creation. Create DB restore request to refresh QA database and DB review tickets to review scripts before implementation. Develop SQL Server and Oracle scripts and Access DB queries for testing of migrated data and perform tests of same. Create release documentation for all environment (QA and Prod) releases.
• Develop data design (model) using Erwin data modeler and PL/SQL scripts (both DDL and DML) for new trade application. Create change requests for schema creation, connections, and login/ID creation. Create DB review tickets to review scripts before implementation. Use Visio to create data flow diagram.
• Lead development database design standards by working with other SQL Developers. Standards were created for naming, and columns used for auditing purpose (update and creation data) are now required.

Technologies and skills: MS SQL 2005/2008, TSQL, PL/SQL, Erwin Data Modeler, SSMS, PL/SQL Developer, Visio, Oracle 11g

SQL DBA

Confidential

• Work on tasks requested in change tickets for application owners such as backups and running of scripts.
• Plan and test service pack apply for SQL Server clustered instances. Test on Sandbox server and develop plan for implementation. Lead team of DBAs who implemented service packs on servers. Perform upgrades on development, then QA, and then production clustered servers.
• Lead project to change passwords on 51 SQL Server clusters and 25 Standalone SQL Server instances. I researched the project first with Microsoft support and then tested on our sandbox server. I worked with a team of 3 on the Standalone SQL Servers and then a team of 4 to change the 51 clusters over one weekend. Servers and tasks to work on along with order and specific changes to make were put in an organized plan so that each DBA knew what items to do, what order to them in and how and so that each had the same amount of work to do. We then tested all clusters by failing them over and back, tested Standalones by stopping and starting instances and all was completed with no issues.
• Create change tickets for implementation of various SQL Server activities.
• Collaborate with storage administrators and system administrators on long-term project to configure SAN storage for all SQL clusters to optimize storage and configuration settings. Project came about due to collaboration with storage administrator who investigated ongoing issues with clusters. Create plan for remediation including all servers that needed remediation that was integrated with other long-term maintenance projects. Create associated tickets and work with system administrator staff to get same staff assigned to perform weekly tasks. Perform remediation by environment by starting with development, then QA, and then Production clusters.
• Collaborate with Windows system administrator to engage Microsoft to run Risk and Health Assessment on selected SQL Server cluster to determine whether selected cluster met best practices and then work on suggested remediation.
• Pass on products, upgrades, pilot projects from interaction with AMSTC IT employees that would provide value to DBA team. This included setting up a Support Central library to centralize tracking our cluster maintenance tasks, Support Central Outlook plugin, Exchange Server pilot using a larger mailbox, and pilot of Citrix WebEx upgrades.
• Document established DR on production servers and follow up with database owners to determine
• Perform DR testing with application owners
• Assist developers with SSIS conversions from DTS using Pragmatic Works DTSxChanges
• Track storage and space needs and request addition of storage if needed
• Document procedure for SQL Server 2008 client installation and assist clients where needed
• Upsize Access databases to SQL Server 2008
• Develop virtual log cleanup process for performance improvement purposes

Technologies and skills: SQL 2005/2008, TSQL, SSIS, BIDS, Idera SQL Diagnostic Manager, VB.NET used in SSIS package development, Pragmatic Works DTSxChange for DTS conversion, MS Project, .NET framework, MS Office.

SQL DBA

Confidential

• Designed and coded SSIS packages to migrate data from various data systems
• Use of SQL Analysis Services and ProClarity business intelligence tools to report on information in the data warehouse
• Test prototype to convert DTS packages to SSIS. Create plan and convert DTS packages to SSIS.
• Configure SSIS services on SQL 2005 64 bit cluster
• Restore data warehouse and ProClarity tables to fix corruption issues
• Reviewed and modified existing VB.Net code and infrastructure as needed
• Set up of Test data base environment
• Monitor SQL Servers for availability
• SQL administration tasks including monitoring of backups
• Monitor capacity and performance procedures
• Migrated data warehouse databases from SQL 2000 to SQL 2005 64bit clustered environment
• Responsible for job scheduling (automation) and trouble shooting
• Developed and implemented standards in migration processes and documented complex processes
• Wrote stored procedures, DTS Packages and scripts
• Administer security (permissions) for stored procedures, SSIS packages, and test server users
• Maintained Eureka reports

Technologies and skills: SQL 2000/2005, TSQL, SSIS, VB.NET, BIDS, SSAS, ProClarity business intelligence tools, Eureka Reports, SQL utilities such as isql, osql, and sqlcmd

Technology Coordinator

Confidential

• Purchased and installed Department PCs and printers
• Coordinated upgrade of Network switch and firewall
• Coordinated move of Department website to new hosting location
• Work on standardizing data and upgrading department software

Technologies and skills: SQL 2000

System Analyst/DBA

Confidential

• Administration of SQL Server databases
• Upgrade and patch SQL Server databases
• Reviewed and modified existing code and infrastructure as needed
• Administration, maintenance, patching, and upgrades of Great Plains accounting software. This included work with 3 vendors for each integrated software piece needed. Upgrades were tested and documented in test environment and then performed in production environment.
• Administration, maintenance and upgrades of iMIS software including work with vendor and creation of customizations.
• Created reports using Crystal Reports and MS Access
• Daily backups and other administration tasks
• Monitor SQL Servers for availability
• Creation of tables, indexes, views, and stored procedures
• Worked extensively with Great Plains and iMIS servers, troubleshooting and integration
• Rewrite VBA application to VB.Net
• Wrote stored procedures, DTS Packages and scripts
• Administration, maintenance, patches, upgrades and customizations of iMIS membership software

Technologies and skills: SQL 2000, TSQL, DML, Great Plains accounting software, MS Access, VB.NET, iMIS membership software, Crystal Reports, Visio Enterprise (data modeling), MS Project, .NET framework

Systems Analyst

Confidential

• Redesign and migrate application data into SQL Server relational database using Visio Enterprise data modeling tools
• Created the database, migrated data, and re-scripted web-based application in ASP
• Monitor Windows, SQL and IIS for availability
• Administered Windows NT server
• Created Windows NT test server
• Administered IIS 5.0 web server
• Backups, daily maintenance and other administrative tasks
• Trouble shoot issues with server and SQL
• Upgrade and patch SQL Server, Windows NT, and IIS 5.0 servers

Technologies and skills: SQL Server 7, TSQL, DML, JavaScript, VBScript, IIS 5.0, Visio Enterprise data modeling tools, MS Access, ASP, Visual Basic, MS Project

Systems Analyst

Confidential

• Worked with vendor in development of pen technology for field staff use
• Performed quality control testing of pen technology application
• Coordinate and participate in user training of application
• Program tasks in development of PowerBuilder system used by hatcheries

Technologies and skills: PowerBuilder, SQL Server, and Embarcadero data modeling tools

Programmer Analyst

Confidential

• Performed activities to integrate Detroit College of Law (now MSU College of Law) grading including development of DCL front end in MS Access
• Responsible for maintenance and upgrades of MSU mainframe grades systems.
• Responsible for multiple COBOL and CICS programming tasks.
• Worked on cross functional team to create web based request system in ASP and SQL