Sql Server Maintenance

Name: Vijaya Bandaru

Microsoft Certified Specialist SQL Server 2005 & 2012

Email: *****.********@*****.***

Contact Number: +1-302-***-****

Professional Summary:

7+ years of experience in SQL Server and Oracle Database Administration comprise of

Implementation and Support projects which involves Installations, Upgradation, Patching

and Maintenance of SQL Server 2005/2008/2008R2 & 2012 and Oracle 11g &12c

databases.

Responsibility for data availability, integrity, consistency and performance of critical SQL

Server and Oracle databases.

Expertise in Database Administration on Production Servers with server configuration,

performance tuning and maintenance with outstanding troubleshooting capabilities.

Configuration and maintenance of Oracle 11g and 12c databases on Linux environment

which include Dev, UAT, Test, QA and Production environments.

Very good experience in cross database migration from Oracle database to SQL Server

database using Microsoft SQL Server Migration Assistant (SSMA) for Oracle.

Very good experience in solution specific hardware and software sizing requirements to

meet customer immediate and growth requirements.

Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and

Application support.

Experience in implementing SQL Server security and Object permissions like maintaining

Database authentication modes, creation of users, configuring permissions and assigning

roles to users.

Good experience in database migration from SQL Server 2008 to 2012 and SQL Server

2005 to SQL Server 2008.

Good Experience in High availability and disaster recovery processes which includes Log

Shipping, Database Mirroring and clustering.

Experience in implementing different types of Replication Models like Snapshot, Merge and

Transactional on the basis of business specification.

Experience in database refreshes and cloning dev data with prod data and other data pump

utilities.

Establishing weekly maintenance plans such as Integrity check, Rebuilding indexes, Update

statistics and monthly maintenance plans such as clean up history etc. to run the databases

efficiently.

Complete end to end database product support for delivering new package/product releases.

Strong technical background along with the ability to perform business analysis and write

effective documentation and specifications.

24 X 7 Production Database on Call Support.

Technical Summary:

Databases MS SQL Server 2012, 2008, 2005 and Oracle 12c, 11g and DB2

Database Administration of MS SQL Server 2012, 2008 and Oracle 12c,

DBA

11g

Operating System Windows 2012/2008/2003 Advanced Server, NT and Linux

Tools SSMA, SQL Profiler, Redgate, Putty, Toad and SQL Developer

Version Control Clear quest and Clear case

Professional Experience:

Assignment 1 Nov 2014 to

Present

Client: Ocean County - New Jersey

Project Name: CGI Advantage ERP

Role: Sr SQL Server 2012 DBA

Description: CGI Advantage ERP is a powerful combination of modern technology and integrated

business applications that are specifically built for government use. With integrated functionality,

workflow and configurable processes, the CGI Advantage ERP suite contain Financial management,

Human resource management and Business intelligence.

Responsibilities:

Migrated Current production data from Oracle 10g in Linux to SQL Server 2012 in

Microsoft Windows Server 2012 Enterprise Edition.

An expert in data migration from Oracle database to SQL Server database using Microsoft

SQL Server Migration Assistant (SSMA) for Oracle.

Involved in hardware and software sizing requirements to meet customer immediate and

growth requirements.

Designing and Creating Databases for Development, QA, Staging and Production

environments.

Involved in trouble shooting and fine-tuning of databases for its performance and

concurrency.

Rebuilding / Monitoring the indexes at regular intervals for better performance.

Responsible for monitoring and making recommendations for performance improvement in

hosted databases. This involved index creation, index removal, index modification, file

group modifications, and adding scheduled jobs to re-index and update statistics in

databases.

Database migrations on the basis of business specification.

Maintaining environments by applying all kinds of application patches which includes

database change requests.

Complete product support for delivering new package/build releases.

Implementation of Security Policy for various categories of User Support.

Data files, Log files maintenance and space management.

Taking backups regularly through jobs, restoring databases for other teams whenever

required in preparing their environment.

SQL Server and Oracle database upgrades and new binary installations.

Documentation with respect to DBA activities and product release/build (s).

Interacting with developers, Release Engineer and App support teams for

implementing new changes.

Supporting an end to end database product support for delivering new package/product

releases.

Establishing weekly maintenance plans such as Integrity check, Rebuilding indexes, Update

statistics and monthly maintenance plans such as clean up history etc. to run the databases

efficiently.

Environment: SQL Server 2012 Enterprise, Windows Enterprise Server 2012, Oracle 10g,

Microsoft SQL Server Migration Assistant.

Assignment 2 June 2011 to Oct

2014

Client: NYC - Financial Information Services Agency (FISA)

Project Name: CGI Advantage ERP

Role: Sr DBA

Responsibilities:

Primary responsibility is to monitor Database servers by incidents configured from an

Infrastructure DB and take necessary action as appropriate.

Responsible for installation and configuration of SQL server 2012, 2008 and Oracle 12c and

11g.

Configuration and maintenance of Oracle 9i, 10g, 11g databases in Linux environment.

Implementing Backup and Recovery Strategy for databases using Hot and Cold Backups,

Logical Backups using expdp/impdp.

Installation of Oracle Client and configure TNS files to get access to Developers.

Creating and managing database objects like tables, views and roles as per user requirement.

Cloning a production database to test and development environments for testing purpose.

Coordinating with other teams for identifying Root cause analysis of issues.

Troubleshooting on DB related issues for better performance.

Database creations as per application requirement and setting backup strategies based on

business criticality.

Implementation of SQL Logins, Roles and Authentication Modes as a part of Security

Policies for various categories of users.

Configuring database mirroring and troubleshooting related issues.

Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery

solutions

Monitoring of database size and disk space in Production, Development & Test

environments.

Migrated SQL Server databases from 2008 to SQL Server 2012.

Set up Database Maintenance Plans to reorganize indexes, re-indexing and update the index

statistics on the production databases

Resolving locking, blocking and deadlock issues and taking proper steps to handle it and

rebuilding the indexes at regular intervals for better performance.

Monitoring SQL server performance using SQL Profiler to find performance and dead locks.

Performed daily tasks including backup and restore by using SQL Server 2008 tools like

SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database

Engine Tuning Advisor.

Prepared the project management and technical documentation.

Interacting with developers, Release Engineer and App support teams for implementing new

changes.

Meet the SLA (Service Level Agreement) established.

Environment: MS SQL Server 2008/2012 Enterprise and Oracle 11g/10g, Windows

2012/2008/2003 Server, Enterprise Manager, SQL Query Analyzer, SQL Profiler, SQL Developer

and Putty.

Assignment 3 Dec 2009 to May

2011

Client: Fragomen

Project Name: INSZoom Case Management System

Role: DBA

Description: INSZoom is the most comprehensive U.S. immigration forms and case management

software for immigration law firms, provides business solutions and services to law firms and major

corporations across the globe including prominent software development and information

technology firms. The product mainly helps the Attorneys of the Law firms or Immigration

management teams of the corporations in processing the different visas for their Clients/Employees.

The immigration law firms or corporations can register with the product and get the User Licenses.

Responsibilities:

Installed, configured, administered and secured SQL Server 2008/2005 versions.

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

Maintaining the Database for producing accurate results.

Troubleshooting and resolving day to day issues such as Job failures, Transactional log

issues, Database full, Blocking and deadlock issues, Permission issues etc.

Restoring and copying Production Databases.

Maintain and troubleshoot Replication issues by continuous monitoring of replication.

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

application.

Implementing Mirroring SQL Server

Resolving various performance issues and running DBCC commands, SQL Profiler and NT

Administering 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.

Perform Full Backups and Transaction Log Backups to restore them whenever necessary;

Creating backup strategies and scheduling them for execution.

Running Database tuning wizard, implementing Log Shipping and Configuring &

Monitoring SQL Server Clustering Environment.

Environment: SQL Server 2005/2008 Enterprise and Standard Editions, Windows Enterprise

Server 2008/2003, Enterprise Manager, SQL Query Analyzer, SQL Profiler.

Assignment 4 Feb 2008 to Dec

2009

Client: IEG.Gov

Project Name: Institute for Electronic Governance

Role: IT Associate

Description: JKC is an innovative and pioneering initiative that attracts the best students from all

over the state, providing them with a world class infrastructure and opportunities to apply their

knowledge to the challenging problems.

Responsibilities:

Installation, configuration and maintenance of MS SQL Server2000/2005/2008.

Performing the database up gradations from a lower version to higher versions.

Designed SQL Server instance-level, database-level and object-level security policies.

Monitoring disk space

Having Experience in database Backup\recovery and Attach\Detach methods using SSMS,

Enterprise Manager and Query Analyzer.

Resolve ticket’s that are raises on our manage engine help desk.

Created and monitored database maintenance plans for checking database integrity, data

optimization, rebuilding indexes, and updating statistics.

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

Backing up the Database on a daily basis.

Environment: SQL Server 2000/2005, Oracle 9i/10g and DB2, Windows and Linux.

Professional Accomplishments:

Microsoft Certified Technology Specialist (SQL Server 2005)

IBM Certified Database Associate (DB2 Fundamentals 9i)

Administering Microsoft SQL Server 2012 Databases

Recognized for exceptional contributions to the CGI Advantage ERP

project

Education:

Master of computer applications.

Bachelor of computer science.

Contact this candidate