Steve Bouffard Email & Phone Number

Hartford, Connecticut, United States

-Provides L3 MSSQL Operational Support-Manages team of offshore DBA's

Springfield, Massachusetts Area

Perform routine database administration tasks including backups, performance monitoring and troubleshooting. Initially identified and solved slow database performance. Performed security audits and offered recommendations and implemented solutions. Provide consulting services for database solutions and recommendations regarding design and architecture.

East Hartford, Connecticut

Production Database Administrator for over 100 databasesSizes range from under 100GB to several 100 GB, to 1TB databasesAdministered SQL Server 2000, 2005, 2012 and 2016 Enterprise databasesConverted SQL Server 2000 databases to SQL Server 2005, and 2005 to 2012Converted Oracle 8i databases to SQL Server 2005Install SQL Server on cluster serversManage change management from development to test, to production environmentsSQL Server replicationDatabase security and… Show more Production Database Administrator for over 100 databasesSizes range from under 100GB to several 100 GB, to 1TB databasesAdministered SQL Server 2000, 2005, 2012 and 2016 Enterprise databasesConverted SQL Server 2000 databases to SQL Server 2005, and 2005 to 2012Converted Oracle 8i databases to SQL Server 2005Install SQL Server on cluster serversManage change management from development to test, to production environmentsSQL Server replicationDatabase security and encryption technologiesUtilize Transparent Database Encryption for protecting “at rest” databasesColumn level encryption for sensitive dataSQL Server Integration Services (SSIS)Create packages for ETL between legacy mainframe files for input into SQL ServerCreate extract files from SQL Server to flat files for legacy mainframe uploadCreate extract files from SQL Server to flat file format for data customersCreated SFTP/FTP scripts utilizing WINSCP utilityDocumenting SQL Server databasesDocumented SQL coding standardsPerform security audits of production databasesWrite stored procedures and audit stored procedures, create triggers and all other database schemaEstablished “Always On” technology for the Judicial production databasesCurrently we are running 3 server nodes between 2 data center sites which ensures the Judicial database servers are always available to the customerMulti-Subnet FailoverDatabase servers have a 99 percent uptimeCreate database backup and recovery scripts and validate the integrity of the backupsMentor developers in SQL ServerMonitor production databases for security and performanceQuery and stored procedure tuningData ModelingServer hardware recommendations based on the performance of the applicationsSQL Server Profiler tracingMember of the Standards and Architecture committeeMember of the Security CommitteeResponsibilities include researching threats specific to database systemsDiscuss possible vulnerabilities and attack vectors for databases Show less

Remote

-Responsible for installing custom software and creating backup solutions for clients-Troubleshooting MS SQL Server connection issues

East Hartford, Ct

Application development for legacy VMS COBOL systems, as well as coding in VB.net and ASP.net languages.

Columbus, Mississippi

Provided air traffic control services for military and civilian aircraft as a Radar Approach Controller. Air Traffic Control instructor for radar approach control. Air Traffic Control Watch Supervisor which included overall supervisory duties of 20 air traffic controllers and the airspace.

Limestone, Maine

Operated the fire control system of the Air Force B-52G aircraft.

Bachelor Of Science, Business Administration, Management Information Systems, General

Associate’S Degree, Airway Science