Ms Sql Server DBA with 3+ years Experience

ARSHAD ALI

Objective:

To take up a challenging career with active interest in the field of

Database Administration. To work in a quality certified organization, which

gives me an opportunity to demonstrate my skills & in turn be a source of

growth for the organization.

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.

Professional Summary:

. Having 3+ years of experience in SQL Database Administration, System

Analysis, Design, Support of MS SQL Servers 2008 and 2005. In environments

like Production, UAT, Development, Replication and Cluster Server

Environments.

. Good Expertise in Installation, Configuration, Maintenance and

Administration of SQL Server 2008 and 2005

. Experience in troubleshooting and resolving database integrity issues,

performance issues, blocking and deadlocking issues, replication issues,

log shipping issues, connectivity issues, security issues etc.

. Strong knowledge of backups, restores, recovery models, database shrink

operations, DBCC commands, Clustering, Database mirroring, Replication.

. Good knowledge in implementing DR solution, High Availability of database

servers using Database mirroring and replications and Log Shipping.

. Having hands on experience in implementing SQL Server security and Object

permissions like maintaining Database authentication modes, creation of

users, configuring permissions and assigning roles to users.

. Experience in Performance Tuning, Query Optimization, using Performance

Monitor, SQL Profiler and other related monitoring and troubleshooting

tools.

. Experience in creating Jobs, Alerts, SQL Mail Agent and scheduling DTS.

. Creating procedures and SSIS packages.

. Having experience in applying patches and service packs to keep the

database at current patch level.

. Communicating regularly with all teams to ensure database integrity and

security

. Excellent client-facing communication skills and delivery focus.

Work Experience:

. Currently working with Tangoe India Softtek since Sep 2012 to till

date.

. Worked with Greytip Software Pvt Ltd from Mar 2011 to Sep 2012.

. Has Undergone Real-time training on SQL and Oracle database

administration from SQL-Star International Pvt Ltd from July 2010 to

Jan 2011.

Skill Set:

Database : MSSQL SERVER 2005/2008, Oracle 9i,

10g, 11g on Linux/Windows.

Programming : SQL/T-SQL.

Oracle Tools : export/import, DBCA.

MSSQL Tools : SSMS, Data manager, SSIS, Profiler,

Microsoft Clustering Services (MSCS),

Quest comparison tool, Lite Speed.

Operating Systems : Win 9x/2000/2003/XP, UNIX, Linux

Webserver : Tomcat, Jboss.

Educational Qualification:

. B.E in Computer Science from Visveswariah Technological University,

Belgaum, Karnataka.

Project Summary:

Tangoe India Softek Service Pvt Ltd.

Sep'12 - Till date.

Client : Tangoe

Environment : Windows 2000/2003/2008, Linux.

Role : Consultant.

Responsibilities:

. We are supporting nearly 200+ Databases which includes Prod/Dev/QA

environment.

. Installation and configuration of MS-SQL Server and Oracle Server.

. Creation of user databases and ensuring file group creations and also

ideally placing files in appropriate locations.

. Created new user accounts, profiles, and roles and assigned them to

different users and enabled auditing to monitor the system privileges

and roles granted

. Log shipping configuring and monitoring.

. Managing replication in SQL Server 2005/2008 and monitoring

replication server

. SQL Setup, Trouble Shooting, Maintenance & Upgrade

. Solving different database related issues like taking care of

different processes consuming high CPU resources, blocking and

long running queries.

. Creating procedures and SSIS packages

. Monitoring SQL Server Backups, upgrades to new version, apply service

packs to correct server bugs and trouble-shoot SQL Server issues.

. Monitor the status of Scheduled jobs - on daily and on weekend tasks

like rebuilding indexes, defragmenting Databases, Shrink Database, and

Database complete backup

. Bulk data cleaning up and modifying the data on database as requested

by client.

. Communicating regularly with all teams to ensure database integrity

and security

. Have created Jobs, Alerts, SQL Mail Agent and scheduling DTS.

Greytip Software

March'11 - Sep'12.

Client : Greytip Software

Environment : Windows 2000/2003/2008, Linux.

Role : Implementation Engineer

Responsibilities:

. Installation and configuration of MS-SQL Server and Oracle Server.

. Experience in SQL Server 2005/2008 implementation and Maintenance.

. Creation of user databases and ensuring file group creations and also

ideally placing files in appropriate locations.

. Creating logins and assigning proper permissions to the created

logins, mapping logins to the database and granting appropriate

permissions.

. Loading data using DTS import utility into MSSQL Server.

. Experience in Database Migration Activity from one Datacenter to

another.

. Planning backup and recovery strategy for various database

environments.

. Performed different file recoveries in the database.

. Space monitoring and adding space to database when it's needed.

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

on it

. Taking care of SQL*Net related problems like listeners and connect

strings.

. Creating linked servers.

. Scheduling jobs.

. Reviewing SQL Server and SQL Server Agent Error Logs

. Handling minutes of meeting for regular weekly team meetings

. Interacting with other teams frequently in order to resolve different

issues.

Hobbies and Strengths

. Ability to achieve targets.

. Creativity.

. Possess sound technical knowledge, excellent verbal and writing

communication skills.

. Reading, playing cricket and playing Sudoku.

Personal Details

Address : Armstrong Road, Shivajinagar,

Bangalore-560001

Sex : Male.

Marital Status : Single

Passport : Yes

I hereby declare that the above written particulars are true to the best of

my knowledge and belief.

Place: Bangalore

Date: Arshad

Ali[pic]

Contact this candidate