Job Title: Database Developer (PostgreSQL / Oracle)
Location details: Menands, NY – Hybrid
Duration: 12+ Months
Key Responsibilities:
Database Development: Design, develop, and maintain robust Oracle PL/SQL packages, stored procedures, functions, triggers, views, and complex SQL queries, PostgreSQL database objects, including functions, procedures, triggers, and views using PL/pgSQL.
Database Migration & Conversion: Analyze Oracle database objects, map dependencies, and assist in migrating Oracle PL/SQL code to PostgreSQL while ensuring functionality and performance.
Performance Tuning: Troubleshoot slow-running SQL queries, optimize execution plans, indexing strategies, partitioning, and database performance across Oracle and PostgreSQL environments.
API Development & Integration (Preferred): Design, develop, consume, and support RESTful APIs for seamless integration between databases and enterprise applications. Collaborate with application teams to expose database services through APIs.
Data Integration: Build, maintain, and support ETL processes and data pipelines to ensure accurate and efficient data movement across systems.
Cross-Functional Collaboration: Work closely with application developers, QA engineers, DevOps teams, architects, and business analysts to deliver secure, scalable, and high-quality database solutions.
Documentation & Deployment: Prepare technical documentation, deployment scripts, release procedures, and standard operating procedures (SOPs) for database changes and production deployments.
Required Skills & Qualifications:
Technical Skills:
- Solid experience in PostgreSQL development, including PL/pgSQL, database design, and query optimization.
- Strong hands-on experience with Oracle Database (11g/12c/19c) and advanced PL/SQL programming.
- Expertise in writing complex SQL queries, stored procedures, functions, packages, triggers, and views.
- Strong understanding of relational database concepts, data modeling, normalization, and indexing strategies.
- Experience analyzing execution plans using Oracle Explain Plan and PostgreSQL EXPLAIN/EXPLAIN ANALYZE to optimize database performance.
- Hands-on experience with RESTful APIs, including API development, integration, testing, and troubleshooting (preferred).
- Experience working with JSON/XML data formats and API-based data exchange.
- Experience building and supporting ETL processes and data migration activities.
- Proficiency in Unix/Linux shell scripting for database automation and operational tasks.
- Experience using version control tools such as Git
- Familiarity with Agile/Scrum development methodologies.
Preferred Qualifications:
- Experience migrating Oracle databases to PostgreSQL.
- Knowledge of Java, Spring Boot, Python, .NET, or Node.js for API integration.
- Familiarity with cloud platforms such as AWS.
- Experience with CI/CD pipelines and DevOps practices.
- Knowledge of messaging technologies such as Kafka or RabbitMQ.
- Oracle and/or PostgreSQL certifications are a plus.
Education:
Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related field.
Never miss an opportunity! Create an alert based on the job you applied for.
