SQL Server Database Sample Resume Format in Word Free Download

Sample Template Example of Beautiful Excellent Professional Curriculum Vitae / Resume / CV Format with Career Objective, Job Description, Skills & Work Experience for Freshers & Experienced in Word / Doc / Pdf Free Download

                                                                                                                                                                                                                              

                    

   Amy Hagan

             

 PROFESSIONAL SUMMARY

SQL Server Database Administrator having 7 years of experience, well versed in all phases of System Development Life Cycle (SDLC) including analysis, design, programming, implementation and maintenance of stand-alone and web-based database applications with the following abilities:

• Total 7 years of IT experience and extensive experience in MS-SQL Server Development and Administration including Design and implementation of Distributed/ Replicated Databases, planning/ implementing backup/ recovery strategies, and Performance tuning.
• Expert in data migration from MS SQL Server 2000 to 2005/2008, including Replication and clustered SQL Servers.
• Designing, testing and implementation of high availability solutions like Clustering, Database Mirroring, Log Shipping, and Replication of databases for large, medium and small customers to further increase scalability and stability of business critical systems.
• Experience in data migration from existing databases to remote data centers.

• Intensive experience in monitoring/tuning SQL Server and database performance using SQL Profiler, Index Tuning Wizard and Windows Performance Monitor.

·         Managed databases on multiple disks using Disk Mirroring and RAID technology.

• Expertise in developing drill-through, drilldown reports using SQL Server 2005 Reporting Services (SSRS)
• Experience in working with 24/7 production Environment with thorough understanding of Standard Operation Procedures (SOP) and Service Level Agreements (SLA).
• Expert in using different Transformation tools like SSIS, DTS packages, BCP, DTEXEC, DTUTIL and BULKINSERT.

·         Involved in design and development of DTS and SSIS packages to load and process the data from Oracle, Excel, Access and flat file feeds to SQL Server and vice versa.

• Experience in implementing different types of Replication Models.
• Has good knowledge in implementing Log Shipping Technique as a part of disaster recovery plan.
• Experience in writing and debugging Stored Procedures, Views and Triggers.
• Experience in performance tuning of very complex SQL statements and procedures using show plan.
• Proven ability in Performance Tuning and Query Optimization.
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Expert in performing database consistency checks and planning and scheduling, Backup & Recovery.
• Created clustered and non-clustered indexes for increasing the performance, also monitored the indexes by troubleshooting any corrupt indexes by removing fragmentation from indexes.
• Provided 24/7 database maintenance and support.
• Knowledge in Third party tools like TOAD, LiteSpeed, AutoSys and Foglight.
• Good Team Player, Strong Interpersonal, Analytical and Communication Skills combined with self-motivation.
• Self-motivated, creative team player with effective communication and Leadership qualities.

EDUCATIONAL QUALIFICATIONS

Bachelor of Engineering in Electronics and Communication

  TECHNICAL SKILLS

Programming Languages:	T-SQL, PL/SQL, C,C++,C#.
Database Application Software:	SQL Server 7.0/2000/2005/2008, MS Access, Oracle
DB Utilities:	SQL Server Management Utilities, Query Analyzer.
GUI:	DTS Import/Export, SQL Server Integration Services.
Reporting:	MS Access, Excel, MS SQL Server Reporting Services 2000/2005, SSIS, SSAS.
ETL Tools:	SSIS,DTS
Application Software:	Microsoft Office, macros
Change Management Tool:	Visual Source Safe (VSS), Team Foundation Server (TFS)
Operating Systems:	Windows Server 2000/2003, Windows NT 4.0 Windows XP/98/95, MS DOS, Linux.
Third Party Tools:	Lite Speed, Performance Dashboard, TOAD, Foglight

 PROFESSIONAL EXPERIENCE

Coventry Health Care ,PA                                                                                                                       Dec’10 – May’11

Sr. SQL DBA

Description:

Coventry Health care is a diversified national insurer in United States. Coventry operates health plans, insurance companies, network rental and workers’ compensation services companies. Coventry provides a full range of risk and fee-based managed care products and services to a broad cross section of individuals, employer and government-funded groups, government agencies, and other insurance carriers and administrators.

Responsibilities:

·         Managed 120 SQL servers including Prod, Dev and QA.

·         Worked with Terabytes of Data with over 3000 databases

·         Installed, configured and managed MS SQL 2005 and 2008 fail over Clustering for production servers on 64 bit platforms to provide high availability.

·         Worked on Active – Active and Active - Passive clustering environment.

·         Post deployment Installations on SQL 2008 servers on Windows 2008 servers.

·         Installed recommended service packs and security patches on production, test and development servers.

·         Migrated Databases from SQL 2005 to SQL 2008.

·         Thorough understanding of standard SOP’s, SLA’s and change control management process.

·         Extensively used Remedy Ticketing and CAMS (internal application) for change requests.

·         Generated Performance analysis reports for all the prod servers on a weekly basis using third party tool Quest FogLight.

·         Experience with third party tools like FogLight and Veritas Netbackup.

·         Configured 43 Production servers using Foglight monitoring tool.

·         Deployed the SSIS packages using manifest file in Production environment.

·         Created Linked Servers between SQL server 2005/2008 and Oracle servers in the environment

·         Created batch files for Veritas Netbackup and scheduled them with SQL Job for both system and User Databases.

·         Modified some of the Jobs which have the steps to truncate backup log for the database which is in simple recovery mode as this option is now not supported in SQL server 2008

·         Used PerfMon and Profiler trace files to find the blocking issues which occur as a result of I/O and CPU bottle necks and memory leaks.

·         Worked on 24 /7 Production support understanding the business SLA’s.

·         Created and modified stored procedures, triggers, views and indexes to provide best performance.

·         Responsible for Database Backups & Restoration, Backup strategies and scheduling Backups.

·         Conversion of the legacy systems data into MS SQL server using SSIS packages.

·         Designed databases for different projects and resolve database issues.

·         Created SSIS / DTS packages to pull data from Oracle and Flat Files.

·         Running DBCC consistency checks, and fixing data corruption in user databases.

·         Generated different reports using MS SQL Reporting Services.

·         Performed Database refreshes from Prod to UAT and Dev  servers

·         Reviewed and deployed the code provided by developers in Prod and QA servers.

·         Involved in handling Work Orders and Documentation of the Change Process by creating Tasks using Service Center.

·          Experience in using Citrix software application

·         Manage security issues by analyzing permission structure and make the necessary adjustments to ensure people have the appropriate privilege.

Environment:

SQL Server 2000/2005/2008 , Windows Enterprise Server 2003/2008, Microsoft Visio 2003, Microsoft Integration Services. T-SQL, Query Analyzer, SQL-Profiler, Foglight, Citrix application.

Sharp Electronics, NJ                                                                                                                                        Jan ’10 – Nov ‘10                              

Sr. SQL Server DBA

  

Description:

The project is to provide services in the area of Software Development and Maintenance, on site and Remote Database Administration, and Business Intelligence Solutions.

Responsibilities:

·         Responsible for application configuration and migration between development, test, and production environments.

·         Primary responsibilities include profiling, performance tuning & redesign, high availability server network and disaster recovery.

• Migrated SQL server 2000 to SQL Server 2005 in Microsoft Windows Server 2003 R2 Enterprise Edition SP2.
• Installed and administered two node cluster Active/passive on Microsoft Windows Server 2003 R2 Enterprise Edition SP2 on SAN environment
• Migrated DTS packages from SQL Server 2000 to SSIS SQL server 2005.
• Extensively worked on SQL Server Integration Services (SSIS).

·         Expert in Using DMV’s, Performance dash board, Mirroring, database snapshot.

• Solving the Bugs Reflected by the Testing team
• Rebuilding the indexes at regular intervals for better performance.
• Recovering the databases from backup in disasters
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.

·         Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.

• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Expert in implementing the snapshot isolation and DDL triggers.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Implemented in new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE).

• SQL 2000, 2005 – Performed installation of SQL Enterprise 2005 64bit version on Windows 2003 servers on Enterprise systems of clustered and standalone HP servers in enterprise Data Centers. Patch applications.

Environment:

SQL Server 2000/2005 Enterprise, Windows Enterprise Server 2003,IIS 6.0, .NET, Microsoft Visio 2003, SFTP, Microsoft Integration Services.

Capital One, TX                                                                                                                                              June ’08 – Dec ‘09                   

Sr. SQL server DBA                    

Description:

Capital One is the largest financial services group in the world, offering a diverse array of corporate and personal financial products and the greatest global distribution capacity of any financial firm.

Responsibilities:

• Installation, configuration of MS SQL Server 2000, 2005, 2008 for development and testing purpose.
• Migration of SQL server 2000 to SQL server 2005 and monitoring and solving the issues after migration.
• Setup, configure and monitoring Transaction Replication, snapshot Replication on remote servers.
• Created and monitored database maintenance plans for checking database integrity
• Creating databases, logins and Assign permission to user(s), role(s), and object. Support column level permission. Administrate security for server’s logins (Windows and SQL Accounts). 
• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications.
• Created DTS packages to export and import data from SQL SERVER to Access, text and EXCEL files.
• Responsible for database backups & restoration and scheduling backup strategies.
• Implemented Disaster Recovery Plan using Log shipping, Mirroring and Replication.
• Running DBCC consistency checks, and fixing data corruption in user databases.
• Planning, implementing and troubleshooting Snapshot and Transaction Replication.
• Prepared Estimates for Database, table size growth.
• Worked with SQL Server Reporting Services (SSRS), implemented report builder to allow customers build their report.
• Generated reports using SQL server report manager and published as PDF formats.
• Created report models for Report Builder and managed reports using Report manager.
• Migrated report system from a custom Crystal Reports system to SQL server 2005 Report Services.
• Responsible to bring the awareness of the importance and techniques involved in DB tuning and Performance, to the developers.
• Implemented Transactional Replication for Real time Reports (Database Server as Publisher and Reporting Server as Subscriber).
• Expertise in Security Issues such as creation and granting permissions on various Objects.
• Involved in migration of SQL Server 2000 to 2005 Cluster.
• Monitoring the event logs and server error logs for troubleshooting.
• Created and modified stored procedures, triggers, views and indexes to provide best performance.
• Performance tuning, finding the CPU Bottlenecks, SQL Server Bottlenecks.

Environment:

T-SQL, Query Analyzer, SQL-Profiler, Windows 2000, SQL Navigator. SQL Server 2000/2005 Enterprise Edition, Windows 2000 advance server, Crystal Report 11.0 SQL Server Reporting services (SSRS) SQL Server Management Studio (SSMS).

Lincoln Financial Advisory ,PA                                                                                                           Nov ’06 - Apr’08

 Sr.SQL SERVER DBA                    

Description:

Lincoln Financial group sells a wide variety of financial products and solutions through financial advisors (LFA). Mutual funds, Managed Accounts, Retirement Solutions, Life insurance. Providing LFA planners and Advisors the ability to search for their clients based on various parameters such as: First Name, Last Name and SSN and view select from a list of reports that are required to be generated or printed .The development required close interaction with the business user’s technical infrastructure team of LFA.

                                    

Responsibilities:

• Installed SQL server 2000 on windows 2000 advanced servers, applied service packs and security fixes.
• Imported Data from text files and excel spread sheet into SQL Server 2000 database using DTS package.
• Setup database mirroring in SQL Server 2005.
• Configured transactional replication between primary Server and Read-Only servers with separate distributed servers.
• Created backup strategies and scheduled them for execution.
• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications

• Configured the database maintenance plans for database optimization.

• Experienced in performance tuning using windows performance monitor and SQL profiler of SQL server
• Creating the users, user groups and maintains the access permissions
• Configured Log shipping server to create stand by environment

• Configured Replication methods like snapshot, transactional replications.
• Worked on DTS packages for transferring data from various data sources like Oracle, MS Access, Excel, *.Txt file, *.CSV files.
• Worked with developers to tune the queries, run scripts and move the database from production to development servers.

• Setting up database back up and recovery procedures for production, quality and development servers
• Developing triggers, stored procedures and enforcing business rules via checks and constraints

• Performance tuning and optimization of procedures and queries.
• Worked with SQL server profiler to generate traces

Environment:

Windows 2000 Advanced Server, MS SQL Server 2000/2005, ASP 3.0, VB 6.0, SQL Server Integration services(SSIS), MS Access, Excel ,SQL Server Management Studio (SSMS).

Download Resume Format