PROFESSIONAL SUMMARY:

• 5+ years of IT experience, more than Five years in Database Administration, System Analysis, Design, Development, Security and Support of MS SQL Server 2012,2008R2,2008,2005 databases in Production, Testing, Development, Replication & Cluster Server Environments.
• Experience in Database administration activities like Installation, Configuration, Backup & Recovery, Database Security, Data Transformation Services, Database design and Query optimization.
• Good knowledge of Relational Database Management Systems (RDBMS).
• Successfully tested and implemented Log Shipping Technique used for warm backup solution for MS SQL Server 2000, MS SQL Server 2005 databases and MS SQL Server 2008 R2 used as DR solution.
• Experience in Installing, configuring and maintaining SQL Server Active/Active and Active/Passive cluster in Windows 2008 R2 Datacenter, Windows 2008 R2 Enterprise, Windows Server 2008 Datacenter, Windows 2008 Enterprise, Window 2003 Enterprise Server and Windows 2000 Advanced Server.
• Extensive knowledge in Tuning SQL queries & improving the performance of the Database.
• Experience in working with Reporting tools like Crystal Reports, SQL Server Reporting services.
• Creation and maintenance of Databases, creating Roles and managing user permissions.
• Good experience in resolving blocking and Dead lock Issues by using SQL commands.
• Experienced in using Microsoft’s in built tools like SQL Profiler, SQL DTA, and Windows Perfmon for Monitoring, Developing and Tuning MS SQL Server applications.
• Hands on experience in writing and debugging Stored Procedures, Triggers, Complex queries using T - SQL.
• Experience working with Windows 2008 R2 Datacenter, Windows 2008 R2 Enterprise, Windows Server 2008 Datacenter, Windows 2008 Enterprise, Window 2003 Enterprise Server and Windows 2000 Advanced Server Administration and Installation.
• Monitoring Event viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Monitoring Dashboard Reports for Performance Tuning and finding bottlenecks in database.
• Worked with Third Party Backup solutions like SQL Lite Speed for MS SQL Server.
• Experience in upgrading SQL Server software to new versions and applying service packs, hot fixes and Unattended Installations.
• Administration and Installing of MS SQL Server 2012, 2008, 2005
• Setting up Replication, Log Shipping, Data Mirroring using MS SQL Server 2005, 2000.
• DTS (Data transformation services), SSIS (SQL Server Integration Services).
• Experience with writing SQL Scripts and batch files.
• Good hands on experience with T-SQL.

TECHNICAL SKILLS:

RDBMS: MS SQL Server 2012, 2008 R2, 2008, 2005

Web Technologies: HTML, DHTML, ASP.Net, XML, Java Script and VB Script

Languages: C, C++, T-SQL, Java, VB.NET, ASP.NET, XML, PHP, UNIX Shell Scripts, T-SQL

Operating Systems: Windows 2003, Windows 2000 server, Win ME/NT/XP, UNIX.

OLAP Tools: MS OLAP Services Manager

Version Control Tools: Visual Source Safe, Rational Clear Case

Web Server Technologies: IIS 5.1/6.0/7.0, Apache, Tomcat.

Reporting Tools: Crystal Reports 8,9,10, Microsoft Reporting services 2008/2005/2000

Modeling Tool: ERWIN 7.1, Microsoft Visio 2003

PROFESSIONAL EXPERIENCE:

Confidential, Cleveland, OH

MS SQL DBA

Responsibilities:

• Installed and configured SQL server 2012\ 2008 and administered 15+ servers
• Involved in general Database administration, query performance tuning and validated some of the existing schemas.
• Responsible for maintaining all database environments Development, Testing, QA, Staging, and Production.
• Administering SQL Server security and apply security across environments and trouble shoot security issues on daily basis.
• Thoroughly worked on REDGATE to compare databases across the environments and compare the data and synchronize all database objects.
• Experienced working on SQL COMPARE tool to compare the structures between databases in order to sync them
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, database mirroring, replication verification, database integrity verification and indexing updates and apply in development and Testing Environment.
• Experience with Dropping and recreate the tables for the damaged databases to avoid data loss.
• Developed physical data models for database schema and objects.
• Involved in the Backup & Restore and point in time recovery of the databases.
• Responsible for developing, monitoring and deploying SSIS packages.
• Configured SQL mail agent for sending automatic emails when a SSIS packages is failed or succeed.
• Developed DTS and SSIS packages to extract, transform and load (ETL) the data using SQL Server 2008 Integration Services and successfully completed DTS to SSIS conversion
• On call 24/7 support to databases on weekly rotation

Environment: SQL Server 2008 R2/2005/2000, Windows 2003\2008, Windows NT, lit speed, SQL backup5 Red Gate, SQL secure, ETL, SSIS, SSRS, C#., VB,ASP.NET, MS Excel and MS Access, SSAS, System Monitor / Performance Monitor.

Confidential, Newark, NJ

MS SQL DBA

Responsibilities:

• Installed SQL Server 2005 with SP2 in production and development environments.
• Successfully upgraded from SQL Server 2000 to SQL Server 2005 on Development and Testing Environments.
• Involved in system requirements and the upgrade matrix for SQL Server 2005.
• Worked in 2- node Active/Passive Clustered Environment.
• Involved in migrating DTS packages from SQL Server 2000 to SSIS packages in SQL Server 2005 database.
• Successfully implemented Database Mirroring with High Availability Mode in SQL 2005.
• Implemented Log Shipping in SQL 2005 from Primary Server to Standby Server to support DR Solution.
• Worked in 24x7 production environment.
• Integrated SQL Server 2005 reporting services with Microsoft Share Point Portal Server to deliver automatically generated reports to a Share Point portal.
• Involved in Performance tuning, optimization of stored procedures and queries.
• Creating Logins and Roles with appropriate permissions.
• Prepared and documented database Backup & Maintenance Plans.

Environment: MS Windows 2003/2008 Enterprise Server, MS SQL Server 2000/2005, Visual Studio 2005,IIS 6.0, HP ProLiant DL380 G4, Dell PowerEdge Servers, ERWIN, DBArtisan, SharePoint

Confidential, Irving, TX

MS SQL DBA

Responsibilities:

• Installed and configured SQL server 2005 and administered 10 servers with minimal downtime
• Functional breakdown includes 70% DBA and 30% Development.
• Migrated Databases, DTS packages, from SQL Server 2000 to SQL Server 2005.
• Involved in creating Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures.
• Involved in general Database administration, query performance tuning and validated some of the existing schemas
• Responsible for maintaining all database environments Development, Testing, QA, Staging, and Production.
• Administering SQL Server security and apply security across environments and trouble shoot security issues on daily basis.
• Administered the SQL server 2000/2005 by creating user logins, dropping and locking the logins, monitoring the user accounts, creating groups, granting privileges to users and groups.
• User management by assigning appropriate permissions to the database users.
• Experience in upgrading SQL Server and applying service packs and hot fixes and unattended Installations.
• Involved in database administration tasks and assisting developers with problems and SQL optimization.
• Monitored, Scheduled jobs and alerts and did troubleshooting when failed on daily basis.
• Expertise in Setting up database backup and recovery procedures for production, QA and development servers
• Knowledge in Active/Passive Clustering and implementing RAID technology on windows 2003 servers.
• Worked on SQL Server Clusters Active - Passive on mission critical financial applications.
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, database mirroring, replication verification, database integrity verification and indexing updates and apply in development and Testing Environment.
• Experience with Dropping and recreate the tables for the damaged databases to avoid data loss.
• Refresh the database from production to development and staging environment on daily basis.
• Developed physical data models for database schema and objects.
• Involved in the Backup & Restore and point in time recovery of the databases.
• Responsible for developing, monitoring and deploying SSIS packages.

Environment: SQL Server 2005/2000, Windows 2000, Windows NT, lit speed, SQL backup5, SQL secure, ETL, SSIS, SSRS, C#., VB,ASP.NET, MS Excel and MS Access, Oracle, UNIX, SSAS, System Monitor / Performance Monitor.

Confidential

SQL Server Developer/ DBA

Responsibilities:

• Creating maintenance plan for consistency checks, maintaining indexes and statistics and
• Provided 24 X 7 dedicated supports for the claims records database.
• Provided 24 X 7 supports for Production environment.
• Planned and modified the permission issues in the production servers.
• Created the backup and restore strategy for production environment.
• Worked with SQL server Profiler generated traces to optimize the performance of the database.
• Installed and configured active/passive clustered environment.
• Rebuilding indexes on various tables.
• Resolving locking and blocking issues.
• Installed and configured SQL Server bit in a Test Environment and migrated & tested databases
• Documented and tested Merge replication in test environment for generating reports.
• Designed a report on the monitoring of SQL Server Performance.
• This report gives a detail report to the management on the performance of the server on daily basis in email format.
• Provided technical assistance and mentoring to staff for developing conceptual and logical database design and physical database.
• Assisted other teams in stress-testing applications, locating bottlenecks, and recommending possible solutions.
• Responsible for quality control and auditing of databases to ensure accurate and appropriate use of data.
• Worked with management to develop database strategies to support company needs.

Environment: SQL Server 2000/2005 Enterprise Edition, Windows 2000 Advanced Server, Windows 2003 Enterprise Edition, IBM eServer pSeries platform, IBM Storage systems DS8300, DS6800s and DS 4800s.