SUMMARY

• Over 5+ years of experience in SQL Database Administration and Developer for very large and complex databases in SQL Server 2014,2012, 2008 R2, 2008 and 2005.
• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Experienced in installing/configuring/administering/supporting SharePoint 2013/2010, SQL Server 2008 R2, in Windows Server 2008 R2 / 2012 & using Central Admin and PowerShell.
• Administering SQL Server High Availability and Disaster Recovery strategies.
• Implemented the new SQL Server 2012 mechanisms like data compressions, online indexing, Contained Databases, security principals.
• Strong experience in MS SQL Server with Business Intelligence in SSIS/SSAS/SSRS, OLTP and OLAP.
• Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability.
• Experience in Disaster Recovery Planning and Security Management operations.
• Expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
• Having hands on experience in DR processes including Log shipping, Always on Availability and Database Mirroring.
• Troubleshoot performance problems, fine - tuning of databases and index Analysis.
• Worked on SQL Server 2012 migration from SQL Server 2008.
• Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
• Experience in SSRS design and deployment of Parameterized, Drilldown, Sub, Linked, Snapshot, Cached, and Ad hoc Reports.
• Transformation of OLTP data to the Data Warehouse using SSIS and T-SQL.
• Extensive experience in developing Stored Procedures, Functions, Triggers, Views, Indexes, Packages and complex queries on SQL Server.
• Experience in using variables, expressions, functions for the reports and in handling Parameterized reports in SSRS.
• Experience in Installing SSIS/SSRS, Create and Migrate SSIS and SSRS Packages.
• UsedPowerShell and T-SQL combining data from multiple sources

TECHNICAL SKILLS

Database Upgraded: SQL Server 2005 to SQL Server 2008. SQL Server 2008, and 2008R2 to 2012.

Database Migration: Migrated MS Access 2003/2000/97 databases into MS SQL Server. Migrated Oracle 10g, MySQL into MS SQL Server 2008R2.

Data Modelling: Worked on more than 10 data modelling projects and generated E-R Diagram. Data Modelling tools using SQL Server Data Diagram.

Database Monitoring/Performance Tuning: Strong on database Monitoring and Performance tuning. Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, and backup verification. Monitor SQL Server Error Log, space usage.

Database Programming: Wrote T-SQL, Trigger, and Stored-Procedures. Assisted Database Developers to optimize SQL queries and Stored Procedures.

ETL Tools: Used ETL tools like DTS, SSIS, Import/Export, BCP (Bulk Copy), to import & export data from flat files, and excel to MS SQL Server databases.

PROFESSIONAL EXPERIENCE

Confidential, NJ

SQL Server DBA

Responsibilities:

• Migrated SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition.
• Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2012.
• Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Updating database systems by reviewing, planning, testing and installing database security patches and service packs.
• Developed, executed and maintained SQL queries/scripts and similar artifacts to validate completeness, integrity and accuracy of data.
• Used log shipping for synchronization of databases.
• Prepared Documentation for the Disaster Recovery plan.
• Created Efficient Triggers, Cursors, Tables, and Views and other SQL Joins and statements for application.
• Analyzed Reports and Fixed Bugs in stored procedures.
• Automated the SSIS jobs in SQL scheduler as SQL server agent job for daily, weekly and monthly loads.
• Involved in Query Optimizations and Performance Tuning for the Stored Procedures.
• Proven ability in generating Drill down and Drill through reports with Drop down menu option, sorting the data, defining subtotals in SSRS 2005.
• Used Index usage statistics to determine how useful an index is and if an index is improving or hindering application performance.
• Wrote T-SQL, Trigger, and Stored-Procedures. Assisted Database Developers to optimize SQL queries and Stored Procedures.

Confidential

MS SQL Server DBA

Responsibilities:

• Database High Availability: Installed, Configured and Maintained Fail-Over Clustering using SQL Server 2008/2005.
• Installed, Configured and Maintained Database Mirroring using automatic fail-over option in SQL Server 2008.
• Configured Log Shipping as Standby database from Production database for Reporting purposes. Configured and Maintained Replications.

Confidential

SQL Server DBA

Responsibilities:

• Installed, configured and Maintained SQL server 2012 and 2008r2 in Clustered and Geo Clustered Setup.
• Provide High Availability and Disaster recovery schemes for MS SQL Server stack and Maintain Tape Backups for the Disaster recovery.
• Installation, Configuration and upgrading the MS SQL Server 20 .
• Install SSIS/SSRS, Created and Migrated SSIS and SSRS Packages (SQL 2008r2,2012).
• Perform Capacity Planning, Performance Tuning, and Query Optimization and give consultation to development team.
• Implemented Transparent Data Encryption.
• Monitor Performance, Availability, and Data Integrity with multiple tools including Performance Monitor, and Spotlight.
• Perform Database deployments as the new objects created/modified.