SQL Database Administrator

About the position

The position (K0230132) involves designing, implementing, and maintaining new SQL Server databases. Responsibilities include modifying existing databases and database management systems, working directly with programmers and analysts to make necessary changes, testing database-related programs, and correcting errors. The role also requires specifying users and user access levels for each database, designing and maintaining SSIS packages, and managing physical database resources. This includes assisting in installation, performing database software maintenance, and monitoring system resources to ensure continuous database operations. Additionally, the position involves planning and implementing security measures to safeguard information, approving and supervising the installation and testing of new products, and implementing backup and recovery strategies.

Responsibilities

• Design, implement, and maintain new SQL Server databases.
• Modify existing databases and database management systems.
• Work directly with programmers and analysts to make changes.
• Test database-related programs and correct errors.
• Specify users and user access levels for each database.
• Design, develop, implement, and maintain SSIS packages.
• Manage physical database resources including installation and maintenance.
• Monitor database performance and improve performance as necessary.
• Implement, maintain, and test backup and recovery strategies.

Requirements

• High School diploma or GED.
• Valid Driver's License.
• Successful completion of 24 hours in computer science coursework or certification and three years of experience in database programming or system software programming and analysis, or four years of experience in the same fields.
• Experience in Data Analytics, Data modeling, and Data Reporting.
• Strong oral and written communication skills.
• Familiarity with server operating systems and database management.
• Experience in building redundancy, high-availability, and backup for databases.
• Knowledge of database security principles and regulatory compliance.
• Knowledge of T-SQL languages.
• Ability to create and understand database design documentation.
• Knowledge of database manipulation languages and scripting, specifically PowerShell.

Nice-to-haves

• Proficiency in Word, Excel, PowerPoint, and Access.
• Strong proofreading, editing, and attention to detail.

Benefits

• Comprehensive medical, mental, dental, and vision coverage.
• Sick and vacation leave.
• Work-life balance programs including parental leave, military leave, jury leave, and funeral leave.
• Paid state holidays designated by the Governor annually.
• Access to fitness centers in select locations.
• Employee discounts with the STAR Program.
• Retirement and deferred compensation programs.