TECHNICAL SKILLS:

Database: Microsoft SQL Server 2014/2008R 2/2005/2000/7.0/6.5 (Developer, Standard and Enterprise Editions), Microsoft Access, dBase IV

Reporting and Analysis: SSMS, SSRS, Microsoft Excel

Data Transformation and Loading: SSIS, DTS, BCP, XML, Linked Servers

Performance Tuning: SQL Server Profiler, PerfMon, SQL Query Plans

Programming: T - SQL, C#, VB, VBA/VBA7, .Net Framework, ASP, COBOL, Pascal, Ada, HTML, LINQ, ADSI, ReportViewer

IDE: Microsoft Visual Studio 2015/2013/2010/2008 /2005 , TFS

Networking: Cisco Routers, Cisco Switches, Enterasys Switches, Novell Network OS, DHCP, DNS, Windows Active Directory, PSFTP, FTP, TCP/IP, VPN

Backup and Recovery: Backup Exec, ArcServeIT, DLT, DAT

OS: Windows Server 2003, Windows 2000 Server, Windows 2000 Professional, Windows NT 4 Server, Windows NT 4 Workstation, Windows 10, Windows Vista, Windows 95, DOS

Additional Skills: Definity PBX, Microsoft Exchange Server, Intermec barcode scanners, Intermec barcode printers, Microsoft Office

WORK EXPERIENCE:

Database Developer

Confidential, AL

Responsibilities:

• Install, configure and maintain Microsoft SQL Server
• Design tables, stored procedures, functions, custom types, triggers, synonyms, views, scripts, indexes utilizing T-SQL
• Load data from disparate sources using linked servers, SQL Server Integration Services (SSIS), data transformation services (DTS), bulk copy program (BCP), Microsoft Access, custom developed C#.Net applications
• Use SQL Server Profiler, execution plans and Microsoft Visual Studio to resolve database performance problems
• Develop reports using SQL Server Reporting Services (SSRS)
• Establish data warehouse solutions to extend reporting ability
• Facilitate interaction between databases using SQL Server jobs, intermediate databases
• Use Microsoft Visual Studio with Team Foundation Server (TFS) to develop C#.Net web, windows and console applications
• Established and maintained separate database environments for development, test and training to facilitate different stages of the development process
• Used Visual Studio, Microsoft Excel and Microsoft Access to develop the Cost Estimation Utility (CEU) for a commercial client of Confidential . The CEU tracked project estimation costs for a large construction effort and constructed Microsoft Excel spreadsheets with dynamically generated formulas
• Earned Microsoft certifications for MCDBA, SQL Server 2000 and MCITP, SQL Server 2005

Environment: Microsoft SQL Server 2014/2008R2/2005/2000 (Developer, Standard and Enterprise Editions), SQL Server Management Studio (SSMS), SQL Server Reporting Services (SSRS), T-SQL, SQL Server Integration Services (SSIS), SQL Server Profiler, Data Transformation Services (DTS), Bulk Copy Program (BCP), Microsoft Visual Studio 2015/2013/2010/2008 , C#, .Net Framework 4.5.2/3.5/3.0 , Team Foundation Server (TFS), Microsoft Access, Microsoft Excel, LINQ, Linked Servers, ReportViewer control Confidential

Database Specialist

Confidential, AL

Responsibilities:

• Administered Microsoft SQL Servers
• Resolved database performance issues using SQL Server Profiler and Performance Monitor
• Used Visual Studio to develop and maintain web applications in Active Server Pages and C#.Net
• Maintained Microsoft Access-SQL Server applications
• Provided application support to users of Primavera, Deltek Costpoint and other enterprise applications
• Refactored an existing ASP-SQL Server web application to be used at other project sites
• Led the upgrade of enterprise timekeeping software

Environment: Microsoft SQL Server 2000 (Standard and Enterprise Editions), T-SQL, C#, VB, ASP, SQL Server Profiler, Data Transformation Services (DTS), Visual Studio 2005, .Net Framework, Microsoft Access, Microsoft Excel, Primavera, Deltek Costpoint, Deltek WebETWindows Server 2003, Windows 2000 Server, Windows 2000 Professional, Windows Active Directory, TCP/IP, VPN

IT Site Lead

Confidential, AL

Responsibilities:

• Installed, configured and maintained Windows NT 4 and Windows 2000 servers
• Installed and managed Enterasys intelligent network switches
• Administered SQL and Oracle database servers
• Planned and implemented a disaster recovery strategy using Backup Exec software and DLT tape drives
• Developed Microsoft Access-SQL Server applications
• Managed Lucent/Avaya Definity PBX
• Provided desktop and telecom support
• Managed desktop and server leases
• Coordinated telecom and IT contractors
• Selected to help resolve Windows network problems at other sites as an enterprise administrator
• Provided periodic IT support to Atlanta, GA sales office
• Earned Microsoft certifications for MCSA, Windows Server 2003 and MCSE, Windows NT 4.0

Environment: Windows NT 4 Server, Windows 2000 Server, Microsoft SQL Server 7.0Oracle 8i, Enterasys Switches, Veritas Backup Exec, Quantum DLT Tape Drives, Microsoft Access, Lucent/Avaya Definity PBX, Windows 2000 Professional, Windows NT 4 Workstation, Windows 95, Windows Active Directory, TCP/IP, VPN

Confidential

IT Specialist

Responsibilities:

• Installed, configured and maintained Microsoft SQL Servers
• Resolved database performance issues
• Developed and maintained Microsoft Access-SQL Server applications
• Installed, configured and maintained Windows NT 4 Servers
• Installed, configured and maintained Microsoft Exchange Servers
• Used ArcServeIT and Backup Exec to backup Windows NT 4 Servers
• Configured Cisco routers and network switches
• Provided desktop support.
• Earned Microsoft Certified Professional (MCP) designation

Environment: Windows NT 4 Server, Microsoft SQL Server 6.5, Microsoft SQL Server 7.0Seagate Backup Exec, ArcServeIT Backup, Quantum DLT Tape Drives, DAT Tape DrivesMicrosoft Access, Windows NT 4 Workstation, Microsoft Exchange Server 5.5, Cisco Routers, Cisco Switches, DHCP, DNS, TCP/IP

Computer Specialist

Confidential, AL

Responsibilities:

• Developed AIPS in Microsoft Access
• Developed barcode scanner software using Intermec tools
• Migrated property data to Access from dBase IV
• Coordinated activities of cooperative education students selected to maintain AIPS
• Provided support for Intermec barcode Scanners and printers
• Administered Microsoft Exchange Server
• Provided desktop support

Environment: Windows NT 4 Server, Microsoft Access, dBase IV, Windows NT 4 Workstation, Windows 95, Microsoft Exchange Server, Intermec barcode scanners, Intermec barcode printers

Computer Specialist

Confidential, AL

Responsibilities:

• Developed and maintained Microsoft Access databases
• Configured and maintained desktop computers and peripherals
• Provided desktop support

Environment: Microsoft Access, VBA, Windows 95, Novell Network OS, Microsoft Office, HTML