SUMMARY

• Currently seeking a challenging position to demonstrate my SQL Server, web, and systems administration experience while providing enterprise wide solutions that maintain a high degree of reliability while remaining flexible enough to promote rapid application development

TECHNICAL SKILLS

Software: Windows Server 4.0 to 2019, SQL Server 6.5 to 2019, SSIS, SSRS, IIS v4.0 to v8.0, Exchange Server, Jenkins, GitHub, Octopus, Artifactory, Windows Team Foundation Server, SharePoint, Citrix, Veritas NetBackup, Norton Utilities, InstallShield, Siebel Tools, Mercury TestDirector & Quality Center, Crystal Reports, Lotus Notes Server etc.

Languages: TSQL, PL/SQL, PowerShell, Groovy, HTML5, HTML, ASP, VB.NET, & JavaScript

PROFESSIONAL EXPERIENCE

Confidential

SQL Server DBA/Systems Administrator

Responsibilities:

• Responsible for all pre - production and production support for SQL Server clustered environments
• Setup and configured AlwaysOn high-availability protection on numerous SQL Server nodes
• Implemented Transparent Data Encryption (TDE) for sensitive data protection
• Designed and implemented numerous ETL processes from multiple sources to a data warehouses and other unified data repositories
• Deploy and manage infrastructure code using CI/CD pipeline tools such as Jenkins, Octopus Artifactory, and BuildkiteWork with FinOps teams to identify storage cost optimization recommendations
• Perform AWS cloud storage services (S3, EBS, multi-region replication, versioning, tiers, lifecycle)
• Perform data conversions between cloud providers such as AWS, Google Cloud Data Services
• Support AWS Systems Manager (Patch Manager, Sessions Manager, Software Distributor, Maintenance Window)
• Designed AWS Backup (Protection Groups, Schedules, Restores)
• Troubleshoot using SQL Profiler and Windows Reliability and Performance Monitor
• Participate in periodic HA / DR tests and other activities during off-hours
• Knowledge of execution plans, statistics, and reading plan diagrams
• Convert business requirements to system design
• Perform backup and recovery as needed for all Non-Prod & Prod environments
• Regularly ensure the integrity of SQL backups in all environments on a daily basis
• Developed, supported, and troubleshoot SSIS packages on regular basis
• Monitor and ensure SQL jobs complete, troubleshoot, and address failures in a timely manner
• Perform SQL production code changes both developers and myself develop while remaining SOX compliant
• Perform numerous database migrations from retired SQL clusters to new SQL high-availability layout
• Setup/develop SQL job tasks for various technical requirements
• Built, configured numerous Windows VMWare for development life cycle environment
• Performed numerous Windows 2003, 2008, 2012 & 2016 server migrations
• Built, migrated, and designed IIS infrastructure for all internal and external web applications
• Support 4 clustered, 4 node, IIS v6/7 web/app servers throughout the MPN and DMZ behind load balanced F5
• Implement firewall port access, and DNS changes as required
• Conducted first Confidential Business Continuity Planning disaster recovery simulation for Windows infrastructure
• Upgraded Biztalk 2016 Server to Biztalk 2017 Server provisioning BAM & EDI adapters
• Provisioned & administered multiple Exchange 2013/2010/2007/2003/2000/ & 5.5 servers in the enterprise
• Planed & implemented Entrust email encryption solution for enterprise HIPAA compliance
• Responsible for NetBackup upgrades for Windows server infrastructure

Confidential

Systems Engineer

Responsibilities:

• Provided SQL Server 2000 administration & backup recovery over 10 database clusters
• Performed & validated integrity of all system backups for disaster recovery testing
• Performed server monitoring & maintenance for high visibility database applications
• Responsible for testing & implementing code in DTS & SQL
• Responsible for understanding the architectural & detailed design aspects of client & vendor application
• Assisted in Design of R&D environments for product testing prior to rolling - out to production environment
• Assisted needs, troubleshooting &/or escalating problems to management
• Performed extra/off hours support as the service needs dictate
• Provided superior customer service for all internal & external customers

Confidential

Systems Engineer

Responsibilities:

• Technical group lead for application implementations and support, for all client server hardware/software
• Maintain and upgrade databases to provide stable and optimal database environment
• Organize and maintain version, script and data control for mission critical databases
• Responsible for providing RAID and replication strategies for disaster recovery and failsafe solutions
• Responsible for system configuration, maintenance, backups, and maintaining server health for 5 SQL servers
• Second line of support for 5 other SQL servers with various databases and applications
• Thoroughly test patches, service packs, and 3rd party tools such as Seagate BackUp Exec
• Responsible for security and administration of 6 IIS 5.0 WLBS clustered web servers
• Responsible for implementing SSL on IIS server for customer insurance enrollment website, containing credit card and other personal content
• Responsible for upgrading web servers from Windows NT Server 4.0 to Windows 2000 Server, and IIS4.0 to IIS 5.0

Confidential

Systems Engineer/DBA

Responsibilities:

• Traveled nationwide implementing and supporting Oracle 7.3.4, Oracle8i, SQL Server 6.5, 7.0, and 2000, for time and attendance database backend
• Responsible for rigorous database upgrade testing, before rolling out to client production environments
• Instrumental in working as a team with other DBA s, developing stored procedures and other related database structures for product enhancement
• Performed Oracle and SQL Server database implementations in multi Citrix Metaframe 1.8 Server Farms via LAN/ WAN, local/global domain
• Upgrades include version SQL Server 6.5 to 7.0, and 7.0 to 2000
• Responsible for implementation and support with IIS 4.0, and 5.0 clustered web servers hosting enhanced time and attendance applications
• Database consultant for application rewrites and product upgrades
• Implemented Windows platform Time and Attendance software applications, on NT and Novell Ethernet networks

Confidential

Network Administrator

Responsibilities:

• Supported 400+ Windows 3.x, Windows 95, Windows NT 4.0, Windows NT Server 4.0 and Unix operating systems.
• Developed, implemented and maintained multiple domain network connectivity and management plan
• Performed administration on 1 Windows NT 4.0 PDC and 2 BDC Servers, which supported over 400 client workstations on local domain.
• Setup and administrated Windows NT based DNS and WINS servers
• Supported network structures such as Ethernet, Fast Ethernet and Token Ring.
• Configured and implemented Cisco 1720 series router, for business internet access, replacing existing Ascend Pipe Line 50
• Developed and administration of security solutions for External Lotus Notes Email and Web Servers
• Built and administered WebSense Proxy Server for employee productivity, cost associated with increased bandwidth, and legal liability for the Internet content crossing LAN
• Implemented internal and external Compaq RAID 5, fault tolerant disaster recovery system with an automated enterprise tape backup solution
• Instrumental in the decision and implementation of upgrading 400+ computers to Windows NT 4.0 Workstations