Faizur Rahman

** ********* ********* ****, *********, NJ 08540

Email: adcujs@r.postjobfree.com; Phone: 732-***-****

SUMMARY

Goal-oriented Database Administrator with proven technical leadership and project management skills with experience in a high-profile and challenging corporate environment. I have extensively worked with key business and operation stakeholders, compliance, internal audit and regulators throughout the career.

• Extensively worked on SQL Server database Administrator, in with hands-on experience in installing, configuring, managing, monitoring, migrating and applying SQL Service Pack and troubleshooting SQL Server 2005 / 2008 / 2008 R2 /2012 /2014 / 2016 instances in Prod, UAT, Test and Dev environments

• Practice with implementing, configuring and troubleshooting in Standalone, Windows Active-Active and Active-Passive Clustering, Backup/Recovery, SQL Server Security, Replication, Log shipping, Mirroring and SQL server 2012/2014 AlwaysOn failover High Availability and Disaster Recovery solutions

• Knowledge in various ETL, Reporting and strong SQL coding skills with SSIS and SSRS

• Constantly involved in SQL Server T-SQL in construction in Triggers, Tables, Store Procedure, User Defined Functions, Views, Indexes, relational database models, and data integrity.

• Investigated and resolved the critical issues of significance including Query Performance Tuning and CPU, memory, IO bottleneck issues

• Provided technical support for various databases and applications to assure full operational conditions 24/7

• Solid understanding of Azure SQL DB and cloud computing service models (IaaS, PaaS, SaaS)

• Implemented large HA/DR Azure Cloud (Private & Public) environments for mission-critical applications using Express route and 24x7 monitoring using Microsoft Azure monitoring solution.

• Familiarity with IGNITE8, Red gate SQL Data Compare 10, SQL Backup7, Share Point, DB Artisan 7.2, 8.1.5, BMC. IDERA SQL Diagnostic Manager.

TECHNICAL SKILLS

● RDBMS: SQL Server 2005/2008/2008R2/2012/2014/2016, Sybase 11.0, 12.5, MySQL and Oracle

● Cloud: Microsoft Azure Cloud Computing Platform & Services

● Software: T-SQL, SQL, PL/SQL, IDERA SQL Diagnostic Manager, Solarwinds DPA, Red Gate SQL Backup7, Share Point, DB Artisan 7.2, BMC, SSIS, DTS. SSRS, Crystal Reports, Access, Performance Tuning, Capacity Planning, ODBC, JDBC, OLEDB, DTS, SSIS, SSRS

● OS: Win 2012/2008/2003/2000 Server/Windows 2000 Professional/ UNIX (Sun Solaris), Red Hat Linux

● Language: Windows Power shell, C+, COM+, Visual C++, .Net, HTML, SML, ASP, JSP, JavaScript, VB. EDUCATION AND CERTIFICATION

● Bachelor’s Degree in Electrical Engineering from New York Institute of Technology. NY

● Diploma in Relational Database Management, Bridge & Router from New York University. NY

● MS Certified Technology Specialist: (MCTS: SQL-Server 2008), MS Certified Professional (MCP)

● CISCO Certified Network Associate 2.0

● ITIL Certified

● Microsoft Azure Certified Architect (In progress) PROFESSIONAL EXPERIENCE

Kim Technologies Dec 2018- Present

Sr. SQL Database Administrator Bridgewater NJ

KIM is a Microsoft Azure-based a global, scalable and highly secure Platform-as-a-Service (PaaS) and SaaS solution provider to their client EY (Global) and Vodafone global (UK). As a Senior SQL DBA, my responsibilities include

• Installed, configured, upgrade and maintained SQL Servers 2014,2016 on Windows Server platforms.

• Implemented MS SQL Server replication and HADR solution for MSSQL using log shipping or SQL mirroring and AlwaysOn Availability Groups

• Performed database monitoring and tuning using DMVs, Perfmon, profiler, and other tools.

• Performed database refreshes of Development and QA databases.

• Worked with the application development team on production release deployments

• Deployments of SQLs server database schemas, SQL data compares and database contents with Redgate SQL compare SQL data compare and SQL change automation tools

• Created Public, Private Clouds based upon a special emphasis on Microsoft Azure PaaS offerings covering compute, VM, Storage, Networking, Middleware, API Managements, etc.

• Implemented large HA/DR Azure Cloud (Private & Public) environments for mission-critical applications

• Solid understanding of Azure SQL DB and cloud computing service models (IaaS, PaaS, SaaS)

• Proficient in using Microsoft Azure pricing calculators to forecast pricing, peak time usage pricing & future growth.

• Involved in SQL Server T-SQL scripts in construction Stored Procedure & User Defined Functions, Environment: MS Azure cloud VM. MS SQL Server 2012/2014/2016, Windows 2003/2008R2/2012/2016, TSQL, RED GATE SQL Data Compare to compare and Replication, AlwaysON, Mirroring, Clustering, PowerShell. T_SQL Scripts.

GS1 US, Inc. Nov 2017- Nov 2018

Sr. SQL Database Administrator Ewing, NJ

As a Sr. SQL Database Administrator at GS1US1 (www.gs1us.org), I was involved in more than 25 different In- house and Vendor application projects which demand 24/7 support. In addition to this, I was part of the MS Azure Dev team worked NOVA project to the Migration SQL database to cloud which at the time was the prime focus of the company's development initiatives.

Responsibilities Included:

SQL databases 2008R2, SQL 2012, Sql2014 to SQL 2016

• Hands-on experience in Install, Upgrade, Migration, Performance Tuning, Patching in all SQL Server 2008/2008R2, SQL2012/2014 and SQL Server 2016, etc.

• Troubleshoot day-to-day problems encountered on production databases and custom application issues

• Provided Expert level services as core SQL DBA, Performance Tuning, and backup/recovery

• Used DMV, SQL profiler, system monitor, query analyzer for troubleshooting, monitoring, optimization and tuning of SQL Server and SQL code and third-party software DPA (Ignite8)

• Developed automated daily, weekly and monthly system maintenance tasks such as database backup, database integrity verification, and indexing.

• Configuration and troubleshooting of Always-on availability on SQL server 2012/2014 and 2016

• Controlled and coordinated the installations (Security Patches, Service packs) and evaluated the performance before Pre-deployment.

• Used several azure cloud service models (IaaS, PaaS, SaaS) and proficient in using Microsoft Azure pricing calculators to forecast pricing, peak time usage pricing & future growth.

• Migrating On-premises SQL databases to Azure cloud VM and Azure SQL

• Configured and implemented detailed monitoring of the MS Azure cloud networks, monitoring all the different fabric of Azure.

• Developed SLA reports automating database monitoring using PowerShell and T_SQL scripts. Environment: MS Azure cloud VM. MS SQL Server 2012/2014/2016, Windows 2003/2008R2/2012/20.16, TSQL, Replication, AlwaysON, Mirroring, Clustering, SolarWinds DPA, PowerShell. T_SQL Scripts WellsFargo Bank May 2016- October 2017

Sr. SQL Database Administrator North Brunswick, NJ My main role in this project is to provide Production support at Wells Fargo wholesale Principal Investment Application and Migration project of SQL 2008/2008 to SQL 2014/ 2016 and Sybase to SQL 2016. These roles include but are not limited to are application support, Installing SQL Server, SQL Server Configuration, and giving updated advisor reports to the team for incompatible objects when the DB is moved to higher compatibility. This role requires constant interaction with customers such as Application Developers, Clients and other DBA's. This position is highly demanding therefore, it requires me to provide 24 x 7 Production Support. Responsibilities Included:

• Maintained a stable process of database refresh from production to internal

• 24 x 7 Production Support

• Responsible for regular database maintenance process and disk defrag procedures in Production and Nonproduction environments

• Used Performance Monitor/Profiler, trace flags to solve Dead Locks/Long-running queries using SQL DMV and third-party software IDERA SQL Diagnostic Manager.

• Developed automated daily, weekly and monthly system maintenance tasks such as database backup, database integrity verification, and indexing.

• Controlled and coordinated the installations (Security Patches, Service packs) and evaluated the performance before Pre-deployment.

• Configuration of Log shipping and Replication and Always-on availability

• Experience with PowerShell Scripting

• Configuration of Mirroring (Synchronous &Asynchronous)

• Provided strategic direction for the database team and functioned as the technical/project leader on projects.

• Automate database refresh on Dev from prod using PowerShell and T-SQL Scripts Environment: MS SQL Server 2008R2/2012/2014/2016, Windows 2003/2008R2/2012/2016, TSQL, RED GATE, AlwaysON, Mirroring, Clustering, and Log Shipping, PowerShell, T_SQL Scripts, IDERA SQL Diagnostic Manager.

IBM Global Technology Services (Collabra) Jan 2015- April 2016 SQL Server Database Administrator Mt. Laurel, NJ

Sr. SQL Server DBA at Raytheon’s Steady State Database operations managed SQL server 2008/2008R2/2012/2014 in production, QA and Developer database environments, including back-up, performance tuning, capacity planning, monitoring critical events and documentation

Responsibilities Included:

● Created and managed multiple databases and assisted incapacity planning

● Monitored, maintained database systems and troubleshoot problems that may arise

● Maintained data integrity and security (managed roles and permissions of database users)

● Generate traces, execution plans, identify performance issues, deadlocks/contention and resolve them

● Developed strategies and implement solutions for managing back-ups, restoration, and replication

● Supported software developers with database operations including the development of complex SQL, tuning of DML and the creation of stored procedures

● Effectively coordinated and communicated with all the stakeholders

● Involved in SQL Server T-SQL Scripts in construction Stored Procedure & User Defined Functions.

● Set up and maintained database infrastructure for the company’s Power BI needs Environment: MS SQL 2008/2008R2/2012/2014/2016, Windows 2003/2008R2/2012/2014, TSQL, AlwaysON, Mirroring, Clustering, and Log Shipping, PowerShell. S&P Capital IQ Jan 2013 – Dec 2014

Production SQL Server DBA New York, NY

Supporting the S&P CAPITAL IQ Production and Staging SQL Server (global) Databases over 12.3 TB size of the individual database The DBA team includes 20 DBAs (7 in the US, 13 in India). Support around 300 SQL Server instances with around 6000 databases, which include the following environments: Transactional replication, log shipping, mirroring with the standalone and clustered server. Includes SQL Server 2008/2008R2, and SQL Server 2012 Responsibilities Included:

● Implemented and maintained databases, perform software installations and upgrades, monitor database performance, perform capacity planning and SQL Server clustering, and manage database Quality Assurance including database consistency check

● Implemented and troubleshot in Performance tuning using Dynamic Management Views (DMVs) and System Catalog Views, Profiler and Server-side Traces, Windows Performances Monitor and built-in performance reports in SSMS, Query Plans, and Database Tuning Advisor

● Responsible for applying service pack and hotfix to all version of SQL Server

● Managed MSSQL Server (storage, memory, processing) and their dependencies and performance bottlenecks

● Responsible for maintaining database security, and high availability such as transactional replication, SQL Clustering, Log shipping

● Review/apply Stored Procedures, Triggers, and other TSQL code developed by developers

● Monitored and ensured Disaster Recovery for critical database

● Managed the granting of access to testing, development application, and system databases

● Implemented various automated scripts to monitor disk space, fragmentation, failed jobs step, backup and mirroring activities, and configured various job alerts for immediate notifications Environment: MS SQL 2008/2008R2/2012/2014/2016, Windows 2003/2008R2/2012/2014, TSQL, AlwaysON, Mirroring, Clustering, and Log Shipping, PowerShell. Aegis Media Jan 2012- Dec 2012

Production SQL Server DBA New York, NY

Responsibilities Included:

Supported the Aegis Media account within a team of 10 DBAs (6 are in India, 4 are in the US)

● Provided 24/7 support to SQL Server Production serves (MS dynamics financial systems) and Production Historical server for analytics systems

● Monitored strategies, processes, and procedures to ensure data integrity; optimized/reduced data redundancy; maintained the required level of security for all production and tested databases

● Extensive experience in SQL Query Performance tuning by Using Dynamic Management Views (DMVs) and System Catalog Views, Profiler and Server-side Traces, Windows Performance Monitor, built-in performance reports in SSMS, Query Plans, and Database Tuning Advisor to optimize the queries and enhance the performance of database servers for SQL Query Performance tuning

● Managed the granting of access to testing, development application, and system databases Environment: MS SQL 2005/2008/2008R2/2012, Windows 2003/2008R2/2, TSQL, Clustering. The Hartford Financial Services April 2011- Dec 2011 Production SQL Server DBA Hartford, CT

Responsibilities Included:

● Maintained databases, performed software installations, and upgrades monitored database performances, performed capacity planning, and SQL Server clustering, and managed database quality assurance including database consistency check

● Implemented various automated scripts to monitor disk space, fragmentation, failed jobs step, backup and mirroring activities, and configured various job alerts for immediate notifications

● Monitored database performance and rebuilt indexes on tables using various SQL Server commands to reduce fragmentation

● Performing backup and recovery tasks and restoring databases (when the database is moved from one environment to other or database is crashed and needs manual recovery)

● Provided 24X7 supports to SQL application developers on production servers Environment: MS SQL 2005/2008/2008R2/2012, Windows 2003/2008R2/2, TSQL Maimonides Medical Center Jan 2007 – March 2011

Production MS SQL Server DBA Brooklyn, NY

Responsibility:

Provided 24X7 supports for Database administration, deployments/upgrades, DR, patching

● Performed performance tuning using Dynamic Management Views (DMVs) and System Catalog Views, Profiler and Server-side Traces, Windows Performance Monitor, DBCC commands and in-built SQL tools like SQL Profiler, DTA (Database Engine Tuning Advisor)

● Implemented custom Maintenance jobs–scheduled to run daily and on weekends (tasks like rebuilding. Indexes, defragmenting Databases, Shrink Database, and Database complete backup)

● Migrated SQL Server 2000 to SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2

● Responsible for installing SQL Server on the new build Standalone and Clustered servers

● Disaster Recovery for the critical database with compliance for HIPPA

● Migrated DTS packages in SQL Server 2000 to SSIS of SQL Server 2005

● Environment: SQL Server 6.5/7.0/2000/2005/2008/2008 R2 Environment: MS SQL 2005/2008/2008R2/2012, Windows 2003/2008R2/2, TSQL

Contact this candidate