- Perform database backup and restore activities.
- Manage database users, roles, and permissions.
- Conduct database health checks and maintenance.
- Monitor and troubleshoot SQL Agent jobs.
- Perform basic performance analysis and optimization.
- Investigate and resolve database connectivity issues.
MySQL
- Monitor and manage replication environments.
- Troubleshoot replication-related issues.
- Perform backup and recovery operations.
- Handle user administration and access management.
- Support basic database performance tuning activities.
Azure Database Services (DBaaS)
- Manage Azure SQL Database.
- Manage Azure Database for MySQL.
- Manage Azure Database for PostgreSQL.
- Provision and configure cloud databases.
- Monitor database performance and utilization.
- Scale database resources based on business requirements.
- Implement basic database security and access controls.
Middleware Administration
IIS (Internet Information Services)
- Install, configure, and maintain IIS environments.
- Deploy websites and web applications.
- Manage application pools and IIS configurations.
- Install and renew SSL certificates.
- Analyze logs and troubleshoot web application issues.
Apache Web Server
- Configure and manage Apache services.
- Manage virtual hosts and SSL configurations.
- Troubleshoot server and application issues through log analysis.
Tomcat Administration
- Install and configure Apache Tomcat.
- Support application deployments.
- Monitor JVM performance and health.
- Analyze server logs and troubleshoot performance-related issues.
Responsibilities include:
- Create and administer SharePoint sites.
- Configure permissions and security settings.
- Manage user access requests.
- Perform troubleshooting and issue resolution.
- Provide technical support to business users.
Operating System Administration
Windows Server
- Manage Windows services and scheduled tasks.
- Perform Event Viewer analysis and troubleshooting.
- Administer users and permissions.
- Support server maintenance and issue resolution.
Linux
- Monitor system processes and resource utilization.
- Manage file systems and storage.
- Administer Linux services and user accounts.
- Execute troubleshooting using shell commands.