Sql Server Data

Ramya Naine

**********@*****.***

Cell: 714-***-****

Anaheim, CA

Professional Summary:

3+ years of experience in Database Design, Development, administration & Support of MS SQL Server 2014/2012/2008/ for Production/development.

Patch Dev/SIT/Production databases by applying PSUs and one-off patches provided by Microsoft.

Performed Administrative tasks in SQL Server using PowerShell.

Handle database environments on daily basis observing performance of the production database and constantly active regarding performance and space management issues.

Created users, groups, roles and assigning users to groups and granting object level permissions to appropriate groups.

Acquaintance in supporting Very Large databases (VLDB) and troubleshooting the problems in OLTP Environment.

Knowledge in Extraction Transformations and Loading (ETL) tools like SQL Server Integration Services (SSIS), Data Transformation Services (DTS), Bulk Insert, and Bulk Copy (BCP).

Knowledge in Transact-SQL (DDL, DML, DCL) and in Design and Normalization of the database tables.

Monitored and modified Performance using execution plans with query hints and Index tuning.

Created maintenance plans to perform index defragmentation, re-indexing and update Statistics.

Involved in Monitoring Performance of different production servers.

Knowledge on AWS, Azure, Oracle and SYBASE environments.

Used various SQL inbuilt tools like SQL Profiler/Perfmon/Execution plans and 3rd party tools like Idera, Redgate to track issues, identify bottlenecks and implementing solutions.

Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player.

TECHNICAL SKILLS:

Operating Systems : Windows 2012/2008/2005/2000, Windows 98/ XP/ Professional

RDBMS : SQL Server 2016/2014/2012/2008R2/2008/2005, MS Access

Database Tools : Profiler, DTS, Management Studio/Enterprise Manager, Query Analyzer & SSIS

Web Technologies : XML, HTML,

Languages : T-SQL and DBMS.

Other Tools : Lite Speed, Red gate

PROFESSIONAL EXPERIENCE

Daimler Trucks North America LLC, Portland, OR Sep 2016 - Dec2017

MSSQL SERVER DBA

Responsibilities:

•Install, Configured SQL Server, 2012, 2008, 2008R2, Enterprise & Standard editions on 64 bit systems.

•Involved in Planning for Upgrades and Migration of major systems from SQL Server 2005 to SQL Server 2012 and from SQL Server 2008 R2 to 2012/2014.

•Created the backup and restore strategy for production and development environment.

•Involved in Quality Test (QA) of Data for successful Migration.

•Created SSIS packages for various Data Source and Data Destination Mappings for transfer.

•Worked on setting up and managing Merge and Transactional Replication.

•Monitoring SQL Server Jobs and Troubleshooting on failure.

•Experience in Configuring and Maintaining Database Snapshots.

•Implemented Database mirroring and Log shipping for disaster recovery.

•Trouble shooting issues on Replication/Log Shipping/Back up & Recovery.

•Involved in migration of databases from SYBASE / ORACLE to SQL server 2012 using SSMA.

•Maintaining the servers - applying patches and service Packs.

•Involved in Performance Tuning on Production, QA and Staging servers of the current project

•Backup and Restoration of System and User databases.

•Rebuilding the indexes at regular intervals for better performance.

•Created extensive reports using SSRS.

•Used the Execution Plan to improve the optimization of the T-SQL code

•Maintained various databases for Production and Testing using SQL Server 2012/2008 R2.

•Planning the location of data, index and Transaction log files on the disk.

•Using SQL Server Integration Services (SSIS) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for ETL application.

Environment: MS SQL Server 2014, SSIS, SSRS, SSMS, SSMA tool, BCP command, RED GATE

HR Software Solutions Pvt. Ltd. Hyderabad, INDIA Jan 2013 – June 2015

MSSQL Server DBA

Responsibilities:

Worked extensively on installing, configuring and maintaining of SQL Server 2012 servers on Windows server 2012 R2.

Installed, configured and maintained MS SQL Fail over clustering to provide server high availability solution for different environments.

Backup and Restoration of System and User databases.

Scheduling database backup jobs.

Managing security, monitor server performance and activities.

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

Daily Monitoring of the Database Performance and network issues.

Responsible for creating Logins, Users and Assigning database Permissions.

Involved in Scheduling database backup jobs.

Documented all the steps and procedures for future references.

Managing security, monitor server performance and activities.

Certifications:

MTA: Database fundamentals (98-364).

MCSA: SQL SERVER 2012/2014(70-462).

Academic Qualifications:

California University of Management and Sciences, California

Masters in Computer Information System

Jawaharlal Nehru Technology University, INDIA

Bachelor’s in Electronics and Communication Engineering

Contact this candidate