Sql Server Windows
Resume:
Kishore Kumar K
*********@****.*** 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