Sr. Database Administrator
Societe General
Total years of experience :4 years, 7 Months
• Managing and supporting 500+ productions, development & UAT databases.
• Performing day-to-day administration and support activities to maximize database availability for our clients and users.
• Monitoring alerts through Third party tool (JUMP) and taking proper actions.
• Database creation using DB PORTAL tool.
• Creating Auxiliary database using RMAN.
• Responsible for resolving archive gaps in standby database.
• Responsible to resolve mount points issues via PMETRO tool.
• Responsible to resolve Archives issues.
• Responsible for database decommissions.
• Responsible for restore & recover databases.
• Perform database refresh using RMAN backup.
• Perform schema refresh using expdp/Impdp or exp/Imp.
• Perform table refresh using data pump or exp/Imp method.
• Managing and Monitoring standby databases.
• Experienced in user management including by create users, grant/revoke roles, privileges to the users, creating and assigning profiles to the users
• Creating and managing Table spaces like adding, renaming, resizing dbf files.
• Validating & Deploying scripts in prod/Dev/Homologation databases.
• Preparing backup checklist and update to the users
• Performing on-demand backups by using Rman & Data pump.
• Providing on call support for critical alerts on weekends.
• Responsible to resolve performance issues.
• Responsible to resolve network(Listener & TNS) issues.
• Managing and maintaining ASM databases.
• Coordinating with oracle support for critical issues.
• Managed and supported 100 productions, development & UAT databases.
• Performing day-to-day administration and support activities for the Information Technology environment to maximize system availability for our clients and users.
• Monitoring alerts through Third party tool (citrix) and taking proper actions.
• Performed schema refresh using expdp/Impdp or exp/Imp.
• Performed table refresh using data pump or logical backup method.
• Experienced at administering database security by create users, grant/revoke roles, privileges to the users, creating and assigning profiles to the users
• Creating and managing Tablespaces like adding, renaming, resizing dbf files.
• Deploying scripts in prod/Dev/Uat databases.
• Preparing Checklist and update to the client.
• Archive files shipping from prod to test and remote databases.
• Archive Monitoring, and checking sync status of standby databases
• Performing on-demand backups by using Rman & Data pump.
2008 Sep - Apr 2011 Wipro Technologies, Chennai Engineer- Database Administrator
Wipro Technologies, Chennai
Engineer - Database Administrator
Sep' 2008 - April 2011
• Managed and supported 120+ productions, development & Uat databases.
• Performing day-to-day administration and support activities for the Information Technology environment to maximize system availability for our clients and users.
• Database cloning from Prod to Dev/Uat using RMAN.
• Performed schema refresh using expdp/Impdp or exp/Imp.
• Performed table refresh using data pump or logical backup method.
• Experienced at administering database security by create users, grant/revoke roles, privileges to the users, creating and assigning profiles to the users
• Creating and Managing Table spaces like adding, renaming, resizing dbf files.
• Creating Tar's with Oracle Corporation for technical support.
• Restored and Recovered database, for missing datafiles / Block Corruption.
• Deploying scripts in prod/Dev/Uat databases.
• Preparing Checklist and update to the client.
• Managing & Creating Materialized views.
• Managing & Creating DB links.
• Performing on-demand backups by using Rman & Data pump.
• Managing & maintaining ASM databases.
• Daily monitoring of the oracle cron jobs
Bachelor of Science in Computers & Electronic Sri Krishna Devaraya University 2002 - 2005.
S.S.C Board of Secondary Education, A.P 1998