Job Description

Description and Requirements Experience & Skills: Education: Bachelor\'s degree or equivalent in technology is preferred. Experience: Minimum of 6+ years of relevant experience in IT Infrastructure Support - Database platforms (Oracle, MS SQL, MYSQL, DB2, SAP HANA, etc.) preferably with multiple client\'s landscape and technology landscapes (Windows Server, Unix, Linux). Experienced in supporting heterogeneous IT environment for large Manage Services accounts. Experience on DB administration on cloud will be added advantage. Should have worked in a remote infra support set up - understand nuances of Remote Support. Good knowledge in DB backup, Restore and Recoveries, Archive and Purge. Experience in DB Network Configuration (LISTNER, TNSNAMES etc.) in dedicated server. Experience in performing the recovery of the databases in various scenarios. Good Knowledge of Oracle 11gR2RAC and Standalone Environment. Experience in performing the recovery of the databases in various scenarios. Experience in generating and reviewing AWR, ASH and ADDM Report. Knowledge on Oracle Exadata, Golden Gate etc. will be added advantage. Good understanding of Cloud Platform & AWS / Azure Relevant expert level technical certifications in Database Domain are preferred Good understanding of ITIL (Information Technology Infrastructure Library) principles Excellent command over verbal & written English Language Experience with various service delivery technical tools Good Communication and presentation skills Persistent, detail oriented, able to multitask Ability to work for large organization in a complex and heterogeneous IT environment Ability to work across Geographies and multi-cultural environments. Experience in working with both physical and virtual teams Job Deliverables: L2 level administrative and implementation support on (Oracle 10G, 11G, 12 C, 16C, 18C) / MS SQL / My SQL / DB2 / Mongo DB / SAP Hana etc. Backups and restorations using RMAN, and via GUI through Commvault. Database software installation to development, test and production servers. Responsible for refreshing and cloning of databases per customer requirements. Responsible for upgrade and migration of databases. Participate in technical transition of database technologies for new FMS customers. Performing Logical backup and recovering specific object or schema as per requirement. Managing table spaces, data files, redo logs, tables and its segments. Oracle Data guard (Standby) Configuration and Administration. Reviewing Reports from Monitoring and management tools on daily basis. Creating DBs through understanding of Database architecture and Instance, logical and physical structure. User/schema management and space management. Managing physical storage structure --Data files, control files, Redo logs and archive logs etc. Escalation to next level for support on issues related to all environments (Production, Test and Development). Monitoring Golden gate services. Working with the Ticket Management tool to manage tickets. Handle Change Management process and Incident Management tickets for all the production, development, and testing database changes. Prepare the technical SOPs for data base domain for managed services and implementation services. Administration and troubleshooting of HA DB environment (RAC / Clustering / Replication). Database migration - (Platform Migration / DB to DB Migration). Database upgrade & patching Plan and lead activities from pre to post. Create POA with all required details. Administration & Troubleshooting of Database Backup and restore - (Using native tools & Backup solutions) Administration & Troubleshooting Oracle Enterprise Manager or equivalent tools for database monitoring and management Keeping up to date with technology trends and developments. Work closely with service delivery team and ensure the agreed KPIs with customers are met. Always ensure customer satisfaction

foundit