Database Administrator

POSITION - DATABASE ADMINISTRATOR

LOCATION - 555 RICHMOND STREET WEST (primarily)

Kindly note that we are temporarily operating via a hybrid model of in-office and remote work

**YES believes that employment is empowerment and is the cornerstone of safe and healthy communities. YES leads the Canadian youth sector with innovative programs that empower disadvantaged and vulnerable youth to become self-sufficient contributing members of society.**
- **Main Duties**_
- Implement/maintain databases. Provide advice on database management standards, procedures, techniques
- Stay abreast of key industry and technology trends and provide thought leadership throughout the organization.
- Develop and recommend options for database structure, standards for data management.
- Monitor the performance of the database and modify its structure to ensure accuracy and effective level of service in data collection and reporting.
- Ensure integrity by performing back-ups, restore and recovery procedures.
- Design database structure and data management, including definition, organization, protection and management of data.
- Prepare detailed documentation of design and specifications; developing plans for testing, implementation and evaluation; and ensuring that testing of all development is carried out
- Prepare materials to support implementation and ongoing use of database, including design and development documentation, manuals and training for users, and developing procedures for database control and maintenance - user access and security procedures.
- Provide technical consultation and support to program teams to ensure optimal database design and the benefits of database technology is achieved.
- Install, test and customize software products, providing training regarding data availability, data entry, data retrieval and database concepts and to provide advice to users on technical and operating problems.
- Identify and act on opportunities to improve and update software and systems
- Maintain database and design to ensure appropriate managers and staff can select from a menu of options regarding reports.
- Perform database and basic information system administration, developing data management guidelines for use/maintenance of databases to ensure information security, accessibility, database complies with YES standards, policies and guidelines.
- Supports YES values, fosters a team-building environment, represents organization in a professional manner
- Prepares for and actively participates in all staff meetings
- Adheres to YES policies/procedures and confidentiality on all matters, including client, personnel, financial

**Qualifications**
- Mandatory skills/experience: Microsoft access, Microsoft SQL server, visual basic programming, VB script and VBA. Generating reports with Crystal Reports. Developing macros with VBA.
- At least 3 years of experience with Microsoft Access and Microsoft SQL Server.
- Strong experience in managing Windows server environments: managing AD, DNS, RD Gateway, and Group Policies.
- Proficient with Networking concepts including: firewalls (Cisco ASA), switches/routers/WiFi equipment, telephone equipment (Avaya); knowledge of TCP/IP (subnets, ports), SSL
- Knowledge and experience of Microsoft Azure Cloud - SharePoint, Exchange, Teams, etc.
- Experience and abilities with Windows Development VB.NET, Crystal Reports and databases.
- Proficiency and experience in development with MS SQL Server and Access. Ability to build SQL queries in order to conduct analysis and troubleshooting.
- Working knowledge of HTML and MySQL. Experience working with a Content Management System (CMS) - WordPress, etc.
- PC hardware, Printers, scanners, computer peripherals.
- Education: Degree in computer science or related field.

**Job Contact Information**:
**Salary Range**: $65,000 - $70,000

Accommodation will be provided in all parts of the hiring process as required under the YES Accessibility policy. Applicants need to make their needs known in advance.

We thank all applicants. Only those selected for interviews will be contacted. YES is an equal opportunity employer.

It is a condition of employment that all new employees must declare their Covid-19 vaccination status prior to the first day of employment.

**Salary**: $65,000.00-$70,000.00 per year

**Benefits**:

- Dental care
- Extended health care

Schedule:

- Monday to Friday

Application question(s):

- Will you be able to reliably commute to 555 Richmond Street West?

**Experience**:

- Microsoft SQL Server: 3 years (preferred)
- Microsoft Access: 3 years (preferred)

Work Location: Hybrid remote in Weston, ON M5V 1Y6