Sql Server Project

Suresh Krishnamachary

***** ******* *** **,

APT # 204

Tampa

FL 33626

813-***-**** (Mobile)

________________________________________________________________________________________________

Career Summary:

A "hands-on" SQL Server Database Administrator (DBA) with over 12 years IT experience in

Technical skills, team leadership. Strong business and technical vision with effective people skills

to allow close work with senior management. Ability to manage multiple complex projects for

internal and external customers. Innovative and creative problem solver, who is results oriented,

has an aptitude for learning and can maximize resources while possessing a sense of urgency.

Dedicated to translating changing business objectives into leading-edge technical solutions that

are practical and efficient but also meet or exceed business needs.

Core Competencies:

SYSTEMS ADMINISTRATION

Install and configure workstation for internal users on networked environment.

Maintaining Server and desktop operating systems with updated critical and security patches and

service pack.

Install and configure Windows operating System (20003 and 2008) Clustered environments.

Design and implement network infrastructure for Development / Test and production

environments for product development companies

Design and implement Backup Strategy and ensuring scheduled/unscheduled Backups as per

backup plan and restoration. Project Server installation/configuration and maintenance (both 2002

and 2003 project server). Share Point 2.0 / Share Point Portal Server 2003 installation and

configuration and maintenance.

DATABASE ADMINISTRATION

Installing and configuring SQL Server (2000 and 2005) environment in clustered environments

Logical and Physical Data Modeling (using ORD). Install and maintain SSRS for reportings.

Monitoring database server for Health and Tuning for performance.

SAN Storage Configuration and Maintenance. Performing Backup and Recovery duties

Managing Database Users and Security

Working with developers (Design, Code Review, Index Tuning, Triggers, Stored Procedure)

Establishing and enforcing Standards and Transferring Data (DTS, SSIS, ETL)

Replication and Log shipping and Data Warehousing

Scheduling events, Capacity Planning and Providing 24 hours Access throughout the world.

Production Support Experience as well as Development Team support

IT PROJECTS

Install and configure Virtual Technologies (like VM Ware, MS Virtual Server and Virtual PC) to

reduce physical server usage. Familiar with VMware, MS Virtual Server, Hyper-V .

Installed and configure of Citrix Presentation Server 4.5 for Windows application delivery with

application isolation.

Planning and implementation on disaster recovery and data center configurations.

TECHNICAL SUPPORT AND SOFT SKILLS

Windows / Networking (application related)/ SQL Server technical resource and support

Application configuration and maintenance (like new hire setup / resolving access issues etc.).

Strong communication skills (Spoken and written). Convey clearly to the right audience in the

right language

Attention to details and believe in documenting everything on time for easy access for

others.

Strongly believe in delegating works to others and love to work in a good team

environment.

Believe in diversifying into new technologies and skills to keep up with the learning

curve.

COMPUTER SKILLS:

Operating Systems:

Windows 2008/2003/2000, Windows XP, Win2kPro, Windows NT, HP/Dec Alpha/Sco UNIX

Databases:

MSSQL Server 7/2000/2005, Oracle 8/9i, Ingress 6.2 / 6.4

Networking:

Design and install Network, DC, Active Directory, DNS, and DHCP and WINS servers, TCP/IP

Productivity Software:

Microsoft Office Suits including Word, Excel, PowerPoint, Visio and Access

Project Management:

Project Server 2002/2003, Project Professional 2002/2003

Configuration Management:

Rational Clear Quest, Microsoft SourceSafe

Software:

Microsoft Visual Studio 6.0/2005, Microsoft IIS Server 5.0/6.0,MSCRM 1.2/3.0, MS Virtual

Server 2005/HyperV, VMware (Workstation/GSX/ESX), Windows Share Point Services 2.0,

Share point, Portal Server 2003, and Business Object Enterprise XI and Crystal Reports MS

Terminal Server, Citrix Presentation Server 4.5.

Hardware:

Dell Power Edge Servers, Desktops and Laptops.

Certification:

Microsoft Certified Professional (Windows XP/Windows 2003)

Experience:

Switch and Data Facilities LLC, Tampa, FL 02/2009 – Present

Maintain SQL 2000 and 2005 production / Test/ Development environment on Windows

•

2003 environments (Siebel, Microsoft Great Plains, and Purchasing Net are some

application used in these environments).

Design and implement Backup of production database and critical production server and

•

create a disaster recovery (standby) environment in Vienna, VA.

Implement policy and procedure for users access and security for all critical production

•

SQL server Databases

Convert Testing and Lab environments into VMware (ESX) using VMware virtual center

•

and VMware Lab Managers product.

Environmental Resource Management (ERM) Boston, MA 10/2006 – 01/2009

SQL Server Database Administrator

SQL SERVER 2000 /2005 Cluster (Active/Passive) on Windows 2003 environment with

Business Object Enterprise edition.

Installed and configured project management application in production environment on

•

SQL Server and Windows cluster and Business Object Enterprise Edition on a cluster

which includes network load balancing servers for the front application server. This

environment used Windows 2003 OS and SQL 2000 with SP4 on EMC SAN storage on

them. This environment is being accessed by user’s world wide located on a Data Center

environment.

Configured log shipping of the production database to our London on hourly basis with a

•

week end full backup getting transferred using customized FTP scripts and SQL

Scheduled jobs. Monitors this activity on a daily basis for its success.

Installed SSRS in SQL 2005 environment for application reporting and conversion of

•

customer reports from Crystal reports to SQL Server Reporting. Monitored the

environment for performance improvements.

Installed and configured Citrix presentation server 4.5 for windows application delivery

•

for use from the high latency location like South Africa and Belgium. They use this

environment to run the project management software located in a datacenter environment

Responsible for production (ERP Application) support and SQL Server database support

•

for US and South America users. Also help data retrieval using DTS, SQL Queries etc

for these uses who has specific data reporting requirements.

Perform application upgrades, SQL Server hot fixes, services packs etc. Responsible for

•

testing such release on test environment before rolling out to them into production

environment. Weekly transfer of production database to test environment and make its

available all the time for such testing on SQL and application upgrades and patches.

Install and Maintain database objects (such as stored procedures, functions,

•

triggers, views and constraints for large ERP applications) in Production, UAT

and development environment. Documentation of upgrades, application upgrades,

Service Packs and any other administration scripts and store them for central access for

other administrative staffs.

Effectively communicate with internal and external customers, provide timely and proper

•

project status report to management and my supervisor on going projects where

applicable.

BST Global Inc Tampa, FL 12/1999 – 09/2006

SQL Database Administrator

Hardware software installation and configuration using Windows 2000/2003 server,

•

Enterprise Server Administration, Dell Open Manage Utility configuration on all severs,

MS IIS installation and configuration for application environments.

Install / Configured and maintenance of SQL Server environment in Development / QA

•

and production environment

Monitor Performance, Database Query and Index Tuning, Storage Management /

•

Requirement validation and analysis / Design Reviews / Code Review etc.

Performed backup and restore, disaster backup and recovery testing, Database Utility

•

processing (Database consistency check – DBCC commands)

Maintain system and database object (such as stored procedures, functions,

•

triggers, views and constraints) for large ERP & BI applications in a production,

UAT and Development environments.

Performed SQL 2000 database schema conversion to SQL 2005 for development

•

department to identify changes required on the application front.

Documentation on Database diagram, Schema and change management / release process

•

documentations as part of every release.

Installed and configured marketing demo environment which was portal on laptop for

•

their day to day demonstration.

Consolidated server utilization by using Microsoft Virtual Server and VMware virtual

•

server products very extensively and saved huge cost on infrastructure cost to the

company.

Implemented Release and Configuration management process for application upgrades

•

and database upgrades.

Participated in system configuration decision such as sizing of hardware, servers and

•

workstation selection process and storage sub-systems (what raids needed what

environments etc).

Designed and implemented Business Continuity and Disaster Recovery plan for the

•

company.

Planned and moved complete server infrastructure to Data Center as part of the BC&DR

•

plan.

Implemented internal portal based solution to HR/Management/Support and Marketing

•

users for day-to-day use.

Implemented Project 2003 server and project professional client for internal project

•

resource planning purposes.

Software Consultants Sacramento, CA 10/1998 – 11/1999

R Systems Inc

Client - Honeywell Sensing Control (July-Dec’99)

• Supported (product enhancement, defect fixing) their internal products developed in Oracle

/Ingress /UNIX /COBOL.

Client - Amdocs (Formerly ITDS) (Oct98-Apr99)

• Worked in their Front-End Product Support Team (customer order entry developed in Oracle/

Ingress) on Bug fixing and product enhancements projects.

Manager Response-IT New Delhi, India 04/1998 – 09/1998

Times of India

Worked as Manager – Response (IT) for their Newspaper classifieds maintenance software called

Response-IT, which was run on HP Unix/Oracle/Ingress. Worked on enhancement and bug fixing

and maintenance of this software by handling a team of 10 application programmers. More than

55 locations used this software to post newspaper classifieds.

Sr. Systems Analyst New Delhi, India 03/1991 – 03/1998

Xerox, India

Started the career as Accounts Assistants in one of Xerox branch in Northern India

Gained insight on COBOL accounting software and done lots of enhancements/process

improvements on the financial system software.

Hand picked to work for Xerox internal management information system division in New Delhi

on Software design development of financial accounting software using Ingress database on Sco

UNIX environment.

Extensively traveled around India for installation and configuration and onsite conversion of

existing COBOL financial accounting data to Ingress and implement the Ingres in-house

developed software.

Gained in-depth knowledge on Ingres Database Management and Administration and al in UNIX

system administration by working on this project.

Received recognition for my work from Xerox Honor’s Club Program on went on grand slam trip

to Paris-France in 1997.

Accounts Assistants/Computer Analyst New Delhi, India 04/1987 – 02/1991

Patel India Pvt. Ltd

Worked as accounts assistants doing AP/AR and financial accounting works

Worked on computerization of companies accounting activities in Windows / Dbase accounting

package which was developed in-house. Trained on financial accounting software development

and programming language while on this job.

EDUCATION:

• Bachelors in Business Accounting (B.Com) - (March 1990)

• Certification course in System Analysis & Design and Object Oriented Programming from NIIT

- New Delhi India (Sept 1998).

• IBM - PC Applications Basic (10 Weeks course) from Computer Point - New Delhi India

(1989)

• Diploma in Computer Programming & PC Applications (Omega course) from Computer Point

New Delhi (Dec 1990)

On The Job Courses completed:

• Leadership thru Quality – Xerox, India 1992

• Manager as a facilitator – Xerox, India 1999

• 4GL/Ingres/ABF training – Mastek, New Delhi - 1993

• Sco UNIX Installation and Advanced Parameters – PCL/STG New Delhi 1995

• Oracle 7.1/Forms 4.5/ Reports 2.5 from Hex aware – New Delhi - Aug 1996

• Java/Enterprise JavaBeans – Time of India - 1998

• Microsoft Certified Professional (Windows XP, Windows 2003)

• Microsoft SQL Server 2000 database (T-SQL) programming (ONLC – Boston – 5 days course - 2006)

Contact this candidate