SUMMARY:

• SQL Server DBA with 7 years of experience of IT with strong administration and implementation experience using SQL Server 2014/2012/2008 R 2/ 2008/2005/2000 .
• Experience in Database administration activities like Installation, Configuration, Backup & Recovery, Database security, SQL Server Integration services
• Good knowledge Relational Database Management System (RDBMS).
• Experience in providing Production Support for 24x7.
• Experience in upgrading from MSSQL Server 2008 to MS SQL Server 2012.
• Experience with SQL server 2008/2012 DDL/DML Triggers, Database Mirroring and Migration.
• Successfully created, implemented and maintained Log Shipping Technique.
• Experience in implementing different types of Replication models like Snapshot, Peer to Peer and Transactional.
• Experience in Maintenance plan for checking integrity, schedule with full and transaction log backup.
• Experience in creating Jobs and monitoring job steps and troubleshooting failed steps.
• Creation and maintenance of Databases, creating Roles and managing user permissions, resolving deadlocks.
• Experience in investigating and applying necessary SQL Server database patches and installing service packs.
• Created and deployed and scheduled report using SSRS.
• Good knowledge and understanding of AWS and MongoDB.
• Deployed and scheduled SSIS Package. Experience in providing Production Support for 24x7.

TECHNICAL SKILLS:

RDBMS: MS SQL 2016,2014,2012,2008R2, 2008, 2005, MS SQL 2000, and MS Access

Languages: T/SQL, Java

Operating Systems: Windows Server 2000/2003/2008 , Desktop Operating Systems, Window XP &Vista

Tools: SSMS, SQL Server Profiler, SSIS and SSRS, SQL Profiler, SQL Query Analyzer, Enterprise manager, Idera Diagnostic Manager, Idera toolkit, SQL DeFrag Manager, SQL safe, Net backup, MongoDB and Hyper HQ

PROFESSIONAL EXPERIENCE:

Confidential, New York

SQL Server Database Administrator

Responsibilities:

• Installation, Configuration and Maintenance of MS SQL Server 2005, 2008, 2008R2, 2012,2014.
• Involved in resolving blocking and dead lock Issues by using SQL commands Using T - SQL.
• Extensive worked on administration activities like Disaster Recovery, backup and restore.
• Created & managed the Database Users, Login and Security.
• Creation of Jobs, Schedules, Alerts using SQL Server Agent and Notifications using SQL Mail.
• Monitoring Event viewer, SQL Error logs and Log File Viewer for Software and hardware related errors. Troubleshooting high availability scenarios involving Database Mirroring, Log Shipping and Replication
• Created and tested the linked servers
• Deploying database objects from development/testing environment to production environment.
• Monitoring all activities of the server including monitoring the daily SQL jobs, SQL Server error logs and Windows error logs.
• Involved in setting up database mirroring for production server
• Configured replication methods like snapshot, transactional and merge replications.
• Imported data from text files and excel spread sheets into SQL Server 2005/2008 database using SSIS
• Responsible in Monitoring and Troubleshooting SQL Server Performance issues.
• Good knowledge and understanding of AWS.
• Provided 24 x 7 Production support for the database and application issues.

Environment/Tools: SQL Server 2005/2008/2008 R2, T-SQL, Enterprise Manager, Query Analyzer, Windows 2003/2008 Server, SSIS,SSRS,MS Excel and Windows XP, Idera Toolkit

Confidential, Perth Amboy, NJ

SQL Server Database Administrator

Responsibilities:

• Installation, Configuration and Maintenance of MS SQL Server 2005, 2008, 2008R2.
• Involved in setting up Transactional Replication and Snapshot replication
• Involved in Setting up Log shipping.
• Extensively involved in database mirroring.
• Extensive worked on administration activities like Disaster Recovery, backup and restore.
• Created & managed the Database Users, Login and Security.
• Created database objects like tables, views, indexes, stored-procedures, triggers, cursors using SQL.
• Creation of Jobs, Schedules, Alerts using SQL Server Agent and Notifications using SQL Mail.
• Administrator tasks such as managing users, roles, and profiles.
• Involved in resolving blocking and dead lock Issues by using SQL commands Using T-SQL.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Performed System Study and Requirements Analysis, prepared Data Flow Diagrams, Entity Relationship Diagrams, Data Diagrams, Table Structures, with a lot of interaction with the client.
• Created and deployed and scheduled report using SSRS.

Environment/Tools: SQL Server 2005/2008/2008 R2, T-SQL, Enterprise Manager, Query Analyzer, Windows 2003/2008 Server, SSIS,SSRS,MS Excel and Windows XP, Idera Diagnostic Manager

Confidential, Vineland, NJ

SQL Server Database Administrator

Responsibilities:

• Troubleshooting high availability scenarios involving Database Mirroring, Log Shipping and Replication
• Involved in designing and creating Databases, Tables, Views, Stored Procedures and Triggers.
• Interacted with Developers in troubleshooting application and database issues.
• 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/2008R2 on Development, Production.
• Created and deployed SSIS packages and scheduled jobs on daily, weekly and monthly basis.
• Created logins and users with specific roles and permissions as per security rules.
• Created linked servers and tested the linked servers
• Deploying database objects from development/testing environment to production environment.
• Monitoring all activities of the server including monitoring the daily SQL jobs, SQL Server error logs and Windows error logs.
• Involved in setting up database mirroring for production server
• Configured replication methods like snapshot, transactional and merge replications.
• Monitoring and scheduled jobs on production and staging environment.
• Imported data from text files and excel spread sheets into SQL Server 2005/2008 database using SSIS
• Responsible in Monitoring and Troubleshooting SQL Server Performance issues.
• Provided 24 x 7 Production support for the database and application issues.

Confidential, South Plainfield, NJ

SQL Server Database Administrator

Responsibilities:

• Extensively involved in Upgrading SQL 2005(32bit) to SQL server 2008(64bit) in production.
• Experience in Database Design activities including Data Files and File group organization, Data Partitioning and Data Normalization.
• Implemented Database Mirroring in SQL 2005/2008.
• Successfully implemented Log Shipping in SQL Server 2008/2005
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Implemented processes for deploying, upgrading, managing, archiving and extracting data for reporting.
• Migrated DTS packages from SQL Server 2005 to SSIS packages SQL Server 2008 database using migration wizard.
• Involved in installing SQL Server 2005/2008 on Development, Production.
• Monitoring Event viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Good experience in resolving blocking and Dead lock Issues by using SQL command.
• Created & managed the Database Users, Login and Security.
• Managed devices and databases, administered security, scheduled tasks, monitored server and database performance.

Environment: MS SQL server 2008/2005/2000 , Windows 2003 Server, SSIS, MS Visio, SSAS, SSRS