Description
20+ years of solid experience maintaining and developing business systems using Microsoft technologies. Experience covers all parts of Microsoft SQL Server 2016, 2014, 2012, 2008 R2, 2008, 2005 & 2000. All aspects and levels of SQL Server including Installation, configuration, performance monitoring and adjustment. Database design, modeling as well as development and deploying of different database objects including stored procedures, triggers, views, functions and constraints. Many years of Relational Database Management System (RDBMS) experience in different environments and ability to adapt to changing environments. Change management experience by deploying changes from Dev to Staging, QA and production instances. Self-motivated proactive a team player, able to manage own projects for on-time delivery. Experience providing 24/7 on-call support and leading severity calls. Experience with Reporting Server (SSRS), Services (SSIS), Installation, Administration and deploying. Monitoring, diagnosing problems, Perform Tuning/Optimization with SQL/T-SQL. Programming with T-SQL and working experience as a SQL Developer writing Stored-Procedures, Triggers, functions and debug/maintenance of existing code. Experience on Linked and Remote Servers to run queries between SQL servers and other data sources using ODBC, OLE DB drivers. Experience in Online Indexing, Query Optimization, Performance Tuning and Database Consistency Checks using DBCC commands & DMV getting metadata information. Experience in using SQL Profiler, Extended events and Windows Performance Monitor to resolve Dead Locks, blocking or long running queries and slow running server Knowledge of Redundant Array of Independent Disks [RAID] system and Clustering nodes. Good understanding in database and data warehousing concepts (OLTP & OLAP). Experience with logical and physical data modeling and database design using Erwin. Experience and Knowledge using Power shell managing both windows and SQL objects. Expert in customer service or clients support and coordinating a team. Have extensive work experience in Installing, Configuration & Maintenance of SQL Server 2016, 2014, 2012, 2008, 2008 R2 and 2005 on standalone and Clustered Servers [Active/Active and Active/Passive Design]. Performed successful migrations for any version of MS SQL Server. Experience with the phases Software Development Life Cycle [SDLC] such as requirement gathering & analysis, design, development, testing, implementation & maintenance in the Client/Server and web-based environments based on Functional Requirements Documents. Experience creating and maintaining SSIS packages using Visual studio, including deployments to SSISDB. Experience with Power BI creating Dashboards, reports and sharing information to the team. Expertise in supporting high transaction OLTP production environments consisting of multi-node clustered SQL instances and Log Shipping. Experience with SAP Basis module and SAP SQL server Databases. Extensive capacity planning experience, change management and keeping source code under control. Experience with tSQLt Database unit testing to create and maintain user test cases and validate proper objects are in place in the servers. Knowledge on Visual studio Development using C#, VB, XML, Business intelligence projects, Agile, scrums and code reviews working closely with Developers. Experience with SQL Server Performance Tuning, monitoring and using Brent Ozar Tools. Experience with Source control repositories and version control, branching, merging, deploying. ITIL Experience, Relational Database Design Experienced in Software Development Life Cycle
Education
| SCHOOL | MAJOR | YEAR | DEGREE |
|---|---|---|---|
| University of Phoenix | E-BUSINESS | 2005 | Master Degree |
Accomplishments
Highlights:
Job Skills
Keywords
