CAREER SUMMARY:

• 11+ years of SQL experience including Administration, troubleshooting, managing, automations and performance tuning SQL Server 2005/2008/R 2/2012/2014/2016/2017.
• Extensive working experience in Administering, Monitoring and Troubleshooting Mission Critical OLTP systems.

PROFESSIONAL SUMMARY:

• Setup and configured Always ON, Mirroring, Replication, Log shipping, clustering as part of high availability Solutions.
• Working experience in Configuring Multi - subnet and Multiple Listeners for High Availability and Disaster recovery purpose.
• Confidential BI Developer implementing SSIS, SSRS and SSAS using
• Confidential Business Intelligence (MSBI), SQL Server Data Tools (SSDT) and Power BI
• Highly experienced in Designing, Developing and Deploying various reports like Tabular, Matrix, Chart, Drill down,
• List, Parameterized, Cascading and other reports using SSRS.
• Experience with advanced power BI topics such as complex calculations, table calculations, geographic mapping, performance optimization
• Designed and developed Power BI graphical and visualization solutions based on business requirement.
• Import data from multiple data sources into BI Tools, Knowledge in making use of data sources: analysis server, data lake, azure sql, cosmos db
• Experience in creating different custom visualizations like shaper map, donut chart, water fall chart, gauge chart, key Influencers, Viscio, Filled map, Line chart, Bar chart, tables,matrix, cards, Tree Maps etc created relationships between data, created calculated columns and measures using DAX Query.
• Worked on DAX expressions like filters,Aggregate, Mathematical Functions, TimeIntelligence etc.
• Knowledge in making Incremental refresh, column profiling, making use of Buttons,Bookmarks, Shapes, Textboxes, Imagesetc
• Good knowledge and understanding DAX Functions in Power BI.
• Experience in migration database servers from SQL Server 2005/2008 to SQL Server 2012/2014.
• Worked on configuring and migrating databases from oracle to Amazon Aurora database using AWS data migration tool.
• Configured, Deployed and Managed SQL Azure/Cloud DB’s on Windows Azure.
• Worked on Migration Strategy and developed a POC migrating VMware/On-premise datacenter to AWS utilizing, AWS EC2, S3, RDS, VPC, and Direct Connect.
• Documented and prepared Operational support guides & TSG (Troubleshooting Guides) for tier-1 & tier-2 support teams.
• Extensive experience with Stored Procedures, Triggers, Functions, Query Performance Tuning, Clustered / Non-Clustered Indexes, Index Fragmentation and Statistics analysis .
• Worked with team on automating full DB level monitoring and auto tasks using PowerShell.
• Monitoring Database Growth and Documenting server setting and verifying configuration changes.
• Proficient in using SQL Profiler for both performance and auditing purposes.
• Strong experience in managing databases Upgrades & Backup/Recovery strategy implementation
• Experience in using external tools such as IDERA Diagnostic manager and Quest Lite speed.
• Automated the Database Maintenance tasks by creating SQL Jobs and Database Alerts.
• Implemented different types of Replication Models like Snapshot, Merge and Transactional.
• Experience in working with SQLCMD, BCP and DTS to load text files to SQL Server
• Strong analytical and debugging skills to achieve error free deployments.
• Strong quantitative analysis skills to lend insight to highly ambiguous and sensitive business problems.
• Responsible for debugging and diagnosing platform outages on cloud platform
• Hands on experience using Test management tools like PS and VSTF.
• Experience in Test Estimation and Test Approach i.e. Security, Performance and White box testing.
• Good experience in driving the Bug triage, Daily scrum and Bug scrub meetings. Outstanding team Player, strong work ethics, enthusiastic, quick learner with positive attitudes with the ability to handle multiple tasks or projects working independently or in a team.

PROFESSIONAL EXPERIENCE

Confidential

Senior Database Engineer/Power BI Developer

Responsibilities:

• Involved in installations, upgrades and configuration of MS SQL Server and databases in clustered and non-clustered environments.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases and data mart databases.
• Upgraded oracle databases from 11.2.3 to 12.1.0.1 & 12.1.0.1 to 12.2.0.1
• Worked on Redshift database on AWS government cloud for research and testing on migrating our databases to the cloud.
• Design, build and deploy multidimensional and tabular cubes using SSAS
• Generate periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Involve in designing and publishing visually rich and intuitive Power BI dashboards.
• Manage security, assign permission, roles.
• Hand on experience in writing calculated columns and measures using DAX Formula Language.
• Import data from multiple data sources into BI Tools, Knowledge in making use of Data sources: Analysis server, Data Lake, Azure SQL, CosmosDB.
• Transform and combine the data using Query Editor in the Power BI.
• Server & Application fine-tuning & trouble shooting, Monitoring MS SQL Server performance and windows server issues.
• Good understanding of data marts, data ware housing, ODS, OLAP, Star schema modeling, snow flake modeling,Fact and dimensions tables using MS Analysis services.
• Worked on custom visualilzations like multi slicer and Hierarchy slicer.
• Worked on DAX expression like filter, aggregate, Mathematical functions etc
• Created New Calculated column and Measure using DAX expression
• Worked on the power bi reports & dashboards with sql server/Tabular ssas sources
• Used table, matrix, bar, card, Gauge, Slicers visualizations
• Implemented copy activity, custom azure data factory pipeline activities
• Create data integration and technical solutions for azure data lake analytics, Azure data lake
• Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat files, CSV files into SQL Server 2012.
• Creating maintenance plan for consistency checks, maintaining indexes and statistics, performing fine Tuning of Database Application. Cleansing and solving Database troubles.
• Migrated SQL databases to amazon-RDS and azure environments.
• Implemented AWS solutions using E2C, S3, RDS, EBS, Elastic Load Balancer, Auto scaling groups, Optimized volumes and EC2 instances.
• Reduced performance issues on physical servers and implemented Auto provisioning, de-provisioning on AWS Cloud Instances.
• Configured and maintaining the COSMOS databases in azure environment.
• Written data analysis queries using kusto query language
• Performance tuning, and optimization of procedures and queries.
• Worked with SQL server Profiler generated traces to optimize the performance of the database.
• Setup the replication monitoring which helped the QA load team to complete the task in time.
• Expert in using Third Party tools like IGNITE, SQL Diagnostic Manager for monitoring and improving overall SQL Server health.
• Migrated SSIS packages to snowflake using alooma
• Participated in all database deployments and solved all the critical issues during deployments which prevented the extended downtime of the sites.
• Installing Monthly Security Patches and Scheduling Regular Maintenance to ensure the health and security on the servers.
• Automated the daily routine tasks using Power Shell
• Provided 24 X 7 dedicated production DB’s support.

Confidential, Redmond, WA

SQL Server DBA/BI

Responsibilities:

• Expertise in installation, upgrade and configuration of MS SQL Server and databases in clustered, cross domain, inter-data center and non-clustered environments.
• Develop reports like Parameterized, Drill Down, Drill Through, Tabular, Cascading reports by using SSRS.
• Used scripts and variables, email notifications for ETL process using Data Integrator.
• Worked on the Power Bi reports & dashboards with SQL Server/Tabular SSAS sources
• Used Table, Matrix, Bar, Card, Gauge, Slicers visualizations.
• Wrote complex SQL queries involving multiple tables from different databases using Joins, Stored Procedures, Temporary tables, functions.
• Installed SQL Server 2014/2012 and Configured Always ON for most of our DB Servers.
• Configured Multi-subnet and Multiple Listeners for High Availability and Disaster recovery purpose, as part of Multi-subnet Cluster configured 4 nodes from different datacenters.
• Upgraded servers from SQL Server 2008 R2 to SQL Server 2012/2014
• Migrated databases to SQL Azure which was the cloud platform to keep a copy of our database secure on the cloud.
• Experience in Installing, Maintaining & Managing Windows 2008R2/2012R2 Clustering - SQL 2014/2012 Clustering (A/A, A/P, A/A/P)
• Manage Production, PPE, Staging and DEV Environments totaling more than 150 servers with around 1000 databases ranging from 10GB to 1TB
• Automated the daily routine tasks using Power Shell scripts and job lets.
• Upgraded Denali on the existing tap servers
• 24 x 7 Production Database on Call Support.
• Created patching, operational support and TSG documents for lower tier offshore support.
• Monthly Dev-DBA reviews on Code, Best Practice including Security, Performance and Optimization.
• Monitoring all the ICP Server production databases and fixing the production issues.
• Monitoring all the backend Mirrored SQL servers which support the Confidential .com sites.
• Working on Diagnosing and mitigate platform faults which results in the service disruption of cloud platform
• Responsible for Installing Monthly Security Patches and Scheduling Regular Maintenance to ensure the health and security on the servers.

Confidential, Mount Lake Terrace, WA

SQL Server DBA

Responsibilities:

• Install and configured MS SQL server 2005 and 2008.
• Upgrade/Migration of MS SQL Server 2000 to MS SQL Server 2008.
• Created the disk space forecast reports for 80 production servers.
• Expert in using Third Party backup solutions for MS SQL Server like SQL Litespeed.
• Performed Migration of Databases from one physical server to another when the size of the database increased and business needs changed.
• Involved in creating data load process using SSIS packages and providing suggestions of using best RAID Technologies based on application requirement.
• Installed IIS 6.0 on the webservers and deployed the internal websites.

Confidential, Redmond, WA

SQL Server DBA

Responsibilities:

• Involved in installations, upgrades and configuration of MS SQL Server and databases in clustered and non-clustered environments. Achieving Performance tuning using various SQL Server Commands and DTA (Database Tuning Advisor).
• Involved in Creating and managing databases that includes setting up new roles and user permissions.
• Database Mirroring, Migration and Upgrading during new releases besides configuring applications and web servers and Cluster SQL Server in Active/Passive nodes.
• Involved in using Third Party backup solutions for MS SQL Server like SQL Litespeed and worked on SQL Server Reporting Services (SSRS) to provide trend analysis of the application behavior that is scheduled on hourly, daily and weekly basis.
• Responsible for driving the Bug triage meeting, follow up with all the teams to get the issues resolved ASAP, actively driving the daily Scrum meeting in the absence of scrum master.
• Much involved in ETL workflow automations and performs data quality assurance using Fuzzy lookups.