We provide IT Staff Augmentation Services!

Sql Server Dba Resume

5.00/5 (Submit Your Rating)

Lorton, VA

SUMMARY

  • Solutions - driven Microsoft Certified IT Professional with a successful background in managing, analyzing and implementing large SQL Server databases.
  • High level of proficiency in requirements gathering, customer service, and mentoring junior team members.

TECHNICAL SKILLS

  • SQL Server Administration
  • SQL Server Security
  • MS SQL Server 2005/2008/2012
  • Client Orientation / Customer Service
  • Product Installations & Support
  • SQL Server Engine Internals
  • Microsoft SQL Server 2005/2008/2008 R2/2012
  • Microsoft Windows Platforms (2003, 2008, 2008 R2, 2012)

PROFESSIONAL EXPERIENCE

Confidential, Lorton, VA

SQL Server DBA

Responsibilities:

  • SQL Server Hardening: I was in charge of hardening 65 SQL Server database servers to comply with the DISA STIGs. I planned and executed SQL Servers upgrades and patch maintenance.
  • I requested and installed server level certificates across all database servers and enforced instance-level encryption.
  • I configured custom scripts to create SQL Alerts to notify all necessary team members of pending SQL Server issues such as I/O subsystem anomalies, insufficient resources and fatal errors. I setup SQL Trace and SQL Audit on all servers to comply with STIGs requirements. I implemented database encryption across 130 databases using SQL Server TDE using 256-bit AES encryption algorithm. I created a custom script to notify appropriate team members of hard disk storage levels below certain threshold.
  • Standardize SQL Server Maintenance: I configured and setup SQL Server database backup, integrity check, and index and statistics maintenance as well as SQL Agent jobs across all 65 SQL Servers to meet organization SLA. I configured server-wide database backup compression that saves between 70-95% in storage space per database backup. I configured database mail notifications to alert all necessary team members of any agent job failures.
  • Documentation: I am responsible for documentation of all 65 SQL Servers recording all security changes, modifications as part of the DISA requirements.
  • Patching / Upgrades: I am part of the maintenance patching team that comes in after hours every 3rd Saturday of the month to apply all security patches, upgrades and updates.
Confidential, Vienna, VA

SQL Server DBA

Responsibilities:

  • National Guard Bureau (NGB): I worked with the Lead DBA for an enterprise level imaging solution DOCS. The DOCS imaging solution is designed to replace an existing image product with a 30TB data store and will be the central image storage repository for 10+ other applications and over 1000 users. Duties included; backup / restore, index management, disk space management and SQL Server Agent jobs management per company SLA.
  • SADMS (Sexual Assault Database Management System): I worked as a SQL Developer and wrote SQL code to enhance web applications. I maintained production and development servers and manages user roles. Under the supervision of the senior database developer, I successfully executed SADMS monthly SQL data ETL processing to include debugging and data failure recovery. I helped streamline existing legacy business processes and created new SQL stored procedures to facilitate new data reports using SSRS. I created reports that were used in Congressional Hearings on sexual assault in the Army.

We'd love your feedback!