Fisher Auto Parts is seeking a Database Developer to focus on the hands-on development and optimization of the database backend for their suite of modern applications, translating application requirements into robust, efficient, and secure MySQL stored procedures and functions.
Requirements
- A Strong SQL Foundation: You must have a solid, demonstrable proficiency in SQL. You should be comfortable writing complex queries, creating stored procedures, and understanding functions. Direct professional experience with MySQL is a major plus.
- Grasp of Core Database Concepts: You have a good understanding of relational database design principles, such as normalization and the purpose of indexing.
- Experience with other database systems (e.g., IBM Db2 for i, SQL Server) is a plus.
- Familiarity with scripting languages like Python for automation tasks.
- Experience with version control systems like Git for managing database scripts.
- Exposure to BI tools (like Amazon QuickSight), data warehousing concepts, or ETL (Extract, Transform, Load) processes.
Responsibilities
- Design, develop, test, and implement complex MySQL stored procedures, functions, and triggers in accordance with application requirements and architectural standards.
- Collaborate directly with our team of C-Sharp, Python, and JavaScript developers to understand data needs and define database logic.
- Analyze and optimize existing SQL queries and stored procedures to improve application performance and scalability.
- Troubleshoot and resolve database-related issues identified during development, QA, and UAT cycles.
- Assist the Data Architect with data modeling and database schema design to ensure consistency and efficiency.
- Ensure data integrity and security standards are met within the database layer.
- Create and maintain clear documentation for database schemas, stored procedures, and related processes.
Other
- The employee in this position reports to the VP of Information Technology and does not supervise other employees.
- A High Aptitude for Learning: You are curious, technically inclined, and genuinely excited to learn.
- A Problem-Solver's Mindset: You have strong analytical skills and enjoy tackling complex problems.
- A Collaborative Spirit: You are a strong communicator who works well with others.
- High school diploma or GED equivalent