Database Administrator Resume Format in Word Free Download

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

CARRER OBJECTIVE:                                                                                                

US Citizen, Over Seven (7+) years of Hands-On Professional Experience as a SQL Server DBA with detail oriented, analytical and troubleshooting experience in different Microsoft products like SQL Server (2000, 2005, 2008), Operating Systems, AD (Active Directory), data modeling including gathering and analyzing business requirement, solid working experience in managing large databases in 24/7 environment including backup/recovery, developing and managing reports using SQL Reporting Services (SSRS), Monitoring, Performance Tuning, stored procedures, triggers, functions, constraints, DBCC, using third party tools etc. Working experience entails strong working experience on using database third party tools like Idera SQL Admin Toolset, SpotLite, ERWin, Visio, Toad Data Modeler, and Toad for SQL Server Admin. Strong business and technical vision with effective people skills, ability to manage multiple complex projects, innovative and creative problem solver, results oriented, and has an aptitude for learning and can maximize resources while possessing a sense of urgency.

EDUCATION:

·         MBA, Information Systems Management

·         BBA, Business Administration in Management and Marketing

CERTIFICATION & TRAINING

·         MCITP - (Microsoft Certified IT Professional - Database Administration: SQL Server 2008)

·         Certified on SQL Server 2008: Cluster Implementation and Administration, Data Group, Alexandria, VA

·         Certified on SQL Server 2008: Replication & Database Mirroring, Data Group, Alexandria, VA

·         Certified on SQL Server 2008: Reporting Services, Data Group, Alexandria, VA

SKILLS:

SQL Server Tools: SQL Server Management Studio, Enterprise Manager, Business Intelligence Development Studio, Query Analyzer,  SQL Profiler, SSIS and DTS, Replication, Clustering, Database Tuning Advisor and Index Tuning Wizard, BCP, SQLCMD, Reporting Services Report Manager, Reporting Services Configuration and Report Builder, Upgrade Advisor, SQL Configuration manager and Service manager, Client and Server Network Utilities, Surface Area Configuration.

Database:	SQL Server 2008/2005/2000,  MySQL (4.0.3, 5.0.1), Sybase, Oracle, MS Access 2003 & 2000
Operating System:	Windows Server 2008/2003/2000, Windows XP/NT4.0, MS-DOS, VMware
Languages:	SQL, T-SQL, PL/SQL,  L, DHTML, XML JavaScript, ASP, ASP.net and C++
Reporting:	SSRS (SQL Server Reporting Services)
Data Modeling:	SSDD (SQL Server Database Diagram)
Third-Party Tools:	Idera, SQL Admin Toolset, SpotLite, ERWin, Visio, Toad Data Modeler, and Toad for SQL Server Admin.
Hardware/Storage:	SAN, RAID
Networking:	Active Directory, TCP/IP, DHCP/DNS/WINS, LAN, SNMP SMTP, HTTP, and OSI Reference model

Technical Summary

·         Working experience with the new features of SQL Server 2008 such as database mirroring, online indexing and recovery

·         Deep understanding and working experience of SQL Server (SQL 2000, SQL 2005 and SQL 2008), MS Access, Oracle 10g, Sybase, MySQL includes installation, configuration, and maintenance of standalone and Clustered Servers [Active/Active and Active/Passive Cluster Design]

·         Performed Data Modeling, data analysis, database design, and developing E-R diagram using ERWin, Database Diagram

·         Optimizing and Performance Tuning, Query Optimization, Performance Tuning  using execution plan, Profiler, Database Tuning Tool , Windows Performance Monitor

·         Experience in resolving Dead Locks or long running queries and slow running server

·         Performance monitoring using different tools comes with the MS SQL Server and third party tool like SpotLite, Idera SQL Diagnostic

·         Experience in administering AD (Active Directory)/Domain and monitoring user activities

·         Expert of database Backups and Restoration

·         Strong knowledge and experience in configuring and administering High Availability Database like Database Mirroring, Replication, Log shipping, Cluster Database

·         Vast knowledge and working experience on SSIS, DTS, SQL Server Reporting Services, scripting for customized Report Generation

·         Knowledge of Microsoft Best Practices with regards to configuration of SQL data/log drive locations

·         Experience with Security and Audit Management

·         Strong working experience in installing, upgrading, and maintaining Web servers (IIS) and Operating Systems: Microsoft Windows Server Family (2000,2003, 2008)

·         Installing and configuring VMware and Synergy

·         Applied Service Pack (SP) and hot fixes for Databases, Operating Systems

·         Migrated databases from other databases like Oracle 10g, MySQL, Sybase to SQL Server 2008

·         Upgraded databases from MS SQL Server 7, 2000, 2005 to MS SQL Server 2008

·         Deployed Databases in Test, Dev and Production environment

·         Deployed web-based applications, websites in the application/web-server like IIS (Internet Information Services)

·         Strong Data Modeling Experience as worked on more than 9 data modeling projects including gathering and analyzing business requirements

·         Strong working experience in creating and supporting database administration scripts; scheduling jobs

·         Working experience in configuring and setup mail server for database mail notification

·         Good customer support experience in providing end-user support on a day-to-day basis

·         Working experience with SAN and RAID

·         Experience using Configuration Tools such as SQL Server Configuration Manager and SQL Server Surface Area Configuration

·         Worked on Linked and Remote Servers to run queries between SQL servers and other data sources using ODBC, OLE DB drivers

·         Installed and maintained Microsoft Reporting Services [MSRS] on 2000 and SQL Server Reporting Services [SSRS] 2005 and 2008

·         Experience in creating and scheduling SSIS/DTS packages

·         Database Migration: Migrated MS Access 2003/2000/97 databases into MS SQL Server. Migrated Oracle 10g, MySQL, Sybase database into MS SQL Server 2008. Imported data fromDB2, Oracle, Excel, Flat file, CSV file to SQL Server Database

·         Good experience in writing and debugging SQL Server stored procedures/triggers and documenting issues/resolutions of SQL Server Applications

·         Proven ability to deliver high quality products and services on schedule and under budget. Self-motivated team player with excellent verbal and writing communication skills. Experience in business analysis, project management, supervisory, and team leadership.

PROFESSIONAL EXPERIENCE:

Royal Exchange Inc. Virginia                                                                                                                           January, 2009 – Present

Database Administrator

Responsibilities and Accomplishment:

·         Lead for 6 Servers

·         Lead for Backup and Recovery

·         Installed, Configured, and Administered SQL Server 2005 & 2008  in development, test, and production environment

·         Installed and Configured Operating System, Windows Server (2000, 2003 & 2008)

·         Database High Availability: Installed, Configured and Managed Database Mirroring, Replication and Log Shipping. Installed, Configured and Maintained Fail-Over Cluster Servers in SQL Server 2005 & 2008

·         SQL/T-SQL, Triggers, And Stored Procedure: Wrote SQL, T-SQL, Stored-Procedures and triggers. Assisted SQL developers to optimize SQL queries, Stored Procedures and Triggers

·         Monitoring and Performance Tuning: Performed database monitoring and Performance tuning. Monitor Servers activity, and worked with clients to solve different problems. Performed index and statistics management. Managed SQL Server Error Logs, space usage, growth pattern. Used DBC and ALTER C statements to check and manage database consistency, index fragmentation/rebuilding, statistics. Managed BLOCK and LOCK

·         Database Automation: Created Backup jobs for different types of backup like FULL, Differential and Transaction Log. Created Jobs for database maintenance Index fragmentation, rebuild, database statistics. Created BAT programs to move backup and other files to backup servers

·         Data Modeling: Worked on different Data Modeling projects using Toad Data Modeler on designing Logical & Physical Database. Used Backward & Forward Engineering to create Logical and Physical database

·         Index/Constraints, Triggers, Stored Procedure: Created and managed Index (Cluster/Non-Cluster), Constraints

·         Security Management: Created and Managed users, roles, security at object level, data encryption

·         Export & Import data from/to Oracle, MySQL, and Access Database including flat files like text, excel, and CSV files to SQL Server 2005/2008

·         Database Migration: Migrated MS Access 2003/2000/97 databases into MS SQL Server. Migrated Oracle 10g, MySQL, Sybase database into MS SQL Server 2008. Imported data from IBM DB2, Oracle, Excel, Flat file, CSV file to SQL Server Database, Successfully done a project Data Center Relocation.

·         Backup/Recovery: Work experience and strong knowledge in disaster recovery. Rebuild databases using backups

·         Reports: Installed, Configured, and administered SQL Server Reporting Services (SSRS). Developed Reports using SSRS. Developed Ad-hoc Reports using Report Builder 3.0, 2.0. Deployed Reports. Managed security for reports

 

NBTY, Inc. New York                                                                                                                           March, 2005 – December, 2008

Database Administrator

Responsibilities and Accomplishment:

·         Maintained mission critical production database as well as production applications including Emergency off-hour support

·         Installed and configured SQL Server 2000, and 2005 on Windows Server 2000 and 2003 as standalone and Clustered Servers

·         Automating Database tasks (Created jobs, alerts, and schedules for database maintenance tasks)

·         Wrote SQL/T-SQL codes, stored Procedures, Triggers and Functions

·         Helped database developers to tune up SQL/T-SQL Queries

·         Applied Service Packs, and hot fixes

·         Performed database backups, restored database from backup

·         Replication: Configured and maintained transactional and merge replication

·         Security Management: Access and security management like creating Logins with appropriate roles. creating users and groups  and granting and revoking privileges for data security

·         Migrated Oracle, MySQL, MS Access 2000/97 databases into MS SQL Server 2000and2005

·         Standby and Mirroring: Configured and Maintained Replicated database using LogShipping and Replication in SQL Server 2000 and 2005 for high availability

·         Performed performance: Using SQL Server profiler, Windows performance monitor and Database engine tuning advisor to analyze and fine tuning of long running queries and stored procedures and slow running servers

·         Documentation: Created documentation for installation, monitoring procedures, security policies, configuration changes, migration procedures, and best practices

·         Reporting Services: Installed, configured and maintained SQL Server 2000/2005 Reporting Service. Managed reports and helped developers in designing and developing reports

 

REFERENCES:

Available on request

Download Resume Format