SUMMARY

• Database architect/Administration with 10+ year track record of developing large and complex databases in SQL Server 2012, SQL Server 2008 R2, 2008 and 2005.
• Experienced database Analyst, DBA and software professional.
• Several years of related work experience, with an emphasis on database development and architecting, administration, tuning and management of transactional and analytical (data warehouse) databases.
• Extensive working knowledge on SQL Server 2005, 2008R2, 2012, 2014 & 2016 including SQL DB migrations from SQL 2000/20005.
• Excellent technical knowledge of database and transaction management technologies and operating systems.
• High level of proven competence with data manipulation languages, data definition languages, physical database design, and application performance analysis & tuning.
• In depth knowledge on database backup and recovery for SQL Server
• Strong experience troubleshooting, analyzing and tuning complex queries and database workloads
• Strong experience and knowledge in Database Project Implementation experience
• Strong experience and knowledge of high availability strategies (SQL Server install/configuration on Windows Cluster, Database replication) and disaster/recovery strategies.
• Comprehensive implementation knowledge on SSIS, SSAS and SSRS.
• Knowledge of enterprise middleware and security tools and standards.
• Experience working collaboratively with a variety of roles in technical environments.
• Extensive experience with MS SQL Server (TSQL,tables, triggers, unions, joins, complex queries and stored procedures)
• Strong experience in the physical and logical design of database architecture
• Experience in managing clustered SQL environments utilizing mirroring, availability groups,
• Fluency with appropriate tools including Power Shell,SQL Management Studio, Query Analyzer, Profiler, Performance Monitor and other SQL Server management tools as well as the entire Microsoft Office suite
• Working knowledge of report creation in Excel/crystal report.
• Ability to follow and enforce change management processes within production environments
• Demonstrated interest and ability to work on new, innovative, cutting edge technologies
• Successful in meeting or exceeding customer expectations through detailed analysis and design, creative engineering and development, followed by efficient execution and delivery.

TECHNICAL SKILLS

Databases: MS SQL Server 2005, 2008, 2012,2016,Oracle, DB2,Sybase

Programming: Visual Basic 6, Visual Basic 5, C, C++ & SQL,PL/SQL

DBA: Database administration of MS SQL Server 2012, 2008, 2005

Operating System: Windows 7, Windows 2008/2003 Advanced Server, NT Linux

Tools: Toad, Backup Utility, SQL Lite Speed, Visio, SQL PROFILER, SQL Server Data Tools, Tableau Reporting

Network Topologies: TCP/IP, DNS, WINS, DHCP, FTP, SNMP, SMTP

PROFESSIONAL EXPERIENCE

Confidential

Senior SQL DBA cum Developer

Environment: MS SQL 2012, 2008, 2005,2014,2016

Responsibilities:

• Responsible for Migration of SQL 2000 and 2005, SQL 2008, SQL 2012 To SQL 2014 and SQL 2016 which includes remediation, incident and ticketing activities
• Responsible for Troubleshooting including providing root cause analysis for SQL migration project which include error and issues for Prod and Non Prod Environment.
• Responsible for Production support, documentation and ticketing process as a part of on call rotational DBA support including on - site database and system support
• Responsible for Creating and maintaining database & transaction processing environments for application testing, Pre-Production verification, and production operation.
• Responsible for Creation and maintenance of SQL Server databases, database objects, including file groups, partition, tables, indexes, views, triggers, procedures, sequences ... etc. in development, test, production and disaster recover environments
• Performing database monitoring and tuning, including memory, CPU, locking, sorting, etc.
• Work with application team to perform SQL tuning. Require to have high level of proven competence with SQL (DML and DDL).
• Responsible for providing subject matter expertise in prod and non-prod databases.
• Performing testing, reporting, capacity planning, performance tuning, back-up and restores.
• Responsible for the physical databases on specific database technologies including design and implement back-up, recovery, archiving and conversion strategies.
• Make recommendations to maintain and improve capacity and system performance.
• Design and develop physical databases.
• Monitor the system, and act upon system and application automated alerts.

Confidential

SQL DBA(Database administrator),Developer

Environment: MS SQL 2012, 2008, 2005

Responsibilities:

• Responsible for Compliance Database Migration to MSSQL 2012 using SSRS, SSIS.
• Performed skilled counsel in the technical design of applications by using design software facilities and features which includes walk through of critical components.
• Performed Transformation of logical data models into physical database structures including data modelling assistance
• Performed Automation using PowerShell Scripts.
• Managing ETL (Extract, transform, load) process for data migration from MSSQL by SSIS,SSRS,SSAS Using TSQL,SQL Server Data Tool, BIDS
• Creation of simple and complex SSIS packages for data ETL Handling of XML file in MSSQL 2012.
• Performed SQL Server Migration experience from SQL 2000, 2005 to SQL 2012/2014.
• Involved in Cross Platform Migration (Oracle to SQL).
• Troubleshoot Database service outages as they occur, including after-hours and weekends.
• Schedule, plan and execute the database backup and restores for the respective project.
• Monitor and resolve incidents, infrastructure systems and applications (Mainly MS SQL, DB2 and Oracle).
• Responsible for Application Performance Tuning and Optimization.
• Plan, coordinate, and implement security measures to safeguard information in data files against accidental or damage and modification.
• Document each process steps to complete the backup and restore and any issues encountered using advanced backup and recovery techniques
• Responsible for fixing Database Issued based on Ticketing software for PROD,UAT,DEV Server like Restore, Backup, Log Shipping, Replication using Mixed-Mode SQL authentication
• Responsible for generating reports using SQL scripts
• Responsible for maintaining database and related tracking reports.
• Developed and maintaining the SSIS, SSRS source code.

Confidential

SQL DBA(Database administrator),Developer

Environment: MS SQL 2012, 2008

Responsibilities:

• Managing ETL (Extract, transform, load) process for data acquisition of BSD, CSD and BSA Call Center related data from various sources using SSIS, SSRS, and SSAS.
• Producing ad-hoc, daily, biweekly and monthly KPI reports for analyzing the performance and efficiency of all teams and KPI’s of BSD (Business Service delivery), CSD (Commercial Service Delivery) and few KPI’s for BSA (Business Service Assurance)
• Maintaining 16 Microsoft Access, 5 MS SQL Server and 2 My SQL based reporting databases, making sure each of them is up-to-date and houses accurate data and right user permissions
• Updating, enhancing and maintaining all SQL (Procedures, Queries, Views and Scripts) as per the source data changes to keep the data flow going.
• Biweekly Production of Performance Scorecards of approx. 550 consultants
• Monthly meetings with the KPI primes and SM’s (Senior Managers) to analyze and finalize Scorecard targets, review existing KPI reports and gather any new requirements or changes to existing KPI reports
• Communicate the results of analysis, issues or delays proactively, including impacts to the management team of BSD, CSD and BSA.
• Maintaining the BSAR SharePoint portal, managing access, posting reports and announcements and updating calendar etc.
• Managing and replying on time to all emails received on BSAR (Business Service Analytics and Reporting) mailbox which receives inquiries, issues and concerns regarding Scorecards and all reports generated by BSAR team.
• Coordinating with other departments to gather information when needed to research, troubleshoot, and resolve issues
• Representing Business Service Analytics and Reporting (BSAR) team in cross-functional groups as a subject matter expert
• Prioritizing and monitor all reporting changes and requests.
• Currently working on a Project to transfer all performance scorecards for BSD and CSD to a third party company called Orbit.
• Perform Troubleshoot and resolve a variety of identified problems (integrity issues, performance issues, blocking and deadlocking issues, replication issues)
• Performs database monitoring, performance tuning, and database maintenance and testing.
• Responsible for Designs and develops complex Microsoft SQL environments and database models with application support teams,

Confidential

DBA (Database Administrator)/ETL Tester

Environment: SQL Server 2000, 2005, 2008 and 2012

Responsibilities:

• Responsible for installation design and support of SQL Server, and Sybase databases
• Performed shell scripting and OS-level troubleshooting on windows Environment
• Responsible for setup, troubleshooting and maintenance of Log shippingof PROD server
• Performed troubleshooting of slow running query, SSIS and other issues using SQL Profiler
• Performed ETL testing of feed file from different business unit
• Participated in an on call rotation and incident severity sev1 .
• Performed Monitor databases actively for tuning opportunities. performance tuning and optimization of database
• Worked on creating database objects.
• Worked on Build/Design scalable database solutions to meet business requirements.
• Monitored databases actively for tuning opportunities.
• Worked to Create and maintain procedural and operational documentation, disaster recovery plans and documentation that relates to database operating procedures.
• Performed Backup and Recovery using Advanced backup and Recovery techniques
• Performed applicationoptimization by working with developers, customers and system support personnel
• Perform database recovery and backup tasks on daily and weekly basis using Mixed Mode SQL authentication
• Responsible for generating reports using SQL scripts
• Responsible for maintaining database and related tracking reports.
• Developed and maintaining the SSIS source code.
• Company: Conquest-financial Services, Toronto, ON
• Role & Responsibility: Database Administrator / Data Analyst
• Environment MSSQL Server 2000, 2005 and 2008
• Imparted operational support to MSSQL
• Developed procedures for operations of database.
• Set up MSSQL database and solved database operational issues.
• Gathered data elements and outlined database specifications.
• Performed Database management and programming using Oracle, SQL Server 2000, 2005 and 2008.
• Responsible for development and maintenance of databases of the organization
• Performed problem determination and resolution
• Performed applicationoptimization by working with developers, customers and system support personnel
• Converted existing Crystal Reports into Tableau Dashboards
• Used excel sheet, flat files, CSV files to generated Tableau adhoc reports.
• Done other duties as assigned.