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
Download Resume Format
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
0 comments:
Post a Comment