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

Benefits:
- Flexible schedule
- Paid sick time
- Provident Fund

Work

📌 PostgreSQL Dba (Dashrath)
🏢 Luxsh Solutions
📍 Dashrath