Senior Database Administrator

[Senshi]

Position Available: Senior Database Administrator
Number of Positions: 1
Employment type: Permanent
Salary: Market relevant (this is not shared with me unfortunately)
Perks: Internet / phone / possible others
Starting Date: Immediately
Location: Waterfall Office Park, Midrand. Position is an onsite position (with some work from home days offered depending on experience)
Job Description:

SELECT StarApplicant FROM ApplicantDBA ADBA JOIN MIX ON ADBA.IntegrityAndTrust >= MIX.IntegrityAndTrust AND ADBA.CustomerFocus >= MIX.CustomerFocus AND ADBA.DecisionQuality >= MIX.DecisionQuality AND ADBA.Perseverance >= MIX.Perserverance AND ADBA.ProblemSolving >= MIX.ProblemSolving WHERE ADBA.Skills IN ('SQLDevelopment', 'SQLAdmnistration', 'SQLTroubleshooting') AND ADBA.SkillLevel > 'Average' AND ADBA.ExperienceYears > 5 AND ADBA.EnvironmentExperience LIKE '%Enterprise%' AND ADBA.PossibleCloudExperience in ('Azure') AND ADBA.DevelopmentExperience in ('GIT',’Python’) AND ADBA.OtherExperience IN ('TSQL', ‘PowerBI’, 'Reporting Services', ‘Windows Clustering','AlwaysOn', 'Automation', 'SSIS')

Requirements
5+ Years of experience
Extensive experience in SQL Server Database Administration. • Extensive experience in database tuning and performance optimisations. • Strong database design and development skills • Strong database Troubleshooting skills • SQL code review an understanding of software version control systems • You will have strong technical aptitude/rapport and ability to – convey technical content in a clear, concise manner, using appropriate language appropriate for the audience. • Understanding Agile Software Development including Scrum and Kanban. • Experience with Data warehouses (Methodologies and normalization levels) • Experience with Microsoft SQL SSRS reporting services and Power BI. • Strong leadership qualities. • Ability to work in a team environment. • Ability to anticipate problems and take decisive action Out of Hours. • Ability to adjust to rapid changes in deadlines and priorities • Ability to balance multiple high priority projects

 

[Ninja Sandwich]

Epic Job Description!

Fix your quotes though my G.
ADBA.DevelopmentExperience in ('GIT',’Python’) AND ADBA.OtherExperience IN ('TSQL', ‘PowerBI’, 'Reporting Services', ‘Windows Clustering','AlwaysOn', 'Automation', 'SSIS')

 

[moedeez]

Epic Job Description!

Fix your quotes though my G.
ADBA.DevelopmentExperience in ('GIT',’Python’) AND ADBA.OtherExperience IN ('TSQL', ‘PowerBI’, 'Reporting Services', ‘Windows Clustering','AlwaysOn', 'Automation', 'SSIS')

It was a test, you passed. Congrats on the new job.

 

[Senshi]

Epic Job Description!

Fix your quotes though my G.
ADBA.DevelopmentExperience in ('GIT',’Python’) AND ADBA.OtherExperience IN ('TSQL', ‘PowerBI’, 'Reporting Services', ‘Windows Clustering','AlwaysOn', 'Automation', 'SSIS')

There was a reason they were left in there.....

 

[Chevez]

There was a reason they were left in there.....

Missing an order by and select from top 1

 

[Ninja Sandwich]

Missing an order by and select from top 1

Why would you have an order by with a select top 1? 🤔

 

[Chevez]

Why would you have an order by with a select top 1? 🤔

To get the best candidate...

But I do get the point if you want lots of recruits.

 

[Ninja Sandwich]

Top 1 will legit give you only 1 result, there's no reason to do a order by then, would be best to do a select distinct and order by for people who submit multiple entries.

 

[viceroy]

There absolutely is good reason to do a top 1 with an order by.

eg. return only the most expensive product.

SELECT TOP 1 ProductName
FROM PRODUCT
ORDER BY Price DESC

 

[Ninja Sandwich]

There absolutely is good reason to do a top 1 with an order by.

eg. return only the most expensive product.

SELECT TOP 1 ProductName
FROM PRODUCT
ORDER BY Price DESC

You only going to return 1 product, yes of highest value, but in terms of candidates, the records are too dynamic. You want select distinct if you want each unique product(candidate) to be returned my G.
If you only select the very first record, why would you order it? It's redundant (in this case).

*I can see how it's useful in terms of things with value -_- missing the point though

 

[Ninja Sandwich]

Wow, I'm flabbergasted already, good luck with the candidates, you clearly got A grade students lined up in this thread already lmao. Sorry for hijacking the thread btw.

 

[Senshi]

Bump!

 

[Senshi]

Bump!

 

[Senshi]

Bump!

 

[Senshi]

Bump!