Power-Star Logo

SQL DBA

Power-Star|Posted 3 months ago

Skills and experience

Role:Database administrator
Other roles:Data analyst, Data architect
Experience in role:5+ years
Language proficiency:English
Must-have skills:
    Microsoft SQL Server
Nice-to-have skills:
    T-SQL
    Database Design
    Database Testing

Location and salary

Remote policy:In-office
Location of job:Cape Town, South Africa
Visa requirements:No specific requirements
Visa sponsorship:Unable to sponsor visa
Employment type:Permanent

Role description

About the job

Company Overview:

Augos is a leading provider of measurement-based technology solutions, with a mission to empower clients through data-driven insights and innovative technology in Energy & Utilities, IoT Sensing & Monitoring, and Manufacturing Metrics. Augos aims to enhance operational efficiency across key business outcomes:

Decision Making Support | Workforce Automation | Monitoring & Control | Data Visualisation | Efficiency Insights | Quality Assurance | Risk Mitigation | Systems Integration | Financial Assurance | Workplace Monitoring | Data Accessibility

We are committed to uncovering hidden value for businesses, enabling them to seize previously invisible opportunities. Our vision is to equip business leaders with actionable insights that drive change.

The Role:

We are seeking an experienced SQL Database Administrator (DBA) to join our team. This is a hands-on role requiring expertise in database administration and development, ensuring optimal performance, reliability, and security of our database systems. If you thrive in a collaborative team environment and have a passion for database optimization, this is an excellent opportunity for you.

Responsibilities:

Manage and maintain SQL Server databases to ensure high availability, security, and optimal performance.

Perform core DBA tasks, including compression, partitioning, fault finding, and optimizations.

Develop, optimise, and maintain SQL queries, stored procedures, and functions as needed.

Conduct regular database monitoring and troubleshooting to identify and resolve performance bottlenecks.

Design and implement backup and recovery strategies to safeguard data integrity.

Collaborate with team members to define and document database requirements and solutions.

Implement and uphold database security measures to protect sensitive information.

Proactively identify opportunities for process improvement and efficiency.

Stay informed of industry best practices and advancements in SQL Server technologies.

Requirements:

At least 5 years of hands-on database administration experience with MS SQL Server. Do not apply if this requirement is not met.

Strong expertise in database compression, partitioning, fault finding, and performance optimization.

Proven ability to write efficient and optimized SQL queries, stored procedures, and functions.

Solid understanding of database security, backup, and recovery best practices.

Excellent problem-solving skills and meticulous attention to detail.

Effective communication and collaboration skills, thriving in a team-oriented environment.

Ability to work in a fast-paced environment and deliver high-quality results.

Bachelor's degree in a related field is preferred but not mandatory.

This is an office-based role in Durbanville, Cape Town, South Africa. Candidates must reside within commuting distance. Remote applications will not be considered.

Benefits:

Opportunity for professional growth and development.

Company-provided tools and equipment.

Work in a collaborative and innovative team environment.

Important Notes:

This role involves working closely with a small, dedicated team.

Candidates must be prepared to handle a mix of DBA work and occasional query or stored procedure development.

Applicants who do not meet the experience requirement or reside outside commuting distance will not be considered.

About Power-Star

15-50 employees

What we do

Power-Star delivers real-time energy intelligence to commercial and industrial users. Our cloud based products include metering, site monitoring and intelligent switching solutions.

With our unique insights and high definition data, we engage our customers and challenge our customers on three levels; operational and behavioral change, infrastructure inefficiency, and alternative energy, typically in that order.

Interventions need to be bankable with return on effort or return on investment, measured and verified. Our advisory services include audit, bill verification, tariff optimization, and incentive consultation.

Power-Star delivers measurement solutions and energy management services to several Top 100 businesses and marquee brands. We service every major business sector in more than 10 countries in Africa, Europe & the Middle East.

Why Work For Us

Our Culture

Our Engineering Processes

Our Hiring Process

Perks at Power-Star

Hybrid Work Environment
Friday afternoon beers with the team

Tech Stack

application and data

PostgreSQL
PostgreSQL
Javascript
Javascript
MySQL
MySQL
React
React
MS SQL
MS SQL

dev ops

GitHub
GitHub
Git
Git

business tool

Zoom
Zoom

Similar jobs on OfferZen: