My CV

CAREER OBJECTIVE

Innovative and highly motivated SQL Server Database Administrator with hands-on experience using relational databases, including SQL 2005 & SQL 2008.

Team player who works well under pressure, adapts easily to change, and is willing to take on additional responsibilities to ensure deliverables are fulfilled.

Adept in prioritizing and coordinating tasks to ensure assignments are completed in a timely manner.

Interacts and communicates effectively with all levels of staff and customers.

Fosters cooperative efforts to drive goal attainment.

SUMMARY

I have overall 7+ years of experience in the field of Software & Hardware. I have 6  years of experience in Installation Configuring & Migration of SQL Server 2000 2005 & 2008, Excellent skills in Configuring Log Shipping ,Database Mirroring & Replication, Disaster Recovery Plan, Performance tunning, Index Tuning, Backup Jobs DTS Packages & SSIS Packages, testing of network in Web based & Client server environments. I have a positive attitude, a keen observer and a firm believer in teamwork and confident to handle work in pressure and individually

PROFESSIONAL EXPERIENCE

March 2009 to Till date,

Working as a Senior Enterprise DBA in Tesco Hindustan Service center pvt ltd, Bangalore India.

Client: FreshandEasy & Central Europe Tesco Stores.

Project Name: IT Infra

Description: FreshandEasy is a subsidiary of Tesco UK. It has is good presence in California USA. Basically the FreshandEasy stores are known for their food products in US Retai market. As part of FreshandEasy and Central Europe Tesco stores retail. I am acting as a SPOC for all sqlserver related stuff.

Roles and Responsibilities: Working as Sr.Enterprise production DBA for  SQL Server 2005 & 2008 & administrator for Biztalk server applications.

Technical Respnosibilites:

·             Creating/Debugging SQL/ T- SQL, Stored Procedure/Jobs.

.             Perform Capacity planning for existing and upcoming projects.

·             Backup/Restore activities using SQL Server native backup and SQL client of Legato and TSM Tivoli.

.             Maintaining and Monitoring the Production, development and Test environments.

·             Implemented a Disaster Recovery plan for all databases to ensure  minimal data loss.

.            Performance Tuning.

·             Installaion/Migration of Sqlserver2005 on physical and Virtual environment.

·             Installation and maintenance of SQL server Clustering.

·             Installation and administration of Biztalk servers.

.             Installation of IIS 7.0 on Windows 2008 server.

·             Setup new site on Web Server.

·             Management of Shares/Permission on folders with/without Cluster Administration.

·             Hot fix, SP upgradation on all servers.

People Management :

  • Mentoring a team of 4 DBA’s.
  • Meeting management performance standards,
  • Team supervision and performance management
  • Actioning more complex administrative issues
  • Managing Operations budget
  • Staff training
  • Implementing management policies and directives
  • Managing Triage for Service Requests using CA Service desk and ICCM tool.
  • Preparing capacity planning reports every period for all the streams across CE and US sqlserver.
  • Responsible of metrics related works, which requires projecting team productivity to management

level as well as process improvement.

June 2008 to March 2009,

Worked as a Senior Software Engineer in Accenture services Pvt Ltd Hyderabad.

Client: Microsoft

Project Name: ASM RXD

Description: PLC is the Partner Learning Center. The Partner Learning Center is a central location for Partners to locate and register for several forms of Microsoft training. This is also the central location for the Microsoft field to market, promote, and report their training for partners.

Roles and Responsibilities: Worked as Tier 3  Subject Matter Expert  for  SQL Server 2005 as Production support DBA & PLC web based Application

·             Creating/Debugging SQL/ T- SQL, Stored Procedure/Jobs.

·             User management like creation of user/granting the permission.

·             Setup and Administration of Log shipping.

·             Backup/Restore activities using SQL Server and SQL LiteSpeed.

.             Maintaining and Monitoring the Production, development and Test database server environment.

·             Implemented a Disaster Recovery plan for all databases to ensure  minimal data loss.

.             Performance Tunning.

·             Databases & Sqlserver Migration.

·             Installation and administration of Virtual server 2005.

·             Installaion/Migration of Sqlserver2005 on Virtual PC’s.

·             Monitoring SQL Clustering Administration.

·             Setting up Linked Servers.

·             Installation of IIS 7.0 on Windows 2008 server.

·             Setup new site on Web Server.

·             Managing server side certificates of webservers.

·             Managing Web Sites on NLB devices.

·             Management of Shares/Permission on folders with/without Cluster Administration.

·             Hot fix, SP up gradation on all servers.

Configuration.

·             Managing Service Requests using the tool MSE (Microsoft Service Enterprise).

·             All metrics related works, which requires projecting team productivity to management level as well

as process improvement.

Apr 2007 to May 2008,

Worked as a Sr. DBA for GNCS(Great Northern Consulting Services) an Internal client of i-Vantage India private ltd.

Job Responsibilities:
As a DBA, Providing full time production Support to OwensCorning a fortune 500 company.

Job responsibilities included:

  • Going through the clients’ requirements and coming up with database design and application architecture.
  • Providing consultation on SQL Server to our development teams.
  • Installing, configuring, administering and securing our as well as our clients’ production servers.
  • Migration of Sqlserver2000 to Sqlserver2005.
  • Migration of Oracle database to Sqlserver2005 using SSMA.
  • Coming up with custom-tailored backup/restore and disaster recovery plans for production servers.
  • Troubleshooting performance issues and fine-tuning queries and stored procedures.
  • Implementing and administering database replication between SQL Server databases as well as dissimilar databases.
  • Writing code and creating jobs to automate repetitive tasks.
  • Upgrading and upsizing databases from earlier versions to the latest versions.

Jan 2005 to Apr 2007,

Worked as a Program Member for Data Migration Team in “TIMKEN ENGINEERING AND RESEARCH INDIA” A fortune 500 Company is said to be world wide leader in Tapered Roller Bearings and high precision Steels. Providing the IT service to their own employees around the world.

Job Summary

Providing Database administration, support and solutions. Automating the sophisticated maintenance tasks. Complete Database design Understanding Business logic at database level. Implementing Security and optimization. Cleansing and loading data from legacy system to SAP using DTS package, BCP Command utility Bulk INSERT Transact-SQL, and Database Copy wizard.

Job Responsibilities

  • Installing and upgrading SQL Server 2000. Performing Unattended and Remote Instillations.
  • Creating and Configuring user Databases and generating Transact-SQL scripts.
  • Developing and implementing the physical and logical Database Schema.
  • Configuring and maintaining Full-Text Search Catalogs.
  • Controlling SQL Server Locking and finding and removing Deadlocks
  • Migrating data with DTS packages, BCP command utility, BULK INSERT Transact-SQL, Database copy Wizard and with Distributed Transactions.
  • Developing a data restoration Strategies depending upon the business needs (Full, Simple and Bulk logged Models)
  • Backup and recovery of databases, Attaching and detaching the databases
  • Automating database maintenance with SQL Server Agent.
  • Implementing Server level and database level, Table and column level security
  • Managing, measuring, monitoring and improving SQL Server performance using SQL-Profiler, perfmon.mmc and by creating sensible and effective indexes
  • Managing advanced availability of the server by implementing standby server with reduced downtime.
  • Automating the migration of data using Replication.
  • Writing application and administrative level stored procedures, functions and triggers for smoother application development.
  • Helping programmers to write optimized Transact-SQL statements.
  • Writing secured stored procedures and functions for Database evaluation copies and User License agreements and integrating them with front-end applications.
  • Creating SQL Server instance groups and registering new SQL Server instance installations
  • Got trained on Cranberry Tool for SAP data migration in USA Canton Ohio.
  • Querying the legacy data using SQL server.
  • Data Cleansing, Data loading etc
  • Data loading using LSMW and BDC sessions in SAP
  • Worked on FI and MM Modules for Data Migration

June 2004 to Jan 2005

  • Worked as “Customer Support Engineer” in Value Point Systems Pvt Ltd Bangalore. A company which is a fastest growing Reseller and Authorized Service provider of Compaq India Pvt. Ltd, now known as HP.

Deputed at United Breweries by Value Point Services Pvt Ltd who has undertaken the Facility management service for UB related to IT services. The Helpdesk team is comprised of four members at corporate office.

  • CCR
  • System Administrator,
  • And two Desktop cum Networking Engineer.

Job responsibilities include

  • Design and implementation of Windows NT based networks , win2000 and Red Hat Linux.
  • Installing the required software’s, configuring and finalizing the networks.
  • Installing and Monitoring network printers like Xerox 428/432.
  • Keeping a track of Backups and monitoring Citrix Met Frame Xp Server.
  • Installing configuring and Trouble Shooting ICA Clients Assigning rights to Users to use Network printers and Applications from Citrix Meta frame XP Server.
  • Trouble shooting compatible Desktop PCs and Laptops like Hp, Compaq , Toshiba satellite , Toshiba Portage, Sharp, and Assembled PCs like (486,Pentium pro , PII, PIII, PVI, and Cyrix) machines.
  • Testing, evaluating and quality control of computer hardware and peripherals.
  • Trouble shooting problems related to TCP/IP products including Super TCP LAN Work Place for DOS and Windows.
  • Training customers on Microsoft Windows and its products.
  • Undertaken training sessions for all Trainee Engineers.
  • Evaluating hardware related to network and recommending solution to the clients.
  • Assisting the Marketing Team to technical discussions with customers.
  • Maintaining good custom report.
Advertisements
Comments
  1. Mohammed Refaie says:

    if you are intrested in Providing IT services abroad send us your contacts( telephone and email). to this email
    info@alwasatit.com

    rgds

  2. Rex Ryan says:

    Just wish to say your article is as amazing. The clearness in your post is simply cool and i could assume you’re an expert on this subject. Fine with your permission let me to grab your RSS feed to keep up to date with forthcoming post. Thanks a million and please carry on the rewarding work.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s