Zahra Sayani

*** ******** **** **.

Euless, Tx. *6039

Phone: 817-***-****

Email: acf7o9@r.postjobfree.com

Summary:

• IT graduate, experienced professional in Windows & SQL

• Team Leader managing onsite and offshore DBAs

• 7 years of experience as Senior MS SQL DBA in a variety of environments - Win NT 4.0/2000/2003/2008

• Planning, installing and configuring the SQL 2000 and 2005 on Win 2003 within Cluster Environment

• Planning, installing and configuring the SQL 2008 and 2012

• Experience in handling large databases in test and production environments

• Extensive experience in database administration, backup, recovery, performance and tuning

• Extensive experience in SSIS packages

• Extensive experience in database analysis, designing and implementation

• Good communication and problem solving skills.

Education:

Bachelor of Science – Information Technology

DePaul University, Chicago, Illinois - June 2002

Technical Skills:

Core Skills: MS SQL DBA, Administration, DR strategy, Performance and Troubleshooting OLTP

Environments: WINDOWS NT/2000/2003/2008

Databases: MS SQL 2000, 2005, 2008, and 2012

Languages: T-SQL

SQL Tools: DTS, SSIS, SSRS, BIDS, SQL Profiler, LiteSpeed, idera, Microsoft Performance Management, SQL

Server Data Tools (SSDT) etc.

Other Tools: Amdocs Clarify CRM, MS-Office 2003/2007/2010

Work Experience:

SQL DBA, Interstate Batteries, TX Sept 2013 to June 2014

• Planning, Installing and configuring SQL 2005 and 2008 on Win 2008 in three node Cluster Environment

• Part of database migration from oracle to SQL server environment

• Designing the database Maintenance Plan

• Identified, resolved, and provided recommendations for different kinds of performance

• Monitored data activities (i.e. database status, logs, space utilization, extents, Checkpoints, locks and long

transactions).

• Refresh of QA and Dev from Production environment

• Create odbc connections

• Create Sql instances in existing Sql Cluster environment

• Extensive experience in writing distributed Queries between Sql Servers by creating link servers and

federated servers

• Experience in doing failover between clustered nodes.

• Experience in DTS migration and table refresh

• Resolved issues with databases applications connection problems

• Manage internal databases, from planning and testing stages through implementation and support.

SQL DBA, Federal Reserve Bank, TX May 2012 to Feb 2013

• Planning, Installing and Configuring SQL 2012 on Win 2008

• Implementing ETL Packages using SSIS 2005/2008

• Managing & scheduling the Database replication

• Implemented the new SQL Server 2012 mechanisms like data compressions, online indexing, Contained

Databases, security principals

• Monitored data activities (i.e. database status, logs, space utilization, extents, Checkpoints, locks and long

transactions).

• Create packages using SSIS SQL 2005, 2008 environment

• Executed scripted changed requests in accordance with change control procedures

• Experience in importing/Exporting Data from various data sources Excel and Flat file using DTS utility

• Investigated and applied necessary SQL Server database patches and installed services packs

• Documented all the SQL installs and updates.

• Experience in an operational environment providing support involving coordination with release management

and change management

Senior SQL DBA, Accenture, IL July 2006 to April 2012

• Planning, Installing and configuring SQL 2000 and 2005 on Win 2003 in Cluster Environment

• Ensure network and data security through access protocols, application roles, views & schema management

• Migrating from SQL 2000 to SQL 2005, SQL 2005 to SQL 2008 and managing the multiple instances, OLTP

• Estimated disk storage requirements for database software, database files & database administration needs.

• Experience in Failover clustering

• Experience in configuring Reporting Services

• Create expressions from built-in fields, collections, operators, and functions

• Export reports to other file formats such as Microsoft Excel, PDF, CSV

• Modify database parameters, structure, and physical location as necessary & indexing the views

• Work with Product Development Team to design new data models and extend existing models

• Managing the SQL 2000 on cluster servers and thus enabling the SQL FAIL OVER

• Designing the database Maintenance Plan

• Monitor database performance to evaluate availability and reliability

• Clarify application schema changes to reflect in database level

• Trained and Knowledge Transferred to in office and offshore DBAs

• Identified, resolved, and provided recommendations for different kinds of performance

• Upgraded for Development, Test, and Production environments.

• Monitored data activities (i.e. database status, logs, space utilization, extents, Checkpoints, locks and long

transactions).

• Created monitoring scripts to alert for production issues

• Documented disaster recovery plans and participated in disaster recovery drills

• Handled Logical Data and Index partitioning for large tables in SQL Server 2005

• Scanned the data pages, Indexes and checked the storage space used by each table.

• Participated in impacting databases physical design.

• Provided appropriate access to client except system databases owners’ and Client will have access to their

respective needed application schema owners.

• Evaluating and maintaining the Database indexes via DBCC showcontig, DBCC Re-indexing and DMV’s.

• Supporting over 50 servers and hundreds of databases including production, development and test servers

• Automating the jobs, defining the alerts & defining the operators

• Building DTS packages for data extraction, transformation & load

• Migrated DTS packages to SSIS Packages

• Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages

• Experience in an operational environment providing support involving coordination with release management

and change management

• Exceptional communication, problem solving and root cause identification skills

• Developed, tested & implemented a robust database backup and recovery strategy

• Interfaced with application vendors & client technical support teams to resolve database related problems

• Complied with standard security-related procedures that are based on established best practices and

conformity to company policy and adjusted to accommodate Client Security Policy based on mutual

agreement.

References: Available on request

Contact this candidate