Swathi D

Pune

adefop@r.postjobfree.com

91-918*******

SQLServer Database Administrator

Key Skills:

Provisioning SQL Server instances

High Availability Options

Security

Disaster Recovery

Performance Monitoring

DB Backups and restores

Distributed Team Environment

Database Tuning

Agile Scrum Methodology

Scheduling and monitoring maintenance tasks

VLDB Migrations

Professional Summary:

Having 6+ years of Progressive technical experience in Database Administration.

Responsible for Software Installation, configuration and maintenance of SQL Server Instances from 2000 to 2016.

Involved in Applying patches and service packs to keep the database at current patch level. Experience in Upgrading SQL Server Versions from 2005 to 2016.

Good knowledge of DB backups and restoration, performed point in time recovery plans.

Safeguarding data by instilling backup and managing user access and securing databases using encryption methodologies like Transparent Data Encryption.

Performed day to day DBA activities such as monitoring SQL Server health, job status, Addressing Change requests from the teams.

Experience in query optimization & performance Monitoring.

Ensuring data integrity by creation of constraints as and when required.

Experience in data migration in 3 flavors of databases i.e. Oracle, SQL Server, Sybase using Internal tools

Exposure towards High availability and Disaster recovery in various topologies such as DB Mirroring, Replication, Log shipping, Always on Availability Groups and SQL Server Clustering.

Researching new features, products, frameworks, trends, and tools to improve the efficiency and offerings of the DBA team and the Information Services department.

Developing SQL scripts for maintaining administration tasks and sending reports to respective teams using DB Mail

Maintain all the SQL documents include installation and data conversion Procedures and DB dictionary documents.

Responsible for Disaster recovery and High availability solutions and large scale database migrations.

Having Exposure in MS Azure cloud technologies.

Knowledge of backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Constraints, Defaults, user defined data types and functions.

Worked with Agile Scrum Methodology in collaboration with distributed teams.

Good time management skills and well adherence to agreed SLAs.

Technical Skills

Hardware:

DELL 6850 Servers, DELL 6300 Servers, SAN arrays, Pentium PC’s and Windows 2000 Servers

Operating Systems:

Windows Server 2003, WINDOWS XP/2000/NT, WINDOWS 7, Windows 8

Software:

MS SQL Server 2000/2005/2008/2008R2,2012,2014,2016 T-SQL, Oracle, Sybase

Tools:

SQL Server Management Studio, Toad, SQL Developer, Interactive SQL(Sybase), SQL Profiler, Database Engine Tuning Advisor, Data Migration Assistant, Export/Import wizards,Nagios,Team city, Sql database recovery tools

Experience Details

Worked in Planon Software Services Limited, Hyderabad .

Role:

SQL DBA(May'2008 – Apr’2014)

Responsibilities:

Install\configure\upgrade\patch SQL server Stand Alone and Clustered instances. Work with SAN Storage team\Active Directory Team\Windows Team\Tape Backup to ensure prerequisites are met for new server build.

Created, administered and maintained Databases

Monitored the health and performance of SQL Server instances using SQL Profiler, Performance monitor, Activity monitor and extended events.

Setup and maintained Log shipping between various environments

Optimized the indexes, adding/deleting them when necessary for better performance.

Configured Always on as a High availability solution For client environment.

Implemented appropriate backup and restore strategies to protect all data assets.

Involved in designing and implementing a Disaster Recovery Plan.

Provided database administration support to projects that are assigned by Planon.

Migrated SQL databases from SQL Server 2005 to SQL Server2008R2

Verified backups and error logs on the servers and troubleshoot for any failures.

Working as a freelancer

Role:

SQL DBA(Feb'2015 – Till date)

Responsibilities:

Migration activities like SQL server migration from SQL server 2008R2 to SQL server 2012.

Migrations from SQL server 2008 to SQL server 2016 both on-premise as well as azure.

Performed side by side upgrade of SQL instances.

Executed Change management scripts on daily/weekly basis.

Experience in performing database regular Backups Full/Differential/Transaction Log Backups into Disk and Restoring on requirement.

Experience in Index Maintenance Index tuning, Rebuild Reorganizing according to Index fragmentation, running DBCC checks and Update Statistics to check Data Integrity.

Experience in identifying the I/O and memory, bottle necks, blocking and deadlocks caused by complex queries using SQL Server Activity monitor/profiler and handling them by implementing better Query Execution plans.

Upgrading SQL servers by applying Service packs, Security patches and Hot fixes on Standard and Cluster instances.

Good experience in Backup and restore and data recovery.

Resolved customer incidents within the agreed SLA.

Enrolled various online courses to keep myself up to date with the technological developments.

Ability to learn things quickly and adaptable to new technologies.

Started learning new skills by enrolling various online courses of Microsoft SQL Server Database Administration and Azure Cloud technologies.

Completed Microsoft certified Professional exams.

Education

oB.Tech Information Technology (2001-2005) Anna University Chennai

Certifications:

oMCSA: SQL 2016 Database Administration - Certified 2020

Contact this candidate