Job Title: PostgreSQL Database Administrator (DBA)

Location: Vadodara
Employment Type: Full time

Department: Information Technology

Position Overview

Key Responsibilities
Lead the database migration from Oracle to PostgreSQL, including schema conversion, data transfer using tools like ora2pg, ETL processes, and validation of data integrity post-migration.
Manage database users, security roles, and access controls following the principle of least privilege.
Design and implement database schemas, including normalization, indexing, constraints, and relationships optimized for ERP workflows like order processing and reporting.
Develop advanced SQL queries using CTEs, window functions, joins, and stored procedures (PL/pgSQL) to replicate and enhance Oracle-based business logic.
Perform performance tuning, query optimization, and monitoring to handle high-volume transactions and ensure low-latency access.
Implement security best practices, including row-level security, backups, replication, and high-availability setups.

Required Qualifications
Advanced SQL proficiency:



execution plans, indexing strategies, partitioning, and optimization for large datasets, with familiarity in Oracle PL/SQL equivalents.
Strong knowledge of database architecture, performance tuning, migration tools (e.g., ora2pg, AWS SCT), and monitoring tools like pgAdmin, EXPLAIN ANALYZE, and pgBadger.
Experience with cloud deployments (e.g., AWS RDS PostgreSQL) and integration with languages like Python, Java, or Node.js.

Preferred Skills
Familiarity with ERP-specific data models (e.g., finance modules, inventory tracking) and handling Oracle-specific features like sequences or packages in PostgreSQL.
Knowledge of replication, clustering, and disaster recovery for production stability.
Experience in regulated industries like pharmaceuticals a plus.

What We Offer

Pay: ₹400,000.00 - ₹1,200,000.00 per year

Perks:
Versatile schedule
Paid sick time
Provident Fund

Work

📌 Postgresql Dba Dashrath
🏢 Luxsh Solutions
📍 Dashrath