Data Developer

mTrade•Oxford, MS

About The Position

The Data Developer is responsible for designing, developing, and optimizing SQL Server databases and related applications. The primary focus will be writing efficient SQL queries, creating database structures, and building functionalities that meet the requirements of the company's applications while meeting performance and security standards. This is a Level III position.

Requirements

10+ years of experience in data development.
Expertise in database design, optimization, and performance tuning.
Experience in data modeling.
Experience in ETL development.

Responsibilities

Design the database schema, defining tables, relationships, and constraints to ensure data integrity.
Write efficient SQL queries for data retrieval, manipulation, and reporting, ensuring optimization for performance and maintainability.
Create stored procedures, user-defined functions, and triggers to encapsulate business logic within the database.
Identify and create appropriate indexes to improve query performance and analyze query execution plans to optimize queries.
Perform data migration between different systems or integrate data from various sources into the SQL Server database using Extract, Transform, Load (ETL) processes.
Collaborate with application developers to integrate database functionality seamlessly into applications.
Implement security measures to protect sensitive data and control database access.
Validate and cleanse data to maintain data accuracy and consistency.
Identify and resolve database-related issues, such as data inconsistencies, performance bottlenecks, or application errors tied to database interactions.
Use version control systems to manage database scripts and participate in the deployment process.
Monitor database performance and identify potential areas for improvement.
Maintain comprehensive documentation of database designs, schemas, and queries.