We provide IT Staff Augmentation Services!

Sql Server Database Specialist Resume Profile

Summary

  • Over 26 years of experience in the industry successfully designing, implementing, maintaining, upgrading and supporting SQL Server databases in corporate environments
  • Over 19 years as an independent SQL Server database consultant, specializing in SQL Server database administration, multiple environment support, performance tuning, upgrades, database security, disaster recovery, data mart and data warehouse design, replication, clustering and advanced Transact-SQL programming
  • Developer of SQL Server Reporting Services SSRS and Crystal Reports reporting systems
  • Creator of SQL Server Integration Services SSIS packages
  • Experienced in organizing and managing multiple projects, project teams, and deliverable deadlines in changing environments keeping within scope and within budget

TECHNICAL SKILLS

  • Databases
  • Microsoft SQL Server 2012/2008/2005/2000/7.0/6.5 64- and 32-bit , Sybase
  • Systems
  • Microsoft Windows 2012/2008/2003/2000 Server, Vista, Windows XP, NT,MS-DOS
  • Applications
  • Microsoft Office Word, Excel, PowerPoint, Outlook , Microsoft Project, Visio
  • Languages
  • T-SQL, SQL, HTML, VBScript, COBOL, JCL, DOS
  • Tools
  • SQL Server Reporting Services SSRS , SQL Server Integration Services SSIS , ER/Win, ER/Studio and Change Manager, Visual Studio, Enterprise Manager, SQL Profiler, OSQL, ISQL, SQLCmd, Crystal Reports, VMWare, Data Transformation Services DTS Packaging, OLAP, LiteSpeed Backup, Veritas tape backups, WebTrends, Tivoli SQL database backups

PROFESSIONAL EXPERIENCE

Confidential

  • Senior SQL Server Database Administrator, MS SQL Server 2000/2005/2008/2012, Windows Server 2008 32-bit and 64-bit , SSIS, VMWare, VPN, Tivoli SQL database backups
  • Supported over 35 SQL Server database servers/instances, including multiple databases, multiple instances and multiple environments
  • Standardized maintenance routines and backup procedures across all database servers
  • Reduced runtime of multiple processes significantly using smart procedures

Confidential

  • Senior SQL Server Database Administrator, MS SQL Server 2008, Windows Server 2008, SQL Server Reporting Services SSRS , SQL Server Integration Services SSIS , VMWare, VPN
  • Planned, developed and supported the SQL Server clustered systems, including multiple databases, multiple instances and multiple environments
  • Reduced runtime of multiple processes significantly using performance tuning tools
  • Designed and implemented multiple database reporting structure using SQL Server Reporting Services SSRS

Confidential

  • Senior SQL Server Database Administrator, MS SQL Server 2000 64-bit Clusters, Windows Server 2003 64-bit Clusters, ER/Studio, Visio, Veritas, VPN
  • Planned, developed and supported SQL Server 2000 Enterprise 64-bit, 32GB RAM environments, including Windows 2003 Datacenter 64-bit, 32GB RAM clusters with multiple database instances
  • Worked very closely with the Data Modeler using ER/Studio to develop the physical database components of the operational data store, including primary keys, foreign keys, indexes and alternate keys
  • Developed failover and failback strategy and testing
  • Assisted implementation of Veritas database tape backups
  • Designed and implemented application database security documentation and strategy

Confidential

  • Senior SQL Server Database Administrator, MS SQL Server 2000, Windows 2000, MS Visual SourceSafe and Embarcadero ER/Studio and Database Compare products
  • Performed as a DPS Consultant to DPS client
  • Planned, developed and supported several 5-20GB intraweb-based application databases in a SQL Server 2000 / Windows 2000 environment
  • Assisted in the design of new databases using Embarcadero ER/Studio
  • Supported database environment using SQL Server 2000 tools and Embarcadero Change Manager
  • Determined and implemented performance tuning measures
  • Developed SQL replication creation and deletion scripts
  • Implemented various Data Transformation Services DTS packages
  • Maintained database environment security for development, test and pre-production environments

Confidential

  • Database Administrator / Data Warehouse Architect, MS SQL Server 2000, Windows 2000, MS Visual SourceSafe and Embarcadero products
  • Planned, developed and supported web-based applications in a SQL Server 2000 / Windows 2000 environment
  • Assisted in the design of new databases using Embarcadero ER Studio 6.0
  • Supported database environment using SQL Server 2000 tools and Embarcadero Change Manager
  • Implemented various Data Transformation Services DTS packages
  • Maintained database environment security for development, test and production environments

Confidential

  • Database Administrator / Data Warehouse Architect, MS SQL Server 2000, Windows 2000 and Crystal Reports 8.5
  • Planned, developed and supported web-based applications in a SQL Server 2000 / Windows 2000 environment
  • Designed and implemented a data warehouse / data mart of external education-related data
  • Implemented Data Transformation Services DTS applications to replicate production database in-house on request
  • Implemented and supported automated backup/restore procedures and database integrity check procedures
  • Developed customized Crystal Reports reports

Confidential

Online Instructor / Online Trainer, MS SQL Server 2000 and Windows 2000

Confidential

Database Administrator / Upgrade Coordinator, MS SQL Server v6.5-to-7.0 Conversion Project

Confidential

Database Administrator, MS SQL Server 7.0

Confidential

Database Administrator, MS SQL Server v6.5 Conversion Project and LeaseTek Leasing Project

Confidential

Database Administrator, Voice and Information Group

Confidential

Application Database Administrator, Project 2000 Data Warehouse

Confidential

Programming Supervisor and Application DBA, North American Payroll System on

Dun Bradstreet payroll application, COBOL, DB/2, Strobe, File-Aid for DB/2, QMF.

Confidential

  • Team Leader, Database Architecture team, Boston Sybase SQL Server, UNIX.
  • Database Administrator, Process/1 development team, Chicago - Windows NT, Microsoft SQL Server, DEC VAX, Rdb/VMS, COBOL, ISO 9000.
  • Team Leader, PC Development Technical Support Team, Chicago - MicroFocus's COBOL Workbench, XDB, Stingray, Endevor, DOS, Novell LAN, Compaq and Dell 486/33 PCs.
  • Developer/Analyst, Technical Architecture and Support team's Test Data Management and Client Workbench teams, Chicago - DB/2, COBOL, IMS, IBM 3090, Andersen Consulting's MAC-PAC/D product, TSO ISPF Dialog Management clists, skeletons, tables, panels.
  • Developer/Analyst/Application Database Administrator, Personnel Information Database team and North American Payroll System team, Chicago - DB/2, COBOL, CICS, IBM mainframe, TSO ISPF, and CASE tools.

Hire Now