Kishore Kumar K

aczjpf@r.postjobfree.com 404-***-****

PROFICIENCY FORTE

PROFILE SUMMARY:

An accomplished Database Administrator with over 8+ years of experience in working with various versions of MS SQL Server 2000/2005/2008/2012/2014 RDBMS System.

• Expertise in installation, up gradation and configuration of SQL Server 2005, 2008R2, 2012 and 2014 also applying Service Packs and Hot Fixes

• Wide knowledge on Security Implementation & Monitoring at Server, Database and Objects level

• Sound Knowledge in Backup & Restore using company SOP(Standard Operating Procedures) for different backup medias, Involved in creating & documenting Backup strategy & Disaster Recovery plan for production, test and development servers within specified Maintenance Window

• Experience in configuring Linked Servers to implement Remote Database Transactions, and data access between SQL Server and other Heterogeneous relations databases such as Oracle, DB2 & MS Access.

• Hands on experience on DTS Packages in SQL 2000, Migration of DTS packages from SQL 2000 to 2005. Created & Deployed SSIS (SQL Server Integration Services) Projects, Schemas and Configured Report Server to generate reports through SSRS(SQL Server Reporting Services) and knowledge of SQL Server Analysis Services(SSAS)

• Experience in Importing/Exporting Data from various data sources like Excel, Oracle and Flat file using BCP, Bulk Insert & DTS utility. Involved in transformation of OLTP data to the Data Warehouse using DTS and SQL commands.

• Worked with Installation, Configuration and Maintenance of Microsoft SQL Server Active/Active and Active/Passive Clustering and actively monitor the database systems to ensure secure services with minimum downtime.

• Incorporated Database Mirroring in SQL Server 2005 for high availability at Database Level, Experience in implementing various RAID technology

• Successfully tested and implemented Log shipping as a Disaster Recovery and Warm Backup solution for MS SQL 2000 and MS SQL 2005 Servers

• Wide Knowledge on Isolation Levels & resolving Blocking and Deadlock issues

• Solid command over daily Database administration activities like Backup & Restore, Running & Scheduling Jobs, Monitoring Event Viewer and SQL Server Error Logs etc.

• Good experience in Automation Configuration by Creating Jobs, Alerts and Operators and SQL Mail/ Database Mail.

• Thorough experience with Recovery of SQL Server in a Disaster Condition. Provided 24x7 Production Support for mission critical applications on call rotation basis.

• Sound knowledge on SQL Server and Database Monitoring & Tuning for better performance using different tools like DTA, Performance Monitor, and SQL Profiler for the high resilience and performance tuning.

• Experienced capacity planner & projection of database growth and advising for the hardware Configuration that the associated hardware resources are allocated to the databases.

TECHNICAL SKILLS

• Operating Systems: Windows 95/98/NT, Windows 2000 Server, Windows, 2000 Advanced Server, Windows 2003 Server, Windows 2003 Advance Server, Windows XP, Windows 2008 R2 and 2012 R2

• Languages: T-SQL, PL/SQL

• RDBMS: SQL Server 2000/2005/2008/2012/2014

• Database Tools: MS SQL Server, SSMS, BI, Query Analyzer, SQL Profiler

• Ticketing Tools: Service Now, BMC Remedy

• Tools: Spotlight

EDUCATION

Bachelors of Technology from JNTU.

PROJECTS PROFILE

1.

Project Name: EDM-DAN

Role

SQL Server DBA

Organization

Domain

Wells Fargo

Banking

Tools & Technologies MS SQL Server 2012, MS Windows Server 2012 R2 Environment, RDP and Citrix Environment, OTRS ticket tool

Project Description & Contribution

We support US production and development servers for their various critical applications which are running on SQL Servers. We have a REMEDY ticketing tool for ticketing purpose. Whenever user faces any issues or any implementation, client creates a ticket and will be assigned to the SQL server DBA team and then team leader will assign task to the respective DBA to perform the task as per the SLA.

We provide DBA support services for US that run 24X7. Our team provides end-to-end SQL Server Database Administration and has approximately 280 Production Servers, 300 Development servers and 120 staging servers.

Technical Responsibilities

The Data Base Administrator (DBA) is responsible for providing technical support for the database environment including development and Pre-production of the databases, assessment and implementation of new technologies

Work on OTRS tickets, Service requests and change management

Working on SQL Server 2012 with Cluster and High Availability Concepts with Always ON

SQL Server Database Administration, installation, configuration, Maintenance and patch activity support.

security concepts, creating maintenance plans, fixing job failures, performing Database backup and restore

performance tuning, query performance, deadlock issues

Providing 24x7 on call support for any database issues.

Knowledge of ETL and SSIS package.

Knowledge of provide a working model of transaction processing environment for capacity assessment and planning.

Implementing Change Request during non-business hours and working on service request.

Deploy database change scripts provided by third party vendors

Team Responsibilities

Skill building and rapport with clients and team members

Preparing Weekly report and monthly report offshore members

Streamline the database environments

Prepare SOP for team knowledge base

2.

Project Name: LBG

Role

SQL Server DBA

Organization

Domain

Synechron Technologies

Banking

Tools & Technologies MS SQL Server 2000/2005/2008 R2, MS Windows Server 2003/2008 Environment, RDP and Citrix Environment

Project Description & Contribution

Lloyds Banking Group are a financial services group with millions of UK customers with a presence in nearly every community; we are familiar on the high street and with over 1 million businesses through our portfolio of brands.

Our business is focused on retail and commercial financial services. We thrive based on how well we serve our customers; on our relationships within the communities we serve; and on helping Britain prosper.

Technical Responsibilities

Working on ITSM tickets, problem management and change management

Queue management- Managing resources queues reports

Efforts tracking tracking resources efforts individually by pulling reports.

Monthly review summary (highlights, lowlights, TTR, ticket volume).

KB Usage- Maintaining Knowledge base articles usage against each resource.

Ageing Report- Generating Ageing reports using ITSM tool for all resources.

Deploy database change scripts provided by development team in PREPROD/PROD

Scheduled and maintain routine Jobs, Alerts and Maintenance Plans.

Team Responsibilities

Skill building and rapport with clients and team members

Preparing Weekly report and monthly report offshore members

Streamline the database environments

Prepare SOP for team knowledge base

3.

Kantime Health Care

Role

SQL Server DBA

Organization

Domain

Kanrad Technologies Pvt Ltd

Telecom Services (Database Management)

Tools & Technologies

Windows 2000/2003, SQL Server 2000/2005/2008,Remedy and ITSM

Project Description & Contribution

We support US production and development servers for their various critical applications which are running on SQL Servers. We have a REMEDY ticketing tool for ticketing purpose. Whenever user faces any issues or any implementation, client creates a ticket and will be assigned to the SQL server DBA team and then team leader will assign task to the respective DBA to perform the task as per the SLA.

Technical Responsibilities

.

Experience in Database administration activities like Installation, Configuration

Performance monitoring and tuning for Dev/UAT/Production Database

Ensuring regular and timely Backup of databases and jobs status on SQL Server.

Creating maintenance plans

Database files, Users, Indexes and disk space maintenance.

Resolving the tickets for SQL Server.

Implementing all the changes required by development teams as well to resolve production data issues.

Replication, Log Shipping, and Database Mirroring

Installed 2005 cluster

Complying with Audit process.

Creating link servers, configuring the Database in Development and Training server.

Planning the upgrade the SQL server version from 2000 to SQL Server 2005.

Coordinating with the respective teams

Monitor the status of log Shipping in both the Primary and secondary server.

Checking SQL Server Logs and Event logs.

Checking Locks and deadlock management.

Monitoring the Database file size (ldf & mdf) to maintain disk space utilization.

Regular interaction with the counter project team to take over the overall DB Admin activity to the current location gradually.

Team Responsibilities:

Shift Lead

Prepares Rota

4.

CDC

Role

SQL and Apps DBA

Organization

Domain

Mahindra Satyam

IT Infrastructure Management Services

Tools & Technologies

Windows Server 2003/2008, SQL Server 2000/2005/2008, AD, ITSM Tool

Project Description & Contribution

We support US production and development servers for their various critical applications which are running on SQL Servers. Whenever user faces any issues or any implementation, client creates a ticket and will be assigned to the SQL server DBA team and then team leader will assign task to the respective DBA to perform the task as per the SLA.

Technical Responsibilities

Implement the release management process and deploy builds accordingly

Release the builds into Test, Dev., Pre production and Production environments

Co-ordinate with the release manager on upcoming releases on applications.

Co-ordinate with Service management, Development team, test team during issues in deploying builds

Participate in the review meetings and prepare game plans for release in Test,Dev, Pre-production and production environment

Involve in meetings with R&D, Test, Build teams for the future releases

Responsible for the deliverables of the project

Monitor status of customer escalations and Drive compliance of defined process

Ensure proper documentation

Applying System and Application builds as well as hotfixes in all the Environments

Migrating application content from an old server to a new server with better hardware to improve performance.

IIS Installation on Web Servers and do Tech Upgrade for the Applications

Grant Local admin Permissions for the IIS Anonymous Account and SQL Account

Installation of SQL Server 2008 and SQL Server 2008R2 on new servers.

Migrating SQL Server 2000/2005 to SQL Server 2008 and 2008R2

Create Database roles, Logins and assign permissions as per the business requirement.

Monitoring and maintaining the SQL jobs running on various servers. Backup and Restore the Databases.

Team Responsibilities

Streamline operations, resolve concerns and improve efficiency.

Mentoring and training up junior and new staff.

Skill building and rapport with clients and team members

Motivating the team to achieve high standards and KPI targets.

Ensuring all administrative and IT records are entered and updated correctly.

Weekly report and monthly report

5.

Project Name: Carol

Role

SQL Server DBA

Organization

Domain

FIS Global

Construction and finance (Database Management & Data ware House)

Tools & Technologies MS SQL Server 2000/2005/2008 R2, MS Windows Server 2003/2008 Environment, RDP and Citrix Environment, ITSM

Project Description & Contribution

Carol is a leading construction business. Capabilities, a substantial portfolio of Public Private Partnership projects and a sector-leading ability to deliver sustainable solutions

Technical Responsibilities

Installed and configured SQL Server 2000 and 2005, 2008 on Windows 2003, 2008 server, applied service packs and cumulative packages released from Microsoft.

SQL 2008,2008R2 and SQL 2012 environments

Performing SQL server daily health check and preparing a report based on it.

Monitoring Disk Space of all the Servers and freeing up space as per SQL Server i.e. Older Backups, Unused Files etc.

Handling creation of new SQL Server databases as per Client/Application Team request using Build Sheet Template.

Scheduled and maintain routine Jobs, Alerts and Maintenance Plans.

Applying Service Packs and Security patches for the Servers as released.

Monitoring the Logs for successful execution of all the specified jobs.

Created and managing Users, Roles and Groups and handling database security policies.

Managing Backups on a daily basis and Recovery as per request.

Reviewing SQL Server and SQL Server Agent Error Logs.

Monitoring of server performance by profiler during peak periods of server utilization (as per performance tickets if any raised).

Have prepared User-Manuals and Technical documents for the project, which includes ED (Environment Description) documents/ Run Books / RCA s.

Working with MSFT for resolving Advanced Issues through Per Incident Basis.

Maintaining instance/database-specific documentation and ensuring it is Up-to-date.

Team Responsibilities

Mentoring and Training up junior and new staff.

Skill building and rapport with clients and team members

Prepare yesterday efforts,dash board report and attend daily morning shift update call

Preparing Weekly report and monthly report

Generating Ageing reports using ITSM tool for all resources

Contact this candidate