Applied Industrial Technologies
Location
Lenexa, KS | United States
Job description
This role directly interfaces with end users and requires both strong communication skills and a strong commitment to UAT and functional testing. The SQL Developer will work with other developers and business team members in developing and supporting important applications. Developer will be responsible for ongoing development projects and supporting legacy applications. We would prefer to have this person based in Kansas City, MO, however would consider Columbus or Cleveland, OH and St Louis, MO.
Duties will include:
- Attend business requirement discussion meetings, understand and analyze the requirements, confirm functional specification notes/documents before proceeding with the design and development.
- Learn existing critical business application business logic and stored procedures used by the Analytics team. Make code changes in the stored procedures to implement new changes and resolve defects.
- Ability to analyze and troubleshoot existing code to identify root causes of failures and to ensure functionality
- Design, Develop and Deploy SSIS Packages.
- Development of ETL, Reporting and Multidimensional Analytical Cube using Microsoft Business Intelligence (SSIS, SSRS, SSAS) data tools.
- Deliver functional work product that has been thoroughly tested from both unit and functional testing perspectives.
- Follow development team’s SDLC process. Accurately estimate time required to complete projects and tasks.
- Meet mutually agreed upon deadlines for completion of modules throughout the program development.
- Following best practices, design and develop Microsoft SSRS reports using latest version of Visual Studio and TFS.
- Identify and write best possible code in case of new deployments or when rewriting code when migrating to newer version of SQL Server. Plan and coordinate data migrations between systems.
- Develop, implement, and maintain change controls for modifications to databases.
- Create required reports in response to business user needs.
- Establish appropriate database access control levels.
Position Requirements
- Bachelor’s degree in computer science or 5 years of related experience in one of the following: application development, database administration, SQL programming, or technical support.
- Ability to analyze and troubleshoot existing code to identify root causes of failures and to ensure functionality.
- MS SQL Server 2016 and above
- Hands-on experience with database standards and end user applications.
- Excellent knowledge of data backup, recovery, security, integrity and SQL
- Experience with Rest API, SDLC, and Visual Studio is a plus
- Advanced knowledge and understanding of SQL Job Agents and Stored Procedures
- Works well independently; capable of self-motivating and managing.
- Good written and oral communication skills.
- Strong technical documentation skills.
- Communicates well with technical and non-technical co-workers alike.
- Ability to present ideas in user-friendly language.
- Highly self-motivated and directed.
- Keen attention to detail.
- Proven analytical and problem-solving abilities.
- Desire to work in a team environment.
- Experience with Rest API, SDLC, and Visual Studio is a plus
- ERP experience a plus specifically Epicor Prophet 21
DBA items….
- Software installation and Maintenance
- Data Extraction, Transformation, and Loading
- Database Backup and Recovery
- Security
- Authentication
- Capacity Planning
- Performance Monitoring
- Database Tuning
- Troubleshooting
FCX Performance, an Applied Industrial Technologies Company, is a leading process flow control company providing technical mission critical products and services to more than 15,000 end users, OEMs, and EPC firms across a broad range of industries and markets.
Founded in 1923, Applied Industrial Technologies (NYSE: AIT) is a leading value-added distributor and technical solutions provider of industrial motion, fluid power, flow control, automation technologies, and related maintenance supplies. Our leading brands, specialized services, and comprehensive knowledge serve MRO and OEM end users in virtually all industrial markets through our multi-channel capabilities that provide choice, convenience, and expertise.
We are an equal employment opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, national origin, ancestry, gender, sexual orientation, gender identity, age, disability, protected veteran status, marital status, medical condition or any other characteristic protected by law.
If you need accommodation for any part of the employment process because of a disability, please send an email to [email protected] or call 216-426-4389to let us know the nature of your request.
Job tags
Salary
