Sql Server Engineer

[pic]

SHAMSIYA AHMED

SQL Server DBA

Address: ***** ** **** **, ******** WA-98007

Email:

abmukb@r.postjobfree.com

Mobile: 775-***-****

SUMMARY

V Over 5+ years of experience in MS SQL Server installation,

configuration, performance tuning, client/server connectivity, query

optimization, backup/recovery and Maintenance activities.

V Experience on Providing High Availability solutions like Replication

(Snapshot, Transactional & Merge), Transaction Log Shipping, Mirroring

and Clustering.

V Experience with Database Backup, Recovery and Disaster recovery

procedures.

V Experience in Extracting, Transforming and Loading (ETL) data using

SSIS/DTS Import/Export utility, BCP and DTS Packages.

V Extensive experience in Query Optimization and Troubleshooting of SQL

Server related issues using SQL Profiler, Performance Monitor and

other tools.

V Experience in integrating different Microsoft BackOffice Components

such as SharePoint, IIS with MS SQL Server.

V Hands-on working experience with analyzing query plans, using extended

Stored Procedures, managing indexes and locks, troubleshooting

deadlocks and process bottle necks.

V Experience in managing alerts, Operators and Jobs through SQL Server

Agent.

V Provided after hours and 24/7 database maintenance and support.

V Installed, authored, and managed reports using SQL Server 2005

Reporting Services.

V Installed the Change and Release deployments in both production and

UAT environments.

V Proficient in database design and creating stored procedures, views,

functions, cursors using SQL Server 2005.

V Experience in SharePoint Administration activities such as

Installation, Configuration, and Deployment of SharePoint Farms and

proficient in developing Custom Web Parts, Custom Workflows, Features,

Event Handlers.

V Excellent experience in branding the SharePoint site by customizing

Master Page, CSS using SharePoint Designer.

V Extensive use of Site Definition, InfoPath, Excel Services, Content

Management, BDC and SharePoint Object Model.

EDUCATION:

Bachelor of Computer Applications (BCA), Osmania University, Hyderabad,

India.

CERTIFICATIONS:

V 70-431 Microsoft SQL Server 2005 - Implementation and Maintenance

V 070-542 Microsoft Office SharePoint Server 2007-Application

Development.

V 070-630 TS: Configuring Microsoft Office SharePoint Server 2007.

TECHNICAL SKILLS:

RDBMS Microsoft SQL Server 2000, 2005& 2008, MS Access, Oracle

LANGUAGES C#.NET, VB.NET, ASP.NET, HTML, DHTML,CSS, JavaScript, SQL, PL/SQL

SHAREPOINT MOSS 2007, SharePoint Designer2007, InfoPath 2007, MOSS Central

TECHNOLOGIES Admin, BDC, Web Content Management, Business Intelligence, Excel

calculation services, SharePoint Object Model, MOSS 2007 Search.

WEB SERVERS Internet Information Server IIS 6.0,7.0

OPERATING SYSTEMS Windows 95/NT/2000/2003/2008, UNIX, MS DOS.

pROFESSIONAL EXPERIENCE:

Microsoft

Mar'2010-Till date

Washington

The purpose of Visual KB application as a management tool is for

automation of setup, publishing, and administration of Knowledge Base

Articles. It serves Internal, External, and Microsoft Only articles

created by MS Users and Partners for more than 50 subs. Its architectural

goal is to align with Geo-Redundancy, Recoverability, High Availability,

High Performance, Lower hosting cost and Supportability.

Responsibilities as an Operations Engineer/DBA:

. Performing initial installation and configuration of SQL Server 2008

and MOSS 2007.

. Configured Search Crawl rules to change the timeout on all SSP since

the default timeout for SharePoint is too low for certain crawls.

. Updated the index servers using the STSADM utility.

. Monitoring the response procedures for MSSQLServer or SQLServerAgent

when it is running.

. Actively participated in the meetings with PM and development team

to discuss on the SMC SharePoint 2010 Pilot architecture and its

deployment.

. Placed orders for servers with PQOInfra team based on the

application requirement.

. Created notification templates for SMC SharePoint 2010 Pilot during

planned outages.

Environment: Windows 2008,.Net 2.0.3.5,SSL Certificates, IIS 7, Moss

2007, TFS, SQL Server 2008.

PfizerProNetwork

Apr'09-Feb'2010

New York

The PfizerPro Network consists of three separate Web sites designed to

support health care professionals. Pfizer for Professionals

(PfizerPro.com) provides detailed, up-to-date information about 150

Pfizer medicines. Pfizer for Oncology Professionals (PfizerOncology.com)

includes extensive information and resources for oncology professionals.

Pfizer Medical Information (PfizerMedicalInformation.com) is your online

source for medical information about Pfizer medicines.

Responsibilities as a SQL Server DBA:

. Created and maintained SQL Server 2005 and 2008 databases.

. Perform day to day Database Maintenance tasks -- Clustered & Non-

clustered Database Monitoring, Backups, Space Management, Resource

Utilization, responsible for performing object migration between all

production database Servers.

. Managed and created reports to be used on the SQL Server 2005

Reporting Services (SSRS) and supported Microsoft Office SharePoint

Server 2007 (MOSS 2007).

. Supported the application development teams in optimizing tables,

indexes, stored procedures, triggers, and ad-hoc reports.

. Responsible for maintaining, updating, and using full, differential

and transaction log backups for multiple SQL Server databases

. Installation and administration of Cluster Servers for SQL Server

2008 hosted on Windows 2008 Server.

. Ensured data backup and recovery, maintenance, data integrity and

space requirements for the database server environments.

. Managed database instances, monitor server performance, tuned the

database server and applications, and performed backup and recovery.

. Applied SQL Server service packs and hot-fixes to ensure maximum

security.

. Responsible for troubleshooting database inefficiencies using SQL

Profiler.

. Creating and troubleshooting stored procedures, indexes, and views

using TSQL.

. Creating DTS Packages for data import/export, scrubbing and

scheduled jobs for backups

Environment: MS SQL Server 2008, MS SQL Server 2005,Moss 2007,

SharePoint Designer 2007, Windows 2008 Server, IIS 7.0

WMS

Jan '08 -Apr '09

Chicago, IL

WMS has played a decisive role in games and entertainment since

1943.Company stand as one of the world's leading slot suppliers with an

unmatched reputation for innovative game design and development.

Portfolio includes many of the industry's most popular and profitable

branded casino slots and state-of-the-art gaming technologies.

Responsibilities as a SQL Server DBA:

. Supports the development, implementation and daily administration

of SQL Server databases, performs database design, modeling and

implementation of new database structures, as required.

. Manage hierarchical security (access control, permissions,

encryption keys and certificates) for databases and ensure data

integrity using templates and schemas per, Sarbanes-Oxley Act.

Ability to prepare for and participate in security audits and

database encryption, and disaster recovery measures.

. Troubleshoot database performance issues and tune database objects.

Set up traces and Profiler to troubleshoot performance issues.

Analyze deadlocks & diagnose issues on the server.

. Troubleshoot Infrastructure issues related to SQL database server

such as memory, CPU, I/O, Disk, etc. Monitor log files to

proactively resolve issues.

. Install and troubleshoot replication, performs production

migrations, backups, and database recovery.

. Managing security, which includes monitoring and controlling database

access, assigning permissions to application owners.

. Maintained high availability of databases using Database Mirroring.

. Running DBCC consistency checks, and fixing data corruption in user

databases.

. Worked with stored procedures, triggers, and complex queries to help

SQL development team.

. Implemented Log shipping as a part of disaster recovery.

. Performing backups and restorations using SQL Lite Speed tool.

. Resolved dead lock situations as a part of performance tuning.

. Responsible for server trouble shooting and maintaining zero down

time.

Environment: MS SQL Server 2008, MS SQL Server 2005, Windows 2003 Server,Windows 2008 Server, IIS 7.0, IIS 6.0

ROSS STORES, Inc

Jun' 06 -Jan' 08

Manhattan, NY

Ross Stores, Inc., a Fortune 500 company, is the nation's second largest

off-price retailer operating 939 Ross Dress for Less stores in 27

states.Ross Dress for Less offers first-quality, in-season, name brand and

designer apparel, accessories, footwear and home fashions for the entire

family.

Responsibilities as a SQL Server Technical Support Engineer:

. Responsible for extensive Application/SQL monitoring, troubleshooting,

tuning, high-availability strategies (Replication, failover clustering,

log shipping) in a Windows 2003/ SQL Server 2005 24X7production

environment including Change and Release deployments.

. Performing under the given the Service Level Agreements (SLA) and

performance metrics.

. Part of Problem management team that identifies trends and provides

information that can be used to eliminate recurring problems.

. Creating a knowledge library associated with each and every service

request.

. Perform code moves / Deploy new releases as per the Date & time of

execution.

. Performing new Installations / upgrades / releases and follow the

process / security guidelines defined by the customer.

. Provide support from a database standpoint during the planned outages /

Patching / Server moves.

. Updating the service accounts passwords and renewing of the SSL

certificates.

. Ensure that Daily backups of all the databases are being successful.

Fix incase of any issues.

. Performing recovery (point in time / transactional) depending on the

requirement.

. Provide proactive & reactive tuning support primarily for the

infrastructure issues.

. Used SQL Profiler and DBTA for performing the performance analysis on

the database.

. Ensure all database environments (UAT and Production) are in sync.

. Proactively monitoring the Production Database and optimize stored

procedures for better performance. Resolving locking conflicts and

resource utilization.

Environment: SQL Server 2005, C# .Net, Windows 2003, IIS 6.0, SQL

Profiler, Visual Studio .NET 2005.

Lupin Laboratories

Feb' 05 -Apr' 06

India

Lupin Laboratories Limited is India's one of the largest pharmaceutical

Company, manufacturing and marketing world class generics, branded generic

pharmaceuticals and active pharmaceutical ingredients. The project involved

Database Administration Support (Development & Production), Software

Installation, Database Performance Tuning & Maintenance, Database Back up

and Recovery, Export/Import of Data, Replication, Creating and Implementing

of various Installs and Database Auditing Analyzing.

Responsibilities as Junior DBA (SQL Server) :

. Created Database objects like Stores Procedures, Triggers, Views, and

Rules etc.

. Responsible for upgrading and migrating various applications in Access

to SQL Server 7.0/2000.

. Designing and building databases for applications across all company

business functions.

. Worked in capacity planning by shrinking databases and log files.

. Experience in using system tables and system stored procedures.

. Created User Defined Functions and stored procedures for query

optimization.

. SQL Server Administration involving planning and implementing Backup

and Recovery Strategies.

. Implementation of data transfer through DTS.

. Setting up and configuring transactional replication of databases.

Environment: SQL Server 7.0, MS Access, Dot net, MTS & Win 2000, Erwin.

[pic]

Contact this candidate