Resume

Sign in

Data Manager

Location:
Rancho Cucamonga, CA
Posted:
April 23, 2020

Contact this candidate

Resume:

Mobile:646-***-**** adcxi3@r.postjobfree.com

Kishore is a Microsoft Certified Database Administrator (MS SQL Server 2016/ 2014/ 2012/ 2008/ 2005/ 7.0) with extensive 18 years’ experience in the IT industry. His expertise lies in Project Management, Service Management, installation, administration, troubleshooting, performance tuning, optimization, replication, clustering, always-on, logshipping, monitoring, back-up, High Availability, disaster recovery, data modeling, partitioning, data warehousing architecture, modeling, ETL, database platform, data profiling, performance tuning, physical infrastructure, strategic planning, business assessment, process design, knowledge management, extensive track record of successful projects and technical & financial analysis and maintenance of SQL Server databases in both clustered and stand-alone environments with a Storage Area Network (SAN-Tagma) on Windows NT/ 2000/ 2003 platform that lead to the growth of the organization. He has experience in migrating and upgrading SQL Server 2000/2005/2008/2012 to SQL Server 2005/2008/2012/2016 that helped organization to be in cutting edge technology. Kishore also has experience in SQL server development including data modeling (logical & physical design of databases), creating stored procedures, functions, triggers, cubes, reports, MDX and packages using T-SQL. He has excellent communication skills to be a great leader and lead the organization to interact with different clients/vendors .

EDUCATIONAL QUALIFICATION:

#

School

Course

Degree

1

Louisiana State University

MBA

Masters

2

Osmania University

MSc Computer Science

Masters

3

Osmania University

BSc Computer Science

Bachelors

CERTIFICATIONS:

#

Vendor

Certificate

Version

Code

1

Microsoft

Installing, Configuring, and Administering (MCDBA)

SQL 2000

70-229

2

Microsoft

Designing and Implementing Databases (MCDBA)

SQL 2000

70-228

3

Microsoft

Installing, Configuring, and Administering (MCDBA)

SQL 2000

70-215

4

Microsoft

Developing & Implementing Web Applications(MCDBA)

SQL 2000

70-305

5

Microsoft

Microsoft Certified IT Professional

SQL 2005

70-447

6

Microsoft

Microsoft Certified IT Professional

SQL 2008

70-453

7

Microsoft

Microsoft Certified IT Professional

SQL 2012

70-457 70-458

8

ITIL

ITIL Foundation Certificate

ITIL 2.0

PROFESSIONAL EXPERIENCE:

SQL DBA Comcast – Remote (Philadelphia, PA) 09/18-Present

Role and Responsibilities:

As a DBA I have assisted Comcast IT and Engineering teams with managing our extensive on-premises and public cloud database infrastructure, including monitoring, system health, maintenance plans, and operational setup, understanding and implementing modern SQL Server (2016) features for HA/DR, replication, encryption and row-level security. Design, develop, implement, maintain and administer data schemas for more than 40 TB database

Using SSIS/MuleSoft/PowerShell, data is synced from Source to Destination/AWS depending upon Real-Time, Near Real-Time, Batch, Asynchronous transactions, Bulk data movement

Integrations may involve in Reading data from Email/ File server, Encryption/Decryption of data/file, Orchestration, Staging data

Implemented the TDE (Transparent Data Encryption) in all the Production servers to secure the employee personal data.

Automated daily activities such as event log ids, running reports, deployments using Power shell scripts

Maintained and monitored 300+ integrations using tools Foglight, DynaTrace

Diagnosed and troubleshooted technical issues using Python, T-Sql

Created C#, Python libraries to create Facades to establish connection to third party APIs

Performed database administration tasks including maintenance, upgrades, user management, monitoring, audit and performance tuning

Worked on Always-On 2012 and managed the Disaster Recovery and High Availability solutions.

Setup/ implemented/ maintained/ troubleshooted Always-On Availability Groups on a Multi-subnet failover network to enable mirror copies for reporting thus saving millions to the organization.

Designed, developed, managed, and maintained all databases that support IIS, Web servers, development, testing and production operations

Saved thousands of dollars to the Organization by designing, developing, testing, deploying and maintaining application servers (Tomcat) and number of inhouse applications such as Success Factor, HR Payment, Timesheet, Salesforce, SAP using Agile/ Scrum, Kanban process (Cherwell, Target Process, ServiceNow) by tuning legacy databases

Evaluated, documented speed & bottlenecks

Tuned T-SQL queries, Indexes, settings, configuration tweaks, hardware

Load tested SQL servers

Maintained best practices, policies, standards and protocols

Dashboard saved additional server resources by both proactive and reactive tuning the performance of the SQL transactions

Optimized in estimating SQL Server infrastructure and saved millions to Organization

Automated the process to extract, transform, load, purge and clean data.

Implemented partitioning to improve performance tuning on the database.

Provide database support for OLTP and OLAP applications.

Perform and improve data replication and purging operations

Supported software development with database operations including storage optimization, database architecture/design guidance and integration for all relational databases, used by different 24/7 systems to store both customer and company provided data

Worked with various teams to control and execute day-to-day database operations

Developed strategies and implement solutions for database continuous testing, integration and delivery

SQL DBA RJW – Remote(Lockport, IL) 10/17-09/18

Role and Responsibilities:

As a DBA I have assisted RJW IT and Engineering team to increase the efficiency of their current infrastructure by leveraging the results from analysis performed and recommendations made. Provided a plan to remediate the existing SQL infrastructure environment and build additional services and functionality to optimize performance and provide scalability for continued growth. Established a higher degree of user ability and user confidence in the SQL infrastructure system.

Reviewed server infrastructure, disk, SQL server, configurations & counters

Analyzed OS, SQL server performance and issues history

Assessed and optimized

oserver set up and usage

ouser set ups and authorizations

oserver components

oDeadlocks, Indexes, Stats, Disk and configurations

oSQL Database instances

Analyzed performance counters statistics and recommended changes to server resources

Saved thousands of dollars to the Organization by tuning legacy databases

oEvaluated, documented speed & bottlenecks

oTuned T-SQL queries, Indexes, settings, configuration tweaks, hardware

oMaintained best practices, policies, standards and protocols

Improved performance by recommending to move reporting activities (Jobs, adhoc ) to another server using replication at SAN/SQL.

Immediate performance improvement

oSeparating data files from log file

oCreating more data files on another drive

oMore data files for TempDB (SQL 2016 supports creation of more datafiles during installation)

Maintained Zuora to run recurring revenue to align commerce strategy, keep up with recurring bills and collections, and manage recurring revenue

Consolidate report of long\frequently running jobs/queries and tuning them based on criticality and priority.

Assembled overall assessment and recommendations documentation and roadmap

SQL DBA BANK OF AMERICA – Remote (Charlotte, NC) 09/13-10/17

Project #1

Role and Responsibilities:

To meet the challenges related to Law Enforcement Bank Of America (BOFA) establish the TEAM Legal Compliance and Regulation Relations Technology (LCRRT) initiative to address BOFA’s business complexity, technology limitations, growing manual processes, and demographics impacting the system. LCRRT team is responsible for compliance, audit, Corporate Security, and Legal which is responsible to delivering on key compliance programs for the company, including Economic Sanctions. As a DBA I have supported all inward, process and outward applications, their increasing demand for 24x7 online services and support, and eliminating inefficient “Siloed” systems.

Design, develop, implement, maintain and administer data schemas for 40 TB database

TO support latest cutting technology, migrated from SQL 2005 to 2008 to 2012 to 2014

Saved additional server resources by both proactive and reactive tuning the performance of the SQL transactions

Made sure projects rollout in time by promptly troubleshooting the database and connectivity issues in time sensitive situations

Supported release rollouts for application teams, demonstrating client management skills and a comfort with change management concepts.

Provided support to project teams utilizing time management skills and exercising judgment of when to escalate issues to leads and management.

Extensively worked on setting up Always On Availability Groups on a Multi-subnet failover network.

Worked along with the Windows team to configure Windows Failover Cluster on which the Always-On setup was done.

Most of the critical production servers are in cluster environment for high availability

Designed, developed and maintained BOFA’s different functionality packages to load weekly data into the database.

Validated and tested ETL packages using QA script, XML, JSON for redundant implementation of the business rules

Interacted with stockholders to gather requirements for the project

Written, interpreted Data Mapping, Software requirement specification, Work product requirement and Bridging documents.

Implemented database backup strategy using Litespeed tool

Development and performance optimization of database objects including partitioning schemes, indexes, functions, triggers, stored procedures, and CLR objects.

Troubleshooted performance issues, follow-up with Microsoft support and fine-tuning queries & stored procedures for SQL Server 2005/2008, Policy Based Management and SOX audit.

Implemented partitioning to improve performance tuning on the database.

Provide database support for OLTP and OLAP applications.

Provide guidance for BI best practices.

SQL Architect, DoubleLinePartners (Austin, TX) 06/13 -09/13

Project #3

Driving EdFi project which is vendor-neutral, open, XML-based and designed to integrate information from a broad range of existing sources.

Implemented following applications using EdFi

oEd-Fi standard

oEd-Fi solution

oEd-Fi dashboards

oEd-Fi ODS

Analyzed EdFi historical data received from Student Information System (SIS PeopleSoft Campus Solutions) or HR, revisit schools with a prototype and gather more requirements.

Verified EdFi historical data in-terms of data validity, orphan data etc.,

Created XML files, loaded Operational Data Store into Dashboard Data Source using ETL packages.

Mapped XML file to have a single component process multiple input files of a directory and output multiple files to a single component using Altova Mapforce

Validated ETL packages using QA script for redundant implementation of the business rules

Prevent data corruption and data redundancy using Sanity check scripts

Performed ETL unit testing before handing it over to QA team

oMetadata testing

oCreated tests using Test Data Manager

oTest Runner for running the tests created and common problems encountered

Owned optimized and prioritized the intake from the EdFi BI demand for the reporting and analytics across the Enterprise Services in alignment with the business strategies and priorities. Articulated the value proposition and drive prioritization.

Architected tables using Kimball’s architecture

Identified dimension and fact tables to build cubes

Developed reports to display data in Excel, SSRS.

Maintenance of SQL technologies like Replication, Clustering, Database Mirroring

Migrating SQL 2005, SQL 2008 R2 to SQL 2012

SQL Lead, EQHS (Baton Rouge, LA) 04/12-04/13

Project #4

Contributed in the growth of the company by driving following projects focused on new data initiatives for real-time decisions, reporting, and ad-hoc analyses

oHealth System of Illinois

oHealth System of Mississippi

oHealth System of Florida

oURUM

oCare Co-ordination

oPredictive Modeling

Implemented SQL\MYSQL security to avoid any project related access issues.

Implementing best practices, Installing, Managing and administering MYSQL, SQL 2005/2008 /2012 database engine, Analysis server(SSAS), Reporting server (SSRS), windows batch scripts, VB scripts, C# and Integration Services (SSIS) on clustered production instances with high availability.

Created a successful master data management project while working along with the stakeholders to generate acceptance and ownership go a long way

Normalized databases to be accurate, fast and efficient and produce the data more than company expected and saved billions of dollars on different projects.

Saved high profile project by implementing best practices, troubleshooting performance issues and fine-tuning queries and stored procedures for SQL Server 2005/2008/2012.

Supported company to be on cutting edge by migrating SQL 2008 to SQL 2012.

Experience in using SSIS tools like Package Installation, and SSIS Package Designer and Import and Export Wizard/ BCP between different sources like Oracle/Access/Excel.

Experience in developing, deploying and administering SSIS packages across all environments.

Expert in generating writing parameterized queries, drill through reports and formatted SQL server Reports in SSRS 2005/ 2008/2012 using data from ETL Loads, SSAS Cubes, Cognos and various heterogeneous data sources.

Defining data warehouse (star and snow flake schema), fact table, cubes, dimensions, measures using SQL Server Analysis Services.

Installing, Managing, Troubleshooting and performance tuning MySQL (5.0.22 and 5.1.24) in production and non-production environments

Effectively configured MySQL/SQL Replication as part of High Availability solution.

Development and/or maintenance of very large-scale Data Warehouse applications with various data sources including SQL Server, Sybase, MS Access, Excel,

Oracle, Informix, Flat Files.

Data Architect\Modeling OLTP and OLAP environments.

Owned optimized and prioritized the intake for the BI demand for the reporting and analytics across the Enterprise Services in alignment with the business strategies and priorities. Articulated the value proposition and drive prioritization.

Experience in managing 46 TB of database.

Writing SQL and T-SQL queries, stored procedures, and triggers.

Provide team of analysts and developers technical guidance and challenges aligned with career development paths

Participate in strategy discussions, analysis and decision making by providing stakeholders with technical input and recommendations.

Continuously keeping an eye on the latest cutting edge technologies and leveraging these in one's own work

Manager Delivery Cognizant Technologies Solutions (NYC) 10/07- 03/12

Project #5

Client

Location

Designation

Period

BARCKLAYS WEALTH

Manhattan, Newyork

SQL Manager

Nov 2011 to Mar 2012

ARTIO

Manhattan, Newyork

Sr. SQL DBA

Nov 2009 to Nov 2011

Washington Mutual

Seattle, WA

Sr. SQL DBA

May 2007 to Nov 2009

Developing, Managing & executing various IT projects at Artio Global

oEagle Uploader

oDaily Price & Security flow from Bloomberg, NTRS, Factset to Eagle & Charles River.

oBloomberg Data migration into Symantec Enterprise Vault (Journals, emails, BB etc.)

oBloomberg Historical Data Management & Migration to Enterprise Vault

oCore Infrastructure UpgradeWin2K8 Server

oVirtualization: ESX3.0 to 3.5 & ESX 3.5 to 4.0

oGood Technology Rollout for User Owned Handhelds

oDB Schema refresh

Onsite offshore co-ordination

Service Management (ITIL 3.0 Frame-work)

Client interaction and only SQL manager for the delivery unit handling 15 resource.

Installing, Managing and administering SQL 2005/2008/2012 database engine, Analysis server(SSAS), Reporting server (SSRS) and Integration Services (SSIS), Informatica on clustered production instances

Monitored SQL server and Windows Server performance using “Performance Monitor” tool.

Created stored procedures, triggers, indexes in SQL 2005/2008/2012 environments using T-SQL.

Migrated from SQL 2005 to 2008.

Datacenter DBA Tower to make transparency of the issues and concepts of the process.

Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.

Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.

Configured Secure Shell (SSH) to connect client to SQL server through firewall.

Troubleshooted performance issues and fine-tuning queries and stored procedures for SQL Server 2005/2008, Policy Based Management and SOX audit.

MySQL database administration on a large scale MySQL installation.

MySQL database backup and recovery strategies and Replication and synchronization.

User management by assigning appropriate permissions to the database users SQL Server 2005/2008.

Backup using Idera.

Database session management like identifying problem sessions and tracing them using profiler, PSSDIAG and other Microsoft utilities.

Analyzed query plans to tune SQL Queries. Writing SQL scripts for gathering statistics for performance-tuning benchmarking.

Made recommendations for space management and monitoring.

Monitor, set and control system capacity plan for future system requirements.

Worked with other technical teams to resolve performance issues.

Patch Management - Tested Hotfix/Service packs/Builds of Ms SQL server before applying to business environment.

Tested database mirroring (DBM)

SQL Server Consultant, SVAM International, US (NYC) 06/07-10/07

Project #6

Responsibilities:

Managed and administered SQL databases

Monitored SQL server and Windows Server performance using “Performance Monitor” tool and using SQL scripts.

Installed SQL DB engine, Integration services, Reporting services & Analytical services.

Toubleshooted issues experienced during installations.

Provided BI platform to analyse and send reports to higher management

Lead Database Administrator, Infosys Technologies (India) 08/04-05/07

Project #7

Developing, Managing & executing various IT projects

Data Warehousing

Risk Assessment Program

SQL 2005 Migration

Database Migration

Clustering Technology

Logical Database

TestDB Refresh

Database Administrator, Apollo Group (India) 10/02 to 06/04

Project #8

Developing, Managing & executing various IT projects

MCare Claims Processing & Administration Modules

Member Enrollment Module



Contact this candidate