Oracle DBA

About Client :-

Our client is a French multinational information technology (IT) services and consulting company, headquartered in Paris, France. Founded in 1967, It has been a leader in business transformation for over 50 years, leveraging technology to address a wide range of business needs, from strategy and design to managing operations.

The company is committed to unleashing human energy through technology for an inclusive and sustainable future, helping organisations accelerate their transition to a digital and sustainable world.

They provide a variety of services, including consulting, technology, professional, and outsourcing services.

Job Details:-

location : Chennai

Mode Of Work : Hybrid

Notice Period : Immediate Joiners

Experience : 10-14 yrs

Type Of Hire : Contract to Hire

JOB DESCRIPTION:

1. Proficient in Oracle and PostgreSQL PL/SQL, with expertise in designing and tuning complex queries, optimizing database performance, and troubleshooting query-related issues.

1. Strong knowledge of UNIX Shell Scripting, capable of performing regular database maintenance tasks such as backups, restores, patching, and automation of routine tasks.

1. Extensive experience with Oracle GoldenGate or manual Change Data Capture (CDC) processes for data replication and synchronization.

1. Hands-on-experience in database migration across environments, including On-Prem to cloud or between different database platforms also able to give the best solution approach to provide the migration tools/manual process for best compatible with the re-write.

1. Understand provide the solution for Pre & Post migration transformation/Re-conciliation based on the Business Data Mapping and requirements.

1. Skilled in re-engineering legacy systems, analysing existing database structures & Data-Mapping w.r.t Legacy to rewrite, and providing optimised solutions for system rewrites and modernization.

1. Proven ability to act as a solution architect, designing end-to-end database solutions (Data Modelling, Data Profiling), evaluating emerging technologies, and driving innovation to meet evolving business needs.

1. Proficient in monitoring database health and performance using tools like Oracle Enterprise Manager, pgAdmin, or manual monitoring techniques.

1. Expertise in analysing query execution plans, identifying bottlenecks, and tuning SQL queries for optimal performance.

1. Experienced in configuring and managing database indexes, partitions, and storage structures to enhance database efficiency.

1. Strong understanding of Database Security Policies, including implementing user roles, permissions, encryption, and ensuring compliance with organisational and regulatory standards.

1. Skilled in identifying and addressing security vulnerabilities, performing audits, and ensuring databases adhere to best practices for security and compliance.

1. Knowledgeable in high availability (HA) and disaster recovery (DR) solutions, including Data Guard, replication, and failover mechanisms.

1. Familiar with cloud-based database solutions such as Oracle Cloud, AWS RDS for Oracle, or PostgreSQL on Azure.

1. Strong problem-solving and analytical skills, with the ability to diagnose and resolve Database related issues efficiently.

1. Excellent communication and collaboration skills, capable of working with cross functional teams to support database related needs.

1. Experiencing in documenting database configurations, processes and procedures and generating reports on database performance and incidents.