Senior Database Administrator

2 weeks ago

Johannesburg, South Africa GMC Talent (Pty) Ltd Full time

**Overview**

The purpose of this role is to design methods to store, analyse, utilize, and organize data To create computer databases based on user needs Migrate data from old systems to new system. To effectively managing multiple database environments

**Responsibilities**:

- Set up and document operational procedures (maintenance, user administration, server standards etc.) Monitor and enforce the usage of the procedures
- Implements departmental and industry best-practices security standards
- Mitigate the risk to ensure mínimal downtime and system availability by ensuring best support practices are in place to ensure proper recovery as defined by the Recovery Point Objective (RPO) and Recovery Time Objective (RTO)
- Monitor the PostgreSQL and MS SQL environment, provide capacity trends and highlight performance bottlenecks
- Provide after-hour standby and support
- Data migration and integration
- SSIS, SSRS, SSAS and SQL development
- The SQL Software Engineer will help design, implement and support the organizations transactional and dimensional Data Warehouse development efforts, providing guidance and direction to clients and project team members
- Leverage knowledge of current data warehouse and software development methodologies to contribute to the overall planning of projects by recommending approaches, identifying resources, and developing timelines
- Build and maintain PostgreSQL packages
- Build and maintain MS SQL SSIS packages
- Implement and manage MS SQL Server databases
- Implement and manage PostgreSQL databases
- Logical and physical data modeling (Transactional and Dimensional)
- Develop and maintain vendor extract / import process
- Identify logical issues between database models and reports
- Follow change management procedures
- Experience in implementing operational automation
- SQL Development - ability to write and troubleshoot SQL Code and design (stored procs, functions, tables, views, triggers, indexes, constraints)
- Knowledge of High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server
- Create ways to store, organize, and present data
- Perform complex technical, analytical and professional services involving program/member services, evaluation, database-driven Web sites, office operations
- Administer a variety of database systems including Microsoft SQL Server, Filemaker Pro, and others
- Integrate old systems data with new system
- Test and coordinate modifications
- Audit, modify, and amend data in systems using SQL commands, hand-editing, and bulk import
- Troubleshoot and correct issues as they arise
- Ensure system is running smoothly
- Add new users to the system as needed
- Plan and coordinate security measures alongside network administrators
- Enhance or build database designs
- Develop, implement measures and execute maintenance plans to maximize availability, performance, and reliability of databases
- Develop, implement and execute a backup / disaster recovery plan for all databases via various technologies (log shipping, database mirroring, SAN replication, etc.)
- Performs strategic database planning as appropriate
- Review, plan, test, and implement database upgrades while adhering to all change management policies and procedures
- Work in conjunction with program owners in the review, planning, testing, and implementation of program upgrades dependent on database technology
- Advise, educate and make recommendations to system analysts and other staff on administration policies and procedures and technical methods
- Troubleshoot and resolve database connectivity and performance problems
- Troubleshoots and resolves problems with production systems; escalates issues, facilitates resolution

**Must have**:

- Bachelor’s Degree in Information Technology or Equivalent
- ITIL Foundation
- SQL Server 2008/2012/2014
- PostgreSQL certification required
- Database Security
- DB Reporting and monitoring

**Competencies**:

- Is adept in the use of the latest MS Office package, particularly Excel, Word and Power-point
- Strong Knowledge in Microsoft SQL versions 2005, 2008, 2012 and 2014
- Strong knowledge in PostgreSQL
- SQL server upgrade (2005 >2008, 2008 >2012, 2012 >2014)
- SSRS, SSIS, SSAS, IIS experience
- Knowledge in SQL Server Clustered environment
- Knowledge of SQL scripting, preferred
- VMWare experience, a plus

**Attributes**:

- Client focused, attention to detail, high organized
- Ability to think strategically, execute quality proposals under multiple and competing deadlines and work extra hours as needed (evenings and weekends)
- High level of creativity, inspiration, innovation and ability to think "outside the box"
- You will be a driven and ambitious experienced self-starter with excellent negotiation skills and business acumen
- Good understanding of the organizations goals and objectives
- Self-motivated and directed, with keen attention to detail
- Able to prioritize and execute tasks in a high-pressure environment
- Ex

  • Senior Database Administrator

    3 days ago

    Johannesburg, South Africa Pollock and Associates Full time

    Senior Database Administrator ICT Johannesburg North, Johannesburg - Gauteng - South Africa Are you an experienced Senior SQL DBA with a passion for database design, performance optimization, and troubleshooting? Our client is looking for a talented Senior Database Administrator to join their team and take on a challenging and rewarding role reporting...

  • Snr Database Administrator

    2 weeks ago

    Johannesburg, South Africa Positive Switch Full time

    **Description** - The senior SQL Database Administrator will support the business in achieving its strategic objectives within the Data Services Business Unit. - As senior SQL Database Administrator in the business unit team, you will be responsible for consulting with clients on complex information technology challenges - Microsoft SQL database...

  • Senior Database Administrator

    2 weeks ago

    Johannesburg, South Africa PPS Recruitment Full time

    **Job Advert Summary**: **Purpose of the Job**: The role is responsible for maintaining the integrity and performance of the company databases and guaranteeing that the data is stored securely and efficiently. **Minimum Requirements**: **Education**: - Matric (Grade 12) - BSc/BTech in IT, Computer Science degree OR Diploma in IT - ITIL Foundation -...

  • Database Administrator

    3 days ago

    Johannesburg, South Africa Affirmative Portfolios Full time

    **Information Technology** **JHB North***: **Database Administrator** **Permanent R670 500p/a** **Sandton** Job Advert Summary **Job summary statement/purpose** The primary role of the database administrator’s (DBA) is to ensure that data is available, structured, protected from loss and corruption, and easily accessible. The DBA will be expected to...

  • Database Administrator

    3 days ago

    Johannesburg, South Africa Six Sense Consulting Full time

    **SKILLS & QUALIFICATIONS**: - Degree in Computer Science, Information Systems, or IT relevant Degree - Microsoft certified Database Administrator (Added Advantage) - Cloud Certification (Added Advantage) **EXPERIENCE**: - Relevant database certificates - Insurance background (Added advantage) - Minimum of 5 years proven MS SQL Database Administration -...

  • Database Administrator

    4 days ago

    Johannesburg, South Africa Six Sense Full time

    Gauteng, JHB - Northern Suburbs - Annually Basic Salary (Market related) A well-established short term insurer is seeking to appoint a Database Administrator to ensure that data is available, structured, protected from loss and corruption, and easily accessible. The DBA will be expected to manage, maintains, and secure data in one or more data systems to...

  • Database Administrator

    Found in: Talent ZA C2 - 3 weeks ago

    Johannesburg, South Africa Telebest Full time

    Our client has an opportunity available for a Database Administrator in the ICT and Projects department based in Gauteng.Requirements:3 years’ experience working with SQL databases and the management thereof.2+ years working experience on DB2 databases.Travel and work overtime when required.Relevant IT diploma or degree.Certified in SQL, DB2 and...

  • Database Administrator

    Found in: Talent ZA 2A C2 - 3 weeks ago

    Johannesburg, South Africa Datonomy Solutions Full time

    Are you ready to take your database skills to the next level? We're on the lookout for a passionate and dynamic Database Administrator!Job Description: To manage, monitor and support mainframe IDMS and DB2 database objects and ensure their availability, performance, security and consistency in order to support mission critical business applications.Create...

  • Database Administrator

    Found in: Talent ZA 2A C2 - 1 week ago

    Johannesburg, South Africa Tower Group Full time

    Database Administrator required for a Contract role in Midrand to implement, maintain and ensure the performance and security of the Oracle Database.  Responsibilities:Database Infrastructure installation and configurationPerformance investigations, tuning and recommendationsData ArchivingData CompressionTable PartitioningData RestorationOracle Enterprise...

  • Database Administrator

    Found in: Talent ZA C2 - 7 days ago

    Johannesburg, South Africa Tower Group Full time

    Database Administrator required for a Contract role in Midrand to implement, maintain and ensure the performance and security of the Oracle Database.  Responsibilities:Database Infrastructure installation and configurationPerformance investigations, tuning and recommendationsData ArchivingData CompressionTable PartitioningData RestorationOracle Enterprise...

  • Database Administrator

    Found in: Whatjobs ZA C2 - 6 days ago

    Johannesburg, South Africa Tower Group Full time

    Database Administrator required for a Contract role in Midrand to implement, maintain and ensure the performance and security of the Oracle Database.   Responsibilities: Database Infrastructure installation and configuration Performance investigations, tuning and recommendations Data Archiving Data Compression Table Partitioning Data Restoration Oracle...

  • Database Administrator

    Found in: Adzuna ZA B C2 - 1 week ago

    Johannesburg, South Africa Adzuna ZA B C2 Full time

    Database Administrator required for a Contract role in Midrand to implement, maintain and ensure the performance and security of the Oracle Database. Responsibilities:Database Infrastructure installation and configurationPerformance investigations, tuning and recommendationsData ArchivingData CompressionTable PartitioningData RestorationOracle Enterprise...

  • SQL Database Administrator

    Found in: Whatjobs ZA C2 - 6 days ago

    Johannesburg, South Africa Network Recruitment Full time

    SQL Database Administrator Gauteng Our client, who is specialising in high-level e-commerce services, is looking for an SQL DBA to join their team. The successful candidate will have to ensure best practice standards regarding SQL, reporting, perform backup and recovery, and also provide assistance to BI developers and users.Job Experience & Skills Required:...

  • SQL Database Administrator

    Found in: Talent ZA 2A C2 - 3 weeks ago

    Johannesburg, South Africa Network Recruitment Full time

    SQL Database AdministratorGautengOur client, who is specialising in high-level e-commerce services, is looking for an SQL DBA to join their team. The successful candidate will have to ensure best practice standards regarding SQL, reporting, perform backup and recovery, and also provide assistance to BI developers and users.Job Experience & Skills...

  • SQL Database Administrator

    Found in: Adzuna ZA B C2 - 1 week ago

    Johannesburg, South Africa Adzuna ZA B C2 Full time

    SQL Database AdministratorGautengOur client, who is specialising in high-level e-commerce services, is looking for an SQL DBA to join their team. The successful candidate will have to ensure best practice standards regarding SQL, reporting, perform backup and recovery, and also provide assistance to BI developers and users.Job Experience & Skills...

  • Oracle Database Administrator

    6 days ago

    Johannesburg, South Africa Total IT Recruitment Full time

    Need a new opportunity for 2024. Then this is for you. Well reputable company is looking for an Oracle DBA with minimum 5 years experience as a DBA to join their dynamic team.. **The following skills are essential**: - Experience with ASM Storage - Database Patching and performance tuning - Database Security - Upgrades - Backup and restore - Data...

  • SQL Database Administrator/dba

    4 hours ago

    Johannesburg, South Africa Mediro ICT Full time

    **Job functions**: The SQL Database Administrator’s role is to design, install, monitor, maintain and performance tune production SQL databases while ensuring high levels of data availability. This individual is also responsible for developing, implementing, and overseeing database policies and procedures to ensure the integrity and availability of...

  • Senior SQL Database Administrator

    3 days ago

    Johannesburg, South Africa Sanlam Full time

    Who are we? Sanlam Developing Markets [SDM] (a wholly-owned subsidiary of Sanlam Life Limited) is one of the top financial services providers in the South African entry-level and emerging middle market. It aims to understand the unique requirements of clients and offers a wide range of simple and affordable financial solutions that cover needs such as...

  • SQL Database Administrator

    2 days ago

    Johannesburg, South Africa Business Capital Group Full time

    _**Strategy & Planning**_ - Assess and develop long-term strategic goals for production databases in conjunction with data owners and department managers. - Design and implement redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets. - **Acquisition & Deployment**_ -...

  • SQL Snr Database Administrator

    3 days ago

    Johannesburg, South Africa Xcede Full time

    **Posted**:about 8 hours ago- **Sector**: Data- **Location**: Johannesburg- **Job Ref**: PR/115483_1675841996- **Job Type**: Permanent- **Salary**: Negotiable per year- **Expiry Date**: 20 March 2023- **Contact**: Stephanie Payne- Attention all experienced SQL DBAs! We're seeking a skilled professional with a Degree/Diploma in Computer Science or similar and...