Sql Server Dba

Ranga Rao Akkinapalli

Phone: 203-***-**** Email: ad5vnu@r.postjobfree.com

Profile:

Experienced SQL Server Administrator/Developer with over 37 years in IT, specializing in SQL Server DBA, EPIC Cogito Admin, DW/BI initiatives for the last 20 years. Skilled in managing over 200 SQL Servers, ensuring database integrity, and setting up Always On over 3 node failover clusters for HA/DR. Adept at troubleshooting, performance optimization, and overseeing daily ETL maintenance for large-scale Clarity and Caboodle databases. Proficient in using SSIS, Informatica for ETL, SSRS/SSAS, Power BI for report deployment, and effectively translating business needs into technical designs. Skilled at leading teams to deliver comprehensive solutions and providing technical guidance for complex business initiatives.

Employment History:

SQL Server Admin / Clarity/Caboodle (Cogito) Admin - Guthrie, Sayre, PA

September 2021 – Current

Manage over 200 SQL Servers, on-prem and Azure, supporting internal and external applications.

Ensure database integrity, index management, backups, recovery, capacity planning, security.

Monitor server performance, troubleshooting issues, and optimize as needed.

Ensure all the servers have the latest patches OS and SQL within a couple of weeks of release.

Setup Always On over a 3 node failover clusters in 2 geographical locations to provide HA and DR. I setup a 2016, 2017 and 2019 cluster to applications. Consolidated 50 application / servers were consolidates to the clusters.

Setup custom imports/exports from vendors. Utilize SSIS, Powershell, batch jobs and sqlcmd to automate

Setup SQL Server reporting services and trained report writes to utilize SSRS and Power BI to replace Crystal, Qlik.

We made several modifications to Caboodle while ensuring confirmed dimensions integrity of the data warehouse. Developed of additional DMCs, testing for functionality and performance and promoting to production.

Administer Epic Cogito including regular upgrades - Clarity / Caboodle / SlicerDicer / BI Restful server, Cubes and monitoring server activities, providing comparison reports, Nova notes and Sherlock tickets

SQL Server Admin / Clarity/Caboodle (Cogito) Consultant - Advocate Aurora Health

March 2021 – September 2021

Review daily ETL executions, address errors/warnings and manage Sherlock and Nova tickets

Contribute to clean up of validation errors, both metadata and ETL and implement for changes in EPIC environments.

Create DMCA for report writers to handle impacted reports due to ETL warnings.

Perform index maintenance, analyze, and working on partitioning tables for 20TB Clarity database and 8TB Caboodle databases

Make several SQL Server settings to maximize workload, monitor SQL Agent jobs and optimize SSIS jobs.

SQL Server Admin / Clarity/Caboodle (Cogito) Consultant – CHSLI Catholic Health Systems of Long Island

August 2019 – March 2021

Oversee Clarity operations, including daily ETL maintenance, timely application of Ras, Compass upgrades, and collaboration with end users and analysts.

Manage caboodle operations, ensuring smooth daily ETL, handling upgrades, and optimizing performance with report analysts, dealing with work queues, error logs

Serve as SQL Server DBA, addressing daily operations, identifying bottlenecks and executing the Upgrade from SQL 2016 to 2017.

Implement ACG for the Healthy Planet team to enhance care management efficiency.

Collaborate with the Human team to enhance care management efficiency through ACG Implementation

Database Operations Manager at a Hedge Fund

Feb 2019 – August 2019

Lead a team of 6 DBAs to manage operational aspects of over 600 servers.

Provide technical guidance for large and complex business initiatives

Mentor junior DBAs to enhance their skills.

Implement new releases upgrades, and optimize new features for application users

Ensure optimal performance and high availability meeting high service levels.

Performance tuning efforts where we have been engaged or proactively as we get alerts.

Work on additional projects upgrade to 2017, utilizing Always on across the fleet, SQL True up etc.

Utilize automation tools to expedite daily operations.

Sr. SQL Server DBA, Cogito, Clarity, Caboodle Admin - Montefiore

Oct 2014 – January 2019

Install, review, and maintain Clarity operations on Oracle Exadata, including applying RAs, upgrading from EPIC 2014 to 2018, and creating derived tables for performance optimization.

Monitor and troubleshoot Clarity ETL, reviewing errors, running fix jobs, extracting tables and updating performance stats on Oracle.

Install, review and maintain Caboodle operations on SQL Server, including upgrading from version 8.2 to 16.11, developing custom DMC, and setting up HA/DR and maintaining security to ensure HIPAA compliance.

Administer SQL Server, focusing on performance tuning, query optimization, index management, manage EPIC delivered cubes, customizing cubes for financial, BPA, and Pharmacy, and apply customizations to newly delivered cubes during upgrades.

Reviewing Nova notes, change logs,

Troubleshooting performance issues by reviewing AWR reports on Oracle, updating stats as needed

Sr. SQL Server DBA – Subway FWH, Milford, CT

December 2013 – September 2014

Manage over 40 Production and 60 Development server, providing and collaborating colleagues to resolve database incidents and request within SLAs.

Focus on performance tuning, Query Optimization, analyzing query plans to identify and address bottlenecks using various monitoring and troubleshooting tools - Performance Monitor, SQL Profiler, Idera,

Troubleshoot and resolve database integrity issues, performance problems such as blocking and deadlocking, replication, log shipping, and other security concerns.

Utilize DMVs to detect and troubleshoot SQL Server related resource contention - CPU, Memory, I/O, disk space.

Managing Partitioned on very large tables that were causing long IOs and other performance issues.

Setup database backups, restores, recovery models, replication, log shipping DR plan and operational automation while ensuring proper index management techniques and documentation of process and procedures.

Created TSQL code - stored procedures, triggers, functions, tables, views, indexed views, indexes, constraints.

SQL Server DBA Team Lead– Custom Vault, Inc., Bethel, CT

August 2011 – November 2013

Managed SQL Server infrastructure, including installing new servers, patching and transferring databases.

Oversaw database backups, replication, log shipping, setup of alerts for space, security, automate integrity checks, index rebuild/reorgs.

Conducted Performance Tuning, Query Optimization, analyze query plans to provide solutions. Utilize Perfmon, Sysmon, SQL Profiler along with DMVs to detect and troubleshoot and fix issues.

Provide SQL database operational support to tech users, developers, developed run books.

Designed dimensional star schema models and utilized SSIS to populate them from the operational system

Published several SSRS reports using data marts and reporting data warehouse to create standard parameterized reports with drill down, drill thru and drill across capabilities.

SQL Server DBA – LLS, White Plains, NY

August 2008 – July 2011

Install and maintain production, dev, test and staging environments for SQL Server 2000/2005/2008 as well as Oracle 10G, providing 24x 7 support

Troubleshoot database issues, identify problem queries and perform performance tuning, using DMVs to analyze and query plans and resolve blocking and deadlocking.

Implement High availability and disaster recovery solutions using clusters, replication, log shipping, and utilized tools like Quest Spotlight, Litespeed, Capacity manager, Foglight and Redgate software.

Setup database maintenance plan for backups, full and transactional log, and provide support for SQL Developers by creating stored procedures, triggers, functions, views, indexed views, indexes, constraints.

Act as the data architect, gathering requirements, creating data models, and making model changes along with creating scripts for tables, constraints, indexes, primary keys etc.

Principal Consultant – Hologic (Cytyc Corporation), Marlboro, MA

August 2007 – August 2008

Administered multiple databases, performed maintenance plans, and installed software for post-market quality system.

Designed and implemented SQL Server database and web-based complaint data application,

Managed virtual servers, transferred data from MS Access using SSIS, and transitioned complaint handling system to a validated workflow paradigm.

Utilized SSIS to create a data warehouse based on a dimensional model to feed the different reports/analysis.

Utilized SSRS to meet reporting requirements utilizing sophisticated visualization, using cascading prompts and complex T-SQL using dynamic temp tables.

Utilized SSAS to facilitate analysis of their complaint data OLAP cubes using SSAS

Data Warehouse Analyst / DBA – Covidien / US Surgical, Norwalk, CT

May 2003 – August 2007

Administered SQL Server (2000/2005) database for data warehouse initiatives, including development, maintenance and enhancing business intelligence applications with ETL tools, Oracle SQL scripts, automated batch jobs on UNIX and Cognos Transformer

Architected the data warehouse environment on an SQL Server / Oracle Server integrating feeds from SAP (IDOCs as well as replicated tables), other Oracle / SQL Server systems, XML, flat files, into the star schema dimensional model utilizing SQL Server 2000 DTS packages and later SSIS as ETL tools.

Manage all aspects of maintaining the SQL Servers including installation, patch upgrades, operational backups/ restores / setting up maintenance plans, monitoring and performance tuning.

Collaborated with user groups to identify reporting requirements, created data marts, created SSRS reports for various systems used by Manufacturing and QA/QC departments

Created several OLAP cubes for servicing the Sales and Marketing department, to analyze sales performance against quota. Analysis was also made available for new product launches, events, by group purchasing organizations as well as several other dimensions.

Principal Consultant – IMany, Inc., Portland, ME

May 2000 – April 2003

Led end-user interviews and requirement sessions, performed business function and data analysis to produce detailed design specifications.

Modeled data warehouses following Kimball’s methodology, utilizing ERWIN and ER Studio to create Dimensional models and reverse engineering from existing databases.

Implemented ETL solutions using Informatica PowerCenter, /PowerMart, Cognos Decision Stream, Import, Export utilities specific to the database such as SQL Loader, DTS packages to do Data extractions from various legacy applications.

Documented target to source mappings, created tables, analyzed the mappings, did SQL performance tuning, index analysis on tables and further maintained detailed metadata information based on information gathered from end-users, developers, DBAs and other data modelers.

Utilize several reporting tools such as Cognos PowerPlay, Impromptu Web Reports (IWR) and Crystal Enterprise Reports to create reports based on specifications.

Utilize various OLAP tools including SSAS and excel to create reports to deliver functionality to users.

Monitoring queries and report behavior to assure expectations are met.

Create Test plans for unit testing, system testing and user acceptance testing, ensure data quality and troubleshoot production problems as necessary.

Also, assisting the project manager in creating project plans, tracking milestones and coaching / mentoring other developers.

Software Engg. – Swiss Re, Reuters, Pepsi, UltraSeal, Simple Software, Tata Unisys

May 1986 – April 2000

I was responsible for various projects including redesign of several applications, merger conversion and integration of applications, Y2K and maintenance of the front-end systems.

Analyze, document, design and develop front-end application that need to be re-engineered into client server, windows based as well as web-based applications from older legacy-based systems to improve performance and functionality using PB, VB, ASP, Informix and Oracle.

Responsible for several of data conversion projects involved in merger between Swiss Re / Life Re including understanding the application architecture/data structures of both systems. Created the specifications for input from Life Re and mapping to Swiss Re systems.

Responsible for identifying, documenting and modifying of the front-end applications that were affected by the mergers of the systems and Y2K changes.

Other activities include monitoring progress of different projects, creating project plans, tracking milestones and coaching/mentoring other developers. Also perform UNIX systems administration as needed, maintain/create shell scripts, and Informix DBA activities on the dev system, optimizing SQL and monitoring the UNIX systems.

- Automated several of their production, accounting, inventory and QC/QA operations.

Designed, wrote, implemented many applications including daily profit and loss / Costing system, Job Scheduling, Inventory Control, Sales Quotations, Summary Consumption reports, Sample retention, archival and retrieval systems

Responsibilities included development of in-house accounting and Point-Of-Sale systems.

Wrote general purpose business software such as checkbook management, personal planner, sales lead tracking system, inventory control, payroll, invoicing for our mail order business in Clarion.

Analyzed, designed and implemented and maintained custom business packages for our clients using dBase / FoxPro and Clarion.

I was the lead programmer and systems analyst along with 2 other developers.

I also started going part-time for my master’s program in Computer Science, while working here, which I finished in two years from 1990-1992.

Maintenance of Airline systems including Airline Reservation, Cargo management, Airline Revenue.

Skills:

SQL Server DBA

Performance Optimization

Always On Failover Clusters

SSIS, Informatica for ETL

SSRS/SSAS/Power BI, Crystal Reports for Reporting

EPIC Cogito Administration / Development

Technical Leadership

Education:

Master of Science in Computer Science, SUNY, New Paltz

May 1992

Batchelor of Science in Chemical Engg., IIT Delhi

May 1986

Contact this candidate