SQL Developer Job Listing at Applied FP Holdings, LLC in Shawnee, KS (Job ID 59015)

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 

As the world's largest fluid power distributor, the Applied Fluid Power® network of companies provide dedicated fluid power support and custom designed solutions that meet customer performance goals and keep industry running. Capabilities include system integration, manifold design, machining and assembly, electronic controls, fabrication, fluid filtration, programming, high speed hose assembly, engineering, repair services, and more. Additionally, Applied Fluid Power® has one of the largest teams of Certified Fluid Power Specialists, Certified Electronic Control Specialists and Certified Fluid Power Mechanics to assist with problem solving, system building, troubleshooting, and other custom requirements.

Applied Fluid Power® is a part of Applied Industrial Technologies (NYSE: AIT), 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 hiring@applied.com or call 216-426-4389 to let us know the nature of your request.