Sql Server Dba Resume
2.00/5 (Submit Your Rating)
New York, NY
SUMMARY:
- Hands on experience in financial, bank, pharmaceutical, market research, environmental and education industries.
- Detail - oriented with good analytical and problem solving skills.
- Enjoy working as a team member, as well as independently.
- Quick learner. Able to work in a fast - paced, challenging environment.
- Good communication skills.
TECHNICAL SKILLS:
Programming Skills: SQL (Stored Procedure, View, Trigger, Function, Cursor), ASP.Net, ADO.Net, XML, HTML
Applications: SQL Server 2000/2005/2008, SQL Server Reporting Services (SSRS), SQL Server IntegrationServices (SSIS), SQL Server Analysis Services (SSAS), Visual Studio 2005/2008, BIDS
Operating Systems: Windows 98/2000/XP/NT/2003, DOS
Others: MS Office Suite 2000/2003/2007/2010, Photoshop, TCP/IP, IIS
PROFESSIONAL EXPERIENCE:
Confidential, New York, NY
SQL Server DBA
Responsibilities:
- Developed backup/restore/upgrade and disaster recovery plans for production servers and participated in client’s weekly or monthly conference call meeting for quality improvement.
- Installed, configured and secured production SQL Servers. Implemented and administered high availability solutions including clustering, replication, log shipping and database mirroring.
- Joined emergency bridges or releases to troubleshoot outages, remediated database server issues, initiated and approved production changes.
- Administered over 100+ SQL Servers in a team environment and provided 24X7 dedicate support for both production and development SQL Servers.
Database & Web Developer
Responsibilities:
- Developed SQL queries in the back-end using DML (select, insert, update, delete) and DDL (create, alter, drop) to ensure data entered on the website were being read, saved, updated and deleted from the database. Developed web forms and controls used by the front-end.
- Created templates and designed queries to populate bookmarks on the templates in order to generate documents. Ensured data being inserted, updated and deleted from the database were also logged to the document and log libraries.
- Created and revised stored procedures, views and triggers for audit and security purposes.
Database Support
Responsibilities:
- Performed install, backup, restore, capacity analysis for 2000/2005 databases. Developed DTS, SSIS packages and SSRS reports for reporting purposes. Created maintenance plan, scheduled jobs and performance alerts. Rebuilt and reorganized index for index fragmentation.
- Assisted in setting up database mirroring, clustering and log shipping. Troubleshot user permission issues.
