Description
Job Description:
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
? ITIL Foundation certified
Behavioral Skill
? Strong verbal and written communication skills
? Team management and motivation
? Flexibility, good attitude.
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
? ITIL Foundation certified
Behavioral Skill
? Strong verbal and written communication skills
? Team management and motivation
? Flexibility, good attitude.