ORACLE DBA
Technip
Total years of experience :9 years, 8 Months
• Managing the Tablespaces like Temp, Undo, Users, Index and storage parameters.
• Handling the Spicework Tickets raised by the Helpdesk for the different issues of DB.
• Creating tables and creating proper indexes and rebuilding indexes when required.
• Monitoring Production databases using Grid Control.
• Managing backups of Prod & Preprod& Dev databases and solving the errors of backups.
• Performing Reorganization of databases every quarter.
• Applying security patches, CPU patches and database upgradation whenever it is required.
• Generating Statspack report and Awr Reports to check the health status of databases.
• Creating database users with appropriate profiles and resolving the errors of database user when they are not able to connect to database.
• Performed Tuning like Memory Tuning, I/O Tuning, Sql Tuning, Database Tuning whenever required.
• Creating Sql Profiles for the sqls.
• Performing database refresh from production to development and test db using.
• Managing SQL Server dbs activities.
• Performing schema level refreshes and object level refreshes whenever request comes.
• Applying technical releases on databases.
• Performing the application/database deployments as Deployment Engineer.
• Managing the Primavera application installations and support.
• Managing the Tablespaces like Temp, Undo, Users, Index and storage parameters.
• Managing EZservice Tickets and assigning within the DBA Team.
• Creating tables and creating proper indexes and rebuilding indexes when required using Maximo changes.
• Monitoring Production databases using Grid Control.
• Managing RMAN backups of Prod & Preprod& Dev databases and solving the errors of rman backups.
• Performing Reorganization of databases every quarter.
• Applying security patches, CPU patches and database upgradation whenever it is required.
• Generating Statspack report and Awr Reports to check the health status of databases.
• Creating database users with appropriate profiles and resolving the errors of database user when they are not able to connect to database.
• Performed Tuning like Memory Tuning, I/O Tuning, Sql Tuning, Database Tuning whenever required.
• Creating Sql Profiles for the sqls.
• Performing database refresh from production to development and test db using RMAN.
• Managing SQL Server dbs and DB2 database activities.
• Monitoring and managing standby databases and RAC databases.
• Performing schema level refreshes and object level refreshes whenever request comes.
• Applying technical and functional releases every month on databases.
• Managing replication using shareplex tool.
• Applying changes on database using maximo changes.
• Create, monitor and troubleshoot SQL Server jobs.
• Setup, monitor and troubleshoot Log-shipping.
• Restore databases from Sql Server Backups when there is a request.
• Installed and configured Golden Gate and managed replication using Golden Gate
• Managing the Tablespaces like Temp, Undo, Users, Index and storage parameters.
• Managing EZservice Tickets and assigning within the DBA Team.
• Creating tables and creating proper indexes and rebuilding indexes when required using Maximo changes.
• Monitoring Production databases using Grid Control.
• Managing RMAN backups of Prod & Preprod& Dev databases and solving the errors of rman backups.
• Performing Reorganization of databases every quarter.
• Applying security patches, CPU patches and database upgradation whenever it is required.
• Generating Statspack report and Awr Reports to check the health status of databases.
• Creating database users with appropriate profiles and resolving the errors of database user when they are not able to connect to database.
• Performed Tuning like Memory Tuning, I/O Tuning, Sql Tuning, Database Tuning whenever required.
• Creating Sql Profiles for the sqls.
• Performing database refresh from production to development and test db using RMAN.
• Managing SQL Server dbs and DB2 database activities.
• Monitoring and managing standby databases and RAC databases.
• Performing schema level refreshes and object level refreshes whenever request comes.
• Applying technical and functional releases every month on databases.
• Managing replication using shareplex tool.
• Applying changes on database using maximo changes.
• Create, monitor and troubleshoot SQL Server jobs.
• Setup, monitor and troubleshoot Log-shipping.
• Restore databases from Sql Server Backups when there is a request.
• Installed and configured Golden Gate and managed replication using Golden Gate
• Managing the Tablespaces like Temp, Undo, Users, Index etc.
• Altering dynamic storage parameters when required.
• Altering the structures and storage parameters of table level and tablespace level.
• Audited the database to monitor day-to-day activities on database and security implementation.
• Performance tuning of Oracle 9i database (includes Oracle init.ora, Oracle SGA, I/O balancing and memory tuning).
• Creating tables and creating proper indexes and rebuilding indexes when required.
• Monitoring Primary and standby databases and resolving the errors of it.
• Checking backup status through backup logs.
• Performing Reorganization of all databases for every quarter.
• Applied security patches and did database upgradation like from 9i-10g.
• Performed Recoveries when required.
• Generating statspack report to check the health of databases.
• Resolving the erros of database users when not able to connect to database.
• Taking backups cold, hot backups and logical backups(export&import).
• Performed Tuning like Memory Tuning, I/O Tuning, Sql Tuning etc.
• Performing database refresh from production to development and test db.
• Resolving the issues of scripts failing.
• Resoved the issues of Primary and Standby databases.
• Created dblinks from one database to other database whenever required.
• Designed & developed database structures (Tables, Indexes, Views, Triggers to implement Business Rules, Procedures etc)
• Implemented new features of Oracle 8i & 9i like LogMiner, Transportable Tablespaces, Standby Databases for fail-over situations..
Degree University B.Tech (C.S.I.T) Mother Terissa Engineering College 2003, (JNTU)