We provide IT Staff Augmentation Services!

Ms Azure Sql Database Architect Resume

MinneapoliS

SUMMARY:

  • 11+ years of experience in Database Development, Administration and Architect for very large scale databases in SQL Server 2017/2016/2014/2012 , SQL Server 2008 R2, 2008 and 2000
  • 8+ years of experience in overseeing the development and organization of the databases, assessment and implementation of new technologies
  • 8+ years of experience in performance tuning, query optimization using SQL Profiler as well as Index and statistics maintenance
  • 6+ years of experience in creating ERD, designing Logical and Physical modeling for OLTP and Data Warehouse (star and snowflakes schemas) using ER Data Architect tool from Idera
  • 6+ years of experience in SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS)
  • 5+ years of experience with BI tools like Power BI, Sisense and SSRS
  • Experience in migration of on - premises SQL Server 2012 to Azure SQL Database (PaaS) on cloud
  • Experience in Azure SQL configuration for the database and automation of tuning, vulnerability Assessment, Auditing and Threat Detection
  • Strong experience in implementation of Clustering, Database Mirroring in SQL Server 2014
  • Extensive experience in using T-SQL in SQL Server /2005/2000 platforms
  • Expertise in creating data structure, integrating relationships, normalization and De-normalization
  • Excellent knowledge in RDBMS concepts and experience in constructing Database Objects creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers, User profiles, SQL joins
  • Experience in upgrading from DTS to SSIS packages, resolving complex issues and Error Handling in SSIS
  • Expert in Extraction, Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Flat File sources and load into various Business Entities and deployment of the SSIS packages
  • Experience to determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes
  • Experience in creating plan and migrating SQL Server , SQL 2008R2 to SQL 2012 using side-by-side and in-place approach in virtual machine
  • Proficient in using different version source control such as Git, TFS, Subversion
  • Hands on experience in Service, Incident and Change Management processes
  • Experience in Agile/Scrum Methodology
  • Experience as onsite lead and handling offshore team members
  • Experience in VMware virtualization in creating VMs on VMware Workstation

TECHNICAL SKILLS:

DBMS: Azure SQL Database, MS SQL Server 2017/20162014/2012/2008/2000 TOAD for Oracle, MS Access 2010/2007, Red Gate

Performance Monitor Tools: Idera SQL Diagnostic, SQL Server Profiler, Red-Gate SQL Monitor

Programing Languages: T-SQL, PL/SQL, Visual Studio 2010, Visual Basic 6.0, C#, C++, C, XML, HTML, VBScript, JavaScript, ASP, CSS

Deployment Tool: SQL Compare, SQL Data Compare

Data Modeling Tools: ER Data Architect, MS Visio 2010/2007, Erwin

BI Tools: Power BI. Sisense, SSIS, SSRS, SSAS

IDE: Visual Studio 2017/2015/2013

Version Control: Git, TFS (Team Foundation Server), MS Visual SourceSafe, SVN

Operating Systems: Windows Azure, Windows Server 2012/2008R2, Windows 8/7/2003/2000/ XP

Package: MS Office 2013/2010/2007

Network Security Tool: Tufin

NPC Tool: Riverbed Steelcentral Netshark

PROFESSIONAL EXPERIENCE:

MS Azure SQL Database Architect

Confidential, Minneapolis

Responsibilities:

  • Worked on the revamping the existing architecture and implemented the new architecture on Azure SQL
  • Experience in evaluation of on-premises SQL database to Azure SQL to reduce the license cost
  • Saved ~$2000 yearly by moving to Azure SQL database while achieving most robust, scalable, highly secured and encrypted database
  • Assessed the existing database by running DMA and removing the migration blocking issue, cross-platform database issues to get maximum performance improvement
  • Ran the Database Migration Assistant to upgrade the existing SQL Server to Azure SQL Database
  • Configured the Azure SQL Server and created the databases
  • Setup the firewall to restrict the IP addresses to connect Azure SQL database
  • Setup the service tier in each environment based on the usage and activities. The DTU is setup to give maximum throughput while accessing database from the web application through VPN
  • Created the Logical and Physical Modeling using Idera ER Data Architecture tool
  • Implemented the owner, database contributor, database reader permissions to access Azure Web Portal to developers, DBAs and system admins
  • Production Database was set up to monitor all the activities through SSIS, stored procedures via application
  • Setup the Automatic Tuning on production database to create index based on inheritance from Azure SQL. The improvement increases sharply to show the result in few milliseconds
  • Created very complex stored proc to paginate the results into web app and shows the results for different reps located in different regions
  • The SSIS packages were implemented to use in a SQL Agent Job using on-premises SQL Server and connect to Azure SQL database using encrypted connection
  • Run the Vulnerability assessment report to investigate, manage and resolved security issues
  • Implemented the automation script to maintain indexes and statistics
  • Run Query Performance Insight to have deeper insight in DTU consumption, top queries by CPU, Duration or Execution count to tune the query for improved performance
  • Developed Power BI model used for life term policies, Annuities for different regions
  • Created Workspace and content packs for business users to view the developed reports
  • Scheduled Automatic refresh and scheduling refresh in power bi service
  • Wrote calculated columns, Measures query’s in power bi desktop to show good data analysis techniques
  • Worked in Agile environment suing VSTS

Environment: Azure SQL Database, Azure Monitor, MS SQL Server 2017, Visual Studio 2017, Git, Visual Studio Team Services, Power BI, ER Data Architect

Sr. Infrastructure Data warehouse and BI Lead

Confidential, Minneapolis

Responsibilities:

  • Worked with Product Owner to define with priorities of business critical and major projects
  • Worked with developers to maintain the Infrastructure Data warehouse for Migration Events
  • Monitoring of different sources like DNS, NetShark and Reverse lookup data to create the facts
  • Worked with Security team to process the scan files throughout the network, performed analysis on data from Tripwire and generate vulnerability reports from data warehouse
  • Created very complex stored procedures to generate the SSRS reports
  • Used DirectQuery in Power BI to get the raw data in dataset and generate the visualization of firewall rules, associated ports and networks traffic
  • Monitor Red Gate tools for the developers code check-in to maintain the audit trails of the project
  • Performed the Optimizations of stored procedures, views by adding more indexing into the underlying tables to generate the complex reports
  • Created stored procedures and performed index analysis for slow performing SSRS reports to bring down the report rendering time from 15 mins to 30 seconds
  • Configured SQL Server Reporting Services 2014 for Dashboard reports
  • Worked with CISO and team to process the Firewall Rules across the network created from Tufin
  • Processed the firewall object references into data warehouse using complex stored procedures
  • Embedded Power BI reports on Sharepoint site and also managed access of reports using Roles
  • Generated the Traffic analysis report for the Firewall Rules based on port and protocol usage
  • Configured the Power BI to access the dimension tables for Firewall Rules Analysis
  • Generated the dashboard reports into Power BI to see the number of hits for a particular firewall rules
  • Created KPI for highest port usage across firewall rule based on the traffic hits
  • Configured Network Navigator visualization for source and destination object references of firewall rules

Environment: MS SQL Server 2014, SSDT, TFS, SVN, Red Gate, MS Visual Studio 2013, Power BI, Tufin, Riverbed, Tripwire Security Intelligence Hub (SIH)

Tech Lead - SQL Server/ETL Developer

Confidential, Minneapolis

Responsibilities:

  • Monitor Kanban/Sprint boards for faster and efficient development of user stories to meet release dates
  • Experience providing training to development teams on how to track, plan and analyze using JIRA
  • Worked with Client Service BA and Tech BAs for requirements gathering and business analysis.
  • Worked with Product Owner to define the dev workflow in Kanban board to meet the client’s timeline
  • Created Data Mapping document to map the fields between client data and data design to be implemented in the SQL Server database for ETL process
  • Worked with CS/Tech BA to understand the Data Validation and Data Cleansing Requirements from Client
  • Involved in Design, analysis, Implementation, Testing and support of ETL processes for Dev, Stage, Test and Prod Servers
  • Assisted in the decision making and development of the data conversion strategies for different projects
  • Designed Star Schema and Snow flaked schemas in the process of data modeling
  • Processed data from flat files and excel files to database tables using in-build task factories of SSIS
  • Created SSIS project to process excel files, perform file validations using C# script tasks, transform data using data validation and cleansing logic and loaded into database tables.
  • Created dynamic and complex stored procedures to generate XML output, Merge multiple XMLs using XML task and write data into XML file using LINQ operation
  • Worked with 4 team members to lead the development of internal sites and ETL projects
  • Provided inputs to developers to write efficient and high-performance stored procedure, SSIS packages
  • Created SSIS Packages to extract data from Excel Files, using Process task, Script task (LINQ, SQL OLEDB connections, Excel connections) in C#, Execute SQL Task, Data Flow Task, Derived Columns, Data Conversion, Script Component to load data into database tables using Visual Studio 2013 and Transform into CSV files
  • Created SSIS package using Third Party tool to load Salesforce data
  • Worked closely with the SQL Server database team to define data requirements to support the applications
  • Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder
  • Utilized SSRS to create very rich reports (Tabular/Graphical) from Database tables with rich data visualization (Charts, Data Bars)
  • Created ElastiCube to get raw data from the SQL Server DB tables
  • Created additional modeling in ElastiCube Manager
  • Created Indicator, Pie Chart, Bar chart, and Scatter map to show different widgets on Sisense dashboard
  • Administered the Users and Groups to provide access to different dashboards on Sisense web portal
  • Used “CONSOLIDATED JUMP TO DASHBOARD PLUGIN” for Drill To dashboard
  • Assisted Scrum Master in preparing the Sprint backlog.
  • Participate in daily stand-up meetings, Bi-Weekly Sprint Planning and Sprint Retro meetings

Environment: MS SQL Server 2014, SSDT, TFS, MS Visual Studio 2013, Altova XMLSpy, Issue and Project Tracking software, SSRS

Technical Lead/Sr. SQL Server Developer

Confidential, Minneapolis

Responsibilities:

  • Responsible for provide production support to all 16 Production, test and development servers
  • Lead the Database Production Support for Point-of-Sale (POS) machines, Order Management, Customer Service and Inquiry Management applications
  • Used Erwin Data Modeler to create database designs
  • Created SSIS package for Zip Code process in which various sources (Excel, Text) have been used as input data, process validations and load the data into database tables
  • Scripting the Database Consistency Checks (DBCC), scheduling the scripts to run daily and weekly basis
  • Provided support for High Availability on the various servers using Log Shipping/Mirroring
  • Reviewing programming code and identifying possible data conversions problems
  • Created and Updated SSIS packages to run executed the stored procedures using OLEDB and Oracle Connections and push the data from SQL to Oracle
  • Created stored procedures to generate output in XML format
  • Created Complex queries to process Financial Amendment of 14,000 customers for processing refund checks due to variance in Tax calculations for a specific state
  • Loaded the data from SQL Server to Siebel using SSIS
  • Created various Drill-through and Drill-down reports using SSRS
  • Responsible to provide approval of any database object changes for production push
  • Created new stored procedures, views, indexes, tables and UDFs
  • Wrote PL/SQL queries to get the data results from Oracle base tables using TOAD for Oracle tool
  • Provide production support through ticketing system, BMC Service Desk Express
  • Use Elementool to create RFC (Request For Change) to push data fix, small enhancements into production
  • Lead Production outages due to patching in SQL Server updates and service packs updates
  • Lead the team of 4 members including onsite and offshore, including weekly meetings for status updates
  • Technical Analysis, Code Review, Implementation, production support

Environment: MS SQL Server 2012 R2/2008 R2, SQL Server BIDS, TOAD, Elementool, Visual SourceSafe, BMC Service Desk Express, VMWare

Sr. SSIS/BI Developer

Confidential, New York

Responsibilities:

  • Created a new database structure to define code for client and communication types
  • Defined domain integrity, referential integrity between database tables
  • Created a stored procedures create a unique campaign code and get campaign codes list based on the selection of client name, campaign type and campaign start date and based on the selection of client name, campaign type and campaign start date and variation
  • Created a SSIS package to find out unused campaign codes created by user and not used in communications
  • Created a job in SQL Server Agent to send an automated email using Database Mail for unused campaign codes notifies user to take an action
  • Created SSIS projects to convert DTS packages from SQL Server 2000 to SQL Server 2008
  • Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task
  • Created and maintained ElastiCube in ElastiCube Manager
  • Created and modified column chart, Indicator and Pie widgets and used formula to generate dashboards for managers
  • Managed User Groups and Dashboard users to access SiSense dashboards
  • Managed day-to-day SQL Server operations in SQL Servers 2008R2/2008/2005
  • Designed and implemented Disaster Recovery Procedures like Log Shipping, Replication
  • Conducted Root Cause Analysis of application availability related to coding practices, database bottlenecks, or network latency
  • System performance using System Monitor, SQL Profiler, and DBCC utilities
  • Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases
  • Involved in physical setup of Local Cloud Appliance (LCA) that provides dependable business continuity to recover data locally with no failover to remote site
  • Configured Recovery Time Objective (RTO) and Recovery Point Objective (RPO) of business critical servers such as DC, File Server, Database Server to minimize the downtime and data loss
  • Successfully setup and configured the LCA at DR location during Hurricane Sandy to continue providing services to our clients
  • Performed successful testing by spinning up DC, File Server and Database Server, Activating servers and logged into each server on LCA and Remote Cloud
  • Set thresholds and monitor the Console Dashboard for any missing snapshots
  • Designed, Implemented and maintained Database Schema, Entity relationship diagrams, Data modeling, Tables, Functions and Triggers, Indexes, Functions, Views, complex SQL statements
  • Optimized the performance of queries with modifications in T-SQL queries, Normalized Tables, established Joins and created Indexes whenever necessary
  • Created complex stored procedures to generate communication calls reports using SSRS
  • Configured SQL Mail agent for sending automated alerts/emails
  • Created a new database, designed schema for each type of tools
  • Used linked server to perform distributed queries, joined with local server DB to update database records
  • Used Visual Source Safe to keep track of all modifications and enhancements for the tools
  • Exclusively supported for the application deployment on IIS server

Environment: SQL Server 2008, SQL Server Agent, Visual Basic 6, MS Access, VBScript, JavaScript, HTML, IIS 6.0, ASP, Visual SourceSafe, MS Visio

SQL Server Developer

Confidential, New York

Responsibilities:

  • Maintained and enhanced websites designed in ASP and HTML
  • Created technical documentation of database applications including data structures and SQL stored procedures
  • Performed bulk data migration using DTS from flat text files
  • Created database tables for conversion of excel headers to load data
  • Performed SQL Server administrative tasks of maintaining access permissions and privileges
  • Created ad hoc SQL queries, Stored Procedures and Functions
  • Designed relational databases in SQL Server 2000

Environment: ASP, HTML, VB6, SQL Server 2000, MS Access, MS Visio

Hire Now