PROFESSIONAL EXPERIENCE

Lead Operations,

Confidential,

Responsibilities:

• Work wif 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 wif several team members
• Plan, test, and make recommendations for backup strategy changes for cost and time savings
• Work wif 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 wif 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 wif 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 include SQL 2008R 2/2012/2014/2016 , TSQL, SSIS, Idera SQL Diagnostic Manager, AlwaysOn, ServiceNow (ITIL)

Lead SQL Developer,

Confidential,

Responsibilities:

• 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. me worked wif the ETL developer, analyst from Wall Street application for integration of new data, business owners, and BA. me also worked wif 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 wif other SQL Developers. Standards were created for naming, and columns used for auditing purpose (update and creation data) are now required.

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

SQL DBA,

Confidential,

Responsibilities:

• 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. me researched the project first wif Microsoft support and then tested on our sandbox server. me worked wif 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 wif 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 wif no issues.
• Create change tickets for implementation of various SQL Server activities.
• Collaborate wif 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 wif storage administrator who investigated ongoing issues wif clusters. Create plan for remediation including all servers that needed remediation that was integrated wif other long-term maintenance projects. Create associated tickets and work wif system administrator staff to get same staff assigned to perform weekly tasks. Perform remediation by environment by starting wif development, then QA, and then Production clusters.
• Collaborate wif 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 wif AMSTC IT employees that would provide value to DBA team. dis 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 wif database owners to determine
• Perform DR testing wif application owners
• Assist developers wif 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 include 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 Michigan,

Confidential,

Responsibilities:

• 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.
• 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
• 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 include 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 include SQL 2000.

System Analyst/DBA State

Confidential,

Responsibilities:

• 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. dis included work wif 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 wif 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 wif 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 software

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

Fulltime - Systems Analyst,

Confidential,

Responsibilities:

DBA tasks include: install MS-SQL Server, create database tables, create stored procedures, create indexes on tables, work wif SQL Server security, and use data modeling tools. Development tasks included: use of 3-tier development in creation of e-commerce solution to convert existing online MBA application to use SQL Server, migrated existing web application data from Access 97 to SQL Server, and created VB program interface between SQL application and Access 97 admissions database.

• 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 wif server and SQL
• Upgrade and patch SQL Server, Windows NT, and IIS 5.0 servers

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

Systems Analyst DNR,

Confidential,

Responsibilities:

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

Technologies and skills include PowerBuilder, SQL Server, and Embarcadero data modeling tools.

Fulltime - Programmer Analyst,

Confidential,

Responsibilities:

• Performed activities to integrate Detroit Colege of Law (now MSU Colege 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,

Technologies and skills include SQL Server 7, Active Server Pages, COBOL, CICS, and MS Access.