Montreal, Quebec, Canada
•Having 3+ years of experience in Database Administration and Developer for very large and complex databases in SQL Server 2012, SQL Server 2008 R2, 2008 and 2005.
•Experience in Installation, Configuration, Maintenance and Administration of SQL Server 2005/2008/2008R2/2012 on Cluster and Standalone environments
•Worked on SQL Server 2012 Migration and Up gradation from SQL Server 2008 / 2005/2003, using in place migration and side by side migration and Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2012.
•Expertise in SQL SERVER Database Administration on Production, Development and Testing Servers with server configuration, performance tuning, Optimization and maintenance with good troubleshooting capabilities
•Experience in Administering on all types of SQL Server High Availability and Disaster Recovery strategies like REPLICATION, MIRRORING, LOG SHIPPING.
•Extensively worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
•Expertise in establishing and maintaining SQL server Backup, Restore and Recovery policies
•Experience in implementing and maintaining database security (Create and monitor user’s, Server roles, Alerts and assign privileges)
•Experience in troubleshooting and resolving database issues such as integrity, performance, blocking, deadlocking etc.
•Expertise in Performance tuning, Query optimization by Using Performance monitor tools like SQL profiler, Data Tuning Advisor, SQL Query Analyser, Perfmon, Dynamic management views and other related monitoring and troubleshooting tools.
•Expertise in End to End installation and Configuration of SQL Server on Windows Failover Cluster 2008 and 2012S
•Experience on Multi node Active/Active, Active/Passive Clusters
•Worked on data transformation services and Bulk Loads with SSIS and BULK INSERT ETL operations.
•Involved in the writing Complex TSQL and hands on experience in writing Stored Procedures, Triggers, and Functions.
•In Depth knowledge of TSQL with the experience in constructing the triggers, tables, functions, procedures, Indexes, Views etc.
•Experience in Configuring and schedule the Maintenance plans, DBMAIL SQL SERVER Jobs based on database behavior like Full, Differential, and Log Backups, and Updating Statics,
•Regularly Monitors Backup jobs, windows logs, SQL logs Maintenance plan History
•Expertise in generating reports using SQL Server Reporting Services, Report builder, and MS Excel Power View.
•Involved in Huge data migrations, transfers using utilities like Data Transformation Services (DTS), and SSIS
•Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
•Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations
•Expertise in creating the packages included a variety of transformations, for example Slowly Changing Dimensions, CDC, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
•Expertise in Troubleshooting Performance issues
•Provided expertise in Data warehouse, as well as extensive knowledge of OLTP/OLAP technologies.
•Strong technical background along with the ability to perform business analysis and write effective documentation and specifications
•24 X 7 Production Database on Call Support
•Bachelors of technology in Electronics and Communication Engineering, Jawaharlal Nehru Technological University, India
MS SQL Server 2012, 2008, 2008R2,MS SQL Server 2005, ORACLE 10g
T_SQL, PL/SQL, C, VISUAL BASIC 5
Database administration of MS SQL Server 2012,2008, 2008R2,2005
SSIS, SSRS, Report builder
Windows 2010/2008/2003 Advanced Server, NT & Windows 9x, Linux
SQL SERVER TOOLS
SQL Profiler, DTA,SSMS,SSDT,BIDS, Query Analyzer
Backup Utility, SQL Lite Speed
WINDOWS SERVER CONFIGURATION
Failover clustering,Active directory, basic networking concepts
TCP/IP, DNS, WINS, DHCP, FTP, SNMP, SMTP
MSSQLSERVER DBA & ETL DEVELOPER
Tata Consultancy Services, Montreal, Quebec, Canada - January 2015 to April 2016
PROJECT: BestBuy Canada
Description: The project involves Infrastructure Project work to the Best Buy Canada IT environment.
Primary objective of the project is to manage all the databases and also used SQL server integration services (SSIS) and SQL Server Reporting Services (SSRS), to generate the reports according to the business requirements. The Project also includes creating the reports to monitor the customer’s records as per the region and by pulling the historic data from the EDW (Enterprise Data Warehouse), which is on SQL.
•Installation, Configuration and Administration of SQL Server 2012 on both cluster and standalone environments.
•Performed Migration and up gradation of Databases from SQL Server 2003, 2005, 2008 and 2008-R2 to SQL Server 2012 in Production and test Environments.
•Worked extensively in Active / Passive and Active / Active Clustered Environments to increase scalability and stability of business critical systems.
•Worked on high availability and disaster recovery SQL Server solutions, including log shipping, Snapshot and Transactional Replication and Mirroring.
•Involved in Data modeling, designing, and building relational databases.
•Backup and Recovery of production databases and tuning them for better performance.
•Creating and Modifying Tables, Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers, user-defined functions, Clustered and non clustered indexes and joins.
•Rebuilding the indexes to improve database performance.
•Database Security and Standard: Maintain database Standard and Security as per defined at Enterprise level. Expert understanding of role, profile, grants and privileges, providing and setting up DB access at different level for different group of users.
•Configured SQL Encryption on Production Servers.
•Monitoring SQL server performance using SQL Profiler and Data Tuning Advisor to find performance and dead locks.
•Used DBCC commands to check physical and logical consistency of the databases and rebuild indexes
•Transferring the data (ETL) to Data warehouse (Informatica) by SSIS.
•Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
•Extensively worked on Data Partitioning and Snapshot Isolation in SQL Server 2012
•Developed Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS).
SQL Server 2008/2012 Enterprise, Windows, Asp.Net2.0,, Microsoft Reporting Services, Microsoft Integration Services, SQL lite speed 5, Backup utility, SQL profiler, DTA.
MSSQLSERVER DBA & ETL DEVELOPER
Wipro Technologies - May 2014 TO November 2014
Project: CORNER BANK
Description: Corner Bank Group is an independent Swiss private bank, active across the whole range of traditional banking services. It specializes in the sectors of lending, Visa and MasterCard payment cards, as well as private banking. We, as Wipro are responsible for four modules like Online Banking, Personal Banking, and Commercial Banking and Mortgage services. I was involved in the mortgage banking Services module to manage the databases and build the SSIS packages and generate the reports in required format.
•Offshore Support on 24/7 environments in MS Sql Server 2008/2012.
•Installation, configuration and upgrading of MS SQL server 2008/2012, SQL patching, Database administration and maintenance support of SQL Database systems and related products in production environment.
•Responsibilities include ongoing database administration, configuring, managing, and performance tuning and troubleshooting.
•Working on Assigned Ticket Nos. from Client/Applications /Developers Team.
•Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
•Developed and optimized database structures, Tables, stored procedures, Dynamic Management views, DDL triggers, user-defined functions, Clustered and non-clustered indexes and joins.
•Involved in Creation, Development and Deployment of SSIS packages in SQL Server 2012 for Data Warehousing.
•Rebuilding the indexes at regular intervals for better performance
•Installed and administered Eight-Node cluster Active/Passive on Microsoft Windows Server 2012 Enterprise Edition
•Designed and implemented High availability and Disaster recovery strategies like Log Shipping, mirroring and configured Replication(Snapshot and Transactional)
•Handled Scheduled backups and restore operations with Lite speed 5.0 and monitored the Tasks, Maintenance plans.
•Involved in troubleshooting and fine-tuning of databases for its performance and concurrency.
•Developed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes.
•Migration of DTS packages to SSIS packages
•Involved in Migration of Databases from SQL Server 2008 to SQL Server 2012.
SQL Server 2008/2012 Enterprise, Windows Enterprise Server 2012, Asp.Net2.0, SFTP, Microsoft Reporting Services, Microsoft Integration Services, SQL lite speed 5
Wipro Technologies - April 2013 TO May 2014
Description: Vodafone is the cellular service Provider (Communication and Media) in India. It is the second largest mobile telecom company with an annual revenue of 38.85 billion pounds with 434 million subscribers as of 2014. For such a big Environment, there are different Applications like CRM, BRM, FMW, retail which run on MSSQL Databases.
•As a DBA, I was working in 24 *7 environment, providing support to Vodafone-India in terms of maintaining all applications' databases.
•Installation, configuration and upgrading of MS SQL server & apply Patches & hotfixes on Standalone and cluster Server environment
•Migrated SQL server 2003 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition.
•Rebuilding / monitoring the indexes at regular intervals for better performance.
•Created database objects like tables, indexes, views, joins, stored procedures, functions, triggers etc.
•Configuring & Administrating Log Shipping, Database Mirroring, Snapshot & Transaction Replication, Disaster Recovery Plan, Index Tuning, Backup Jobs and Deploying DTS & SSIS packages.
•Implement and maintain database security (create and maintain users and roles, assign privileges).
•Worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
•Check the blocking session and database locks, distributed locks or time out error, whenever business face any issue in their database.
•Performed and maintained database backup and recovery
•Implemented Data partitioning, Error Handling through TRY-CATCH-THROW statement, Common Table Expression (CTE).
•Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
•Involved in performance improvement using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA).
•Responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
SQL Server 2008/2012 Enterprise, Windows Enterprise Server 2012, .NET, Microsoft Visio, SFTP, Microsoft Reporting Services, Microsoft Integration Services, Backup utility.