SUMMARY:

• Over Ten years of technical experience as an IT professional, Microsoft Certified Senior MS SQL DBA.
• Play a key role in architecture design, physical and logical Data modeling, production support and Project review.
• Experience includes administering large and complex Databases, Database Design, Replication, Log Shipping, Database mirroring, Full - text indexing, MS SQL Server Installation, SQL Clustering, Backup/recovery, and Security.
• Experience in creating Disaster recovery documents and Disaster Recovery Planning.
• Experience in Performance Tuning, Application Design, Query Optimization, Security Management, Managing server and clients, T-SQL, Stored Procedures, Functions, Cursors and Triggers etc.
• Experience in logical and physical data modeling using ER Model and Erwin.
• Exposure in C#, ASP.net, VB.net, ASP, ADO, C++, JAVA, HTML, JavaScript, VBScript Assembly Language.
• Experience creating report using Crystal reporting and SSRS (SQL Server Reporting) tool.
• Extensive experience in creating business, functional and technical documentation.
• Experience in Financial and Health Care industries.
• Excellent verbal, written, communication and presentation skills, problem solving, conflict resolution skills, and detail oriented.

TECHNICAL SKILLS:

DBMS: MS SQL Server 2014, 2012, 2008 2005, 2000, 7.0, Oracle 10g, 11g, and MS Access.

Hardware: IBM Compatible computers and Apple Mac

Languages: C#, ASP.net, Java, JSP, HTML, JavaScript, VBScript, FlashC++, ASP

Operating Systems: Windows 2012, 2008, 2003, 2000, NT, XP, UNIX and Sun Microsystems

Application: MS Office, MS Project, Visual SourceSafe, and Visio, Visual Studio, Front Page.

Tools: NT Performance monitor/System monitor, SQL Engine Tuning Advisory, Crystal Reporting, MS SQL ReportingSSIS, SQL Profiler, SQL Query Analyzer, ISQL, OSQLNetIQ, Erwin, NetIQ, Cluster Administrator, Remedy.

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Sr. SQL Server DBA

Responsibilities:

• Maintain and responsible for all SQL servers of the company.
• Create and modify the Logical and Physical Database design using ER Model for new and existing applications.
• Work on all phases of project (SDLC).
• Configure, install and maintain clustered servers, Log Shipping, Database Mirroring and Replication.
• Involve in trouble shooting and fine-tuning of databases for their performance and concurrency, Capacity Planning, User Management, Security features and Index Management.
• Involve in Data Extraction using SSIS and create very complex SSIS packages to import data from XML files.
• Experience with SQL Server Performance Monitoring, Query tuning and Database optimization.
• Create the standards for backup strategy for production, test and development servers.
• Design and implement Security policy for SQL Servers.
• Involve in Disaster Recovery processes and create the documentations.
• Involve in Capacity planning for new and existing applications.
• Ensure maximum system availability during business hours.
• Provide day to day Administration assistance such as Server Configuration, Space Management, Log Management, creating users and assigning permissions to users, and maintenance tasks.
• Providing on call support 24 X 7.
• Involve in upgrade from 2005 to 2008, 2008 to 2012 and 2014 applying patches and hot fix.
• Document server and database policies and procedures.
• Collaborate and work with developers on both logical and physical data model, Query optimization, review developer change, and install the changes to production servers.

Confidential, New York, NY

SQL Server DBA

Responsibilities:

• Experienced with Performance tuning, SQL profile, PerfMon, Database optimization and Query tuning.
• Responsible to Review and approve design changes.
• Responsible to Review and approve database objects written or modified by developers.
• Created the Logical and Physical Database design using Erwin.
• Configured, installed and maintained Log shipping, Database mirroring and replication.
• Upgraded from SQL server 2005 to 2008, applied patches and hot fixes.
• Designed SSIS packages to transfer data from various heterogeneous sources to a central repository.
• Used complex transformations in SSIS to compare the in-flow values with the analyzed values to create reports on regular time intervals.
• Deployed the SSIS packages on the server and scheduled the jobs using SQL Server Agent.
• Set up and maintained the transactional servers.
• Set up database Standard, policies and procedures.
• Created backup and restore strategy to production, development and test environments.
• Involved in Disaster Recovery processes and created the documentations.
• Involved in Capacity Planning for new and existing applications.
• Involved in index management for better performance.
• Ensured maximum system availability during business hours.

Confidential, Secaucus, NJ

SQL Server DBA

Responsibilities:

• Provided 24*7 production supports for all the SQL Server.
• Responsible to Review and approve design changes.
• Responsible to Review and approve database objects written or modified by developers.
• Experienced with Performance tuning, SQL profile, PerfMon, Database optimization and Query tuning.
• Created the Logical and Physical Database design using ER Model software.
• Configured, installed and maintained Log shipping, Database mirroring and replication.
• Upgraded from SQL server 2000 to 2005 and 2005 to 2008.
• Designed SSIS packages to transfer data from various heterogeneous sources to a central repository.
• Used complex transformations in SSIS to compare the in-flow values with the analyzed values to create reports on regular time intervals.
• Deployed the SSIS packages on the server and scheduled the jobs using SQL Server Agent Services.
• Set up database Standard, policies and procedures.
• Created backup and restore strategy to production, development and test environments.
• Involved in Disaster Recovery processes and created the documentations.
• Involved in Capacity Planning for new and existing applications.
• Involved in index management for better performance.
• Ensured maximum system availability during business hours.

Confidential, New York, NY

SQL Server DBA

Responsibilities:

• Created the Logical and Physical Database design for new web based applications.
• Configured, installed and maintained clustered servers and replication servers.
• Created Logical data modeling for production database using Erwin Tool.
• Involved in Data Extraction and Loading using DTS and SSIS Import and Export Utility.
• Involved in upgrade from SQL 2000 to 2005, and 2005 to 2008 applying patches and hot fix.
• Setup and maintain the transactional servers.
• Setup and maintain Database Mirroring, Log Shipping for SQL Server 2008 servers.
• Documented server and database policies and procedures.
• Created backup and restore strategy to production, development and test environments.
• Involved in Disaster Recovery processes and created the documentations.
• Documented server database policies and procedures.
• Experienced with SQL Sever Performance Monitoring, Server and Database optimization and Query tuning.
• Collaborated and work with developers on both logical and physical data model, Query optimization.
• Created the backup and restore strategy to production, development and test environments.
• Involved in Disaster Recovery processes and created the documentations.
• Experienced with SQL Sever Performance tuning, Monitoring Server and Database optimization and Query tuning.
• Involved in Capacity Planning, user management and Security features and index management.
• Ensured maximum system availability during business hours.

Confidential, NY

SQL Server DBA

Responsibilities:

• Provided 24*7 critical production supports for 20 mission critical applications. Maintained 110 Servers out of which 70 servers are production servers including USA and around the globe.
• Provided Day to day Administration tasks like Server Configuration, Space Management and Log Management.
• Installed, configured and maintained Active/Passive SQL Cluster environment.
• Created the standards for backup strategy for production, QA servers.
• Involved in data refresh between the production and test environments.
• Experienced with cleaning up the database design for development projects.
• Involved in improving the databases performance tuning using profilers, execution plans and index tuning wizards.
• Evaluated future projects and advise management of project impact on the current environment.
• Created the Physical Database design for production Database. Involved in Capacity planning for large databases.
• Involved in upgrade from SQL 7.0 to 2000 and 2000 to 2005.
• Applied patches and hot fixes.
• Documented server and database policies and procedures.
• Implemented routine database and log backups, restores as needed.
• Involved in Disaster Recovery processes and created the documentations.
• Experienced with SQL Sever Performance Monitoring, Server and Database optimization and Query tuning.
• Monitored the growth of the database objects for capacity planning.
• Performance Tuning.
• Created DTS packages for import/export data operations from Oracle databases.
• Configured SQL Server log shipping for create a stand by server.
• Provided Day to day Administration tasks like Server Configuration, Space Management and Log Management, create users, and assign permissions to users, and maintenance tasks.
• Provided on call support 24 X 7.