Sql Server Management

Swapna N

MS SQL Database Administrator

*********.********@*****.***

SUMMARY

I have 8 years of experience in Information Technology and 6 years as an Database Administration, System Analysis, Design, Development and Support of MS SQL Servers 2012, 2008, 2005

Upgraded all SQL Servers, 2005/ 20008 /2008 R2 to SQL Server 2012.

Hands on experience and outstanding knowledge of High Availability, Disaster Recovery Solutions including, Database Mirroring, Replication, log shipping, Backup and Recovery.

Maintain DDL and DML.

Expertise in support of highly distributed environment of databases, Business Intelligence Services(SSRS, SSIS, SSAS) and Data Warehouse Databases(ETL).

Expertise in database design and database modeling.

Experience in Performance Tuning, Query Optimization and Client/Server Connectivity.

Expertise in configuration of Linked Servers.

Install and configuration of Active/Passive SQL Clusters.

Familiar with ITL service management methodologies.

T-SQL scripting.

Hands on experience on Project management.

Automated scripting for Databases.

Expertise in SOP in DB instances.

Hands on with 3rd party Utilities like Net Backup, Net Apps and CA.

Hands on experience handling of Incident, change and Problem management.

Experience working in Production and testing environments.

Excellent communication and Verbal skills.

EDUCATION

Masters in Engineering from university of new haven, CT 2007

Technology Experience:

JAVA, C#,.Net

SQL2005/2008/2012,Oracle 10g, 11g, Informatica, Cognos.

Net backup, Net Apps and CA

IIS, Tomcat, SharePoint.

SSIS,SSAS,SSRS,Crystal reports and ETL Tools

Monitoring Tools

Linux, Solaris10, Windows

PROFESSIONAL EXPERIENCE

SQL Database Administrator, Anthem, Atlanta, GA

Duration : Nov 2014 - Till date

Responsibilities:

Install and Configuring of SQL Server 2012 in multi server environment.

Upgraded SQL Server 2008 /2008 R2 to SQL Server 2012 without any service interruption.

Data migration from PeopleSoft to SQL Server 2012.

Resolved Critical issues, during Data Migration.

Handled various issues related to the setup and configuration of Log Shipping.

Involved in logical and physical for application and database tuning.

Established standards for SQL installations, maintenance and coding standards.

Well designed Backup and Recovery.

Database refresh from production to testing.

Managed Logins, Users, Roles and User Permissions and conducted backup and recovery.

Worked with developers to tune the SQL queries.

Daily Health Check for DB instances.

Provided 24/7 Production support for the database and application issues.

Environment: MS SQL Server 2012, 2008,PeopleSoft, .Net, IIS 8, Windows Server 2008 /2012 and C#

Database Administrator Philips66, Houston, TX

Duration : Jan 2012 – Oct 2014

Responsibilities:

Installed and Configured of SQL Server instances.

Setup and Configuration of Replication and Mirroring.

Experience in Database design and modeling for applications.

Hands on experience on Windows Servers and IIS configuration.

Handled SQL cluster and SQL mirror databases.

Managed Backup/recovery data management/performance monitoring/tuning/Jobs and Re-Indexing.

Setup and Configuration of Business Intelligence services.

Designed SSIS packages generated Reports (SSRS) using Business Intelligence Development Studio.

Performed troubleshooting of client database related issues during implementation, Maintenance, upgrading and migration process.

Managing the use of disk space, memory, connections and monitoring the servers.

Analyzed user requirements and business rules.

Used SQL profiler and Database engine tuning advisor for solving Deadlock, Performance Issues.

Involved in scheduling jobs using SQL Server Agent as required.

Project involved knowledge transfer to offshore team, Documentation, Change Management and Metrics.

Worked Change, incident and Problem management.

Created Users, Roles and User Permissions in databases.

Worked Running DBCC Consistency Checks and fixing Data Corruption in user databases.

Involved in production support round the clock.

Environment: MS SQL Server 2008 /2005 Server, Windows Server 2008/2005 Enterprise Edition, Business Intelligence,.Net, SQL Profiler, SharePoint, C# and IIS, Net Backup, CA

SQL DBA Comcast, Denver

Duration : Jan 2009 - Dec 2011

Responsibilities:

Installed and Configured SQL server Instances.

Involved in Migrations and new installations & Administration of SQL 2005.

Coordinated and performed quality assurance testing for movement of database and objects from development environment to testing and production environments.

Managing security, which includes monitoring and controlling database access, assigning

Permissions to application owners.

Developed SSIS, SSRS and SSAS packages.

Tested and implemented Database mirroring solution for Production critical application.

Extensive experience in using Automate task for various database maintenance issues like Backup, DBCC, Update Statistics, Exporting and Importing data, Security planning and monitoring.

Troubleshooting production issues related to the various portals/applications connectivity with SQL servers.

Environment: SQL Server 2008/2005, VB.Net, Net Backup, Windows, CA.

QA Engineer VeriSign Inc, MA

Duration : Oct 2007 - Dec 2008

Responsibilities:

Involved in time efficient way to automate defined test cases (type, name, action, input parameters, and expected results).

Tested the functionality Page Navigation objects and created Scripts for Regression testing and used across the application.

Tested Conditions based on the Functional Requirements.

Designed and developed detailed test plan and also developed the functional test plan and test scripts for the application.

Performed Regression, Functional and GUI Testing by using the action keyword scripts for the application by using IBM Rational Functional Tester.

Analyzed user requirements, attended change request meetings to document changes and implemented procedures to test changes.

Identified and documented all issues and defects to ensure desired quality of the application functionality.

Involved in configuring the application in different environments.

Tested java based applications by using Rational Functional Tester.

Tested VB.NET applications and some Windows objects, and also tested an object of one domain within an object of another domain, in some cases.

Experience in Adding an entire project or directory to clear case and worked with the clear case.

Perform full functional testing. Record and play back scripts that navigate through your application and test the state of objects.

Involved in writing the methods and functions and classes for java based applications.

Hands on experience in writing SQL queries.

Involved in browser testing.

Participated in requirement, defect review, and go no go meetings

Environment: IBM Rational Functional Tester, Rational Clear Case, SQL Server, MS-Excel, UNIX, MS-Word, Java, HTML.

Contact this candidate