Database Installation and Configuration
- Install and configure SQL Server instances, including both on-premises and cloud-based deployments.
- Configure SQL Server settings and parameters to optimize performance and align with organizational requirements.
Database Maintenance and Management
- Perform regular database backups and restores to ensure data integrity and availability.
- Monitor and maintain database performance, including indexing, query optimization, and performance tuning.
Disaster Recovery and High Availability
- Develop and implement disaster recovery plans to ensure business continuity in the event of system failures or data loss.
- Test and validate disaster recovery procedures to ensure they are effective and up-to-date.
- Manage high-availability solutions and ensure they are functioning correctly to minimize downtime.
Backup and Restore Operations
- Design and implement backup strategies, including full, differential, and transaction log backups.
- Monitor and verify the success of backup operations and address any issues promptly.
- Perform database restores and recovery operations as needed to address data loss or corruption.
Network Design and Implementation
- Design and implement network architectures, including LAN, WAN, and VPN solutions, to meet organizational requirements.
- Configure network devices such as routers, switches, firewalls, and access points.
User Support and Troubleshooting
- Provide technical support for network-related issues to end-users and other IT staff.
- Assist in configuring and troubleshooting network connections for devices such as computers, printers, and mobile devices.
- Educate users on best practices for network usage and security.
Collaboration and Coordination
- Collaborate with other IT teams, vendors, and service providers to support network-related projects and initiatives.
- Coordinate with external parties for network troubleshooting and service issues as needed.
ERP System Administration
- Manage and maintain the ERP system’s SQL Server database, including installation, configuration, and upgrades.
- Monitor ERP system performance and troubleshoot issues related to SQL database.
- Assist users in understanding and utilizing ERP system functionalities related to database operations.
- Work closely with ERP system administrators, developers, and other IT professionals to support system upgrades and enhancements.
Exchange Server Installation and Configuration
- Install, configure, and deploy Microsoft Exchange Server, including Exchange Online and on-premises versions.
- Create, modify, and delete user mailboxes and manage mailbox permissions and access.
- Provide support for email-related issues, including troubleshooting and resolving problems with mail delivery, mailbox access, and user connectivity.
Hardware and Software Management
- Oversee the installation, maintenance, and troubleshooting of software and physical hardware, including servers, desktops, laptops, printers, and networking equipment.
- Perform regular hardware and software upgrades
- Manage inventory, including procurement, asset tracking, and lifecycle management.