Sachin Jain

• Installed , configured and maintained On - Premises SQL Server 2012,2014,2016,2017,2019 in in clustered and standalone environment.
• Migrated on premises SQL Databases to Azure/AWS .
• Designed databases to support business applications, ensuring system scalability, security, performance and reliability.
• Configured and Maintained Always On Fail-Over Clustered high-availability environment in SQL Server 2014/2016.
• Extensively provided ETL Application support , SSIS Package Administration/ Deployment /troubleshooting.
• Performed SSRS server Migration from SQL 2012 to SQL 2016.
• Performed SQL Server database Migrations from SQL 2012 to SQL 2019.
• Configured Transparent Data Encryption (TDE) and backup/Restore strategies on encrypted databases .
• Designed and developed scripts to refresh selective data from production to development, QA and production support environments.
• Engaged in security audits, ,SQL Patching and disaster recovery measures.
• Interact with developers, network, virtualization, storage and systems operations teams to resolve problems with applications and database systems
• Worked on Backup strategies /Index Maintenance/ Database Consistency Checks as part of database maintenance.
• Administered and monitored 24/7 applications and systems, developing automated alerts to warn of failures.
• Maintained detailed documentation of solution designs and business requirements.

Environment : MS SQL Server 2008r2,2012,2014,2016,2017,2019, Windows 2008r2,2012,2016, SSIS ,SSAS, SSRS , Power BI ,Crystal reports , MS Access , Oracle 11g,VMware, Solarwinds DPA,Visual Studio 2017,Azure DevOps Server

• Installed , configured and maintained On - Premises SQL Server 2012,2014 in clustered and standalone environment.
• Extensively worked on HA and DR solutions to meet customer requirements for various state agencies.
• Configured Always-On with synchronous and asynchronous secondary replicas for 2 node cluster.
• Worked on applying Service pack upgrade for SQL 2012 SP3 to SQL 2012 SP4 on 2 node always on cluster.
• Consistently met deadlines and requirements for all production Deployments.
• Provided continued Database maintenance support and applied SQL Patches/Bug Fixes for existing Database Servers under Service Pack upgrade Project.
• Extensively worked with server level ,Query level tuning for effective performance.
• Created in house monitoring system using power shell scripts for getting backup reports and various SQL server alerts .
• Extensively worked on automating manual process like Backup/Restores, Automating SQL server Build processes by creating Templates for SQL 2012/2014/2016 versions.

Environment : MS SQL Server 2008r2,2012,2014,2016,2017, Windows 2008r2,2012,2016, SSIS ,SSAS, SSRS , Power BI ,Crystal reports , MS Access ,VMware, Windows Clustering,AWS,Azure

• Installed , configured and maintained On - Premises SQL Server 2008,2008r2 in clustered and standalone environment.
• Extensively worked on SQL Server database design, development , and implementing to support business needs and deadlines.
• Designed and developed scripts to refresh selective data from production to development, QA and production support environments..
• Consult with Service Owners, Managers and Senior Project Managers in order to prioritize and scope technical needs of Advanced technology / high impact projects.
• Interface with cross-functional teams and departments to access and understand business needs.
• Implemented company policies, technical procedures and standards for preserving integrity and security of data, reports and access.
• Extensively used SQL Server DB Snapshot for Backup / Restore strategy as part of Quarterly application upgrade .
• Evaluate and test new versions and features of SQL Server 2012.
• Worked on Capacity planning and providing strategies for ongoing increase in data storage and data maintenance.
• Utilized Red Gate Tools SQL Compare and SQL Data Compare for promoting modified objects from development to acceptance and productions
• Work with Server/SAN team to diagnose IO latency occurring with several VM's suffering from - IO taking longer than 15 seconds Configured HADR techniques such as log shipping and Always on.
• Extensively worked on Data migration from physical to Virtual and virtual to virtual across various versions of SQL Server.
• Engage in security audits, database encryption, and disaster recovery measures.
• Create Server/Database level SQL Auditing (DDL trigger), Change Data Capture (CDC).
• Troubleshoot with connectivity, DNS, security and firewall issues.
• Work with domain admins to create appropriate service principle name (SPN) for implementing Kerberos authentication on all SQL Servers.
• Work with change control process for deploying changes in production servers.

Environment : MS SQL Server 2005,2008,2008r2,2012,2014, Windows 2008,2008r2,2012

• installing, configuring, managing, monitoring, and troubleshooting SQL Server 2000, SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2, 2012, 2014, 2016, 2019.
• Hands on experience in installing & configuring Active Passive clustering setup of SQL Server 2008 R2.
• Hands on experience of high availability SQL Server solutions, including Log shipping, Database Mirroring, SQL Server clustering and HADR Availability Groups.
• Extensive experience with SQL Server and T-SQL in constructing triggers, tables, user defined functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Extensive Experience in providing Production support for Database and Applications.

• Proven ability to learn quickly and adapt to new situations.
• Paid attention to detail while completing assignments.
• Developed strong communication and organizational skills through working on group projects.
• Demonstrated creativity and resourcefulness through the development of innovative solutions.
• Worked well in a team setting, providing support and guidance.
• Resolved problems, improved operations and provided exceptional service.

• Providing Production support for Database and Applications.
• Installing, configuring, managing, monitoring, and troubleshooting SQL Server 2000, SQL Server 2005.
• Use of high availability SQL Server solutions, including Log shipping, Database Mirroring, SQL Server clustering.
• T-SQL in constructing triggers, tables, user defined functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
•