Sql Server Management

SQL Server DBA Resume

Title

SQL Server DBA

Primary Skills

Windows NT 4.0, Windows 2000, Windows 2003

Location

US-GA-Kennesaw

Posted

Jun-20-11

RESUME DETAILS

Management & Maintenance

Disaster Recovery

Integration Services

Analysis Services

Reporting Services

Backup and Recovery Database Administration

Team Management

Database Security

SQL Server Upgrades

Patches & Hot fixes Installation/ Configuration

Troubleshooting

High Availability Solutions

Performance Tuning

Staff Motivation

Data Migration

I am a SQL Server DBA who has been supporting database applications for almost 6 years. I have a very Strong Skill set in SQL Server Database Administration. I am an effective communicator with exceptional relationship and management skills. Ability to relate with people at any level of business/management & significant experience working with team members. A team leader with exceptional abilities in performance evaluations, team building, team work and mentoring.

WORK EXPERIENCE:

PACIFIC SYSTEMS INC. (MCDONOUGH, GA U.S.A) 2006 - PRESENT

SQL SERVER DBA

IBM CORPORATION (Nigeria) 03/2005 --- 09/2006

SQL SERVER DBA (REMOTE SUPPORT)

TECHNICAL SKILL SET

RDBMS/DBMS: SQL 2000, SQL 2005, SQL 2008, SQL 2008R2

OPERATING SYSTEM: Windows NT 4.0, Windows 2000, Windows 2003.

SOFTWARE/DATABASES: MS SQL Server 2008R2/2008/2005 / 2000, MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services SSAS), MS SQL Server Integration Services (SSIS), Data Transformation Services (DTS), OLTP, OLAP, SQL Server Management studio (SSMS), MS SQL Server 2000 Enterprise Manager, SQL Query Analyzer, SQL Profiler, Bulk Copy Program (BCP).

NOTABLE MILESTONES

• Handled Administration of SQL Server SQL 2000, SQL 2005, SQL 2008 and SQL 2008R2.

• Implemented MS SQL Cluster (Active/Passive & Active/Active), Multi Node Cluster up to 4 Nodes.

• Created and maintained windows domain with 500 numbers of clients which spread crossed multiple locations.

• Planned & executed upgrade such as Service Pack, Hot fixes etc.

• Handled Fine Tuning Databases System

• Developed exceptional maintenance plans.

AS A SQL PRODUCTION DBA

• Up gradation of Database from SQL Server 2000 to 2005 and 2008.

• Installed & configured database software, associated database tools and performance monitoring software.

• Performed database/infrastructure physical design, database upgrades & applied software patches to databases as per application/client requirements.

• Performed acceptance testing to verify that database changes perform without adverse consequences.

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

• Provided optimal database file layout for utilization of storage and performance acceptable to client.

• Participated in meetings impacting databases physical design.

• Customized support for Client's Applications (e.g. Third party supported/In-House Applications etc.) and exceptional skills in creating and maintaining database objects and structures (e.g. tables, indexes, views, triggers, Functions, Procedures etc.).

• Provided appropriate access to database as needed.

• Developed & maintained scripts, utility jobs for database maintenance.

• Implemented & managed database clustering, failover and load balance technologies as per client requirement.

• Developed, tested & implemented a robust database backup and recovery strategy with client assistance.

• Requested refreshes pre or post restore activities (e.g. data loads).

• Database recoveries as per requirements.

• Conducted root cause and analysis for database incidents and problems.

• Participated in designing, testing and implementing an enterprise Disaster Recovery Plan.

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

• Developed & executed scripted changes requests in accordance with change control procedures.

• Provided overall configuration and change control management for data base components.

• Conducted research and collaborated with vendor if necessary for additional patches.

• Researched, re

©2003-2012 Dev Bistro

Contact this candidate