Chouhan Prashanth

Experience

1. Sql Database Administrator

   Check Up Medical Center

   Aug 2023 — Present · Harrisburg, PA, US

   AWS cloud professional with strong experience in migrating resources to AWS, AWS administration, AWS infrastructure operations, and end to end project management.• Maintains responsibility for analysis of Sybase / SQL code and development where changes are necessary. Tunes queries / stored procedures, indexes, and other database elements.• Skilled in Snowflake performance tuning, optimizing queries, and reducing storage costs by leveraging its micro-partitioning and clustering keys.• Developed entire frontend and backend modules using Python on Django Web Framework and created User Interface (UI) using JavaScript, bootstrap, Cassandra with MySQL and HTML5/CSS• Utilized AWS Glue for ETL automation, orchestrating data transformations and workflows, ensuring streamlined data processing and reducing operational overhead.• Create and deploy ETL packages to achieve various task using Microsoft integration services (SSIS). Automate backups, refreshes, maintenance jobs, Bulks inserts data migration, data extraction, transformation and loading from multiple data sources• Led the migration of legacy databases to AWS RDS (PostgreSQL), reducing maintenance overhead and ensuring seamless transition with minimal downtime.• Monitored, analyzed, and optimized Sybase TSQL stored procedures and views• Developed & deployed Python script for enhanced security on new Users creation on Oracle & MySQL Databases.• Migrate SQL server database to AWS hosted DBs, managed instances. Configuring AWS site recovery for DR and back-up on-premises/AWS environment.