Sql Server Manager

SQL SERVER DBA Resume

Title

SQL SERVER DBA

Primary Skills

SQL, T-SQL

Location

US-NJ-Somerset (will consider relocating)

Posted

Aug-31-12

RESUME DETAILS

SUMMARY SQL Server DBA with 6+ years of experience of IT experience with strong administration, design, development, and implementation experience using SQL Server 2008 R2/2008/20005.

Good Knowledge in installation, upgrade and configuration of MS SQL Server and databases in clustered and unclustered environments.

Experience in implementing different types of Replication Models like Snapshot and Transactional.

Hands on experience in Log shipping with SQL Server 2008/2005.

T-SQL coding and testing: functions, views, triggers, cursors, and stored procedures.

Experience in Performance Tuning, Query Optimization, Client/Server Connectivity.

Management of users including creation/alteration, grant of system/dB roles and permissions on various database objects.

Extensive experience in creating Tables, Views, Indexes, Stored Procedures, Cursors, Triggers and more.

Experience in creating packages, Scheduling Jobs, Sending Alerts using Database Mail.

Experience in upgrading from MSSQL Server 2005 to MS SQL Server 2008 R2.

Experience in using DBCC Utilities Checks Database Consistency.

Experience in SQL Server Integration Services (SSIS).

Experience in SQL Server Reporting Services.

Extensive experience in Capacity planning, Performance Tuning, Disaster Recovery, Troubles shooting, backup and restore procedures.

Creation and maintenance of Databases, creating Roles and managing user permissions.

Experience in investigating and applying necessary SQL Server database patches and installing service packs.

Documented disaster recovery plans and participated disaster recovery drills.

Excellent interpersonal, analytical and communication skills.

Good team player with strong analytical skills.

TECHNICAL SKILLS:

Languages T-SQL, PHP5, HTML/CSS, C, C++, VB

RDBMS MS SQL 2008 R2/2008/2005/2000, MySQL

Tools SSMS, SQL Server Profiler, SSIS, SSRS, Idera Diagnostic Manager, Idera Safe Manager, Idera Defrag Manager, SQL Query Analyzer, Enterprise Manager, LiteSpeed, RedGate SQL Backup, Erwin, Visio, Share Point Designer, Dreamweaver, Microsoft Office

Web Technologies JavaScript, jQuery, DHTML, XML, Ajax

Operating Systems Windows Server 2003/ 2008/2008 R2, Windows98/XP/Vista/7, Linux(Ubuntu)

Hardware Dell PowerEdge R900/R710

Certification MCTS

EDUCATION: M.S. E-learning Technology and Administration Northern State University

B.S. Management of Information System Capital University of Business and Economics

PROFESSIONAL EXPERIENCE:

Fannie Mae, Reston, VA Jun. 2011 -- Present

SQL Server DBA

Description: Fannie Mae is a government-sponsored enterprise chartered by Congress to keep money flowing to mortgage lenders, to help strengthen the U.S. housing and mortgage markets, and to support affordable homeownership.

Responsibilities:

• Creating and maintaining various databases on production/development servers and provide 24 x7 support

• Configured Log shipping from Production to Disaster Recovery server.

• Involved in development of automated daily, weekly and monthly system maintenance tasks such as database backup, integrity verification, replication verification, and indexing updates.

• Involved in designing and creating Databases, Tables, Views, Stored Procedures and Triggers.

• Identified, tested and resolved database performance issues to ensure data optimization.

• Used tools like SQL Server profiler, Performance Monitor to identify bottlenecks.

• Implementation of system wide security policies and trouble shooting.

• Involved in installing SQL Server 2008/2008 R2 on Development, Production.

• Troubleshooting high availability scenarios involving Clustering, Database Mirroring, Log Shipping and Replication.

• Deployed and scheduled SSIS package.

• Setting up Failover Clustering in SQL server 2008 (Active/Passive)

• Involved in migrating SQL Server Databases from Development to Production Server.

• Managed Login and User: adding logins, roles, groups to the Windows Server and MS SQL Server and maintaining proper security procedures.

Environment:

SQL Server 2008/2008 R2 Enterprise Edition, Windows Server 2008 R2 Enterprise edition, Idera SQL safe Manager, Idera Diagnostic Manager, Idera Defrag Manager, SSIS, Dell PowerEdge R900

Duane Reade, New York, NY Aug. 2010 -- May. 2011

SQL DBA

Description: Duane Reade is the most recognized drugstore chain in metropolitan New York. The Company operates over 253 stores in commercial and residential neighborhoods throughout New York.

Responsibilities:

• Involved in upgrading the instance of development environment of SQL Server 2005 service to SQL Server 2008.

• Created logical and physical database design, data structures, and implemented databases using Erwin.

• Developed, designed and documented tables, view, stored procedures, advanced queries, triggers, indexes and functions.

• Experience in Database Design activities including Data Files and File group organization, Capacity Planning, Data Partitioning and Data Normalization.

• Implemented Database Mirroring in SQL 2005/2008.

• Successfully implemented Log Shipping in SQL Server 2005/2008

• Analyzed business recovery requirements and maintained strategies and plans for critical databases

• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.

• Wrote T-SQL stored procedures and functions to efficiently perform complex business logic to summarize data.

• Migrated databases and database objects between multiple servers across production, QA and development platforms.

• Involved in Performance Tuning, Indexing, Query Optimization.

• Involved in Resolving locking and blocking issues.

Environment:

SQL Server 2005/2008 Enterprise Edition, Windows Server 2003/2008 Enterprise edition, Dell Poweredge M710, Idera SQL safe Manager, Idera Diagnostic Manager, Erwin, Visio

National Life Group, Montpelier, VT Sep. 2009 -- Jul. 2010

SQL Server DBA

Description: National Life Group is a diversified family of financial service companies that offer a comprehensive portfolio of life insurance, annuity and investment products to help individuals, families and businesses pursue their financial goals.

Responsibilities:

• Verify, maintain & troubleshoot database backups, integrity checks, and scheduled jobs.

• Troubleshoot and monitor SQL performance issues.

• Created stored procedures, scripts, cursors for the Bulk application, tested them on the test servers and moved them to production.

• Provide 24 X 7 dedicated support to all Production, QA & Development MS SQL Server Environments

• Involved in setting up Transactional Replication and Snapshot replication.

• Maintain DTS packages and SQL scripts for generating reports.

• Provide support to other developers and work with them to solve critical problems.

• SQL performance tuning.

• Involved in setting up and Troubleshooting clusters Application Center Clusters Performance tuning, and optimization of procedures and queries.

• Developed and document disaster recovery plan.

• Created Triggers to enforce data and referential integrity.

Environment:

SQL Server 2005 Enterprise Edition, Advanced Windows 2003 Server, SQL LiteSpeed, HP Proliant BL460c Server

Beijing Automotive Import & Export Corporation Jun. 2007 -- Jun. 2009

Beijing, China

SQL Server DBA

Description: Beijing Automotive Import & Export Corporation is a major and leading supplier of automobiles in China with capabilities ranging from auto manufacturing, parts supplies to technical solutions and import and export business.

Responsibilities:

• Installed SQL Server Management tools using SQL Server Setup Program. Test the Installation of SQL Server.

• Created Database Maintenance Plans for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.

• Created & managed the Database Users, Login and Security.

• Scheduled database backups and restored the Database from DR.

• Provide 24 X 7 support to all Production, QA & Development MS SQL Server Environments.

• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server

• Configured Replication Server, worked on replication server.

• Logical and Physical Data Modeling using Erwin.

• Identified the necessary steps to enhance user response time by checking fragmentation and re-index tables for efficient application access methods.

Environment:

SQL Server 2000/2005 Enterprise Edition, Advanced Windows 2003 Server, Erwin, SQL RedGate SQL Backup, Dell Power Edge 8450

Sinoprogress Consulting Company, Beijing, China Dec. 2005 -- May. 2007

SQL Server DBA

Description: Progress Strategy, established in 2000 in Beijing, is a professional management consulting firm under Horizon Research Consultancy Group. Progress Strategy serves five areas of services: management consulting, automobile research and consulting, brand strategy and promotions, public affairs advisory services, and urban development and real estate services.

Responsibilities:

• Created database objects like tables, views, indexes, stored-procedures, triggers, cursors using T- SQL.

• Creation of Jobs, Schedules, Alerts using SQL Server Agent and Notifications using SQL Mail.

• Involved in Setting up Log shipping.

• Extensively involved in database mirroring.

• Extensively Involved in Creating Back up Strategy.

• Created and managed the Database Users, Login and Security.

• Monitoring Event

©2003-2012 Dev Bistro

Contact this candidate