Oracle DBA

• Provide guidance and support to Application team
• Install, tune, implement and upgrade DBMS installations
• Write and deploy SQL patches
• Write new database programs and maintain existing programs to ensure they can handle the flow of traffic and the amount of data being stored in the database.
• Help design new databases based on company needs, data storage needs, and the number of users accessing the database.
• Continuously monitor databases and related systems to ensure high functionality.
• Write new support programs and scripts for databases to deploy, operate, increase data storage capacity, and fix existing database problems.
• Troubleshoot platform specific performance, checking for potential problems that affect database functionality and related database programs.
• Look through coding language to debug existing database scripts and programs.
• Review daily, weekly, and monthly database reports, including user reports and systems information, to spot problems and ensure that all databases and support systems are working at peak levels.
• Process work accurately and in a timely manner
• Always paying attention to the detail
• Urgency
• Proactively and regularly make recommendations for system improvements
• Collate, prepare, and present statistical information for internal and external use

Do you have experience in Systems analysis?, * Expertise in Installation, Upgrade & Patching of different components in Oracle like -RAC,Data-Guard,RMAN,OEM,ASM,Partitioning etc,. and experience with the other platforms we manage listed in the Duties and Responsibilities.

• Experience with Replication including setup, troubleshooting issues and failovers - (Goldengate or HVR)
• Monitor all systems (work processes, users, system logs, short dumps, locks, developer traces, system traces, disk space, etc.).
• Ensure production uptime service levels are maintained and made available per requirements that include backup, recovery, refresh, performance tuning, and security
• Provide data cleansing services, verify data integrity, and implement access controls
• Provide routine maintenance including problem defect analysis and resolution, space, storage, object management, physical database layout, rollback segment management, and temporary space management
• Experience with Schema creation, deployment, and maintenance
• Experience with Setting up and configuration of Auditing, audit trails
• Carry out recovery of databases in an event of log full, system crash Troubleshoot issues related to the installation for our supported platforms
• Should have knowledge of Disaster Recovery setup and maintenance
• Automation using shell-script, python, Ansible, go, etc.
• Performance & Tuning Related Expertise
• Experience with Performance analysis, monitoring of queries and platform specific tuning.
• Linux