Vijay Visavaram

SQL Database Administrator 614-***-**** acy76r@r.postjobfree.com

SUMMARY

•9 + Years of IT experience in USA, which includes SQL Database Administration, System Analysis, Design, and Development & Support of MS SQL Servers 2016 & 2014, 2012 and 2008R2 and 2005 and Cluster and standalone Server Environments.

•Extensive experience on DBA Support, Application Production Support and server Administration in all operations environment for domains like Financial and Manufacturing and Healthcare.

•Extensive experience in SQL server administration that includes Installations, Configuring, upgrades/Migrations, Monitoring, tuning, troubleshooting issues in SQL server 2014/2012/20008R2/2005.

•Experience in working with Windows server 2008R2 & 2003 Server Operating Systems

•Involved in migrating databases from SQL Server 2005, 2008 and from SQL Server 2005 to 2008 and 2008 R2 (Side by Side).

•Proficient with SQL Server tools, including Enterprise Manager, Management Studio, Query Analyzer, Profiler, SQL Server Agent, SSRS and SSIS.

•Hands on experience and outstanding knowledge of High Availability, Disaster Recovery Solutions including, Database Mirroring, Snapshot, Transactional, Merge Replication, log shipping and SQL Server clustering.

•Experience in creating SSIS Packages, Jobs, Database Mail, sending Alerts using SQL Mail.

•Solid experience with creating alerts, jobs, data loading and database maintenance.

•Experience in using Performance Monitor and SQL Profiler.

•Using Performance Monitor/SQL Profiler to solve Dead Locks/Long running Queries.

•Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC utilities.

•Experience working in Production 24/7 and development environments.

TECHNICAL SKILLS :

•Languages: C, C++,T-SQL, Java

•Web Technologies: HTML, DHTML, ASP.Net, XML, Java Script and VB Script,

•Data Bases: SQL SERVER 2014 and 2012/2008 R2 &2005 / 2000, MS Access

•Front End: MS Visual Basic 6.0, ASP.

•OLAP Tools: MS OLAP Services Manager

•Version Control Tools: Visual Source Safe

•Web Server Technologies: IIS 6.0/7.0/8.0

•Microsoft Reporting Services: 2008/2005

•ETL- Tools - MicrosoftSQL Server Integration Services

•SharePoint: WSS 2003/MOSS 2007/14

•Modeling Tool: Microsoft Visio, Erwin

•Third Party Tools : Red Gate, Lite speed, spot light and Service Now

EDUCATION

•MSc in Computer Science,Tamil Nadu, India.

CERTIFICATIONS

•MCITP: Database Administrator in MS SQL Server 2008 Implementation and Maintenance.

PROFESSIONAL EXPERIENCE

Ally Financials Inc. ( Digital Technologies) 09/15 – Present

Detroit, MI

SQL SERVER DBA

Ally Financial Inc., previously known as GMAC Inc. (an acronym for General Motors Acceptance Corporation), is a bank holding company headquartered in Detroit, Michigan, States. The company is in the process of moving its headquarters to One Detroit Center located at Renaissance Center 200 Tower, Detroit, Michigan.

•Maintained database by determining structural requirements; developing and installing solutions.

•Determined database structural requirements by analyzing client operations, applications, and programming; reviewing objectives with clients; evaluating current systems.

•Developed database solutions by designing proposed system; defining database physical structure and functional capabilities, security, back-up, and recovery specifications.

•Installed database systems by developing flowcharts; applying optimum access techniques; coordinating installation actions; documents actions.

•Maintained database performance by identifying and resolving production and application development problems; calculating optimum values for parameters; evaluating, integrating, and installing new releases; completing maintenance; answering user questions.

•Designing DB migration/upgrades strategies.

•Carrying out the migrations for SQL server version and hardware upgrades.

•Ensure database environment is compliant with IT security standards and per security baselines

•Involved in updating Windows Patches and SQL Server Patches on different versions of Windows Operating System and SQL Server.

•Worked on privilege tickets to provide read, write and execute permissions on windows and SQL Logins.

•Experience in applying SQL Server Service Packs to the latest version 2008 R2 and 2012 servers and 2014.

•Experience in light speed tool for taking backup and restore databases.

•Very good knowledge on Service Now ticketing system tool.

•Involved in monitoring the SQL Server performance issues using third party tools like spotlight and Performance Analysis.

•Experience in applying Windows Patches and SQL Server Service Packs to the latest version.

Environment: MS SQL Server 2014&2016 and SQL Server 2012&2008R2, SQL Server Management Studio, SQL Profiler, Export Wizard, Enterprise Manager, SQL Server Agent, Light speed, Service Now.

EMERSON Process Management (YASH Technologies) 04/13 – 08/2015

Marshall Town, IA

SQL Server DBA

Emerson is a diversified global manufacturing company that brings technology and engineering together to provide innovative solutions to customers in the industrial, commercial and consumer markets through its Process Management, Industrial Automation, Network Power, Climate Technologies, and Commercial & Residential Solutions businesses.

•Installed and Configured of SQL Server 2012 and SQL Server 2008R2 in multi-server environment.

•Installing SQL Server service packs based on the errors and flaws that are found in the application.

•Monitors SQL software license usage, reallocates unused license, and requests additional licenses when needed.

•Managed Logins, Users, Roles and User Permissions and conducted backup and recover.

•Developed administrative tasks of SQL Server of performing daily backups and recovery procedures.

•Worked with developers to tune the SQL queries using SQL Profiler.

•Created alerts and notifications for system errors, insufficient resources and fatal database errors.

•Migrated from SQL Server 2005 to SQL Server 2008&2012, and migration of SSIS packages to 2008 & 2012.

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

•Installed and Configured Transactional and Snapshot Replication from production servers to other production server in remote location.

•Hands-on working experience in installing, configuring, upgrading and managing SQL Server 2008/2012 and upgrading Service Packs for multiple instances.

•Created SSIS packages using Import/Export Wizard.

•Deployed and scheduled SSIS packages.

•Worked on providing read, write and execute permissions on SQL Logins in different environment.

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

Environment: MS SQL Server 2008/2005, SQL Server Management Studio, SQL Profiler, Ex- port Wizard, Enterprise Manager, SQL Server Agent, SSIS.

Great American Insurance (HCL Technologies) 01/11 – 12/12

Cincinnati, OH.

SQL Server DBA

Great American focuses on two primary markets. Our Property and Casualty Group is made up of more than 25 companies and divisions that offer targeted commercials coverage for specialized industries. Our Annuity and Supplemental Insurance Group, operating as Great American Financial Resources, Inc. Markets traditional fixed, indexed and variable annuities and various forms of supplemental insurance.

•Installed and Configured of SQL Server 2008 and SQL Server 2008R2 in multi-server environment.

•Installing SQL Server service packs based on the errors and flaws that are found in the application.

•Used GATE and REMEDY tools for ticket system to solve customer tickets.

•Creation of New NT Logins and granting privileges to users/Groups and objects.

•Recovering the Backups of SQL Server production databases in test servers as part of regular maintenance activities.

•Provide dedicated support to all Production, Test & Development MS SQL Server Environments.

•Review / test / apply all database changes to all environments including QA, Development and Production Servers.

•Worked with developers to tune the SQL queries.

•Solved Issues related to performance tuning.

•Managing Logins, Users, Roles and User permissions.

•Regularly performing the Health checks on the Databases and updating the statistics on the Databases.

•Worked as part of the 24x7 team which included working over the week-ends and late nights.

Environment: MS SQL Server 2008R2 /2005 Standard, Enterprise Edition. Windows Server 2003/2000 Enterprise Edition, SQL Server Agent, SSIS.

Toyota Motor Engineering & Manufacturing (TEK System) 01/10 – 12/10

Florence, KY

SQL Server DBA

Toyota Motor Corporation operates in the automotive industry worldwide. It engages in the de- sign, manufacture, assembly, and sale of passenger cars, minivans, and trucks and related parts and accessories. The company offers hybrid vehicles primarily under the Prius brand, which run on a combination of gasoline engine and motor the company provides retail and whole financing, retail leasing, and insurance services to dealers and its customers, as well as offers Lexus brand credit cards. Additionally, it engages in the design and manufacture of prefabricated housing and information technology-related businesses. Toyota Motor Corporation was founded in 1933 and is headquartered in Toyota City, Japan.

•Worked extensively on installation, upgradation and configuration of MS SQL Server 2008 and MS SQL Server 2005 databases/ servers.

•Actively participated in gathering of User Requirement and System Specification

•Involved in migrating databases, DTS packages from MS SQL server 2000/2005 to MS SQL Server 2008.

•Cleaning and maintain the databases by removing and deleting old data.

•Writing code for Database access, modifications, partitions, indexes and constructions including store Procedures along with optimization of physical tables.

•Managing Logins, Users, Roles and User permissions.

•Solved various issues encountered in migrating from SQL Server 2000 to SQL Server 2005/2008.

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

•Implemented transactional replication between Primary Server and Sub Systems.

•Worked with developers to tune the SQL queries using SQL Profiler.

•Worked extensively on Database space management, performance monitoring, Tuning.

•Administered the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups to automate daily DBA activities

•Managed Daily/Weekly/Monthly database administration functions, such as backup/recovery/data management/performance monitoring/tuning/Jobs and Re-Indexing.

•Involved in scheduling jobs using SQL Server Agent as required.

•Extensively used SSIS to move data from text files to SQL Server.

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

•Involved in handling and downloading data using FTP jobs from Mainframe systems.

•Used Robo copy for moving data from Source to Target paths.

•Developed documentation that sufficiently describes technical deliverable as required for internal controls so that the maintenance responsibility can be passed on to production support team.

•Hands on experience with Change management tickets on Production Environment.

•Worked as part of the 24 x 7 team which included working over the week-ends and late nights.

Environment: MS SQL Server 2008/2005/2000 Standard, Enterprise Edition. Windows Server 2003/2000 Enterprise Edition, Windows XP, Business Intelligent Development Studio.

Allstate Insurance (WIPRO Technologies) 10/07 – 11/09

Chicago, IL

SQL Server DBA

In Chicago, an insured may purchase a PIP package where they have opted to have their Health Insurance carrier be primary when handling their injuries from an automobile accident and All- state is their Excess (Secondary carrier). This decision is only valid for the insured and their res- ident relatives. On resident passengers that are injured in the insured vehicle during an accident are not subject to the choices of the insured.

•Installation of MS SQL 2005 & 2000 Enterprise servers on production, Test and Development boxes.

•Supporting Applications with SQL Server 2000 & 2005 Databases across Many Locations all over United States.

•Planned and Successfully Implemented SQL Server 2005 on the Production, Test and Development Servers.

•Successfully Installed the Service Pack 1 and Hot-fix for SQL Server 2005 in all the Dev and Prod Environments.

•Administering the MS SQL Server 2005 by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.

•Involved in Migrating the existing database to SQL Server 2005 (Side by Side).

•Created a mirrored database on the report server using Database Mirroring with High Performance Mode.

•Day-to-day activities like taking backup (or schedule the backups daily for database and transaction log) on disk and restore the databases and transaction log on production/development servers as per requirement.

•Involved in creating Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures

•Involved in General Database Administration, Query Performance tuning, and validated some of the existing schema.

•Involved in DTS Package, DTS Import/Export for transferring data.

•Involved in implementation of replications like Snapshot and Transactional.

•On call 24/7 support to databases on weekly rotation.

Environment: MS SQL Server 2008/2005, Windows Server 2003/2000, Business Intelligent Development Studio, Database Engine Tuning Advisor, SQL Profiler.

Citi Group (Satyam Computers) 03/06 – 09/07

New York, Cincinnati, USA

SQL Server DBA

This Project talks about the Variable and Incentive compensation system for all the employees in Merrill Lynch. In this system there are Comp Managers, Relationship Managers, Business Man- agers and Recommendation Managers will be there to review their current population, allocate their performance year budget and distribute that budget and population to their direct reports or eligibility populations, make recommendations, review analysis of the recommendations (Dash- boards) and review and approve submission of the year end recommendations.

•Installation of MS SQL 2005 & 2000 Enterprise servers on production, Test and Development boxes.

•Supporting Applications with SQL Server 2000 & 2005 Databases across Many Locations all over United States.

•Planned and Successfully Implemented SQL Server 2005 on the Production, Test and Development Servers.

•Successfully Installed the Service Pack 1 and Hot-fix for SQL Server 2005 in all the Dev and Prod Environments.

•Administering the MS SQL Server 2005 by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.

•Involved in Migrating the existing database to SQL Server 2005 (Side by Side).

•Created a mirrored database on the report server using Database Mirroring with High Performance Mode.

•Day-to-day activities like taking backup (or schedule the backups daily for database and transaction log) on disk and restore the databases and transaction log on production/development servers as per requirement.

•Involved in creating Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures

•Involved in General Database Administration, Query Performance tuning, and validated some of the existing schema.

•Involved in DTS Package, DTS Import/Export for transferring data.

•Involved in implementation of replications like Snapshot and Transactional.

•On call 24/7 support to databases on weekly rotation.

•Environment: MS SQL Server 2005, Business Intelligence development studio, database engine tuning advisor, SQL Profiler, Index tuning wizard.

Contact this candidate