SUMMARY

• Overall 8+ years of IT experience in Design, Development, Implementation & Administration of Client - Server Applications & Database systems using MSSQL 7.0/2000/2005/2008/2008R2/2012/2014 applications in all SDLC environments
• Extensive experience in installation, configuration of MS SQL Server 7.0/2000/2005 and 2008/2008R2/2012/2014 on Windows NT/2000/2003/2008 servers, applying patches, service packs, hot fixes.
• Experienced in implementing efficient Disaster prevention and Recovery Strategies and High availability like Database Backup and Restore, Database Snapshot, Log shipping, Clustering and Database Mirroring.
• Handled multiple SQL Instances on Cluster environments for Server Consolidation projects built on SAN using RAID levels.
• Solid experience in performance monitoring with Activity monitor, SQL Profiler, client/server connectivity, DMVs and DMFs, SQL Diagnostic Manager.
• Experience in Database administration activities for DB Security (creating logins, users and roles, mapping and assigning permission to them).
• Administering SQL Server using GUI tools which includes SQL Server Enterprise Manager (2000), SQL, Server Query Analyzer and Management Studio.
• Experience in Database Maintenance plans, Database Consistency Checks and Reorganizing andRebuilding indexes using DBCC.
• Experience in implementing and maintaining Data partitioning, Error handling through TRY-CATCH statement, Memory shrinking up on Request.
• Hands on Experience in implementing different types of Replication Models like Snapshot and Transactional and Merge Replication.
• Experience in configuring linked servers and handling distributed queries across multiple datasources.
• Experience in taking Backups, managing Alerts, Operators and Jobs through SQL Server Agent.
• Experience in Upgrading of SQL Server 2000/2005 databases to SQL Server 2005/2008R2/2012.
• Experience in Always on Configuration and Troubleshooting issues.
• Experience in Import & Export of various data formats using DTS (Data Transformation Services), BCP, Bulk Insert and SQL 2005 Integration Services.
• Detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention.
• Experience in administrating the reports to assign permission to the valid users for executing the reports.
• Worked very closely with Customers, End users and powered users collect requirements and training or resolve any business process related issues. Intensive experience in monitoring.
• Experience in TCP/IP, DNS and connectivity issues.
• Responsible in providing Development and Production Support 24x7 and off hours support.
• Excellent analytical, problem solving, interpersonal and communication skills, self-motivated, hardworking, team player ability to handle multiple tasks, and a fast learner

TECHNICAL SKILLS

Relational Databases: SQL server 2014/2012/2008R2/2005/2000/7.0, MS-Access 2000/2003/2007 Oracle 10g, My SQL4/5

Database Tools: SQL Server Enterprise Manager, Query Analyzer, SQL Profiler, SSIS, SSASSSRS, DTS, BCP, ODBC, SQL OLEDB, DBCC, ADO, Business

Intelligence Studio, Crystal Reports.:

Languages: C, C++, JAVA, Android SQL LITE DB, XML, HTML, PHP, T-SQL.

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

Web Servers: IIS 5.0/6.0, Apache, Tomcat.

Architecture: Relational DBMS, Client-Server Architecture, Clustering, Replication, OLAPOLTP

ETL: SSIS, DTS, Informatica, Data Stage.

Other Tools: Erwin 4.0/3.5, Microsoft Visual Studio 2003/2005, Service Center, MS Visual

Source: Safe, Source Control, MS Visio, Windows System Monitor, BMC TOOLOla hallengren.

PROFESSIONAL EXPERIENCE

Confidential - Basking Ridge, NJ

SQL Server DBA

Responsibilities

• Creating login Permissions to Instance/Server level/Database level (user roles, user mapping).
• Security Level Server Instance Login-Audit and Server proxy account managing.
• Changing ownership to different cross databases. Performing the initial checklist for the new database.
• BMC Remedy ticketing tool which access different issues like Critical to low tickets from different environment issues regarding data bases.
• Extensively worked on Dynamic Management Views in SQL Server 2005.
• Installed, authored, and managed reports using SQL Server 2005 Reporting Services.
• Managed the migration of SQL Server 2000 databases to SQL Server 2005.
• Monitoring SQL server performance using SQL Profiler to find performance and dead locks.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, Activity monitor, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Extensively worked on Data Partitioning and Snapshot Isolation in SQL Server 2005.
• Prepared the project management and technical documentation.
• Solving the Bugs Reflected by the Testing team on database.
• Solving Tickets which was raised by Developing team and support team.
• Rebuilding the indexes at regular intervals for better performance.
• Monitored and modified Performance using execution plans and Index tuning.
• Rebuilding the indexes at regular intervals for better performance.
• Extensively worked on DBCC commands and Dynamic Management Objects.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Complete documentation about the database. Recovering the databases from backup in disasters.
• Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.
• To analyze long running slow queries and tune the same to optimize application and system performance.
• To set up SQL Server configuration settings for better server management.
• Worked on SQL Server tools Like Enterprise Manager and SQL Query Analyzer.

Environment: SQL Server 2008/2005, Oracle 10g/ 9i, .Net Framework 2.0/3.5, C#.Net, Asp.Net2.0, VSS, Windows 2000, Windows 2003 Server, MS TFS, MS-Access.

Confidential - Atlanta, GA

SQL Server DBA

Responsibilities:

• Involved in installation, configuration, and upgradation of MS SQL Server 2005/2008 R2 servers.
• Involved in Database upgradation and Migration of SQL2005 to SQL2008 and co-ordinate all Upgrade activities.
• Worked on SQL server clustering to provide an active and passive node, SAN storage with RAID 10 implemented on Dell servers, VIP pool to manage the IP address of SQL servers.
• Configured SQL Mirroring, Log shipping.
• Hands on experience with Microsoft SQL Server Replication.
• Configuring HTTP Access to SQL Server Analysis Services on Microsoft Windows Servers using msmdpump.dll
• Performed data transfers between various servers using BCP and SSIS for developer requests, Environment Migrations, Backing up and Archiving Data for various business requests.
• Created SSRS reports for SQL performance Utilizations stats and schedule it to report every 1 Hour.
• Experience in Tuning and Optimization at Server, Application, Hardware, Database, Query levels
• Extensively used Spotlight /Fog light, DMV’s, DMFs for Enterprise for SQL Server Performance monitoring
• Trouble shoot Developer/User issues like Client/Server Connectivity, Migration issues
• Security Administration by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granted privileges to users and groups.
• Backup and recovery of production databases and Monitor data and log growth, Jobs, Alerts, disk usage and cleanups using 3rd party tool Ola Hallengren.
• Comprehensive knowledge on high availability option log shipping (DR/Standby-server).
• Created various reports like charts, sub reports, graphs and scheduled these reports using windows task scheduler to run on daily, weekly and monthly basis.
• 24/7 Production support for SQL Server databases
• Performed documentation for capacity usage factor data validations and work summary for capacity usage factor calculations.

Environment: Windows 2008/R2/2003/2000, MS SQL Server 2000/2005/2008/R2 SQL Server 7.0., Integration services (SSIS), Reporting Services (SSRS), T-SQL, SCOM 2007, .Net, Ola hallengren.

Confidential

SQL Server DBA

Responsibilities:

• Designs, develops and maintains the development, test and production database architectures, including database management, configuration, optimization, security, replication, maintenance and support.
• Contributes to the successful design, development, implementation, and change management and production support of mission critical database applications.
• Implementation and monitoring of transactional & snapshot Replication
• Plans, installs, configure and upgrades installations related hardware and software.
• Implementation of log shipping and monitoring
• Creating and modified stored procedures for optimization.
• Responsible for taking regular backups.
• Assists the development staff with best practices, including but not limited to, code optimization techniques.
• Monitored and optimized database and server performance using tuning methodology and tools, including enterprise manager, query plans, performance views, and other SQL Server tools.
• Migrated Access and Excel files into SQL Server Databases using Integration services (SSIS).
• Maintains and improves high availability and disaster recovery strategies for the database environments, including backup, restore and where appropriate.
• Involved in the implementation of databases mirroring.
• Administered SQL Server security.
• Involved in building indexes when necessary.
• Involved in performance tuning for the optimization of slow running queries.
• Supported system wide replication tasks including monitoring and alerting. Provided problem resolution.
• Involved in setting up SQL Server Agent jobs for Periodic Backups with Backup Devices, Database Maintenance Plan and Recovery.

Environment: Windows 2000, SQL Server 2005, SQL Server 2000, MS ACCESS, MS-Office.

Confidential

SQL Server Developer/DBA

Responsibilities:

• Actively participated in gathering of Requirement and System Specification.
• Worked on complex T-SQL statements, and implemented various codes and functions.
• Created stored procedures and triggers for Data consistency.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent Data entry into the database.
• Wrote complex stored procedures to process employee’s requirement and generating.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity.
• Debugged the T-SQL queries for performance tuning.

Environment: SQL Server 2000 Enterprise Edition, T-SQL, Query Analyzer, Enterprise Manager, Windows 2000/ NT, MS Access, MS Excel.