Sql Server Maintenance
Resume:
[pic]
Professional Summary
. Over * years of Experience in design, development, database
administration and production support of relational databases and
business applications.
. Experience in setting up new servers, installing, upgrading and migrating
database applications in SQL Server.
. Hands on experience in writing and debugging Stored Procedures, Triggers,
Complex queries (DDL/DML statements) using T-SQL.
. Good experience working with very large databases and Performance tuning.
. Experienced in implementing SQL Logins, Roles and Authentication Modes as
a part of Security Policies.
. Experience in using data modeling tools like SQL Diagrams, Erwin &
Microsoft Visio.
. Experienced in configuring and maintaining high availability
(Replication, Log Shipping, Mirroring, Clustering and Always-on) and
disaster recovery database systems.
. Proficient in backing up, restoring and troubleshooting of databases.
. Expert in analyzing, designing, developing, installing, configuring and
deploying MS SQL Server suite of products with Business Intelligence in
SQL Server Reporting Services and SQL Server Integration Services.
. Expert in creating SQL Server Reports using SSRS in designing stylish
report layout parameterized, performance, Chart Reports, ad-hoc reports.
. Experienced in migration of data using BCP utility, Bulk insert command,
SSIS and DTS packages, Import/Export and Copy database wizard.
. Experienced in using tools like Performance Monitor, SQL Profiler to
optimizing and tracing long running queries and deadlocks.
. Experienced in applying patches and service packs to keep the databases
up to date.
. 24 X 7 Production Database on Call Support.
. My accomplishments include managing and involving in teams as a member
and delivered myself a key role player with strong technical skills
coupled with good interpersonal and communication skills, Strong
Leadership qualities and problem solving abilities.
. Positive attitude in accepting new technologies and a great willingness
to learn new innovations and skills in accordance with the dynamic
technologies.
Technical Skills
Programming/Scripti HTML, XML, Java Script, T-SQL,PL/SQL
ng Languages
Operating Systems Windows Server XP/2003/2008/2008 R2/2012/Windows7, and
Linux
Databases MS SQL Server 2012/2008/2008 R2/2005/2000, MS-ACCESS,
MYSQL 5.5, Oracle 10g/9i.
Web Servers IIS 6.0, 7.0. Apache Tomcat.
Tools ITIL,SQL LiteSpeed, MSE, TOAD, Workbench,
SSMS/Enterprise Manager, SQL Navigator, SSRS,SSIS,SQL
Profiler, SQL Compare, Visual Studio
2005/2008,TFS,Erwin.
Microsoft Certification
70-432 - Microsoft SQL Server 2008-Implementation & Maintenance
70-433 - Microsoft SQL Server 2008 Database Development
70-462 - Administrating Microsoft SQL Server 2012 Databases
Professional Experiences
Company: Project Performance Company, McLean, VA
Jan 2011 to till Date
Project: DOE-eCenter (Department of Energy)
Title: Sr. Database Analyst
Roles & Responsibilities
. Involved in gathering the requirements, analysis, design, development and
implementation.
. Designed Data flow diagrams & Entity Relationship(ER) diagrams.
. Developed complex queries, stored procedures, triggers, functions, based
on the system design using T-SQL.
. Extensively worked on DBCC commands and Dynamic Management Objects.
. Rebuilding the indexes at regular intervals for better performance.
. Installed and configured SQL Server for testing, staging and production
environments.
. Developed, deployed and monitored SSIS Packages including upgrading DTS
to SSIS.
. Extensively used SSIS transformations such as Lookup, Derived column,
Data conversion, Aggregate, Conditional split, SQL task, Script task,
SFTP task and Send Mail task etc.
. Unit Testing the SSIS packages with respect to its flow and performance
issues.
. Export or Import data from other data sources like flat files using
Import/Export through DTS, SSIS.
. Monitoring SQL server performance using SQL Profiler to find performance
and dead locks.
. Solving the Bugs reported by the Testing team.
. Generated periodic reports based on the statistical analysis of the data
from various time frame and division using SQL Server Reporting Services
(SSRS)
. Developed various operational Drill-through and Drill-down reports using
SSRS.
. Developed different kind of reports such a Sub Reports, Charts, Matrix
reports, Linked reports.
. Backup client databases and perform database restore and run consistency
checks from SQL Server and application. Performs and monitors daily
database operations and set-up backup schedules.
. Monitor the status of Maintenance jobs - schedule to run daily and on
weekends (tasks like, creating Databases, Shrink Database, and Database
complete backup).
. Performing security management by maintaining roles, privileges, and user
profiles. Add/Remove users from many different Security Groups in our
domain (Auto groups).
. Run Scripts on production databases and also troubleshoot if there are
any minor issues in the script, if the script doesn't give the desired
output.
. Upgrade of Database from SQL Server 2005 and 2008R2 to SQL 2012.
. Configured and manage SQL Server 2012 Always-On solution with 4
replicas.
Technologies: SQL Server 2000\2008\2012, SSIS, Visual Studio 2008\2010,
TFS.ITIL, Erwin.
Company: Infosys Ltd, India
July 2009 to Oct 2010
Project: Cisco
Title: Technology Lead
Roles & Responsibilities
. Recovering the databases from backup in disasters.
. Monitor the status of Maintenance jobs - schedule to run daily and on
weekends (tasks like, creating Databases, Shrink Database, and Database
complete backup).
. Maintenance of Log shipping.
. Password Reset Activities on production and pre-production servers.
. Providing 24 / 7 Production support as an On-Call Production support DBA
for all SQL Servers and MySQL Instances.
. Configured packages using SSIS to import the data in to MySQL database
from source servers like sql server.
. Created SSIS packages for File Transfer from one location to the other
using FTP task.
. Proactively working on Performance and Blocking issues on servers by
auditing Databases.
. Maintain Security Administration and High Availability( transactional
Replication)
. Run Scripts on production databases that are requested by the Redmond
Teams. Also troubleshoot if there are any minor issues in the script, if
the script doesn't give the desired output.
. Created SSRS reports using Report Parameters, Drop-Down Parameters,
Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and
Charts.
. Import and export data into different table using import and export
wizard.
. Installed and configured MySQL on Linux and Windows environments.
. Managing/Troubleshooting MySQL issues in production and development
environments on Linux.
. Created scripts to create new tables, views, queries for new enhancement
in the application using TOAD.
. Effectively configured MySQL Replication as part of HA solution.
. Performed MySQL Replication setup and administration on Master-Slave and
Master-Master.
. Worked on SSRS to handle Ad-hoc requests.
. Worked on application bugs created by users.
Technologies: SQL Server 2008, MYSQL 5.5, SSIS, SSRS, Visual Studio 2010,
TOAD, Workbench, SQL LiteSpeed.
Company: Infosys
June 2008 to June 2009
Project: Overseas Development Support
Title: Technology Analyst
Roles & Responsibilities
. Hands-on experience in installing and configuring MS-SQL SERVER 2005.
. Implementation of SQL Logins, Roles and Authentication Modes as a part of
Security Policies for various categories of users.
. Recovering the databases from backup in disasters.
. Backup client databases and perform database restore and run consistency
checks from SQL Server and application. Performs and monitors daily
database operations and set-up backup schedules.
. Worked on SSIS Package, DTS Import/Export for transferring data from
Database (Oracle and Text format data) to SQL Server.
. Monitor the status of Maintenance jobs - schedule to run daily and on
weekends (tasks like, creating Databases, Shrink Database, and Database
complete backup).
. Maintenance of Log shipping.
. Creating Linked servers.
. Maintain Security Administration and High Availability( Replications and
Log Shipping)
. Created indexes on the tables for faster retrieval of the data to enhance
database performance
. Performed SQL and PL/SQL tuning and Application tuning using various
tools like EXPLAIN PLAN, SQL*TRACE
Technologies: SQL Server 2000\2005, T-SQL, TFS, SSIS.
Company: Infosys August 2006 to May
2008
Project: Trillion-Mind
Title: Associate DBA
.
Roles & Responsibilities
. Hands-on experience in installing and configuring MS-SQL SERVER 2000/2005
. Implementation of SQL Logins, Roles and Authentication Modes as a part of
Security Policies for various categories of users.
. Recovering the databases from backup in disasters.
. Backup client databases and perform database restore and run consistency
checks from SQL Server and application. Performs and monitors daily
database operations and set-up backup schedules.
. Development of custom scripts and stored procedures for data import and
manipulation
. Monitor the status of Maintenance jobs - schedule to run daily and on
weekends (tasks like creating Databases, Shrink Database, and Database
complete backup).
. Maintenance of Log shipping.
. Maintain Security Administration and High Availability(Replications and
Log Shipping)
. Creation of database objects like tables, views, materialized views,
procedures and packages using oracle tools like Toad, PL/SQL
Developer and SQL* plus.
. Transferring data between development and production environment (sync up
environment techniques).
. Worked as a developer in creating complex stored Procedures, SSIS
packages, triggers, Cursors, tables, and views and other SQL joins and
statements for applications.
. Worked on SSRS to handle Ad-hoc requests.
Technologies: MS SQL server 2000, TOAD, SSRS, DTS, T-SQL.
Sravani Kukkadapu
Email: *************.***@*****.***
Contact: 571-***-****
Contact this candidate