Applications System Administrator SQL/Database

A. JOB PURPOSE:

• This position will support to develop and maintain MS SQL Databases and Integration service within De Heus applications as well as support to manage and ensure that all databases are highly available, with proper backup & recovery strategy.

B. ACCOUNTABILITIES:

1. System Planning & Implementation (30%)

• Database Design and Modelling: ASAs are responsible for designing and structuring databases to meet the needs of the organization. They create logical and physical database models to support the data requirements of applications.
• Installation and Configuration: ASAs install and configure database servers and software. They ensure that the database environment is set up correctly and performs optimally.
• Capacity Planning: ASAs plan for future growth of the database. This includes estimating the resources required and scaling the database environment as needed.
• Update and Patch Management: ASAs apply updates and patches to database software to address security vulnerabilities and improve functionality.

2. System Monitoring and Maintenance (40%)

• Performance Tuning: ASAs monitor and optimize the performance of the database. This includes tuning SQL queries, adjusting indexes, and configuring database parameters for optimal efficiency.
• Security Management: ASAs are tasked with ensuring the security of the database. This involves managing user access, implementing security measures, and auditing database activities.
• Backup and Recovery: ASAs implement backup strategies to prevent data loss. They also ensure that recovery procedures are in place and tested regularly to handle data restoration in case of failures.
• Data Integrity: ASAs enforce data integrity rules to ensure the accuracy and consistency of data stored in the database.

3. Troubleshooting and Support (20%)

• ASAs provide support for database-related issues. They troubleshoot problems and work to resolve them in a timely manner.

4. Documentation and Reporting (10%)

• ASAs maintain documentation related to database configurations, procedures, and policies. They also generate reports on database usage and performance.

C. RESULTS:

• By addressing these key elements, organizations can effectively plan, design, and implement new systems and applications, ensuring a successful deployment that meets the business requirements, integrates seamlessly with the existing IT Applications, and provides a reliable and scalable solution for the long term.
• By addressing these key elements, organizations can establish a robust and effective system monitoring and maintenance strategy, ensuring the ongoing reliability, security, and optimization of their IT Applications
• By addressing these key elements, organizations can develop a robust and efficient troubleshooting and support framework, ensuring timely and effective resolution of user issues, reducing system downtime, and improving overall customer satisfaction.
• By addressing these key elements, organizations can establish a robust and well-structured documentation and reporting framework, ensuring the availability of accurate, up-to-date, and accessible information to support informed decision-making, regulatory compliance, and continuous improvement of IT operations.

QUALIFICATIONS:

• Bachelor / Engineer of IT or Data Science/ Computer Science or equivalent degree

EXPERIENCES:

• Minimum 4 Years of relevant experience

COMPETENCIES:

1. Cloud Application Development:

• Develop cloud applications using Azure services such as Azure SQL Database, Azure Web Apps, and Azure Virtual Machines.
• Optimize cloud resources for performance and cost-effectiveness.

2. Security and Compliance:

• Maintain cloud security by adhering to best practices and compliance standards.
• Monitor and address security vulnerabilities.

3. Automation and Collaboration: (optional)

• Streamline development, testing, and deployment processes using Azure DevOps tools (Azure Boards, Azure Repos, Azure Pipelines, and Azure Test Plans).
• Collaborate with other developers, DevOps engineers, and IT specialists.

4. Programming Languages and Tools:

• Proficiency in multiple programming languages commonly used in cloud development.
• Familiarity with scripting languages like PowerShell, Python, and Perl.

5. Power Platform:

• Develop low-code/no-code solutions using Power Apps, Power Automate (Flow), and Power BI.
• Integrate Power Platform components with Azure services for streamlined workflows and data visualization.

*** Have experience with Azure Fabric/Databrick is an advantage

• Annual Health Check, Year End Party: once per year
• Company Trip, Team Building, Family Day: twice per year
• Health Insurance (Generali care 24/24 Insurance)
• Birthday Gift, Staff Gift
• Free parking batch