OBJECTIVE:

• Microsoft SQL Server Database Administrator

PROFESSIONAL EXPERIENCE:

Confidential

Senior Microsoft SQL Server Database Administrator

Responsibilities:

• Created logical and physical data models to optimize security, performance, and data integrity.
• Redesigned database’s tables, indexes, triggers, and stored procedures improving application performance by 300%. Implemented SQL Server 2016 Always Encrypted for security maximization.
• Implemented and tuned new and existing SQL Server databases. Created and debugged SSIS packages.
• Created stored procedures and triggers as needed. Identified and resolved performance issues including high
• IO, high CPU, slow SQL queries, missing indexes, and server configuration problems. Installed and upgraded SQL Server database engine, SSRS, SSAS, and SSIS, on SQL Server versions 2005, 2008, 20122014, and 2016. Moved, upgraded, and installed new databases and applications on SQL Servers in GM data centers and in GM plants. Supported and resolved application development’s database needs and issues. Implemented and supported data warehouses. Made recommendations for SQL Serve features to improve security and performance. Advised other DBAs on technical issues. Implemented
• SQL Server Always On High Availability Groups and SQL Server Transactional Replication.
• Trained several new SQL Server DBAs. Erwin experience. Created Powershell scripts to copy filesadd SQL Agent jobs, restart services on remote computers.

Confidential

Senior Data Architect, DBA, ASP, MS Dot Net developer

Responsibilities:

• Developed company wide systems, processes, and standards. Created logical and physical database designs. Designed, maintained, and deployed databases on 160 Clustered MS SQL Advanced and Data Center Servers, accessing 60 tera bytes of storage from IIS Web based applications and client server applications. Created SQL Server 2000, SQL Server 2005, and SQL Server 2008, SQL Server 2012 stored procedures, triggers, views, maintenance jobs, SSIS, and DTS jobs. Developed and implemented processes to reduce number of SQL servers and consolidate SQL instances. Created Linked servers spanning multiple domains. Installed and supported IIS for multiple Web sites. Created multiple ASP and ASP.NET based Web sites using C#, VB.NET, VB Script, Java Script, and XML. Established replication and mirroring for several clients. Tuned SQL Servers and Optimized T - SQL code. Implemented SQL Server Management Data Warehouse for database and server optimization.

Confidential

Senior DBA, Site Server E-commerce, ASP, MS Dot Net developer

Responsibilities:

• Selected software development and deployment platforms, software development tools, database software, e-commerce software, and helped staff the development team. Created logical and physical database designs using Erwin. Deployed databases with MS SQL Server 7 and MS SQL Server 2000. Created stored procedures and triggers as needed. Installed and supported IIS for multiple Web sites. Created Visual basic COM objects and programs to process Web data. Developed E-commerce Web sites based on MicroSoft Site Server E-commerce and Cyber Source. Created web portals with Microsoft ASP, Microsoft Dot Net, and XML. Created Document management systems based on Microsoft Site Server and SharePoint.

Confidential

Contract Internet Instructor

Responsibilities:

• Part time instructor for Java, and Visual Interdev. Instruction included the following:
• Java, JDBC, ASP, DHTML, ODBC, OLE DB, ADO, ActiveX.
• October 1998 - Director of Information Systems
• February 2000 Behavioral Health Partners
• Directed team of 8 in development of commercial application for the health care industry. Responsibilities included managing, designing, and coding health care software for managed care organizations, health care providers, and employee assistance programs.
• Acted as MS SQL Server DBA. Designed and implemented databases using Power
• Designer. Systems developed using PowerBuilder 5.0/6.5 with PFC. Directed staffing

Confidential

Java, Javascript, VBscript developer

Responsibilities:

• Developed Web software using ASP to process database information using Vbscript and Javascript. The system developed navigated to a Web site based on database information then used DHTML to pull data from the Web page and place the data in a database. Developed Java programs to pull web data from remote servers and parse the information into a database.

Confidential

Senior Consultant

Responsibilities:

• Responsible for design, development, testing, and deployment of GUI systems.
• System developed using PowerBuilder 4.0/5.0/6.5, PFC, and ORACLE 8.
• Extensive knowledge of Windows NT, Windows 95, Windows 98, Windows 3.1, MSDOSUNIX, OS2, LANs, WANs, and Intranets. Extensive Database design, GUI designand full product life cycle experience.

Confidential

Project leader/Development Manager

Responsibilities:

• Hands on Manager, responsible for complete product development. Designed, developed, tested, and deployed GUI systems on Intranet, WAN, LAN, utilizing PowerBuilder 4.0/5.0 and Visual Basic with ORACLE, SYBASE, and MS Access DBMS. Performed ORACLE DBA duties, installing and supporting ORACLE databases. Developed PC interfaces to DG and Honeywell mainframes. Acted as primary customer contact resolving and/or delegating customer support issues, recommending current and future software and hardware solutions. Supervised and conducted remote support with PCanywhere and Reachout. Interviewed and recommended for hire contract and permanent staff. Extensive knowledge of Windows NT, Windows 95, Windows 3.1, MSDOS, UNIX, OS2, LANs, WANs. Extensive Database design, GUI design, and full product life cycle experience.

Confidential

Project Manager

Responsibilities:

• Directed team of 9 analysts in software development and maintenance projects utilizing Confidential compatible PCs and Unisys mainframes. Designed, developed, and supported MicroFocus COBOL, Unisys assembler, Motorola assembler, and Unisys COBOL banking systems.

Confidential

Systems Analyst / Project Systems Analyst

Responsibilities:

• Researched customer needs, designed and developed Confidential PC and mainframe based software systems. Systems written with C, Micro Focus COBOL on Novel Local Area Networks for Confidential compatible PCs. Mainframe and other software written in Unisys Medium System COBOL and Motorola 68000 assembler. Systems designed and developed using Confidential methods.

Confidential

Sales Representative

Responsibilities:

• Responsibilities included sales of mainframes, communication systems and software.