Database Developer (PostgreSQL/Oracle)
Themesoft Inc
Database Developer (PostgreSQL/Oracle)
Location: Menands NY 12204 (Hybrid)
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.
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.
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
- ...Job Description Job Description PostgreSQL Database Developer Employment Type: Full Time, Experienced level Department: Information Technology... ...customers. You will support a migration from the current Oracle database to a Postgres database and manage the database...PostgresqlOracleFull timeFlexible hours
Contact Government Services, LLC
Albany, NY19 days ago - ...The Database Engineer will design, implement, and maintain robust database systems... ..., and maintain relational databases (PostgreSQL, SQL Server, Oracle, MySQL). Perform performance tuning,... ...Collaborate with the Integration team to develop and maintain data integration...PostgresqlOracle
Excelsior College
Albany, NY4 days ago - ...Oracle PL/SQL Developer Location: Albany, NY 12237 Duration: 2 years Contract Position Requirements Mandatory Requirements... ...Requirements ~84 Months of experience in interpreting physical database models and experience with relational database concepts...OracleContract work
InterSources
Albany, NY2 days ago - ...performance, and adherence to coding standards. Collaborate with database administrators to design and optimize database schemas, and... .... Experience with database systems such as MySQL, PostgreSQL, or Oracle, including SQL query optimization. Knowledge of web technologies...PostgresqlOracle
ModusLights Technologies
Albany, NY5 hours ago - ...Senior Oracle Developer Location: Albany, NY Duration: 2- 3 years Contract Position Requirements ~7 years' experience using... ...Cascading Style Sheets. ~7 years' experience with Oracle: Database design, PL SQL coding, stored procedures, packages, indexes,...OracleContract workWork at office
InterSources
Albany, NY2 days ago - ...A leading government services firm in Albany, NY is seeking a Senior Oracle APEX Developer to support various IT services including software application support and enterprise infrastructure. Ideal candidates will have over 8 years of experience, a strong background in...OracleFull time
CGS Federal (Contact Government Services)
Albany, NY6 hours ago - ...Job Description Job Description Senior Oracle APEX Developer II Employment Type: Full-Time, Entry-Mid Level Department: Information... ...environment. Provide support in the advanced use of Oracle Database products version 11 and above. - Provide support for...OracleFull timeFlexible hours
Contact Government Services, LLC
Albany, NY19 days ago $135.2k - $306.4k
...Software Engineer or Architect Database Engine, Search & Document... ...-facing capabilities inside Oracle Database. This is a role for... ...and Migration Help evolve developer-facing document APIs,... ...Experience with Oracle Database, PostgreSQL, MongoDB, DynamoDB, Elasticsearch...PostgresqlOracleTemporary workFlexible hoursOracle Defunct
Albany, NY2 days ago- ...including datacenter, private cloud, storage, network, and databases. You love building data pipelines, configuring FinOps... ...arrays, network telemetry (SD-WAN), and enterprise databases (Oracle, SQL Server, PostgreSQL)Configure FinOps platforms (Cloudability, CloudHealth,...PostgresqlOracleFull timeWork experience placementLive inWork at officeLocal area
$105k - $141.75k
...have Rocket Enterprise Server and Enterprise Developer experience. Additionally, technical skills... ...experience of IBM CICS; IMS and JCL Relational databases, such as IBM DB2/UDB, Oracle, Microsoft SQL Server; PostgreSQL Windows operating system Linux/UNIX...PostgresqlOracleFull timeRemote workWorldwideRocket Software
Albany, NY4 days ago- ...an experienced Overall Tech Lead with 10–15 years of hands-on expertise in Oracle Fusion applications and Oracle Integration Cloud (OIC). The ideal candidate will independently design, develop, and support integrations while providing technical leadership across Oracle...Oracle
ClinDCast LLC
Albany, NY11 days ago - ...solutioning of large, complex data sets and models. Experience developing data pipelines from many structured and unstructured... ...and ability to apply them. Experience with relational databases such as PostgreSQL. Experience with version control systems such as Git. Preferred...PostgresqlFlexible hours
Cgsfederal
Albany, NY13 hours ago - ...of large, complex data sets and models. Experience with developing data pipelines from many sources from structured and unstructured... ...and ability to apply them. Experience with relational database, such as PostgreSQL. Work comfortably in version control systems, such as Git...PostgresqlFull timeFlexible hours
Contact Government Services, LLC
Albany, NY4 days ago - ...objects such as procedures, functions, triggers, and packages in Oracle database 12c or higher. 72 months experience working with Oracle... ...and ETL platform architecture. 24 months experience developing, implementing, and integrating systems related to Criminal Justice...Oracle
- We Are:Accenture’s Oracle practice, and we make the new happen now. Every day, we imagine the future and bring it to life using design... ..., Engineering, Customer Operations, Regulatory, and Finance.Develop and maintain functional design documents (FDDs), configuration...OracleFull timeWork experience placementLive inWork at officeLocal areaRemote work
- ...POSITION PL/SQL Developer LOCATION New Albany, OH (on-site preferred... ...application development environment. ~ Strong Oracle PL/SQL development experience. ~... ...SQL Developer, TOAD, or equivalent database development tools. Oracle Retail...OracleRemote work
Akaasa Technologies
Albany, NY1 day ago - Oracle DBA - Albany, NY - 24 Months - # K18251/300755 Contract position. Candidates willing... ..., upgrading, and patching Oracle Database software in an IBM AIX environment. Designing... ...designs. Creating Oracle databases. Developing and testing backup and recovery...OracleContract workWork at officeRemote work
- ...the power of change to create value and shared success for our clients, people, shareholders, partners and communities. Visit us at Oracle CFO & Enterprise Value (CFO & EV) practice helps finance organizations reinvent themselves through Oracle Cloud ERP. We partner...OracleFull timeWork experience placementLive inWork at officeLocal area
- ...Job Description Job Description Senior Database Administrator II Employment Type: Full-Time, Mid Level Department: Information... ...maintaining data warehouses. - Experience with AWS RDS for PostgreSQL. - Experience with working in cloud environments such as...PostgresqlFull timeFlexible hours
Contact Government Services, LLC
Albany, NY5 days ago - ...technical problems involving networking, database, application, storage and associated... ...technical guidance to a team of software developers to implement solutions to multiple concurrent... ...• Five years' experience performing Oracle database development using SQL and Procedural...Oracle
3B Staffing LLC
Albany, NY5 hours ago $64.89k - $173.04k
...modern programming languages, designing and developing data solutions. The position is open in... ...working with SQL and relational database management systems 2+ years of experience... ...Platforms such as Microsoft SQL Server, Oracle, Teradata etc. Programming and modifying...OracleHourly payFull timeTemporary workLocal areaStryker
Albany, NY4 days ago- ...enterprise content/data management services. We have developed our methodologies and processes based on the... ...access using JDBC.Develop complex relational database queries using ANSI standard SQL and PLS/SQL to be used with Oracle databases giving special consideration to...Oracle
$126.3k - $241.2k
...SAGA, orchestration/choreography), data movement (ETL/ELT), and API lifecycle management; knowledge of integration platforms such as Oracle Integration Cloud (OIC), middleware, and APIs. Familiarity with enterprise architecture frameworks (e.g., TOGAF), agile at scale (e...OracleLocal areaRegeneron Pharmaceuticals
Albany, NY4 days ago- Senior Database Administrator II Contact Government Services is seeking a Senior Database Administrator to assist with administering... ...and maintaining data warehouses. Experience with AWS RDS for PostgreSQL. Experience with working in cloud environments such as Azure and...PostgresqlFlexible hours
$169.8k - $355.4k
...Job Description Oracle Cloud Infrastructure (OCI) powers Oracle’s global cloud services through highly available, large-scale, enterprise... ..., emergency response readiness, and capacity execution. • Develop next-generation site and regional operations leaders....OracleTemporary workWorldwideFlexible hoursOracle
Albany, NY1 day ago- ...an On Shore test automation team of at least 10 test automation developers. Proven experience developing custom automation scripts in... ...for data validation from various data sources in both DB2 and Oracle. Hands‑on experience in developing automation scripts for a very...OracleWork experience placementLocal areaImmediate start
360 IT Professionals
Albany, NY13 hours ago $74.1k - $148.3k
...Team Overview: The Data Center Construction organization at Oracle Cloud Infrastructure (OCI) is rapidly expanding to deliver gigawatt... ...internal stakeholders. Quality, Standards & Compliance • Develop and oversee testing, certification, and QA/QC procedures for...OracleTemporary workLive inLocal areaWorldwideRelocationRelocation packageFlexible hoursOracle
Albany, NY3 days ago- ...Position(s) Required: 3-Developer-Level III Hybrid Interview: Webex Designated Work Location: 40 North Pearl, Albany NY... ...driven) More than (7) years proven experience with SQL/NoSQL databases, API development (REST/SOAP), version control (Git), and...
InterSources
Albany, NY4 days ago $78.7k - $150.6k
...together: At Regeneron, we use science and innovation to develop life-changing medicines for people with serious diseases. We are... ...supporting the configuration, implementation, and ongoing management of Oracle Supply Chain applications and ERP systems. In this role, you...OracleWorldwideMonday to FridayRegeneron
Troy, NYa month ago- ...enhancing, and modernizing existing client-server applications and Oracle databases. This individual will collaborate with business stakeholders,... ...replacement with a modern web-based solution. Design, develop, test, and deploy new software features. Create and...OracleFull timeContract work
Diverse Agile Solutions
Albany, NY22 days ago
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Database Developer (PostgreSQL/Oracle). Be the first to apply!
