Posted:4 days ago| Platform: Linkedin logo

Apply

Work Mode

On-site

Job Type

Full Time

Job Description

Key Responsibilities

  • Data Modeling: Design and maintain complex Logical and Physical data models; implement normalization and denormalization strategies based on performance needs.
  • Schema Development: Write and optimize complex SQL queries, stored procedures, functions, and triggers in PostgreSQL and Oracle DB.
  • Performance Tuning: Conduct query optimization, indexing strategies, and partitioning to ensure sub-second response times for the application.
  • Database Administration: Manage user access, backups, data security, and integrity constraints across development, UAT, and production environments.
  • Migration: Architect the migration path for data from the decommissioned system to the new environment without data loss or downtime.
  • Administration: Index management, partitioning strategies, and database security protocols.

Required Skills & Experience

  • Advanced proficiency in PostgreSQL and Oracle Database
  • Hands-on experience with NoSQL databases (e.g., MongoDB, DynamoDB).
  • Expertise in ERD tools (e.g., Erwin, MySQL Workbench, or LucidChart).
  • Solid understanding of ACID properties and CAP theorem. Preferred
Skills: oracle,database,security,postgresql

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now

RecommendedJobs for You

mumbai metropolitan region

chennai, coimbatore, thiruvananthapuram