
Can write DDL/DML for creating database objects (tables, indexes, partitions etc.).Understands Linux and Windows operating systems.Understands Oracle, RAC, data replication and high availability technologies such as RAC, DataGuard, GoldenGate.Minimum of 5 Years of working experience as an Oracle DB.If you are interested, then please send us your relevant details along with the updated resume on qualification: Automobile industry related experience.Oracle to PostgreSQL Migration experience will be a great plus.Extensive experience in using extensions and all available functions.
Strong experience in writing complex JOINS and Sub Queries. Experience in developing and managing table and index partitioning. Strong experience in SQL and Database performance tuning. Experience in triggers and constraints. Ability to write optimized SQL queries and PL/SQL code. Ability to develop efficient data models. In-depth knowledge of IT industry database technologies and processes and business applications integrated with database technologies. Experience with automation using Python, Ansible, etc. Working knowledge of Database Security mechanism, data encryption, obfuscation, auditing using tools. Proven experience in working in a mission critical environment in a multi-terabyte database platform. Measure database performance and troubleshoot complex database issues, I/O bottlenecks and SQL Tuning. Experience in working closely with the application teams to resolve any performance related issues. Experience in implementing Security Guidelines of Postgres STIG, testing, and other vulnerability remediation. In depth knowledge of the Oracle, PostgreSQL architecture and application data lifecycle management. Hands on experience as a Oracle PL/SQL Developer (added advantage if PostgreSQL I known) code development and migrations. NBFC ( Non Banking Financial Services ) (15) Operations Management / Process Analysis (48)
Application Programming / Maintenance (85)