SQL Database Engineer / DBA

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.