Backend Developer/Systems Administrator

About PSD CitywidePSD Citywide combines innovative software and comprehensive consulting to not only show our clients the future, but to deliver on it. Our software solutions include three enterprise systems empowering governments to optimize processes, enhance decision-making and improve service delivery, strengthening community sustainability and resilience. Functionally rich, technically advanced and user friendly, PSD's Citywide Enterprise systems are configurable for clients to deal with the current and future needs of an ever-demanding fiscal environment. Our applications are open-source and web-hosted. As we continue to grow our team, we are seeking a full-time BACKEND DEVELOPER / SYSTEMS ADMIN to join our development team. This is a remote based role within Ontario, Canada. Role DescriptionWhile working within a cross-functional development team, you will be responsible for further supporting our applications. As a generalist who loves solving problems, you will play a pivotal role in ensuring the smooth operation of our systems, organizing data and assisting in feature deployments. This multifaceted position requires a strong understanding of system administration and database management. In addition to solid technical skills, we are looking for candidates with strong oral and written communications skills. You must be able to articulate technical solutions to a wide range of audiences. QualificationsUniversity or College degree in Computer Science or Computer Engineering, or related degree/diploma.Minimum of 5 years' experience in system administration including: Shell scripting, Postgres, MySQL; Docker considered an asset.Strong SQL skills; ability to create and modify complex stored procedures and functions.Familiarity with relational databases (e.g., MySQL, PostgreSQL), and proficiency in writing efficient database queries and data manipulation.Experience with backend development; PHP is considered an asset.Experience installing, configuring, and maintaining servers.Experience managing data backups and systems upgrades.Strong attention to detail with the ability to collaborate and problem solve.Excellent problem-solving skills and the ability to work in a fast-paced environment are a must.Good verbal and written communications and knowledge transfer skills. Responsibilities & DutiesOrganize, maintain and rectify client data.Enable/Disable features as requested.Effective knowledge with SQL statements and database development, PL/SQL, stored procedures, creating, and extending functions, scripts and triggers.Develop and maintain database solutions to improve technical implementations for our client base. Participate in a daily scrum and weekly team sprints.Experience working in an Agile project delivery environment, develops and modifies technology systems, addressing functional, performance, security, quality, operational and monitoring needs.Self-motivated; capable of working independently and results focused.Able to work multiple projects simultaneously.Shares knowledge with peers and documents solutions and deliverables.Confident; strong interpersonal and communication (both oral and written) skills. Recruitment ProcessAll resumes will be reviewed for experience working with key technologies. Only those who qualify will be contacted for an initial screening interview. We strive to provide a quick recruitment process, but to find the right candidate for the job the process may take up to a month to complete. We will let the candidates know if we will not be moving them to the next step in the process. Phone InterviewIf you are invited to a screening interview you will discuss your experience with one of our People and Culture team members. This interview is an opportunity to get to know a little more about the company, the type of work we do and the impact we have. Virtual InterviewCandidates invited to a virtual interview will meet with our hiring team and People and Culture. This will allow the candidate to get to know the team as well as learn more about our processes, culture and growth opportunities we have at PSD. During this phase of the interview process the candidate will be given a technical test to complete during the meeting. Why work with us?Employee personal and career growth is important to us, and we will encourage you to pursue the things you care about. We have a mentoring program that matches you with a senior developer for your first three months to ensure you get fully acquainted with our tech. We also encourage continuous learning through a Training & Development program allowing our developers to fully explore their interests and contribute to different product development teams at PSD. Employee Perks Competitive Salaries Full Benefits Package Work from home Relocation Assistance Program Company Matched RRSP Contributions Flex Hours & Paid Time off Social and Charity events and initiatives Ergonomic Workstations PSD Citywide is committed to ensuring equal access and participation for people with disabilities. We believe in integration, and we are committed to meeting the needs of people with disabilities in a timely manner. We will do so by removing and preventing barriers to accessibility.We are committed to accommodating people with disabilities. Accommodations are available upon request for candidates taking part in all aspects of the recruitment and selection process. Should you require any accommodation, please indicate this when you apply, and we will work with you to meet your accessibility needs. IT Services and IT Consulting