SUMMARY

• 9 years of experience as a Database Administration in Microsoft SQL Server and over 4 years of experience as a Migration Engineer and SQL Database architecture with experience in requirement analysis, design, development, testing of client/server, web, Data warehouse and n - tier architecture applications.
• Microsoft Certified Technology Associate - Database Fundamentals.
• 7+ years experience administering enterprise-level production MS-SQL servers and databases.
• More than 4 years of experience on cloud environment with Microsoft Azure and Amazon RDS and EC2 platform.
• More than 4 years of experience in Data migration with SSMA, AWS DMS/ SCT and SSIS.
• 3+ years of experience in reporting tools - Tableau development, MSBI and Power BI development
• Expertise on RDBMS concepts as well as Data Modeling Concepts.
• Extensive experience in implementing High availability solutions like Always on, Replication models (Snapshot and Transactional), Log shipping, dynamic management views, clustering and mirroring on physical and virtual machines.
• Expertise in Always-On Availability Groups (AAG) and HA/DR Troubleshooting.
• Experience in extracting data and creating SAS Version 6 datasets from various sources like SQL database, Access database, Excel and flat files using Import techniques.
• Extensively worked on Active-Active and Active-Passive Clustering.
• Strong in standard Software Development Life Cycle (SDLC) and software development methodologies.
• Experienced in different phases of Software Development Life Cycle (SDLC) including Strategic Systems Planning, Designing, Object Oriented Programming (OOP) concepts, Programming, Testing, Documentation, and Presentation to clients and preparing customer specifications as part of software technical requirements and Customer support.
• Having good experience of Microsoft SQL Server 2008, 2008R2, 2012, 2014 and 2016 with Production support, Microsoft SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS) using Business Intelligence Development Studio (BIDS) and Crystal Reports 7.0/8.0.
• Knowledge on PostgreSQL 9.1, Oracle 10g, 11g, 12c and MySQL.
• Good at SQL Server 2012 new features like Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE).
• Experience in Data Modeling, Normalization, and Building Referential Integrity Constraints.
• Developed complex Stored Procedures, Triggers, Views, Functions, Indexes, Normalization, Data types using MS SQL Server 2000, 2005, 2008, 2012 and 2014.
• Experience in analyzing Locks, Dead Locks and Handling the Isolation Level and Concurrency Effects.
• Experience in Query Optimization and Performance Tuning.
• Experience in Data Base backup, Windows Azure and disaster recovery procedure.
• Experience in Replication - Snapshot, Merge and Transactional.
• Has very good experience in complete ETL cycle including data analysis, database design, data mapping and conversion and data load.
• Worked in In-Memory OLTP & OLAP environment that includes Production (24x7), QA and development databases in SQL Server.
• Experience with the Cognos Reportnet suite (Framework Manager, Cognos Connection, Report Studio, and Query Studio) on Windows.
• Experience in Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, FACT, Dimensional tables and Operational Data Store (ODS).
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
• Worked on configuring VLAN’s and IP’s for the new SQL DB cluster.
• Strong Business and Application analysis skills with excellent communication & professional skills.
• A self -motivated Individual with exemplary analytical and problem solving skills.

TECHNICAL SKILLS

SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio

Languages: C# ASP. NET, T-SQL, My SQL, VB.NET, HTML, XML, C/C++, CSS, DHTML, Java Script

Operating Systems: Windows, UNIX (Sun Solar), LINUX

Databases: MS-SQL Server 2016, 2014, 2012, 2008R2, 2008/2005/2000 , Teradata, PostgreSQL 9.1, Oracle 10g, 11g, 12c, Redshift and MySQL.

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

Scripting: Shell Scripting

Business Intelligence: SSRS, SSIS, SSAS

DB Utilities: SQL Server Management Utility, Query Analyzer

Software Tools: Visual Studio 2005/2008/2010 , VMware, AWS, Azure Visual Source Safe, TFS, MS Office Suite, SCOM

Data Modeling Tools: Erwin, Red gate, Lite Speed,Embarcadero

Data Migration Tools: SSMA, AWS DMS and SCT, SSIS

Cloud Technologies: Microsoft Azure, Amazon RDS (Relational Database Service) and EC2 (Elastic Computing Cloud)

PROFESSIONAL EXPERIENCE

Confidential, Las Vegas, NV

Microsoft SQL Server DBA / Migration Engineer/ Architecture

Responsibilities:

• The ability to assist in finalizing a Microsoft SQL Server migration design in which to migrate older Microsoft SQL server machines into a right-sized Virtual Machine (VM) residing within the customer’s environment. Includes analyzing previous discovery data.
• Physical to Virtual (P2V) SQL Server migration.
• Sizing the environment bases on empirical performance metrics and best practices
• Implemented Always On Availability Group, Replication and log shipping as a High Availability.
• Configured and Maintained Database Servers from 2005 through 2014 version.
• Migrated data from Oracle 12g to SQL server 2012 by using SQL server integration service (SSIS) and SQL Server Migration Assistance for Oracle (SSMA).
• Worked on homogeneous migration from on premise SQL and Oracle server to Amazon RDS environment with AWS DMS and SCT tools.
• Deployed on Amazon Elasticsearch service for log analytics.
• Worked on Azure Resource Manager to manage the resource for the solution in a single, coordinated operation.
• Deployed Azure SQL instance as the secondary replica in Always On.
• Analyzed execution plans, and tuned queries and databases for better optimal performance.
• Used SQL server Profiler for the trace files and Database Tuning Advisor (DTA) for better query level performance.
• Maintained production SQL servers and Databases with daily maintenance job and performed SQL server security management.
• The ability to understand and tune how a database interacts with a specific application.
• The ability to understand and make use of tools available (vSphere Web Client, MS Windows Server Perfmon) to troubleshoot and tune SQL DB performance after DB migrations where applicable.
• Worked on data conversion and partitioning strategies on PostgreSQL.
• Design and build architecture to support Tableau environment and data feeds.
• Proactively and continuously improve IT metric dashboards and cost allocation models for IT leaders. Assist in evaluating client business requirements, think outside the box and providing technical recommendations.
• Offshore Solution Architecture with basic concepts on Redshift DB architecture and MS SQL on designing, implementing and optimizing technology.
• Worked on configuring VLAN’s and IP’s for the new SQL DB cluster.
• The ability to minimize downtime completing SQL server migrations with knowledge in detailed troubleshooting of their infrastructure environment SQL 2000, SQL 2005, SQL 2008/R2, SQL 2012/R2 and 2016
• SSAS cubes performance tuning.
• Ability to script and develop SQL server components like stored procedures, views and functions.
• Hands-on understanding of the VMware admin clients and the ability modify Virtual Machine properties appropriately.

Environment: Microsoft Windows 2016, 2014, 2012, 2007 Server, Microsoft SQL Server 2016, 2014, 2012, 2008 R2, 2005, 2000, Microsoft .Net 2.0, VMware admin clients, vSphere Web Client, SCOM.

Confidential, San Ramon, CA

Microsoft SQL Server DBA/ Migration Engineer

Responsibilities:

• Joined as a part of SQL Server 2012 upgrade project in December 2014.
• Migrated more than 500 production databases to SQL server 2012 environment from the older versions in production, UAT, Testing and Development server.
• Migrated more than 20 databases from Oracle and Teradata.
• Worked on the SQL Server 2014 upgrade project.
• Co-ordinate with the DR migration to their new Denver, CO location.
• Installation and Maintenance of SQL Server 2012 on Test, Development and Production Environments.
• Seamlessly migrated more than 20 databases to AWS RDS (Relational Database Service) and EC2 (Elastic Computing Cloud) environment with DMS (Database Migration Service)/ SCT (Schema Conversion Tool) including Oracle and PostgreSQL.
• Implemented Clustering and used VM Ware as part of Server consolidation project.
• Co-ordinate with the Online Banking, CRM, First Hawaiian Bank (FHB) and other major projects.
• Worked on share point and Box environment with application and business owners.
• Configured, Developed and supported OLAP solutions using Microsoft SSAS.
• Familiar with the Shell scripting which we used for the database inventory project for the Cherwell application.
• Implemented Query Optimization, Indexing and Table Partitioning, along with In-Memory OLTP to improve the performance for the CCAR project.
• Familiar with the SSRS, SSAS and SSIS in SQL Server 2012.
• Implemented Transparent Data Encryption (TDE) on production data.
• Co-ordinate with the application team and the Business Users for a successful project completion.
• Maintained database warehouse for the online bankingapplication andonbuilding staging data as per new requirement.
• Assisted on deploying Azure search for the mobile application under PaaS (Platform as a Service) service.
• Successfully migrated CCAR data warehouse to Azure data warehouse.
• Usage of new compression Techniques in SQL Server 2012 for backup and restore jobs along with the Windows Azure for the cloud backup.
• Involved in the implementation of Always On Availability Group as a High Availability solution on clustered and stand-alone scenarios on SQL Server 2012.
• Implemented Database Mirroring, Log shipping, Transactional Replication and Always On as a part of DR plan.
• Design and develop scorecards, dashboards and multi-dimension data cubes using MSBI and Power BI.
• Participate in the design and development of enterprise wide data repositories; make recommendations to improve the efficiency and functionality of the database, MSBI and Power BI environment and associated processes.
• Closely monitored the performance for the reporting DB’s by SQL Profiler tool.
• Worked on Oracle 12c and 11g, PostgreSQL 9.1 and MySQL as a part of migration project.
• Created Logins and Roles with appropriate permissions.
• Created and Maintained Database Maintenance Plans.
• Worked on Microsoft and internal audits, security, vulnerability assessment and compliance using third party tools like GridApp clarity and SQL compliance manager by IDERA.
• Modify Stored Procedures and complex T-SQL Queries to improve query execution process.
• Write T-SQL Scripts for database backup jobs and daily/weekly jobs.
• Familiar with the SQL Server Profiler for the performance tuning for the SQL query.
• Import data across multiple instances using BULK INSERT and BCP Utility.
• Hands-on experience in Performance Tuning and Index Tuning.
• Able to communicate effectively with a wide range of people, by showing interest and carefully listening to their needs.
• Familiar with Team Foundation Server (TFS).
• Created User Groups, Roles to implement the Cognos Security.
• Worked in MS Access for the inbound consolidation project.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SSRS.
• Extract, Transform, and Load data from heterogeneous data sources to SQL Server using SQL Server Integration Services (SSIS) Packages.
• Create Clustered and Non-Clustered Indexes to improve the performance of database access.
• Create and manage databases across Development and Production instances using SQL Server Management Studio.
• Involved in Logical and Physical Data Modeling process using MS Visio.
• Closely worked with the production environment for the upgrade, security patching and RFC.
• Closely worked on fail over clustering as a part of database consolidation project.

Environment: Microsoft Windows 2014 Server, Microsoft Windows 2012 Server, Microsoft SQL Server 2008 R2, Microsoft SQL Server 2005, Microsoft SQL Server 2000, Windows 2007 Server, Windows 2012 Server.

Confidential, Chicago, IL

MS SQL Server DBA/ Migration Engineer

Responsibilities:

• Upgrading SQL Server 2000 Production, Test and Dev environment to SQL Server 2008.
• Worked on gathering requirements from the business and analyze them with offshore team. The application is 3- tier architecture and builds using Microsoft Visual Studio 2010 with .Net Framework 4.0.
• Developing stored procedures, triggers, views and adding/changing tables for data load and transformation, and data extraction.
• Working on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Configuring, tuning, and optimizing SQL 2008.
• Worked on SSIS, SSAS and SSRS configuration.
• Performance testing on stored procedures, indexes, and triggers.
• Creating DTS Packages for data import, export, scrubbing and scheduled jobs for backups.
• Data migration using Bulk copy program and DTS.
• Helping the front-end application developers with their queries.
• Job Monitoring and making sure all jobs run successfully every night.
• Performing low-level scripting, fixing of codes and software enhancement process.
• Administrator tasks like managing users, roles, and profiles
• Performed Database backups with tools like lite speed.
• Used SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Development of various reports and reporting interfaces utilizing Microsoft SQL Reporting Services.
• Suggest Replication techniques to meet business needs.
• Worked on Oracle Database 10g and MySql as part of the consolidation project.
• Setting MAX DOP (Max degree of parallelism) to 8 for 28 GB memory.
• Scheduled and monitored all maintenance activities including database consistency check and index fragmentation.
• Analyzed execution plans, and tuned queries and databases for better optimal performance.
• Fixing Missing Indexes and Excess indexes
• Generated script files when changes applied to stored procedures and functions.
• Managed schema objects like Triggers, cursors, indexes, procedures.

Environment: SQL Server 2000/2008 Enterprise, Windows Enterprise Server 2008, IIS 6.0, T-SQL, Microsoft Reporting Service.

Confidential, Atlanta, GA

Microsoft SQL Server DBA/ Migration Engineer

Responsibilities:

• Responsible for configuration of Microsoft Server/Client Products and implementation.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Defined relationship between tables and enforced the referential integrity constraints. Created Clustered and Non-Clustered Indexes.
• Responsible for General Database Administration and Performance tuning.
• Experience in resolving deadlock and blocking issues for concurrent users.
• Worked with DTS packages to load the massaged data into Data warehousing system.
• Data Migration from legacy to master tables using DTS-Import and Export wizard.
• Performance tuning of HMS e apps ERP on SQL Server 2008.
• Developed Database Backup Scripts and automated this process
• Used MS Visual Source Safe 6.0 as a Version Control System.
• Partly Participated in system study and analysis of software applications.
• Experienced in support, applications and software development

Environment: MS SQL Server 2008, 2005, .NET Framework 4.0, T-SQL, DTS, Visual Source Safe 6.0, Windows 2003 Server, Compuware QA Load test and HMS report Writer.

Confidential, Omaha, NE

Microsoft SQL Server DBA/ Developer

Responsibilities:

• Worked on Agile Methodology (Scrum) to meet timelines with quality deliverables
• Involved in gathering and preparing the requirements from clients for product design and enhancements.
• Communicated with client for daily updates, reviews and demos. Involved in user training programs.
• Managed 17 databases at the headquarters running on 10 servers
• Designed Business components and Data Access Layer using C#.
• Database version control using VSS.
• Developed SQL scripts for maintaining administration tasks.
• Created DTS packages to maintain central repository. Extensively used different SQL2005 DTS tasks.
• Backup and Recovery Plans Involved in installation and configuration of SQL server 2005.
• Applied patches and service packs to keep the database at current patch level.
• Responsible for configuration of Microsoft Server/Client Products and implementation.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Involved in Analysis and Design Documentation, User requirements and maintained good documentation.
• Designed and implement database logical and physical Schemas using Erwin 3.5.2./4.0
• Supported production and development databases.
• Implemented SQL standards in writing stored procedures, Triggers, Views, Sql functions and locking issues.
• Maintained 6000 tables, or Field office and Headquarters database servers
• Maintained the field office database backups through SQL mail Scripts.
• Converted the legacy data from mainframes and dbase by using DTS packages
• Interacting with the users and troubleshooting the problems involved with the development of stored procedures.
• Created and maintained users and user groups
• Involved in Extraction transformation and loading of data using SSIS to create packages
• Involved in user trainings and implementation.
• Implemented application variables for application level reports.
• Involved in creating, deploying and managing reports using SSRS.

Environment: MS SQL Server 2005/7.0, T-SQL, DTS, Windows 2003 Server, Compuware QA Load test, SQL Server Integration Services 2008, SQL Server Reporting Services 2008.

Confidential

Microsoft SQL Server DBA/ Developer

Responsibilities:

• Actively participated in gathering of Requirement and System Specification.
• Worked on complex T-SQL statements, and implemented various codes and functions.
• Involved in creating Stored Procedures, views, tables, constrains.
• Created stored procedures and triggers for Data consistency.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent Data entry into the database.
• Wrote complex stored procedures to process employee’s requirement and generating.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity.
• Debugged the T-SQL queries for performance tuning.
• Checked & updated Database Statistics and Re-indexing.
• Created Users and Roles, and managed security and permission of database.

Environment: SQL Server 2005, 2008, 2008R2 Windows NT Server, SQL Profiler, C# ASP. NET.