Summary Responsible for developing and maintaining SQL databases; writing applications to interface with SQL databases; develop queries and procedures, create custom reports, and modify ERP user forms to enhance organizational productivity; designing tables, storing procedures, views and functions; ensuring data integrity through constraints, managing transactions, and implementing security measures like authentication and authorization. Essential Duties and Responsibilities include the following. Other duties may be assigned. SQL Development

• Design, develop, and maintain complex SQL queries, stored procedures, functions, and scripts.

• Optimize and troubleshoot SQL queries for performance and efficiency.

• Collaborate with business users to create database schemas and data structures that support application requirements.

  Database Administration

• Install, configure, and upgrade SQL Server instances and related software.

• Monitor database performance, implement changes, and apply new patches and versions when required.

• Perform database tuning and optimization, manage backup and recovery processes.

• Ensure data integrity, security, and availability of databases.

  API Integration

• Maintain APIs to facilitate communication between different software systems.

• Integrate external and internal APIs to streamline data exchange and business processes.

• Ensure APIs are secure, efficient, and scalable.

  Automation

• Identify opportunities for process automation within the database environment.

• Develop scripts and tools to automate routine database tasks, such as backups, indexing, and monitoring.

• Implement and manage ETL (Extract, Transform, Load) processes to automate data flow.

  Business Intelligence (BI)

• Utilize BI tools such as Qlik, Microsoft Power BI, Tableau, or similar to provide insights and data-driven decisions.

• Collaborate with stakeholders to understand BI requirements and translate them into technical solutions.

• Ensure the accuracy, completeness, and timeliness of BI reports.

  Documentation and Reporting

• Create and maintain detailed documentation of database designs, configurations, processes, and policies.

• Generate regular reports on database performance, usage, and issues.

  Collaboration and Support

• Work closely with other IT team members, developers, and stakeholders to ensure database systems meet business needs.

• Provide support and training to users and other IT staff on database-related issues and best practices.

  Additional Requirements/Skills

• Proven experience as a SQL Developer and DBA.

• Strong knowledge of SQL Server (or other RDBMS), T-SQL, and performance tuning.

• Experience with API development and integration.

• Proficiency in scripting languages such as PowerShell, Python for automation.

• Familiarity with ETL processes and tools.

• Strong problem-solving skills and attention to detail.

• Excellent communication and teamwork abilities.

• Ability to manage multiple tasks and projects simultaneously.

• Knowledge of database security best practices.

  Education and/or Experience Bachelor's degree in Computer Science, Information Technology or related field. 5+ years related experience and/or training or equivalent combination of education and experience. Relevant certifications (e.g., Microsoft Certified: Azure Database Administrator Associate) are a plus. Experience with cloud database services (e.g., Azure SQL Database, Fabric, Datalake). Familiarity with modern development methodologies and tools (e.g., Agile, DevOps, CI/CD). Knowledge of D365 F&O, ServiceTrade, Qlik.