Job Description Rate: 520 Euros 3 Days WFO Role & Responsibilities · 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 Skills Must have Nice to Have Technical Skills (Core & Top-Up) · 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 · ITIL Foundation certified Behavioral Skill · Strong verbal and written communication skills · Team management and motivation · Flexibility, good attitude · Manage the global infrastructure customer and projects Requirements Oracle Database Admin