Sql Server DBA
Resume:
Deepthi Rao Phone: *** -*** - ****
***************@*****.***
Experience Summary
Over 5 years of experience in Database Administration, Design, Development and Support of MS SQL Server 2012, 2008/R2 and 2005 in Production, Testing and Development Environments.
Experience in SQL Server Installation, Configuration, Query Optimization, Performance Monitoring, Security Administration, Capacity Planning and Troubleshooting.
Experience in Installing and configuring SQL Server Clusters in Active/Passive modes.
Experience in SQL Server Upgrades and Migrations.
Hands on experience in DR processes including Log Shipping and Database Mirroring.
Experience in Database Backup & Recovery and Transaction Replication.
Experience in extracting and transforming data using Import/Export, Bulk Insert and BCP.
Experience in Performance Tuning, Query Optimization, Database consistency checks using DBCC utilities and Index Tuning Wizard
Extensive experience in monitoring database performance using SQL Profiler, DB’s percent log space using Ignite Confio, Foglight and Windows Performance counters.
Experience in Database administration activities for DB Security (creating logins, users, roles, and assigning permission to them).
Installed, configured and administered SQL Server Integration and Reporting Services.
Extensive knowledge in different industries including Finance, Telemarketing, Insurance and Health Care.
Implemented the New SQL Server 2012 Mechanisms like data compressions, Contained Databases, security principals and AAG.
Expertise in T-SQL writing stored procedures and functions.
Experience in supporting Very Large databases (VLDB) and troubleshooting the problems.
Worked on logical and physical database modeling with UML and ERWIN tools, SQL Compare.
24 X 7 Production Database On Call Support
Good analytical, organizational, problem solving, interpersonal and communication skills and can work efficiently with minimal supervision.
Job Title History
SQL Server DBA, Fifth Third Bank, Cincinnati, OH Nov’13 – Jul’ 15
SQL Server DBA, Sanofi-Aventis, Bridgewater, NJ Aug’12 – Oct’ 13
SQL Server DBA, Department Of Health, Harrisburg, PA. Oct’11 – Jul’ 12
SQL Server DBA, Verizon Business, Atlanta, GA. Jan’10 – Sep’ 11
Java Developer, Polaris Software Lab Ltd, Hyderabad, India. Jan’10 – Dec’ 09
Technical Skills
Operating Systems : Windows 2003/2008/2012/XP and Solaris.
Languages : C, C++, SQL, T-SQL, PL/SQL, Java, VBScript, Java Script, HTML, ASP
Databases : SQL Server 2005/2008/2008R2/2012, Oracle 9i/10g and MS Access.
Utilities : ERWIN, ER Studio, TOAD 8.6/9.0, SQL Developer, Data Compare, VSS
Monitoring Tools : Ignite Confio, Litespeed Backup, Foglight, Quest, Symantec I3, Spotlight., IP Monitor, Litespeed,
Education
Master of Computer Applications, India.
Bachelor of Computer Applications, India.
Professional Experience
Fifth Third Bank, Cincinnati, OH Nov’ 13 – Jul’ 15
SQL Server DBA
Fifth Third is one of the nation's leading financial institutions, lending and investment services to individual consumers, as well as to small businesses. It maintains users checking and saving account information, allows users to make a payment, transfer funds and customize reports for users and bankers.
Responsible for all aspects of company’s SQL Server database systems requirement from Hardware, Installations, Configurations, Upgrades, Backup & Recovery and Day-To-Day Maintenance. Supported almost 29 Servers including Development, Test, Stage and Production Environments.
Responsibilities:
Reviewed and analyzed requirements for New Projects with Application and Business teams.
Created Database Maintenance Plan to implement Database Integrity Checks, Re-indexing and Stats.
Evaluated 3rd party SQL Server Monitoring Tools that could be used for database administration.
Installed & configured SQL Server 2008R2/2012 Active/Passive Clusters in different environments applying the installation and configuration standards.
Used DMVs, Alerts, SQL Profiler, Performance Monitor and Ignite Confio by Solar Winds to proactively monitor and tune the Database Environment
Implemented SQL Server Security Standards by granting minimal permissions, using database Roles, Windows Authentication and Active Directory Groups.
Coordinated with SAN Team and involved in Capacity Planning and Storage allocation for Test, Dev, Stage and Prod environments.
Installed, configured and administered SQL Server Integration and Reporting Services.
Run Upgrade Advisor and Upgraded and Migrated SQL Server 2008 to SQL Server 2012.
Used Import/Export wizard to move data from flat files and Excel sheets to SQL Server using SSIS.
Provided 24/7 Production Support (on-call) and resolved all tickets opened by operations team including SSIS/SQL Job failures, Disk space, Blocking.
Administrative tasks including full and differential backups, database security by creating users and roles for login authentication and validating permissions
Maintained SQL Inventory documented backup strategies, SQL Server best practices, and installation and configuration procedures.
Adhered to the Change Management procedures.
Evaluated new features in SQL Server 2012 in lab environment namely Enhanced to Backups, contained databases, Security Principals and AAG.
.
Environment: Windows 2003/2008/2008R2/2012, MS SQL 2005/2008/2008R2/2012, Clustering, Ignite Confio, VMware, EMC SAN, Red Gate SQL Compare, Windows Power Shell, SSIS, SSRS, Visual Studio, .NET, SFTP.
Sanofi-Aventis, Bridgewater, NJ Aug’ 12 – Oct’ 13.
SQL Server DBA
Sanofi-Aventis Pharmaceuticals is the third largest pharmaceutical company in the world formed by the merger of Sanofi and Aventis. Sanofi-Aventis manufactures and markets the drugs for therapeutic areas, human and animal vaccines to protect the health of patients.
The main aim of this project is to migrate & integrate separate databases into a single database when Aventis merged with Sanofi Pharmaceuticals. This involved designing and implementing strategies to import data over from the database and then running consistency checks to ensure data integrity. Also responsible for ensuring all applications that were based on the database did not experience any data issues on account of the merged database.
Responsibilities:
Installed SQL Clustering in production environments and Maintained SQL Servers with High availability.
Installing and configuring of SQL Server 2008 and 2008R2.
Configured and maintained database mirroring for high availability.
Performed SQL Server Upgrades and Migrations..
Involved in Provisioning drive space (SAN, SCSI, other) and Virtualization configuration meetings with core team.
Created & Managed the required databases in all environments.
Created and configured Database Maintenance Plans to perform day-to-day upkeep on all databases.
Rebuilt and Monitored indexes at regular intervals for better performance.
Involved in modeling physical and logical database structures using Microsoft Visio, Erwin for designing ERD and DFD.
Responsible for Database and Log Backups & Restoration, Backup Strategies and Scheduling Backups.
Worked on Common DBA Tasks not limited to Troubleshoot Blocking, Deadlocking (using Profiler), Re-Indexing and Performance Tuning.
Reviewed complex stored procedures, triggers and scripts for ongoing projects.
Handled Change Requests, Releases, Change meetings and back out plans.
Design and implement SSIS Packages and schedule jobs to run packages.
Used SQL Compare and Data compare software to insure customer (UAT) and QA environments were kept in sync with production environments.
Global documentation for SQL Server standards, Disaster Recovery, Monitoring and Installation Process as per Sanofi-Aventis policies.
Environment: MS SQL Server 2005/2008R2/2012, Windows 2003/2008/2008R2 Server, Clustering, Database Mirroring, SAN, T-SQL, SQL Compare 5.0, Microsoft Visio, ERWIN.
Department Of Health, Harrisburg, PA Oct’ 11 – Jul’ 12.
SQL Server DBA
Health Application Compass - Pennsylvania department of health has online application site Compass, that application helps citizens of Pennsylvania State to apply for health care benefit and other services online.
Responsibilities:
Installing and configuring of SQL Server 2008 and 2008R2.
Setup maintenance jobs in all Servers scheduled to run at various times.
Created Logins, users & roles and involved in Day to Day User Maintenance.
Extensive usage of SSIS, Export/Import, BCP & BULK INSERT utilities for data Migrations involving multimillion records tables.
Involved in resolving the Locking & Blocking Issues.
Analyzed Database Growth and planned for data storage and servers.
Installed and configured SQL Server 2008/R2 service packs and hot fixes.
Run the Upgrade Advisor and resolved SQL Server 2008 upgrade hurdles
Investigated and resolved any database corruption, performance related issues with minimal and maximum reliability.
Created Indexes and Constraints (Check, Unique, and Foreign Keys) on the tables.
Created Backup and Restore Strategy for production, development and test environments.
Installed and configured Log Shipping for production servers.
Used Attach/Detach approach to Migrate SQL Server 2008 and reviewed SQL Server error log and event log for any messages related to the migration
Created SQL Server Integration Services (SSIS) for transferring data from DB2 to SQL Server.
Periodically checked all databases with DBCC commands for maintaining data consistency and integrity.
Installed and configured SQL Server Reporting Services
Involved in Production Support on a 24*7 basis.
Environment: MS SQL Server 2005/2008/2008R2, T-SQL, Windows 2003/2008,Logshipping, Oracle 9.0, MS-Access 2003, SQL Compare 6.0.
Verizon Business, Atlanta, GA Jan’ 10 – Sep’ 11.
SQL Server DBA
Verizon is a global leader in delivering broadband and other wireless and wire line communications services to mass market, business, government and wholesale customers. Verizon Wireless operates America's most reliable wireless network, serving more than 87 million customers nationwide. My role as a SQL DBA is to provide support to the production/development/UAT database on day to day basis.
Responsibilities:
Installation, configuration the MS SQL Server and maintenance of servers in various environments.
Designed and implemented disaster recovery plan that provided restore capabilities within hour of failure.
Developed Backup & Restore strategies for all SQL Servers and monitor the backup jobs of multiple machines.
Addressed and resolved application user problems through Work Order Ticketing system.
Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
Managed the security of the database by creating and managing server roles, database access and granting/revoking different object level permissions to specific users.
Set up new SQL Servers and configured required users. Restored and copied production databases.
Regularly monitored servers which included Disk space monitoring, Services monitoring, block monitoring and troubleshoot of all the issues on regular basis.
Installed Microsoft SQL Server on New Production and Test servers with latest Security updates involving Service Packs and Security patches.
Environment: MS SQL Server 2005/2008/2008R2, T-SQL, Windows 2000/2003/2008, Visio, Erwin, Data Analyzer, COGNOS 7.0, SQL Compare.
Polaris Software Lab ltd, Hyderabad, INDIA Jan ’ 10 – Dec ’ 09.
Java Developer
In this project we will develop a web-based system for managing the product Support center. Users of the system can report and track product defects, log comment about them and route them to the appropriate parties. This project providing technical support for software. The system architecture employed is known as MVC (Model-view-controller)
Responsibilities:
Interacted with clients to understand business requirements and involved with business intelligence team during requirement analysis.
Involved in developing database modeling and database schema.
Implemented Struts 1.0 framework using MVC architecture.
Used the Struts 1.0 framework and Standard Tag Libraries and various custom in-house custom tag libraries for the presentation layer
Developed new screens to the application by designing the UI with HTML, JSP, CSS, JavaScript, ajax.
Used JavaScript for client side validations.
Used JMS for asynchronous messaging between different modules.
Developed the application using Eclipse as the IDE and used standard features for editing, debugging, running etc
Built scripts using ANT that compiles the code, pre-compiles the JSPs, building the war application and deployed the application on the Apache Tomcat application server.
Implemented Log4J for Logging Errors, debugging and tracking using loggers, appenders components.
Environment: JDK 1.4, Struts 1.0,Hibernate2,JSP Servlets,, HTML, CSS, JavaScript, Oracle9i, Eclipse, Apache Tomcat Windows XP.
Contact this candidate