SQL Server Database Administrator

Job Title : SQL Server Database Administrator (695041)

Location : Kennesaw, GA 30144 Hybrid

Long-Term

This position will replace an employee on FMLA, and will be the primary SQL DBA.

Duties and Responsibilities:

• 35% - Maintain the Microsoft SQL environments within UiTS, including but not limited to: installation, upgrades, and patches to all Microsoft SQL instances; ensuring proper security levels are maintained; tuning; cloning; and day-to- day maintenance to ensure a high level of reliability and stability.

• 15% - Document and implement procedures for database backup and recovery using various technologies.

• 15% - Develop, maintain, and implement procedures to guarantee the accuracy, accessibility, and responsiveness of the database environment, ensuring optimal database performance and availability, including the identification, analysis, and resolution of complex database issues.

• 10% - Provide assistance to application developers in the effective use of database query and programming languages and work with other department personnel to ensure all activities associated with the Microsoft SQL Server databases function smoothly and efficiently.

• 15% - Serve as a resource on a variety of database integration issues, including migration between disparate databases, data conversion, capacity planning, and new application deployments.

• 5% - Maintain documentation including data dictionaries and data flow diagrams as well as any documentation to meet departmental and audit requirements.

• 5% - Other duties as assigned.

Key Responsibilities:

• Provides support for assigned enterprise applications and their respective databases

• Primarily Production with some Test and Development

• Provide functional and technical support for end-users of the assigned enterprise applications, including but not limited to: applying upgrades and patches, ad-hoc querying, data manipulation and managing end user service tickets.

• Perform troubleshooting and resolution of system issues and providing functional level support to campus end-users.

• Serve as the liaison between functional users and technical support staff.

• Maintain records and documentation to meet departmental and audit requirements.

• Creation of user accounts, assigning security access, and annual review of user accounts to ensure compliance to audit standards.

Knowledge/skills/abilities

• Successful track record as a SQL Server DBA.

• Ability to maintain OLTP databases. (i.e. installation; upgrades/patches; tuning; cloning; backup/recovery)

• Knowledge of query languages such as T-SQL and SQL

• Knowledge of Personally Identifiable Information (PII) data security standards. (i.e. FERPA and HIPPA)

• Knowledge of system and application security threats and vulnerabilities (e.g., buffer overflow, mobile code, cross-site scripting, SQL injections, race conditions, covert channel, replay, return-oriented attacks, malicious code).

• Knowledge of data backup, types of backups (e.g., full, incremental), and recovery concepts and tools.

• Experience and knowledge in code migrations, database changes, enforcement of the data integrity

• Experience and knowledge with application security management.

• Excellent communication skills, verbal and written

Skills:

SQLDBA,T-SQL,Azure,Powershell