Manager Data

FNU KARIMULLAH

SQL Database Administrator (DBA)

Email: *************@*****.***

Phone: 1-443-***-****

Skype: *************@*****.***

Linked ID: Fnu Karimullah

OBJECTIVE

A Certified SQL Server DBA/Azure Administrator with over Five (5) years of professional experience in SQL Server Database Administration Willing to Relocate Nationwide, with excellent technical knowledge, and troubleshooting experience in Database Design/Modeling, create, manage, deploy reports as well as creating and deploying packages using DTS, and Integration Services (SSIS). Backup/Recovery, Monitoring, Performance Tuning, Replications, Always On, Mirroring, Clustering, and writing Stored Procedures, Functions, Triggers, Constraints, and Views. Acquired solid working experience in designing and implementing Database Security including Encryption (TDE).

Substantial knowledge, and strong experience in using third party tools like Erwin, Idera, Redgate and Toad Data Modeler in managing SQL Server database and designing databases, AWS and Cloud Management for Software development.

I consider myself to be a well-organized, self-motivated, productive individual. I am not a stranger to hard work, long hours, and tight schedules. I am a very motivated individual who can take simple creative direction and turn it into somewhat amazing.

EDUCATION

• Bachelor’s degree in science: Herat University, Herat, Afghanistan

CERTIFICATES & TRAININGS

•MCSA: (Microsoft Certified Solution Associate)

•Microsoft Certified Azure Administrator Associate

•MCITP: Microsoft Certified IT Professional on Microsoft SQL Server

•Training on Database High availability, Azure, AWS

•Training on Performance Tuning

SKILLS & ABILITIES

Database:

SQL Server 2016,2014, 2012, 2008R2, MY SQL, Oracle 11g

Operating System:

Windows Server 2016, 2012, 2008 R2, Windows XP, 7, 10

Languages:

SQL, T-SQL, HTML, ASP, ASP.net, CMD, PowerShell

ETL Tools:

SSIS (SQL server integration services)

Reporting:

SSRS (SQL Server Reporting Services) VISIO 2007/2010

Data Modeling:

Toad Data Modeler, Erwin

Networking:

Active Directory, TCP/IP,

Third-Party Tools:

RedGate, Idera, ERWin, Toad Data Modeler, OpNet,

WORK EXPERIENCE

ADNET Systems, Bethesda, MD July2019-Present

Database administrator

Responsibilities

•Installed, configured, and managed MS SQL Server 2019,2016/2014/2012 in Development, Test, and Production environments,

•Migrated databases from SQL Server 2008/2008 R2 /2012 to SQL Server 2014/2016,

•Performed Performance Monitoring and Tuning using windows and SQL performance monitoring tools (i.e. system monitor, task manager, extended events, SQL profiler, activity monitor, DBCC, & DMVs),

•Used DBCC commands, DMVs and DMFs to check database integrity, index fragmentation and statistical updates,

•Resolved low disk space alerts, connection issues and failed jobs,

•Identified and Troubleshoot CPU, Memory and I/O bottle necks,

•Configured database mail, jobs and alerts in all SQL Servers,

•Properly configure primary/secondary is according to best practices

•Manage service accounts

•Properly implement required automation jobs

•Ensure file locations include the proper permissions

•Ensure database logs are shipped to secondary

•Perform Data Export/Import/Load and data transformations between databases in production environments.

•Analyze and resolve database space utilization in production environments. Analyze and resolve issues with database

•Design and implement database backup solutions based on the business needs which include: configuration, testing,

•Perform database restorations and point in time recovery to avoid data loss and meet service levels objectives.

•Ensuring database integrity, stability and system availability.

•Ensuring new database schema meets standards for readability and performance.

•Performance tuning new and existing applications.

•Working with IT Manager to be responsible for database procedures, and related documentation.

MCM CPAs & Advisors LLP June 2015-June 2019

Operational SQL DBA

Responsibilities

•Install, maintain and troubleshoot all database environments and serves as primary SQL server database administrator

•Monitor, identify, and implement security related updates and patches for SQL Server database systems and Microsoft OS

•Configured SQL Server Agent job and automated alerts and maintenance plan,

•Performed root cause analysis for slow running quires, missing index, outdated statistics, blocking and deadlocking issues,

•Configured and maintain database Always on in Synchronized and A synchronized mode,

•Imported and Export data from/to flat file, access, excel to/from SQL Server databases using SSIS and Import/Export wizard,

•Coordinate and collaborate with various Information Services departments to ensure availability, reliability, and scalability of corporate database environments to meet business demands.

•Configure and maintaining different high availability technologies that are used to support MSSQL i.e.

log shipping, transactional, and snapshot replication, mirroring.

•Manage clustered/non-clustered indexes, index rebuilds, partitioning.

•Manage security, roles, logins, and user accounts.

•Teaming with technical and business resources to perform implementation and ongoing upgrades.

•Developed parameterized and non-parameterized store procedures, functions, triggers, views and other T-SQL codes,

•Deployed and Automated SSIS Packages using SQL Server Agent Jobs,

•Configure Publisher/Subscriber/Distributor

•Ensure type of replication is best suited for environment

•Maintain automation jobs are function properly based off the type of replication

•Ensure data synchronization

•Configure subscription based off push/pull methods

•Document the client's database environment, processes, & procedures

Contact this candidate