SUMMARY

• Around seven years in SQL Server Database Administration, Design, System analysis, Development, Testing and Support of MS SQL server with hands - on experience in 2012/2008R 2/2008/2005.
• Expert in installation, upgrade, configuration and administration of MS SQL Server 2012, 2008, 2005 & 2000 in clustered and stand-alone environments with relevant experience on MS SQL Server 2014 as well.
• Design and document Logical and Physical data models.
• Expertise in Databases Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Extensive experience in testing, maintaining and implementation of Disaster Recovery sites (DR) and High availability (HA) solutions for production databases.
• Experience in Normalization, Database design and capacity planning.
• Experience in Query Optimization, analyzing the execution plan and index management for better Query performance.
• Proactively maintaining activities like monitoring of database space allocations, transaction log space allocations, monitoring memory, CPU utilization, disk utilization, locks, and run-time of queries.
• Experience in planning and implementation of Backups and restoration strategies.
• Strong experience in ETL Application using SSIS with various source like flat files, excel, Oracle.
• Expertise in implementing Database Mirroring and failover cluster on SQL Server 2005, 2008 and 2012 for high availability.
• Successfully tested and implemented Log Shipping Technique used for warm standby solution for MS SQL Server 2012/2008/2005/2000 databases.
• Experience in implementing Snapshot and Transactional replication models.
• SQL Server Business Intelligence Development Studio expertise to create SSRS (SQL Server Reporting Services) reports, SSIS (SQL Server Integration Services) packages and SSAS (SQL Server Analysis Services) with OLAP.
• Design, Architect and Tune OLTP or OLAP requirements.
• Proficient in Migration of Data to/from various heterogeneous sources from/to MS SQL server by using SSIS/DTS utility or by Linked Server.
• Experience in developing Custom report and different types of Tabular, Matrix, Ad hoc and distributed reports in multiple formats using SQL Server 2005, 2008, 2008 R2 Reporting Services (SSRS).
• Having an extensive experience in documentation in ITIL specifications.
• Good interpersonal skills,self starter, result oriented, hard working with a quest and zeal to learn new technologies and undertake challenging tasks.

TECHNICAL SKILLS

Databases: MS SQL Server 2012/2008 R2/2008/2005, ORACLE, MS Access, MySQL

Database Tools: SQL Server Integration Services (SSIS), Data Transformation Services (DTS), Analysis Services, Business Intelligence & Development Studio and Erwin

Development skills: T-SQL, PL/SQL, SSIS/SSRS/SSAS, Oracle 8i/9i/10g/ 11g/12c

Languages: T-SQL, HTML, XML

ETL Tools: DTS, SSIS (SQL Server Integration Services)

Reporting Packages: SQL Server Reporting Services (SSRS), Business Objects 6.5/XI, Crystal reports 9/10/11/12, MS Excel

Operating Systems: Windows XP Servers, Windows 7, Windows 8.1, UNIX.

Tools: / Methodologies: MS Visio, Erwin, MS Project, SQL Profiler, SQL*Loader, TOAD for SQL Server and Oracle

PROFESSIONAL EXPERIENCE

Confidential, Jersey City, NJ

SQL DBA Consultant

Responsibilities:

• Involved in Installation and configuration of SQL server 2012 on Servers.
• Maintaining User account administration for Different domains.
• Upgrading existing Servers from SQL server 2008R2 to SQL server 2012.
• Migrated Databases from SQL Server 2008-R2 to SQL Server 2012 in Production and test Environments.
• Applied patches and service packs to keep the database at current patch level.
• Documented the results from Upgrade Advisor and resolved all before and after issues migrating from SQL Server 2008R2 to SQL Server 2012.
• Setup and troubleshoot for Active/Passive Clustering in SQL Server 2012.
• Monitor failed and long running MS SQL Server jobs.
• Created Scheduled maintenance and backup procedures to the database as a DR method.
• Involved in Configuration, Administration, and Implementation with Log Shipping mechanism.
• Configured Disaster Recovery solution with Transaction and Merge Replication from Production to Development Server for multiple subscribers with Non-Updatable subscriptions.
• Scheduled Backup/Recovery jobs, creation of Login, Users, and Permissions.
• Implemented database standards and naming convention for the database objects.
• Implement and maintain database security.
• Implemented trigger and stored procedures and enforced business rules via checks and constraints.
• Fine-tuned Stored Procedures using Execution Plan in T-SQL for better performance.
• Going through the client's requirements and coming up with database design and application architecture.
• Designed new job process, new database maintenance plans, DTS programs and did Performance tuning of the existing processes.
• Data conversions and data loads from various databases and file structures.
• Generated reports using Crystal reports.
• Monitor, tune, and analyse database performance and allocate server resources to achieve optimum database performance.

Confidential, Jersey City, NJ

SQL DBA Consultant

Responsibilities:

• Worked with SQL Server 2008R2 side by side upgrade from SQL server 2005.
• Installed SQL Server 2012 on Windows 2008/2012 Servers on Active/Passive as well as Active Clustered environment and applied Patches, Hotfixes and Service Packs.
• Setup and maintained Database Mirroring with automatic failure and Transactional Replication.
• Extensively worked on Installation and Maintenance of SQL Server 2008R2/2005 on Test, Development and Production Environments.
• Database Backup and restores, and periodical database refreshes
• Worked Extensively on Remedy application Database server tuning.
• Worked on Operational side for Disk Space, Log Space, Blocking and Deadlock issues.
• Installed Various Service packs for SQL Server 2008R2 and 2008.
• Managed Security usingSQL Logins, Roles and Security Modesfor various users.
• CreatedDatabase Maintenance Plansfor the performance of SQL Server which coversDatabase Integrity checks, update database Statistics and Re-indexing.
• Checking Database Health by using DBCC Commands and DMVS.
• Added SQL Clustered Node to Existing Cluster for SQL Server 2008R2
• Correlated Profiler trace events with System Monitor performance counters to identify what event(s) are hogging server resources
• Worked On SQL Server 2005/2008(R2) Clustered Environments.
• Handled numerous Change Management Requests on production servers.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
• Developed several Complex Reports (daily, weekly, monthly, quarterly and yearly) using SSRS (SQL Server Reporting Services).
• Extensively used Red Gate SQL Compare and Data Compare tools to compare and synchronize SQL Database Schemas.
• Have good understanding in IIS Administration and configuration.
• Used Perfmon, DMV’s, SQL Profiler to capture the activities of the databases and used the trace file as workload file to the Database Tuning Advisor for index recommendations.
• Moved Tempdb files from One Drive to another Drive.

Confidential, Memphis, TN

SQL DBA Consultant

Responsibilities:

• Worked on Business and Financial analysis to document the business requirement documents and Functional requirement documents and acquired sign-off for the same in compliance to ITIL standards.
• Prepared maintained and modified SQL server installation and configuration documents.
• Installation ofSQL Server 2008 onWindows Server Clustered environment.
• Managed and Administrated theSQL Server 2008/2005 production and Non-production servers.
• Data Migration from Legacy system to SQL Server 2008 using SSIS packages
• Upgraded/Migrated SQL Server 2005 databasestoSQL Server 2008 databasesand mentored other technical staff.
• Performedbackup using backup compression and Data compression in SQL Server 2008 on clustered environment.
• ResolvedApplication connectivity issues like connection timeouts, connection pooling issues and memory leaks.
• Monitoredtransactional replication on Production, UAT, QA and Dev servers.
• Used SQL Server 2008 Activity Monitor When troubleshooting a performance issue or monitoring a server in real time..
• Implemented new features inSQL 2008likePolicy based Management, Table Compression & backup compression, SQL Server Auditing, Resource Governor, Power shell and MERGE statement inT-SQL.
• Involvedin index creation, index removal, index modification, file group modifications, and addingscheduled jobstore-indexandupdate statisticsin databases.
• Performed daily tasks includingbackupandrestoreby usingSQL Server 2008tools likeSQL Server Management Studio, SQL Server Profiler, and SQL Server Agent
• CreatedDatabase Maintenance Plansfor the performance of SQL Server which coversDatabase Integrity checks, update database Statistics and Re-indexing.
• Performed transparent data encryption (TDE) and decryption of the data and log files.
• Managed Security usingSQL Logins, Roles and Security Modesfor various users.
• Analyze execution plans and generate suggestions for improvement.
• Optimized the query performance with modification inT-SQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins,creating usefulclustered indexandnon-clustered indexes.

Confidential, East Hanover, NJ

SQL DBA Consultant

Responsibilities:

• Planned, Configured, Installed and Maintained for SQL Server in Clustered(Multi-Node) and Non-Clustered environments
• Configured and Monitored Database Mirroring for one of the Business Development scenario
• Involved in Configuration, Administration, Implementation using Log Shipping and Replication
• Involved in development of SSIS packages for ETL applications
• Involved in Installation, Configuration and Deployment of Reports using SSRS with Scale-Out topology
• Involved in Designing for Logical Databases for SQL Server2005 and SQL Server2008
• Involved in Upgrading of Servers from SQL Server 2000, SQL Server 2005 to SQL Server 2008
• Involved in Migration of Databases from SQL Server 2000 to SQL Server 2005 and SQL Server 2008
• Migrated DTS packages to SSIS packages
• Scheduled Backups and Restore operations and monitored the Jobs and Maintenance plan
• Developed Stored Procedures, Functions, Triggers for automation of tasks
• Created and executed Store Procedure using Run as permissions.
• Created automated T-SQL scripts to process summary database transactions that run off-hours
• Used Rebuild Indexes to reduce fragmentation and enhance the performance
• Involved in maintenance and configuration of Database Servers to connect with SAN Storage Environment
• Controlled and coordinated the installations(Security Patches, Service Packs)
• Regular Database Maintenance process, Checking the disk, Defrag procedures in Development environments
• Used SQL Profiler for Performance Monitoring to resolve Dead Locks and Long running queries by checking appropriate changes
• Performed Database Refresh tasks from production to Development servers
• Involved in resolving performance issues of Indexes
• Used Fog Light for monitoring Databases
• Designed Users and Logins as per SOX Standards
• Work involvement in performance monitoring of Memory, Processor, Disk I/O and fine tuning.
• Involved in writing Stored Procedures and Functions to handle database automation tasks.
• Created and scheduled backup using Maintenance Plan wizard.
• Extensively used Database Tuning Advisor to improve the performance of Query.

Confidential

Jr. SQL DBA

Responsibilities:

• Extensively worked on Installation and Maintenance of SQL Server R2/2005 on Test, Development and Production Environments.
• Worked with SQL Server side by side upgrade from SQL server 2000.
• Database Backup and restores, and periodical database refreshes
• Worked Extensively on Remedy application Database server tuning.
• Worked on Operational side for Disk Space, Log Space, Blocking and Deadlock issues.
• Performed Server & Application fine-tuning & troubleshooting.
• Monitored MS SQL Server performance and network issues.
• Fixed high Memory utilization issues.
• Installed Various Service packs for SQL Server 2005.
• Having expertise Knowledge on SQL Server High availability concepts.
• Worked on SQL Server 2000/2005(R2) Clustered Environments.
• Managed Security usingSQL Logins, Roles and Security Modesfor various users.
• CreatedDatabase Maintenance Plansfor the performance of SQL Server which coversDatabase Integrity checks, update database Statistics and Re-indexing.
• Correlated Profiler trace events with System Monitor performance counters to identify what event(s) are hogging server resources
• Handled numerous Change Management Requests on production servers.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
• Extensively used Red Gate SQL Compare and Data Compare tools to compare and synchronize SQL Database Schemas.