Ms Sql Database Specialist Resume Maryland Sql Database Specialist Maryland - Hire IT People

SUMMARY:

Seven plus years hands - on professional experience as a SQL Server Production DBA.
Experience with MS SQL Server
Administered over 200 SQL Server databases spread across PROD/DEV/QA
Broad knowledge of backups, restores, recovery models, T-SQL, SQL, DBCC commands, Database Mirroring and Log Shipping.
Broad knowledge of High Availability/Disaster Recovery
Experience in troubleshooting and resolving frequent database issues including integrity issues, error log, connectivity, and security related issues e.t.c
Experience in installing and configuring SQL Server, applying patches and fixes
Broad knowledge in setting up and managing database security by creating new users, roles, profiles, setting up audits and providing required user privileges in development, test, and production environments for SQL server.
Experience in monitoring, troubleshooting and performance optimization related issues
Broad knowledge in Configuring SQL Server Agent, create, maintain and monitor jobs
Have excellent analytical, problem solving, communication and interpersonal skills with ability to interact with people at all levels and can work as part of a team or independently
Devoted and Quick learner with capability to master and implement new technologies
Excellent presentation and documentation skills

TECHNICAL SKILLS

Databases: SQL ServerTools: BCP, Import and Export Wizard, Profiler, Perfmon, ServiceNow, TSQL,SSIS & SSRS

Microsoft Office: (Word, Excel, Power Point, Outlook, Access, OneNote)

Operating System: Windows server 2005, windows server 2008, Window Server 2012 R2

PROFESSIONAL EXPERIENCE:

Confidential, Maryland

Sql Database Specialist

Duties and Responsibilities:

Installed, Configured, and Administered SQL Server,
Provide Production Support for MS SQL Server Databases
Performed Disaster Recovery
Backed up databases using Full, Differential, Transaction backups
Restored Database from database backups and file backups
Monitored Server Activity, Error Log, and capacity planning
Performed database migration and upgrade from SQL server
Installed and applied Service Packs (SP) and Security updates on SQL Server 2008 and 2012
Able to use ServiceNow to run reports, to create tasks for another dept. and e.t.c
Utilization of T-SQL Scripting
Database Refresh from Production to QA
Strong knowledge of Crontab/CMS for scheduled jobs
Ability to create/alter users in SQL Server
Perform data export/import
Experience with performance tuning with SQL Server (Profiler, Execution plans, DTA)

Confidential

Database Administrator

Duties and Responsibilities:

Installed, Configured, and Administered SQL Server,
Backed up databases using Full, Differential and Transactional log backup methods
Restored Database from database backups and file backups
Maintained logical consistency of the database by running DBCC statements and rebuilding\reorganizing indexes
Monitored the performance of Database Backup and other jobs in the maintenance plan Restoration and Point in-Time Recovery and optimized as needed
Monitored Server Activity, Error Log, and capacity planning
Maintained server level, database level and object level security best practices by creating logins and users, configuring permissions and assigning different roles to users
Configured Database Mail and SQL Server Agent

Confidential

IT Support Specialis

Duties and Responsibilities:

Installed and Configured Computer system, hardware, software, printers and scanners
Monitoring and Maintaining Computer systems.
Providing technical support across the company.
Resolving and responding in a timely manner service issues and request.
Testing new technologies and setting up new user accounts.