Sql Server Power Bi

Location:

Addison, TX

Salary:

90000

Posted:

July 24, 2024

Contact this candidate

Resume:

Vijay Kiran Koonala

Cloud DBA, Tableau/Power BI Developer & Admin

+1-214-***-**** ***********@*****.*** linkedin

PROFESSIONAL SUMMARY

Over 16 years of professional experience in MS SQL Server Database Administration,Oracle, Postgresql, Mysql, AWS EC2, AWS RDS, AWS Aurora, Azure SQL, Snowflake, Tableau, Power BI Developer and Admin.

Database Administration:

Experience in MS SQL/Oracle/Postgresql/Mysql/AWS Aurora/AWS RDS/AWS EC2/ Azure SQL Server database administration activities such as Installation, Configuration, Backup & Recovery, Database Security, Performance Tuning, and Query Optimization.

Experience in Cloud AWS/Azure and Migrating from On Prem to AWS/Azure IAAS and PAAS Servers.

Expertise in powershell scripting and DBA Tools.

Configured, maintained, supported Attunity(Qlik) Replication from/to multiple RDBMS from/to Cloud

Setup new Snowflake data warehouses and onboard tenants

Assisting with projects to migrate customer on-premises hosted databases into Snowflake

Manage the Snowflake platform across multiple environments (Development, Test, Stage, Production)

Perform Snowflake account management (create users, delete users, manage permissions)

Create and manage views in Snowflake as defined by the customer

Administering SQL Server High Availability and Disaster Recovery strategies. Hands-on troubleshooting and resolution experience with Always on Availability Groups.

Performed End-to-End SQL Server Administrative tasks ranging from installing and configuring servers to set up and administering Always On Availability Group, Cluster, Replication, and Log shipping.

Strong analytical and troubleshooting skills to identify and resolve database issues, diagnose performance problems, and prevent downtime.

For SSRS – Configure and generate reports through scheduled jobs, troubleshoot reporting and disk, permission.

Installation of SSAS for BI analysis.

Experience in ETL process using SQL Server native to load data between different databases and data warehouses.

Scheduling application jobs in ETL for Data extract from different databases.

Expert in automating processes by creating and maintaining Jobs, Alerts, and Error reporting using T-SQL and CmdExec through Maintenance plans, SQL Server Agent, SQL Mail Agent, and Creating Alerts.

Experience in SQL Server Security from the creation of logins-users, configuring permissions, and assigning roles to users. And securing data with TDE, Always Encryption, Row-level security, and Dynamic Data Masking to secure PI and PII data.

Expert in SQL Server performance tuning and query optimization through monitoring and using Execution Plan, Extended Events, SQL Profiler, PerfMon and DMVs

Experience in third-party tools SolarWinds, IBM Tivoli storage manager, Snapshot, Light speed.

Excellent Analytical and problem-solving skills. Self-motivated, quick learner, and determined to learn new technologies.

Strong troubleshooting skills and good team player with excellent interpersonal and teamwork skills. Also good at writing documentation.

Always compliance with Audit and Security standards.

Worked in various IT Service Management frameworks, specifically ITIL as a Service Management Service Lifecycle like Change Management, Request Management, Incident Management, Problem Management, and Event Management.

Experience in providing 24x7 Production Support.

Ability to execute in a remote work environment

Experience in implementing Disaster Recovery for minimal downtime using different types of database backups, restore, and replication.

Installed and configured Rubrik backup clients across multiple servers/domains, ensuring seamless integration with existing infrastructure.

Managed Rubrik backup policies and schedules, achieving 99% backup success rate and reducing recovery time objectives (RTOs).

Conducted regular disaster recovery tests, ensuring readiness and compliance with business continuity requirements using Rubrik.

Diagnose and resolve technical issues related to Rubrik appliances, backup jobs, and integrations.

Configured and Scheduled Daily, Weekly, Monthly Rubrik Backup reports at enterprise level.

Experience working in an agile environment, coordinating across multiple teams

Tableau/Power BI Developer/Admin:

Proficient in creating multiple kinds of data visualization dashboards and Story points/Story Telling using Tableau/Power BI/ MicroStrategy/MSTR./SSRS.

Skilled in creating and developing BI Dashboards into rich look for better understanding.

Implemented row level security for the tableau dashboards and used various advanced table calculations for the dashboards.

Manage Tableau User Access and Report Permissions.

Interact with business users and understand their business requirements.

Analyze data using Tableau to develop and automate reports that leads to actionable business decisions and insights.

Experience in building Groups, hierarchies, sets to create detail level summary reports and dashboard using KPI’s.

Experienced Data Analyst built, developed, and published customized interactive reports, Story Telling, dashboards and reports with complex objects in Tableau.

Improved Reports performance in Tableau using LOD expressions and context filters.

Experienced in advanced visualization widgets in Tableau including Heat maps, Maps, Gantt, Scatter Plots, Bullet Graphs, and Packed Bubbles.

Strong understanding of advanced Tableau features including calculated fields, parameters, table calculations, joins, data blending, and dashboard actions.

Experience in working on generating various dashboards to Tableau server different data sources

Created sets and used them in the calculated fields to retrieve the specific data by combining multiple sets and visualize the data.

Created cascading filters to filter the data within the hierarchy and prompt to specific filter that is applied by cascading.

Involved in migrating reports from Adobe work space to Tableau

Strong problem-solving ability to clearly understand business problems, identify underlying critical underlying issues, Present clear Ideas and solutions to senior management and intellectually articulate solutions in working in different project methodologies - Waterfall, and iterative Scrum/Agile environment.

Certification:

Microsoft Certified: Azure Database Administrator Associate

Microsoft Certified Technology Specialist

Oracle PL/SQL Developer Certified Associate

ITIL® v3 Foundation

Education:

Bachelor of Technology, April 2004 from Jawaharlal Nehru Technological University, Hyderabad, India

Technical Skills:

Databases: MS SQL Server, Postgresql, Mysql, AWS Aurora, AWS EC2, RDS, Azure SQL

Datawarehouse: Snowflake, AWS Athena, BigQuery

Data Visualization: Tableau, Power BI, MicroStrateg/MSTR

Reporting Tools: SSRS, MS Excel

Languages: SQL, T-SQL, Visual Basic, PowerShell, PSQL

Other Tools: ServiceNow, Remedy, SCOM, SolarWinds, MS Visual studio, HPSM, Service now, SM9, Idera DM, Control M, Nezumi, Cyber Ark, Maximo, Jira, DBA Tools

Backup tools: IBM Tivoli storage manager, Snapshot, Light speed, Pure Storage, Rubrik, Commvault.

Operating Systems: Windows Server 2008, 2008R2, 2012, 2012R2, 2016,

Professional Experience:

Client: Appstekcorp, Dallas, Texas Apr 2024 – Till Date

Title: DBA II

Environment: Tableau Desktop, Tableau Online, Power BI, SQL Server, AWS Athena, BigQuery, Snowflake

Responsibilities:

Working on SQL server 2008R2/ 2012/ 2014/ 2016/2019/2022, Oracle, Postgresql 13 and Mysql 8, Azure SQL, AWS Aurora, AWS EC2, AWS RDS designing/ administration support.

Provide Subject Matter expert on database management for Business application.

Performing enterprise level migrations to SQL Server versions 2014/2016/2019

Designed and implemented enterprise-wide database solutions on-premises and utilizing SQL instances on AWS/Azure cloud computing technologies.

Configure, maintain, and troubleshoot AlwaysOn Availability Groups as part of High Availability.

Implement and monitor replication for high availability and disaster recovery scenarios.

Configure Log shipping, Database mirroring as per the application requirements and troubleshooting the issues related to it.

Responsible for maintaining the organization's databases, monitoring database performance, identifying, and resolving issues, and implementing upgrades and patches.

Plan and implement database backup and recovery procedures to ensure data availability in case of disasters or failures.

Installing Microsoft SSIS, SSAS and SSRS as per the application requirements.

Creating packages through SSIS for the DBA jobs and deploying packages through SQL agent jobs.

Configuring SSRS for reporting and SSAS for applications team.

Work with development and operations to tune production queries for optimal performance.

Create and maintain documentation related to database architecture, procedures, and policies.

Participate in SQL code reviews and provide guidance on best practices.

Monitor and manage database indexes and partitioning for optimal performance.

Perform schema management, database sizing, and maintain privileges.

Monitor SQL Server databases using custom built monitoring tools and Idera Diagnostic Management Tool.

Ensure the availability, reliability, and performance of all databases as per SLA’s and ensure security control and compliance in place.

Work on day-to-day activities, Monitoring of Incidents, Tasks and resolving as per SLA in Service Now.

Scheduling application jobs in ETL for Data extract from different databases.

Working on ETL processes using SQL Server native to load data between different databases and data warehouses.

Participate in Change Advisory Boarding meetings for representing change requests and getting approvals.

Planning and Implementing In-place and side-by-side upgrades for MSSQL.

Perform regular database maintenance tasks such as applying patches, updates, and tuning database configuration.

Support and maintain SSIS packages, SSRS reports, and SQL Server Agent jobs.

Troubleshoot and resolve database integrity, performance tuning, connectivity, security, blocking, and deadlocking issues.

Managing, Coordinating, Planning, and executing the migration/upgrade project, for MSSQL.

Provide Data integration solution with Cloud from On-premises through database conversion and migration activities.

Providing 24x7 support in Production and PRE-PROD environments.

Installed and configured Rubrik backup clients across multiple servers/domains, ensuring seamless integration with existing infrastructure.

Managed Rubrik backup policies and schedules, achieving 99% backup success rate and reducing recovery time objectives (RTOs).

Conducted regular disaster recovery tests, ensuring readiness and compliance with business continuity requirements using Rubrik.

Diagnose and resolve technical issues related to Rubrik appliances, backup jobs, and integrations.

Configured and Scheduled Daily, Weekly, Monthly Rubrik Backup reports at enterprise level.

Designing and developing Company daily, weekly, monthly sales, revenue category dashboards and validating by coordinating with different cross functional teams.

Built Complex reports using advanced reporting functions like YTD calculations, MTD calculations and percentage differences in tableau.

Built YOY Dashboards for better comparison.

Building Dashboards by using AWS Athena and Snowflake data sources.

Developed complex Map Dashboards

Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.

Supported the development and modification of Tableau views in Tableau Desktop, while preparing documentation and training users from respective departments.

Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to created summary level and detailed Reports.

Client: Fanatics.com Sep 2018 – Apr 2024

Title: Staff DBA

Environment: SQL Server, Postgres, Mysql, Tableau Desktop, Tableau Online, Power BI, AWS Athena, BigQuery, Snowflake

Responsibilities:

Working on SQL server 2008R2/ 2012/ 2014/ 2016/2019/2022, Oracle, Postgresql 13 and Mysql 8, Azure SQL, AWS Aurora, AWS EC2, AWS RDS designing/ administration support.

Maintain all development, QA, staging and production SQL Server databases within organization.