Job Title: Oracle DBA
Location: Dublin, Ireland
Educational Qualifications:
OS- Solaris/Linux/AIX/HP UNIX & Windows Database - MySQL/MS SQL & Windows OS / Sybase / DB2 / PostgreSQL/MongoDB/SAP HANA
Experience Level:
B.E. / B.Sc. / Diploma
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
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
Behavioral Skill:
* Strong verbal and written communication skills
* Team management and motivation
* Flexibility, good attitude