We provide IT Staff Augmentation Services!

Database Administrator Resume

Washington, DC

OBJECTIVE:

I am a Microsoft Certified Database Administrator with experience in backup, maintenance, security, and recovery of SQL Server, seeking the Position of MS SQL Server Database Administrator

SUMMARY:

  • Microsoft Certified SQL Server Database Administrator (DBA) with over four years of experience in MS SQL 2000, 2005 & 2008.
  • Well experienced in Installation, Upgrade and Configuration, Server security, Performance Tuning, Query Optimization, Client/Server Connectivity, Data Transformation Services and running Database Consistency Checks using DBCC, Database Backup, Recovery and Disaster Recovery procedures, implementing SQL server high availability tools like Log shipping and replication.
  • Moderate experience on T - SQL
  • Excellent interpersonal communication (oral/written) teamwork player, fast learner, hard worker, and versatile

TECHNICAL SKILLS:

Database: MS-SQL Server 2000 & 2005/2008

Configuration: SQL Server Surface Area Configuration, Database Mail Configuration, SQL Server Configuration Manager, Microsoft Database Upgrade AdvisorDevelopment Environment: SQL Server Management Studio Query Analyzer, Enterprise Manager, SSIS and DTS

Performance Tool: Database Engine Tuning Advisor, Profiler, Reliability and Performance Monitor

Operating Systems: Window 2000/2003/2008/ XP/Vista

Application Software: Microsoft Office 2003/2007/2010 GLPI Ticketing, Nagios.

PROFESSIONAL EXPERIENCE:

Database Administrator

Confidential, Washington, DC

Responsibilities:

  • Create reports and data extracts on SQL Server databases using SQL Server Reporting Services (SSRS)
  • Plan, develop and produce SQL Server database reports
  • Quickly and accurately produce ad hoc reports
  • Manage SQL server database administration assignments for diverse industry clients.
  • Enhance database performance, perform restores, implement recovery procedures, handle performance tuning and conduct regular system backups.
  • Ensure technical and functional designs meet business requirements.
  • Managed a data-integration project for financial services firm that consolidated information from accounting applications, third-party market data and internal equities/fixed income applications.
  • Innovated time-saving, robust employee data-intake system that automated database update functions, enabling new salary and process-exception information to be automatically populated.
  • Developed and tested storage strategies and disaster-recovery plan for large manufacturing company's operational database, delivering solution that guaranteed recovery performance and high availability.
  • Synchronizing SQL Databases from development to production through SSIS/DTS packages, SQL jobs, and SQL scripting
  • Creating and maintaining processes and procedures with regard to database administration
  • Migrating databases from SQL 2000/2005 to SQL 2008

Assistant Database Administrator

Confidential

Responsibilities:

  • Perform day to day Database Maintenance tasks -- Database Monitoring, Backups, Space Management, Resource Utilization, responsible for performing object migration between all production database Servers.
  • Manage SSIS packages, stored procedures, jobs, and utilize Server Side tracing to identify performance issues with deadlocks & other locking issues. Proficient with Server-Side System Default.
  • Setup and configure SQL Server for other business functions. Index & Data Management to determine Defragmentation level; whether to Update Statistics or Rebuild Indexes. Manage user and data security to allow access to appropriate resources.
  • Export data from Access to Excel and Data files.
  • Providing support of Database connectivity for Developers and users.
  • Installing SQL server 2005 as instance on a SQL Server 2008
  • Creating file groups and files for separating frequent transactions and static data.
  • Managing the recovery model and setting while productions for better performance.
  • Creating databases backup and high availability strategies.
  • Resolving various performance issues running DBCC commands, SQL Tracer, SQL Profiler and using activity monitor.
  • Performing maintenance of database mirroring with automatic recovery by configuring a witness server for constant availability of sales.

Hire Now