SQL/Python Developer

Lorven Technologies Inc
New York, United States of America
2 days ago

Role details

Contract type
Temporary to permanent
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

New York, United States of America

Tech stack

Java
Agile Methodologies
Application Performance Management
Code Review
Computer Programming
Databases
Data Integrity
Relational Databases
Database Schema
Software Debugging
Python
PostgreSQL
Microsoft SQL Server
MySQL
Oracle Applications
Oracle SQL Developer
Performance Tuning
Systems Development Life Cycle
Query Optimization
Software Construction
Software Engineering
SQL Stored Procedures
SQL Databases
Scripting (Bash/Python/Go/Ruby)
Freeform SQL
Database Optimization
Backend
Information Technology
Software Coding
Code Restructuring
Software Version Control
Sql Tuning
Legacy Systems

Job description

  • Analyze, develop, and optimize complex SQL queries, stored procedures, and database objects to improve application performance and scalability.
  • Perform SQL performance tuning, identify bottlenecks, optimize execution plans, and implement database best practices.
  • Design, develop, and maintain Python-based applications, scripts, and automation solutions.
  • Review and understand existing Java codebase to support ongoing maintenance and define migration strategies to Python.
  • Participate in application modernization efforts by refactoring legacy components into scalable Python solutions.
  • Troubleshoot application and database issues while ensuring high performance, reliability, and data integrity.
  • Collaborate with Architects, Product Owners, QA teams, and business stakeholders to gather requirements and deliver high-quality technical solutions.
  • Participate in Agile ceremonies, code reviews, testing, and deployment activities while following software engineering best practices.
  • Document technical designs, database changes, migration approaches, and development processes to support long-term maintainability., Title: - Oracle PL/SQL developer with Python Location : NYC NY-Need Mandatory onsite in NYC Duration : 3 months extendable Need : 1. Oracle/ SQL : yrs 2. Python : yrs In …
  • 19 days ago, Our client is seeking a Senior Full Stack Developer to join their technology team. The successful candidate will work closely with business stakeholders and technical teams to desi…
  • 1 month ago

Requirements

  • Bachelor's or Master's degree in Computer Science, Information Technology, Engineering, or a related field with 5+ years of experience in SQL and Python application development.
  • Strong hands-on experience writing, analyzing, and optimizing complex SQL queries, stored procedures, functions, views, and database objects.
  • Proven expertise in SQL performance tuning, query optimization, indexing strategies, execution plan analysis, and database troubleshooting.
  • Strong programming experience with Python for application development, scripting, automation, and backend solutions.
  • Experience working with relational databases such as SQL Server, Oracle, PostgreSQL, or MySQL.
  • Ability to understand and analyze legacy Java code to support application modernization and migration initiatives (new Java development is not required).
  • Experience contributing to application modernization, code refactoring, and migration from legacy systems to Python-based solutions.
  • Strong understanding of software development lifecycle (SDLC), coding standards, version control, debugging, and testing best practices.
  • Experience collaborating with cross-functional teams including Architects, Developers, QA, Product Owners, and Business Analysts.
  • Excellent analytical, problem-solving, communication, and troubleshooting skills with the ability to work in Agile environments.

Apply for this position