SQL Server Developer/Data Analyst/DBA (SQL/TSQL/SSAS/SSIS/SSRS/MySQL/AWS/Azure) with 6+ Years of experience in MS SQL SERVER 2017/2014/2012, 2008R2/2008 Database Administration in Production, Test and Development environment. * Experience in Analysis, Design, Development, Testing and Maintenance, Capacity Planning, Performance support of application systems of OLTP and OLAP databases in the client-server, internet\intranet environments. * Experience in Installing, Upgrading and Migrating databases in and from SQL Server 2014/2012/2008R2/2008/2005, SQL and PL/SQL. * Experience working with Bit Bucket, Git Hub, Jenkins, Docker, Kubernetes, Azure, AWS, Cognos, Tableau and Spot Fire. * Expert in Creating, Configuring and Fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS). * Designing applications including data mapping, data integration jobs, database design, data architecture, implementation of business rules, calculations (stored procedures) * Experience in implementing Data warehouse solutions in Amazon Redshift, worked on project to migrate data from on premise databases to Amazon Redshift, RDS and S3. * Optimizing and tuning the Redshift environment, enabling queries to perform up to 100x faster for Tableau. * Implemented Work Load Management (WML) in Redshift to prioritize basic dashboard queries over more complex longer-running queries * Worked with ETL team to setup AWS GLUE Pipeline to configure data loads from S3 to into Redshift * Very good T-SQL Programming skills. Experience in query optimization and performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands. * Expert in tuning the long running Queries and Store Procedures by examining the execution plans. * Developed ETL process using SSIS with various control flow, data flow tasks and store procedures for work order validation process. * Expertise in using Performance Monitor/Profiler /Activity Monitor to resolve Dead Locks, Long Running Queries and Bottlenecks caused by complex Queries. * Expert in migrating the DTS Packages to SSIS Packages by using Package Migration Wizard. * Data Modeling Experience including Physical and Logical data modeling using Erwin tool * Extensively used repositories like Team Foundation Server (TFS), and Visual Source Safe. * Expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning. * Worked Extensively on ETL process using SSIS packages * Experience in database development, for creating complex database queries, Indexes, Views, Stored Procedures and Triggers in SQL Server. * Experience working with process data files, FTPing, data load and analysis of raw data * In-depth knowledge of Amazon cloud Web Services, EC2, S3, RDS, SQS, SNS. * In-depth knowledge of fundamental and Advance concepts for Working with Amazon EBS, ELB, Cloud front, AWS IAM, Amazon VPC. * Experience with Microsoft Azure cloud computing service for building, testing, deploying, and managing applications and services through a global network of managed data centers, Azure SQL Database Migration and migration to Azure VM. * Familiar with all the services (SaaS), (PaaS), (IaaS), tools and frameworks, including both Microsoft-specific and familiar with VM, Azure SQL DB, Storage account and Networking.
Description
