SQL Server Database Administrator Resume Rockville, MD - Hire IT People

SUMMARY:

SQL Server Database Administrator with versions from 7 to 2016, supporting company databases 24X7 in mid - size datacenter (26 database servers, over 200 databases). Maintain Recovery Time Objectives and Recovery Point
Objectives for each database. Implement and maintain successful database environment, including SSIS integrations. Schedule and monitor of SQL Server jobs, SSAS, Reporting Services maintenance, install and support of back end of 3rd party tools. Establish policies and procedures pertaining to production, testing, and development groups. Good team player and autonomous problem solver.

TECHNICAL SKILLS:

Visual Basic
MS Access
T-SQL
Solarwinds DPA
ODBC
MS Excel

PROFESSIONAL EXPERIENCE:

Confidential, Rockville, MD

SQL Server Database Administrator

Tools: SQL Server, Red-Gate SQL Compare, Litespeed, Solarwinds DPA, Reporting Server, SSIS, ETL, SSAS, Postie, Robocopy, Oracle,VBScript.

Responsibilities:

Responsible for 24X7 support of High Availability SQL Clusters and stand - alone servers running SQL Server databases on rotational basis.
Monitor and maintain production MS SQL Server environment. Track and resolve database related requestsfulfill incidents, review service related reports (performance tuning, user privilege changes, custom backups, ad hoc data extracts, database synchronization to dev\test groups) on a daily basis to ensure service related issues are identifying and resolving issues, responding to database related alerts and escalations and work with different departments within the company to come up with strategic solutions to mitigate recurring problems.
Collaborate with developers and testers in implementation of fast and flawless deployments.
Write detailed operational database related documentation and specifications.
Administer user profiles, user rights, security policies
Schedule and monitor SQL Server jobs to automate integrations and maintenance packages.
Setup tracing and audit procedures
Improve procedure performance, tuning databases.
Monitor database capacity issues, replication, and other distributed data problems
Rebuild / monitor indexes at regular intervals for better performance
Develop backup systems, data transfer and migration between different systems
Migrate SQL databases from legacy systems to new environments.
Data import/export ( ETL ) from other systems into SQL Server with SSIS and DTS.
Generate report for management presentations
Archive historical data, monitor health of databases
Monitor SQL job logs to identify success or failures; troubleshoot and debug database related issues.
Monitor and maintain database disk space.
Backup and restore of databases
Support database environments for DevOps and testers, set automated refresh from production
Install and configure database part of 3rd party software on dev/test prod servers
Plan and implement disaster recovery: log shipping, mirroring, replication
Patch database servers
Work with IT Network specialists to set High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server.

Confidential, Washington, DC

SQL Server Database Administrator /Systems Analyst

Tools: SQL Server 7-2000, Visual Basic 6.0, MS Access, VBA, DTS, Crystal Reports, Norton Antivirus 9.0 Corporate edition, Microsoft Security Analyzer, Windows NT, Windows Server

Responsibilities:

Implement full life cycle design, development, support of multiple Client/Server systems based on Microsoft technologies including requirements documentation, analysis, project planning, high - level and detail design
Design application and database architecture, code, test and debug of software components
Database design, maintenance and data integrity support
Resolve database performance and capacity issues, and other distributed data problems
Develop of backup system, create data transfer processes, and migrate data between different systems
Generate reports, test recovery procedures.
Detect and disable of system intruders on client desktops, remove spyware, Trojans, worms, unauthorized software
Administration of user profiles, user rights, security policies, configuring software, hardware/software installation
Maintaining Windows and Windows NT Servers and user PCs
Working with customers to determine needs, discuss software methodologies, and resolve ad hoc requests

Confidential, Greenbelt, MD

Programmer /Analyst, Consultant

Tools: SQL Server 7, Visual Basic 6.0, Oracle, MS Access, Excel, and Crystal Reports.

Responsibilities:

Create data transformation procedures from MS Access and Excel,
Create SQL Server Jobs, develop of procedures, triggers and functions
Analyze data integrity issues and create solutions to improve data flow

Confidential, Vienna, VA

SQL Server DBA, Programmer /Analyst, Consultant

Tools: SQL Server 7.0, DTS, ASP, Visual InterDev, Visual Basic 6.0, MS Access, MS Excel.

Responsibilities:

Design database, create tables and other objects, import data, create and schedule SQL Server Jobs, SQL Server backup and recovery, DTS-import-export packages

We provide IT Staff Augmentation Services!

Sql Server Database Administrator Resume

Rockville, MD

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship