SUMMARY:

• Results - driven software professional with a demonstrated ability to successfully architect and implement complex large-scale, N-tier, distributed, real-time Database Environment.
• Outstanding track record of driving the project to success through various phases of Software Development Life Cycle.
• Deep desire to solve problems with persistence and pays meticulous attention to details.
• Over 8 years of IT experience with Database Administration on MS SQL SERVER 2016/2014/2012/2008 R2/2005 in Production, Development and Testing Environments.
• Hands-on experience with Installation/Troubleshooting, Managing and Configuration of MS SQL Server 2016/2012/2008 R2/2008/2005 on Windows 2016/2012/2008 server.
• Upgraded and Migrated MS SQL Serve in Microsoft Azure Cloud (IaaS) and PaaS
• Exposure in managing Microsoft Azure cloud (IaaS) and (PaaS)
• Implemented AlwaysOn availability groups on MS SQL Server 2016/2012 Expert in creating Microsoft Active/Active and Active/Passive clusters.
• Sound experience in Implementing Mirroring and Log Shipping for DR
• Implemented Transactional and Snapshot replication and resolved latency problems
• Expert in troubleshooting and resolving performance bottlenecks and problems
• Expert in using SQL Server latest DMV’s for performance and maintenance
• Maintained databases with sizes ranging from Large to Very Large Databases (terabytes).
• Strong experience with T-SQL, Stored Procedures, Functions and Excel macros
• Excellent Experience in Managing Security through Logins, Users, Permissions, Certificates, Credentials, Encryption Schemes per Company’s Security Policies
• Extensive knowledge with Backups, Restoration and Disaster Recovery Planning.
• Extensive experience in developing Stored Procedures, Views, Triggers, and Complex Queries on SQL Server 2016/2014/2012/2008 R2.
• Experience in Upgrading of SQL Server from version 2008/2008R2 to 2014/2016
• Highly Proficient in migration of Databases, packages and Job activities from MS SQL Server 2008/2008 R2 to SQL Server 2016/2014/2012 and also migrating the database from development to production and migrate the data between the databases.
• Excellent knowledge of Database concepts such as Entity-Relationship Modeling, Transactional Management, Normalization, Indexes etc.
• Active/Active and Active/Passive cluster.
• Experience in Constructing Server Baselines and Performance Tuning using tools like Windows System Monitor, SQL Profiler, DMV's, and SQL Query Analyzer and performed Query Optimization.
• Hands-on experience with SSIS (SQL server Integrated Services), SSRS (SQL server Reporting Services).
• Experience in designing & implementing high availability, clustering, log shipping and/or mirroring standby, large database management, and partitioning.
• Automated Database Consistency Checks, Fragmentation checks and Index Reorganization/Rebuilding Operations.
• Hands on experience in creating database maintenance plans monitored the jobs by generating alerts to be sent to the operators via email & Pager notifications using SQL Server Agent.
• Eliminated DB access bottleneck to significantly improve response time to client queries.
• Team player with solid documentation skills

TECHNICAL SKILLS:

• Windows Server 2016/2012/2008 R2
• MS SQL Server 2016/2014/2012/2008 R2/2008
• Enterprise Manager
• Query Analyzer
• Oracle 10g/11i
• DTS
• MS SQL SSRS
• SSAS
• SSIS
• SQL Profiler
• ASP.Net 2.0
• SQL
• PL/SQL
• Visual Studio 2012/2008
• Microsoft Azure (IAAS)
• Microsoft Azure (PAAS)
• Amazon AWS
• T-SQL
• ERWIN
• Database Modeling
• Microsoft VISIO
• IDERA SQL Diagnostic Manager
• SQL Litespeed
• IDERA
• Lumigent Log Explorer
• Dell PowerEdge
• HP Blade
• VMware.

PROFESSIONAL EXPERIENCE

Confidential, Tampa, FL

MS SQL Server DBA

Responsibilities:

• Managed 100+ Servers in clustered, mirrored and replicated environments and worked on all production issues
• Managed servers in Microsoft Azure (IAAS) cloud and Amazon EC2 instances
• Worked on Implementing SQL Server 2016/2014/2012 on Production, Dev and UAT environments.
• Installed and configured Windows Servers and configured Domains and AD on Windows environment Worked on Advanced level T-SQL programming, creating stored procedures, views and UDF’s
• Implemented AlwaysON with Sync and Asyn configuration.
• Implemented AlwaysON availability groups with replicas for reporting/backups/HA on SQL Server 2016/2012
• Develop, design, configure and document database architecture, including software, hardware and physical layout (processor configurations, data file layouts)
• Standardize and perform best practice database troubleshooting
• Implement risk management practices to mitigate data corruption Perform backup and disaster recovery
• Worked on SQL Server 2014 DEV, QA, UAT and Prod.
• Administer, configure and maintain various types of data replication in particular AlwaysOn
• Manage distributed databases, SSIS packages and SSRS
• Participate in functional, performance and security testing
• Assist developers and end users with implementation best practices
• Coordinate by/between intra-city stakeholders on special technology projects (cross-functional) Maintain/administer/tune program databases (built in Microsoft Access and SQL)
• Develop and conduct staff trainings on program databases and tracking tools Provide ongoing database technical support to DHS and OIT staff as needed Maintain quality control and data cross checks of databases
• Test logical input, processing and output scenarios in the database design
• Analyze data using available statistical software to support, guide and evaluate DHS strategic planning and community-based efforts
• Present and report public health data and research findings to community leaders, key stakeholders and residents
• Perform other tasks based on Client’s needs, including literature reviews and policy scans

Confidential, Raton, FL

SQL Server DBA

Responsibilities:

• Worked on managing and supporting MS SQL Server 2014/2012 instances in production environment
• Actively worked on supporting AlwaysOn Availability group environment for HA Experienced in working on Deployment of Packages.
• Worked on Microsoft Azure (IAAS) service/portal to migrate on-premise database servers. Worked on applying Service Packs for clustered environments
• Experienced and Worked on Red Gate synch Process and Schema Compare.
• Used Light Speed for Backup and Restore Process.
• Worked on Implementing SQL Server 2012/2014 on Production, Dev and UAT environments.
• Upgraded and Migrated SQL Server 2005/2008R2 to SQL Server 2014.
• Experienced on UAT environment for testing queries to make sure they work appropriately based upon user request.
• Worked on setting up Training Environment for Trainers and setting up Refresh Jobs with new Data from Dev.
• Worked on Setting up SQL jobs to be run on Schedule Time.
• Worked on DELPHIX Data Tool to set up Virtual Databases to save memory on Physical Server and increase the Performance.
• Worked on Security for setting up User and AD Groups Access issues.
• Running DBCC consistency check, and fixing data corruption in user databases.
• Experience on working on DR of Lost Databases.
• Worked on Setting up Standalone and Clustered Environment.
• Tuning Queries and Database performance using tools like SQL Server Tuning Advisor & SQL Server Profiler.
• Hands on Experience working on APEX SQL for performance of data, Auditing, Recovery, Monitoring & Administration.
• Hands on Experience working on Attunity Tool for Replication.
• Experience working on Altiris and IBM RQMS Ticketing Tools.

Environment: Windows 2012/2008 R2, AlwaysOn, Clustering, Mirroring, VMWare, SAN, MS SQL Server 2012/2008 R2/2005, T-SQL, SSMA, IDera SQL Safe backup, IDera Diagnostic Manager and other IDera tools, SSIS, SSRS, VB Script Performance Monitor, SQL Profiler.

Confidential, New York, NY

MS SQL Server DBA

Responsibilities:

• Provided 24/7 production support on a rotating roster schedule
• Good exposure on Cluster environment servers, to failover/failback (Automatic/Forced) to the cluster nodes.
• Designed and implemented backups/restore strategies for point in time recovery purposes Used Idera SQL Safe backup tool to backup databases
• Used Redgate Search engine to compare and Deploy scripts Performed Builds and Release.
• Used Performance Monitor and SQL Server Profiler to optimize long running queries and improved the performance of the Queries
• Worked extensively on Database space management, performance monitoring and alert management.
• Managing Security of SQL Server Databases by creating Database Users, Roles and assigning proper permissions
• Involved in development of automated daily, weekly and monthly system maintenance.
• Created Jobs and scheduled jobs according to the requirements
• Monitored the jobs by generating alerts to be sent to the operators via email & Pager notifications using SQL Server Agent
• Worked with different teams (Off shore) to deploy projects to UAT (Testing), Development, and Production environments.
• Monitoring SQL Server Instances with IDERA diagnostic Manager
• Evaluating SQL Scripts of Developers and Build the Test Environments as Dupes of Prod ENV.
• Installation of SQL server 2005,2008R2 on development and testing environments Used Bug Tracker to solve the Errors.
• Migrating SQL Server 2000/2005 7.0 databases to SQL Server 2005 and then to 2008R2.
• Hands on Experience on Serena Business Tool for Tickets
• Extremely effective communication and presentation skills across all levels in the organization
• Worked with Powershell Scripts to Run Test Builds on Test Servers and Release on Production Servers.
• Created Custom Jobs for certain DML and DDL Scripts

Environment: Windows 2008 R2/2003/2000 Server, VMWare, SAN, MS SQL Server 2012/2008 R2/2005, T-SQL, SSMA, IDera SQL Safe backup, IDera Diagnostic Manager and other IDera tools, SSIS, SSRS, VB Script Performance Monitor, SQL Profiler.

Confidential, Warren, NJ

MS SQL Server DBA

Responsibilities:

• Provided 24/7 production support on a rotating roster schedule.
• Worked extensively on VMware and Virtual instances of MS SQL Server
• Worked extensively with writing T-SQL, Stored Procedure, Functions, Views, Triggers and Excel Macros
• Implemented SQL Server 2008R2 Active/Active cluster setup on Windows 2008 R2 servers.
• Implemented SQL Server 2012 on Development and QA Environment
• Good exposure on Cluster environment servers, to failover/failback (Automatic/Forced) to the cluster nodes.
• Configured and Monitored MS SQL Server 2008 R2 in Log Shipping for Disaster Recovery.
• Installed and configured SQL Server 2008R2 with Service Packs in UAT, Development & Production environments
• Worked with SAN Technology and SAN boxes.
• Created Maintenance Plans for checking database integrity, rebuilding indexes and updating statistics.
• Designed and implemented high level backups/restore strategies for point in time recovery purposes.
• Used Idera SQL Safe backup tool to backup databases.
• Used Performance Monitor and SQL Server Profiler to optimize long running queries and improved the performance of the queries.
• Worked with different teams to deploy projects to UAT (Testing), Development, and Production environments.
• Migrating SQL Server 2005/2008 databases to SQL Server 2012.
• Created solid ETL packages with SSIS using various transformations, sources and destinations Created packages in SSIS with solid error handling, logging and error re-direction
• Used VB Scripting in SSIS transformations
• Deployed SSIS packages from one server to another and scheduled the packages for automation Created heavy duty reports with SSRS, parameterized and drill down reports
• Configured SSRS report server

Environment: Windows 2012/2008 R2/2003 Server, VMWare, MS SQL Server 201/2008 R2, Business Intelligence Development Studio, IDera SQL Safe backup, IDera Diagnostic Manager and other IDera tools, DTS, SSIS, SSRS, VB Script Performance Monitor, SQL Profiler.