Asma Khanam

SQL Server Database Administrator

US Citizen

Towson, MD-21204

Phone: 703-***-****

Email Address: actpgb@r.postjobfree.com

Objective:

Microsoft Certified Profession, US citizen Seeking MS SQL server Database Administration position in a progressive company.

Technical Skills

SQL Server Database: 2005, 2008, 2008R2, 2012

T-SQL Programming Language, Stored Procedures, Triggers, Functions, XML,HTML

Database Performance/Tuning, Query Analyzer, Query Execution Plan

Transactional and Snapshot and Merge Replication, as well as log shipping, Mirroring

SSIS/DTS(Packages), SSRS

Microsoft Products: Word; Excel; PowerPoint

Operating Systems: MS Windows Server 2003, Windows Server 2008, Windows Server 2012

Raid, active directory, Web servers

RDBMS, Toad Data Modeler, ER Win, VISIO

Education & Certification & Training

MS National University Dhaka Bangladesh

MCITP: Database Administrator 2008

MCTS: Microsoft Certified Technology Specialist, SQL Server 2008

MCP: Microsoft Certified Professional

Certified SQL Server Reporting Services (SSRS): Report Administration,

Certified on: Database High Availability Solutions

Certified on IIS Web Server: Administration

Professional Experience

STEVENSON UNIVERSITY Baltimore, MD

Database Administrator August 2014 to Present

Accomplishments included the following:

Developing, configuring and maintaining databases and related systems to include writing well-formed, efficient SQL queries, views, jobs, and stored procedures to collect, process and present relevant data

Implement schemes, permissions and tables for database as appropriate for its use

Install, configure and upgrade/migrated the server to suit the database needs

Design automated systems and make reports

Include objects in database like tables, views, functions, triggers, etc.

Control the access for database by giving security password and permissions

Perform Database integrity checks and Index defragmentation

Review error logs and sizing the files

Developing, configuring and maintaining databases and related systems to include writing well-formed, efficient SQL queries, views, jobs, and stored procedures to collect, process and present relevant data

Support with recovery of lost or corrupt data

Support in the administration of the SQL Change Management process

Ensure the integrity and security of data from unauthorized individuals

Respond quickly to any database requests or issues and to ensure 247 uptime

Support in future planning and architecture of database environments

Develop and maintain proper documentation for procedures processes designs builds in regards to the database infrastructure

Bolon, Hart & Buehler, Inc . Columbus, OH

Database Engineer February 2012 to July 2014

Accomplishments included the following:

Provided constant online or on-call assistance to end users for handling their queries

Maintained a backup or recovery options to retrieve the lost data

Performed data cleansing and data migration and database upgrading

Fixed Orphan users after migration

Assisted in building strategies for installing and improving the database

Inspected the operations of the database as per the standards set by the organization

Setup and monitor Database Mirroring, Log Shipping, replication

Resolved SQL Server query issues and perform SQL Server query tuning

Verify Server consolidation and space management

Actively monitored performance and tuning when needed

Coordinate team meetings with groups for any new design/strategies

24/7 production support

Contact this candidate