SQL Developer (Broking/Trading Domain) SMC Group

About SMC Group

Job Description

Job Summary: We are looking for a detail-oriented and data-savvy Database Analyst / SQL Developer with hands-on experience in Oracle and SQL Server. The ideal candidate should have a strong understanding of database structures and be proficient in writing and optimizing SQL queries, procedures, and scheduled jobs. A good grasp of data relationships and query logic is essential. Key Responsibilities: Develop, test, and maintain SQL queries, stored procedures, functions, and views in Oracle and SQL Server. * Read from and write to database tables for business logic processing and reporting. * Design and optimize joins, subqueries, and complex data retrieval logic. * Analyze existing database structures and recommend optimizations. * Support data quality and integrity across systems. * Create and maintain scheduled jobs, ETL processes, or data pipelines. * Work with application developers to support backend data needs. * Troubleshoot database issues and performance bottlenecks. Required Skills: Proficiency in Oracle PL/SQL and T-SQL (SQL Server). * Strong knowledge of joins, subqueries, and data manipulation. * Ability to understand and work with stored procedures, functions, triggers, and scheduled jobs. * Experience in reading and interpreting relational database models. * Understanding of indexes, constraints, and basic normalization. * Familiarity with data profiling and basic data modeling concepts. Preferred: Knowledge of data migration, ETL tools, or SSIS/Oracle Data Integrator. * Familiarity with cloud databases (e.g., Azure SQL, Oracle Cloud). * Experience with reporting tools or writing queries for dashboards. Soft Skills: Strong analytical and problem-solving mindset. * Ability to communicate effectively with business and technical teams. * Self-motivated and able to work independently or in a team.,