Job Type : Contract
Number Of Applications : 4
Job Posted On : 24/05/2022
Job Posted On : 24/05/2022
Job Duration: 1 month
Daily Salary: Negotiable
Job Title Oracle Database Admin – L3
Primary Skill (Technical Skill) : Oracle DBA
Secondary Skill (Optional) : OS- Solaris/Linux/AIX/HP UNIX & Windows
Database : MySQL/MS SQL & Windows OS / Sybase /
DB2 / PostgreSQL/MongoDB/SAP HANA
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
5 years ago