Sql Server Project

Subrahmanyam.T

Email: *****.***@*******.*** Mobile:+919*********

PROFESSIONAL SUMMARY:

A confident and motivated IT Professional with over 3.8 years of experience in Microsoft Technologies as SQL Server DBA and management skills with very good exposure to business communication with a high degree of innovativeness and excellent problem solving capability.

CORE RESPONSIBILITIES:

Experienced SQL Server DBA in Production & Development support.

Responsible for administration of almost a hundred instances comprising of several hundreds of databases with sizes up to 300 Gb+ and 500 Gb+.

Experience Installation, configuration and maintenance of MS SQL Server

Experience in Managing and monitoring jobs, Error Logs, Server space,

Health of Database & Servers.

Experience in creating SQL Logins, Assigning Roles to the users and Authentication Modes as part of Security Policies for various categories of users.

Developing the successful Backup strategies based on Recovery models.

Experience to Perform database tuning & performance monitoring

Setup High Availability database infrastructure using Log shipping, Replication, Mirroring, Clustering

Setup and Administration of Transactional Replication and Periodical Troubleshooting of customer data issues

Conceptually i have strong knowledge on Clustering.

Ensuring data consistency in the database through DBCC commands

Experience in Client Interaction (Both Domestic and Overseas)

Quick learner and ability to grasp new technologies.

PROFESSIONAL EXPERIENCE:

Working as Support Analyst for Polaris Software Lab Limited, Hyderabad from November 2007 to till date.

EDUCATIONAL QUALIFICATION:

Bsc(computers) from Andhra University in 2005

TECHNICAL SKILLS:

Databases : SQL Server 2000/2005/2008

Operating System : Windows Server 2000/2003 /XP

Languages : C, C++

Project#1

Project Name : ARTEMIS (Accrual RiskTotalizer Management information

System)

Role : Database Administrator

Client : CITI BANK

Environment : Database: SQL Server 2005

O/s : Windows Server 2000,2003

Team size : 06

Duration : March 2010 - Till Date

Project Details:

ARTEMIS is a management information system tool that provides a view on the Price Risk and Liquidity measures on a consolidated basis across regions, countries and businesses.The main benefit of this project is Monitoring of Limit excesses (or)bursts for all risk measures at global/ regional level and Monitoring of Risk Measures at global / region level.Another benefit is Price Risk measures on a pre configured template MCO by country with consolidation at global/regional level by currency Stress testing of standardized portfolio at a consolidated level.

It also provides Historical trend analysis for key risk measures across selected regions/businesses and Ability to view Balance Sheet trends & composition changes.

RESPONSIBILITIES:

Provided 24/7 Supports for Production, Development & Test Servers of MSSQ Servers

Installing and Configuring SQL Server, including service pack deployments.

Planned and created a managed backup and recovery plans for clients.

Implementing disaster recovery plans.

Migration of SQL Server databases.

Administer Microsoft SQL Server 2005 database server’s ensuring data Integrity

Database Administration And Maintenance.

Fixing Orphaned users through SSIS package

Managing Security (Creating users, logins and roles ,granting permissions)

Performance Monitoring and tuning through SQL Server performance alert,running trace in profiler,using the database tuning advisor.

Ensuring Data consistency in the database through DBCC commands.

Scheduling jobs in Sql server

Creating Index & managing other objects of Database.

Troubleshoot Microsoft SQL Server errors including blocking, transaction Locking and security

Configuring and Monitoring SQL Server high availability techniques, Replication and Logshipping

Project#2

Project Name : Reckitt Benckiser

Role : Database Administrator

Client : Reckitt Benckiser (UK)

Team Size : 04

Environment : SQL Server 2005, Windows Server 2003,MOM

Duration : May 2009 to February 2010

Project Details:

Reckitt Benckiser is a global force in household, health and personal care products. Reckitt Benckiser is having 3 Data centers and more than 400 Servers in UK . We have used a standard trouble ticket system(VISION) for logging tickets and for doing change request. I have managed 170 database servers and also extented my support in windows administration.

RESPONSIBILITIES:

Installing and administering Microsoft SQL server.

Upgrading to latest service packs

Coordinate and troubleshoot SQL server problems.

Capacity Planning of the Database Servers for hard disk

Monitoring disk drive space, Database file sizes.

Responsible for the whole Database Maintenance (Installation, Backup, Restore, updating , deletion) in SQL Server 2005,2000,7.0

Monitoring and resolving failed and long running jobs, blocking processes, error logs.

Monitoring the CPU, Memory utilization on servers

Maintaining and updating project documentation.

Running multiple queries for the daily routine activities in SQL Server 2000

Standardization of database servers as per the best practices in database administration.

Testing upgradation from SQL Server 7.0 installation to SQL 2000

Upgradation from SQL Server 6.5 installation to SQL 7

Worked with the team in the migration process of a critical database server to a new machine.

Project#3

Project : LG Electronics

Client : LG Electronics,U.S.A

Role : System analyst, DBA

Environment : SQL Server 2005.

Project Duration : August 2008 to April 2009.

Project Details:

LG electronics, Inc, Was established in 2002 to provide global management responsibility and overall direction for strategy, product development, marketing, sales and distribution of the company’s iris recognition technology products. LG Electronics roots as an electronics industry leader trace back to 1958.today,a leading manufacturer of digital and electronics products, and world leader in monitor technology and optical disc drives.

RESPONSIBILITIES:

Installing, configuring and upgrading of Microsoft SQL Server software and related products.

Establish and maintain sound backup and recovery policies and procedures.

Implement and maintain database security (create and maintain users and roles, assign privileges).

Automating and monitoring all the Database maintenance activities.

Monitor and optimize the performance of the database and troubleshooting performance issues.

Performing the Data Refresh activity in DEV/Test environments from Production.

Configuring and Monitoring SQL Server high availability techniques, Replication and Log shipping.

Project#4

Project Name : Status Mart

Client : ETFC (U.S.A.)

Team Size : 3

Role : Support Analyst

Environment : SQL Server 2005, Windows Server 2003, IIS6.0.

Duration : November 2007 to July 2008

Project Details:

E-Trade Financial Corporation which helps the Business users to know about the status of Pipelined Loans, Loan Summary, Funded and Cancelled Loans. The Group's principal activities are to provide Investing, trading, banking, and Lending Products brokerage services, primarily through the Internet and other electronic media

RESPONSIBILITIES:

Installing, configuring and upgrading of Microsoft SQL Server software and related products.

Backing up of all the databases along with the verification and Checking the status of Backups and Restoration of databases(Daily / Weekly / Monthly).

Making required schema changes, adding triggers, stored procedures.

Providing Security by giving access permission to users at various levels.

Monitoring of Disk space where physical databases are stored.

Escalating issues to our senior DBA.

Involving to Creation of Jobs & Maintenance Plans.

To Learn the Daily Log checking for errors on Production as well as Standby Servers and to know the other error & solutions.

Monitoring the Performance of the servers.

DECLARATION:

I hereby declare that the information furnished above is true to the best of my Knowledge.

Subrahmanyam T

Contact this candidate