Home

Kishore Kumar - SQL Server DBA

[email protected]

Location: Remote, Remote, USA

Relocation: Remote

Visa: GC

Kishore Kumar SQL Server DBA (540) 353 7000 [email protected] Remote GC Certified SQL Server DBA Over 15 years of expertise as results-driven project and database management professional with first-rate skill in directing full cycles for complex, multi-site programs. Expertise in Database Architecture, Administration, System Analysis, Design, Development and Support of MS SQL Server 2019, 2017, 2016, 2014, 2012, 2008 in Production, Test, Development and Replication & Cluster Server Environments. Technical Summary: Extensive experience in building and managing new Data Centers and participating in major Hardware Upgrades and Database Migration Projects Performed Capacity Planning, Data Modeling, and Logical/Physical Database Design Conducted many a GAP Analysis and provided recommendations to follow the best practices of Database Design, Implementation and Maintenance Conducted Risk Evaluation of Database Security for enterprise-wide SQL Server Databases and managed mitigation of identified areas with diverse teams in a record time Setup and managed Enterprise DBA group starting with one database/ one DBA, implemented processes and procedures, expanded DBA group to manage over 450 databases in a world-wide, distributed database environment Worked extensively on MS SQL Server 2000, 2005 & 2008 R2, 2012, 2014,2016 and 2019 Extensive knowledge as a SQL Server DBA and great Developer Experience in writing Stored Procedures, Triggers, Views, Indexes, Functions using T-SQL with Query Analyzer tool and ability to use SQL Profiler & Index Tuning Wizard for Performance Tuning and used DTS, BCP for import & export the data. Experience in Database Backup, Recovery and Disaster Recovery procedures (Clustering, Log Shipping, Replication and Mirroring) Proficient with SQL Management Studio, scheduling jobs with SQL Server Agent, SQL Profiler, restoring database using full, differential, and log backups. High level of exposure to SQL performance tuning query optimization using Database Engine Tuning Advisor (DTA) and SQL Server Profiler Experience in installation, configuration of SSIS and SSRS in 2014, 2016 and 2019. Exposure to SSIS Architecture and designing end to end DTS & ETL process. Good skills in client server architecture, design, system requirement study, and project management OLAP experience like Data Analysis Services, Business Intelligence tools. Data migrations using SSIS and DTS services across different databases like Oracle, MS access & flat files Experience in installing and configuring SQL Server 2019/2016/2014/2012 Clusters in Active/Active or Active/Passive Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database Consistency Checks using DBCC Utilities Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional Experience in Data Modeling using Erwin Design Tool Experience working with windows 2016/2012/2008 Advanced Server Administration and Installation Good interpersonal, Analytical and Communication skills Proven ability to deliver productivity and quality improvements through well-managed, on-time Projects Dedicated, self-motivated achiever who is committed to success and adept at juggling multiple tasks in high- pressured environment Education: Master of Engineering (Microelectronics) from RMIT University, Australia Bachelor of Computer Science Engineering from JNTU University, India Technical Skills: Microsoft SQL Server 2005 2019 Azure SQL MS Access Amazon Web Services (AWS) Amazon Aurora MySQL Windows Server SQL Server Integration Services (SSIS) SQL Server Analysis Services (SSAS) SQL Server Reporting Services (SSRS) Internet Information Services (IIS) Foglight SharePoint Visio PowerShell Oracle Transact SQL (T-SQL) SQL Server Management Studio SQL Server Data Tools SQL Profiler SQL Query Analyzer Database Tuning Advisor Visual Studio Microsoft Office 365 Python, PowerShell Idera Diagnostic Manager SQL Sentry Solarwinds NewRelic LiteSpeed SQL Server Backup Amazon Redshift AWS Glue Professional Experience: Ernst & Young (EY), ATL Apr 21 to Till Date Sr. Database Administrator Responsibilities: Worked on many challenging projects supporting different teams in their Database Engineering needs. Some of the projects included Database Design, Storage Analysis, Archival Strategy, SSIS Development, Server Upgrades and Performance Monitoring and Troubleshooting Worked on AWS Cloud projects that included upgrading Terraform Modules and upgrading RDS instances. Worked on right sizing AWS cloud instances and saving costs. Have experience of working on SQL Server EC2 and RDS instances. Automated database deployments using Flyway and CICD pipelines. Automated backup and database maintenance tasks. Worked as production support DBA and involved in troubleshooting many issues including performance analysis and mitigation. Worked on many infosec requests to maintain compliance with database security and protection standards. Have experience with on-prem to cloud migrations. Created runbooks and kb articles for monitoring and troubleshooting production issues. Worked on daily backup strategy and recovery procedures using Tivoli Storage Manager. Good knowledge of Powershell and Python languages Worked on SQL Server, MySQL, and AWS Aurora Database Technologies Conducted many Knowledge-Share sessions for other team members. Participated in some exciting Hackweek projects. Worked on modifying and deploying SSRS projects. Worked with GitHub for Source Control. Documentation of critical issues and other knowledge sharing articles. Worked with Dynatrace Monitoring tool to study application workflow and dataflow traces. On-call 24/7 support Molina Healthcare, Long Beach, CA Mar 19 to Mar 21 Sr. Database Administrator Responsibilities: Played a hybrid role of database administrator and architect. Worked in a highly diverse technical environment including SQL Servers, MySQL Servers, Oracle Servers, Netezza, Hadoop and AWS Servers Lead a team of 3 database developers and managed SQL development work for many projects Designed, planned, and delivered multiple complex projects Involved in writing, installing, configuring, scheduling, and monitoring of various ETL processes Assist with infrastructure optimization and design, including identifying bottlenecks, improving responsiveness, and reducing single points of failure Experience in creating OLTP and OLAP Data warehouse using Pentaho Suite (Pentaho Data Integration/Kettle, Pentaho BI Server) Experienced in developing BI Reports and Dashboards using Pentaho Reports and Pentaho Dashboards Writing views, stored procedures, functions, and reviewing query performance and optimizing code Used Python and PowerShell scripts to automate and manage various database tasks like scheduling maintenance jobs, application jobs and other deployment tasks Worked on many SSIS projects and upgrades. Excellent experience with ETL concepts, design, and delivery Responsible for building and deploying database updates to real-time production, and working with several environments and QA processes Provide database support by coding utilities, responding to user questions, resolving problems Research database technology, propose changes and develop implementation plans based on database platform roadmap Maintain, tune, monitor and administer development, stage, and production databases Provide technical and business subject matter expertise to the data modelers and other developers Provided general guidance/direction and training to junior level support personnel Good experience working in AWS cloud environment. Working knowledge on AWS Redshift, Glue jobs, Lambda functions, monitoring and alerting with CloudWatch, Aurora databases etc. Worked with both EC2 and RDS instances. Supported both MySQL and SQL Server Instances. Built and upgraded EC2 instances with terraform modules. Used in-house platform called HAL to deploy the modules. Responsible for all kinds of activities related to SQL Server database administration Assisted in MySQL database administration Document and create architecture diagrams, ETL processes, best practices for database backup and recovery, monitoring, and security etc. ISN, Dallas, TX Oct 18 to Mar 19 Sr. SQL Server DBA Responsibilities: Manage and support company s database assets across production, dev, and staging environments Work with Rackspace hosting company to identify, troubleshoot and fix database related errors and address issues on 2016 SQL Servers Monitor and address performance issues across environments using NewRelic, PRTG, Rackspace and Custom SQL Server Alerts Use tools like QueryStore and Extended Events to troubleshoot performance issues Manage Backup and Recovery strategy on all environments using Tivoli Storage Manager Monitor and respond to over 1200 SQL Server Job errors and issues Perform Quarterly DR test and meet RTO and RPO SLAs Perform Quarterly Dev/STG refresh and automate this process using PowerShell script Perform Quarterly capacity planning and raise tickets to expand the database drives appropriately Be on-call duty 24/7 365 days and respond to any critical database issues Be available and perform database code release management on every Monday evening Follow change management process and handle all db related tickets on our Siebel CRM Manage SQL Security and automate process of implementing permissions and privileges Perform index maintenance and statistics updates on critical tables Setup, monitor and address transactional replication issues Setup, monitor and address AlwaysOn Availability Groups Monitor, troubleshoot and fix trace data collection SSIS packages Maintain active communication with developers and QAs to address their issues quickly Stubhub Inc., San Francisco, CA Mar 13 to Sep 18 Sr. SQL Server DBA Responsibilities: Designed and built a new Data Center to move all the database servers that were being hosted by a 3rd party vendor to the in-house Infrastructure Designed, planned, and executed multiple data center setups with high availability and disaster recover features such as AlwaysOn Availability Groups Awarded multiple merit-based recognitions for troubleshooting and solving mission critical production issues and bringing databases online and continuing to service business with very minimal downtime Implemented high availability DB options like Clustering (Active/Passive) and Replication (Transactional and Snapshot) after the move to the new data center Performed Database Migration from SQL Server 2000 to 2005, 2005 to 2008 and 2008 to 2012 as part of the data center moves Designed and built a whole new stack of Non-Prod Envs on VMWare machines for the purpose of Development, Testing and Deployment of new Projects Participated and performed many duties like Planning, Design, Development, Testing and Deployment of various database objects in many projects like POSNET re-design, Ticket Technology Exchange Rewrite, PDF Delivery, Order and Inventory Integration, SOX/PCI compliance and other Security Projects Installed, Configured and Maintained many a database server of various versions like SQL Server 2000, 2005, 2008, 2012, 2014 and 2016 for both external and internal applications Constantly involved, attacked, and solved many a performance issues on a host of different database servers belonging to a variety of applications Installed, Configured and Maintained both SSIS and SSRS Servers Installed, Configured and Maintained Team Foundation Server for version control Participated as an integral part of the release and change management teams and handled a variety of DB releases for many applications and projects Performed GAP Analysis, Risk Assessment of various SQL DB Servers and provided recommendations and implementation procedures to bring them up to an acceptable standard by following the best practices in the industry Developed Templates and Implemented comprehensive Maintenance plans for backup, reindexing, db health check, updating of statistics for a variety of both Prod and Non-Prod DB Servers Performed many patching exercises on both stand-alone servers as well as clustered servers in a rolling failover fashion Performed general Database Administration and other Management Activities in a safe, recoverable, and professional manner to ensure the optimal operation of all database environments Developed, Deployed and Maintained many a ETL packages using SSIS Developed, Deployed and Maintained many a Reporting packages using SSRS Provided 24/7 365 days support for almost 2 years as a sole SQL Server DBA in the company Cross-Trained Oracle and DB2 DBAs to handle basic jobs and contribute towards SQL Server Database Administration Planned and Implemented a Comprehensive Monitoring Mechanism for all the SQL Server DB Servers by employing and deploying Quest Foglight and Solarwinds DPA Tools as a Central Repositories Developed and published many a Design, Implementation and Maintenance related documents for SQL Servers to help the broader employee base to understand, monitor and maintain the servers Provided guidance and troubleshooting capabilities in performance tuning, security, and other best practices implementation to various application teams Designed and Implemented Service Broker objects to provide the capability of asynchronous messaging as part of Order and Inventory Integration Projects Implemented Data Encryption by developing various objects like Certificates, Keys and Stored Procedures as part of the SOX and PCI compliance Security Project Planned and Implemented the Maintenance Activity for VLDBs up to the sizes of 3 TB Involved in complete SDLC process by analyzing business requirements and charting out functional workflow from source systems to destination systems Designed, developed, deployed, and maintained many SSIS solutions and projects to build and populate the data store Used transformations in SSIS Dataflow, Control flow using sequence and for loop containers Involved in ETL architecture enhancements to improve performance using sql server tools Developed various types of complex reports like Drill Down, Drill through and Cross tab reports Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs. Involved in creating, scheduling snapshots and subscriptions using SSRS 2012 Involved in many deployments for both reports and SSIS projects to production Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes Advised optimization of queries by looking at Execution Plan for better tuning of the database Loaded data from various sources like flat files, excel workbooks to SQL Server database using SSIS packages Used Lookups Transformation to get the data from reference data sets Involved in troubleshooting critical production issues for both reports and SSIS loads Worked as a key resource and SME to help design and implement custom client projects Understanding the functional and technical specifications Prepared backups using Tabadmin and Tabcmd commands Designed and developed SSIS packages for Tableau dashboards Modified data visualization dashboards and developed data connections Setup new Tableau sites and granted user permissions Created and maintained Tableau scheduling tasks Designed, developed, and deployed Tableau Business Intelligence reports Good understanding with the design and development of Tableau visualization solutions Preparing dashboards using calculations and parameters in Tableau Used Trendlines, Parameters, Aggregate Functions and Filters to develop Tableau reports Sterling Creek Software Inc., IN Aug 08 to Feb 09 MS SQL Server DBA Bridgestone Firestone Diversified Products Responsibilities: Involved in Migration of SQL Server 2000 to SQL server 2005 Installed and configured SQL server 2005 active/passive cluster Configuring SSIS (SQL Server Integration Services) for named instances, remote access enabling for Users and Migrating DTS packages to SSIS Involved in re-writing of all the functionality (which is not supported in 2005) of SQL server 2000 to SQL server 2005 Creating Maintenance Plans for consistency checks, maintaining indexes and statistics, performing fine Tuning of Database Application. Cleansing and solving Database troubles Solid experience and knowledge with SQL 2005, 2000 Backup and Recovery Procedures Successfully Implemented Multi Server Administration in SQL Server 2005 and developed scripts to use in Multi Server Administration Involved in Performance Repository Project, where the performance statistics data is collected, and to generate reports to proactively monitor the servers and try to avoid any kind of Server and Database related issues Resolved database performance issues by using dynamic management views to identify a cause Implemented QUEST Management solution at Enterprise Level and configured for performance analysis of the Databases Exporting the Database from Local Server to the Remote Server and Importing the Current running database from remote server to the Local DB Server using SSIS and DTS Given proposal for servers and hardware RAID configuration solutions for Enterprise Solutions Applied hot patches on MSCS (Microsoft Clusters) and fixed few bugs in Microsoft Cluster and SQL Virtual Servers Good experience in 24/7 production support which included verifying all instances and checking if they are up and running. Responsible for checking the error log files for any new entries Environment: .NET Framework, ASP .NET, ADO.NET, Visual Studio .NET, HTML, XML, XSLT, Windows (2003, 2000/4.0), QUEST, SSL, IIS 6.0, SQL Server 2005, 2000/7.0, SQL Server Integration Services and SQL Server Analysis Services 2005. Department of Child Services Responsibilities: Involved in installation and configuration of SQL Server 2005 Express Edition. This is used as an offline database server for the original database server which is Oracle 10g Managing projects for Oracle 10g and SQL Server 2005 systems implementations Supporting MS SQL Server 2000/2005 and Oracle 9i / 10g production databases Involved in migrating the various data structures and sample data from Oracle databases to SQL Server databases Experience of efficient troubleshooting of the issues when setting up the migration process Setup the Merge Replication between the Oracle Server and the SQL Server Express Edition whenever they come online with one another Providing support to the application developers and attending to their requests about various database requests pertaining to SQL Server databases Environment: .NET Framework, ASP .NET, ADO.NET, Visual Studio .NET, HTML, XML, XSLT, Windows (2003, 2000/4.0), QUEST, SSL, IIS 6.0, SQL Server 2005 Express Edition, Oracle 9i / 10g Client: Toyota Motors Manufacturing, KY Aug 07 to Jun 08 SQL Server Administrator Responsibilities: Production support of 430GB Microsoft SQL Server 2005, with responsibility for troubleshooting, fault tolerance and disaster recovery Database Creation, Assigning Database Security and Standard data modeling techniques In-depth knowledge of internal database structures and configuration of Microsoft SQL 2005, 2000 Responsible for running database consistency checks (DBCC) Job Scheduling-using SQL Agent. Extensively used Microsoft Visio, ER Studio are used for multi-level data modeling application for Logical and physical database design & construction. Installed and Configured SQL Server Mail. Design, Import/Export of ETL using DTS, BCP and Bulk Insert. Database Administration (Space, Distribution, Recovery, etc.) Successfully migrated Oracle, MS Access to MS SQL Server for a large system. Administered SQL Server 2000 & 2005, Oracle 9i, 10g Server Security. Planed and implemented SQL Server Backup strategy and automation. Database tuning using UTLBSTAT/UTLESTAT and STATSPACK. Plan for a robust backup system with RMAN develop and test recovery scenarios on a Test restore system on a frequent basis for customers. Solely responsible for application tuning using Explain Plan, SQL trace, TKPROF utility. Automation of maintenance jobs. Responsible for tuning SQL Server Configuration (Memory, Locks, Indexes, etc.). Eliminated table scans, Maintained data integrity and improved performance by applying proper indexing. Upgraded SQL Server 2000 to SQL Server 2005. Consistently reviewed and analyzed patch fixes and service pack releases and applied accordingly. Monitored and resolved problems with IT systems; hardware, software, and processes using SPOT Light Extensive Expertise in implementing Replication and Database Mirroring. Send alerts and identify potential performance problems. Actively worked with developers writing database codes and tuning them. Worked on Microsoft SQL Server Analysis Services and Reporting Services. Extensive Experience Creating and Maintaining several TSQL Scripts, Stored procedures and Triggers Extensive experience in Database design and Data Modeling for Data Warehouses (ODS, Star Schemas, Snowflake Schemas). Excellent Knowledge of Micro strategy, Business Objects (User, Designer, Supervisor). Environment: SQL Server 2005/2000, Oracle 8i/9i WinNT/2000, Microsoft Project, DB Artisan, Spot Light, Erwin, Microsoft Visio, Micro strategy 7i, Business Objects, SQL Server Analysis Services, Reporting Services. Client: MidAmerican Energy, IA Oct 06 to Jul 07 SQL Server DBA Responsibilities: Development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, database integrity verification and indexing updates. Daily support of system wide replication tasks including monitoring, alerting, and problem resolution. Responsible for the creation and maintenance of entity relationship diagrams, Meta data repository and comprehensive system documentation including everything from environment configuration information through standards, policies and procedures. Installed MS SQL Server Cluster Server and configured SQL Server 2000 on Windows 2000 Advanced Server. Worked on project called GSLB (Global Site Load balancing). Integrating SQL Server 2000 with CISCO Network to balance load between three website (ww1, ww2, ww3) locations. Configured Transactional replication between Primary Server and three Read Only servers, with separate Distributor server and experience in troubleshooting replication problems. Configured MS SQL Server 2000 in-built log shipping from primary server (New York, NY) to DR server (Ashburn, VA) and also SQL Server 7.0 log shipping manually using scripts. Daily support, troubleshooting, monitoring, optimization and tuning of server and SQL server environments across entire system. Involved in Development activities included hardware and network specification, installation and configuration, and participation in database design, architecture and SQL scripting. Performed key role in handling WEB site Database during peak holidays like Valentine s Day, Mother s day and Christmas Day. When we had 5000 user connections solved latching issues by creating multiple servers (Read Only Servers) using replication. Worked with B2B solutions in the same company for maintaining retail stores across USA. Totally 120 servers maintained at flowers including B2B (Fresh connections), Live Web Site and DR site. Used Diagnostic Manger from Idera solutions and NetIQ App manager for monitoring SQL Server Servers. Environment: .NET Framework, ASP .NET, ADO.NET, Visual Studio .NET, HTML, XML, XSLT, Windows (2003, 2000/4.0), SSL, IIS 6.0, SQL Server 2000/7.0. Keywords: quality analyst business intelligence database information technology green card microsoft California Iowa Kentucky New York Texas Virginia