Subject Matter Expert
Microland
Total years of experience :19 years, 5 Months
I am working as an SME with Microland Ltd. I have worked on several performance issues and annual DR test and documented DR procedures. Trained team on 11g RAC and Golden Gate.
Roles & Responsibilities:
Working on 11gR2 RAC Installation.
Converting single instance databases to RAC and migration.
Rebuilding physical standby databases
Working on performance tuning and resolving business critical high severity issues.
Successful completion of Disaster Recovery Tests
Worked on DB Replay to compare performance for migration activity.
Worked on logical standby
MySQL database administration at L1 level.
Managing team to adhering to client SLAs and work load distribution with in the team.
SQL Server administration.
I have worked as Primary DBA and transitioned multiple accounts from EMEA region to bestshore DBA teams in India which involved on-site travel to Netherlands, Working at client locations, receiving KT, giving reverse KT and overcoming several challenges at technical and process level and in establishing good rapport between on-site and off-shore teams.
Environment:
Operating Systems IBM AIX6.1, SunSolaris 2.10/2.9/2.8/sun containers, Linux el5,
HP-UX B.11.23 and Windows 2000/2003/2008
Oracle Versions Oracle 11gR2, 10g, 9i and 8i
Tools 10g Grid Control, Control-M, Patrol, Perigrine Service Center, Autosys, TNS Tool
Backups TSM and Net backups
Roles & Responsibilities:
Lifecycle migrations that involves Database migrations and upgradation, cross-platform migrations, upgrading from 9i to 10g, 10g to 11g.
Standby rebuilding and RMAN cloning at frequent intervals.
Hands on with RAC Administration. Experience in 9i RAC with HACMP cluster and raw devices. 10g and 11g RAC with ASM
TSM backup management and Configuration on windows, SunOS, AIX, Linux and HP-UX.
Transitioned 6 projects as Primary DBA from UK and European Countries taking KT from on-site teams and giving reverse KT to Off-shore teams in India.
Working for multiple accounts as primary DBA and closely working towards resolution of high priority issues.
Hands on with performance tuning with OEM, AWR and ADDM.
Oracle Installation of various versions. 11g, 10g, 9i and 8i on Windows and UNIX.
Worked with team in setting up OEM 10g Grid Control for monitoring and maintenance.
OEM agent patching.
Partitions creation and purging old partitions.
Managing Backups and retention, and purging TSM old backups with tdposync.
Space management with Database and File System with Quarterly Capacity Planning.
Planning and working on Disaster Recovery Drill and ensuring successful recoverability tests with in SLA.
Standby configuration and Maintenance.
Database Decommissioning
Documentation of all the processes and technical issues and maintaining in common repository.
Worked on Flashcopy to clone production databases on HACMP cluster.
Roles & Responsibilities:
• Monitoring databases and database Backup failures and re-run failed production backups.
• Space administration
• Decommissioning Databases
• Log shipping administration. Ensuring logs are transferred correctly to the staging servers.
• Creating users, roles and giving requested grants and dropping users.
• CPU patching and bug fix patching
• Worked on Upgrading database from 9.2.06 to 9.2.0.8
• Automation of Monitoring to generate mail alerts for space and backup failures.
• Worked on simple performance issues under the guidance of L3 team.
• Standby Management on RAC servers. (2 Node RAC with Dataguard)
• Troubleshooting issues found in alert log and requests received.
• Worked on schema and database refresh from production to UAT and development servers.
MCA with 68% from IGNOU - 2011.
B.Sc Computers from Osmania university