Required Skills: Python, PostgreSQL, MySQL, SQL Server, Oracle, ETL pipelines, NoSQL databases, Docker, Kubernetes, cloud databases
Job Description
Role : Senior Python Developer with Strong SQL expertise (12+ years of experience)
Location : Boston, MA
Duration: 12 months
Job Description:
We are looking for a Senior Python Developer with strong SQL expertise to design, develop, and optimize database-driven applications. The ideal candidate will have extensive experience in Python programming, SQL query optimization, and database management in high-performance environments.
Key Responsibilities:
Design and develop Python applications with a strong focus on database interactions.
Write, optimize, and maintain complex SQL queries, stored procedures, and triggers in PostgreSQL, MySQL, or SQL Server.
Work with large-scale datasets, ensuring efficient data processing, ETL pipelines, and query performance tuning.
Develop and maintain APIs, microservices, and backend services using Django, Flask, or FastAPI.
Implement data modeling, indexing strategies, and query optimization for enhanced performance.
Automate database interactions and data processing using Python scripts.
Collaborate with Data Engineers, DevOps, and Software Engineers to build scalable applications.
Ensure data security, integrity, and compliance with industry best practices.
Utilize ORM frameworks like SQLAlchemy or Django ORM for database interactions.
Work with cloud-based database solutions on AWS (RDS, Redshift), Azure (SQL Database), or GCP (BigQuery, Cloud SQL).
Develop CI/CD pipelines for automated database migrations, testing, and deployments.
Required Skills & Experience:
✅ 5+ years of experience in Python development (Django, Flask, FastAPI).
✅ Strong SQL skills (PostgreSQL, MySQL, SQL Server, or Oracle).
✅ Experience with query optimization, performance tuning, indexing, and stored procedures.
✅ Hands-on experience with database design, normalization, and schema management.
✅ Experience with ETL pipelines and data integration using Python.
✅ Knowledge of NoSQL databases (MongoDB, Redis, or Cassandra) is a plus.
✅ Familiarity with Docker, Kubernetes, and cloud databases (AWS, Azure, GCP).
✅ Strong understanding of data security, access control, and database scaling strategies.