Srinivasa Sarma J

Currently working as Consultant with Tata Consultancy Services Worked as Technical Services Professional with IBM India Pvt Ltd Worked as Software engineer with Satyam Computer Services Ltd

• Tata Consultancy Services, Lead DBA, Various teams, 09/10 to present, Oracle 9i to 12c on AIX/Linux/Solaris/HP-UX/Windows, WebLogic 10g to 14c, OEM, ORADEBUG, Toad, SQL Developer, RMAN, MSSQL management studio, MsSQL-SSMS, GG, 24
• 7 production Support for mission critical production systems, DB health checks for all DB flavours, Creating user ID’s based on requirement and granting Privileges on Objects, Performing object level re-org activities, Performing object level compression activities, Creating DB links and materialized views based on requirement, Performing Object level refresh & schema level refresh, Performing regular restoration testing for backup validations for all DB flavours, Archiving tables based on project requirement, Monitoring and fixing replication issues, Working on DB code movements based on CR’s and PF’s, Installed Oracle on different platforms & different MSSQL versions on windows, DB upgradations, DB Migrations - Oracle, MySQL, PostgreSQL to cross platform, Upgrading 10g RAC databases to 11g & 12c RAC latest version with latest PSU’s, Experience in installing and configuring oracle (RAC and non-RAC) databases, Migrated OCR & Voting disks to different storage in co-ordination with storage team, Experience in ASM storage migration to new disks/new DG, Implemented redundant Interconnect configuration in co-ordination with system admin team, Performing war /ear file deployments in application server based on code changes, Replacing jsp/report/xml and other configuration files on application server, Forms compilation on application servers, Performing switch over and switch back activities, WebLogic administration – starting from installation to application deployment on LB and troubleshooting various issues, Worked on HLD and SFLB for load balancing applications, Troubleshooting application issues, Installing application server, Applied PSU & other patches based on Vendor suggestion in RAC/non-RAC environments, Handled Switchover and Live testing DR project, Moving historical data from PROD to HIST box using transportable tablespaces, Creating and Converting partition tables, Regular partition extension activities, Archiving partitions using exp/Expdp, Regular archival activities based on user requirement, Generating statspack reports on regular basis to identify the database performance at peak load, Monitoring space, wait events, locks and long operations running on the database, Restoration of HIST data for based on TRAI requirement, Monitoring Library cache locks/pins held on objects, Involved in couple of application merger projects, Worked on block corruption issues, Worked on recovery while performing HIST restoration, Tuning the SQL statement by analyzing the explain plan, AWR and ADDM reports, Installing and configuring CRS on all cluster nodes, Installing Oracle 10g software for RAC with ASM and creating 2-node RAC DB, Closely worked with Vendor in order to overcome internal errors (Ora-600) by applying oracle suggested patches
• IBM India Pvt Limited, Carphone Warehouse, Yara, Diageo, RSA, Heinz’s, Nokia, Virgin Mobile, Boots, Coats, ICI paints, Ebrs, Ntrust, Capita India, DBA, 15, 02/10 to 09/10, Oracle 8i, 9i, 10g on AIX/Linux/Solaris/windows, Recovery Manager (RMAN), SQL
• LOADER, Performing health checks of the databases, Handling tickets raised by users in tools like Remedy, Maximo etc., Providing scripts requested by users and Implementing RFC’s, Performing Partitioning activities every month, Refreshed databases, Creating mirror user id’s, Trouble shooting user raised issues, Involved in performance tuning of queries, Preparing capacity reports and storage charts for critical databases to analyze database growth, Applied security CPU patches, Applied databases patches, Prepared RCA’s for P1 issues, Closely worked with Oracle support for critical issues/bugs, Refreshed schemas, Closely worked with monitoring team, Backups team, and UNIX team for database issues, Provided On call support. Working on RFS work, Performed re-org activities to claim space, Worked on Oracle internal errors, Worked on critical application releases in coordination with Application, IM and problem management team
• Satyam Computers Services Limited, BP (UK and US), DBA, 20, 07/07 to 01/10, Oracle 8i, 9i, 10g on Solaris/windows, Solaris, windows, ORACLE 8i, 9i, 10g, Recovery Manager (RMAN), SQL
• LOADER, SSMS, Managed database space related issues, Monitoring and Handling data guard related issues, Performed switch over and failover of data guard, Managed the backup of the databases implementing backup strategies, Performing Health check of the databases, Refreshed Test, Development & Quality database with Production, Creating look alike accounts for the database users, Maintaining Archive logs and their spaces for routine administration alert and trace monitoring, Created and managed different kinds of tablespaces, space issues, extent and storage parameters, Performed databases upgradations to latest versions, Performed Failover, Failback activities for Data guard, Performed standby database rebuild activities, Performed schema level refreshes, Created database links between databases to access data between databases, Performed DR tests using hot backup dumps, Replaced the JD Edward tool (acting as interface between two databases) with UNIX script, Performed database Re-org activities, Performed oracle software installations & created databases on Solaris/windows servers, Resolved critical performance issues happened after upgradation, Created the of databases for development, production and testing, Loaded data from Flat files to database using SQL
• LOADER, Monitoring the growth of Table space and taking proper actions, Implemented the automated database health check-up scripts, Handled problems happened with rollback segments (ora-1555), Changes database character sets based on client requirements, Performed DB migrations across cross platforms, Involved in efforts estimations for client requirements, Performed Gap resolution for standby and reporting databases, Closely worked with application users to tune the queries using explain plan and tkprofs, Prepared and implemented scripts for critical servers to monitor the cpu usage at os level, Applied patches to overcome minor bugs based on the feedback from oracle, Decommissioned databases from Unix and windows environments, Used enhanced explain plan tool (Sqlt), RDA, AWR, 10046 & 10053 traces events to collect the statistics of queries & database and uploaded the same to oracle as per Oracle corp recommendations, Closely worked with Oracle Corporation via SRs and OWC to resolve critical issues and unknown bugs on priority basis

• Oracle database administration
• MsSql Administration
• Azure Solution architect
• WebLogic Administration