Verified Job
IT / Software / Data Analyst
Oracle Database Admin
IT / Software / Data Analyst
#250109
Remote / WFH
Job Description
Job Title Oracle Database Admin L3 Proposed Grade Band B2 / B3 Primary Skill (Technical Skill) Oracle DBA Secondary Skill (Optional) OS - Solaris/Linux/AIX/Client UNIX & Windows
Database - MySQL/MS SQL & Windows OS / Sybase /
DB2 / PostgreSQL/MongoDB/SAP HANA Educational Qualifications B.E. / B.Sc. / Diploma Experience Level 5 8 Years Location of Posting
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
Database - MySQL/MS SQL & Windows OS / Sybase /
DB2 / PostgreSQL/MongoDB/SAP HANA Educational Qualifications B.E. / B.Sc. / Diploma Experience Level 5 8 Years Location of Posting
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
