Lakshmi Datla

469-***-****

acfyh1@r.postjobfree.com

Professional Summary

* ***** ** ** ********** in SQL Server database admin, System Analysis, Design and Development and

Support of Microsoft SQL Server2012/2008 R2 / 2008 / 2005 / 2000 in Development, Test and

Production Environments on various business domains like Financial, Insurance and Manufacturing.

• Hands on experience in Installing, Configuring, Managing, Monitoring, Troubleshooting, Upgrading

and Migrating SQL Server 2012/2008/2005/2000 on Clustered and Standby Environments.

• Migration from SQL server 2000 to 2005 and 2000/2005 to 2008 by using In-Place upgrade

process and as well as side-by-side upgrade process, And documented the Upgrade Process and also

expert in migrating DTS packages to SSIS Packages

• Experience in implementing and Monitored different types HA and DR scenarios like Replication, log

shipping and Configure Database Mirroring in Cluster Environment on Production, QA and Dev

environments.

• Configured the servers on 32 bit and 64 bitclustered and standalone server environments.

• Experience in supporting Very Large Database (VLDB) more than 2TB and troubleshooting problems

• Expertise in Database Backup and Recovery procedures by using Native, TDP/TSM and LiteSpeed

to/from Disk /Legato server (Tape).

• Very Good Experience working with SCOM Monitoring

• Extensively used tools like SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor

for monitoring and tuning MS SQL Server performance.

• Experience in usingPerformance Monitor/Profilerto resolve Dead locks /Long running queries. And

also good experience in data (table) partitioning.

• Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database

Consistency Checks using DBCC Utilities and DMV’s and DMF’s, Re-indexing, Updating Statistics

and online indexing.

• Experience in data modeling like physical data modeling and logical data modeling by using ERWIN

tool

• Expert in data warehouse modeling (designing Star Schema, snowflake schemas with identifying

Facts and Dimensions).

• Expertise in writing Stored Procedures, Functions and Triggers using T-SQL and also expert in tuning

Complex Queries.

• Good experience on physical storage configuration and optimization of SAN/NAS/DASD with

different RAID levels.

• Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related

errors.

• Checking the threshold values and baselines and monitoring in Perfmon and SCOM

• Created linked servers between SQL Server 2000 & Oracle 9i, 10g & 11g and Teradata and DB2.

• Expertise on Business Intelligence Tools to Create SSRS Reports, SSIS Packages and SSAS with

OLAP.

• Expertise in implementation of security models; Database authentication modes, creation of users,

configuring permissions and assigning roles to users.

• Expertise in performing data transformations between servers using BCP, DTS, SSIS and bulk insert.

And also Expert in using DMV’s, DMF’s.

• Good understanding in database and data warehousing concepts (OLTP & OLAP). Experience with

logical and physical data modeling and database design using Erwin.

• Experience in managing Alerts, Operators and Jobs through SQL Server Agent.

• 24 X 7 Production Database on Call Support.

• Strong Technical background with excellent problem solving and communication skills. Strong time

management skills and excellent team player with reputation of integrity and an ability to work on

multiple technologies.

Education

Bachelor of Technology in Jawaharlal Nehru Technological University, Hyderabad, India

Technical Skills

SQL Server Reporting Services (SSRS) 2000/2005/2008R2/2012, Crystal

Reporting Tools

Reports, Cognos Framework Manager, Report Studio

Database Tools SQL Server Management Studio (SSMS), SQL Server Business Intelligence

Studio (BIDS), Enterprise Manager, SQL Profiler, Query Analyzer

ERWIN, MS Visio

Data Modeling

Windows 98, Windows 2000 Advanced Server/Professional, Windows Server

Operating Systems

2003, Windows NT, Windows XP Professional/Standard, Windows Vista

Business/Ultimate, Windows 7 Ultimate

PROFESSIONAL EXPERIENCE

Bally Gaming Inc., Pleasanton, CAApr 2010 – Till date

SQL Server DBA

Bally Technologies provides the global gaming industry with innovative games, table game products,

systems, mobile, and iGaming solutions that drive revenue and provide operating efficiencies for gaming

operators.

Responsibilities:

• Upgraded Servers from SQL server 2008 to SQL server 2012 and installed service pack

• Installed and configured SQL server 2008 and administered.

• Migrated Databases, DTS packages, from SQL Server 2000 to SQL Server 2008.

• Involved in creating Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views,

Functions and Stored Procedures.

• Involved in general Database administration, query performance tuning and validated some of the

existing schemas

• Responsible for maintaining all database environments Development, Testing, QA, Staging, and

Production.

• Administering SQL Server security and apply security across environments and trouble shoot security

issues on daily basis.

• Administered the SQL server 2000/2005/2008 by creating user logins, dropping and locking the

logins, monitoring the user accounts, creating groups, granting privileges to users and groups.

• User management by assigning appropriate permissions to the database users.

• Experience in upgrading SQLServer and applying service packs and hot fixes and unattended

Installations.

• Experience in handling the situations in change control process.

• Involved in database administration tasks and assisting developers with problems and SQL

optimization.

• Monitored, Scheduled jobs and alerts and did troubleshooting when failed on daily basis.

• Experienced working on SQL COMPARE tool to compare the structures between databases in order

to synch them

• Expertise in Setting up database backup and recovery procedures for production, QA and

development servers.

• Installing SQL Server 2008 in windows Cluster environment.

• Worked onSQL Server Clusters Active - Passiveon mission critical financial applications .

• Development of automated daily, weekly and monthly system maintenance tasks such as database

backup, database mirroring, replication verification, database integrity verification and indexing

updates and apply in development and Testing Environment.

• Involved in migrating database from oracle 11g to sql server 2008.

• Actively involved in data warehousing of the Sybase database onto SQL SERVER 2008.

• Experience with Dropping and recreate the tables for the damaged databases to avoid data loss.

• Refresh the database from production to development and staging environment on daily basis.

• Involved in the Backup & Restore and point in time recovery of the databases.

• Responsible for developing, monitoring and deploying SSIS packages.

• Loaded data from various sources like flat files, to SQL Server database Using SSIS Package.

• Configured SQL mail agent for sending automatic emails when a SSIS packages is failed or succeed

• Used Lookups Transformation to get the data from reference data sets.

• Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively

monitoring the performance of SQL Server databases.

• Involved in the Query optimization and Performance tuning, and also tuned SQL queries using Show

plans and Execution plans.

• Write SQL views against source tables in Oracle with business rules applied.

• Created permanent tables, temporary tables and table variables.

• Responsible for handling in high available clusters such as fail over clusters.

• Conducted design reviews with users/team for development and production strategies.

• Experience in handling in SOA environment.

• Translating business requirements into technical design specifications and actively supported business

users for change requests.

• Developed DTS and SSIS packages to extract, transform and load (ETL) the data using SQL Server

2008 Integration Services and successfully completed DTS to SSIS conversion

• Capacity-planning, Maintaining run book documentation on all the servers in word, pdf and excel

formats.

• Involved in handling onsite-offshore model.

• On call 24/7 support to databases on weekly rotation.

Environment:

SQL Server 2012,2008 R2/2005/2000, Windows 2003\2008 64bit\32bit, VMware ESX\Vsphere5.1 lit

speed, SQL backup5 Red Gate, SQL secure, ETL, SSIS, SSRS, C#., VB,ASP.NET,SSAS, System

Monitor / Performance Monitor, VMware ESX, Share point 2007, Biztalk, TFS 2008,Microsoft Network

monitor 3.4.

Social Interest Solutions, Sacramento, CA May 2009 – Apr 2010

SQL SERVER DBA

Social Interest Solutions (SIS), a mission-driven, nonprofit organization dedicated to leveraging

technology innovation to improve consumers’ access to eligible health and human services.

.Responsibilities:

• Installation and Maintenance of SQL Server 2008 on Test, Development and Production

Environments.

• Implemented Database Mirroring and Transactional Replication as a part of DR plan.

• Created a mirrored database on the report server using Database Mirroring with high performance

mode.

• Using Red gate SQL Compare tool to compare code in development and production environments.

• Involved in migration of MS SQL Server 2000 to MS SQL Server 2005, 2008.

• Installation of SQL Server 2005 on Standalone and Clustered Environments.

• Assisted in Deploying 2 Node failover clustering.

• Maintained and supported Clustered Windows Environment.

• Handled Clustering between two Production Servers and performed daily backups and developed

recovery procedures.

• Configured Server for sending automatic mails to respective people when SSIS process fails.

• Created, built and deployed successfully SSIS packages by using BIDS.

• Migrated DTS packages to SSIS 2005 packages.

• Used SSIS packages to transfer the data from legacy systems to SQL Server 2005.

• Administered the MS SQL Server by creating User Logins with appropriate Roles, dropping and

locking the logins, monitoring the User Accounts, granting and privileges to users.

• Taking daily database backups by using Idera SQL safe backup tool .

• Modify Stored Procedures and complex T-SQL Queries to improve query execution process.

• Configured Mirroring and Transactional Log Shipping between Primary and Secondary Servers

depending on the business requirements.

• Implemented and Maintaining Replication. Generate every day morning Replication reports from

branch SQL Servers and Resolve Issues.

• Implemented Transactional Replication between Primary and Secondary Servers.

• Created Linked Server between SQL Servers.

• Worked with SQL Profiler/SQL Trace to Generate Traces.

• Created jobs, Database Maintenance Plans and scheduled jobs according to requirements using SQL

Server Agent.

Environment:

MS SQL Server 2000, 2005, 2008, Windows Server 2003, 2008

Cardinal Health, Piscataway, NJ Jan 2008 – May 2009

SQL SERVER DBA

Cardinal Health is a Fortune 21 company that improves the cost-effectiveness of healthcare. As the

business behind healthcare, Cardinal Health helps pharmacies, hospitals and ambulatory care sites focus

on patient care while reducing costs, improving efficiency and quality, and increasing profitability.

Responsibilities:

• Create and maintain various databases for Production, Development and Testing Servers using MS

SQL Server 2005/2008. Planning the location of data, indexes, and Transaction log files on the disk.

• Install and configure SQL Server 2005/2008 on the server and client machines, provide connections

and manage databases.

• Assisted in Upgrading SQL Server 2000, 2005 databases to SQL Server 2008.

• Planning, Implementing and troubleshooting Replication.

• Involved in planning and monitoring Log Shipping.

• Involved in SQL Server Hardening.

• Use of DBCC Utilities to maintain the consistency and integrity of each database in the production

server.

• Conducted root cause analysis of application availability and narrow down the issues related to

coding practices, database bottlenecks, network latency and Resolve locking and blocking issues.

• Configured up to 32 GB of memory.

• Tuning the Production server to get the performance improvement.

• Running Index tuning wizard for optimal query performance.

• Implemented Database Mirroring as part of disaster recovery plan.

• Implementing and Monitoring Transactional Replication and other SQL Server jobs using custom

scripts.

• Reviewed third party tools to automate routine tasks such as monitoring, blocking and consolidate

status of scheduled jobs.

• Monitoring SQL Server LOGS, Application logs and analyzing the logs.

• Providing 24*7 supports to SQL application developers in implementing the applications on

production server.

• Maintaining both DEV and PRODUCTION Servers in sync.

• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for

various categories of users.

• Creating Backup strategies and scheduling them as a part of database maintenance plans.

• Environment:MS SQL Server 2000, 2005, 2008, Windows Server 2003, Windows 2000-Advanced

server NT, XML.

Contact this candidate