Sql Server Maintenance

Radhika A Email: *************@*****.***

Sr. SQL Server DBA Mobile: 571-***-****

Having 10+ Years of SQL Server DBA experience in Telecommunications, Finance, Oil & Gas verticals.

Experience in setting up SQL Server environments (2008R2 & 2012) on Win 2008 R2 & 2012.

Experience in Database design, Backup & Recovery, Performance tuning and Query Optimization, Data Transformation Services and Database Security.

Experienced in creating Maintenance plans and backing up databases, restoring databases. Creating jobs experienced in rebuilding master database and restoring Master database and user databases.

Implemented Always ON for High availability on SQL Server 2012.

Experienced in managing SQL Server and Database Security, Authentication modes, creating Roles, Logins, User Accounts, managing Database and User Permissions.

Experience in configuring memory, monitoring the disk usage and the memory usage of the servers.

Experience in using Data Compare tools.

Auditing of database for users transaction, login and database action and removing orphan users.

Experience in configuring memory, monitoring the disk usage and the memory usage of the servers.

Experience in querying the databases using the Powershell scripts.

Having experience in working with Microsoft Azure cloud and AWS.

Identifying the bottle necks using SQL Server Profiler and Perfmon and troubleshooting the performance of bottle necks.

Experience in using Microsoft's in built tools like SQL Profiler, Windows Perfmon and DTS, SSIS, SSRS for Monitoring, Developing and Tuning MS SQL Server applications.

Monitoring Event viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.

Managed Security like windows and SQL Logins, Roles, permissions for various users.

Experience with SQL 2012 ALWAYS ON and Data Migration from MS SQL server 2000 to 2005, 2005 to 2008, 2008 to 2012

Experience in creating packages, Jobs, Sending Alerts using SQL Mail and custom extended procedures like XP_SMTP_MAIL.

Experience in migration from SQL Server to Oracle.

Having experience in Installation applying service packs and patches of SQL Server 2008/2012/2014 in standalone and having knowledge in clustered environment.

Strong Knowledge in ITIL (Information Technology Infrastructure Library) procedures and practices.

Setting up and monitored Disaster recovery environments like Database mirroring with in the primary Datacenter servers and Log Shipping between primary and secondary Data center servers

Implementing database disaster recovery plans.

Experience in Query Optimization, Database Consistency Checks using DBCC Utilities, and Linked Servers and also analyzing the execution plan and index management for better Query Optimization.

Worked in 24x7 Production support.

Excellent team player with good communication skills having ability to adapt new technologies.

Enthusiastic, flexible and project oriented with strong interpersonal skills to develop creative solutions for challenging client needs.

Technical Skills:

Operating Systems: Windows server 2012 datacenter, Windows Server 2008R2 datacenter,

2008 and 2003R2, Windows XP/7/8.

Data Bases: SQL Server 2008, 2008R2, 2012 and 2014.

Scripting Languages: PowerShell.

Tools: DB Comparer, Profiler, HP QC.

Skills: SQL DBA, SSIS, SSRS (as ETL) AND T-SQL

WORK EXPERIENCE

Senior Program DBA

Shell Oil & Gas – Houston, TX December 2014 to 7/5/2016.

As Program DBA, I have installed and configured staging and production environments.

I was also responsible for day to day database administration, maintenance and support activities, including installation and configuration of SQL Server in High-Availability Always ON

On production environment, performance tuning, backup and recovery activities, writing maintenance plans and jobs and resolved number of ad-hoc requests.

I am Responsible for maintaining the databases in sync on both the nodes and checking the health of databases in dashboard.

As a DBA, I have taken care of all the parameters at SQL server instance level and hardware level of SQL Post installation.

Worked on Query optimization, Index recommendations, Tempdb configurations.

CPU, memory and storage recommendations for performance improvement

Responsible all the DB related issues coming from Application, Development, Testing teams and Database Teams.

Working to support daily tickets coming to our application and find out its solution and assigning to various teams.

Developed PowerShell scripts based on customer adhoc requirements.

Assigning permissions to Roles and adding users to the appropriate Roles.

I am responsible for Monitoring Jobs created by Maintenance Plan sub plans.

Work experience on SSIS and SSRS services to create and deployed dtsx packages and reports.

Creating and scheduling Full and Transaction log backup Jobs. Initiating, Maintaining and Implementing SQL server best practices.

Developed and implemented complex T-SQL and PowerShell scripts for administration tasks.

Upgraded over 35 instances from SQL Server 2008 to SQL Server 2012.

Checking health of the databases and disk spaces.

Having experience on T-SQL and stored procedures

Environments: SQL Server 2008R2, 2012 and 2014. Windows server 2012 datacenter, Windows Server2008R2 datacenter.

Lead Administrator

BBH- Charlotte, NC May 2013 –Nov 2014

I worked on clustering for Active-Passive Nodes and having knowledge on transparent data encryption (TDE).

I was responsible for day to day database administration and maintenance activities, including performance tuning, backup and recovery, writing maintenance plans, creating SQL jobs and writing and running ad-hoc queries.

Installed SQL Server 2012, this includes Analysis, Reporting and Integration services.

Assigning permissions to Roles and adding users to the appropriate Roles.

Worked on Performance tuning for the project and in improving overall performance of the DB's.

Monitored Jobs created by Maintenance Plan sub plans.

Creating and scheduling full, differential and Tlog backup Jobs.

Use SQL Server Profiler traces to collect and monitor server performance.

Performed special backups during production support.

Environment: Microsoft Windows Server 2012 R2/2008 R2, MS SQL 2008/2008R2/2012/2014 Enterprise Edition,Database Maintenance Plan Wizard, SSIS, SSRS, RedGate

Senior Database Administrator

S&P Capitaliq - Arlington, TX April 2012 – April 2013

I am responsible for assigning permissions to Roles and adding users to the appropriate Roles.

I worked on Performance tuning for the project and in improving overall performance of the DB's.

Monitored Jobs created by Maintenance Plan sub plans.

Created and scheduled Full and Differential and Transaction log backup Jobs.

Created Indexes and removing overlapping indexes and high maintenance cost indexes.

Configured Database Mail and using for setting up notifications in the event of failure of jobs.

Initiated, Maintained and Implemented SQL server best practices

Used SQL Server Profiler traces to collect and monitor server performance.

Monitoring the servers for any blocks and troubleshooting of Client connections, viewing error log and applications

Environment: Microsoft Windows Server 2000/2008/2008R2, Microsoft SQL Server 2005/2008/2008R2 Enterprise Edition, Microsoft Visual Studio 2005/2008, BIDS.

Database Administrator

AT&T - Bangalore, India December 2009 – March 2012

I have Installed and Configured SQL server 2008R2.

Performed Database maintenance activities like Backups, Restoring.

As a part of the DBA team providing 24x7 production support to the clients.

Monitored the Scheduled jobs, Disk spaces on all the servers.

I have involved in adding users in the Database and granting permissions.

Scheduled jobs in Sql server

Worked on Log shipping and mirroring.

Created maintenance plan for consistency checks, maintaining indexes and statistics, performing fine Tuning of Database Application and solving Database troubles.

Involved in implementation of replication like Snapshot, Transactional.

Created various jobs, schedules, alerts, logins and notifications.

Environment: Microsoft Windows Server 2003,2005 Microsoft SQL Server 2005/2008 Enterprise Edition, MicrosoftVisual Studio 2005, Net Framework 3.5, Query Analyzer, Event Viewer, Database Maintenance PlanWizard, SSIS.

Associate Administrator

Century Link Inc., - Bangalore, India Aug 2006 to Nov 2009

I have upgraded and Migrated SQL Server 2005(SP2) to SQL Server 2008.

Knowledge of authentication modes, types of roles, how to manage security accounts, grant revoke permission to access data and how to make a security plan matching the business needs.

Monitored Jobs created by Maintenance Plan sub plans.

Involved in database Administration and Maintenance.

Monitored Databases for Dead Lock, Capturing long running SQL queries.

Created and scheduled Full and Differential and Transaction log backup Jobs.

Created and scheduled jobs to Monitor Changes in the databases.

Configured database Mail and using for setting up notifications in the event of failure of jobs

Configured and Implemented Replication techniques such as Transactional Replication.

Configured and Implemented Log Shipping in Test Database Server environments.

Configured Automatic Failover for Database Mirroring.

Used SQL Server Profiler traces to collect and monitor server performance.

Environment: Microsoft SQL Server 2005, 2008R2, SSIS, Windows 2003, 2008R2, Business Intelligence development studio 2005

Contact this candidate