Sql Server DBA

VIJAYALAKSHMI ABARANJI ( Viji )

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

Mobile : +1-216-***-****

EAD Holder, Can work for any employer in USA.

SUMMARY

5+ years of IT experience in Database Development and Administration on MS SQL Server in Production, Testing and Development Environments.

Experience in Installation and Configuration of MS SQL Server.

Experience in Upgrade, Managing, Monitoring and Troubleshooting of MS SQL Server.

Experience in Database Backup, Recovery and Disaster Recovery procedures.

Implement/Support Log Shipping, Mirroring, Replication, Clustering, AlwaysOn Availability Group.

Experience in Managing Security of SQL Server Databases by creating Database Users, Roles and assigning proper Permissions according to the business requirements.

Experience in creating database Maintenance Plans to perform regular backup jobs and monitored the jobs by generating Tools alerts.

Experience in Using Performance Monitor/Profiler to solve dead Locks/Long Running Queries.

Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using BCP and DTS utility.

Supported Reporting Services (SSRS), Integration Services (SSIS) and Analysis Services (SSAS).

Experienced in Creating Databases based on Functional Requirements and System Design.

Implement/Supported for Stored Procedures and Triggers.

Experience working in Production 24/7 and Development Environments.

Excellent analytical, Interpersonal and Communication skills, fast learner, hardworking and versatile team player.

Domain Expertise lies in Health Care, Stock Exchange Market, Apparel Industries, Call Centers, HRMS, Banking, ERP and MIS.

CAREER PROFILE

Currently working as SQL Server DBA in Integration Developer Network (May 2013 to till date).

Worked as Database Consultant in Fomax Information Technologies Pvt. Ltd. from Jan2012 to Feb 2013.

EDUCATION

Master of Science (M.Sc), 1stClass with Distinction,Bharathidasan University.

Bachelor of Science ( B.Sc), 1stClass with Distinction,Bharathidasan University.

SKILLS

Database: MS SQL Server 2016/ 2014/ 2008R2 / 2005/ 2000, MS-Access,

SQL Server Tool Idera SQLdm, MS-SQL Server Enterprise Manager, Profiler, Query Analyzer, Export & Import tools,

Operating System Windows Server 2016/ 2012/ 2003, Windows 2000 Advanced Server, Windows NT 4.0, Win XP Prof/Standard & UNIX, Linux.

ETL Tool SSIS

Miscellaneous: Microsoft Exchange Server 2000/2003, Apache Web Server, VB Script

PROFESSIONAL EXPERIENCE

Miller, World wide Feb 2015 - Till Date

Miller is one of the world’s largest brewers, operating across six continents. The management is committed to maintain high standard of corporate governance. The management applies integrity, principals of good governance and accountability throughout its organization. To achieve integrity and well communication, Miller uses SYSPRO ERP which uses SQL Server as its data store. Apart from this, Miller branch and partners use many other applications for their day to day business activities like production plan, Vendor Management Inventory, PQRS, HRMS and etc.

I have involved in migrating about 12 + SQL Servers which are containing around 60 databases from SQL Server 2005 version to SQL Server 2016 version and maintaining the databases on the daily basis.

Responsibilities:

Worked on installation, upgrade and configuration of MS SQL Server databases/ servers.

Involved in migration of databases from SQL Server 2005 to SQL Server 2012/2014/2016.

Actively participated in gathering User Requirement and System Specification.

Maintained security by creating users and giving appropriate permissions to users.

Installed and configured SQL Server Reporting Services (SSRS).

Created database setup as per the user requirements.

Installed SQL Server Analysis Services (SSAS).

Involved in modifying the back up schedule and the disaster recovery plan.

Documented for migrating databases from SQL Server 2005 to SQL Server 2012/2014/2016.

Environment:

MS SQL Server 2005 / 2008 R2/ 2012/ 2014/ 2016, Windows 2003/2008/2012/2016 Server.

Product Quality Rating System, (PQRS) May 2013 – Jan 2015

This is a Product Quality Rating System and is used to generate the Quality oriented and Customer feedback. With this tool, we can generate different types of reports and Dashboard. This product tool is SaaS (Software as a Service) based. We can design and develop all types of reports what a customer is needed.

Responsibilities:

Installation & Management of MS SQL Server.

Involved in Database design, User management.

Maintained security by creating users and giving appropriate permissions to users.

Running DBCC consistency checks & fixing data corruption in application Databases.

Managing the use of disk space, memory & connections.

Monitoring MS SQL Server performance and network issues.

Environment:

SQL Server 2005/ 2008R2 / 2012, Oracle, and Windows 2003.

Health Diagnostic Report Software Jan 2012 to Feb 2013

The Client is a global leader in the Healthcare development; manufacturer and sale of sleep diagnostic systems. Doctors, research facilities and hospitals use these systems to diagnose sleep disorders. The research softwares are somnologica and Rembrandt. Aim of this project is to develop Report Engine for those softwares.

Responsibilities:

Created database objects like tables, views, indexes etc.

Wrote T-SQL statements using DML and DDL for retrieval of the data.

Created complex stored procedures, triggers and cursors in SQL Server.

Created automatically running Stored Procedures and trigger for the day end operation.

Server Installation, Database Administration, Production and Development Support.

Involved in capacity planning, estimating and sizing of tables.

Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables.

Used SQL Profiler and performance monitors to enhance the performance of database servers.

Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.

Using Performance Monitor/Profiler to solve Dead Locks/Long running queries.

Worked on DTS packages for transferring data from various data sources like Oracle, MS Access, Excel, *.Txt file, *.CSV files.

Involved in setting up backups for the newly created databases. Scheduling transfer of backups and log files to different servers.

Published high-level technical documentation to set standards, guidelines and best practices for SQL Server Database Installation, Administration, Backup & Restore Procedures, Database Security, SQL Database Development and Access database upgrades across the enterprise.

Environment:

Windows2000 Advanced Server, MS SQL Server 2005/ 2008 R2/ 2012

PERSONAL DETAILS

First Name : VIJAYALAKSHMI

Last Name : ABARANJI

Language skills

Good communication skills in English and Tamil

Immigration Status

Having EAD status and eligible to work for any employer in USA

Contact this candidate