C2H Indent - Hence applicable only for internal employees. About Wipro: Wipro Limited (NYSE: WIT, BSE: 507685, NSE: WIPRO) is a leading technology services and consulting company focused on building innovative solutions that address clients’ most complex digital transformation needs. We leverage our holistic portfolio of capabilities in consulting, design, engineering, operations, and emerging technologies to help clients realize their boldest ambitions and build future-ready, sustainable businesses. A company recognized globally for its comprehensive portfolio of services, strong commitment to sustainability and good corporate citizenship, we have over 250,000 dedicated employees serving clients across 66 countries. We deliver on the promise of helping our customers, colleagues, and communities thrive in an ever-changing world. A PROUD HISTORY OF OVER 75 YEARS FY22 REVENUE 10.4 BN USD WE’RE PRESENT IN 66 COUNTRIES OVER 1,400 ACTIVE GLOBAL CLIENTS Location: O'Fallon, MO Job Role: Oracle DBA Required Skills: Handled large database estates and managed TB size of databases Installation and administration of multiple versions of databases on multiple Unix platforms and Windows servers Design and implement the high availability solutions (RAC, Golden Gate and Dataguard) Install, configure and manage ASM instances in oracle Plan and execute major migrations and upgrades Define and configure the disk and diskgroups in ASM and troubleshoot Manage and administer the databases on Exadata machine Plan the database upgrade, migration and patching Plan and implement the backup/recovery on need basis Hardware tech refresh (host to host database move) Coordinate and work with database vendors for resolution on major incidents Database refresh, re-org, backup using RMAN and 3rd party tools Install and configure grid control database monitoring tools Install, Administer, manage and troubleshoot Oracle grid control Define performance benchmarks and metrics Periodic database instance performance review and tuning recommendation Proactive database analysis and suggestion to application team / business Write and troubleshoot shell scripting, SQL and PL/SQL scripts Primarily role is supporting the production and non-prod database environments Ensure the reduction of repeated errors through implementation of necessary checkpoints Contribute towards evaluation of tools, products and software selection SLA tracking and reporting to Higher management Prepare and Maintain Standard Operating Procedure for all activities Proactive identification of risks and mitigation of the same Technical presentation on emerging technologies. Foresee the need for newer technology based trainings on customer needs and provide suggestions for such trainings to Project Manager. Implement and Periodical check on Automation Implement and Periodical check on DB Security Identify, document and track Technology related risks and mitigation plan in the project Technical and Process guidance to L2 and L1 DBA Provide 24x7 and on call support for critical application databases Technical Skills Strong database administration Database upgrades on multiple versions and releases High availability (RAC) setup and administration Disaster recovery design, planning, setup and administer the Dataguard (standby) Install, configure, maintain and troubleshooting on Golden Gate Knowledge on ExaData OEM Configuration and management Automation through scripting Strong performance analysis on AWR, ADDM, SQL Profile, ASH and advisory views Experience on OS, Storage, Network and Virtualization activities Certification on Primary Technology Handled database estate of various technologies Process & Tools Service Request and Incident, Problem, Change managements Configuration, Capacity planning and Knowledge management Experience on ITIL Tools like Remedy, Service Now or any other ticketing tool Identify the service improvement plan Secondary Skill OS - Solaris/Linux/AIX/HP UNIX & Windows Database - MySQL/MS SQL & Windows OS / Sybase / DB2 / PostgreSQL/MongoDB/SAP HANA Wipro is an Equal Employment Opportunity employer and makes all employment and employment-related decisions without regard to a person's race, sex, national origin, ancestry, disability, sexual orientation, or any other status protected by applicable law. Oracle Database Admin