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