KALVA LAVANYA

SOFTWARE ENGINEER

SR.SQL SERVER DBA/DEVELOPER

E-mail: adrr41@r.postjobfree.com

Phone: 804-***-****

SUMMARY:

** + years of experience working as a SQL Server Database Administrator.

Experience in Database Modeling includes Logical and Physical Design of Databases using Microsoft-Visio and Erwin.

Good knowledge in physical storage configuration and optimization of DASD/NAS/SAN with different RAID levels.

Experience in PL-SQL and T-SQL Programming skills includes writing Stored Procedures, Functions and Triggers.

Experience in Database Security includes creating Logins and Roles for users to access the database. Managed security logins and worked with Windows authentication, SQL server authentication and mixed modes.

Experience in writing Maintenance Plans for Full, Differential and Transactional Log Backups.

Experience with High Availability architectures includes setting up Database Mirroring with a witness server.

Experience in setting up Snapshot and Transactional Replication from Production to Report Server.

Expertise in Data/Table partitioning, indexing, rebuild indexes and Update statistics at regular intervals or after huge data manipulation queries for better performance.

Experience in query optimization & performance tuning using SQL Profiler, Performance Monitor, Execution Plan and DBCC Commands.

Created DTS Packages for Migrating data and Transformation. Experience in data migration from Oracle/Access/Excel Sheets to SQL Server 2005/2008/2012/2017.

Expertise in Installation, applying patches, configuring, Upgrade and troubleshooting of SQL Server 2008/05/00 on Windows Servers Clustered and Hyper-V environment.

Good knowledge on new concepts from SQL 2008/2012/2017.

Expertise in Using DTA, DMFs, DMVs and Performance dash board and database snapshot.

Expertise in handling blocking and dead lock situations.

Monitoring, Maintaining and scheduling Jobs, Alerts and scheduling DTS/SSIS Packages using SQL server Agent.

Expertise in writing Complex queries like MDX, DMX, XMLA.

Experience in writing Powershell scripts for copying the Trace Logs from Production to a FileShare.

Providing 24x7 on-call support.

Ability to work in a fast paced environment, Good team player. Helped the database and application developers on technical issues.

EDUCATION:

Bachelor in Computer science from JNT University.

Master in Computer science (Major Subjects on Database Design and Analysis)– Jan’10 – May’11 TECHNICAL SKILLS:

.NET FRAMEWORK C#. Net, VB.Net, ASP. Net, ADO.Net

LANGUAGES C# 2.0, C++, Visual Basic 6.0, C, Java Script, PHP. DATABASE SQL Server 2000/2005/2008/2012/2018, Oracle 8i/9i/10g/11g, MS- SQL SERVER TOOLS Access.

Query Analyzer, SSMS, SSRS, SSIS, BCP, SQL Profiler, Spotlight, Quest.

DEVELOPMENT TOOLS

WEB SERVERS

Oracle BI, Visual Studio, Dream Weaver, MS FrontPage, MS- Office, Photoshop, Visual Studio InterDev.

IIS and Apache.

REPORTING TOOLS SQL Reporting Services, Crystal Reports. OPERATING SYSTEMS MS Windows 2012/2010/2008/2003/7/XP/NT/2000, Red Hat Linux 3x, 4x, MS DOS.

Professional Experience

Champion Logistics, Northlake, IL Oct’14 to Till date SQL Server DBA/ Program Analyst/BI Developer

Responsibilities:

Perform and monitor database backups and restorations.

Database maintenance, applying software and windows patches & refreshing services.

Monitoring & maintaining database mirroring.

Tuning & optimization SQL queries, stored procedures and taking care of database performance.

Data conversions, database migrations and data loads.

Support for developers in test and production environments.

Configuring, maintaining and developing SSIS, ETL packages.

Configuring maintaining and developing SSRS reports.

Developing and maintaining SQL database object, TSQL and PLSQL stored procedures and Views.

Managing security, access control, permissions & privileges.

Constantly working on security issues and databases to improve security and reliability of the data structure.

Creating, Maintaining database Log shipping, Mirroring

SQL Server Migration to new versions.

Working with OTM reports.

Creating, scheduling Oracle BI reports.

Hands on experience on MICROSOFT DYNAMIC AX.

Use Datto cloud for disaster recovery.

Worked on Azure and AWS for cloud computing services. Humana, Louisville, KY Dec’13 to Jul’14

SQL Server DBA/ Program Analyst/Application DBA

Responsibilities:

Install and configure SQL server instances, check server performance and health.

Working on database replication and backups.

Co-ordinate database back-up and restore activities.

Monitoring and troubleshooting SQL Objects, Creating and deploying reports.

Configuring, deploying and maintaining database servers. Using Microsoft Visual Studio 2008/2010, writing relational and multidimensional database queries.

Configuring and deploying SSIS Packages from Test to Production Environments.

Analyze, plan and implement changes in the size of databases due to ordinary fluctuations in business growth

Maintaining the data dictionary and data models.

Tune and reorganize databases as required to maintain system performance requirements and in accordance with a schedule

optimize application performance

Analyzing and Designing Documentation, User requirements

Troubleshooting and fixing database issues to ensure data integrity and database performance.

Creating and maintaining SQL agent for scheduling jobs.

Manage user access and rights to database and reports. BrownGreer, PLC., Richmond, VA Jul’12 to Oct’2013

SQL Server DBA/ Program Analyst

Responsibilities:

Develop and execute SQL queries and Stored Procedures

Manage application database instances to support multiple development tracks, system testing, user acceptance testing, performance testing, regression testing and other functional testing activities

Analyze, plan and implement changes in the size of databases due to ordinary fluctuations in business growth

Maintain the data dictionary and data models

Co-ordinate database back-up and restore activities.

Tune and reorganize databases as required to maintain system performance requirements and in accordance with a schedule:

Create indices to optimize application performance

Generate the performance statistics report and perform an analysis of the databases performance for the given period of time and identify the performance bottlenecks

Monitor storage space utilization through alerts and other monitoring tools

Lead the SQL server upgrades as approved through the CR process Xylem Inc, Morton Grove, IL Mar’12 to Jun’12

SQL Server DBA

Responsibilities:

Installation and configuration of SQL 2005/08/08 R2, Oracle 11g data base and grid infrastructure.

Involved in Analysis and Design Documentation, User requirements and maintained good documentation.

Maintain SQL scripts, indexes, and complex queries for data analysis and extraction.

Perform database and SQL optimization, table partitioning, and stored procedure optimization.

Created Alerts and Operators in SQL Servers to alert when any Failure occurred in the Database server.

Worked on reducing the over disk space used by reducing the size of the transaction logs. Export and Import of data from server to server.

Design various ETLs in SSIS which are efficient, optimized, robust and easy to manage.

Worked on storage configuration SAN.

Design SSIS projects in SQL Server 2005 and migrated DTS from 2000 to SQL Server 2005.

Troubleshoot and fix database issues to ensure data integrity and database performance.

Worked on database replication and backups.

Created and maintained SQL agent for scheduling jobs.

Manage user access and rights to database and reports. JP Morgan Chase, Columbus, OH Sep’11 to Jan’12

Sr. SQL Server DBA/Developer

Responsibilities:

Build of SQL 2005/08/08 R2

Maintain SQL scripts, indexes, and complex queries for data analysis and extraction.

Perform database and SQL optimization, table partitioning, and stored procedure optimization.

Created Alerts and Operators in SQL Servers to alert when any Failure occurred in the Database server.

Develop various stored procedures, triggers, user defined functions and views in SQL 2005.

Design various ETLs in SSIS which are efficient, optimized, robust and easy to manage.

Worked on storage configuration SAN.

Experience with SharePoint.

Design SSIS projects in SQL Server 2005 and migrated DTS from 2000 to SQL Server 2005.

Troubleshoot and fix database issues to ensure data integrity and database performance.

Worked on reducing the over disk space used by reducing the size of the transaction logs.

Involved in Analysis and Design Documentation, User requirements and maintained good documentation.

Manage database replication and backup.

Created and maintained SQL agent for scheduling jobs.

Manage user access and rights to database and reports.

Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options. Eventcy Software Solutions, Hyderabad, India Aug’08 to Jul’09 Database Analyst

Responsibilities:

Worked closely with Database Administrator team and was involved in planning, developing database structures, maintaining security, running backups and recovery of SQL Server databases.

Maintained Data Integrity by creating standards using Normalization.

Provided information to the Database team, collecting and monitoring database performance.

Interacting with the software developers and helped in troubleshooting the problems involved with the development of stored procedures.

Developed Database Backup Scripts and automated this process.

Used BCP tool to post data in new database.

Installation, configuration and maintenance of database server (SQL Server) Servers in clustered environments.

Worked closely with software developers to connect front end software application with backend databases.

Created ER diagrams for better understanding, documentation and tutorial purposes.

Automated processes by creating scripts, stored procedures, triggers, cursors and views.

Contact this candidate