Job Description

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