Working as an associate database architect. Primary responsibility includes monitoring, capacity planning and health check of production environment for various alerts, optimization of slow performing queries, DB migration from 2008R2 to 2019, automate the redundant tasks and helping in designing to dev team for various works. Migrated SQL Server 2008 R2 DB, SSIS packages and SSRS reports from standalone instance to SQL Server 2019 AG. Installation and configuration of SQL Sentry DB monitoring tool to monitor all the prod servers. Review the code developed by dev team before deploying to production.

Worked as DBA in L2 support role. Primary responsibility includes monitoring, capacity planning and health check of production environment for various alerts, optimization of slow performing queries, DB migration from on-prem to AWS EC2 instances, automate the redundant tasks and helping in designing to dev team for various works. Review the code developed by dev team before deploying to production.

Worked in a DBA support role. Primary responsibility involves the installation/configuration of SQL Server for development and test environment. Monitoring the prod environment for various alerts. Optimization of slow performing queries. Code review of the database objects developed by dev team. Developed the Datawarehouse project for production and also deployed it on the EC2 instance. Migration of reports from SQL Server to Redshift database.

Worked as developer DBA. Primary responsibility included the development of various stored procedures/triggers/views/function etc. for various user stories. Performance tuning and optimization of various reports and procedures. Secondary responsibility was preparing the UAT and dev environment and assisting DBA.

Worked as a database and.Net developer. Primary work involved the development of various UI components using.Net framework, java script and writing stored procedures/function/triggers/views etc. for the backend component. Developed the custom code analysis for database objects to show the objects that do not follow the standards designed by the DB Architect. Automate the unit test case for stored procedures.