The database role
Database programming refers primarily to writing programming code in SQL – either writing queries or creating views, functions, or stored procedures. Companies looking for database programmers usually post SQL jobs, which require candidates to be proficient in standard SQL and, preferably, one or more dialects (e.g., SQL Server, PostgreSQL, etc.).
- Perform regular database maintenance tasks such as backups, recovery, and optimization.
- Monitor database performance and ensure its reliability and efficiency.
- Manage user access and permissions to databases, ensuring data integrity and confidentiality.
- Conduct regular testing of backup and recovery procedures.
- Develop and maintain backup and recovery strategies to minimize data loss in case of failures or disasters.
- Identify and resolve performance bottlenecks in the database systems.
- Optimize queries and database performance for optimal speed and efficiency.
Network, system and security role
- Design, implement, and maintain network infrastructure, including routers, switches, firewalls, and wireless access points.
- Monitor network performance and security, identifying and addressing issues promptly.
- Implement network security measures to protect against unauthorized access and data breaches.
- Administer, configure, and maintain server hardware and operating systems (e.g., Windows Server, Linux).
- Familiar with virtualization technologies (e.g., VMware, Hyper-V).
- Perform regular server updates, patches, and security hardening.
- Manage user accounts, permissions, and access controls.
- Conduct routine system backups and implement disaster recovery plans.
- Ensure high availability and uptime for critical systems.
- Implement and enforce security policies, including antivirus, firewall, and intrusion detection systems.
The helpdesk role
- Check system and shared server on a daily basis.
- Prepare, install and re-install workstation on a frequently basis.
- Maintain company's security cameras a frequently basis.
- Troubleshoot system on a daily basis.
- Develop and search for new applications on internet and in market on a periodical basis.
- Create user accounts for new employees and administrate them accordingly.
- Stock printers, cartages, flashes, computers, PC accessories. Give to employees upon request after approval of direct line of authority.
- Extends help to other employees found overloaded whenever deemed necessary by his/her superior