SQL Developer: coding business logic into SQL, performance tuning, optimization; financial exp a + (debits / credits / etc.)

KORE1
Buenapark, CA
20 May 2024

Vacancy expired!

THIS ROLE REQUIRES PARTIAL ONSITE IN BUENA PARK, CA. KORE1, a nationwide provider of staffing and recruiting solutions, has an immediate opening for a

SQL Developer: coding business logic into SQL, performance tuning, optimization; financial knowledge a + (debits / credits / journal entries, etc.) The SQL Server Database Developer creates solutions for a variety of business problems. Develops the plan to design solutions, code, and test modifications and enhancements to the existing systems with a high level of reliability and execution speed. Provides assistance to the user during the implementation of the system or the modified solutions. Knowledge of Financial and Accounting business processes strongly preferred

Primary Duties & Responsibilities:

  • Role is primarily charged w/ troubleshooting and optimizing SQL code to include data modeling to fix business logic AND reporting issues (in a custom-built ERP where we do accounting / financial functions like debits & credits for order processing, journal entries, AR balance, GL, etc.)
  • Create stored procedures and functions
  • Develop and design database objects, such as tables, indexes, constraints, etc.
  • Perform performance tuning of queries
  • Create complex queries on large data sets
  • Analyze query execution plans and optimize database code
  • Generate code to extract, transform and load data
  • Research and develop new ways to improve existing functionality
  • Maintain and review daily, monthly and yearly for financial and accounting issues and reporting
  • Provide support for internal and external audits
  • Participate in Ad Hoc reporting requests
  • Will NOT contribute to ETL or DW development
  • Will NOT function as a DBA

Requirements - Knowledge and Skills:
  • Bachelor's degree in Computer Science or related field from an accredited university and/or equivalent work experience

  • 3-8+ years of SQL development experience that includes:
    • Experience and strong knowledge of SQL Server Fundamentals.

    • Knowledge of best practices when dealing with relational databases (experience with database design, performance tuning, query optimization, indexes, data migration tools, and data analysis)

    • T-SQL; writing complex queries, stored procedures, and functions

    • Strong SQL performance tuning & optimization

    • Thorough understanding / solid experience with database / data modeling

    • Must be able to code business logic into SQL

    • Previous DBA skills is a plus.

    • Experience w/ accounting / finance operations such as order processing debits / credits, posting journal entries, GL, AR balance, etc, is very helpful.
  • Demonstrate personal initiative
  • Ability to work on multiple tasks simultaneously
  • Excellent verbal and written communication skills
  • Strong organizational skills and attention to detail
  • Ability to work well in a fast-paced environment
  • Industry experience in financial services and accounting strongly preferred
The salary for this role is between $110-130K plus bonus depending on experience. #LI-JB1 ABOUT KORE1Specializing in professional and technical recruiting, KORE1 is committed to supporting top IT, Engineering, Creative, Scientific, Accounting and Finance professionals in their career paths. We build deep relationships with leading companies, connecting them to exceptional talent every day. With extensive industry expertise and unmatched opportunities, our goal is to provide a unique experience for our contractors and consultants as they prepare for their next role. We are passionate about matching the right people with the right companies.

Kore1 provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics. In addition to federal law requirements, Kore1 complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training. Kore1 expressly prohibits any form of workplace harassment based on race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, genetic information, disability, or veteran status. Improper interference with the ability of Kore1's employees to perform their job duties may result in discipline up to and including discharge.
  • ID: #49969793
  • State: California Buenapark 90620 Buenapark USA
  • City: Buenapark
  • Salary: $100,000 - $130,000
  • Job type: Permanent
  • Showed: 2023-05-20
  • Deadline: 2023-07-18
  • Category: Accounting/finance