Assistant Database Administrator

Job highlights
Identified by Google from the original job post
Qualifications
A valid work permit is necessary in the US/Canada
Bachelor’s degree in Computer Science, related degree, or a combination of equivalent education and experience
Two years of experience with MS SQL Server and SQL applications
Strong interpersonal, verbal, and written communication skills
Ability to work independently while meeting well-defined deadlines
Familiarity with Jenzabar or a similar administrative computing system
Experience writing SQL queries and/or reports
Benefits
Annual Income: $5+K - $6+K
Responsibilities
It offers features such as collaborative coding, real-time multiplayer editing, and the ability to build, test, and deploy directly from the browser
The platform also provides tightly integrated code generation, editing, and output capabilities
The Assistant Database Administrator works closely with the Database Administrator and other UIT professionals, the Assistant Database Administrator performs directed tasks to maintain SQL Server-based applications through script and report development
Perform scheduled transfers of data between servers, automating systems as much as possible
Assist with all software (Jenzabar, PowerFAIDS, etc.) installations, upgrades, and work orders
Accurately assess and assign support calls for Software staff, resolve routine/documented issues
Research and install routine SQL Server service packs as approved by the DBA
Work with Network and Server staff to maintain and continuously improve server resources
Develop, document, and oversee maintenance plans
Reboot or restart services as necessary
Other duties as assigned
Act as backup to the DBA during normal business hours
Assist with continued development & documentation of backup and disaster recovery plans
Serve as technical lead on Strategic Initiatives requiring technology solutions
Develop and deliver documentation and training for all relevant systems
Develop and maintain a hardware/software inventory system
Develop, troubleshoot, and maintain Enterprise Reports using InfoMaker and SQL Server Reporting Services
Develop, and maintain stored procedures, triggers, and batch files
Work with Web Applications staff to develop & maintain internal web-based database applications
Job description
- hybrid Job, 1+ Year Experience

Annual Income: $5+K - $6+K

A valid work permit is necessary in the US/Canada

About us: Patterned Learning is a platform that aims to help developers code faster and more efficiently. It offers features such as collaborative coding, real-time multiplayer editing, and the ability to build, test, and deploy directly from the browser. The platform also provides tightly integrated code generation, editing, and output capabilities.

Description

The Assistant Database Administrator works closely with the Database Administrator and other UIT professionals, the Assistant Database Administrator performs directed tasks to maintain SQL Server-based applications through script and report development. Remote options are available for this position.

Essential Duties and Responsibilities:

Level 1
• Perform scheduled transfers of data between servers, automating systems as much as possible
• Assist with all software (Jenzabar, PowerFAIDS, etc.) installations, upgrades, and work orders
• Accurately assess and assign support calls for Software staff, resolve routine/documented issues
• Research and install routine SQL Server service packs as approved by the DBA
• Work with Network and Server staff to maintain and continuously improve server resources
• Develop, document, and oversee maintenance plans
• Reboot or restart services as necessary
• Other duties as assigned

Level 2
• All Level 1 responsibilities
• Act as backup to the DBA during normal business hours
• Assist with continued development & documentation of backup and disaster recovery plans
• Serve as technical lead on Strategic Initiatives requiring technology solutions
• Develop and deliver documentation and training for all relevant systems
• Develop and maintain a hardware/software inventory system
• Develop, troubleshoot, and maintain Enterprise Reports using InfoMaker and SQL Server Reporting Services
• Develop, and maintain stored procedures, triggers, and batch files
• Work with Web Applications staff to develop & maintain internal web-based database applications

Position Requirements:
• Bachelor’s degree in Computer Science, related degree, or a combination of equivalent education and experience
• Two years of experience with MS SQL Server and SQL applications
• Strong interpersonal, verbal, and written communication skills
• Ability to work independently while meeting well-defined deadlines
• Familiarity with Jenzabar or a similar administrative computing system
• Experience writing SQL queries and/or reports