Experience

DK Consulting, LLC

• United States
• IT Services and IT Consulting
• 1 - 100 Employee

• SQL Database Administrator / Data Analyst

  • Jan 2016 - Present

  Designing, developing, testing, server monitoring, Performance tuning, backups/restores, configuration, creating tables, indexes, stored procedures, maintenance, implementing security, data replication, query optimization, data migration and scheduling jobs/tasks. Designing reports based on business requirements while using SSRS, designing ETL loads to load data into the reporting database using SSIS, creating stored procedures, Working on Power BI and SSAS. Extensive Excel work using pivot tables, work on SPSS, Business need analysis, HA/DR planning and implementation. • Performance tuning and optimization using Perfmon, DMV/DMFs, SQL Server profiler trace, and database engine tuning advisor. • Creating tables, indexes, stored procedures and optimized poorly performing stored procedures, views and ad-hoc queries. • Installation, configuration, upgrade, patching, and management of SQL Servers 2017, 2016, 2014, 2012, 2008/R2. • Working on Storage area network (SAN) which is helpful in backup and disaster recovery settings. • Configuration and management of HA/DR solutions such as Always On-AG, Failover Clustering, Database Mirroring, Log-Shipping, and Transactional Replication. • Working on Power BI and SSRS. • Creating reports using Visual Studio and deploying it to SSRS • Designing and tuning highly available and high-volume transactional databases. • MS Azure SQL DB • Working on Red-Gate to monitor SQL Server and database performance, • Ensuring SQL Server Security by creating user logins, assigning roles and least-privilege permissions, certificate-based security authentication. • Business need analysis, data source identification and analysis and data modeling • Extensive Excel work using pivot tables and complex formulas to manipulate large data structures. • Microsoft Office Suite (Word, Access, Outlook, and PowerPoint) Show less



Capital One

• United States
• Financial Services
• 700 & Above Employee

• SQL Database Administrator /Data Analyst

  • Nov 2013 - Dec 2015

  • Performing database reorganization, extent (space) management and rebuilding indexes based on evaluation. • Working on solar winds to monitor SQL Server and database performance, • Maintaining database artifacts, integrity, and security of databases. • Database migrations and SQL Server upgrades. • Implementing robust server and database level security as well as encryption solutions • Performance tuning and optimization • Working on AWS • Proactively identifying and fixing potential issues. • Configured server and database level audits for mission-critical databases. • Extensively participated with database developers in database design and development. • Developed stored procedures, functions, views and ad-hoc T-SQL queries. • Applied Service Packs to different versions of SQL servers. • On-demand refreshed lower environments with production databases. • Designing reports based on business requirements while using SSRS, designing ETL loads to load data into the reporting database using SSIS, and creating stored procedures and functions required to extract data for the load. Working on Power BI and SSAS. • Routinely monitored and troubleshot performance issues using SQL Server Diagnostic Manger. • Administered SQL Server 2000, 2008R2, 2012 hosted by Windows 2003/2008R2/2012. • Managed an HA/DR environment including Always On-AG, failover clustering, Mirroring, and log-shipping. • Successfully migrated SQL Server 2000 databases to SQL Server 2012. • Developed a detailed Disaster Recovery strategy for critical databases. • Extensively performed performance tuning using SQL Server profiler, DMV/DMFs, query execution plan, perfmon and database engine tuning advisor. • Configured Database-Mail for alert system. • Extensive Excel work and Business need analysis, • Microsoft Office Suite (Word, Access, Outlook, and PowerPoint) and worked on SPSS. Show less