Senior DBA
Woodmead, Gauteng
Posted 7 days ago
- Company:
- BAEC Specialists
- Company Description:
- Welcome to BAEC Specialists, the providers of cutting-edge resourcing services. With a focus on innovation and client satisfaction, we're driven to redefine the landscape of niche staffing solutions. Drawing on our extensive industry experience, we've built a reputation for seamlessly matching skilled professionals with leading organisations, driving success and exceeding expectations. What sets us apart is our unwavering dedication to flexibility. Whether clients need resources locally or offshore, our fully customisable service options ensure access to top talent when needed, empowering clients to optimize IT operations and achieve strategic objectives. At BAEC Specialists, we're more than just staffing solutions; we're dedicated to forging lasting partnerships grounded in trust, reliability, and innovation. With our unmatched expertise and commitment to excellence, we're setting new industry standards.
- Contract Type:
- Full Time
- Experience Required:
- 5 to 10 years
- Education Level:
- Bachelor
- Gender:
- Any
- Number of vacancies:
- 1
Job Description
Minimum skills and knowledge required
• Diploma or Degree in IT administration, MCSE, MCDBA SQL and database design, etc.
• Minimum of 5+ years in database administration in advanced stage with proven track record
• Experience with Windows Server 2016 upwards and SQL 2014, 2017, 2019 and the proper disk configuration and layout to support large, scalable SQL Server environments
• Data warehousing and transactional flows of data from different systems
• Microsoft SSRS, SSIS, SSAS
• Virtual Server experience, Azure or AWS experience a bonus
Key performance areas
• Database Administration
• Provide administration of database systems including installation, upgrades, configuration, migration, consolidation, monitoring, tuning, and maintenance
• Testing new versions of the database management system (DBMS)
• Set up, maintain reporting and data integration processes using SSRS, SSIS and SSAS
• Set and administer standards for overall organization's SQL Server relational database structure / architecture
• Oversee all data generated, monitor server transaction speeds, and look for any service degradation in speeds due to SQL fragmentation or lack on maintenance
• Oversee all SQL instances and databases
• Patching and updating Software
• Implement database backup, disaster recovery and high-availability solutions
• Ensure the companies records are archived and secure and keep the companies database maintenance plan intact with the company records
• Maintain data standards, including adherence to the Data Protection Act
• Write database documentation, including data standards, procedures and definitions for the data dictionary (metadata)
• Implement and maintain a working high availability environment with all SQL instances
• Database Reporting / dashboards / Build and maintain the company dashboards
• Ensure all company reports are accurate and running
• Develop custom database objects (T-SQL scripts, stored procedures, tables, views, functions)