NATION

PASSWORD

Looking for new Tech Staff - Database Administration

Bug reports, general help, ideas for improvements, and questions about how things are meant to work.
User avatar
Sedgistan
Site Director
 
Posts: 36225
Founded: Oct 20, 2006
Anarchy

Looking for new Tech Staff - Database Administration

Postby Sedgistan » Mon Oct 21, 2024 12:42 am

What we are Looking For

Earlier this year we added to our Technical team to address a lack of frontend development staff. This is round two of recruitment this year, now focused on database administration.

NationStates has very large amounts of data stored in MySQL, and a high rate of queries. This is an opportunity for a tech person to be involved a high level with all of the decision-making and administration involved in using data at scale, from table schema design and query optimization to backup and disaster recovery. You would begin as a Technical Moderator, with a pathway to rise to full Admin.

If the challenge of rebuilding database tables after a crash makes you feel warm and fuzzy inside, or you love optimizing the tiniest queries to squeeze nanoseconds worth of performance out of a server, you might have what it takes!

We're looking for somebody with significant expertise with databases, especially MySQL. Any knowledge of or ability to pick up some Perl is a plus. And if you have other skills you can contribute, great! Feel free to send in an application!

How to Apply:

We are only taking applications for this role, not nominations. If you are interested in applying, please contact us via Getting Help Request.

Supporting information on your skills is essential, as well as letting us know what you think you could achieve in the role. Ideally please link to projects or a GitHub profile. We understand that some code mostly in their profession, so this is not always possible - but if you do have a GitHub profile, please add it. If accepted to the team, GitHub is mandatory in order to contribute to the source code.

FAQs:

What's the deadline for applying?
There is no particular deadline for applications - when we are no longer looking, this announcement will be taken down.

How many people are you looking for?
We do not have a target for a number of people to take on - it depends on the applications that come through. The end result could be no-one is brought on board, or multiple people are.

I have some blemishes on my Moderation record. Can I still apply?
Yes. This is considered as part of the Moderator team review, and we consider the "whole person," not isolated instances of misbehavior alone.

I've heard you all use Discord to communicate. I don't have it, can I still apply?
No. The team utilizes Discord extensively in day-to-day communication, and it is critical that new technical moderators have access to the rest of the team while learning the codebase.

Please feel free to ask any other questions you have in this thread, but do not use it for applications/nominations.

User avatar
Killercrocs
Civilian
 
Posts: 1
Founded: Nov 22, 2024
Inoffensive Centrist Democracy

Postby Killercrocs » Thu Dec 05, 2024 10:18 pm

back buster

User avatar
Valentine Z
Postmaster-General
 
Posts: 14260
Founded: Nov 08, 2015
Scandinavian Liberal Paradise

Postby Valentine Z » Fri Dec 06, 2024 5:39 am

Typically for my applications I tend to keep it private, but thought I would ask for this one. So I applied for this one a month ago or two, does the news announcement mean you're still looking for more? Or the applicants submitted so far being... inadequate?
Last edited by Valentine Z on Fri Dec 06, 2024 5:43 am, edited 2 times in total.
If you are reading my sig, I want you to have the best day ever ! You are worth it, do not let anyone get you down !
Glory to De Geweldige Sierlijke Katachtige Utopia en Zijne Autonome Machten ov Valentine Z !
(✿◠‿◠) ☆ \(^_^)/ ☆

Issues Thread Photography Stuff Project: Save F7. Stats Analysis

The Sixty! Valentian Stories! Gwen's Adventures!

• Never trouble trouble until trouble troubles you.
• World Map is a cat playing with Australia.

User avatar
Sedgistan
Site Director
 
Posts: 36225
Founded: Oct 20, 2006
Anarchy

Postby Sedgistan » Fri Dec 06, 2024 5:52 am

We only received four applications (yours included) in the month and a bit after posting the thread, so figured we needed a News post too to get it more attention. We haven't made any decisions on any applications yet.

User avatar
Valentine Z
Postmaster-General
 
Posts: 14260
Founded: Nov 08, 2015
Scandinavian Liberal Paradise

Postby Valentine Z » Fri Dec 06, 2024 6:01 am

Sedgistan wrote:We only received four applications (yours included) in the month and a bit after posting the thread, so figured we needed a News post too to get it more attention. We haven't made any decisions on any applications yet.

That's fair enough, no worries. ♥ To be clear I did not mean inadequate in terms of quality, but of quantity too so.. that answered that.
If you are reading my sig, I want you to have the best day ever ! You are worth it, do not let anyone get you down !
Glory to De Geweldige Sierlijke Katachtige Utopia en Zijne Autonome Machten ov Valentine Z !
(✿◠‿◠) ☆ \(^_^)/ ☆

Issues Thread Photography Stuff Project: Save F7. Stats Analysis

The Sixty! Valentian Stories! Gwen's Adventures!

• Never trouble trouble until trouble troubles you.
• World Map is a cat playing with Australia.

User avatar
Zzznxz
Political Columnist
 
Posts: 2
Founded: Aug 24, 2023
Scandinavian Liberal Paradise

Postby Zzznxz » Fri Dec 06, 2024 6:09 am

If your dataset is small enough to fit in RAM
https://yourdatafitsinram.net/
I don't think it would qualify as very large amounts of data.

User avatar
National Coraland of Fishery
Envoy
 
Posts: 241
Founded: Nov 12, 2022
Democratic Socialists

Postby National Coraland of Fishery » Sat Dec 07, 2024 10:02 am

Sedgistan wrote:-snip-

What is the population requirement/Nationstates experience is expected?
Last edited by National Coraland of Fishery on Sat Dec 07, 2024 10:03 am, edited 1 time in total.
The Island Paradise and Aquarium Zoo of Fishery
"When the sun comes up...I couldn't tell where heaven stopped and the Earth began."
Current Parliament Member and Citizen of The Region That Has No Big Banks, Former Lt Gov of Covenant Shores, Former Founder and Sec of Law of The Global Union Consr, Former Vice President of Gravy

User avatar
United Calanworie
Technical Moderator
 
Posts: 5179
Founded: Dec 12, 2018
Democratic Socialists

Postby United Calanworie » Sat Dec 07, 2024 2:22 pm

National Coraland of Fishery wrote:
Sedgistan wrote:-snip-

What is the population requirement/Nationstates experience is expected?

As with most things, it depends. We’re probably not going to appoint somebody who joined yesterday, but if there’s a player out there who joined last year and happens to be a DBA for NASA, maybe we’d be interested.
@queerlyfe | She/Her/Hers
Getting Help Request (GHR) | One Stop Rules Shop (OSRS) | Routine Actions thread | NS Announcements Discord
Script Rules | API Documentation | Approved Image Hosts | How Bots are Regulated | NS Coders Discord

"...against all enemies, foreign and domestic..."
You are such a crybaby [...] all you do is lock threads and be a bitch to people, nobody likes you, you aren’t cool, you lock every thread for stupid reasons, often times not giving a reason, [...] all you do is sit on your computer all day on NationStates, locking threads at a rate 5x higher than any other mod [...] stop trying so hard to impress people, literally nobody like you.
Have a good day

User avatar
Hindu Ram Rajya
Political Columnist
 
Posts: 5
Founded: Jan 24, 2020
Father Knows Best State

Postby Hindu Ram Rajya » Sun Dec 08, 2024 3:06 am

whats the comp or benefits though?

User avatar
Waterfall State
Envoy
 
Posts: 238
Founded: Aug 07, 2019
Democratic Socialists

Postby Waterfall State » Sun Dec 08, 2024 3:09 am

Hindu Ram Rajya wrote:whats the comp or benefits though?


I am pretty sure moderation/admin is a volunteer thing
Insert useless statement here about my opinions being my own etc that is ignored by others when convenient

User avatar
Refuge Isle
Technical Moderator
 
Posts: 2592
Founded: Dec 14, 2018
Left-wing Utopia

Postby Refuge Isle » Sun Dec 08, 2024 2:38 pm

Hindu Ram Rajya wrote:whats the comp or benefits though?

None of us are paid, if that's the question.

The moderator badge blocks ads though. :blush:

User avatar
Zzznxz
Political Columnist
 
Posts: 2
Founded: Aug 24, 2023
Scandinavian Liberal Paradise

Postby Zzznxz » Fri Dec 20, 2024 7:52 pm

United Calanworie wrote:
National Coraland of Fishery wrote:What is the population requirement/Nationstates experience is expected?

As with most things, it depends. We’re probably not going to appoint somebody who joined yesterday, but if there’s a player out there who joined last year and happens to be a DBA for NASA, maybe we’d be interested.


Well finding DBAs with that level of experience for no money and that much free time; your best bet is finding the kid of a DBA for NASA who is able to bounce ideas off said parent. As good table and index design is 90% of performance/reliability and proper stored procedure engineering is something they would have access to.

User avatar
Decacon
Secretary
 
Posts: 27
Founded: Aug 09, 2012
Democratic Socialists

Postby Decacon » Sat Dec 21, 2024 3:39 pm

Zzznxz wrote:
United Calanworie wrote:Well finding DBAs with that level of experience for no money and that much free time; your best bet is finding the kid of a DBA for NASA who is able to bounce ideas off said parent. As good table and index design is 90% of performance/reliability and proper stored procedure engineering is something they would have access to.


It's possible someone would do it just to support the wider NS community. People are capable of altruism. :p
First President of Frontier Europeia
Former Chairman of Region Inc

User avatar
Haku
Technical Moderator
 
Posts: 284
Founded: Jan 02, 2018
Compulsory Consumerist State

Postby Haku » Sat Dec 21, 2024 3:55 pm

We're pleased to announce that Stoklomolvi has joined the team as a result of this process!
Last edited by Haku on Sat Dec 21, 2024 3:55 pm, edited 1 time in total.

User avatar
Dackians
Civil Servant
 
Posts: 9
Founded: Aug 24, 2024
Moralistic Democracy

Postby Dackians » Sun Dec 22, 2024 5:26 pm

United Calanworie wrote:
National Coraland of Fishery wrote:What is the population requirement/Nationstates experience is expected?

As with most things, it depends. We’re probably not going to appoint somebody who joined yesterday, but if there’s a player out there who joined last year and happens to be a DBA for NASA, maybe we’d be interested.

What if I joined 4 months ago roughly? Would that be ok? :?:

User avatar
Refuge Isle
Technical Moderator
 
Posts: 2592
Founded: Dec 14, 2018
Left-wing Utopia

Postby Refuge Isle » Sun Dec 22, 2024 5:29 pm

Dackians wrote:
United Calanworie wrote:As with most things, it depends. We’re probably not going to appoint somebody who joined yesterday, but if there’s a player out there who joined last year and happens to be a DBA for NASA, maybe we’d be interested.

What if I joined 4 months ago roughly? Would that be ok? :?:

You're welcome to apply, we're unlikely to accept.

User avatar
Aleator
Political Columnist
 
Posts: 5
Founded: May 16, 2016
Father Knows Best State

Postby Aleator » Mon Dec 23, 2024 11:12 am

Would've loved to join your team a number of years ago, before I lost my entire card collection to some users who don't play fair :( Haven't really been playing since then, because losing ~2 years of progress was too much of a hit for me and decimated my interest in this otherwise wonderful game.
I hope you do manage to find a good enough specialist. Glad you've already found people for front-end!

User avatar
The Otaku Shire
Political Columnist
 
Posts: 3
Founded: Jan 07, 2025
Democratic Socialists

Postby The Otaku Shire » Tue Jan 07, 2025 9:24 pm

Zzznxz wrote:
United Calanworie wrote:As with most things, it depends. We’re probably not going to appoint somebody who joined yesterday, but if there’s a player out there who joined last year and happens to be a DBA for NASA, maybe we’d be interested.


Well finding DBAs with that level of experience for no money and that much free time; your best bet is finding the kid of a DBA for NASA who is able to bounce ideas off said parent. As good table and index design is 90% of performance/reliability and proper stored procedure engineering is something they would have access to.


I am a kid(mid 30s) of a senior systems admin red hat linux database administrator. Dad didn't work for NASA but yea. I have exp as US Army DoD power gen mech (electrical+mechanical engineer) and a BA in software engineering (autodesk to unreal pipeline). I am OOP trained and versitile in C/C++, with design dev exp in HTML and Java.

I am a bit overqualified, and looking for MySQL exp to add in refs to portfolio so maybe one day I can actually get a stupid job in crap industries that req 2-15years exp on shipped title/reffable projects.

My newest NS state is brand new, but some years ago I did try running a separate one for a short period.

Anyway, if you're still looking for people to help, I could help. And, I have relivant loose tho actually some DBA analyist education w-e. Least more so than anyone else will provide you for free.

PS post edit
As to knowledge/exp
I know what NAND opperands are and how to use such in table management query. Good luck finding that elsewhere.
Last edited by The Otaku Shire on Tue Jan 07, 2025 9:38 pm, edited 2 times in total.

User avatar
Stoklomolvi
Technical Moderator
 
Posts: 2372
Founded: May 02, 2007
New York Times Democracy

Postby Stoklomolvi » Wed Jan 08, 2025 2:13 am

Haku wrote:We're pleased to announce that Stoklomolvi has joined the team as a result of this process!


Belated thank you for the opportunity!
Demonym: Stoklomolvi
Stoklomolvi Liaoist Federation
Factbook -- Interpol -- Liaoism (old) -- News Agency (old) -- Commerce Comissariat -- Minyang
Defensive Preparedness: 1 | 2 | 3 | 4 | 5 | 6
Nuclear Launch Protocol: А | Б | В | Г | Д
Leader: Commissar Vladimir Mikhailovich Stuyonovich

User avatar
Sel Appa
Diplomat
 
Posts: 995
Founded: Nov 21, 2004
Inoffensive Centrist Democracy

Postby Sel Appa » Mon Jan 20, 2025 7:16 pm

Stoklomolvi wrote:
Haku wrote:We're pleased to announce that Stoklomolvi has joined the team as a result of this process!


Belated thank you for the opportunity!

Awesome!!!! Congrats! o/ o/ o/
Celebrating 20 years of Sel Appa!
NationStates General: You will never find a more wretched hive of scum and villainy. We must be cautious.
Remembering 21c: A real-life nation simulation!
Sel Appa on IIWikiThe Turtle Times


Advertisement

Remove ads

Return to Technical

Who is online

Users browsing this forum: No registered users

Advertisement

Remove ads