Objective

A distinguished leader seeking opportunity in Information Technology including Development & Administration of Software & Systems Engineering, Database Administration, Business Intelligence, Data Integration, and process management with expertise in diverse range of Computer Science & Technologies within multiple industry settings.

Career Highlights

Over 10 yrs. of combined management experience in App & DB Development along with Project Management including Vendor Management & Remote Resource Management.

Interfaced with third party vendors, outsourced work model, managed offshore-onshore model

Managed and optimized multi-cultural teams with diverse background in various product suites, with team size of around 5 to 10 including employees, contractors, and support vendors.

Conducted product training for client users and internal team members through career and self-improvement guidance.

Experience

Capital Staffing Solutions/FIS, Sunrise, FL 11/17/2017 – 06/17/2022

Lead Senior SQL Server DBA

Provide regular updates to management on database project status.

Upgraded/Migrated SQL Server instances/Databases from older version SQL Server to recent version of SQL Server like 2008/2008R2, 2012 and 2014 to 2016, 2017, 2019.

Deployed and restored database including point in Time Recovery.

Applied SP (Service Park)/Hot Fixes on SQL Server instances to address security and upgraded related issues.

Experience in Always On environment.

Configured and Maintained Replications, Log Shipping, and Mirroring for high Availability.

Performed database and SQL/TSQL Performing tuning.

Maintain and monitor High-Availability of SQL Server Database clusters between production and disaster recovery (DR) environments.

Installed, configured, and Maintained SQL Server 2019, 2017, 2016, 2014, 2012 and 2008/2008R2 in development, test, and production environments. Identify and resolve database issues related to performance and capacity.

Maintained server and database security including database encryption (TDE).

Setup jobs, Maintenance plans for backups, Rebuilding Indexes, check server health, alert, notifications.

Created and managed diverse types of indexes (Cluster/ Non-Cluster), Constraints (Unique/Check).

Experience with Troubleshooting, performance tuning,and automation set up for SQL Server.

Used imp/exp. Tool to export & Import data from various sources like SQL Server Database, Flat file, CSV, Excel, and many other data sources supports ODBC, OLE DB Data Source.

Oversee day-to-day activities of database team.

Perform regular audits to ensure data integrity and quality.

Monitor Server Activity, error log, space usage and solving problem as needed.

Provides troubleshooting and support, including on-call rotation, after-hours support.

City Of Deerfield Beach, Deerfield, FL 01/17/2016 -11/17/2017

Senior SQL Server DBA

Administer MS SQL Server 2008/2008R2/2012/2014 instances

Maintains database by identifying and solving database requirements; supporting users; experience in 24x7 production environment.

Responsible for providing day-to-day activities, including, but not limited to; backup, restore, performance tuning, security management, capacity planning, standards development, and enforcement. •

Design support structure for the database infrastructure, including systems architecture, monitoring, documentation, policies and procedures, best practices, and support automation.

Maintain database performance by calculating optimum values for database parameters; implementing new releases; completing maintenance requirements; evaluating computer operating systems and hardware products.

Develop and maintain an in depth understanding of the database architecture and the typical application functionality used to maintain data integrity of the database

Provide database assistance and problem support to application developers, business analysts and business users.

Knowledge on backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication.

Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.

Complete platform upgrades, migrations, quarterly patching, monitor performance, and coordinate actions with team members.

Support the integration of the One Solution (ERP) application with SunGard Help to a successful project.

Maintain SSIS packages to support ETL processes.

Manage and implementing a project for Disaster Recovery for both iSeries (AS400) and SQL Server by using NOMAX and Log shipping.

JardenCS, Boca Raton, FL 2014-07 - 2015-12

Lead Senior SQL Server DBA

Manage and implementing a project for Disaster Recovery for both iSeries (AS400) and SQL Server by using NOMAX and Log shipping.

Designed and built a new Data Center to move all the database servers that were being hosted by a third-party vendor to the in-house Infrastructure.

Supervised or mentor Development Staff in the use of the database or the construction of database objects for optimal performance (i.e., Stored Procedures, Tables, and Triggers etc.)

• Implemented high availability DB options like Clustering (Active/Passive) and Replication (Transactional and Snapshot) after the move to the new data center.

Performed Database Migration from SQL Server 2000,2005 to 2008 R2 and 2012 as part of the data center move.

Installed, Configured and Maintained many database servers of various versions like SQL Server 2000, 2005, 2008R2 and 2012 for both external and internal applications.

Performed many patching exercises on both stand-alone servers as well as clustered servers in a rolling failover fashion Reviews requirements developed by Business.

Provided Guidance and troubleshooting capabilities in performance turning, security and other best practices implementation to various application teams.

Planned and Implemented a Comprehensive Monitoring Mechanism for all the SQL Server DB Servers by employing and deploying Quest Fog light Tool as a Central Repository Developed Templates and Implemented comprehensive Maintenance plans for backup, re-indexing, dB health check, updating of statistics for a variety of both Prod and Non-Prod DB Servers.

Performed many patching exercises on both stand-alone servers as well as clustered servers in a rolling failover fashion Reviews requirements developed by Business.

ITT Corporation, Morton Grove, IL 2008-03 - 2013-04

Lead Senior SQL Server DBA

Manage Oracle database administration, SQL Server, and Sybase assignments for ITT Corporation.

Enhance database performance, perform restores, implement recovery procedures, oversee performance tuning, and conduct regular system backups.

Served as DBA or project lead in the completion of several medium-to-large scale implementations, managing projects from business requirements analysis to solutions delivery and support.

Managed database security, creating and assigning appropriate roles and privileges to users depending on the user activity.

Managed and resolved design issues during development stage.

Worked closely with developers. • Installed, upgraded, and patched Oracle, SQL, and Sybase software and associated applications.

Planned, installed, configured, and administered multiple Oracle databases in a Windows NT/2000/XP and Sun Solaris UNIX environment.

Experience with database performance tuning, Query optimization, client/server connectivity and other network issues, database consistency checks using DBCC.

Implemented disaster recovery techniques including mirroring and log shipping. • Knowledge of SQL Server tools including Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs and system stored procedures.

Knowledge of SQL Server tools including Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs and system stored procedures.

GE Medical Systems, Barrington, IL 1998-06 - 2008-03

Global Customer Support Engineer

Responsible for integrating and validating Cloverleaf (RIS/HIS (HL7) standard interface with GEPACS.

Utilized cutting-edge technology including RAID, NAS, Sybase, file modes, DICOM standards, J2EE, high availability systems, replication, client-server and web-based applications, server clustering and security in a Windows 2000 / Macintosh / Solaris environment.

Installed, configured, maintained, troubleshooted and tuned SQL Server databases.

Responsible for all aspects of UNIX administrator including hardware and software (Unix Disk management tools specially LVM and VERITAS) for GE Medical Systems.

Administered, supported and troubleshooted all UNIX systems inclusive of Linux (Red Hat) HP-UX, VMS, and AIX.

Performed database installation and configuration, SQL optimization and performance tuning resulting in 40% increase in performance for USA and Europe sites.

Remotely supported users of MS ACCESS, MS EXCEL, RDBMS, SAP, SQL SERVER and MS Windows desktop and server environments.

Troubleshooted system, database, and network problems across a wide range of platforms and various implementations including HP/UX, Solaris, Linux, and Windows systems.

Saved thousands in installation fees by upgrading hardware on HP 9000 for GEMS IT included installing new CPUs, memory, SCSI controllers and disk arrays.

Monitored, analyzed, and tuned database performance to comply with service level agreements.

Moved several mission-critical applications from mainframe environments to client/server systems and ensured that the new application met the performance requirements.

Managed and supported business processes that maximized competitiveness and quality to provide business growth.

Responsible for supporting global installation of Centricity RA600, Archive and Web Server products.

Installed and configured Web Server including (IIS) and Apache, utilizing workflow system.

Utilized metrics and Six Sigma tools to evaluate performance and implement measurable changes.

Completed a Six Sigma project that formally defined an automated test process that incorporated the use of Win Runner and provided productivity improvements that saved over $100,000 dollars per year.

Education

Master of Information Technology Professional in Information Technology

Northwestern University - Evanston, IL 2002-10 - 2004-06

Bachelor of Science in Electronics Engineering Technology

DeVry University - Chicago, IL 1990-10 - 1994-06

REFERENCES

Available Upon Request

Contact this candidate