Sr. SQL Server Database Administrator

Kabir Ahmed Khan

Cell: 571-***-****

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

Woodbridge VA

Willing to relocate

OBJECTIVE

An accomplished SQL Server Database Administrator with demonstrated success planning, designing, and implementing database solutions that improve enterprise level business functionality. Possess diversified, intensive technical background with SQL Server Database Management Systems. My proven ability to implement SQL Server technologies that increase performance, scale SQL Server platform, and maintain security for database and systems level. Good understanding to business and technical requirements and administrative work with leadership and teamwork.

PLATFORMS & TOOLS

oWindows Server 2008-2016, SQL Server 2008/2012/2016/2019

oOffice applications, CRM (Customer Relationship Management).

oManagement and inventory tracking system (Mobile Asset).

oTicketing: Track IT, Service Manager (ITB).

oMS SharePoint 2010, 2013, MS Office

oNetBackup, Tivoli for network backup.

oWFC, VMware, Microsoft Azure (cloud computing) & familiar with AWS- RDS/EC2

oSQL Profiler, Database Engine Tuning Advisor.

o.Net and ASP.Net web and application.

oSSIS, DTS (ETL), SSRS (Reporting), BIDS (Business Intelligence Development Studio) and Visual Studio.

Database & SQL Server Tools:

oData Tools (Visual Studio), Management Studio, Database Diagram, Activity Monitoring Tool, SSAS (SQL Server Analysis Service), Microsoft Power-BI with SSRS (SQL Server Reporting Service).

oNew Query (T-SQL), DBCC, DMV, ETL (Extract, Transform and Load: SQL Server Integration Service), SSMA SQL Server Migration Assistant, Database Mail & Alert/Notification.

oOther Relevance: SQL Server Activity Monitoring, Native Client (ODBC, OLEDB), SQL Server Profiler, Database Engine Tuning Advisor, Data Tools (Visual Studio), Management Studio - Database Diagram Activity Monitoring Tool, SSAS (SQL Server Analysis Service), Microsoft Power-BI with SSRS (SQL Server Reporting Service), Service Manager.

SPECIALIZATION IN SKILLS

•Working on production support, including maintaining, managing, performance monitoring and tuning.

•Working experience of High Availability setting, configuring, and managing Always-On High Availability on Windows Server Clustering, Database Mirroring, Log-Shipping and Replication.

•Managing database security, apply service pack, database encryption and securing SQL Server by managing/granting appropriate permission, applying service pack, updates, and patches for protecting data from unauthorized users.

•Advanced knowledge of SQL Server, SSIS, SSRS, database design & creation, maintaining backup/recovery plan based on Disaster and Point-In-Time recovery model.

•Operating Systems: Microsoft Windows Server 2012-2019

•Database Management: Microsoft SQL Server (2008 -2019- advanced), MS Access (basic).

WORK EXPERIENCE

Excellicore LLC, Sterling, VA Duration: December 2018 – Present

Title: Sr. SQL Database Administrator

Responsibilities:

oSQL Server 2012, 2017 and 2019, Relational Database Management System (RDBMS); installing, managing, maintaining.

oMigration experience from on-premises to AWS and MS Azure.

oInstalling, configuration and creating a database instance on a cloud platform like AWS RDS and EC2.

oManaging security, review policy and roles and working experience of Identity Access Management (IAM) on the Amazon cloud.

oCreating SQL Server Integration Service, Export, Import, Data Migration and Upgrading.

oConfiguring Windows Failover Clustering, Always On and other high availability such mirroring, replication, and log-shipping.

oSetup, maintenance plan – backup, database health check, rebuild and reorganize indexes.

oUpdate and upgrade – Windows Server and SQL Server.

oMonitoring and administering DBMS security; adding and removing users, administering quotas, security audit, checking for security problems, and assigning user privileges

oMonitoring system performance and constantly tuned databases for efficient performance

oManaging Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.

oDeveloped an effective backup and recovery strategy to maintain the integrity of the database

oWorked on the front-end and back-end application development team, QA team vendors, and consultants.

Fulcrum Digital, Jersey City, NJ Duration: April 2016 – December 2018

Title: SQL Server DBA

Responsibilities:

oKnowledge of the principle of information Database Management by using Conceptual, Logical, Physical data modeling and designing within the best practices and standards guidelines.

oResponsible for the day to day operations of all production SQL server clustered instances and physical database servers.

oManage and maintain the database instances across the environment.

oPerformed performance tuning as a part of our performance management.

oInvolve in creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers, Rules and Defaults.

oMonitoring 24/7 production operations management (incident break/fix, change, service requests and vulnerability management).

oDesign different database backup strategies for effective use of space and minimum time to recover when needed.

oPerform database Integrity Checks, updated database Statistics and performed Re-indexing.

oAutomating database refreshes from production to test servers using SSIS and create packages for automated tasks.

oInstalling, Configuring, and Maintaining Windows Failover Clustering with Always On High Availability.

oInstall, Configure and Maintain Database Mirroring using automatic failover options in, High

oReport Development, SSIS Package creation& Deployment: Installed, Configured, and Administered SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Crystal Reporting Technology.

oCollaborative work with development team, application team, server, and networking team.

I transition, Denver, CO Duration: August 2013 – April 2016

Title: SQL Server Database Administrator

Responsibilities:

•Performed SQL Server DBA duties in a production, development, pre-prod, and testing environment, including security, configuration, developing maintenance plans for the backup and recovery of system and user databases.

•Access database migration to SQL Server 2012 using Integration Services and stored procedures.

•Developed Data Objects, Forms, Policies, and Services Reports.

•Monitored and Diagnose performance tuning on indexes, queries, and stored procedures on databases to resolve performance issues.

•Ran database clean up scripts to ensure database performance remained high.

•Worked for Disaster Recovery Plan and High Availability.

•Worked on project requirement documentation and maintained data standards and daily task automation.

•DTS/SSIS (ETL), Database Migration & Upgrading.

•(Development, testing/Staging, and production environment): From different platforms based on various operating systems.

•Data Design & Data Modeling, Patch Management & Security.

•Utilized Data Modeling tools including Toad Data Modeler, Erwin, VISIO, Oracle SQL Developer, and SQL Server Data Diagram.

•Experienced of enterprise architecture principles included configuring, designing using the advance methodology for supporting data quality, integrity to sharing and availability.

EDUCATION, TRAINING & CERTIFICATION

Completion Certificate in Microsoft SQL Server Database Administration

Training Completion in Microsoft SQL Server Integration Service

Training Completion in Microsoft SQL Server Reporting Service and Power-BI

Training Completion in Amazon Web Service & MS Azure

Bachelor’s degree

Contact this candidate