SQL Server DBA
Resume:
Zahra Sayani
Euless, Tx. *6039
Phone: 817-***-****
Email: ********@*****.***
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