SQL Server Database Administrator Resume Washington DC - Hire IT People

SUMMARY

Certified SQL Server Database Administrator wif 4 plus years of experience and an in - depth understanding of SQL Server administration, design, development, and implementation on a fast paced 24/7 environment using SQL Server 2012/2008R2/2008/20005/2000
n Operating Systems like,Windows Server 2003, Windows Server 2008, Windows Server 2008R2, Windows Server 2012, Windows XP,Windows Vista, Windows 7,Windows 8 and VMware as well, good use and understanding of native and third party monitoring tools like, Activity Monitor, profiler, and Foglight and Idera tools.
High level of energy, integrity and ethics wif an exceptional ability to deliver outstanding bottom line results which improves productivity, also maintaining and automating database operations to minimize cost and meet short deadlines.

TECHNICAL SKILLS

Technical Skill Summary: Installed, Configured and Managed SQL Server 2005, 2008/R2& 2012 in development, test, and production environment

Backup/Recovery: Performed and also have strong noledge of Database Backup and Disaster Recovery Experienced wif Point-in-Time Recovery

Patch Management: Applied SP (Service Pack) and Hot Fixes on SQL Server2000, 2005, and 2008/R2

Performance Tuning: Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, and backup verification Tuned SQL Server and Monitored Server Error Log, space usage SQL Server 2000 to 2005/2008/R2 SQL Server 2005 to SQL Server 2008/R2/ to 2012Migrated MS Access 2003/97 databases into SQL Server 2005, and 2008/R2,2012

Data Modeling: Gave administrative support for developers on data modeling using tools like Toad Data Modeler and ER Diagrams.

Database Programming: Assisted Database Developers to optimize SQL queries and Stored Procedures Writing T-SQL, Trigger, and Stored-Procedures

SSIS: Undertook Export & Import operations from Flat file, CSV file to/from SQL Server Database using SSIS and BCP

PROFESSIONAL EXPERIENCE

Confidential, Washington DC

SQL Server Database Administrator

Responsibilities:

Installed, Configure and Managed SQL Server in Test, Production, and Development Servers
Backup and Recovery: - Setup jobs, alters, notifications for backup, Restored Databases, Rebuild Servers
Created and modified tables, Index (Cluster/Non-Cluster), Constraints (Unique/Check), Views, Stored Procedures, Triggers
Security - Managed security, created and managed logins, users and roles, and implement password policy
Developed Database Maintenance Plan
Upgraded/Migrated databases from SQL Server to SQL Server (2000/2005/2008/R2/2012)
Performance Tuning - Performed Database, SQL Server, and index tuning, troubleshooting Lock and Block
Troubleshooting - Monitored and Analyzed SQL Server Error Log, Job Errors, Event related errors, space usage and take actions as needed
Used third party tools such as Idera and Foglight to monitor SQL server performance
Writing T-SQL and Stored-Procedures
Used DBCC commands as needed to check physical and logical consistency of the database, index Rebuild
Assisted SQL developers to optimize SQL queries and Stored Procedures
Data Modeling, worked wif business analyst, users and stakeholders to collect and analyze the requirements
High Availability Solutions - Implemented and Managed Mirroring and Replication/Transactional
Configured Log Shipping as Standby database from Production database for Reporting purposes
Used Serena Team Tracker for managing, tracking issues and generating Issue Reports
SSIS - Created and Deployed package, setup jobs using packages
Export & Import – Imported Data from Access Databases, flat files, excel, and CSV files into SQL Server databases

Environment: MS SQL Server2005,2008/R2/, and 2012, Windows Server 2008/R2, 2012 Enterprise Edition

We provide IT Staff Augmentation Services!

Sql Server Database Administrator Resume

Washington, DC

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship