Sql Server Data
Resume:
Lakshmi Datla
*******.***@*****.***
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