Kaniz Hussain

**** ****** ******, ********, ** **026

Tel (703) - 441- 0190, Cell 571-***-****

Email- ace9f2@r.postjobfree.com

Objectives:

I am a Microsoft Certified SQL Server Database Administrator and seeking a SQL

DBA position to an organization that will allow me to utilize and develop my academy

education and experiences and skills.

Industry: Information Technology, MS SQL Server, DBA

Job Title: Database Administrator

Experience: 5 Years

Visa Status: U.S. Citizen

Security Clearance: Clearable

Education Level: Master?s in Arts.

Certificate: MCITP (Certified DBA): Microsoft Certified IT Professional (SQL Server 2008)

AREAS OF EXPERTISE:

? 5 years of Database Management experience in different environments

? Excellent in customer service or clients support

? Ability to adapt to changing environments

? Excellent ability to work with team and quick learner

? Development and maintenance of reports using SQL Server Reporting Services

? Attention to detail

? Proven record of liabilities and responsibilities

? Excellent organization skills

? Skills in a fast-paced environment

? Excellent written and verbal communication skills

Professional Skills

Database Management:

? Strong knowledge and working experiences as Database Administrator of

MS SQL Server ( 2000, 2005, 2008 )

? SQL Server Upgrade to later version

? SQL Server Database Migration one server to another.

? Strong working experience and knowledge with SQL Server Log shipping,

? Database Mirroring,

? Performance Tuning,

? Database Backup/Recovery,

? Query Optimization

? Security Management

Tools

SQL Server

? SQL Configuration manager

? SQL Server Management Studio (SSMS),

? Enterprise Manager (EM)

? Activity Monitor,

? Query Editors

? Query Analyzer,

? SQL Profiler,

? Database Tuning Advisor (DTA)

? Business Intelligence Development Studio (BIDS),

? Reporting Services Configuration manager

Third Party Tools

Toads for Data Modeling

? Spotlight for Performance Monitoring

Operating Systems:

? Windows Server 2008, 2008 R2, 2003,

? Windows XP Professional,

? Windows 7 Professional

? Windows 8

Programming:

? SQL,

? T-SQL,

? Trigger,

? Functions,

? ASP, ASP.NET.

Current Job

Kforce,

Washington, DC January 2012 to Present

Responsibilities:

? Performs and recommends capacity planning and management of database environments.

? Responsible for the overall configuration management of the database technologies,

including database installations, upgrades to new product releases and the installation of

service packs.

? Apply patches for Systems and SQL Servers.

? Provide ongoing support for designated applications and databases.

? Experience with SQL Server Upgrade to later version

? Manage the deployment, monitoring, maintenance, development, upgrade, and support of

all Database system.

? Monitors and analyzes database performance, producing reports and recommendations

for improvements as needed.

? Performs database tuning for diagnosing issues and optimal database performance.

? Manage security procedures for specific user, user applications, access to secure

databases.

? Manages backup and recovery of the database, including establishing standards and

schedules for database backups, developing recovery procedures for each database and

ensuring that the backup schedules meet recovery requirements.

? Designs, develops, monitors and maintains complex database management systems and

related components underlying business applications.

? Provide technical direction for Logical/Physical database design, maintenance, and

administration.

? Review developer SQL queries and stored procedures for optimization and security

purposes

? Used DBCC to check physical and logical consistency of database.

? Working experience with T-SQL, Trigger, Function, Indexes, Constraints, File & File

Group.

? Implement and Configured Log Shipping from Production to Standby Server (Running as

Reporting Server)

? Experience with ODBC Connection

? Implement and Configured Database Mirroring for High Availability solution.

? Export & Import data from Oracle Database, MySQL, and Access Database including flat

files like text, excel.

? Write and maintain database and application documentation, including data standards,

procedures, definitions for the data dictionary and logical and physical models of the

databases.

*

Job 2

Data Group USA,

Alexandria, VA March, 2009 to December 2011

Title: Database Administrator,

Responsibilities:

? Performed capacity planning for SQL Server Instance & Database.

? Installed and Configure SQL Server 2000, 2005 & 2008R2 in development, test,

and production environment

? Experience in Operating System, Windows Server (2000, 2003 & 2008).

? Experience with SQL Server Upgrade to later version

? Migrated databases within SQL Servers in test and production environment.

? Identify and address database performance issues and capacity issues.

? Strong experience in operational monitoring and management of databases to

ensure maximum uptime and performance, Monitor Servers activity.

? Tune and solve performance problems.

? Experience SQL Server Error Log, space usage, DBCC Command,

? Write T-SQL and Stored-Procedures. Assist SQL developers to optimize SQL

queries and Stored Procedures.

? Strong working experience in backup, restore and recovery procedures. Scheduled

jobs

? Strong working experience Maintenance Plan.

? Export & Import Databases.

? Experience with Data Modeling: Designed Logical & Physical Database, Backward

& Forward Engineering.

? Involved in creating and modifying tables, Index (Cluster/Non-Cluster),

Constraints, Views, Stored Procedures, Triggers

? Rebuild Servers (Restore & Recovered from tape/CD backup) from backup

? Configured Log Shipping from Production to Standby Server (Running as

Reporting Server)

? Configured Database Mirroring

? Writing documents for Server and databases.

Contact this candidate