Sql Server Database adminstrator
Resume:
Kibret S.
********@*****.***
Annandale, VA
Career Objectives:
I am looking for a position with new challenges and opportunities to build
upon my extensive knowledge and experience in MS SQL Server. My goal is to
develop innovative and effective database solutions that will meet the
technical objectives of the company and support the implementation of the
company's mission. As a result, I want to obtain a challenging technology
position in an organization that enables me to excel and offers me an
advancement opportunity with increasing related task knowledge.
Areas of EXPERIENCE:
Installation & configuration SQL Server & Database Database Consistency check
Database Administration Security Management Applying Patches, Service
Backup/Recovery & Disaster Creating Schemas, Tables, Pack & Hot Fixes
Recovery Solution Indexes and Views Programming - T-SQL, Stored
Database Point-in-time recovery Creating Jobs & Alerts Procedure, Functions,
Creating Linked Server and Triggers
High Availability Solutions, Writing Distributed Query Creating and Deploying SSIS
Mirroring, Log Shipping, Performance Turing and Query packages
Replication Optimization Report development,
Database Migration Tracing Long Running Queries deployment, & security
Database Upgrade and Deadlocks management using SSRS
-
Technical Skills:
SQL Server Administration:
Technical Skills:
SQL Server Administration:
> SQL Server 2012, 2008 & R2, 2005 and 2000
> Database Mirroring, Log Shipping, Replication and Clustering
Management
> SQL Server Management Studio, Enterprise Manager, BI, SQL Server
Integration Services (SSIS), SQL Server Reporting Services
(SSRS), SQL Server Profiler/Trace, Database Tuning Advisor,
Upgrade Advisor, Query Analyzer, Activity Monitor, SQL Server
Migration Assistant, SQL Trace, DBCC, DMV, BCP.
Operating Systems:
> Windows Server 2008/R2, 2003/R2, 2000, VMWare
> Hardware/Storage: RAID, LAN, SAN
> Data Modeling: ERin Data Modeler, SQL Server Data Dia
Professional Experience
[pic]
Cox Communications
SQL Server Database Administrator 09/2013 to present
Responsibilities
. Installed, Configured, and Managed SQL Server 2012, 2008, and 2005 in
development, test, and production environment, on stand alone and
clustered servers
. Applied Service Packs and Hot Fixes on SQL Server 2000, 2005, 2008
R2,2012
. Managed security, created and managed logins, users and roles
. Scheduled jobs to automate different database related activities
including backup, monitoring database health, disk space, backup
verification, updating statistics
. Strong working experience in creating and modifying tables, index (
cluster/non-cluster), constraints (unique/check), views
. Strong knowledge and working experience in database backup and
disaster recovery
. Restored database from backup and with point-in-time recovery
. Installed, configured and maintained database mirroring, log shipping
and replication
. Configured log shipping as standby database from production database
for reporting purposes
. Installed, configured and maintained database mirroring using
automatic fail-over option in SQL Server 2008R2, 2008 and 2005
. Configured and maintained replications (Transactional)
. Export & Import data from Flat file, CSV file to/from SQL Server
Database using SSIS (SQL Server Integration Services), BCP (Bulk Copy
Program)
. Export & Import data from/to databases like Oracle, MySQL, and Access
to/from SQL Server
. Migrated database from MS Access 2003/2000 into MS SQL Server 2008
R2, and from SQL Server 2005 to SQL Server 2008
. Upgraded database from SQL Server 2000 to 2005, and SQL Server 2005 to
SQL Server 2008
. Upgraded MS Access 2000/97 databases into MS SQL Server 2000, 2005,
and 2008
. Experienced on database monitoring and performance tuning
. Created clustered indexes and Non-Clustered Indexes to enhance
performance of database
. Performed defragmentation and rebuilding of indexes periodically on
the production tables
. Monitored SQL Server error log and space usage.
. Used DBCC commands to check database conditions, indexes rebuilding
and other database performance optimization methoExperienced in using
performance monitor, SQL profiler and optimizing the queries, tracing
long running queries and deadlocks, and using execution plans and
traces.
. Monitored server activity and solved problems as needed
. Used third party tools such as Idera and Spotlight to monitor SQL
server performance
. Assisted database developers to optimize SQL queries and Stored
Procedures
Star Wood Hotels and Resorts
(Sheraton Hotels and Resorts)
SQL Server Database Administrator 09/2009-
07/2013
Responsibilities:
Installed, Configured, and Managed SQL Server 2008 & 2005 in
development, test, and production environment
. Creating and maintaining various databases on production/development
servers .
. Configured Log shipping from Production to Disaster Recovery server.
. Involved in development of automated daily, weekly and monthly system
maintenance tasks such as database backup, integrity verification,
replication verification, and indexing updates.
. Involved in designing and creating Databases, Tables, Views, Stored
Procedures and Triggers.
. Identified, tested and resolved database performance issues to ensure
data optimization.
. Used tools like SQL Server profiler, Performance Monitor to identify
bottlenecks.
. Involved in installing SQL Server 2008/2008 R2 on Development,
Production.
. Troubleshooting high availability scenarios involving Clustering,
Database Mirroring, Log Shipping and Replication.
Strong knowledge and working experience in Database Backup, Restore and
Point-in-Time Recovery
. Migrated databases and database objects between multiple servers across
production, QA and development platforms.
. Involved in Performance Tuning, Indexing, Query Optimization.
. Involved in Resolving locking and blocking issues.
. Created database objects like tables, views, indexes, stored-procedures,
triggers, cursors using T- SQL
. Creation of Jobs, Schedules, Alerts using SQL Server Agent and
Notifications using SQL Mail.
. Involved in Setting up Log shipping and database mirroring.
. Created and managed the Database Users, Login and Security.
. Monitoring Event viewer, SQL Error logs and Log File Viewer for Software
and hardware related errors.
Strong working experience in creating, modifying tables, Index
(Cluster/Non-Cluster), Constraints (Unique/Check), Views, Stored
Procedures, Trigger
Export & Import data from/to databases like Oracle, MySQL, and Access
to/from SQL Server
Information and Technology Inc .
Desk Support
6 /2008 to 8/2009
. Provided computer help desk support via telephone communications with
end-users.
. Performed diagnostics and troubleshooting of system issues, documented
help desk tickets/resolutions and maintained equipment inventory
lists.
. Performed set-up, break-down, and transport of agency equipment on an
as-needed basis.
. Performed desktop support to over 475 employees in person and by
telephone.
. Trouble shot network connectivity, network printing and user access
issues.
. Played a key role in ensuring a proficient workforce and significantly
reducing system downtime.
. Built and maintained computer systems and performed memory upgrades
Certificates:
> MCITP (Microsoft Certification IT Professional) Design and
optimization of SQL Server 2008
> MCTPS ( Microsoft certified Technology Specialist)- SQL Server
2008, Implementation and Maintenance
Education:
> Bachelor of Science
References: - available upon request
[pic][pic]
Contact this candidate