SQL Server database administrator resume samples and formats
SQL Server database administrator resume samples and formats
Name:
E-mail:
Phone:
SUMMARY:
-Around 4 years of IT experience in SQL Database Administration, System Analysis, Design, Development & Support of MS SQL Servers 2008/2005 in Production, QA, Reporting Services, Development Environments & Replication and Cluster Server Environments.
-Extensive experience in installation and configuration of MS SQL Server 2008/2005 versions, SSIS, SSRS and administration.
-Experience with software Development Life Cycle (SDLC) and Project Methodologies.
-Expertise in Administration, Database Design, Performance Analysis and Production Support for Large (VLDB) and Complex Databases.
-Expertise in planning and implementing MS SQL Server Security and Database Permissions.
-Successfully tested and implemented Log Shipping Technique used for warm backup solution for MS SQL Server 2008/2005 databases.
-Experience in Database Backup, Recovery and Disaster Recovery Procedures.
-Using Performance Monitor/Profiler to solve Dead Locks/Long running queries.
-Import & Export of various data formats using DTS, BCP, Bulk Insert and SQL 2008/ 2005 Integration Services.
-Expertise with Table Design, Index Design and Performance Tuning.
-Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
-Involved in Migrating the SQL Server 2005 to SQL Server 2008 (Side by Side).
-Experience in Replication – Snapshot and Transactional and extensive knowledge in Merge Replication.
-Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule DTS Packages.
-Experience with monitoring, troubleshooting related issues.
-Worked closely and efficiently with all levels of management to satisfy project and productivity requirements, offered logical, forthright thinking and is able to provide effective solutions to solve difficult problems.
TECHNICAL SKILLS:
Database Management Systems - MS SQL SERVER 2008/2005, Basics Administration of Oracle 10g, MS-Access.
Database Utilities - Enterprise Manager, Query Analyzer, SQL Server,
SQL Server Management Studio.
Programming Language - C, C++
Operating Systems - Windows Server 2000/2003/2008, Windows XP
EMPLOYERS
Working as a Database Administrator for ABC india pvt ltd form Mar 2011 to till date.
Worked as a Database Administrator for XYZ systems from Feb 2009 to Mar 2011.
RESPONSBILITIES:
-Installation SQL Server 2008 /2005 on Windows 2003, applied service packs and security fixes.
-Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, User Defined data types and functions.
-Addressed the Replication Issues. Created new replications, DTS packages to maintain high availability of the data between the servers.
-Implemented the SQL Login Security for developers and users.
-Running DBCC consistency checks, and fixing data corruption in user databases.
-Involved in Planning and Monitoring Log Shipping.
-Creation of Schema objects, rules and granting of roles to the users.
-Worked and coordinated with developers in writing and tuning new stored procedures.
-Worked on DTS packages to import the data from Oracle, Access and text files.
-Setting up backups for the newly created databases.
-Scheduling transfer of backups and log files to different servers.
-Responsible for change managements, created the documents for SQL Server and service packs installations.
-Responsible to Install, Upgrade, Design, and Implementation of SQL Server 2000 and 2005 Enterprise database environment for multiple clients sites
-Oversee and Assist database developers and web programmers in query writing, query optimization, performance tuning.
-Implemented the recovery process to restore lost data caused by users or system failure.
-Good experience in Project Documents, Installation Documents and User Manuals.
PROJECTS UNDERTAKEN:
Project Name:
Client :
Role : Database Administrator.
Environment : Windows 2003/2000/NT4.0, Oracle 10g, MS-SQL Server 2008/2005, SSIS, System Monitor, DTS, Performance Tuning, Clustering, .net, c# Script and visual source Safe.
EDUCATIONAL QUALIFICATIONS:
--
--
--
--
PERSONAL DETAILS:
Date Of Birth:
Languages Known:
Address:
