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