SUMMARY:

• 8+ years of experience in SQL Server Database Administration and Developer for very large and complex databases from versions 2016, 2014, 2012, 2008/2008R2 and 2005.
• Experience in supporting Microsoft Azure systems including SQL Server hosted on Azure Virtual Machine (IaaS) and Azure SQL Databases (DBaaS).
• Very strong in Azure system configuration, database migrations, backup and recovery, geographic data replication, performance monitoring and tuning and disaster recovery configuration and execution.
• Expertise in Data Modeling, Database Design, Programming, Development and Implementation of Database & BI intelligence system using MSSQL 2005/2008R2/2012.
• Extensive experience as SQL Server DBA in Production, Development and Staging Environments.
• Extensive experience in Installation, Upgrades, Patches, Configuration and Administration for SQL Server in a Clustered and Non - Clustered Environment.
• Excellent experience in In-Place and Side-by- side Upgrades from MS SQL Server to MS SQL Server 2008/2008R 2/2012/2014/2016.
• Access control management in Microsoft SQL Server 2016/2014/2012/2008/2005.
• Experience in BI Development and Deployment of DTS, SSIS packages from MS-Access, Excel, and Oracle.
• Implementing High Availability (HA) technologies which include Log shipping, Database Mirroring and replication.
• Configuring and Deploying SQL Server Integration Services (SSIS) Packages.
• Working knowledge in Analysis Services (SSAS), Reporting Services (SSRS) and Clustering.
• Excellent experience in In-Place and Side-by- side Upgrades from MS SQL Server to MS SQL Server 2008/2008R 2/2012/2014/2016.
• Knowledge of SQL Server Analysis Services (SSAS).
• Monitoring and Troubleshooting SQL Server Agent Jobs.
• Extensive experience in Installation, Configuration and Deployment of SSRS using Scale-Out, Scale-Up and Local topologies.
• Implementing different Backup Strategies and experienced in backups, restores and DR (Disaster Recovery) procedures.
• Expertise in Scheduling Database tasks - Jobs, Alerts, Emails, Notification.
• Expertise in Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler, PerfMon and Spotlight
• Expertise in Always-On Availability Groups (AAG) and HA/DR Troubleshooting.
• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Expert in data transformation services and Bulk Loads with SSIS and BULK INSERT ETL Operations.
• Troubleshoot performance problems, fine-tuning of databases and index Analysis.
• Experience on 64 bit SQL Server, 2012, 2008 R2 systems and MSCS Configurations.
• Strong Knowledge of service management processes like ITIL (Incident, Problem, Change and Release).
• Having Experience on Data center servers and handling 1.4 TB databases.
• Experience in supporting Very Large databases (VLDB) and troubleshooting the problems.
• Strong experience in mentoring team members and writing documentation.
• 24 X 7 Production Database on Call Support.

TECHNICAL SKILLS:

Databases: SQL Azure, SQL Server 2000/2005/2008/2012/2014/2016, Amazon RDS, Oracle 9i/ 10g/ 11g, MySQL 5.x, PostgreSQL, MongoDB, Dynamo DB and MaxDB.

Cloud Infrastructure: Azure Cloud, Azure Data Factory, Azure Data Lake, Azure SQL Data Warehouse

Database Tools: Management Studio (SSMS), Enterprise Manager, Query Analyzer, SQL Profiler, Performance Monitor, SSIS, SSAS, SSRS, DBCC, PL/SQL Developer, SQL Developer, Toad, BR*Tools, SAPGUI, MySQL Workbench, ASMCMD, RMAN, BCP, GCSCI, SRVCTL, CRSCTL, EXP/IMP, EXPDP/IMPDP, SQLLoader and Import/Export Wizard.

Operating Systems: Windows 2008/2012 Server, Linux (RHEL, CentOS, Ubuntu, Suse, Oracle) and UNIX

PROFESSIONAL EXPERIENCE:

SQL BI Developer/ Cosmos Developer

Confidential, Redmond, WA

Responsibilities:

• Data analytics and engineering experience in multiple Azure platforms such as Azure SQL, Azure SQL Data warehouse, Azure Data Factory, Azure Storage Account etc. for source stream extraction, cleansing, consumption and publishing across multiple user bases.
• E2E understanding of all MCIO usage related streams such as Compute, Azure-SQL, Azure-Storage, and Azure- DocDB built up on a customer centric platform encompassing constant communication with partners/upstream providers in guaranteeing 99%Completeness and 100% accuracy.
• Expert knowledge on Microsoft proprietary SCOPE language specification (de-facto standard for all data related operations) for Microsoft Internal COSMOS platform for most of, much of usage streams such as Azure Compute, Azure Storage, Azure SQL & Azure DocDB.
• Cloud based report generation, development and implementation using SCOPE constructs and power BI. Expert in U-SQL constructs for interacting multiple source streams with in Azure Data Lake.
• Worked extensively on ACT (accuracy, completeness and timeliness) project for MCIO usage reference system - DQ frame work that analyzes and detects anomalies such as fraud, underutilized Azure resources, etc.
• Pipeline creations and scheduling for source and end stream creation for MCIO using Azure
• Data Factory for on-perm to Azure SQL and Azure SQL to Microsoft Cloud Internal Implementation COSMOS.
• Worked aggressively on Microsoft Optimization Grim Reaper project which identifies SKU, VM recommendations across multiple platforms such as Azure Compute and Azure SQL utilizing Grim Reaper algorithm which is based on historical trends.
• Data engineering using Microsoft Internal Geneva platform for Module creation, source data extraction, scheduling, DQ frame work and source swaps for Storage, Compute and SQL platforms.
• Created objects like tables, views, stored procedures, and indexes.
• Worked closely with different business teams to gather requirements, prepare functional and technical documents and UAT Process for Creating Data quality rules in cosmos & Cosmos Streams.
• Created daily, weekly, monthly reports for various categories and Hierarchies based on business needs using bigdata Excel Extensions & Analyzed Data Quality.
• Practiced Agile Principals, Sprint planning, daily standups.
• Ensured the development teams are practicing the agile principles. Completed product

Demonstrations, retrospectives, and resolve action items.

Environment: SQL Server 2016, SQL Server 2014, SQL Server 2012, Enterprise Edition, Management Studio,, Windows 2008/2012 Server, Visual Studio Interface, Microsoft Power BI, Cosmos Scope Scripts.

SQL BI Developer, Power BI

Confidential, Redmond, WA

Responsibilities:

• Requirement analysis
• Identified Dimensions and Facts
• Build the cube
• Created Power BI dashboards and reports and User portal design
• Demos and status calls with client
• Created various database objects such as tables, indexes and views based on the requirement.
• Created reports such as Parameterized, Cascading, and Drill through/Drill down Reports, Charts and specialized in producing Sub Reports using Relational data warehouse and OLAP Cubes.
• Created daily, weekly, monthly reports for various categories and Hierarchies based on business needs using SSRS.
• Created Company level inventory, sales, budget reports from OLAP Cubes using MDX Script.
• Created many SSRS reports with lots of metrics on it using row grouping and column grouping.
• Involved in Performance Improvement of thus created reports and deployed reports onto Report Server and Report Manager and to SharePoint Server making those reports available for the end users.
• Created table valued functions and used in the report stored procedures on the fly.
• Worked on the performance of reports, created appropriate indexes on tables and modified the code in existing stored procedures for the best fly-on performance.
• Confidential ended functional testing meetings, user acceptance sessions and worked on the feedbacks.
• Created deployment documents for the reports and worked with database administrator in the deployment of the report objects to the production server.
• Created SSIS packages to get the data from different sources to BI environment using different transformations on hourly basis, daily basis and monthly basis.
• Involved with ETL team and created packages using SQL Server Integration Services (SSIS) to extract data from various feeder systems, apply required transformation and finally load the data to the destination data warehouse.

Environment: SQL Server 2016, SQL Server 2014, SQL Server 2012, Enterprise Edition, Management Studio, Windows 2008/2012 Server, Visual Studio Interface, Microsoft Power BI.

SQL DBA

Confidential, Columbus, OH

Responsibilities:

• Database Administrator, Database Programming.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Rebuilding the indexes at regular intervals for better performance
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Monitored and modified Performance using execution plans and Index tuning.
• Deploying new code base release to UAT and Production Environments.
• Perform SQL Server service pack and Windows Service pack upgrades.
• Working with customers on Application rollouts and server migrations.
• Extensively worked on Enterprise Manager for managing the database.
• Troubleshoot performance problems and fine-tuning of databases.
• Involved in Index Analysis and Performance Tuning.
• Worked with different upstream team for downloading ETL MART data.
• Converting DTS packages into SQL Server 2005 Integration Services.
• Migrating SQL Server 2000 data bases into SQL Server 2005.
• Recovering the databases from backup in disasters.
• To analyze long running slow queries and tune the same to optimize application and system performance.

Environment: SQL Server 2005, SQL Server 2008, SQL Server 2012, Windows 2003/2000 Server, SQL Lite Speed 4.5, MSE, ME Change Request, Visio. Enterprise Manager, SQL Query Analyzer, SQL Profiler.

Database Administrator

Confidential

Responsibilities:

• Installing SQL Server with minimum access privileges service account to improve security and to Confidential ain high ratings in SOC audits.
• Installed, configured SQL Server 2005 Clustering on Microsoft Clustering services (MSCS) from Hardware inventory to test environment.
• Involved in Analyzing and Upgrading SQL Server 2000 test servers to SQL Server 2005.
• Having experience on SAN and RAID levels and building SQL Cluster servers on SAN Environments.
• Perform SQL Server service pack and Windows Service pack upgrades.
• Designed and implemented comprehensive Backup plan using SQL Lite Speed.
• Resolved and tweaked memory pressures caused during product release.
• Worked with customers on Application rollouts and server migrations.
• Troubleshoot performance problems and fine-tuning of databases.
• Expertise in designing databases and capacity planning.
• Rebuilding the indexes at regular intervals for better performance.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• To provide 24x7 production support for SQL Server databases on Clustered Servers with sizes ranging from 1 to 2 Terabytes to achieve maximum performance and uptime in production environment.
• Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.
• Monitored and modified Performance using execution plans and Index tuning.
• Transferring the data (ETL) to Data ware house by SQL Server 2005 Integration Services.
• Rebuilding the indexes at regular intervals for better performance.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented and Scheduled Replication process for updating our parallel servers.
• Designed and created databases, tables, views, store procedures and triggers.

Environment: SQL Server 2005 and SQL Server 2000, Windows 2003/2000 Server, SQL Lite Speed 4.5, MSE, VSS and Password Updater.

SQL Server DBA

Confidential

Responsibilities:

• Monitoring the server for High availability of the servers.
• Solving the request raised by user support.
• Participate in implementation of new releases into production.
• Facilitates application deployment and joint effort deployments.
• Meet the SLA (Service Level Agreement) established.
• Day-to-day administration of live SQL Servers.
• Designed and implemented Security policy for SQL Servers.
• Used Stored Procedures, DTS packages, BCP for updating Servers.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented and Scheduled Replication process for updating our parallel servers.
• Automated messaging services on server failures, for task completion and success.
• Execute procedures to accomplish short-term business goals.
• Deploying Administration tools like SQL DB Access, Performance Monitor and Backup Utility.
• Deploying monitoring tools like Site scope and spot light.
• Table partitioning to improve I/O access.
• Enforce Database Security by Managing user privileges and efficient resource management by assigning profiles to users.
• Using database level triggers code for database consistency, integrity and security.
• Tested and Implemented procedures to detect poor database performance, collecting required information, and root cause analysis.

Environment: SQL Server 2000/7.0, IIS, Windows 2003/2000 Server, SQL DB Access, Performance Monitor, Backup Utility, MOM, MSE and Site scope.