Faizan Khundmiri

CAREER OBJECTIVE:

Obtain a challenging position as a SQL Server 2000/2005/2008/2008R2 DBA to

contribute to an organization's success through the use of my knowledge,

skills and abilities.

PROFESSIONAL SUMMARY:

Mastery and Extensive experience in SQL Server 2000/2005/2008/2008R2:

< SQL Server Architecture and Database Designs

< Database backups, Recovery procedures and Database Maintenance Tasks

< Database Clustering Active/Active and Active/Passive

< Performance tuning, logical and physical db optimization, hardware

sizing and testing

< Disaster Recovery and Business Continuity Planning

< Creation of SQL queries, Indexes and Tables

< All aspects of data Replication

< Creation of complex processes and ETL through SSIS

< Solid team player with strong communication, verbal and written skills

< Self-motivated with exemplary analytical and problem solving skills

developed through variety of projects

TECHNICAL SKILLS

Databases : SQL Server 2008R2/2008/2005/2000

Reporting Tools : Sql Server Reporting Services, Training: Cognos 7

Reportnet Authoring Part 1 & 2

Cognos BI Server

Administration and Content Administration

Languages : SQL, TransactSQL

Operating Systems : Windows Server 2008R2,Windows Server 2008,

Windows Server 2003, Windows 2000, Windows

XP, Windows NT 4 / 3.5, Windows 98, Win 95

Web Development : HTML, DHTML, CSS, Dreamweaver, JavaScript

Other Tools : Idera Sql Diagnostic Manager, Visual SourceSafe, Quest

Spotlight, Red-gate Sql Compare, Pivotal

Tracking, Jira 5.2, Tortoise SVN

PROFESSIONAL EXPERIENCE

[pic]

Duluth, GA August 2012 - Present

Sr. SQL Server DBA

Description: NCR Corporation is US based multi-billion dollar computer

hardware, software and electronics company that provides products and

services that enable businesses to connect, interact and transact with

their customers

Responsibilities / Accomplishments:

< Provide database management and support to the Software Engineering

team in the R& D department

< Worked extensively with the QA team in the NCR labs to improve the

Performance of the Logix product.

< Participate in the scrum planning's and meetings and work on the story

points reflected by the scrum master.

< Responsible for providing Security for highly sensitive data.

< Provide guidance and review the work for developers and ensure they

meet internal database standards.

< Provide guidance to developers on optimization of SQL code

< Responsible for monitoring and making recommendations to external

clients for performance improvement for our Logix product. This

involved troubleshooting performance problems, fine-tuning of

databases and index Analysis.

< Extensively worked on DMVs and DBCC commands

< Implemented Data partitioning, Error Handling through TRY-CATCH-THROW

statement, Merge Statement.

< Create, modify, and tune SQL Server stored procedures, triggers,

functions, indexes, views, and schemas.

< Create and maintain database diagrams, data dictionary and database

documentation.

< Design, test and implement Disaster Recovery, Backup and Restore

strategies.

< Export or Import data from other sources like flat files using

Import/Export through SSIS

< Experience in using tools like SQL Profiler, Windows Performance

monitor (Perfmon) and performance counters for Monitoring and Tuning

< Extract and import data in and out of SQL Server.

Priority Payment Systems (Alpharetta, GA) June 2011 - August 2012

SQL Server 2008/2008R2 DBA

Description: Priority Payment Systems is a Bankcard Solutions Company

providing support to Merchants for Credit Card Processing and also provide

support to ISO/Agents with online Application called MX ISO/Agent to manage

their Portfolios. I am responsible for providing Support to Production, QA

and Reporting Databases. Provided change management and problem management

to 2 Production Servers and 2 QA Servers and 1 Reporting Server

Responsibilities / Accomplishments:

< Responsible for Support and Maintenance of a total of over 16

databases in Production, QA and Reporting Environments.

< Responsible for providing Security for highly sensitive data.

< Troubleshoot, escalate, and resolve database problems.

< Responsible for a disaster recovery plan (e.g. logical/physical

standby)

< Providing and implementing optimum physical database design, Providing

schema management for objects such tables, views, indexes etc, and

ensuring they meet internal database standards

< Provide guidance to developers on optimization of SQL code

< Participate in 24x7 on-call support rotation

< Perform database capacity planning

< Maintain databases by checking automated backups, monitoring queries,

and adjusting indexes accordingly.

< Create and maintain database diagrams, data dictionary and database

documentation.

< Design, test and implement Disaster Recovery, Backup and Restore

strategies.

< Create, modify, and tune SQL Server stored procedures, triggers,

functions, indexes, views, and schemas.

< Create and maintain reports using SSRS.

< Extract and import data in and out of SQL Server.

[pic]

Atlanta, GA May '07 - May 2011

SQL Server 2005 DBA

Description: Automatic Data Processing (ADP) provides Online Application

Called Odyssey for Applicant Management System. I am responsible for

providing Support to Production, QA, and Development databases. Provided

change management and problem management to 7 production Servers, 5 QA

Servers and 4 Development Servers.

Responsibilities / Accomplishments:

< Responsible for Support and Maintenance of a total of over 100

databases in Production, QA and Development Environments.

< Responsible for providing Security for highly sensitive data.

< Troubleshoot, escalate, and resolve database problems.

< Responsible for a disaster recovery plan (e.g. logical/physical

standby)

< Providing and implementing optimum physical database design, Providing

schema management for objects such tables, views, indexes etc, and

ensuring they meet internal database standards

< Provide guidance to developers on optimization of SQL code

< Participate in 24x7 on-call support rotation

< Perform database capacity planning

< Maintain databases by checking automated backups, monitoring queries,

and adjusting indexes accordingly.

< Create and maintain database diagrams, data dictionary and database

documentation.

< Design, test and implement Disaster Recovery, Backup and Restore

strategies.

< Create, modify, and tune SQL Server stored procedures, triggers,

functions, indexes, views, and schemas.

< Create and maintain reports using SSRS.

< Extract and import data in and out of SQL Server.

< ASP and ASP.NET enhancement to existing systems

Matria Healthcare (Marietta, GA) Feb '04 - May '07

SQL Server Production / Support DBA

Description: Matria Healthcare provides health management programs. I am

responsible for providing Support to Production, Development and QA client

specific databases. Provided change management and problem management to 3

production Servers, 2 development Servers and 1 QA Server. My duties

include providing services to our clients on SQL Server Database

Administration, Maintenance and Support.

Responsibilities / Accomplishments:

< Support, administration and maintenance of SQL Server instances and

user databases

< Maintain defined operating procedures for backup / Recovery and

Restoration and cleanup old data and stored procedures

< Provide DTS / Stored procedures troubleshooting / support, Planning,

installing, and upgrading SQL Server instances and databases

< Scheduling and setting up jobs to run nightly using SQL server agents

< Upgrading to new Microsoft releases and applying latest Microsoft

Service Packs and Patches

< Monitoring disk space, CPU and performance of slow running queries,

provide instance level performance monitoring and tuning

< Providing and implementing optimum physical database design, Providing

schema management for objects such tables, views, indexes etc, and

ensuring they meet internal database standards

< Modifying database structures / objects based on directives from Sr.

DBA / team lead Implementation / control / monitoring of users / apps

database security access according to internal database security

design/policy

< Provide Change management and Problem management services to clients

< Enforce compliance with SQL Server license agreements

< Package database components for promotion into production according to

department standards and procedures

< Prepared and implemented database software upgrades and applied new

patches

< Provided 24/7 support for products in a Microsoft Clustering

environment under the direction of IT Manager.

SQL Server 2000 Tools: Enterprise Manager, Query Analyzer, SQL Profiler,

SQL Server Agent Services, Data Transformation Services, SQL Server Wizards

Third Party Tools: Quest Spotlight, Red-gate Sql Compare

Environment / Setup: SQL Server 2000(SP4), Win2003 Server (SP2), Win2000

Professional, Win2000 Server (SP4)

Kennesaw State University (Kennesaw, Ga) Oct '01 - Feb '04

Database and System Support Specialist

Description: Support the instructional and departmental use of databases

for faculty and staff at all Kennesaw State campuses. I support the

database and spreadsheet applications and versions available in the Student

Technology Centers. Also support Oracle and Microsoft SQL Server. I support

faculty and staff computers and equipment for the College of Health and

Human Services. Assist in the installation, troubleshooting and moving PC's

when required; provide technical support in the installation and

maintenance of software, operating systems, network connectivity, and e-

mail for desktops and laptops; install and/or relocate computer hardware as

necessary. Direct and maintain the computer lab. Resolve technical and

procedural issues.

Administration Role:

< Monitor system utilization and database performance for databases on

multiple servers

< Create and Maintain disaster recovery and database maintenance plans

< Handling all database security issues

< Upgrading to new Microsoft releases and applying latest Microsoft

Service Packs and Patches

< Creating databases, tables, SQL queries, stored procedures, indexes

and triggers

< Create jobs, alerts, operators and configuring mail agents

< Generating reports, testing of new system, user training,

implementation and Systems Support for new Information System

Hewlett Packard (Kennesaw, Ga) Apr '99 - Oct

'01

Database Administrator\Application Support

Description: Working within internal setup, we have 5 production Servers

installed with many client databases. Working with the growing number of

clients; my duties include providing services to our clients on SQL Server

Database Administration, Maintenance, Support, and Report generations and

perform some development tasks.

Provide hardware and software support for HP employees. Install, enhance,

and maintain various computer systems and other technological equipment.

Resolve technical and procedural issues; work with end-users in training

and troubleshooting. Handle and control HP inventory around the U.S.

Assure customer communication of backorders. Find availability of parts

for CE's and customers.

Administration Role:

< Daily Support, administration and maintenance of SQL Server instances

and user databases

< Creating user databases, tables, indexes, and database connectivity

< Writing simple to complex SQL Queries and TSQL statements

< Upgrading to new Microsoft releases and applying latest Microsoft

Service Packs and Patches

< Data security, data backups, data recovery, database maintenance and

data transfer.

Birla Tires Ltd (Hyderabad, India) 1997 -

1998

Developer

Description: Developed forms 4.5, Reports 2.5, created several tables.

Forms, views, synonyms, constraint and indices. Wrote several forms

triggers, database procedures, functions and packages.

Quest, Inc (Hyderabad, India)

1995 - 1997

Recruiter

Description: Responsible for testing and interviewing applicants for

overseas consultancy. The applicants were interviewed for their knowledge

in Oracle, SAP and Visual Basic. Further training was provided to

qualifying candidate to increase their opportunity for full time

employment in Australia, Canada and the USA. Technical training included

Oracle and non-technical training included finance management, political

correctness and corporate management structure.

CERTIFICATIONS

< Certificate in Oracle 7.x, Developer 2000 (Hyderabad, India) Mar

'97

EDUCATION

< Second Year Information Systems Major (Kennesaw State University)

Present

< Bachelor of Commerce (Osmania University, Hyderabad, India)

May '96

6218 Abercorn Ave, Dunwoody, GA 30346

404-***-****

acehn5@r.postjobfree.com

Contact this candidate