Vacancy expired!
- If selected, there might be a background check that includes a drug screen (usually 4-panel-excluding marijuana) and sometimes credit checks for financial clients.
- Most companies might also have a vaccine mandate, so once hired, we (or the client) will ask for proof of vaccination if required. If you are not vaccinated, we/they might ask you to work with them on a religious or medical exemption if necessary.
- NOT open to Corp to Corp.
- Those authorized to work in the US are encouraged to apply.
- DKKD Staffing does not sponsor and cannot support H1, TN, etc. No outside agencies please.
- Design and maintenance of databases and data warehouses solutions using Microsoft technologies that include SQL, SSRS, SSIS, and SSAS (both OLAP and Tabular models)
- Development and maintenance of complex optimized queries, views, functions, and stored procedures using T-SQL
- Database development using RDBMS standard practices and principles including star schemas, ERD’s, primary/surrogate keys, and indexes
- Conducts analysis, design, evaluation, modification, testing and implementation of enterprise-wide systems (e.g., Infor XA, Dynamics AX, IFS, Baan, Costpoint) across functional areas
- Responsible for software integration, external interface development and technical documentation
- Plans and directs the evaluation of potential third-party applications and prepares design proposals to reflect cost, time and alternative actions to satisfy existing and future needs of the Corporation
- Supports BI and Document Management applications integrated to ERP systems and SQL databases (Power BI, Targit, Tab Fusion or similar experience)
- Develops test plans and protocols for evaluation of system performance
- Conducts analysis of systems specifications and uses the latest analysis/diagramming tools to represent business/technical processes
- Develops conversion and system implementation plans
- Prepares and obtains approval of system and programming documentation
- Recommends changes in development, maintenance and system standards
- Coordinates system upgrade activity
- Trains user personnel in the conversion and implementation of the system
- General Support – The position will have support responsibilities specific to the supported applications. Support will require troubleshooting and problem resolution related to user and connectivity issues.
- Responds to emergencies as needed
- Daily availability to include evenings and weekends when necessary to reach goals and deadlines.
- Strong interpersonal skills:
- Strong oral and written communication abilities with all levels of management, employees, and customers, ability to communicate and explain information efficiently:
- Ability to add, subtract, multiply, and divide in all units of measure, using whole numbers, common fractions, and decimals:
- Ability to develop solutions to problems of unusual complexity which require a high degree of ingenuity, creativity, and innovativeness. Challenges are frequently unique and solutions may serve as precedent for future decisions:
- Follows all import/export requirements, consulting with facility import/export personnel as required:
- Basic Knowledge of ISO and/or AS9100:
- Working knowledge of Lean Manufacturing/6 Sigma/Kaizen:
- Knowledge of specific software (design, analysis, ERP…):
- Name:
- Best Contact Info:
- Your Linked In:
- Where do you live and your desired geographical location:
- Why looking for a new job:
- Availability for interviews and a new job:
- Willing to work 100% on-site or hybrid:
- Are you open to relocation if required:
- Do you have an active passport if needed for the job:
- Are you open to travel if needed:
- Are you authorized to work in the US (Please indicate US, , or Other):
- If not or do you require sponsorship at any time, or will you in the future?
- Salary Expectations: (We need a range) $
- Sizes of staff overseen and their titles: (include # of direct reports)
- Budgetary Responsibility: $
- Education/Certs/Degrees: (also indicate which certs are active – Bachelor’s degree (B.S.) from four-year college or university in a related field and 3-5 years of directly related experience and/or training; or equivalent combination of education and experience required)
- Who Referred You/ How Did You Hear About Job/ DKKD Staffing:
- Experience and/or the title of ERP SQL Systems Programmer/ Data Analyst – AX:
- Basic Knowledge of ISO and/or AS9100:
- Working knowledge of Lean Manufacturing/6 Sigma/Kaizen:
- Knowledge of specific software (design, analysis, ERP…):
- Advanced knowledge and in-depth experience with the following applicable system:
- Microsoft SQL Stack:
- MS SQL Server with strong T-SQL experience:
- SSRS/SSIS/SSAS:
- Database design and performance optimization:
- Complex queries, views, functions, and stored procedures:
- Dynamics AX:
- Programming methodologies, structures, and concepts – .Net framework, UML, XML, SharePoint, BizTalk:
- Object oriented development languages (e.g., X, C, C#, VB.NET, Java, .NET framework):
- AIF (Application Integration Framework), BOF (Business Operation Framework), TFS (Team Foundation Sever), and SSRS (SQL Server Reporting Services):
- Dynamics AX Trace Parser:
- Diagnosis of X code tracing with performance analysis outcomes and recommendations:
- Database design and SQL (Query Language):
- Experience integrating ISV solutions:
- Functional application knowledge:
- IFS:
- Familiar with ERP software/IFS applications in general:
- Applicable business process, SDLC:
- IFS Programming methodologies, structures, and concepts – .Net framework, UML, XML, BizTalk:
- Object-Oriented Design principles:
- Relational database, Oracle Database:
- IFS Foundation1 Administration such as Users, Security, Profile, Custom Objects, and Events:
- Quick Report, IFS Development Studio, IFS Report Designer Development and SSRS:
- Strong SQL and PL/SQL languages:
- Strong Crystal Report:
- Microsoft Office Suite (i.e., Outlook, Word, Access, Excel, PowerPoint, Project, Visio, etc.):
- Support ticketing systems, change control methodologies and their importance to ITIL best practices:
- IT security concepts and best practices (e.g., Microsoft, Cisco, etc.):
- Microsoft SQL Stack:
- ID: #42393201
- State: California Thousandoaks 90245 Thousandoaks USA
- City: Thousandoaks
- Salary: Depends on Experience
- Job type: Permanent
- Showed: 2022-06-04
- Deadline: 2022-08-02
- Category: Security