We provide IT Staff Augmentation Services!

Senior Sql Server Dba / Senior Systems Engineer Resume

Glenview, IL

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.

Hire Now