Sql Server Manager

Kanala

Email : *******@*****.***

Ph.no : 714-***-****

SQL server Database Administrator

Professional Summary :

. Senior SQL server DBA with 7 plus years of experience on SQL server

(7.0/2000/2005/2008) Database Administration on standalone and cluster

server operating Systems like Windows 2000/2003 NT/2008.

. Supported the system 24*7.Ability to work beyond regular hours.

. Extensive knowledge in tuning T-SQL queries (DML, DDL) to improve the

database performance and ability.Created various database maintenance

plans.

. Identified long running queries, resolved blocked and locked objects

issues.

. Created Clustered, Non-Clustered Indexes and constraints to the

frequently used tables in application.

. Reviewed and optimized queries using DTA Wizard to help dev teams to

achieve better performance.

. Documented solutions to database issues

. Created maintenance plans to perform index de-fragmentation, re-indexing

and updating the index statistics.

. Experience in writing distributed queries in between the servers.

. Experience in Handling Very Large Database(VLDB). Expertise with Table

Design, Index Design and Performance Tuning.

. Involved in optimizing code and improving efficiency in databases

including re-indexing, updating statistics, recompiling stored procedures

and performing other maintenance tasks.

. Expertise in database backup & recovery, disaster recovery procedures,

High availability (Clustering, Replication, Log shipping and Mirroring.)

. Experience in designing and development of disaster recovery planning

using mirroring and log shipping.

. Good experience in cluster environment (Active/passive).Installing and

configuring SQL server in a cluster.

. Created SSIS / DTS packages to pull data from Flat Files.

. 3+ years of experience in Replication Environment for setting up and

configuring replication

. Experience in OLTP, OLAP technologies.

. Creating and maintaining Documentation including Data Dictionary.

Certifications :

MCTS Microsoft Certified Technology Specialist

MCDBA Microsoft Certified Database Administrator

MCITP Microsoft Certified IT Professional

Education :

Bachelor's in computer science

Technical Skills:

RDBMS SQL Server 2008/2005/2000/7, Oracle 9i

SQL Server Tools SQL Server Enterprise Manager, T-SQL, SQL Server Profiler,

SQL Server Query Analyzer, Import/Export Tools, SQL Server

Agent, SQL Jobs, SQL Server Management Studio, Database

Maintenance Plan, DTA, Database mail.

ETL Tools Business Intelligence Development Studio (SSIS, SSAS,

SSRS), Data Transformation Services (DTS), DBCC, BCP.

Operating Systems Windows NT, Windows 2000 Server, Windows 2000 Advanced

Server, Windows 2003 Server, Wintel 2003, Windows XP

Professional/Standard, Windows Server 2008(Hyper-V ),UNIX.

Internet Tools HTML, XML.

Backup tools VERITAS, Snap manager, light speed.

Networking TCP/IP, SAN, Ethernet

Expericence :

Netapps (CA, US)

5/2010- Till now

_______________________________________________________________________

Production DBA

. Configured and Installed SQL server 2005/2008 on Windows 2003/2008.

. Also installed service packs and hot fixes for SQL Server.

. Provided appropriate access to client except system databases owners

and Client will have access to their respective needed application

schema owners.

. Database creation for dev and production servers.

. Created database backup/restore scripts for full, Differential and

Transactional backups and scheduled jobs for DBA automation tasks.

. Analyzed long running /slow queries and tuned the same to optimize

application and system performance. Intensively used DBCC commands,

SQL Profiler, Trace Analysis and Execution plans as part of trouble

shooting and performance tuning. Rebuilt the indexes at regular

intervals for better performance.

. Prepared daily reports on the job failures, backup failures and disk

space. Monitored the event logs and server error logs for

troubleshooting.

. Responsible for setting security at OS level and Database level by

creating users with appropriate privileges to access a database. .

. Up gradation of Databases from SQL Server 2000 to 2005 and 2008.

. Table migration from one database to another database.

. Table partition for better performance.

. Used Import /Export wizard to move data from one table to another

table with in the server.

. Involved in designe and implemented a disaster recovery system.

. Implemented & managed SQL server 2008 clustering as per client

requirement.

. Database refreshes and restoration.

. Database recoveries as per requirements.

. Conducted root cause analysis for database incidents and problems.

. Participated in designing, testing and implementing an enterprise

Disaster Recovery Plan.

. Monitored data activities (i.e. database status, logs, space

utilization, extents, locks and long transactions).

. Suggested Application level tuning changes for code, queries, SQL

objects which may not be performing up to the optimum database

performance standards.

. Provided overall configuration and change control management for data

base components.

. Escalated database issues to appropriate approvers (if applicable).

. Conducted research and collaborated with vendor if necessary for

additional patches.

. Handled table and Index partitioning for large tables in SQL Server

2005 and 2008.

. Expertise in MSSQL SERVER Database Administration.

. Set up Log Shipping, MSSQL Mail, Alerts, and Operators.

. Created, administered & maintained SQL Server Databases (Production,

Development, env).

. Involved in Fine Tuning the Procedures After studying the Processing

time through SQL Trace.

. Monitor Performance issues like CPU bottleneck, Memory bottleneck,

Disk space bottleneck, Slow running queries, Dead Locks, Blocking.

. Find out performance issues with Perfmon, Profiler, DMVs, DBCC,

counters. Tune then to get better performance.

. Index defragmantation of indexes.

. Modified & created Indexes, Optimizing Indexes.

. Migrated data from various sources such as MS Access, flat files etc.

Environment: SQL 2008/2005/2000, Windows 2003/2000 /2008

LISCR (NY)

3/2008 - 5/2010

SQL DBA

Roles & Responsibilities:

. Installation and configuration of SQL 2008 on windows 2003and 2008,

apply appropriate service packs to SQL Server.

. Created logins, Users in SQL Server.

. Installation and configuration of backup tools

. Running SQL Services to domain account, and make sure SQL servers

passed through all security checks.

. Worked on Oracle servers

. Performed all the Database related activities such as Database Backup,

Restore Operations, and Troubleshooting Issues when occurs.

. Routine Hourly, daily, weekly and monthly database backups and

rebuilding indexes and running of update statistics on PROD databases.

. Setup SQL Server 2005 Database Mirroring to maximizing availability of

PROD databases

. Implemented Transactional Replication especially peer to peer

replication on Production and dev servers.

. Provided & managed support to Environment of more than 500 Database

Servers.

. Proven ability to handle Database of more than 1 TB in Size.

. Worked on change managements, incident management, Tivoli, MOM.

. Performance Tuning, monitoring error logs, jobs etc.

. Involved in Stored Procedures Tuning .Performance and Query tuning

Activities

. Troubleshooting client connectivity issues and application

connectivity issues

. Monitoring Server Performance and Activities. Tuning Queries, created

necessary indexes.

. Manage and maintain database changes in Development and Production.

. Created Application Roles, assign required permissions Database Users.

. Trouble shooting of maintenance jobs on Prod & DR servers.

. Update statistics on the tables to improve performance.

. Using SQL Profiler, Tuning Queries to improve performance. Worked on

Performance issues like CPU bottleneck, Memory bottleneck, Disk space

bottleneck, Slow running queries, Dead Locks, Blocking.

. Created clustered and non-clustered indexes.

. Tune the slow running queries.

. Troubleshooting Blocking and Dead lock issues.

. Find the index fragmentation levels and rebuild or reorganization the

indexes depend on fragmentation levels.

. Interaction with application team to resolve performance issues with

application.

. Monitoring stored procedures and queries.

. Worked on Dead Locks and Blocking.

. Extensive use of performance tools.

. Log files shrinking in case of disk space reached threshold value.

. Installation,configuration and maintenance of SQL 2008 clusters

. Experience in performing database consistency & Integrity checks sing

DBCC.

. Providing 24 * 7 Production Support for SQL Server Prod Servers.

Environment: SQL 2005/2000/2008, Windows 2003/2000 /2008, Varitas net

backup tool, BMC Remedy

IBM (India, Hyderabad)

8/2005 -12/2007

Database administrator

Roles & Responsibilities:

. Installation & configuration of SQL Server 2005.

. .Created databases using T- SQL Statements, SSMS

. QA and SA done for Quarterly.

. Applied patches to SQL server.

. Security Administration Tasks like creating users, assigning

responsibilities.

. Databases creation on Prod and Test servers. Administering SQL 2000

and SQL 20005 Server Securities.

. Before moving servers to production support. Done all tests on SQL

server side and Databases side

. Up-gradation of SQL databases from SQL Server 2000 to SQL Server 2005.

. Migration of Databases from one server to another server.

. Moved Database from one location to another location in SQL Server.

. Client connectivity issues troubles hooted.

. Backup databases and perform database restores and run consistency

checks for SQL Databases.

. Created Databases and Database Objects like Tables, Stored Procedures,

Views, Triggers, user defined data types and functions. Schema

Changes to the database as per application team requirement.

. Monitor the Server performance when application team loading the data.

. Tune the queries in performance issues; help the application team to

give optimal query plan.

. Index Management to enhance better performance.

. Analyzed long running queries and tune the same to optimize

application and system performance.

. Monitor and resolved performance issues like CPU bottleneck, I/O

bottlenecks, Memory bottlenecks, slow running queries, dead locks

using tools.

. Created Table, Clustered, Non-Clustered Indexes and constraints to the

frequently used tables in application.

. Major activities include monitoring Database servers, to ensure jobs

are successfully completed.

. Created Cluster and non-cluster indexes.

. Monitor the status of Maintenance jobs - schedule to run daily and on

weekly .

. Experience in performing regular Backups and scheduling tasks.

. Installed and worked on SQL 2005 Cluster setup. And Documentation on

Cluster setup.

. Maintained SQL 2005 cluster servers.

. Configuration of transactional replication on SQL servers and

Troubleshooted Replication issues.

. Installed and configured SSRS and SSAS services on Clustered and Non-

Clustered servers.

. Worked on Incident, problem and change management, SCOM.

. Extensive use of BMC Remedy tool and lotus notes, DSS.

. Have basic level of Exp on Oracle.

. 24/7 support.

Environment: SQL 2005/2000, Oracle, UNIX, Windows 2003/2000

ITC (India, Bangalore)

8/2003 - 7/2005

Jr SQL DBA/Developer

Roles & Responsibilities:

. Managing of database objects like Tables, views, indexes etc.

. Working on change requests.

. Login creation and assign permissions to users.

. Moving databases from dev to production.

. Restoration of databases to different locations.

. Implementing Backups and restoration of Databases.

. Developed DTS Packages to transfer the data between SQL Server database

and files.

. Used BCP utility to publish table output to text files.

. Data transfer from flat files, ex-cel to SQL server.

. Used SQL Profiler to monitor the server performance, debug T-SQL and slow

running queries.

. Extensively used Joins to get data from multiple tables.

. Documented daily tasks & operations.

. Client connectivity issues troubleshooting.

. Maintain SQL server security, auditing databases.

. Created backup scripts and restoration scripts.

. Login creation and assign permissions to logins.

. Installation of SQL servers and configuration.

. Applying service packs on SQL servers

. Change server settings if required.

. Jobs creation for maintenance of databases.

. Troubleshooting jobs and check jobs are running according to schedule

. Index creation, Index Analysis and Performance Tuning.

Environment:

SQL Server 2000, Enterprise Manager, Windows 2K, Query Analyzer, SQL

Profiler, DTS, T-SQL, BCP, Stored Procedures

Contact this candidate