The Planet Group
https://cdn.haleymarketing.com/templates/63515/logos/square.png
http://www.theplanetgroup.com
http://www.theplanetgroup.com
true
Epicor Prophet 21 Database Administrator
Posted: 11/29/2023
2023-11-29
2023-12-30
Employment Type:
Contract To Hire
Job Category: ERP
Job Number: 581872
Country: United States
Is job remote?: No
Job Description
JOB DESCRIPTION
SQL Developer will work independently to learn, maintain, and enhance existing applications as well as develop new code to accomplish business needs for data analysis and automation. 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.
Duties will include:
Position Requirements
DBA items….
SQL Developer will work independently to learn, maintain, and enhance existing applications as well as develop new code to accomplish business needs for data analysis and automation. 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.
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
- Knowledge & Experience
- Hands-on experience with database standards and end user applications.
- Excellent knowledge of data backup, recovery, security, integrity and SQL
- Familiarity with Java, C#, MS SQL and .Net
- Experience with Rest API, SDLC, and Visual Studio is a plus
- Advanced knowledge and understanding of SQL Job Agents
- Advanced knowledge and understanding of 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.
- Motivated to serve clients, both internal and external.
DBA items….
- Software installation and Maintenance
- Data Extraction, Transformation, and Loading
- Database Backup and Recovery
- Security
- Authentication
- Capacity Planning
- Performance Monitoring
- Database Tuning
- Troubleshooting
Share This Job:
Related Jobs:
Login to save this search and get notified of similar positions.About Lenexa, KS
Join us in the vibrant job market around Lenexa, Kansas! This thriving area offers a perfect blend of career opportunities and quality of life. Located in the heart of Johnson County, Lenexa boasts a friendly community, excellent schools, and a variety of dining options ranging from BBQ joints to food trucks. Enjoy outdoor adventures at Shawnee Mission Park or catch a show at the Theatre in the Park. With close proximity to Kansas City's renowned art galleries, professional sports teams like the Kansas City Chiefs and Royals, and iconic venues like the historic Kauffman Center for the Performing Arts, Lenexa is the ideal place to grow your career while embracing a unique culture and irresistible charm. Explore our job listings today and discover the exciting possibilities this region has in store for you!