MTK Technologies Inc
Overview
Database Developer role at MTK Technologies. Responsibilities
Design schemas, write complex queries, perform aggregations, and optimize performance in MongoDB environments. Model NoSQL data using patterns and principles (document-oriented, key-value). Familiarity with other NoSQL databases and their use cases (e.g., Cassandra, DynamoDB, Redis) is a plus. Develop, debug, and optimize complex PL/SQL stored procedures, functions, triggers, and packages. Understand relational database concepts, including normalization, indexing, and referential integrity. Work with a major relational database system (e.g., Oracle, PostgreSQL, SQL Server). Data Platforms: Snowflake must have strong experience, including DDL/DML, stored procedures, UDFs, and performance optimization. Understand Snowflake architecture (compute, storage, cloud services) and features (Virtual Warehouses, Zero-Copy Clones, Time Travel, Streams, Tasks). Load/unload data into and out of Snowflake. Practical experience with Apache Iceberg for managing large data sets in open table formats. Understand Iceberg features such as schema evolution, hidden partitioning, time travel, and manifest files. Integrate Iceberg with query engines (e.g., Spark, Presto, Trino) or data lakes. Performance tuning: diagnose and resolve database performance issues across relational and NoSQL environments. Index tuning, partitioning strategies, and database configuration for optimal performance. Familiarity with database monitoring tools and techniques. Programming and scripting: Python is beneficial for database automation, scripting, data processing, and API integrations. Proficiency with Python libraries for database connectivity (e.g., psycopg2, pymongo, snowflake-connector-python). Design and migration of NoSQL MongoDB in financial domain. Work on PL/SQL queries development, fine-tuning, and migration. Design and development of cloud-based DWH using Snowflake. Implementation and rollout of on-prem and cloud-based application development projects. Work on fixing application issues and enhancement items. Mentor junior developers and identify opportunities for product improvements and best practices. Troubleshoot applications, perform root cause analysis, and address identified issues. Track project status, issues, risks, and updates with senior leadership. Seniority level
Mid-Senior level Employment type
Full-time Job function
Information Technology Industries
Information Services
#J-18808-Ljbffr
Database Developer role at MTK Technologies. Responsibilities
Design schemas, write complex queries, perform aggregations, and optimize performance in MongoDB environments. Model NoSQL data using patterns and principles (document-oriented, key-value). Familiarity with other NoSQL databases and their use cases (e.g., Cassandra, DynamoDB, Redis) is a plus. Develop, debug, and optimize complex PL/SQL stored procedures, functions, triggers, and packages. Understand relational database concepts, including normalization, indexing, and referential integrity. Work with a major relational database system (e.g., Oracle, PostgreSQL, SQL Server). Data Platforms: Snowflake must have strong experience, including DDL/DML, stored procedures, UDFs, and performance optimization. Understand Snowflake architecture (compute, storage, cloud services) and features (Virtual Warehouses, Zero-Copy Clones, Time Travel, Streams, Tasks). Load/unload data into and out of Snowflake. Practical experience with Apache Iceberg for managing large data sets in open table formats. Understand Iceberg features such as schema evolution, hidden partitioning, time travel, and manifest files. Integrate Iceberg with query engines (e.g., Spark, Presto, Trino) or data lakes. Performance tuning: diagnose and resolve database performance issues across relational and NoSQL environments. Index tuning, partitioning strategies, and database configuration for optimal performance. Familiarity with database monitoring tools and techniques. Programming and scripting: Python is beneficial for database automation, scripting, data processing, and API integrations. Proficiency with Python libraries for database connectivity (e.g., psycopg2, pymongo, snowflake-connector-python). Design and migration of NoSQL MongoDB in financial domain. Work on PL/SQL queries development, fine-tuning, and migration. Design and development of cloud-based DWH using Snowflake. Implementation and rollout of on-prem and cloud-based application development projects. Work on fixing application issues and enhancement items. Mentor junior developers and identify opportunities for product improvements and best practices. Troubleshoot applications, perform root cause analysis, and address identified issues. Track project status, issues, risks, and updates with senior leadership. Seniority level
Mid-Senior level Employment type
Full-time Job function
Information Technology Industries
Information Services
#J-18808-Ljbffr