Database Developer

Tampa, FL - USA

Monthly Salary: Not Disclosed

Posted on: 30+ days ago

Vacancies: 1 Vacancy

Job Summary

Job Title: Database Developer (Python Scripting & Mongo DB)

Location: Tampa FL (onsite)

Job Type: Full time

Job Description

Database Development

Mandatory

Mandatory hands on experience with Python Scripting preferably on Data Migration scripts

Experience with Python for database automation scripting data processing and API integrations.

Familiarity with relevant Python libraries for database connectivity (e.g. psycopg2 pymongo snowflake-connector-python

Mandatory hands-on experience with MongoDB: Designing schemas writing complex queries performing aggregations and optimizing performance within MongoDB environments.

In case associate has not worked on MongoDB familiarity with similar NoSQL Document database (For example Apache CouchDB)

Understanding of NoSQL data modeling patterns and principles (e.g. document-oriented key-value).

PL/SQL Proficiency (Mandatory):

Extensive experience in developing debugging and optimizing complex stored procedures functions triggers and packages using PL/SQL.

Strong understanding of relational database concepts including normalization indexing and referential integrity.

Experience with a major relational database system (e.g. Oracle PostgreSQL SQL Server).

Performance Tuning (Must Have)

Proven ability to diagnose and resolve database performance issues across relational and NoSQL environments.

Expertise in query optimization (e.g. analyzing execution plans rewriting inefficient queries).

Experience with index tuning partitioning strategies and database configuration for optimal performance.

Familiarity with database monitoring tools and techniques.

Good to Have Skills

Data Platforms - Snowflake (Must Have):

Strong experience with Snowflake Data Cloud development including DDL/DML stored procedures UDFs and performance optimization within Snowflake.

Understanding of Snowflakes architecture (compute storage cloud services) and features (e.g. Virtual Warehouses Zero-Copy Clones Time Travel Streams Tasks).

Experience with data loading/unloading into and out of Snowflake.

Apache Iceberg (Preferred):

Practical experience with Apache Iceberg for managing large high-performance data sets in open table formats.

Understanding of Icebergs key features such as schema evolution hidden partitioning time travel and manifest files.

Experience integrating Iceberg with query engines (e.g. Spark Presto Trino) or data lakes.

Design and migration of No SQL Mongo DB in fi nancial domain

Work on PL-SQL queries development fine tuning and migration

Design and development of Cloud based DWH using Snowflake

Implementation and Roll-out of on prem and cloud-based application development projects

Work on fixing application issues and enhancement items

Mentoring junior developers in the team and identify opportunities for product improvements implementation of best practices et al.

Work on application troubleshooting perform root cause analysis as well as address identified issues

Track the project status issues risks and updates timely with senior leadership.

Job Title: Database Developer (Python Scripting & Mongo DB) Location: Tampa FL (onsite) Job Type: Full time Job Description Database Development Mandatory Mandatory hands on experience with Python Scripting preferably on Data Migration scripts Experience with Python for database...