Support MySQL & PostgreSQL Database Servers on a 24x7 basis.Identify and solve various database related issues using a variety of diagnostic methods, using AWS inbuilt tools like Cloud Watch and Performance Insight and Resource Monitoring. Define and document database best practices for Ecommerce environment.Proactively monitor activity, utilization, exceptions and database health to identify areas of improvement. Use scripting languages, such as bash and python, to automate various repetitive maintenance tasks.Configure and implement read-only replicas on separate region as part of Disaster Recovery Storage optimisation, Data archival implementationConduct and participate in disaster recovery exercises.Implemented the monitoring mechanism using CloudWatch.Manage Amazon Web Services - EC2, S3, RDS, CloudWatch.Database capacity planing and Cloud usage cost optimisationConfiguring database events and monitoring alerts.Refreshing Databases in Development /Testing environments on request basis.Rebuilding and Reorganizing the Indexes based on the Index Fragmentation Strategy.DB migration using AWS Data Migration Services

Administration and Supporting SQL Server, PostgreSQL, MySQL;Database Architecture, Design, SQL Server, Always-ON, Disaster Recovery, Data EngineeringSSMS, SSAS, SSRS and SSIS; AZURE Cloud, AWS Cloud, AWS RDS, AWS DMS, Windows Server 2016,2019; MYSQL/Postgres Implementation and Administration, MongoDB and ElasticSearchAutomation with PowerShell, Python, Shell Scripts

Database Administrator/Architecture/Design, SQL Server, Always-ON, Disaster Recovery, SSMS, SSAS, SSRS and SSIS; AZURE Cloud, AWS RDS, Windows Server 2012,2016; Visual Basic, ASP; IIS 6.0,7.0;MYSQL/Postgres Implementation and Administration, MongoDB and ElasticSearchPython, Jupyter Notebook

Senior DBA and Leading the Database Operation Projects.Automated the SQL Server general tasks and helped the team to reduce their efforts.Worked on Performance issues like High CPU, memory, troubleshooting the t-sql query issues and did query tuning.As a SQL DBA, maintaining and monitoring SQL server.I am responsible for the SQL server migrations.Need to handle all the SQL Server escalations which comes to SQL team.Need to coordinate with the business analyst and discuss about the projects plans, upgrades, maintenances and other SQL related works.Worked on much automation for the SQL servers in terms of audits, SQL agent job activities, SQL backup reports, SQL disk reports and few others.Need to provide SQL Server trainings to Developers and Junior DBAS.Implementation of Amazon RDS and Amazon Database Migration, TDE on Sensitive DatabasesResponsible for all DBA related activities from India site and High Availability and Disaster Recovery of ServersNeed to provide RCA for critical issues and document them for future reference.Recruitment, Performance Rating

Monitoring and maintaining more than 150 servers as part of day to day activitiesApplying System, application builds and security patchesCreating and managing databases, monitoring SQL Servers, Automation using SSIS and SSRSEstablishing backup and recovery proceduresImplementing Security policies by creating logins, users and managing permissions.Managing High Availability environmentPerformance Tuning and Optimizing, Backup and Recovery, Replication (Transactional)Log Shipping, Clustering (Active/Passive) & SQL Mail/Database Mail IntegrationSQL Server Agent-Events, Jobs, Alerts and Operators.Database Maintenance & Server Migration: SQL 2005 to SQL 2008Helping Development and Test teams for releases on UAT and Production environments. Team management, training and coordinating with team members on technical issues and other general issues. Proactively working on Performance and Blocking issues on servers by auditing Databases.Maintaining of Backup Strategies as per the company standards using SQL Litespeed.Solving Disk space, Log files full and database file full related issues on SQL servers.

As a team member, I am responsible for trouble shooting SQL Database problems in windows environment, installation and maintenance of SQL Servers. I have implemented high availability solutions for SQL servers. I have executed many migration/upgrade of SQL standalone and Cluster servers in Microsoft Windows environment. Also I handled migration of critical applications which were hosted on standalone and cluster web servers.Monitoring and maintaining more than 150 servers as part of day to day activitiesApplying System, application builds and security patchesCreating and managing databases, monitoring SQL ServersEstablishing backup and recovery proceduresImplementing Security policies by creating logins, users and managing permissions.Managing High Availability environmentPerformance Tuning and Optimizing, Backup and Recovery, Replication (Transactional)Log Shipping, Clustering (Active/Passive) & SQL Mail/Database Mail IntegrationSQL Server Agent-Events, Jobs, Alerts and Operators.Database Maintenance & Server Migration: SQL 2005 to SQL 2000Helping Development and Test teams for releases on UAT and Production environments. Team management, training and coordinating with team members on technical issues and other general issues. Proactively working on Performance and Blocking issues on servers by auditing Databases.Maintaining of Backup Strategies as per the company standards using SQL Litespeed.Solving Disk space, Log files full and database file full related issues on SQL servers.

DBA

ESRI Database Inministrator