Data Sql Server

Mohammad Kabir

*********@*****.***

Phone -571-***-****

Summary of Qualifications:

SQL Server Database Administrator having more than 5 (Five) years of professional experience in different Microsoft products as a SQL Server DBA. Solid working experience in troubleshooting, designing databases, disaster recovery, HA solutions, developing reports and SSIS packages, Database upgrade/migration, proactive monitoring, performance tuning, SQL/TSQL queries, and handling complex production issues. Experience in Performance Tuning, Index Tuning, Execution Plan, Query Optimization, Reports, Backup, and Disaster Recovery. Proven ability to identify the root cause of database issues with the expertise to troubleshoot and resolve issues promptly. Strong knowledge of SQL server upgrades and migrations using various versions and editions. Expertise also includes high proficiency in using third-party tools like Toad Data Modeler, Erwin, RedGate, Solar Winds, and SQL Sentry. Strong business and technical vision with effective people skills, ability to manage multiple complex projects, innovative and creative problem solver, results-oriented, and has an aptitude for learning and can maximize resources while possessing a sense of urgency. Strong Communication & Management skills and Excellent Team player.

Technical Proficiencies:

Operating Systems

Windows Server- 2016/ 2012 /2008R2 /2003R2, VMware.

Database

MS SQL Server- 2017/2016/2014/2012/2008R2/2005, MS Access, Oracle, MySQL.

SQL Server Tools

SSMS, Query Analyzer, Performance Monitor, SQL Server Profiler/Extended Events, BIDS/Data Tools, Database Tuning Advisor, SSIS, SQL Server Configuration Manager, Activity Monitor, Job Activity Monitor, Execution Plan, DMVs, DMFs, DBCC, Index Tuning Advisor.

Data Modeling Tools

Erwin, Toad Data Modeler, SSDD (SQL Server Database Diagram).

Reporting Tools

SSRS, Report Builder.

Data Migration

SQL Server to SQL Server, Oracle to SQL Server, MySQL to SQL Server, and MS Access/Excel to SQL Server.

Networking

TCP/IP, DNS, WAN, LAN.

Hardware/Storage

SAN, RAID, iSCSI.

ETL/Data Warehouse Tools

DTS, SSIS, BCP, Import/Export Wizard.

Third-Party Tools

Toad Data Modeler, RedGate, SolarWinds, SQL Sentry. Ticketing System- Remedy, ServiceNow, Jira

Certification:

CompTIA Security+ Certified.

MCSE (Microsoft Certified Solutions Expert): Data Management and Analytics.

MCSA (Microsoft Certified Solutions Associate): SQL 2016 Database Administration.

MCSA (Microsoft Certified Solutions Associate): SQL Server 2012/2014.

Querying Microsoft SQL Server 2012/2014.

Administering Microsoft SQL Server 2012/2014.

Implementing a Data Warehouse with Microsoft SQL Server 2012/2014.

Developing Microsoft SQL Server Databases 2012/2014

Administering a SQL Database Infrastructure-2016.

Provisioning SQL Database-2016.

Education:

Master of Arts (MA).

Master of Education (MEd).

Bachelor of Computer Science & Engineering.

Legal Status :

US Citizen.

Security Clearance:

Clearable.

Summary of Expertise :

Strong working experience as a Database Administrator in installing, upgrading, patching, administrating, and maintaining Microsoft SQL Server 2016/2014/2012/2008R2/2008/2005 database Server in Production, Test, and Development environments.

Proactively monitoring and troubleshooting database issues and making tuning adjustments to ensure database integrity, security, and system performance.

Proficient in performance tuning of T-SQL queries, stored procedures, and debugging the poorly written code and helping application teams.

Proven experience in monitoring, troubleshooting, optimizing, and tuning lock, block, deadlock, index fragmentation, slow running queries, etc. using native and third-party tools.

Highly proficient in database Backup, Restore, Point-in-Time Recovery, Linked servers, and Database Maintenance Plans.

Expertise in RDBM concepts and constructs. Working with data modelers on logical and physical data modeling, DBAs/Developers in implementing and updating physical data models in databases.

Proficient in writing T-SQL Queries and developing Indexes, Stored Procedures, User Defined Functions, CTEs, Triggers, SQL Joins, Views, Cursors, Table Variables, and Sub-queries.

Experience of Upgrading and migration from an earlier version of SQL Server to SQL Server 2014/2012 in different environments.

Solid experience in implementing, configuring, monitoring, and administering high availability and Disaster Recovery Solutions (Log Shipping, Mirroring, Replication, SQL Server Clustering, and Always On Availability Groups).

Extensive work experience in TempDB configuration, shrinking, compression, and database optimization.

Strong knowledge and experience in capacity planning and implementing disaster recovery solutions-database Backup, Restore, Point-in-Time Recovery by RTO and RPO guidelines.

Good experience in configuring Database mail and automation of administrative tasks such as Maintenance plans, Jobs, and Alerts using SQL Server Agent.

Extensive work experience in applying the latest Service Packs, patch, and hotfixes.

Adequate knowledge of configuring, administering, and maintaining SQL Server Reporting Services (SSRS).

Good experience with the phases of 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.

Maintain database and application documentation, including data standards, procedures, definitions for the data dictionary, logical and physical models of the databases.

Expertise in need assessment, logical/physical database design, reverse/forward engineering using Erwin, and native tools.

Experienced in implementing SQL Server security, Managing users, granting/revoking access, encryption, TDE, data masking, auditing, and monitoring to comply with Microsoft and industry best practices.

Responsible for developing and implementing SSIS Solutions and Configuring, Deploying, and Maintaining SSIS.

Strong Skills in ETL operations using SSDT/BIDS, SSIS, BCP, Import/Export Wizard.

Expert in utilizing different Monitoring tools including third-party tools like Toad Data Modeler, RedGate, SolarWinds and SQL Sentry.

Expert in utilizing different Ticketing Systems including Remedy, ServiceNow, and Jira.

Excellent ability to work as part of a team and independently and able to manage time too effectively to meet deadlines and prioritize workload.

Knowledge of Azure SQL Database.

Professional Experience:

Pentagon Federal Credit Union March 2018- Present

SQL Server DBA.

Job Responsibilities :

Working as a Production DBA and Responsible for the performance of the SQL Server Instance and safety of the data in the database.

Supports day to day operational activities for the database platform like service requests and tickets, monitoring, performance tuning, troubleshooting long-running queries, locks, deadlocks, and performance issues like CPU, I/O, Memory bottlenecks.

Installed, configured, and managed SQL Server 2014, 2012, and 2008R2 in development, test, and production environments.

Installed SQL Server 2016 on a test environment to be the future production environment.

Monitored and Scheduled jobs and created maintenance plans to automate different database administration related tasks including backup and database consistency check.

Configured Backups, involved in restoring the database to point in time in case of issues, and optimization jobs for various purposes and DBA notifications like job failures, disk issues, critical events.

Involved in SQL Server Configuration, Administration, Implementation, and Troubleshooting for Business work.

Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.

Regularly inspected SQL Server Error Logs, Space Usage, Disk Utilization, Backup status, Jobs, Customer Complaints, Windows Event Viewer for information, errors and warnings, and Daily routine works.

Implemented business rules in databases, set up referential integrity to maintain data integrity and other database-level constraints.

Created and maintained logins, users, and managed security tasks like granting and revoking permissions for server, database, and database objects.

Planned, Configured, Installed, Maintained SQL Server in the environment of Multi-node clusters with Multi-instances.

Ensured all database servers are backed up in a way that meets the business's Recovery Point Objectives (RPO).

Tested backups to ensure the company meets the business' Recovery Time Objectives (RTO).

Used SQL/T-SQL to create, alter, drop, delete, insert, update, etc. of databases, tables, views, clustered and non- clustered indexes, schemas, triggers, functions, and stored procedures.

Upgraded databases from SQL Server 2008R2 to 2014 in testing and production environments.

Applied Service Pack (SP) on SQL Server 2008R2, 2012, 2014, and 2016.

Worked with Application Developers to design databases and tables to support Development activities and achieve optimal efficiency.

Performed Database refresh tasks from Production to Development and Staging Servers.

Deployed database objects/changes to different environments including production.

Installed, Configured, and Administered SQL Server Reporting Services (SSRS), and Developed, Deployed, and Managed Reports for associates and upper management using SSRS, Crystal Reports, and Report Builder.

Using Third-Party Monitoring tools Toad Data Modeler and RedGate also, we use Ticketing system Remedy and Jira.

Moved data from Flat file, CSV file, Excel, Access, OLE DB data sources to/from SQL Server database using SSIS, BCP and/or Import/Export wizard.

FTI Consulting. January 2015 - February 2018

SQL Server DBA

Job Responsibilities :

Installed, Configured, and Managed SQL Server 2008R2, 2012, and 2014 in development, test, and production environments.

Monitored SQL Server activities/issues (such as CPU utilization, Memory utilization and IO utilization, disk space issues, blocking, deadlock, fragmentation, Identifying indexing issues, managing indexes, growth patterns, etc. ) and optimized performance using Execution plan, PerfMon, Profiler, Database Tuning Advisor, DMVs and DMFs.

Implemented Backup strategy for production and development environments and managed Backup to different media such as Local Drive, Network Drive/Backup Server, Tape Media, and Restored databases.

Setup and configured Database Mail and configured notifications and alerts

Performed regular backups, restores, and databases.

Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, and backup verification, cleaning history, deleting old files, index, and fragmentation management.

Installed, Configured and Maintained Fail-Over Clustering using SQL Server 2012.

Setup, configured, monitored, troubleshoot, and maintained Log Shipping, and Transactional Replication.

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

Tested and Implemented procedures to detect poor database performance, collecting required information, root cause analysis.

Created and managed schema objects such as tables, views, indexes, stored procedures, and triggers and maintained referential integrity.

Export & Import data from Flat file, CSV file to/from SQL Server Database using DTS, SSIS, and BCP.

Export & Import data from/to databases like Oracle, My-SQL, and Access to/from SQL Server.

Created user accounts and managed database object permissions.

Regularly inspected SQL Server Logs, SQL Server Agent Error Logs, and Windows Event Viewer for Information, errors, and warnings.

Using Third-Party Monitoring tools SolarWinds and SQL Sentry also, we use Ticketing system Remedy and ServiceNow.

Involved in resolving deadlock issues and performance issues and the Health Check process for the database.

Responsible for Database support, and troubleshooting application issues daily basis.

Monitoring of database size and disk space in Production, Staging & Development environments.

Developed and Managed reports in SSRS (SQL Server Reporting Services) including managing securities.

References: References available upon request.

Contact this candidate