Sql Server Dba Resume
New York, NY
PROFESSIONAL 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 Integration Services (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:
SQL Server DBA
Confidential, New York, NY
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
Confidential, Chatham, NJ
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
Confidential, New York, NY
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.