SUMMARY:

• 9+ years of Database Administration and Development experience on MS SQL Server 2014/2012/2008 R 2/2008/2005/2000 in OLTP and OLAP environments with Healthcare, Financial, Insurance, Public Sector and Pharmaceutical Domains.
• Experience with Installation/Troubleshooting, Managing and Configuration of MS SQL Server 2014/2012/2008 R 2/2008/2005/2000/7.0 on Windows Server 2012/20 / NT.
• Experience in installing Service Packs, Hot Fixes and Patches for SQL Server.
• Experience in the AlwaysOn Availability groups and AlwaysOn Fail Over Clustering in SQL server 2012.
• Expertise in Side - by-side and In-Place upgrades SQLSERVER 7.0 2008 R2 2012 versions also experience in SQL Server Database Recovery Advisor.
• Maintained databases with sizes ranging from Large to Very Large Databases (terabytes).
• Experience in creating Databases, Transactions, Tables, Joint, Indexes, Constraints, Stored Procedures, Triggers, Views, Functions and Cursors using SSMS.
• Experience with Database Security: Granting and revoking end user access to resources. Database Maintenance: backup and restore, Recovery and Disaster Recovery procedures, integrity checks, index rebuilds, assigning Roles To Users, usually as jobs, setting them up and periodically reviewing them to make sure they are operating correctly.
• Expert in Monitoring SQL Server Performance, Troubleshooting using SQL Profiler, and Scheduling Jobs using SQL Server Agent. Index Tuning Wizard (or) DTA, Windows Performance Monitor and Maintenance plan. Performance Monitor/Profiler to resolve Dead Locks or long running queries.
• Experience in designing & implementing high availability, clustering, log shipping and/or mirroring standby, large database management, and partitioning.
• Experience with Data Migration from MS SQL server and 20 .
• Experienced in Data Migration between Homogeneous & Heterogeneous Systems using various tools (SQL Server Upgrade Advisor, DTS Package Migration Wizard, Import Export Data, DTS Packages, Bulk Insert, BCP and SSIS).
• Installed and configured Microsoft reporting, and integration services (SSRS, SSIS), ETL experience, Experience in creating SQL Server Reporting services.
• Hands-on experience with SSIS (SQL server Integrated Services), SSRS (SQL server Reporting Services).
• Indexes (Clustered/Non-Clustered) and partitioning of VLDBs (Very Large Data Bases 900GB-1TB) for improving the Data base performance.
• Troubleshooting system wide problems including Network, database & third party software.
• Excellent interpersonal and Communication skills, detail oriented, aggressively penetrating into the root cause, organized and highly motivated.
• 24/7 Database operation support for SQL server 2012/08/05 databases in clustered and stand-alone server environment.

TECHNICAL SKILLS:

Databases: MS-SQL Server 2000/20 /2014, Oracle 9i/10g, MS Access 2003, DB2 (Version 8).

Languages: C, C+, T-SQL, VB Script, Java Script, HTML, XML, Microsoft PowerShell.

SQL Server Tools: Management Studio, Enterprise Manager, Index Tuning Wizard, Database Tuning Wizard, Profiler, Query Analyzer, Export & Import, Precise i3 for SQL Server, Upgrade Advisor

Operating system: Windows 2012/2008/2003, Vista/7/8/ Professional/ NT 4.0 Advanced Server, Unix, Linux.

OLAP Tools: SQL Server Analysis Server 2008, 2005, SSIS (as ETL).

Load Test Tools.: WAPT 7.5, WAPT Pro 3.1

Services: Database Engine, SSIS, SSRS(Visual Studio 2013/2010/2008/2005 )

PROFESSIONAL EXPERIENCE:

Confidential, NJ

SQL Server DBA

Environment: SQL Server 2008R2, 2012, 2014Enterprise Edition, SSIS, SSRS, SAN storage systems.

Responsibilities:

• Installations and configurations of SQL server 2012, 2014, applying service packs and Upgrading SQL Servers 2008 R2 to SQL Server 2014 and SQL Servers 2012 to SQL Server 2014.
• Migrated Database from SQL server 2008 to SQL Server 2012and SQL Servers 2012 to SQL Server 2014 in Microsoft Windows Server 2012 Enterprise Edition.
• Migrated SSIS packages from SQL Server 2008 R2 to SQL Server 2012/2014.
• Used Data Transformation Services (DTS)/SQL Server Integration Services (SSIS) an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application Update statisticswith full scan on a weekly basis to make sure that the query optimizer uses the most recent statistics.
• Managed security on Production and Development environments.
• Created and maintained various databases on Production and development environments using SQL Server 2008r2/2012.
• Installed and configured SQL Server Reporting Services.
• Responsible for Database Backup and recovery. Monitoring the database backup, drive space, log space and Critical errors for all production servers.
• Created and maintained various logins and managed security based on the required access.
• Implemented and tested the point in time recovery of the production databases.
• Responsible for Performance and troubleshooting problem solving of issues related to the SQL Server and Oracle databases.
• Database Security User Management, Privileges, Roles, Auditing, Profiling, Authentication
• 24x7 and on - call support duties.

Confidential

Sr. SQL Server DBA

Environment: MS SQL Server 2008/2008 R2, MS SQL Server 2005, Windows Server 2008, Microsoft Cluster Service (MSCS), SQL LiteSpeed.

Responsibilities:

• Tested and implemented stored procedures, tables & views in SQL Server 2005/2008 from Test Environment to Production Environment.
• Implemented Database Standards and Naming Convention for the Database Objects.
• Implemented Transactional Replication for Customer Application between Primary Server and three Read only Servers with separate Distributor Server and experience in troubleshooting replication problems.
• Developed and Implemented Backup and Recovery Strategies involving complete Database Backup/Restore&Transaction Log Backup/Restore.
• Supported troubleshooting as required, Optimized Performance and Resolved Production Problems.
• Configured Transactional Replication and Log Shipping with SQL Server Management.
• Checked and Updated Database Statistics and Re - Indexing.
• Used BCP Utility to publish table output to text files.
• Automated and enhanced daily administrative tasks including space management, object alteration, backup & recovery and performance monitoring.
• Involved in Data Security by Maintaining and giving granular permissions to Users / Login with appropriate roles, dropping and locking logins, monitoring user accounts, creation of groups enforcing the Password Policies and by creating proxy accounts.
• Monitor Daily SQL jobs, Event logs, Error Logs and Performance of the Database.
• Investigated and resolved SQL process issues using various SQL commands.
• Generated Reports using SQL Server Reporting Services (SSRS).

Confidential, Newark, NJ

Sr. SQL DBA

Environment: SQL Server 2005/2008/2008 R2, Windows server 2003/2008, MS Access 2008, Log Shipping, Clustering, Mirroring, SSRS, Web Services, T-SQL, SSIS, MS-Excel, Database Backups.

Responsibilities:

• Configured and troubleshooting replication, log shipping, mirroring, clustering and database maintenance jobs.
• Handling backup process, writing the automated jobs for taking thefull backup, differentialbackup and transactional backups.
• Created and maintained the knowledge base system for all the application databases
• Granted permissions to end users according to their level of access to database objects.
• Performed Query tuning and used fragmentation strategies to avoid contention.
• Created/altered databases, table extents, indexes, constraints as necessary.
• Mentored developers and supervised their work for accuracy and improvement.
• Interacted with database and application issues of users daily.
• Isolated large tables into their own table space for quick restore purposes.
• Monitored disk space utilization and added or freed extents accordingly.
• Regular SQL Server Maintenance Activities.
• Index rebuild and update statistics, Database Backup, Data Imports and Exports.
• SSIS Jobs, Reporting Jobs through SQLCMD, Archiving and GatherDatabase counters.
• Status report of all the jobs, Database consistency checks, Data Refresh, Data Masking.
• On call support.
• Index Defragmentation by Rebuild/Reorganize of Indexes on a monthly basis across all Databases.
• Configured and worked on different DR strategies with Log shipping, Replication and Clustering.
• Setup Transactional and Merge Replication between Servers, and troubleshoot and monitor Publishers, Distributors, and Subscribers.
• Involved in designing and configuring a replication server where production database was replicated into two different databases: Read - only reporting database and disaster recovery database.
• Worked on different tools like Foglight, Lightspeed and Remedy.

Confidential, San Francisco, CA

SQL DBA

Environment: MS SQL Server 2000/2005/2008, Windows Enterprises 2003 servers, IIS Web server, Toad for SQL Server, LiteSpeed, Red Gate, JavaScript, CSS,HTML, SSIS, SSRS,VERITAS NetBackup,SYBASE,C#,VB.Net, ASP.Net.

Responsibilities:

• Installing, configuring and deploying SQL Server 2005 and 2008 in Clustered and non - clustered environment.
• Created a role in Share point site for security purpose. Created various roles according to the user.
• Worked as a Data Analyst.
• Responsible for defining the complete data warehouse architecture.
• Direct and design the ETL process involving data quality and testing.
• Migrated from SQL Server 2000/2005 to SQL Server 2008.
• Hands on experience with Redgate SQL Backup.
• Configured security and access per SOX and PCI standards.
• Created Linked Servers for OLEDB Data Source and Native Sources.
• Responsible for creating, maintaining and monitoring mirrored servers, configured using synchronous and asynchronous updates with witness server.
• Created alerts, notifications and emails for system errors, insufficient resources, fatal database errors, hardware errors, alerts, activity logs, error logs to capture any possible errors.
• Used 3rd party tools like Quest Lite Speed in taking the backups to optimize performance and restoring.
• Extensively worked on Dynamic Management Views (DMV s) and Dynamic Management Functions (DMF s).
• Analyzed business requirements and build logical and Physical data models that describe all the data and relationships between the data.
• Monitor backup jobs daily and run the jobs manually in case of failure depending upon the necessity. Monitor database status including CPU, Memory, I/O, Space and dead lock using SQL Server Utilities.
• Running DBCC consistency checks, and fixing data corruption in user databases.
• Used SQL Profiler, Windows Performance Monitor and DB Artisan for troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Implemented and Monitor the replication between two sites, support and maintenance of MS SQL Server Transactional Replication.
• Worked on fail over clustering and mirroring.
• Documentation of daily tasks and scripting them.
• Worked in 24X7 production support with a rotation basis.
• Involved in loading the Warehouse databases and performing maintenance tasks on these databases.
• Setup log shipping and troubleshooting log shipping errors when arises.
• Experience in implementing Failover Support for SQL Server with active/Active Cluster configuration.
• Built SSIS Packages to transfer data in and out of the Extract, Stage and Production Servers.
• Updated the multi-dimensional cube data using SSIS- Import/Export wizard.
• Created, Built and deployed SSIS Packages by using BIDS, and Migrated DTS Packages to SSIS 2005/2008 packages
• Used BCP command line utility to replicate a database.
• Used SQL Profiler to find badly performing queries and deadlocks.
• Created Dash board reports using COGNOS report studio.
• Developed SSIS packages to export data from OLTP database to OLAP database.
• Using Views, Triggers, and Stored Procedures for updating and cleaning the existing data and also the new data.
• Configured and worked on SSRS.
• Extensive experience in Deploying and maintaining SSIS Packages and SSRS Reports
• Created Indexes to speed up the queries and Performed Database Normalization.

Confidential, Crawfordsville, IN

SQL DBA/ Developer

Environment: MS SQL Server 2000/2005,T-SQL, Windows 2000 Advance Server, MS Excel, MS Access, SSIS and SSRS

Responsibilities:

• Installation and configuration of MS SQL Server 2000/2005and applied service packs.
• Administration of SQL Servers in Production and Development environment
• Responsible for Database maintenances and security. Creation and maintenance of Users security permissions and Migration the entire database objects from one Server to another Server and database to another database. Creating and managing user accounts / logins for development purpose.
• Developed Backup and Recovery Strategies, and Disaster Recovery Plan.
• Successfully implemented indexes on tables for optimum performance.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non - Clustered Indexes for significant performance boost using index tuning wizard.
• High availability such as Clustering, Database Mirroring, Log Shipping, and Replication.
• Created new database objects like Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment.
• Created SSIS packages to import data from MS Access, Excel to SQL 2005.
• Created report models and deployed on report server using SSRS
• Successfully managed Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using BCP in staging database from MS Access, excel.

Confidential

Jr. Database Administrator

Environment: SQL server 2005,SQL Server 2000 Enterprise Edition, MS Reporting Service 2000, Windows 2000/2003 Server, IIS 5.0, VERITAS NetBackup,VB.Net.

Responsibilities:

• Participated in the requirements elicitation and technical specification processes.
• Upgraded the server from SQL 2000 TO SQL 2005.
• Migrated SQL Server 2000 DTS Packages to SQL Server 2005 SSIS packages.
• Worked extensively on installation, upgrade and configuration of MS SQL Server 2008/2005 and 32/64 bit SQL Server Cluster for SQL 2008 and SQL 2005.
• Created SSIS Packages to Extract, Transform and Load (ETL) consolidated data from different sources into Data Warehouse.
• Performed Backup/Restore by using VERITAS Net Backup.
• Created and scheduled back up using Maintenance Plan wizard.
• Extensively used Database Tuning Advisor to improve the performance of Query.
• Used SQL Profiler to monitor the server performance, debug T - SQL and slow running queries.
• Monitored the application and database performance using SQL Profiler and Performance Monitor.
• Used Index tuning wizard to get a better idea of implementing indexes on the existing databases
• Analyzed database growths for Capacity Planning, Normalized the data for efficient performance and also Partitioned data into multiple Files and File groups.
• Performed database consistency check as regular Interval.
• Implemented Replication and Log Shipping to overcome Disaster Recovery plan.
• Implemented and maintained SQL Server Agent Jobs, Monitor SQL Server Agent Job history.
• Worked on DB2 environment.