About

Sandeep CHARAYA, Database Administrator

Professional Summary

Sandeep Charaya is dynamic professional working with a growing organization and utilizes his technical / management skills, creativity and innovative thinking for the benefit of organization. He has 13+ years of experience as a Database Administrator and writing queries. He has knowledge in ITIL process, leadership and team training. Highly motivated and ambitious, able to give timely and accurate advice, guidance, support, and training team members. Complete understand the security requirements of the business (gxp / non-gxp), measures, monitor and continuously improve performance process.

PERSONAL SKILLS

Performance Tuning and Troubleshooting specialist
Understand the concepts of current hardware systems, RAID and SAN, NAS commonly used in fault tolerant production environments and Windows Server operating systems
Ability to proactively identify, troubleshoot and resolve live database systems issues and to manage database maintenance plan activities including backups, indexing, integrity and consistency checks.
Participation in the creation of an Enterprise Reference Data Architecture for a Client
Collaboration with the business, its applications, solutions, and with technical architects to understand the implications of respective architectures on data architecture and to maximize the value of information across the organization (GxP environment)
Work with the Clients Database Administration / Architecture and Data Analytics teams to help set the enterprise data strategy and standards
The creation and implementation of processes to collect and maintain inventory of GxP Data assets across the Clients enterprise
Drive standardization and simplification across the enterprise, lowering cost, improving quality and value of data assets
Assist in maintaining the assessment and inventory of the existing enterprise-level data environment.

SKILLS

Performance Tuning Troubleshooting GxP Documentation Always On Clustering SSIS SSRS ITIL Tivoli Data Protection PowerShell MS Azure Other backup tools like redgate, Snap Manager SCOM Automation Transition Coordination Quality Replication Mirroring Replication Customer Handling Manage SLA Query Optimization

WORK EXPERIENCE

Nov 2018 – Till now

Tata Consultancy Services, United States – Technical Architect

Implementation of HA & DR solutions available within SQL Server (FCI, Log Shipping, Mirroring, Replication, Availability Groups)
Solving performance issues
Helping engineers reviewing code and discussing improvement methods
Supporting and prompting resolution of production issues
Monitoring and analyzing systems performance data.

Aug 2016 – Oct 2018

Tata Consultancy Services, Germany – Sr DBA

As a database team leader handle all architecture and development change with the team.
Improvement performance process and best practices configuration for database servers.
Automating processes using Powershell, the company had significant time gain to employees, since manual processes were executed monthly to collect information from databases.
Database cloud migration to AWS, using Powershell could improve when necessary to create new environments on RDS and automating S3 copies from VPCs.

Nov 2012 – Aug 2016

Tata Consultancy Services, India – DBA

Change management and implementation improvements with new environments and users access control. Improvement performance process and best practices configuration for database servers.
Disaster and recovery projects to replicate data between branch offices in the country to protect data for each office.
The company minimized the adverse impact of incidents and problems on the business that is caused by errors within the IT infrastructure.
Implement integration between AD and the database, using Powershell and XML to use the same information from Windows Active Directory and the company’s systems

Nov 2008 – Nov 2012

Ionnor Solutions Pvt Ltd., India – Team Coordinator

Leading different projects and worked as coordinator between onsite and offshore team
Improving performance process and configuration of servers to reduce incidents
Data replication between organizational units.
Provide accurate information on configurations and their documentation to support all the other service management processes in the organization.
Team leader located in Mexico to achieve better utilization of IT resources.
ETL process performance boosts to improve data update time and automate a new business process.
Planning and execution with the team to migrate databases located in the data center in Mexico to the new data center in the United States.
Migration database version from Microsoft SQL Server 2000 to 2008 R2.

Dec 2005 – Oct 2008

Comm-IT Pvt Ltd., India- Jr DBA