SQL Server/GIS Administrator (Technology Engineer)
Job ID: 13618
Agency: Bureau of Information and Telecommunications/Data Center/Technical Administration
Salary: $25.89 - $33.24, depending on experience
Closes: 02/26/2020
This is a full-time position with the Bureau of Information and Telecommunications. For more information on the Bureau of Information and Telecommunications, please visit https://bit.sd.gov/.
The position will be responsible Microsoft SQL Server on-premises implementations, GIS server administration, and Microsoft AzureDB implementations.
The Ideal Candidate Will Have:
A degree in computer science, networking, or a related field and several years of experience is preferred. Technology engineering level assignment will be determined by the education and experience of the incumbent. The ideal candidate will also have experience with data architectures, database design, and database development; stored procedures and views; backups, restores, and other DB maintenance tasks; database connectivity; database tuning and optimization; SQL Server security.
Knowledge of:
- Windows Server operating systems;
- SQL Server performance and tuning;
- SQL Server integration services;
- SQL Server reporting services;
- Microsoft Visual Studio (VB.net and\or C#);
- SQL Server operational activities (backup\recovery, DBMS maintenance);
- data center automation techniques.
Skill to:
- communicate effectively with fellow IT staff on complex technology solutions;
- develop Visual Studio applications;
- manage Windows Server;
- work with application development;
- trouble shoot problems.
Additional Preferred Skills (training will be provided on these if absent):
- ARCGis Server administration;
- Microsoft AzureDB administration;
- SQL Server Business Intelligence technologies;
- Internet Information Server basics.
Ability to:
- develop SQL jobs for data exports, data purges, and error monitoring;
- investigate and resolve SQL job failures (typical SQL jobs could be for ETL processes or for data integration);
- develop internal automation procedures for the data center to enable seamless process in IT operations;
- use SQL Server performance analysis tools to improve TSQL query performance;
- develop complex TSQL queries;
- research, evaluate and recommend new technology solutions;
- develop Microsoft Visual Studio applications.
VETERANS' PREFERENCE ELIGIBLE
Successful applicant(s) will be required to undergo a background investigation. An arrest/conviction record will not necessarily bar employment.
The State of South Dakota does not sponsor work visas for new or existing employees. All persons hired will be required to verify identity and eligibility to work in the United States and complete an Employment Eligibility Verification, Form I-9.
The State of South Dakota offers paid employee health insurance plus ten paid holidays, generous vacation leave accrual, and medical, dental, vision, and other benefits. For more information please visit https://bhr.sd.gov/job-seekers/work-for-state-government/. This position is a member of Class A retirement under SDRS.
South Dakota Bureau of Human Resources
500 East Capitol
Pierre, SD 57501-5070
Telephone: 605.773.3148 Fax: 605.773.4344
"An Equal Opportunity Employer"