Sql Server Manager

Jagan Gaddam

SUMMARY:

< *+Years of Experience as a SQL SERVER DBA in Implementation,

Administration, Database Design, Development & Support of SQL Servers

****, ****, **** *** **** in Production, Test, and Development

Environments

< Experience in replication, log shipping and SQL Server Failover

Clustering.

< Experience in setting up, troubleshooting and maintenance of production

server databases.

< Performed In-Place and Side-by-Side Migration between instances of SQL

Server 2000, 2005 and SQL Server 2008.

< Sound knowledge on Operation CIRT Handling.

< Familiar with VERITAS Cluster. Monitoring the Nodes and Volumes.

< Responsible for reviewing and deploying any production changes through

Release for change (RFC) process

< Responsible for interacting with other technical support groups to

determine appropriate disk platforms, disk configuration, operating

system kernel settings and database engine configurations.

< Familiar with the ITIL standards and implementations.

< Well versed with project responsibilities such as planning and

implementation i.e., Migration and Up-gradation.

< Proficient in meeting tight deadlines and adopting new technologies.

< Experience in using Service Desk application, used to

assign/track/document all requests for work impacting the nature.

< Monitoring the servers by accessing remotely and analysing the databases.

< Experience in Active directory user management, replication and

monitoring.

< Experience in handling Production Servers having an average 120 user

Databases in each server spread across various locations.

< Very Good experience on Optimising Code and Improving Efficiency in

databases including Re-indexing, Updating Statistics, Recompiling Stored

Procedures and performing other maintenance tasks.

< Installation, configuration and maintenance of MS SQL Server.

< Checking the status of Backup troubleshooting the failed backups and

Restoration of databases.

< Experience in Performance Monitoring (PERFMON), Performance Tuning and

Security Administration by implementing Schemas, Optimizing queries,

Tuning indexes and DBCC using DBCC Utilities.

< Adding users in the database and granting permissions.

< Scheduling jobs in SQL Server.

< Recovery of the database during crash or data Loss.

< Coordinating with the development and test teams in the Implementation

and Maintenance of projects.

< Handling various issues rose from the users regarding the data entry

errors in the database. SQL2005 and configuring services.

< Proficient in Designing and Documentation of SQL Server Strategies and

plans.

< Experience in Documenting all Database Architecture according to

established standards.

< Worked as a single DBA and worked in a Team of DBA's in projects so far.

< Analytical and highly versatile, team-oriented individual. Skillful in

translating strategy into actions by organizing tasks, building and

sustaining relationships and leading team members through project

inception to completion under strict time and resource constraints.

< Worked closely with network and SAN teams, well versed with EMC -

Symantic storage.

< Familiar with ENDUR application and standards of trading.

TECHNICAL SKILLS:

Programming Languages Transact SQL, C, C++, Java, Microsoft Active Server Pages

(ASP), PL/SQL, Shell scripting

Web technologies JavaScript, HTML/ XML

Databases MS SQL Server 2000/2005/2008 and 2012, MS-Access, Oracle

10g

Operating Systems Windows Family, MS DOS, UNIX, Linux.

SQL Server tools Management Studio, Enterprise Manager, SQL Profiler,

Query Analyzer, System Performance Monitor, Export &

Import, Replication, SQL Litespeed

Domain Commodities, Telecom, Healthcare,

EDUCATION:

< 2007 Master of Computer Application, Hyderabad, AP, India.

< 2003 Bachelor of Computer Application, Hyderabad, AP, India.

CERTIFICATION:

< Microsoft Certified IT Professional - Database Administrator 2008.

< Microsoft Certified Technology Specialist - SQL Server 2008 -

Implementation and Maintenance

PROFESSIONAL EXPERIENCE

Client : Wells Fargo, Charlotte, NC

Position: SR. SQL SERVER DBA

Duration: AUG'12 - Till Date

Project: Commodities Trading

Synopsis: Wells Fargo Commodities* helps you manage price risk across all

major commodity classes, including agriculture, energy, metals, and power.

It offers both traditional financial hedging strategies to manage exposures

to commodity prices and indices, and physical transaction capabilities in

natural gas and agricultural products. Wells Fargo Commodities, LLC

operates as a subsidiary of Wells Fargo & Company. Wells Fargo offers its

swaps and other derivative products, services, and transactions solely as

principal, and not as an agent, broker, advisor, or fiduciary for its

customers.

Responsibilities:

- Work closely with Client's Technical team, Front Office and Middle

Office users for technical solutions of business requirements.

- Responsible for the daily trade flow process and ensure all the

operations are going on smoothly, without any interruption

- Installation and maintenance of Production boxes which has Endur

application, Oracle and SQL Server.

- Performing the health check of the Production servers.

- Deploying the Java, Java Script, J2EE, ASP and XML production

changes through Release for change (RFC) process.

- Research, Analyze and troubleshoot technical issues.

- Configuring the PROD, UAT and QA environments.

- User Management through Oracle for Endur application

- Configuring and maintaining ICE Gateways.

- Monitoring SQL server databases

- Enhancements and implementations of new solutions.

- Perform backup and restore of database as per the user

requirements.

- Manage offshore team being in Charlotte, NC.

Environment: MS SQL Server 2008, Oracle 10g, Endur (OpenLink), Weblogic

(Java, J2EE), C++, Java Scripting, Shell Scripting, XML, Microsoft Active

Server Pages (ASP) and Grid Server

Client : Asurion, TN, USA

Position: Sr. SQL Server Administrator

Duration: MAY'10 - July'12

Project: IT Operations - Database Administration

Synopsis: ASURION is the global leader in technology protection services.

From lost, stolen and damaged wireless handsets to malfunctioning computers

or HDTVs, ASURION provides more than 90 million consumers worldwide with

best-in-class, next day device replacement. ASURION also offers protection

of user content and software. As the world's largest provider of technology

protection products, we make replacing wireless devices fast, easy,

inexpensive, and hassle-free.

Responsibilities:

- Installation and maintenance of SQL Server software on

production/development / Quality Assurance

- Servers and clients

- Monitoring SQL server databases

- Handling Very Large databases ranging in sizes from 500 GB to 1.3

TB

- Provided L2/L3 support as the primary point of contact for all

technical and operational issues

- On call support

- Tuning data & performance of the servers, and working with

development teams to identify & suggest Optimization enhancements

- Implementing Database Replication for VLDBs

- Maintain integrity and consistency of the databases.

- Deploying custom maintenance procedures to maintain the health of

large databases

- Implementing Log shipping and Database Replication for high

availability of 24x7 active databases

- Experience in Installing and Configuring Failover Clustering for

high availability in Active/Passive.

- Configured and monitored Database Mirroring.

- Worked extensively on Database space management, performance

monitoring and alert management.

- Coordinated with back-end programmers in optimized stored

procedures, Tuned Stored Procedures and carried performance

improvement on long running queries and used DTA.

- Analyzed Traces from the SQL Profiler to troubleshoot database and

used DBCC consistency checks for other database maintenance

aspects.

- Designed & implemented databases, tables, views, clustered and non

clustered indexes in production environment.

- Administered the SQL Server by creating user logins with

appropriate roles, dropping and locking the logins, monitoring the

user accounts, creation of groups, granting the privileges to users

and groups.

- Worked on replication latency and distribute the over load on

publisher servers. Created 3 new distribution server by own and

reduced the over load on the server.

- Prepare steady state documentation and cutover scripts for the

entire SQL processes at PCA.

Environment: SQL Server 2000, 2005, 2008 R2 (32 and 64 bit) and 2012,

Windows Server 2000/2003(32 and 64 bit), SSMS, SSIS, SSRS, Enterprise

Manager, T-SQL, Log shipping, Replication, Clustering, SQL Profiler,

Performance Monitor (PERFMON), C++, Microsoft Active Server Pages (ASP) and

Java Scripting

Client : VIANT (formally known as CNS - Concentra Network services),

TN, USA

Position: Sr., SQL Server Database Administrator

Duration: SEP'09 - JAN'10

Project: IT Operations - Database Administration

Synopsis: Viant delivers comprehensive cost control strategies to payers in

the health care industry through its suite of PPO network, network

management, pre-payment and post-payment services. Leading carriers, Blues

plans, TPAs and self-insured employers rely on Viant's professional

expertise and sophisticated technologies to maximize savings opportunities

and improve business processes. Since 1990, we have developed effective

solutions for both in-network and out-of-network claims that have generated

significant savings for our clients and their customers. For example, in

2007 alone, Viant saved its clients $2.4 billion

Responsibilities:

- Migrated data from SQL server 2000 to SQL server 2008

- Performed daily tasks including backup and restore by using SQL

Server 2005 / 2008 tools like SQL Server Management Studio, SQL

Server Profiler, SQL Server Agent, and Database Engine Tuning

Advisor

- Managing SQL databases, Security, fine tuning of SQL queries,

troubleshooting

- Designed technical specifications and implemented business

components for the site using C++, Java, _JavaScript, Microsoft

Active Server Pages (ASP), DHTML, HTML, XML

- Created transactional replication on different servers.

- Worked on UNIX/ LINUX, MS SQL Server, Oracle server and Windows

servers extensively

- Developing SQL stored procedures, views and triggers.

- Installation and configuration of SQL Server 2005 / 2008 components

- Regular overview on the performance of Database queries using

Profiler and Event Viewer graphs.

- Configured Log shipping for the disaster recovery plan in SQL

server2005.

- Check SQL Server jobs (look for failures) and the SQL Server logs

for error messages

- Monitored database status including CPU, memory, I/O, space, and

dead lock using SQL Server Utilities

- Managing Logins, Users, Roles and User permissions.

- Used 3rd party tools like Quest LiteSpeed in taking the backups to

optimize performance.

- Responsible to releases from development to test to production

environments

Environment: SQL Server 2000, 2005 and 2008, Windows Server 2003,

Enterprise Manager, SSMS, Query Analyzer, SSIS, SSRS. T-SQL, C++, Microsoft

Active Server Pages (ASP), Java Scripting

Client: MULTIPLAN, TN, USA

Position: SQL Server Database Administrator

Duration: SEP'06 - AUG'09

Project: Database Administration

Synopsis: Multiplan is the nation's oldest and largest supplier of

independent, network-based cost management solutions. We have almost

900,000 healthcare providers under contract, an estimated 57 million

consumers accessing our network products, and 110 million claims processed

through our networks each year, giving us more of the experience and

resources healthcare payers and providers need to face today's

unprecedented cost and competitive pressures. Multiplan clients and

providers benefit from a service program designed to blend the best of both

local, people-driven and centralized, system-driven organizations. The end

result is a highly focused service team for day-to-day / business service

needs.

Responsibilities:

- Building SQL Servers to create and deploy new databases

- Handling backup process, writing the automated jobs for taking the

weekly full backup, daily differential backups and hourly

transactional backups

- Performing the ETL operations to support the data loads and

Transformations.

- Created and maintained the knowledge base system for all the

application databases

- Implemented automated backup and database maintenance / cleanup

jobs

- Create backup and recovery plans using 3rd party backup tools such

as Quest LiteSpeed

- Imported Data from text files and excel spread sheet into SQL

Server 2000 database using DTS package.

- Managing Logins, Users, Roles and User permissions.

- Installation of SQL server 2005 on Development and Production

Servers, setting up databases, users, roles and permissions.

- Running Trace from the Profiler to trouble shoot database and

running DBCC consistency checks for other database maintenance

aspects.

- Making required schema changes

- Implemented log-shipping and transaction replication in DR process

plan.

- Set up SQL Mail and Created Jobs to Automate & Scheduled many tasks

- Had good experience in 24/7-production support.

Environment: MS SQL Server 2005, Windows 2000, Windows NT 4.0, SSMS. SQL

profiler, Performance Monitor (PERFMON), MS Active Server Pages (ASP), Java

Scripting

Client: Family Health Plan Limited - FHPL, India

Position: SQL Server Database Administrator

Duration: SEP'04 - AUG'06

Project: Database Administration

Synopsis: Family Health Plan (TPA) Ltd (FHPL) is pioneering as one of the

best Third Party Administrators in Health Insurance sector for providing

quality assistance to core groups of health care industry. FHPL is licensed

by Insurance Regulatory Development Authority of India and acts as a nodal

agency between the core groups of health care industry. The core groups are

Insurance companies, insured members (Policy holders)) and Hospitals

(healthcare service providers). FHPL ensures quality health care and

bridges the gap between the sources for rendering the right service, at

right time, to the right person, at a right price

Responsibilities:

- Maintaining the production database servers.

- Monitoring the growth of the database to ensure the smooth running

of daily activities.

- Taking full / differential database backups of all system and

production databases.

- Taking back up of system databases whenever changes are made to the

system databases or updates and service packs are applied to the

SQL Server

- Check the Windows 2000 Event Viewer for error messages.

- Check for adequate disk space for growing database files and log

files.

- Check SQL Server jobs (look for failures) and the SQL Server logs

for error messages.

- Controlling and monitoring user access to the database

- Import and Export data from one database to another database or to

another server using DTS

- Remove extra-unused space from the data and log files

- Evaluate possible approaches to increasing application and server

performance, based on the knowledge obtained from daily operational

activities

- Requirement gathering and analyzing data sources

- Assisted in design and implementation of Database

- Installation and configuration of SQL Server 2000 and 2005

- Design and implementation of Backup policies and Recovery

procedures

- Created stored procedures and triggers

Environment : SQL Server 2000 and 2005, Windows 2003, T-SQL, XML, Java

Scripting, Visual Basic and Microsoft Active Server Pages (ASP)[pic]

Contact this candidate