Database Developer

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 Snowflake's 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 Iceberg's 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.