Job Description

Oracle DBA Admin - L2

General Information

Req #

WD00051312

Career area:

Customer Experience

Country/Region:

India

State:

Maharashtra

City:

Mumbai

Date:

Monday, April 24, 2023

Working time:

Full-time

Additional Locations:

• India - Mah\xc4\x81r\xc4\x81shtra - Mumbai

• India - Mah\xc4\x81r\xc4\x81shtra - Mumbai

Why Work at Lenovo

Here at Lenovo, we believe in smarter technology that builds a brighter, more sustainable and inclusive future for our customers, colleagues, communities, and the planet.

And we go big. No, not big-huge.

We\'re not just a US$70 billion revenue Fortune Global 500 company, we\'re one of Fortune\'s Most Admired. We\'re transforming the world through intelligent transformation, offering the world\'s most complete portfolio of smart devices, infrastructure, and solutions. With more than 71,500 employees doing business in 180 markets, we help millions-not just the select few-experience our version of a smarter future.

The one thing that\'s missing? Well\xe2\x80\xa6 you...

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

Additional Locations:

• India - Mah\xc4\x81r\xc4\x81shtra - Mumbai

• India - Mah\xc4\x81r\xc4\x81shtra - Mumbai

• India

• India - Mah\xc4\x81r\xc4\x81shtra

• India - Mah\xc4\x81r\xc4\x81shtra - Mumbai , * India - Mah\xc4\x81r\xc4\x81shtra - Mumbai

Lenovo