➽Supports, troubleshoots, tests, and maintain Oracle PL/SQL and Unix Script code and functionality.➽Working extensively on Oracle 19c.➽Produce reports over Oracle data, attend Oracle conferences and research Oracle functionality.➽Maintain effective and efficient PL/SQL packages, procedures, triggers, and functions.➽Follow current department policies, especially regarding the use of workload management tools. ➽Other responsibilities of an Oracle database administrator (DBA) include:➽Managing access to systems that store company information.➽Ensuring that information is stored securely and only available to authorized people.➽Monitoring and troubleshooting database hardware.➽Performance monitoring➽Security analysis➽Performing data backup➽Data recovery➽Providing support for production systems and application development teams➽Developing and designing databases➽Creating primary database storage structures➽Designing and creating primary objects➽Modifying database structure as necessary for enhancements or performance➽Creating documentation➽Designing interfaces, database objects, and creating plans

➽Working in Oracle EBS (12.2) / Oracle Application➽Working in running STA and perform tunning. ➽Working in generating ASH / AWR reports➽Working on performing Export and Import at high level for tables and full schemas.➽Working on Oracle Forms and Reports➽Working on analysing AWR / ASH Reports regularly➽Working on RAC Systems, monitoring data Guard, Sync Issues and monitoring multiple database syncs regularly➽Working on 12c and 19c (12.2), EBS and Non – EBS➽Managing PSO Patching on every release➽Working on refresh / cloning along with every Patching Cycle➽User Management, creating user/ resetting passwords➽Granting DML access to users➽Working with Service Now and Pager Duty➽Making sure backups run properly for all databases and running backups again if any backup fails➽Monitoring and maintaining FRA so that it does not fill➽Adding Datafiles to tablespaces ➽Creating GRP Guaranteed Restore Points

➽Understood and documented functionalities of various application modules, participated in requirement gathering, and created technical designs.➽Designed, developed, coded, debugged, and corrected errors in application programming languages.➽Developed software applications and workflows using the integration tool WMB, facilitating data movement within various streams.➽Coded for language conversion (French and German basics), followed up with testers, and resolved issues proactively.➽Worked on software development lifecycle activities, utilizing Agile methodologies, Test Driven Development (TDD), and Continuous Integration.➽Built architecture for development projects, estimated timeframes, and contributed to initial project phases.➽Developed and maintained tools for software product releases, writing automation scripts, and improved workflow processes.➽Conducted end-to-end testing, integration, and code deployment in multiple environments.➽Gathered domain knowledge in the insurance sector, developed new change requests and maintained technical documentation.➽Managed Oracle 10g & 11g instances, maintained redo log files, data files, and control files.➽Conducted system analysis, recommended operational improvements, and participated in educational opportunities for professional growth.➽Exported and imported tables, schema, and databases, ensuring data integrity and security.➽Protected operations by keeping information confidential and provided summarized development and service issue reports