Role & Responsibilities | - Handled large database estates and managed TB size of databases
- Hands-on experience on Oracle 11g, 12C, 18c and 19C database administration.
- Hands-on experience on Pluggable database Management (PDBs to PDBs Online refresh and Backup).
- 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
- Preparing System Maintenance Documents and creating SOP for operational use.
- Preparing Risk register based on customer environment.
- Understanding SOW (Scope of Work).
|
