Database Developer

Database Developer (SQL) – Performance Optimization Expert

Experience Required:

• 4–8 years of hands-on experience in database design, development, and optimization.
• Expertise in MS SQL Server (2016 or later) with deep knowledge of query performance tuning and execution plan analysis.
• Proven experience in large-scale, high-transaction financial or trading systems.
• Exposure to PostgreSQL, MySQL, or NoSQL databases (MongoDB, Redis) is a plus.

Roles & Responsibilities:

• Design, develop, and maintain high-performance database solutions for trading, risk management, and reporting systems.
• Analyze, troubleshoot, and optimize slow-performing queries, stored procedures, and database jobs.
• Implement indexing strategies, partitioning, and query plan analysis to enhance system speed and reliability.
• Collaborate with backend (.NET) developers to improve SQL integration and application performance.
• Design data models and schemas supporting scalability, normalization, and business logic consistency.
• Manage ETL processes, data migration, and integration between trading systems and external data sources.
• Ensure data accuracy, integrity, and compliance with financial and regulatory requirements.
• Monitor database performance metrics, perform tuning, and automate performance alerting.
• Implement backup, recovery, security, and disaster recovery strategies.
• Participate in code reviews and provide guidance on SQL best practices across teams.

Skills Required:

• Strong expertise in SQL Server (T-SQL) — query optimization, indexing, statistics, and locking mechanisms.
• Deep understanding of database internals (execution plans, deadlocks, tempdb usage, I/O tuning).
• Experience with performance monitoring tools such as SQL Profiler, Extended Events, Query Store, and DMVs.
• Database design & modeling (ER diagrams, normalization/denormalization, referential integrity).
• Hands-on experience in ETL tools (SSIS, Azure Data Factory, or similar).
• Knowledge of Azure SQL, PostgreSQL, or MySQL performance tuning concepts.
• Familiarity with data warehousing, replication, and high availability setups (Always On, Mirroring, Log Shipping).
• Exposure to Power BI, SSRS, or other reporting/analytics platforms.
• Experience working with trading, financial, or real-time data systems is highly preferred.

Preferred Qualifications:

• Bachelor’s degree in Computer Science, Information Technology, or related field.
• Microsoft certification (e.g., MCSE: Data Management and Analytics or Azure Database Administrator Associate) is a plus.
• Strong problem-solving skills with attention to detail and system performance.
• Ability to work in high-pressure environments with large data volumes and mission-critical systems.

Job Type: Full-time

Pay: AED5,000.00 - AED6,000.00 per month