SUMMARY

• Senior Database Administrator with over 20 years of experience in data architecture, database design,
• Infrastructure, implementation and management. Key assets include team leadership experience, excellent analytical skills and creative problem - solving skills. Repeated success in full development cycle of SQL
• Server and Oracle database solutions, Network Administration.

TECHNICAL SKILLS

Operating systems: Windows 2008 R2, 2012 R2.

Data Architecture / Development tools: MS SQL Enterprise Manager Tools and Visual Studio, TOAD, ER/Studio, ERWin, Visio, Shell scripting.

Monitoring and Backup: QUEST FogLight, Solar Winds - IGNITE, SQLSentry, RedGate (SQL ToolBelt), IDERA, LiteSpeed and RMAN.

PROFESSIONAL EXPERIENCE

Confidential, Glenview, IL

Senior SQL Server DBA / Senior Systems Engineer

Responsibilities:

• Designed, implemented and administered global Datacenters, Amazon and Microsoft Clouds.
• Administered network security on Windows AD and MS SQL Server.
• Performed (internal and external) environment security audits for government compliance requirements.
• Built and managed Clustered SQL Server 2012/2014 environment for worldwide use with High Availability.
• Upgraded existing server installations to Microsoft SQL Server 2012/2014 with High Availability.
• Implemented data partitioning and sharding, setup required maintenance plans for recovery.
• Implemented Disaster Recovery sites at the remote countries via Replication and Log Shipping to DC.
• Setup and configured Reporting Services on all of the servers for audit and documentation.
• Managed SharePoint installation and multi-farm administration.
• Setup weekly reporting for system health, audit of users and user groups, network resources and database access.
• Compiled library of standards and procedures for environment design, infrastructure, development and implementation proceedures.

Confidential, Northbrook, IL

Data Architect / Senior SQL Server & Oracle DBA

Responsibilities:

• Designed and implemented multi-vendor database solutions on Local DC and Microsoft Cloud.
• Upgrade of existing server to VM/Clustered environments on SQL Server 2012/2014 with High Availability.
• Data Recovery site Solution - built at remote data center on SQL Server 2014 with High Availability.
• Logical and Physical design and implementation of the required hardware and software resources.
• Upgraded Central Monitoring server, installed and configured FogLight by QUEST for Network and Database servers monitoring.
• Performed an internal/external security audit on multiple servers and installations to raise the level of security and accommodate AUDIT requirements.
• Performance tuning and code review with application development team. Provided feedback to code changes and documented standards to which the development must follow.

Confidential, Des Plaines, IL

Data Architect / Senior SQL Server & Oracle DBA

Responsibilities:

• Analyzed processes and existing services, examined object models and worked closely with business partners to identify hardware/software and data change requirements for future expansion.
• Planned and build a central monitoring server for Enterprise. Installed and configured FogLight (QUEST) network and database alerts. Setup regular system audits and reporting.
• Created a logical data model that represented the environment and proposed changes that will improve processing (ER/Studio and VISIO).
• Created workable solutions and applied inventive ideas to complex problems. Proposed standards for physical data elements, object names and query writing T-SQL based on Microsoft suggestions and business proven standards by using correct data type and definition/logic for every attribute.
• Automated processing of database schema updates and changes required by the business life cycle.

Confidential, Glenview, IL

Data Architect / Senior SQL Server & Oracle DBA

Responsibilities:

• Data Architecture review, Project Management and coordinating resources within the team.
• Proposed and built new and improved database structures and enforced standards.
• Planning, building and implementing new SQL Server and Oracle Clustered environments.
• Server builds and configuration of OS, SQL Server or Oracle software with required packages.
• Implementing user access security, setup monitoring software, maintenance procedures and backup schedules. Production support and performance Monitoring.
• Built centralized monitoring server for Network/Database Servers monitoring (QUEST FogLight)
• POC - Research, design and testing of new hardware and products for new environment.
• Acted as a liaison for Development, Testing and QA of pre-production release.

Confidential, Lincolnshire, IL

Data Architect / Senior SQL Server & Oracle DBA - Team Lead

Responsibilities:

• Planned and upgraded existing installations to SQL Server 2012 (Clustered Environment on VM).
• Active Directory integration of domain groups and users on all databases servers for single sign-on. User and group access audit to accommodate for Statement on Auditing Standards (SAS) No.70.
• Logical and Physical design and implementation of the hardware and software on new server installs.
• Data Recovery site implementation at the remote data center via Replication and automated process cycle for environment refreshes.
• FogLight by QUEST setup for centralized monitoring (Network and Database servers).
• Server performance monitoring uncovered issues that required changes to be made and were successfully implemented that resulted in performance increase by 30-40%.
• Projects Completed: Confidential Long Term Care, Disaster Recovery and TAX department and Human Resources databases on single multi-terabyte SAN storage, Data Warehouse.

Confidential

Data Architect / Senior SQL Server DBA/Team Manager

Responsibilities:

• Audit of current database server installation and configuration. Suggested modification plan for improvement.
• Upgraded existing and environment with New server builds to replace existing setup that are no longer supporting the business requirements and SLA's.
• Automated Maintenance and Backup operations. Setup Performance Monitoring and reporting.
• Planned and setup the data Replication, Transaction Log Shipping for inter-state data exchange on multiple servers and locations throughout US as well as Data Recovery center.

Confidential

Data Architect / Senior SQL Server /ORACLE DBA

Responsibilities:

• Server Builds and Upgrades of existing installations of SQL Server and Oracle packages.
• Database logical and physical design, implementation using Visio/ER Studio and server management.
• Performance monitoring, tuning and database optimization providing technical support and guidance to developers and end users.
• Setup and configured database maintenance procedures and data processing jobs on a schedule.
• Automating Data exchange with the clients through secure FTP servers (loads/extracts), Replication and Log Shipping to DR data centers.
• Data warehouse project with logical and physical design and implementation.