Company:
PamTen Inc
Location: Duluth
Closing Date: 30/11/2024
Hours: Full Time
Type: Permanent
Job Requirements / Description
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.
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.
Share this job