We provide IT Staff Augmentation Services!

Sql Server Dba Resume

3.00 Rating

Washington, DC

SUMMARY

  • An accomplished proactive DBA with 5+ years of proven experience with demonstrated success in managing and supporting database solutions in development, test and production SQL Server environments.
  • As a self motivated, responsible person, I aim to get a challenging position as a SQL Server DBA in a team - oriented environment that will let me to exploit and excel my technical and interpersonal skills.
  • Authorized to work in the US for any employer CORE.

TECHNICAL SKILLS

Database: SQL Server 2005/2008R2/2012/2014, MS Access, MS Excel, SSIS, SSAS, SSRS

Language: T-SQL, PL/SQL, VB, VBA, HTML, Power Shell.

System/OS: Windows Server 2003/2008/2012 , Windows XP/Vista/7/8/10, Linux.

Statistical software: SPSS, STATA, SAS, R.

Microsoft Office: Microsoft Word, Microsoft Excel, Microsoft PowerPoint, and Microsoft Access

PROFESSIONAL EXPERIENCE

Confidential - Washington, DC

SQL Server DBA

Responsibilities:

  • Providing 24/7 dedicated support for development and production SQL Server environments.
  • Installed, configured and managed SQL Server 2012 and SQL Server 2014 in development, test and production environments.
  • Managed rebuilding and reorganizing indexes Confidential regular intervals for optimal performance.
  • Designing and implementing comprehensive backup plan (FULL and LOG) disaster recovery strategies.
  • Migrated databases from SQL Server 2008R2 to SQL Server 2012
  • Involved in installing, configuring and maintain Always On Availability Groups in development and production servers.
  • Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
  • Monitoring SQL Server performance using SQL Profilers, DMVs, execution plans, dead- locks and database engine tuning advisor.
  • Recovered databases from backups in disasters.
  • Maintaining database consistency checks using DBCC CHECKDB regularly
  • Involved in creating many SSIS packages using SSDT, ETL and Import/Export wizards.
  • Experience in SQL Server Reporting Service (SSRS).

Environment: MS SQL Server 2008R2, SQL Server 2012/2014, SSIS, SSAS, SSRS, MS Access 2013, Windows Server 2012 (NT 6.2), Windows 7/8/10, SQL Admin Toolset, Idera.

Confidential - Groningen

Database Administrator

Responsibilities:

  • Upgraded and configured SQL Server 2008R2 from SQL Server 2005 on Windows Server 2003 and applied service packs and security fixes.
  • Responsible for a large scale database migration from SQL Server 2005 to SQL Server 2008R2
  • Involved in scheduled and manual database and log backups both in development and production environments.
  • Responsible for installing, configuring and maintaining SQL Server Failover Clustering for two production environments.
  • Responsible for high availability of databases using log shipping and database mirroring.
  • Involved in improving database performance using SQL Profiler, Database Engine Tuning Advisor, DMVs and execution plans.
  • Responsible for securing SQL Server, user management taking care of permissions and roles.
  • Migrated application codes and objects from development/test to production environment.
  • Scheduling jobs and alerts using SQL Server Agent.
  • Rebuilding indexes Confidential regular intervals for better performance.
  • Export/Import data from flat files, CSV, DTS, SSIS and BCP.
  • Used third-party tools like Red Gate and SQL Tool Belt to backup and restore operations.
  • Had a good experience in 24/7 in SQL Server production support.

Environment: SQL Server 2008R2, SQL Server 2012, SSRS, SSIS, DTS, Windows Server 2003/2008, Windows 7

Confidential - Addis Ababa

Junior Database Administrator

Responsibilities:

  • Installed and configured SQL Server 2008R2 for over twenty Confidential branches across Ethiopia
  • Involved in upgrading to SQL Server 2008R2 from SQL Server 2005
  • Responsible for large scale database migration from SQL Server 2005 to SQL Server 2008R2
  • Performance analysis using index tuning advisor, performance monitors (PerfMon), CPU, I/O and memory counters and monitors.
  • Configured and maintained transactional replication between production environments.
  • Scheduled database maintenance tasks to improve performance.
  • Backing up (FULL, LOG & DIFF) and restoring user and system databases.
  • Responsible for securing the SQL Server, all system and user databases, user management and taking care of permissions and roles.
  • Involved in maintain databases with maximum availability and resolve any database issues
  • Worked with development and system teams to boost performance of the bank system and the SQL Server.

Environment: SQL Server 2000/2005/2008 R2, T-SQL, SSIS, SSRS, Windows Server 2003, Windows XP/ Vista/7.

We'd love your feedback!