
Overview
Role: SQL Developer
Experience: 5+ years
Location: Remote
Company URL: https://crossasyst.com
Company Description: CrossAsyst redefines the way companies experience and benefit from technology. Our delivery model is infused with a distinct culture of high customer satisfaction. We deliver trusted partnership, cost reductions and business results by driving technology innovation for better and faster outcomes.
Job Description: We are seeking an experienced SQL Developer with over 5 years of hands-on experience in SQL development and a strong background in Oracle PL/SQL. The ideal candidate will possess a solid understanding of SQL standards, database optimization techniques, and be familiar with database migration processes and performance tuning.
Key Responsibilities:
- Design, develop, and optimize complex SQL queries, stored procedures, functions, and triggers • Work extensively with Oracle PL/SQL to support application development and database processes
- Apply ANSI SQL standards to ensure cross-database compatibility and maintainability
- Participate in database migration projects, including migration to column-store databases • Analyze and improve existing queries for better performance and scalability
- Collaborate with application developers, data architects, and business analysts to support data-related requirements
- Troubleshoot and resolve database-related issues, performance bottlenecks, and query optimization tasks
- Maintain strong documentation of SQL code, procedures, and data transformation logic
Required Skills and Experience:
- 5+ years of experience in SQL development
- Strong hands-on experience with Oracle PL/SQL
- Solid understanding and working knowledge of ANSI SQL
- Experience with database migrations or column-store databases
- Exposure to performance tuning and query optimization techniques is a plus
- Knowledge of database engine execution and internal architecture is a plus