Hola;
As you clearly said "not from IT background"....
So- the interaction with the SQL queries (i presume that they are light weight?)
If you are already dealing with complex queries then not on just some one has created if for you and you just execute it on changing some parametes...
/Then/
you have to have the basics of SQL Queries, so the SQL Admin job can be done seamlessly.
SQL DBA is not like a changing the parameter in the config panel and click apply, its really a
lot of risky work.
Say; you- must know and have good hands on below
- creating the basic to complex queries in no time
- make sure the query you create executes with in 5 seconds (in general) on consider you need to improve your execution performance.
- now when you now above two with much more familiarity with thoughts, then you need optimize your query where it do not applies any kind of chronic blocking in the execution.
- killing the locks and releasing the resource from the server memory
- so when the above all is much known to you then jump to indexing- not just how it looks like the word, its a lot work.
- then batching the index process on the table where the fragmentation of the data is more than 10% of the existing data
The above are the basic steps as a DBA does (more to come)
- learn the backup process from scripting and restoring the whole DB or part of it where the main or logical DBF is needed to replace
- Most importantly, understand the execution plan of the queries and you have to take steps where the query is taking maximum resource for executing, and modify such queries for better performence
- knowing when to implement the isolation levels for all DDLs
- high hands on SQL profiler for proper maintenance in the development sever level
- YOU have to know the DTS/SSIS packages for reporting services, creating CUBES (multi dimension data) for mining (in further, you it will just knocks your door)
- transferring the old data from DBs to another DB (archiving) process.
okay- (cutting up here)
now you can call your self as Jr. SQL DBA (under practice)
(only after you know and how the above does)
once you reach this stage, you will be in the stage of knowing further on what to do.
Hope this helps
(All the best, man)