SEARCH

Database Administrator Resume Example

Resume Score: 90%

Love this resume? Build Your Own Now
DATABASE ADMINISTRATOR
Career Overview
Databases: MS SQL Server 2000, 2005, 2008 & 2008R2 Languages: MS SQL /T-SQL, Stored Procedure, Trigger, function.,.NET and ASP.NET Hardware: EMC SAN, RAID Operating System: MS Windows Server 2000, 2003, 2008, Windows XP, Windows 7 Software: Microsoft Office Word, Excel, PowerPoint, Visio, NotePad++, Ultra Edit, Business Requirements Analysis
Qualifications
SQL Server Database Administrator SQL Database Administrator with over five years of experience in administering SQL databases.Proficient in SQL Server 2000, 2005, 2008 & 2008R2,2012. Experienced working with different projects. Highly professional and a great team player.
Work Experience
Database Administrator
May 2012 to Current Innovation Health - Hyattsville, Maryland
  • Currently working as a database administrator as well as supporting configuring and analyzing client systems, testing and implementing software upgrades; maintaining security configuration and patches tracking performance from backend, troubleshooting issues.
  • Responsibilities : Installed and Configured SQL Server 2005 ,2008,2012 in development, test and production environment Installed and Configured Operating System; Windows Server (2000, 2003 and 2008) Migrated databases from Oracle 10g, MySQL (4.0.3, 5.0.15) to SQL Server 2008 Upgraded earlier versions of SQL Server 2000 to SQL Server 2005/2008 and SQL Server 2005 to SQL Server 2008 Migrated MS Access 2003/2000/97 databases into MS SQL Server 2000/2005/2008 Closely work with business analyst to deploy databases and manage availability Rebuild Servers (Restore & Recover) from backups Configured and Managed Log Shipping from Production to Standby Server (Running as Reporting Server) Configured and Managed Database High Availability: Replication, Database Mirroring, Log Shipping, and Clustering Wrote SQL, T-SQL, Triggers and Stored-Procedures Worked with developers to tune-up performance of SQL and T-SQL query Performance tuning &optimization of servers in production, test environment Created and managed database security, data encryption, and applied object level security Developed and applied Backup strategy at my current workplace Setup and configured Database mail for notification purposes Developed Database Maintenance Plan for different important tasks Used DBCC and Alter statements for different database Administration tasks like check database consistency, rebuild indexes, statistics, and other jobs Used DMV (Dynamic Management View) for different database Administration tasks like find backup history, indexes fragmentation, statistics, and status of different jobs Exported&Imported database objects from/To Oracle, MySQL, Access Database, flat files (text, excel, and CSV files) and MS SQL Server Extensive experience in using SSIS/DTS, BCP to import & export data from flat files, excel, MS Access, and Other OLEDB databases to MS SQL Server databases.
August 2010 to April 2012 Department of Energy - Washington, DC
  • Installed, Configured, and Managed SQL Server 2000 &2005 in development, test, and production environment Installed, Configured and Maintained Fail-Over Clustering using SQL Server 2005 Installed and Configured SQL Server Reporting Services (SSRS) Configured and Maintained Replications, Log Shipping as part of a high availability solution Upgraded databases from SQL Server 2000 to 2005 in testing and production environment Applied SP (Service Pack) on SQL Server 2000, 2005 Expertise in database Performance tuning Writing T-SQL and Stored-Procedures Responsible for creating, modifying and managing tables, Index (Cluster/Non-Cluster), Constraints (Unique/Check), Views, Stored Procedures, Triggers Export & Import data from Flat file, CSV file, Oracle, MySQL, and Access to/from SQL Server Database using DTS, SSIS, and BCP Data modeling using Toad Data Modeler and Visio Generated Report using SSRS (SQL Server Reporting Services) Responsible for Database Backup, Restore and Point-in-Time Recovery Monitor Server Activity, Error Log, space usage, and solving problem as needed.
February 2009 to July 2010 Federal Credit Union - Bethesda, Maryland
  • working as database administrator responsible for Installed, Configured, and Managed SQL Server 2000 &2005 in development, test, and production environment Installed, Configured and Maintained Fail-Over Clustering using SQL Server 2005 Installed and Configured SQL Server Reporting Services (SSRS) Configured and Maintained Replications, Log Shipping as part of a high availability solution Upgraded databases from SQL Server 2000 to 2005 in testing and production environment Applied SP (Service Pack) on SQL Server 2000, 2005 Expertise in database Performance tuning Writing T-SQL and Stored-Procedures Responsible for creating, modifying and managing tables, Index (Cluster/Non-Cluster), Constraints (Unique/Check), Views, Stored Procedures, Triggers Export & Import data from Flat file, CSV file, Oracle, MySQL, and Access to/from SQL Server Database using DTS, SSIS, and BCP Data modeling using Toad Data Modeler and Visio Generated Report using SSRS (SQL Server Reporting Services) Responsible for Database Backup, Restore and Point-in-Time Recovery Monitor Server Activity, Error Log, space usage, and solving problem as needed.
Education and Training
Bachelor of Science
Training & Certifications Certification Administering Microsoft SQL Server 2012 Databases MCITP (Microsoft Certified IT Professional) - SQL Server 2008 SQL Server 2008 - Administration SQL Server 2008 - Reporting Services, SSIS, Relational Database Design
Skills
Backup, business analyst, Clustering, encryption, client, Data modeling, DTS, Database Administrator, database Administration, Databases, Database, managing, Access, Access Database, MS Access, Microsoft Certified, excel, mail, 97, SQL Server 2000, 2000, MySQL, OLEDB, Operating System, optimization, Oracle, Relational Database Design, Reporting, Servers, Shipping, MS SQL Server, Microsoft SQL Server, SQL, SQL Server, statistics, strategy, tables, team player, Toad, T-SQL, troubleshooting, Unique, upgrades, View, Visio, Windows Server
Build Your Own Now

Resume Overview

Companies Worked For:

  • Innovation Health
  • Department of Energy
  • Federal Credit Union

Job Titles Held:

  • Database Administrator

Degrees

  • Bachelor of Science
    Training & Certifications Certification Administering Microsoft SQL Server 2012 Databases MCITP (Microsoft Certified IT Professional) - SQL Server 2008 SQL Server 2008 - Administration SQL Server 2008 - Reporting Services, SSIS, Relational Database Design

Advertisement

Similar Resumes

View All

Database Administrator

Manger of Data Systems

Denver, Colorado

Posted 1106 days ago