TECHNICAL SKILLS:

• SQL Server 2016
• SQL Server 2014
• SQL Server 2012
• SQL Server 2008(R2)
• SQL Server 2005
• SQL Server Integration Services
• SQL Server Reporting Services

PROFESSIONAL EXPERIENCE:

Senior Database Administrator

Confidentia, Millington, TN

Responsibilities:

• Performed SQL Server 2014 and 2016 installations and upgrades including SSAS, SSIS, SSRS and FullText and Semantic Extractions components on virtualized Windows Server 2012 R2 servers. Employed RegGate SQL Monitor, SQL audits, triggers and database mail to monitor and report on DDL events, security changes and server health.
• Implemented Change Data Capture and SSIS packages to replicate data between environments without trust relationships.
• Created functions, stored procedures, and SQL Agent jobs to automate backups of availability group databases.
• Converted Integration Services solutions from package deployment to project deployment models.
• Redesigned SSIS projects, added error control logic, event handlers, variables and parameters, used for extracting, transforming and loading data between files, databases and DB2. Ensured consistency of certificates, SQL logins, server roles, database users and roles, linked servers and schemas across replicas participating in availability groups.
• Responded to and resolved performance, connectivity and permission issues using Extended Events, SQL Profiler and PerfMon.
• Fulfilled customer requests for data manipulation and complex querying.
• Advised and assisted development teams with relational database design and creation of schemas, tables, views, indexes, stored procedures and functions.

SQL Database Administrator

Confidential, Pocatello, ID

• Served as SQL server subject matter expert (SME) and mentor for DBA team members.
• Installed and configured SQL Server 2014 instances utilizing multi - subnet AlwaysOn High Availability spanning datacenters, Windows Server Failover Clustering and stand-alone servers.
• Migrated SQL cluster dependent drives between SANs.
• Implemented security controls pursuant to DISA’s SQL Server 2012 STIG.
• Administered SQL Server instances on virtualized Windows server platforms in different security enclaves.
• Assisted product support teams on application-specific database requirements.
• Responsible for administration and technical support in the development, testing, and production SQL Server environments.
• Created and modified reports using SQL Server Data Tools.
• Managed and delivered reports using SQL Server Reporting Services (SharePoint).
• Provided enterprise-wide support to resolve data integrity, performance, blocking, deadlocking, replication, access and connectivity issues.

Senior Systems Engineer

Confidential, Millington, TN

• Designed and implemented SQL Server 2012 solutions with instances that utilizes AlwaysOn Availability Groups with multiple secondary replicas and multi-node SQL Server failover clusters on Windows Server 2012 R2 platforms.
• Converted legacy DTS packages to SSIS packages and optimized data and control flows of existing SSIS packages.
• Assisted development teams with creation, modification and performance of stored procedures, user-defined functions, views and data element definitions.
• Monitored SQL Server 2008 instances in the production, test and development environments to ensure availability and optimal performance.
• Performed ad hoc data reporting and data manipulation as requested by customers.
• Updated or implemented error control logic in SQL Server Agent jobs.

Principal SQL Database Administrator

Confidential

• Conceptualized, designed and developed reports that consisted of spatial data overlaid with key data elements utilizing Business Intelligence Development Studio.
• Developed and automated the generation of analytical reports resulting in the command saving hundreds of man-hours a month.
• Deployed reports with SQL Server Reporting Services (Native) and made them viewable via SharePoint sites, web pages and as individual files.
• Performed the SQL Server administrative support tasks for SharePoint farm migrations.
• Responsible for administration and maintenance of SQL Server 2008 (R2) instances on the NIPR, SIPR and Centrix networks.
• Duties included creation of, and modifications to, databases, triggers, stored procedures and SSRS reports in collaboration with software developers.
• Performed ETL functions using a variety of Microsoft products and assisted end-users with ODBC procedures and reporting processes.
• Configured and maintained SQL database replication, mirroring and instance clustering, automated daily backup jobs, performed monitoring and troubleshooting tasks.
• Responsible for implementing and adhering to DoD security policies.

Senior Database Engineer

Confidential, North Charleston, SC

• Responsible for the administration of approximately one hundred instances of SQL server for the Bureau of Navy Medicine enterprise.
• The instances were of various editions, Windows Internal Databases, Express, Standard and Enterprise, in different configurations from stand-alone installs on physical servers to clustered instances on virtual servers.
• Standardized server and database maintenance procedures, jobs, tasks and reporting across the enterprise.
• Interpreted security policies directives and implemented DoD security recommendations, Security Technical Implementation Guides (STIGs), for SQL Server and the host operating systems.
• Ensured database high availability through installation, configuration and monitoring of SQL Server Failover Clustering, database mirroring and merge replication.
• Tasking included SQL Server installations, upgrades and patching, database management, server performance monitoring and maintenance.
• Responded to and resolved internal and external customer requests pertaining to all aspects of SQL Server administration.

Database Administrator

Confidential, Millington, TN

• Managed SQL Server 2008 and SQL Server 2005 installations on active-active clusters and standalone instances residing on virtual servers in production, test and development environments.
• Responsibilities included SQL Server installation, administration, database administration, testing and implementation of database and application upgrades, creating stored procedures and functions, performance monitoring and tuning, and documentation of processes and procedures.
• Develop and modify SSIS packages that extract, transform and load data from disparate sources.
• Migrated SQL Server 2000 instances to SQL Server 2005 virtual instances in a clustered environment.
• Upgraded SQL Server 2005 virtual instances to SQL Server 2008.
• Converted over a hundred DTS packages to Integration Services packages.
• Performed SQL Server Database Security Readiness Reviews and implemented Security Technical Implementation Guides recommendations.
• Configured and administered EMC CX4-480, CX3-80 storage arrays and RecoverPoint appliances and software.
• Maintained storage aspects of new server integrations, storage allocation, and change management.
• Performed project management functions relating to application development and deployment which required coordinating the support of web developers, networking engineers and system administrators.
• Performed network engineering and administration duties in a Windows 2003 environment hosting web-based and client-server applications.
• Responsible for disaster recovery processes, server and OS maintenance, troubleshooting of networking and OS issues, version upgrades, administration of third-party applications, upgrading hardware.

Systems Management Server Administrator

Confidential, Millington, TN

• Designed, maintained, and administrated SMS 2.0 servers and services for the purposes of remote technical support, software inventory and reporting, and software distribution.
• Performed SQL Server 7.0 administrative duties that included database maintenance, database backups and restores, and troubleshooting performance issues.
• Provided Windows 95, NT 4.0, 2000, and XP administrative and technical support for the customer and second tier technical support representatives.
• Performed Microsoft Exchange administrative support.
• Implemented and maintained Symantec System Center with Norton Antivirus Corporate Edition for virus protection and automatic virus definition updates.