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 TWO Sr. SQL Developers: troubleshooting, performance tuning, data modeling, SSRS for accounting / finance operations/reports required. 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. Experience with SQL Server SSRS required. Knowledge of Financial and Accounting strongly preferred
Primary Duties & Responsibilities: Role is primarily charged w/ troubleshooting and optimizing SQL code to include data modeling to fix reporting issues (in a custom-built web application and/or SSRS). This application does financial / accounting reporting functions. (For example: balance statements, income statements, double (journal) entries, snapshot reporting, AP, AP, GL, etc.)Create stored procedures and functionsDevelop and design database objects, such as tables, indexes, constraints, etc.Perform performance tuning of queriesCreate complex queries on large data setsAnalyze query execution plans and optimize database codeGenerate code to extract, transform and load data Research and develop new ways to improve existing functionalityMaintain and review daily, monthly and yearly for financial and accounting issues and reportingProvide support for internal and external auditsParticipate in Ad Hoc reporting requestsWill NOT contribute to ETL or DW developmentWill 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 experience5-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 functionsStrong SQL performance tuning & optimizationThorough understanding / solid experience with database / data modelingSSRS experienceExperience w/ accounting / finance operations, reporting, etc. (Knows the difference between a balance & income statement for example) Demonstrate personal initiativeAbility to work on multiple tasks simultaneouslyExcellent verbal and written communication skillsStrong organizational skills and attention to detailAbility to work well in a fast-paced environmentIndustry experience in financial services and accounting strongly preferred The salary for this role is between $120-150K plus bonus depending on experience. #JBU ABOUT KORE1 Specializing 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: #49817169
- State: California Buenapark 90620 Buenapark USA
- City: Buenapark
- Salary: $100,000 - $150,000 /yr
- Job type: Permanent
- Showed: 2023-04-28
- Deadline: 2023-06-26
- Category: Et cetera