The Job
As a Senior Database Developer for Epicor Finance Processing & Accounting, your role is crucial in extending the data platform and contributing to the improvements in the DB development and management processes. As a key team member, you'll collaborate with cross-functional experts to decipher and address diverse database requirements.
What you will be doing:
- Design and implement robust database solutions to meet the needs of Epicor FP&A service.
- Ensure the scalability, performance, and reliability of database systems.
- Write and optimize T-SQL code, stored procedures (SP), and ETL processes.
- Ensure adherence to best practices in database development.
- Defines data repository requirements, data dictionaries, and warehousing requirements.
- Improves database performance and capacity, and plans for future expansion requirements.
- Adapts business requirements and develops the data, database specifications, and table and element attributes for an application.
What you will likely bring:
- 5+ years of production experience with Microsoft SQL Server, having in-depth knowledge of SQL Server features and functionalities.
- Proficiency in Transact-SQL programming, optimization, and performance tuning.
- Understanding of bookkeeping and financials to tailor database solutions to meet financial service requirements.
- Proficient troubleshooting abilities to ensure the stability of the database environment.
- Relational database design skills.
- Advanced SQL query writing skills.
What could set you apart:
- Experience with RedGate SQL Toolbelt for efficient database development and management.
- Knowledge and experience with Microsoft Azure, especially in the context of database solutions.
- Specialized/industry experience or familiarity with ERP systems.