Software Development Specialist

Role Description

We are looking for a seasoned Senior SQL Developer to join our data engineering team. In this role, you will serve as a subject matter expert in relational database design, development, and optimization - driving best practices across the organization and mentoring junior developers. You will work closely with data architects, analysts, and business stakeholders to deliver robust, scalable, and high-performance data solutions.

Key Responsibilities

• Design, develop, and maintain complex SQL queries, stored procedures, functions, triggers, and views across large-scale relational databases.
• Perform deep-dive query performance tuning using execution plans, indexing strategies, query rewrites, and statistics analysis.
• Identify and resolve bottlenecks, long-running queries, and resource-intensive operations in production environments.
• Establish and enforce SQL coding standards, naming conventions, and best practices across the team.
• Lead the logical and physical design of database schemas, including normalization, partitioning strategies, and data modeling.
• Develop and maintain complex reports, dashboards, and data extracts for business intelligence and operational needs.
• Monitor database health, performance metrics, and capacity planning to proactively address issues before they impact operations.
• Manage database backups, recovery procedures, and ensure compliance with data retention policies.
• Handle schema migrations, database upgrades, and patch deployments with minimal downtime.
• Implement and maintain database security, including role-based access control and data masking where required.

Qualifications

• 10 years of hands-on experience writing and optimizing complex SQL in production environments.
• Deep expertise in at least one enterprise RDBMS platform - Microsoft SQL Server or Oracle (proficiency in both is a strong plus).
• Advanced knowledge of indexing strategies (clustered, non-clustered, covering indexes, columnstore), execution plan analysis, and query optimizer behavior.
• Proven experience with stored procedures, CTEs, window functions, dynamic SQL, cursors, and advanced T-SQL / PL-SQL constructs.
• Strong understanding of database design principles - normalization, referential integrity, partitioning, and data modeling (ER diagrams).
• Experience with ETL tools and data pipeline development (SSIS, Informatica, dbt, or equivalent).
• Familiarity with high-availability and disaster recovery configurations (Always On, RAC, mirroring, log shipping).
• Solid understanding of ACID properties, transaction management, and concurrency control.