Welcome to FNB, the home of the #changeables. We design for the shapeshifters and deliver products and services that make us incredibly proud of people that make it happen.
As part of our Core Banking Team, you will be surrounded by unique talents, diverse minds, and an adaptable environment that lives up to the promise of staying curious. Now’s the time to imagine your potential in a team where experts come together and ignite effective change.
Are you someone who can:
.
Windows Server Administration
Windows Server Management: Strong knowledge of Windows Server (2008, 2012, 2016, 2019, or 2022) administration, including installation, configuration, patching, and troubleshooting.
Active Directory: Expertise in Active Directory (AD) management, including user/group management, Group Policy (GPO), domain controllers, DNS, and replication.
PowerShell Scripting: Proficiency in using PowerShell for automation, system management, and administrative tasks such as user management, software installation, and configuration changes.
File and Print Services: Knowledge of configuring and managing file servers, network shares, NTFS permissions, and print services.
Windows Security: Understanding of security best practices, including user authentication, file system permissions, Windows Defender, and system hardening.
Azure Administration
Azure Services: Deep knowledge of Microsoft Azure cloud services, including compute (VMs, App Services), networking (VNets, VPN, Load Balancer), and storage (Blob, Disk, File Storage).
Azure Active Directory (AAD): Understanding of AAD for identity and access management, integration with on-prem Active Directory, user provisioning, and Azure MFA.
Azure Networking: Proficiency in configuring and managing virtual networks (VNets), VPNs, ExpressRoute, Network Security Groups (NSGs), and Azure Load Balancers.
Azure Resource Management: Ability to use Azure Resource Manager (ARM) templates, Azure CLI, and PowerShell to deploy and manage Azure resources.
Azure Monitoring & Security: Experience with Azure monitoring tools such as Azure Monitor, Log Analytics, Azure Security Center, and setting up alerts, dashboards, and security policies.
MS SQL Server Administration
SQL Server Installation and Configuration: Expertise in installing and configuring various versions of SQL Server (2008, 2012, 2014, 2016, 2017, 2019), including configuring instances, databases, and SQL Server settings.
Database Backup & Recovery: Strong knowledge of SQL Server backup and recovery strategies, including full, differential, and transaction log backups, and disaster recovery plans.
Performance Tuning and Optimization: Experience with database performance optimization, including query optimization, indexing, and using SQL Server tools like SQL Profiler, Execution Plans, Database Tuning Advisor, and Dynamic Management Views (DMVs).
Replication and High Availability: Knowledge of SQL Server replication, Always On Availability Groups, Database Mirroring, and Log Shipping for high availability and disaster recovery.
Security & Permissions: Understanding SQL Server security features, including SQL authentication, Windows authentication, encryption, permissions, role-based security, and Auditing.
SQL Server Integration Services (SSIS): Experience in designing and managing ETL workflows with SSIS, including data extraction, transformation, and loading from multiple sources into SQL Server databases.
SQL Server Agent: Familiarity with SQL Server Agent for automating maintenance tasks like backups, jobs, and alerts.
Monitoring: Proficiency with monitoring SQL Server instances using built-in tools like SQL Server Management Studio (SSMS) and Performance Monitor, as well as third-party tools for monitoring SQL Server health and performance.
SQL Server Integration Services (SSIS)
SSIS Package Development: Strong experience in creating and managing SSIS packages for ETL processes, including data extraction from various sources (SQL Server, flat files, Excel, etc.), transformation, and loading.
SSIS Performance Optimization: Knowledge of optimizing SSIS packages for performance, including data flow optimizations, parallel processing, and debugging.
Error Handling & Logging: Expertise in configuring logging, error handling, and event handling in SSIS packages to track failures and performance issues.
Deployment & Scheduling: Experience deploying SSIS packages to SSISDB and configuring jobs using SQL Server Agent to schedule and automate ETL processes.
Database Design & Architecture
Normalization & Schema Design: Understanding of relational database design, including normalization, indexing, primary/foreign keys, and optimization for large datasets.
Data Warehousing: Knowledge of data warehousing concepts and architectures, including dimensional modeling (star/snowflake schemas) and OLAP cube development.
Data Migration: Experience in data migration strategies and tools for transferring data between different SQL Server environments or from SQL Server to other systems (e.g., cloud, other databases).
Disaster Recovery & High Availability
Backup and Recovery Plans: Designing and implementing comprehensive disaster recovery plans for SQL Server and Windows infrastructure, ensuring business continuity.
Clustering and Availability Groups: Knowledge of Windows Server Failover Clustering and SQL Server Always On Availability Groups for high availability and failover scenarios.
Automation & Scripting
PowerShell Scripting: Proficiency in using PowerShell for automating administrative tasks such as SQL Server backup, maintenance, and user management.
SQL Scripts: Ability to write T-SQL scripts for automating database management tasks (e.g., cleanup, maintenance, querying).
Automation Tools: Familiarity with tools like Azure Automation and System Center Orchestrator for automating repetitive administrative tasks and workflows.
Security & Compliance
SQL Server Security: Understanding of SQL Server security best practices, including role-based access, encryption (TDE, Always Encrypted), and auditing for compliance requirements.
Data Encryption: Knowledge of database encryption methods such as Transparent Data Encryption (TDE), Always Encrypted, and column-level encryption.
Compliance: Familiarity with compliance frameworks like GDPR, HIPAA, and PCI DSS, especially in relation to managing data security and privacy in SQL Server environments.
Monitoring & Troubleshooting
SQL Server Profiler: Experience using SQL Server Profiler for troubleshooting and auditing SQL Server events, queries, and performance.
Performance Tuning Tools: Proficiency in using tools such as SQL Server Management Studio (SSMS), Performance Monitor, and Extended Events for diagnosing issues and optimizing performance.
Event Logs and Error Handling: Familiarity with reviewing Windows Event Logs, SQL Server Error Logs, and implementing efficient error handling strategies in both SQL Server and SSIS
You will be an ideal candidate if you:
Minimum Qualification - Relevant bachelor’s degree in information technology computer science, Information Systems or related field
Preferred Qualification - Control M/O/R certification
Experience - 3 to 5 years’ experience in a similar environment, of which 1 to 2 years ideally at junior (entry level) management level
Prior batch scheduling or software equivalent
Programme/Batch monitoring
Developer fix application
Troubleshooting and analysis protocol
Monitoring and command center knowledge
Data processing
Infrastructure knowledge
Operating systems knowledge
Redhat Certification
You will have access to:
Opportunities to network and collaborate.
Challenging Working.
Opportunities to innovate.
We can be a match if you are:
Curious & courageous - you're driven by always wanting to know more and learn more.
Obsessed with mastery - you know what it takes to become good at what you do and are constantly pushing yourself to do it.
#LI-TK1
Job Details
Take note that applications will not be accepted on the below date and onwards, kindly submit applications ahead of the closing date indicated below.
25/04/25
All appointments will be made in line with FirstRand Group’s Employment Equity plan. The Bank supports the recruitment and advancement of individuals with disabilities. In order for us to fulfill this purpose, candidates can disclose their disability information on a voluntary basis. The Bank will keep this information confidential unless we are required by law to disclose this information to other parties.
DevOps Engineer-1