40 Sql And Oracle Microsoft Dba jobs in Midrand

You will be responsible for supporting end users on SQL Database used in the company environment, including data analysis and troubleshooting for issues raised from the applications.

Responsibilities:

• Operating Oracle and SQL database platforms and actively troubleshooting any issues impacting the environments, as well as analyzing error logs.
• Analyzing queries and advising on efficiency improvements.
• Identifying and resolving database locks and lack of statistics, resolving data structure issues, i.e., invalid objects, tables, partitions, constraints, and performing deploy patches as needed.
• Creating and maintaining SOPs.
• Collaborating with DBAs, developers, vendors, and professionals to deliver quality service.
• Acting as a subject matter expert for database implementations.
• Automating operational processes as needed, with accuracy and in compliance with security requirements.
• Providing service delivery in a timely and efficient manner.
• Ensuring continuous support is provided.
• Working with Incident Management, other support groups, and vendors to provide seamless support to customers.
• Participating in project work as assigned.
• Providing inputs to the Team Leader on the status of activities as required.
• Providing daily system check reports using the provided template.

• Grade 12.
• Formal IT qualification (National Diploma/Certificate, CompTIA, Microsoft or similar certification) or currently studying towards completing a Degree/Diploma or Certificate in IT.
• ITIL v3 Foundation.
• Microsoft Azure and Office 365.
• Own car and Driver’s License essential.
• MCSA: SQL Servers 2012 onwards.
• Oracle DBA support 11G onwards.
• 2-3 years’ experience with MSSQL and PLSQL.
• Sound knowledge of ITIL and SDLC.
• Strong technical aptitude and ability to research and solve complex issues independently.
• Exposure to Oracle version 11G and MSSQL from 2012 onwards.
• Experience in MSSQL Manager, performing SQL queries and log management.
• Experience with Oracle RMAN and Oracle Enterprise Manager.
• Performance and tuning experience (Tools: ADDM / AWR and Oracle advisors).
• Experience with scripting and automation (Shell / Bash / PowerShell / PL / SQL / SQL / DBMS jobs).

Please note only shortlisted candidates will be contacted.

Annually

We’re looking for a Database Administrator to manage the performance, security, and availability of database systems supporting enterprise software and client environments. You’ll work with cross-functional teams to design and maintain scalable, high-performing databases and provide on-site support for implementations, upgrades, and troubleshooting. Periodic travel required.

:

• Install and manage on-prem/cloud database servers
• Monitor performance and optimize queries, schema, and indexes
• Ensure database security, access control, and auditing
• Manage backups, restores, and disaster recovery testing
• Develop and maintain data models, procedures, views, and triggers
• Support development teams with data issues and test data
• Assist in deployment planning and post-release support
• Troubleshoot database issues and perform root cause analysis
• Document configurations and best practices
• Stay updated on new DB technologies and suggest improvements
• Travel as needed for client support and implementations

:

• Bachelor’s degree in IT, Computer Science, or related field
• 3–5 years’ DBA experience, ideally in software or IT services
• Proficient in at least one major RDBMS (PostgreSQL, SQL Server, Oracle, or MySQL)
• Strong grasp of database design, optimization, and normalization
• Knowledge of security, compliance, and data privacy best practices
• Familiar with replication, high availability, and disaster recovery
• Cloud DB experience (e.g., AWS RDS, Azure SQL) is a plus
• Skilled in scripting/automation (SQL, Bash, PowerShell)
• Open to regular travel for client and project support

Contact Hire Resolve for your next career-changing move.

Apply for this role today, contact Sune Pienaar at Hire Resolve or on LinkedIn
You can also visit the Hire Resolve website: hireresolve.us or email us your CV:

We will contact you telephonically in 3 days should you be suitable for this vacancy. If you are not suitable, we will put your CV on file and contact you regarding any future vacancies that arise

Database Administrator, preferably with a relevant tertiary qualification and minimum 5 years’ experience required to join this Financial Services Organisation, based in Midrand, Gauteng.

Minimum Requirements:

• Matric plus applicable tertiary equivalent experience or preferably, an ICT-relevant diploma or degree from a recognised tertiary institution
• Minimum 5 years’ experience as a database administrator, essential
• Relevant technical certifications
• Cloud database experience
• Ability to consult on data architecture and assess the impact of project changes to data architecture, required
• Experience working with SQL Server 2016 and 2019 as a database administrator, essential
• Design and development of MS SQL Server databases (DB design, optimization, tuning, ETL, stored procedures, triggers, and views)
• MCDBA certification advantageous
• SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS) beneficial
• Must have Microsoft SQL Always On practical experience

Duties and Responsibilities:

• Implement appropriate designs for databases, data warehouses, marts, reports, and dashboards
• Specify database infrastructure requirements
• Design and implement database solutions for high performance and high availability using Microsoft SQL Always On.
• Responsible for planning and implementing database replication
• Perform query and database optimisation Be responsible for database maintenance
• Work with development teams to identify databases for decommissioning
• Monitoring database user access and security
• Writing database documentation, including data standards, procedures, and definitions
• Developing, managing, and testing disaster recovery processes and servers as well backup and recovery plans
• Keep abreast of new database technologies

Job Summary:

The Database Administrator will take ownership of the databases across our clients'(Azure SQL Server) the optimal performance of all database tables, stored procedures, and views. This role involves identifying issues and making recommendations for infrastructure changes as needed.

Key Responsibilities:

1. Database Design and Management:

• Design, create, and maintain databases to meet the organizations requirements.
• Ensure data integrity and efficient data structures.

2. Setup and Maintain Data Factory for Power BI Reporting:

• Establish and manage data factory pipelines to support Power BI reporting needs.

3. Database Performance Tuning and Optimization:

• Monitor and enhance database performance through query optimization and indexing.
• Implement best practices for optimizing database performance.

4. Data Backup and Recovery:

• Set up and manage backup and recovery processes to safeguard data integrity.

5. Security and Access Control:

• Enforce security protocols to protect sensitive data.
• Manage user access permissions and roles.

6. Database Software Installation and Configuration:

• Install, configure, and upgrade database software as required.

7. Monitoring and Troubleshooting Database Issues:

• Proactively monitor database systems for issues and troubleshoot as needed.
• Implement solutions to prevent recurrence of problems.

8. Collaborating with Developers and BI Developers:

• Work closely with application developers and business intelligence developers toensure seamless integration with the database systems.

9. Database Documentation:

• Maintain comprehensive documentation of database schemas, configurations, andprocesses.

Qualifications and Skills:

1. Bachelors degree in computer science or a related field. (advantageous)
2. Minimum of 1 years of experience as a Database Administrator.
3. Relevant certifications, such as Microsoft Certified: Azure Database Administrator. (advantageous)
4. In-depth knowledge of specific database management systems, particularly SQL Server.
5. Proficiency in SQL and expertise in database query optimization.
6. Familiarity with best practices for database security.
7. Strong problem-solving and troubleshooting skills.
8. Effective communication and teamwork abilities.

• Degree in Computer Science, Information Systems or IT relevant Degree
• Microsoft certified Database Administrator (Added Advantage)
• Cloud Certification (Added Advantage) and Relevant Database certificates

• Minimum of 5 years proven MS SQL Database Administration
• Minimum of 2 years Microsoft Synapse experience
• MySQL experience (added advantage)

Job Description:

• Apply knowledge of computer science principles, information management principles, automated data processing (ADP) functions, hardware and software systems' structures and operation, and computer programming languages and techniques to solve automation problems
• Interface with and use minicomputer and mainframe computer systems in addressing project objectives
• Use standard or conventional approaches, methods and techniques to define, plan, organize, design, refresh/modify, test and integrate data base or data processing systems, computer hardware systems and simulation models
• Assist in formulating architectural design, functional specifications, interfaces and documentation of hardware or software system
• Use detailed specifications and adapt standardized techniques, methods, criteria and precedents to refresh or modify portions of a system or program
• Responsible for segments or phases of broader and more complex projects
• Knowledgeable of Windows Server 2019 Configuration and Administration
• Knowledge of Internet Information Server (IIS) 8.5 administration
• Ability to implement DISA required Server configurations
• Maintain Compliance provided by DISA STIGs
• Complete Annual Security Audits with USARC Cyber Team
• Detailed knowledge of T-SQL querying
• Experience with SQL Server Reporting Server (SSRS) and SQL Server Integration Services (SSIS)
• Able to learn and understand AWMS processes and workflows

• Diploma or postgraduate Degree in computer science, information systems management, mathematics, operations research, statistics, or engineering from an accredited college or university; or eight (8) years of combined education (at the undergraduate level in any academic field) and at least three (3) years' experience
• 8-15 years of experience working with progressively more complex or large-scale databases.
• Experience and / or the ability to perform software program refreshment, systems testing, and production of graphic and statistical reports
• Proficient with Microsoft Office software, to include, but not limited to Word, PowerPoint, Excel, Outlook, etc.
• Excellent verbal and written communication skills,
• Experience with government systems and requirements for maintaining access to these systems

• Knowledge of Azure infrastructure and security practices
• Azure Web App configuration and management
• Power BI reporting knowledge
• Knowledge of CI/CD configuration
• Continuous Risk Monitoring experience
• Detailed Knowledge of T-SQL Querying
• Able to learn and understand AWMS processes and workflows

• Degree in Information Technology or Computer Science
• Oracle Certified Associate (OCA) Oracle Database 12c or 19c - Required
• Oracle Certified Professional (OCP) Oracle Database 12c or 19c - Advantage
• 5+ years of experience as an Oracle Database Administrator (DBA) in large enterprise environments
• Strong working knowledge of Oracle versions 12c, 19c, and/or 21c
• ITIL Practitioner (V3) / ITIL Specialist (V4)
• Hands-on experience with:
  • Oracle RAC (Real Application Clusters)
  • Oracle Data Guard (disaster recovery and high availability)
  • Oracle RMAN (backup and recovery)
  • Oracle Enterprise Manager (OEM)
  • PL/SQL development (packages, triggers, procedures)
  • Shell scripting for task automation
• 3+ years working in environments with complex business logic and high volumes of stored procedures
• Management of operations on virtualized and distributed infrastructures,
• Management of operations on environment with clustering, replication, load balancer
• Experience with performance tuning and advanced diagnostics (AWR, ASH, SQL Tuning Advisor)
• Exposure to functional/business workflows, ideally in logistics, supply chain, or ERP systems
• Familiarity with DevOps practices, version control, and Agile methodologies is a plus

• Provide expert-level administration and support for Oracle databases (primarily 12c/19c/21c) across development, testing, and production environments.
• Act as the database specialist for the business projects using Oracle databases, with a strong focus on both infrastructure and understanding of business logic.
• Collaborate with developers, analysts, and business users to understand stored procedures, schemas, and underlying application workflows.
• Ensure high availability, performance, and security of Oracle database systems within the enterprise.
• Install, configure, patch, and upgrade Oracle database software across multiple environments (Azure and OnPrem)
• Design and implement database architecture, including tablespaces, partitions, indexes, and schemas.
• Monitor and optimize database performance using tools like AWR, ASH, and Oracle Enterprise Manager.
• Implement backup and recovery strategies using RMAN and Oracle Data Pump.
• Ensure database security, auditing, and compliance with company policies and regulations.
• Handle database replication, high availability (Oracle RAC), and disaster recovery strategies (Data Guard).
• Perform capacity planning and manage database storage across large enterprise environments.
• Automate routine DBA tasks using Shell or PL/SQL scripts.
• Realize periodical tuning of the databases to maintain I/O performances
• Analyse, interpret, and debug complex PL/SQL stored procedures, packages, and triggers.
• Work closely with application teams to align database logic with business processes.
• Understand end-to-end business workflows supported by Oracle systems, especially in the Logistics/Supply Chain domain.
• Translate functional requirements into optimized database queries or procedures.
• Participate in application development or modernization projects by providing database-level insights.