SQL Server DBA
Resume:
Lalitha Mareddy, MS SQL Server DBA, Database Engineer
****, ****** *********, ****** *******, CA 95742
*******.*******@*****.***
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