What are the responsibilities and job description for the PostgreSQL Database Engineer position at Kanini?
Job Details
Job Summary:
We are seeking an experienced and detail-oriented PostgreSQL Database Engineer with a strong background in Oracle to PostgreSQL migrations. The ideal candidate will lead and support large-scale database migration projects, ensuring seamless data transformation, performance optimization, and post-migration support.
Key Responsibilities:
Lead end-to-end migration from Oracle to PostgreSQL, including schema conversion, data migration, and validation
Analyze existing Oracle database architecture, objects, stored procedures, packages, and performance configurations
Design and implement equivalent PostgreSQL solutions following industry best practices
Convert PL/SQL code (procedures, triggers, functions) to PL/pgSQL or appropriate PostgreSQL constructs
Optimize PostgreSQL performance through indexing, query tuning, partitioning, and caching strategies
Support testing teams during UAT and post-migration validation phases
Develop migration strategy, risk assessments, and rollback plans
Provide documentation, deployment scripts, and technical support throughout the migration lifecycle
Collaborate with development and DevOps teams to ensure seamless database integration
Participate in database upgrades, patching, and maintenance
Monitor and troubleshoot PostgreSQL databases in production and staging environments
Required Skills & Experience:
5 years of hands-on experience with PostgreSQL database administration and development
Strong experience in Oracle to PostgreSQL migrations (manual and using tools like AWS DMS, Ora2Pg, etc.)
In-depth knowledge of PL/SQL and PL/pgSQL
Experience in schema design, data modeling, and performance tuning
Proficient in writing complex SQL queries, stored procedures, and functions
Experience with Linux-based systems and shell scripting for automation
Familiarity with high availability (HA), replication, and backup strategies for PostgreSQL
Strong debugging and analytical skills
Excellent verbal and written communication skills
Preferred Qualifications:
Experience with cloud platforms like AWS (RDS/Aurora PostgreSQL), Google Cloud Platform, or Azure PostgreSQL
Exposure to CI/CD tools, version control (Git), and infrastructure automation (Terraform, Ansible)
Knowledge of database security and compliance best practices
Familiarity with containerization (Docker/Kubernetes)
