GUNASEKAR RAMAKRISHNAN - WIZBII GUNASEKAR RAMAKRISHNAN a publié son profil professionnel sur WIZBII. G R

GUNASEKAR RAMAKRISHNAN

Oracle Database Administrator Consultant

52 ans • Chennai

Résumé

Overall 16 years of IT experience of which 10 years ‘of experience in Oracle Database Administration. Being a DBA Lead and Subject Matter Expert accountable for systems running on Oracle, DB2 and SQL Server with multi-million USD Remote Infrastructure Management Systems, Primary responsibility is to ensure smooth Remote Infra support/Operations to worldwide clients using ITIL model on 24x7x365 basis, and responsible for profit and loss of the accounts. Managing and monitoring Incident, Change and Problem Management in line with ITIL Framework.

Compétences

 Managing The Oracle Databases For 10g / 11g/ 12 C In A 24*7 Production Environment.  Monitoring Database And System Health And Performance  Monitoring Alert Log & Other Trace Files.  Monitoring Tablespace And Data File Space Utilization & Managing The Same.  Database Planning And Creation.  Database Migration  Export & Import, Datapump On Database Level, Table Level, Schema Level Etc.  Backup & Recovery On Production Setup  Database Tuning On Instance Level And Query Level Using Statspack, AWR And ADDM And Sql Optimizer.  Managing The Database Using Sqlplus, Toad, And Enterprise Manager.  Trouble Shooting Database Issues  Use Of Problem And Change Management Tools  Usage Of System Catalogs On Query Analyzer  Managing Transaction Log Files  Backup And Recovery Methods Using Enterprise Manager And Query Analyzer  Expertise In Sun Solaris/AIX And Red Hat Linux.  Designed, Tested And Implemented Oracle High Availability Solutions  Worked With Development Team In Optimizing SQLs  Install And Configure New Databases Based On Best Practices  Perform Day To Day Database Administration On Existing Databases Including Implementing Patches And Upgrades As Needed  Participate As A Member Of The Engineering Teams For Database-related Tasks  Develop, Test, And Implement The Appropriate Backup Procedures  Maintained Effective Database Performance Monitoring Procedures  Performed Database Tuning For Optimal Performance To Meet Business SLAs  Controlled And Monitored User Access To Databases And Maintain Database Security  Allocate Storage And Develop Plans For Future Storage Requirements  Maintained Documentation Of Systems And Standard Operating Policies And Procedures  Provided Technical Assistance And Mentored Junior Members Of The Team  Oracle RAC & ASM Administration/Installation  Database-Backed Web Solutions  SQL Tuning In An Oracle Environment Creation Of Physical And Logical Standby.  Knowledge Related To Dataguard Broker  Managing The Database In A Data Guard Scenario With Physical And Logical Standby Databases.  Managing And Monitoring The Log Apply Services & Log Transport Services.  Managing The Physical And Logical Standby For Archive Log Gap.  Handled Switchover And Failover Of The Physical Standby Databases.  Managed The Changes On Primary Site That Affect The Standby Site.  Troubleshoot Data Guard Issues & Provided Solutions To Physical Standby & Logical Standby Configuration Problems EXPERIENE RAC Setup And Configuration.  Create And Administer Real Application Cluster Databases.  Able To Administer Storage Components In RAC Environment  Able To Manage Parameter Changes Across Multiple Instances In RAC Environment  Managing The Scalability For Multiple Instances In RAC.  Managing The Backup And Recovery In RAC Environment.  Upgrade, Migration, Patching, Cloning Of Oracle RAC Database,  Experience In Adding & Deleting Nodes & Instances  Configure Clients And High Availability For RAC  Converting Single Instance Databases To RAC.  Knowledge Related To RAC Guard Architecture, Components.  Installing & Configuring Oracle Clusterware & Oracle RAC.  Troubleshoot While Installing & Configuring, Rolling Patching RAC  Migration Of ASM Instance To Non-ASM Instance & Migration Of Non-ASM Instance To ASM Instance (Vice-Versa.,)  Using AWR In RAC Environments.  Managing Oracle S/W And Applying Patches  Administering Oracle Clusterware Components.

Expériences

Database Administrator Lead

- MaintenantDéveloppement informatique Oracle DBA Lead/ Consultant / Subject Matter Expert  SLA reporting, measurement and tracking  Plans, Schedules, Monitor and reports on activities related to projects  Manage deliverables against the signed SOW  Issue log tracking / Risk Management / Customer communication and Service Reporting  Deliver services without any penalties and accrual of Bonus  Identify the Internal and external stake holders and communications channel  Mitigate Risks due to non-compliance of SLA norms for the Vertical and Region  Ensure 100% SOW compliance for all accounts in Vertical and Region

Infrastructure Services Manager / Oracle DBA Consultant

- Développement informatique Oracle DBA Consultant  SLA reporting, measurement and tracking  Issue log tracking / Risk Management / Customer communication and Service Reporting  Service Offerings creation / Value Added Services / Innovations  Introduction of best practices for development and support projects  Mitigate Risks due to non-compliance of SLA norms for the Vertical and Region  Actively participate in Audit NC closure / Risk mitigation  Successfully transitioned multiple DBA accounts across regions.

Sr. Member Technical Staff – Sr. Oracle DBA

- Développement informatique Leading the team of DBAs and Support Team.  Involved in CORE DBA activities and responsible for Oracle Transport Management delivery for end customers  Installing and upgrading the ORACLE Server and application tools.  Allocating system storage and planning future storage requirements for the database. Creating primary database storage structures.  Modifying the database structure, as necessary, from information given by application developers. Enrolling users and maintaining system security.  Ensuring compliance with Oracle License agreements. Controlling and monitoring user access to the database. Monitoring and optimizing the performance of the database.  Planning for backup and recovery of database information.  Monitor database instances on a daily basis to ensure availability. Resolve unavailability issues. Collect system statistics and performance data for trending and configuration analysis.  Analyze and administer DB security. Control and monitor user access to DB. Audit database usage when necessary.  Upgrade RDBMS software and apply patches when needed. Upgrade or migrate database instances as necessary.  Setting up Standby Database & Cloning / Refreshing Databases /Setting up RAC instances.

Oracle Database Administrator

- Conception / Génie civil / Génie industriel Installing and upgrading the ORACLE Server and application tools.  Allocating system storage and planning future storage requirements for the database. Creating primary database storage structures.  Modifying the database structure, as necessary, from information given by application developers. Enrolling users and maintaining system security.  Ensuring compliance with Oracle License agreements.  Migration of database from Oracle to DB2  Controlling and monitoring user access to the database.  Monitoring and optimizing the performance of the database.  Planning for backup and recovery of database information.  Backing and restoring the database.  Contacting Oracle Corporation for technical support.  Monitor database instances on a daily basis to ensure availability. Resolve unavailability issues. Collect system statistics and performance data for trending and configuration analysis.  Analyze and administer DB security. Control and monitor user access to DB. Audit database usage when necessary.  Upgrade RDBMS software and apply patches when needed. Upgrade or migrate database instances as necessary.

Formations

Bharathidhasan University

1996 - 2000 Tiruchirappalli City, Tiruchirappalli, Tamil Nadu 620001, India, TiruchirappalliDéveloppement informatique, Infra / Réseaux / Télécoms, Conception / Génie civil / Génie industriel, Chimie / Biologie / Agronomie

Mes qualités

Communicant·e
Autonome
Flexible
Esprit d'équipe

Langues parlées

  • Anglais

    Professionnel

  • Tamoul

    Langue maternelle

Faire de chaque avenir une réussite.
  • Annuaire emplois
  • Annuaire entreprises
  • Événements