Jr. Sql Server DBA

Kandula, Sree Vijay

210-***-****, ****************@*****.***

Career Summary

• Having nearly 2 years of experience in a fast paced environment as a Database Administrator for VLDBs (Over 19 TB) in SQL Server 2008R2/2008 and SQL Server 2005/ 2000/7.0 over the Windows 2000/2003/2008R2.

• Cultivating SQL Server 2012 (Denali).

• Proficiency in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.

• Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery planning and Security Management. Configured Service Broker and Table partitioning.

• Implemented the new SQL Server 2005 / 2008 concepts like Data partitioning ,Snapshot isolation, database mirroring, DDL triggers, Online indexing, DMV’s, DMF’s, Mail Setup, Jobs, and Alerts, DTA, SQLCMD, dedicated admin connection, MERGE statement.

• Worked on High Availability atmosphere (Active-Active/Active-Passive Cluster, Transactional Replication). Mirroring, Log Shipping and Replication. Evicting (dropping) nodes and adding node in cluster 2005/2008. Documentation and Inventory maintenance for various SQL Servers.

• Used Perfmon, profiler, DTA(Database Engine Tuning Advisor), DMV’s and DMF’s for troubleshoot performance problems, fine-tuning of databases, for finding long running queries and index analysis. Worked on 32 and 64 bit SQL Server and MSCS Configurations.

• Extensively Worked on Transactional Replication, Snapshot Replication and Merge Replication.

• Handled multiple SQL Instances on Cluster for Server Consolidation projects built on SAN using RAID levels. Worked on SQL Server 2008 migration from SQL Server 2000 and 2005.

• Worked on configuring SQL Server in Single user mode and Minimal Configuration Mode.

• Data modeling experience in Physical and logical data modeling by using Erwin and VISIO.

• Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support. Extensive usage of Proactive Monitoring tools of SQL Server.

• Handling Memory configurations, SQL Server 2000/2005/2008 on Windows 2000/2003/2008.

• Sound knowledge stored procedures, Indexed views, User Defined Functions (UDL), Triggers, Distributed Queries and Common Table Expressions, UDFs.

• Experience in Batch processes, SSIS, DTS, BCP (bulk copy), Bulk Insert, Import, Export, Backup, Database Monitoring tools and Application support.

Education

• Masters in Computer Information Sciences from ST Mary’s University, San Antonio, TX. (2008 - 2010)

• Bachelor of Computer Science and Information Technology from Jawaharlal Nehru Technological University, Hyderabad, India. (2003 -2007)

Technical Acquisitions

RDBMS MS SQL Server 2000/2005/2008/2008R2,Access,Oracle 10g

Tools Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Data Transformation Services, Upgrade Wizard, Replication, Performance Monitor, Visual SourceSafe, TFS, Litespeed, Idera SQL Safe, Idera SQL Compliance Manager, Idera SQL Diagnostic Manager, Redgate SQL Compare, Redgate Data Compare.

Programming SQL, TSQL, XML,MDX

Scripts MDX, HTML and XML.

Web Tools Coffee Cup, Macromedia Suite, IIS, Outlook Express.

Operating systems Windows 9x/NT/2000/XP/2003/2008/2008R2.

Professional Experience

REDBOX, Oakbrook terrace, IL Jun 2011 – Till Date SQL Server DBA Contractor

Redbox is the fun, fast, easy way to rent the latest new release movies on DVD or Blu-ray Disc® and the top new release and family video games.

Responsibilities:

• Monitored and modified Performance using execution plans and Index tuning.

• Checking Database Health by using DBCC Commands and DMVS.

• Database objects migration – Transfer and synchronize data records, triggers, SPs, tables, databases, SQL Server agent jobs, DTS packages, etc. amongst different SQL Servers promptly and with minimum supervision. Worked extensively on Idera Tools and Redgate Tools.

• Performance tuning – Identify performance bottlenecks (i.e. poor written queries, hardware issues, etc.) and recommend corrective course of action.

• Update statistics, Fragmentation info, database integrity check and Backup operations.

• Monitoring SQL server performance using profiler, dealt with blocking and deadlocks.

• Extensively worked on trouble shooting and fine-tuning of databases for its performance.

• Demonstrated expert understanding of database performance tuning, data backup, recovery and security processes/ procedures. Installed, configured, upgraded, and maintained all database systems. Worked with DBs over 13 TB in Size.

Environment: SQL Server 2005/2008/2008R2/Denali SQL 2012 with Mirroring, Replication, Windows 2000/2003/2008/2008R2 64-bit, Idera SQL Safe, Idera Compliance Manager, Idera Diagnostic Manager, REDGATE SQL Compare.

JMC Steel Group, Sharon, PA Feb 2011 – May 2011 SQL Server DBA Contractor

The JMC Steel Group was founded as the John Maneely Company (JMC) in 1877. It started as a distributor of pipe, values and fittings in Philadelphia, Pa. and grew into one of the largest independent steel pipe and tube distributors on the East Coast of the U.S.

Responsibilities:

• SQL SERVER 2008 R2/2008/2005/2000 Production Environment with SAP as the Front end.

• Mainly Migrated databases from SQL Server 2000 to SQL Server 2008 R2.

• Handling 32 bit and 64 bit Memory configurations for SQL Server 2000 on Windows 2000 and SQL Server 2005 on Windows 2003 and SQL Server 2008 R2 in Windows 2008 Server. Prepared Documentation for the Disaster Recovery plan.

• Created Documentation for upgrading the SQL server 2000 to SQL server 2008 R2. And also Inventory maintenance of all SQL Servers. Configured more than 2 GB ram on 32 bit Environment. Setup countless LINKED SERVERS and resolved Issues with MSDTC.

• Recovered the System and User databases from suspect mode. Expert in sizing Temp DB. Used /AWE, /3GB and /PAE switches. Excellent understanding over ODBC providers.

• Written Stored Procedures and (DDL /DML) Triggers, Functions as per client requirements.

Environment: SQL Server 2000/2005/2008/2008R2 with clustering, Replication, SAP, T-SQL, Windows 2000 32-bit/2003 64-bit, Backup Exec tool for backups.

Office Depot, Boca Raton, FL Dec 2010 – Jan 2011 SQL Server DBA Contractor

Office Depot, Inc. is a global supplier of office products and services.

Responsibilities:

• Supported more than 50 production boxes spread all over the world with multiple clusters and complex replication topologies in the High OLTP production environment.

• Database objects migration of data records, triggers, SPs, tables, databases, SQL Server agent jobs, DTS packages, etc. amongst different SQL Servers promptly and with minimum supervision. Create and maintain standby databases and/or log-shipping, Setup Mirroring.

• Installation, Migration, upgrading, patching and capacity Planning of Microsoft SQL Server suite of products (7.0, 2000, 2005, 2008). Worked on databases of size over 2 TB.

• Performance tuning – Identify performance bottlenecks (i.e. poor written queries, hardware issues, etc.) and recommend corrective course of action. Table partitioning large tables.

• Windows Operating System – Diagnose and troubleshoot OS components that may impact SQL Server availability, such as memory, CPU, disk space, security, etc.

• Proficiently used OS tools such as Perf Mon, Computer Management, Event Viewer, etc.

• Windows Clustering – Support active/active and active/passive clusters. Manage cluster resources and troubleshoot errors.

Environment: SQL Server 2008R2/2008/2005/2000/7.0, IIS, Windows 2008/2003/2000 Server, Performance Monitoring, LiteSpeed Backup Utility, T-SQL.

Contact this candidate