▪     Oracle and SQL Server database administration and support.

▪     Full fill DBA activities including incident management, space management and monitoring.

▪     Monitor SQL server systems health and performance.

▪     Configure backups using VERITAS Net backup.

▪     Implementation of mongo db security mechanisms.

▪     Involved in daily activities of configuration in mongo db.

▪     Identifying and trouble shooting of mongo db issues.

▪     Implementing shell scripts for purging data and for monitoring.

▪     Performed day-to-day activities, Such as daily health checkup of the database server using Alert log, AWR, Explain plan.

▪     DB2 UDB EEE database administration and support.

▪     Tuning application queries for better performance.

▪     Implementing and scheduling the shell scripts to automate the routine maintenance jobs like backup, Runstats.

▪     Backup and recovery strategy.

▪     Analyzed index requirements and designed appropriate indexes.

▪     Worked on server, instance, and SQL tuning issues. 

▪     Creating, Managing & Maintaining Database objects.

▪     Experience in SQL Tuning issues using AWR reports, ADDM reports, Explain Plan, SQL Trace Utility. 

▪     Setting up of new database for development teams as per specification for Testing.

▪     Monitoring DB and Space usage.