SQL Developer

Tentek - Torrance, CA

Full-time - Mid Level

Torrance, CA

Professional, Scientific, and Technical Services

About the position

The SQL Developer role at TenTek involves designing and optimizing data operations, maintaining database performance, and supporting application development for multiple large projects. The position requires a strong understanding of business intelligence needs and the ability to create complex SQL queries, troubleshoot production issues, and deliver comprehensive documentation.

Responsibilities

• Design and streamline data operations and maintain the database for peak performance.
• Understand business strategy and translate business intelligence needs to the database level.
• Design database tables based on transactional and analytical requirements.
• Create complex SQL queries.
• Troubleshoot production issues affecting database performance and investigate data issues.
• Create, maintain, and deploy SSIS packages.
• Provide application development and production support for multiple large projects.
• Research and resolve production issues, including troubleshooting of Mid-Tier MS SQL Server online and batch abends.
• Evaluate daily and monthly batch processes to improve performance and shorten critical path windows.
• Perform impact analysis across multiple platforms and applications.
• Deliver complete documentation for estimates, design, and development.
• Be on-call for production support during off-office hours, including nights and weekends if required.
• Create and execute SQL statements and perform complex data analysis.
• Create, modify, and deploy SQL Server code/packages, including SSIS and stored procedures, while handling error conditions.

Requirements

• BA/BS in Information Technology, Computer Science, or a related field, or equivalent work experience.
• 5+ years of experience as a SQL Developer.
• Proficient with columnar databases and distributed SQL query engines.
• Database development experience using T-SQL, including creating and updating stored procedures, SQL functions, and triggers.
• Experience working with SQL XML on SQL Server 2019 or higher.
• Experience working on SQL Server 2019 or higher.
• Demonstrated experience in troubleshooting and resolving database problems.
• Experience with the full software development lifecycle and delivery using Agile methodologies.
• Strong data analytical skills and ability to analyze large datasets.
• Advanced ability to utilize SQL traces and debugging tools for problem resolution.
• Advanced ability to analyze and model business functions, processes, and information flow within or between systems.
• Hands-on experience working with SQL XML on SQL Server 2008 R2 or higher.
• Hands-on experience creating, updating, and deploying SSIS packages.
• Excellent analytical skills to understand requirements and design appropriate database schemas.