Administered and maintained multiple databases, including performance tuning, backup and restores.Assisting developers with query tuning and schema refinementProviding 24x7 support for critical production systems.Installing and configuring the SQL, Oracle and DB2 servers and establishing the connectivity for clients using client tools dB forge and SSMSSetting up the TNS connectivity for users and resolving Oracle connectivity and TNS issues.Worked on huge sets of test data… Show more Administered and maintained multiple databases, including performance tuning, backup and restores.Assisting developers with query tuning and schema refinementProviding 24x7 support for critical production systems.Installing and configuring the SQL, Oracle and DB2 servers and establishing the connectivity for clients using client tools dB forge and SSMSSetting up the TNS connectivity for users and resolving Oracle connectivity and TNS issues.Worked on huge sets of test data creation by analysing the reference application logs based on the requirement.And analysing and debugging the queries which listed on the logs for filing data gaps and, flag changes and property changes.Applying the Latest Service packs and Cumulative Updates on the SQL servers running.Keeping SQL servers up to date listing the Deprecated Features of SQL server and Ensuring the developers Don't use the Deprecated features in the code.Listing the queries by using SQL server Profiler.And tunning the queries for better performance.Writing the Stored procedures for application installation.And installing the SYFT application and setting up the database.Ensuring the application running.Writing the queries for People soft data creation in the oracle.Checking the query performance and tunning the queries by creating the indexes and verifying the join conditions in the queries.Interacting with the People soft and creating the data through GUI as part of new changes in the approach.Creating ER diagrams using Visio for every version of SYFT applicationIntegrated performance Monitor tool with JMeter for the reports generation for Demo Site. Show less