TULSI VYAS

LOS ANGELES, CA • 973-***-**** • adhu11@r.postjobfree.com

Professional Summary

• 9+ years of experience in database administration, development, design, deployment and production support.

• Expertise in maintenance and security of database servers, troubleshoot and support in a fast-paced work environment.

• Experience in designing and planning for high availability, strong knowledge of database recovery models, backup procedures and disaster recovery plans.

• Strong collaborator and team player with excellent analytical problem solving and communication skills.

Skills

• Transactional Log shipping

• Always On availability groups (AG)

• High Availability (HA)

• Disaster recovery (DR)

• Data backup and retrieval

• Performance tuning and Optimization

• Release impact and planning

• T-SQL/SSIS Development

Expertise

• Microsoft SQL Server • SSIS • SSRS • Visual studio • BIDS • AWS • SentryOne • Redgate • MoveIT • PTC/Integrity • Trackstudio

Work History

Database Administrator June 2015 - Present

ALTISOURCE SOLUTIONS INC – Los Angeles, CA

• Perform database administration tasks including system management, backup/recovery, enforcing user access policy, SQL server agent/SSIS jobs configuration and provide on-call support.

• Work with Architect team to discuss and design database architecture, update coding standards and enforce best practices.

• Cross functionally work with multiple teams including Application Support, DB Development and QA to support SDLC stages for the Change Requests, identifying bugs and deploying critical fixes through tickets and code changes on Production environment.

• Took a lead on research and planning on database migration project from MS SQLServer 2008 to 2016. Successfully implemented data migration that helped in resource and cost optimization resulting in 100k+ licensing cost reduction.

• Proactively identify issues and recommend process improvements, design and implement solutions and testing to meet and maintain client SLAs.

• Monitor performance with SQL server and third-party tools, ensure availability and security of mission critical highly transactional OLTP database.

• Configure alerts for data integration jobs and setup proactive notifications for disk usage, temp DB growth, index fragmentations and long running queries.

• Generated database system related reports and assisted audit team for SOX audit purpose.

• Administer and support 100+ production databases with maintenance activities including rebuild indexes, update stats and occasional manual maintenance.

• Deploy and troubleshoot complex SSIS packages for multiple ETL systems on Production and staging environments.

• Establish disaster recovery plan with the team and implement Distributed Availability Group

(AG) across different datacenters.

• Actively worked on rigorous performance testing for a high-volume EPI (Existing Property Import) project before the go live on Production, deployed it on production and successfully imported 1M+ properties into Legacy system.

• Worked on designing database archive process for growing application database. Database Release Engineer Feb 2013 – May 2015

ALTISOURCE SOLUTIONS INC – Los Angeles, CA

• Performed daily database deployment across environments and configured SSIS jobs.

• Implemented automated database deployment tool in place to cut down release time significantly.

• Reduced environment downtime during environment refresh process by 50%, by implementing scheduled maintenance plans, backup and restore jobs, scripting out, applying and syncing user/permissions and automating post refresh steps.

• Monitored database performance during each release cycle on staging environments to catch performance issues and identify bottleneck. Recommended suggestions and worked with database developers on query optimization and performance tunings.

• Closely collaborated with project members to identify and resolve DB Code issues, improve operations.

• Assisted QA team during integration and client testing on various staging environments and monitored system performance.

• Created a mission critical database restore template from production to Extended Beta environments, keeping in mind special requirements like only restoring certain requested client data, ensuring security and integrity for rest of the clients. SQL Server Developer/BI Developer June 2011 – Feb 2013 EQUATOR LLC – Los Angeles, CA

• Developed custom database objects, stored procedures and delivered application support.

• Maintained complex T-SQL queries, views and stored procedures in multi-database environment.

• Designed and configured end to end ETL workflow and dataflow processes to support many different data source and file structures for business processes.

• Improved application performance by researching root cause of critical issues, developing hotfixes and ensuring smooth release to production.

• Successfully delivered multiple client projects for data import/export, report generation, that are currently up and running and a part of legacy system.

• Worked on creating several staging tables from data mapping documents and developed several complex packages for EPI project - Existing Property Import from client system to Equator system.

• Designed SSIS Packages for importing data from multiple clients and developed complex mappings using SSIS to transform and load data from various sources like SQL Server, flat files, .csv files, .xlsx file etc.

• Optimized long running queries, stored procedures and SSIS packages that are impacting the performance.

• Used SQL Server agent for creating, maintaining and scheduling TSQL and SSIS jobs.

• Made use of various SSIS configurations including SQL server, XML files and Environment variable configuration, to smoothly promote the packages to staging and production environment.

• Included checkpoints and custom loggings to handle errors by redirecting it to the exception tables.

Education

Master of Science: Computer Science, July 2010

Georgia Southwestern State University

Bachelor of Science: Computer Application & Information Technology, Oct 2008 Hemchandracharya North Gujarat University, India

Contact this candidate