Senior Database Consultant
Gulf International Bank
Total des années d'expérience :20 years, 3 Mois
• Providing end to end support to Production/Dev and UAT environments. This includes 24*7 on-call L3 support, handling Sev1, Sev2 issues pertaining to Oracle, MS SQL and MySql databases.
• Analyzing and resolve database performance bottlenecks and proactive review using AWR, ADDM, ASH, hints, SQL tuning set, OEM 13c.
• Configuring, managing Oracle Golden-Gate one-way, two-way/bi-directional, active-to-active and active-to-passive data replication with conflict detection and resolutions.
• Administration of M7 supper cluster and exadata.
• Securing Oracle RAC clusters using ASM and Database scope security to restrict the ASM disk groups at cluster/database level on supper cluster/exadata environment.
• Enabling IPsec security within the M7/exadata environment to restrict IP based access for the hosts.
• Migration of banks core databases to M7 supper cluster, also upgraded them to 12c/18c release from 11.2.0.3.
• Migrated Legacy databases running on 10g/8i on windows to 12c on M7 supper cluster.
• Automating database jobs, scripted the automation of DR database activation and post DR auto-resync using oracle standby/dataguard.
• Configuring standby databases and activating them in read/write mode using snapshot standby/Flashback.
• Ensure DR sites are in-sync with Production site, and make DR databases available to the application/business as per the requirement.
• Managing multiple projects that involves designing, implementation of 12c/18c single/multi node cluster, ASM and Dataguard setups and post implementation support.
• Active database duplication/cloning from production using RMAN for reporting purpose.
• Configuring RMAN database backup/restoration on disk and networker data domain.
• Refreshing the Test and UAT environments from production databases using RMAN/Export dump.
• Maintenance of databases on various Unix flavors and on Windows platform.
• Attend Change/Release management meetings for the smooth change implementations.
• Mentoring the junior members of the database team.
• Interact with the application/developers and help them with database solutions to meet the business requirements.
• Preparing root cause analysis for issues and ensuring permanent closure.
• Implementation and support of Mysql databases.
Supported Production and Dev environments in Deutsche Bank across all the regions globally.
•Managed multiple projects that involves designing, implementation of 11g RAC, ASM and Dataguard setups and post implementation support.
•On-call rotation DBA for Incidents and change implementations.
•Converted database from Non-Rac to Rac and migrated database from filesystem to ASM.
•Replaced underlying storage disks of ASM diskgroups/OCR/Voting disks as part of storage tech-refresh of mission critical systems.
•Designed and implemented Backup policy i.e. RMAN Backup and BCVs.
•Analyzed database performance bottlenecks and resolved various issues using tuning parameters, sql-profiles, hints and SQL tuning set.
•Maintained databases on various Unix flavors and on Windows .
•Installed and configured of EM12C grid control.
•Carried out various cross-platform migrations using Transportable DB.
•Ensured DR sites are in-sync with Production site, and made DR databases available to the application/bussiness as part of COB drills.
•Ensure all oracle software installations and routine patches /upgrades are implemented to avoid know issues.
•Automating daily jobs and activities using shell scripting.
•Prepared RCA for repetitive calls to ensure permanent closure.
•Documented multiple database design & configurations for Deutsche Bank’s database support teams so that the database engineers can follow the standard way to implement and support database services.
SKILL SET
Oracle Exadata/RAC
Performance Tuning
Backup/Recovery
Golden Gate
DB Security
Migration/Upgradation
Patching
Dataguard
Cloud/Autonomous DB
EM13c
Worked as oracle DBA consultant in a highly charged production/development environment.
•Provided 24*7 production and development database support to the APAC and EMEA region.
•Managed multiple projects that involved designing, implementation of 11g RAC, ASM and multi-site Dataguard setups.
•Analyzed database performance bottlenecks and resolved various performance issue related to database and sql tuning.
•Provided day to day oracle database administration support including Installation, patching, upgradation and maintenance of databases on various Unix flavors and on Windows platform.
•Upgraded variuos Grid Infrastructures from 11gR1 to 11gR2.
•Implemented EM grid control for database monitoring and alerts.
•Participated in continuity of business test drills to ensure business continuity in case of disaster.
•Implemented DB Vault and TDE on business critical databases to meet the security compliance.
•Migrated various databases using cross-platform database migrations.
•Managed Standby/Active Dataguards in multi-sites across the region.
•Configured and managed Golden Gate and share-plex replication.
•Automated daily jobs and activities using shell scripting.
•Configured Backup policies using RMAN, datapump.
•Prepared RCA for repetitive calls to ensure permanent closure.
•Interfaced with teams to craft solutions to meet service requirements.
•Implemented changes based on the requirement from the vendors and from the various application teams.
•Apr 2013 Citi Bank - Malaysia - Citi Gem Award
•Oct 2011 Citi Bank - Malaysia - Citi Gem Award
•May 2009 Wipro Infotech - India - Best Performer in Database domain.
•Aug 2008 Wipro Infotech - India- Won the DBA case study-quiz contest (east region) conducted across India.
• Provided 24x7 production databases support.
• Handled terabytes of databases for a telecom giant in india.
• Day to day oracle database server administration and on-call support round the clock.
• Customer interaction and capacity planning.
• Installation, configuration, patching and maintenance of oracle databases on HP-UX, Solaris, Linux and Windows
• Database performance tuning and SQL tuning.
• Understanding the application and the client requirement and designing/amending the databases solutions as per the application nature.
• Taking daily export backup/ restorations of the important tables as per the requirement using Export/Import and Data pump and Flashback.
• Tablespace, Index, Tables, Clusters, Data files and Redo log creation and management.
• Taking weekly, monthly Hot/Cold backups using RMAN.
• Generating and analyzing ADDM, AWR, RDA and Statspack report for performance bottlenecks.
• Designing & implementing database security and audit policies.
• Writing database Procedures, Functions and Triggers.
• Resource allocation for the entire Database objects.
• SQL * Loader for Data Conversion from other sources.
• Configuration and maintenance of oracle streams.
• Raising SR for critical oracle issues and follow up with the vendor till the resolution/fix
Handled 24x7 support for the production databases .
•Installation, config, patching and maintenance of Oracle DB’s on HP-UX, Solaris, Linux and Win platforms.
•Database upgradation and migration.
•Database backup and recovery using Export/Import, Hot backup or Cold backups or through RMAN.
•Recovery catalog creation and maintenance, User creation and Maintenance through Profiles and Roles.
•Tablespace and Index creation and management.
•Designing & implementing database security and audit policies.
•Writing database Procedures, Functions and Triggers.
•Oracle Troubleshooting, Alert log, Trace files.
•SQL * Loader for Data Conversion from other sources, Oracle Streams and Documentation.
•Resource allocation for the entire Database objects.
System Administration
Installation of Oracle and database setup on multiple windows/unix platforms.
•Writing oracle procedure/triggers and maintenance of applications using oracle developer 2000.
•Installation, configuration, maintenance of Windows/Web Servers.
•Installation of new hardware and software packages.
•Administration of Active directories/exchange server, Configuration of terminal services.
•Configuration of various ADSL modems and routers (Link sys, Net Gear, Zyxel, and De-link Routers etc.
•Troubleshooting system / network related problems.