Lalitha Mareddy, MS SQL Server DBA, Database Engineer

****, ****** *********, ****** *******, CA 95742

acog8w@r.postjobfree.com

916-***-****

Summary: Database Administrator (DBA) with 12+ years of extensive experience designing, building, and

supporting database solutions in SQL Servers environments. Proficient in designing data models for high

performance, Translating client feedback into technical requirements with effective interpersonal,

presentation, communication, problem solving skills.

SQL Server Database Administrator 10+ years of extensive experience in

SQL Server 2005, 2008, Data modeling (Physical and Database Mirroring

2008 R2, 2012 logical design of database

SQL server migrations Back-up and Restore Database Replication

management

SQL Server Installation Design for Disaster recovery SQL Performance tuning –

(Cluster and stand alone) & High availability Database growth

management & Long running

queries

Tools DB artisan, LiteSpeed, SQL Security Database partitioning

ApexSql

ITIL framework & service SQL Server reporting SQL Jobs management &

management tools services – administration DTS packages

Data transformation tools – T-SQL development – DDL, Database health monitoring

BCP, Bulk inserts, ETL DML, Stored procedures,

support functions, Triggers

Expertise in working under high pressure environment - L1/L2/L3 service management

CERTIFICATIONS

MCTS :Microsoft SQL Server 2008 – Implementation and Maintenance

MCTS:Microsoft SQL Server 2008 – Business Intelligence Development and Maintenance

MCITP:Database Administrator 2008

ITIL Foundation Certificate (An entry-level professional qualification in IT Service Management)

Employment History:

Sr.Database Administrator (current job) Feb 2015 – present Appisoft Inc.,

NJ,USA

Sr.Database Administrator Oct 2011 – Jan 2015 Thomson Reuters,

India

Sr.Software Engineer - Database Jun 2010 – Nov 2010 Avanade, USA

Lead SQL Database Administrator Nov 2005 – Aug 2008 Stratify software,

USA

Lead SQL Database Administrator Nov 2002 – Nov 2005 Infosys, India

Software engineer Jul 2000 – Oct 2002 Infosys, USA

Professional awards

Best Employee For Valuable Contribution for implementing replication mechanism for corporate

databases from Infosys in 2005

Best Employee For Valuable Contribution for designing in-house application database from Infosys

in 2004

Best Employee For Valuable Contribution for implementing disaster recovery strategy from Infosys

in 2003

PROFESSIONAL EXPERIENCE

Employer Name Appisoft Inc, USA

Start Date: Feb-2015 End Date: Present Job Title: Senior Database Administrator

Responsibilities:

Involve in design, planning and maintenance of database systems

Ensure up-to-date patches applied and tested in all environments (dev, test and prod)

Troubleshooting database issues and performance tuning

Optimal configuration of user and system databases.

Maintain backup strategies and maintenance plans.

Employer Name Thomson Reuters, India

Start Date: Oct-2011 End Date: Jan-2015 Job Title: Senior Database Administrator

Responsibilities:

Resolving day to day database incidents and coordinating with application development team to take

necessary measurements that avoid recurring incidents.

Installing Multi node Cluster Failover SQL server

configuring high availability solutions such as database mirroring, replication

Tuning SQL server configurations for the optimum performance based on usage of various databases and

their data growth

Designing high speed reads and writes to database – table partitioning, creating appropriate indexes,

maintaining database statistics

SQL Server migration from SQL server 2005 to SQL server 2008

Monitoring database activities such as database growth, disk space requirements, logical / physical

fragmentations, blockings, locks, maintenance jobs to maintain uptime of the server with optimum

performance

Developing SQL scripts for monitoring, maintenance and reporting tasks

Employer Name Avanade, U.S

Start Date: Jun-2010 End Date: Oct-2010 Job Title: Senior software engineer

Responsibilities:

Meeting business analysts, program management team to understand functional and non-functional

database requirements

Documenting checklists for configuration management, incident management process and

availability of support etc

Participating in database design reviews to analyze data models and proposing areas of

improvements.

Developing SQL scripts for monitoring, maintenance and reporting tasks

Identifying and Analyzing long running queries and proposing areas of improvement to tune the

performance of such queries

Employer Name Stratify software, India

Start Date: Nov-2005 End Date: Aug-2008 Job Title: Lead SQL Database Administrator

Responsibilities:

Responsible for the delivery unit managing 35 database servers and handling 5 resources including direct

interaction with client

Developed custom business reports by writing stored procedures, functions etc

Monitored performance statistics of long running queries and analyzed query plans to tune SQL Query

performance

Responsible for installing, managing and administering SQL 2000/2005 database engine on production

instances

Created stored procedures, triggers, indexes in SQL 2000/2005 environments using T-SQL.

Resolved MS SQL full-text search issues in SQL Server 2000 environment.

Coached SQL developers to develop optimum T-sql queries.

Responsible for SQL security management supporting backend access to web applications, SQL Jobs and

hardening database server, windows 2003

Database maintenance like index rebuild, backup and restore plans, monitor full text catalogs.

Proposed recommendations for space management and monitoring.

Patch Management - Tested Hotfix/Service packs/Builds of Ms SQL server before applying to business

environment.

Implemented database mirroring (DBM)

Employer Name Infosys, India

Start Date: Nov-2002 End Date: Nov-2005 Job Title: Lead SQL Database Administrator

Responsibilities:

Implemented & maintained Clustering in Win2k/2K3 and Replication in SQL 2000

Interact with business users, analysts and perform database design reviews

Analyze IT incidents and generate relevant reports that helps improving project situation

Synchronize schema and data across Development, Testing and production environments.

Install, Manage SQL 2000 database engine on clustered production instances

Monitor SQL server and Windows Server performance using “Performance Monitor” tool.

Develop stored procedures, triggers, indexes in SQL 2000 environment using T-SQL.

Troubleshoot performance issues and fine-tune queries and stored procedures for SQL Server 2000.

Develop and maintain security model for database users

Analyze query plans to tune SQL Queries. Develop SQL scripts for gathering statistics for performance-

tuning benchmarking.

Make recommendations for space management and monitoring.

Employer Name Infosys, India

Start Date: Jul-2000 End Date: Oct-2002 Job Title: Software engineer

Responsibilities:

Work with team members to gather and interpret user/system requirements into design specifications

Analyze, design, build, and/or test new components or enhancements to existing modules

Design and code applications to functional and technical programming standards

Develop system specifications and interfaces for complex components

Create operational documentation for the application

Provide primary support for installation of application releases into production

Maintain applications according to SLAs

Technologies & Tools used: Visual studio Dev, classic ASP, VB, MS SQL server 2000, VBScript, JavaScript

Education

1996 – 2000

Bachelor of Engineering degree in Computer Sciences Engineering from Bharath Institute of Science and

Technology, Chennai (India).

Contact this candidate