Vacancy expired!
- We are seeking an Oracle database administrator with GoldgenGate experience. The candidate will be part of the DBA team that works on cutting edge technologies to support their trading systems, including Oracle RAC, Goldengate replication, and real-time data warehouses.
- Supporting various mission critical databases with enterprise-scale expertise in database management.
- Performing database administration functions such as database installation, configuration, upgrades, patching, capacity planning, backup, restore, disaster recovery, SQL code review, performance analysis, query tuning, database application design, physical data modeling, and developer support.
- Administrating Oracle Real Application Cluster on Linux Platform.
- Configuring, maintaining and troubleshooting Oracle Golden Gate Replication.
- Very Strong Experience in Query Tuning/Performance Tuning/Database System Tuning.
- Assist development and reporting groups in optimizing SQL statements in applications, batch jobs, and reports and in designing and using databases and database applications and processes for maximum performance, security, reliability, and availability.
- Monitors performance issues on all production and non-production databases (as applicable)
- Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations.
- Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
- Refine and automate regular processes, track issues, and document changes.
- Work with Goldengate to replicate data among different databases.
- Manage Oracle databases through multiple product lifecycle environments, from development to mission-critical production systems.
- Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
- Provide 24x7 support for critical production systems.
- Perform scheduled maintenance and support release deployment activities after hours.
- Ability to quickly diagnose the problem areas and come up with solutions and/or workarounds.
- Should have strong time management skills with willingness and ability to handle multiple projects/initiatives at the same time.
- Self-motivated with strong team, interpersonal and communication skills!
- 10+ years of experience in Oracle, including 5 years of experience in 12c onwards
- 3+ years of experience in Golden Gate
- Experience in MS SQL Server Database is a plus
- Experience in AWS is a plus
- Good Experiences in Shell and SQL. Python is a plus
- Experience in MySQL and PostgreSQL is a plus
- Experience in Pure storage is a plus
- Experience working in financial company is a plus
- Experience to Monitoring Tools like OEM cloud control, Foglight
Vacancy expired!