Oracle Database Administrator - Ticketing System

Designation: Oracle Database Administrator WFH Job Handling Technical support tickets within SLAs - Administer business application databases and associated program software in Database and Application Infrastructure. - Undertake performance monitoring and tuning, problem resolution, availability management, capacity management, change management and security access management to ensure the continuous provision of service of the database and integrated platform environments. - Monitor performance of database systems resources and query throughput - Optimize SQL Code as necessary - Monitor and maintain database storage resources,database maintenance plans for backups, index rebuild/defragment, and database statistics - Provide advanced skills in the areas of fault diagnosis and failure and initiate remedial action as required in Database and Application Infrastructure environments. - Perform complex backup and recovery tasks for database and applications infrastructure environments. Design the database recovery and backup policy and procedures in accordance with business requirements. - Implement and maintain database replication solutions using Oracle Golden Gate. - Manage data migration projects, including planning, execution, and post-migration validation. - Collaborate with cross-functional teams to ensure smooth data replication and migration processes. - Perform database performance tuning and optimization. - Troubleshoot database-related issues and implement solutions in a timely manner.- Implement and maintain database backup and recovery procedures. - Monitor database health and proactively address potential issues. - Stay updated with the latest Oracle technologies and best practices. Skills Required: - Oracle Database Setup and administration. - Implementation knowledge of RAC and its configuration from scratch. - Expertise in one or more of Systems area including virtualization, network, storage - Working knowledge of DBVisit, Oracle Backup & Recovery and High availability technologies (via Dataguard) - Knowledge in Oracle 12c and higher versions. Managing specialized workloads in cluster, volumes and configuring data, monitoring & logging, maintenance and troubleshooting. - Oracle Database upgrade, performance tuning, 24/7 production support. - Planning out strategies for DB migration, DB consolidation and driving it end to end. - Dig deep to discover the root causes of issues - exploring source code, databases, logs, and traces. - Provide technical expertise, advice and guidance on technology aspects of database and application delivery services to management and other technical staff. - Strong documentation skills in documenting processes, procedures and tools descriptions. - Participate in and contribute to Release activities including Spec reviews. - Understand and contribute to effective Monitoring of the critical components of the System. - Ensure database security, integrity, and performance - Recommend, implement, and maintain best practices and corporate standards (ref:hirist.tech)

Location: in, IN

Posted Date: 11/24/2024