Rss

Contact_user

maulik p

Database Administrator - 6 Years of Experience

Occupation:

Database Administrator

Education Level:

Bachelor

Will Relocate:

YES

CollapseDescription

Summary: * Over 8 years of IT experience in Administration and Development on Database Design using SQL server (2005, 2008, 2012,2014 2016 Servers in OLAP and OLTP environment), Oracle (11g 12c) and AWS environments. * Excellent SQL Server administration skills including Database Creation, Tables, Indexes and Clusters Creation. * Experience working on oracle 11g and open source database like MySQL. * Worked and troubleshoot application running on DB2 databases. * Experience working with Tableau, TOAD SQL, Redgate and Idera. * Experience in creating table with In memory oltp, identifying In memory OLTP Hash collisions for sql server 2014. * Planning and implementation of Disaster Recovery and maintain High Availability of database. * Involved in Migrating SQL Server 2008 databases into SQL Server 2012 databases. * Installation and configuration of oracle 12c on windows. * Configuration of oracle sql developer. * Experience in writing codes in PL/SQL. * Experience in Always On cluster and creating AAG. * Extensive use of DTS/SSIS packages in SQL Server, Performance Tuning & Application Design, Disaster Recovery Planning, Security Management, Managing server and clients. * Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities. * Experience with RAC administration, installation, configuration and patching. * Experience in T-SQL Developer skills include stored procedures, Indexes views, User Defined Functions (UDF), Triggers, and Distributed Queries, Scheduled Tasks. * Expertise in writing and debugging Stored Procedures and Triggers. * Excellent skills in database Backup, Restore, Recovery, Replication, Linked servers, Database Maintenance Planning. * Understanding & Working knowledge of CDC (Change Data Capture). * Experienced in DBA activities include Installing & maintaining SQL Server database system, Logical/Physical database design and administration, Backup & Recovery, Log Shipping, Database Mirroring and Performance Tuning. * Implemented and provisioned AWS services combining hands on experience with services like EC2, Cloud Front, Cloud Formation templates and monitoring services like Cloud Watch etc. * Experience in providing Logging, Error handling by using Event Handler, Query Optimization and Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations. * Perform backups, DBCC utilities, updating index statistics, monitoring database * Performance monitoring, estimate the number of users, CPU and Disk space requirement, identifying bottleneck and rectifying it. * Implemented AWS solutions using E2C, S3, RDS, EBS, Elastic Load Balancer, Auto-scaling groups. * Migration and maintenance of data using various utilities like DTS/SSIS, Import and Export, Attach/Detach Data Migration tools. * Extensively use SQL Profiler, Index Tuning Wizard, Windows Performance Monitor for monitoring and tuning MS SQL Server performance * Experience in SQL Server concepts SSIS (SQL Server Integration Services), SSAS (Analysis Services) and SSRS (Reporting Services). * Excellent written, verbal communication and leadership skills to develop creative solutions for challenging client needs. * Quick learner and good performer work well independently and on a team * Experience is providing 24X7 support and on call rotation schedule.

Right_template4_bottom

CollapseWork Experience

COMPANY POSITION HELD DATES WORKED

(Confidential) Dba /Data Modeler 4/2017 - Present
Holiday Systems International Production Dba/ Developer 10/2016 - 3/2017
Hurley Medical Center Cloud Dba 6/2014 - 9/2016
Bank Of Baroda Sql Server Developer 5/2010 - 7/2014
Right_template4_bottom

CollapseAccomplishments

Highlights:

Left_template4_bottom

CollapseJob Skills

Left_template4_bottom

CollapseKeywords

Left_template4_bottom