Server Database Administrator II
ZAR 258K-288K (estimate) Mid-level Full Time
Tasks
- Apply database patches and upgrades
- Configure SQL Server Agent and cron jobs
- Configure TLS SSL
- Configure database instances
- Configure encryption at rest and in transit
- Configure storage and memory parameters
- Create and manage backup strategies
- Ensure environment availability for DR UAT production and development
- Grant and manage user logins and permissions
- Implement Transparent Data Encryption
- Implement least-privilege access
- Install database engines
- Maintain database systems
- Manage role-based access control
- Monitor database performance
- Perform Point-in-Time recovery
- Perform index tuning
- Review execution plans
- Schedule database maintenance jobs
- Support disaster recovery environments
- Test and validate restores
- Tune queries to reduce I O CPU and memory usage
- Use monitoring tools to identify bottlenecks
Perks/Benefits
- N/A
Skills/Tech-stack
ARM Templates | Access Control | Azure Data | Azure Data Studio | B Tree Index | B-Tree | Backup and Recovery | Bash | Clustered Index | Columnstore Index | Cron | Data Studio | Data encryption | Database Restore | Database Restore Testing | Database Schema | Database Schema Design | Differential Backup | ER diagrams | Encryption at rest | Encryption in Transit | Enterprise Manager | Execution Plans | Full Backup | IBM DB2 | Incremental Backup | Index Tuning | Least Privilege | Log Backups | Management Studio | MariaDB | Microsoft SQL | Microsoft SQL Server | MySQL | Non Clustered Index | OLAP | OLTP | Oracle AWR | Oracle Database | Oracle Enterprise | Oracle Enterprise Manager | Performance Monitor | PgAdmin | Pg\_dump | Pg_stat | Point In Time | Point-in-time recovery | PostgreSQL | Powershell | Python | RMAN | Restore Testing | Role-Based Access | Role-Based Access Control | SQL Agent | SQL Profiler | SQL Server | SQL Server Backup | SQL Server Management | SQL Server Management Studio | Schema Design | Server Management Studio | Server backup | TLS/SSL | Terraform | Transparent Data Encryption
Education
Related jobs
-
Systems Administrator (Montagu - Western Cape) ZAR 360K-480KActive Directory | Azure | Azure AD | Azure AD Conditional Access | Azure Active DirectoryEnd user training sessions | On-site work environment | Professional developmentMid-level Full TimeMontagu, ZA5d ago
-
Data integration | Database Administration | Database security | Disaster Recovery | High AvailabilityMid-level Full TimeKempton Park, South Africa8d ago
-
AWS RDS | Automation | Azure SQL | Cosmos DB | IndexingMid-level Full TimeCape Town, Western Cape, South Africa9d ago
-
Azure | Azure CLI | Azure Data | Azure Data Lake | Azure DevOpsMid-level Full TimeJohannesburg, South Africa13d ago
-
Automation Scripting | Azure | Azure Data | Azure Data Lake | Azure DevOpsMid-level Full TimeJohannesburg, South Africa13d ago
-
Database Administrator ZAR 180K-213KAutomation | Backup and Recovery | Data Integrity | High Availability | LinuxChallenging work | Collaborative environment | Networking opportunities | Professional development resourcesEntry-level Full TimeFNB Building, 1 Enterprise Road, Fairland, …16d ago
-
Automation | High Availability | Linux | MariaDB | MySQLOn-call rotation support | Participation in open source projects | Professional growth opportunities | Remote work flexibilitySenior-level Full TimeSouth Africa R19d ago
-
Atlassian Ecosystem | Bitbucket | GitHub | GitLab | GroovyHealth insurance reimbursement | Home office reimbursement | Language lessons discount | Paid vacation | Recognition programsSenior-level Full TimeSouth Africa20d ago
-
Linux Administrator ZAR 240K-264KAnsible | Automation frameworks | Azure DevOps | Bash | GitHybrid workingEntry-level Full TimeCape Town, Draper on Main, South …22d ago