Database Developer

About PSD

PSD 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 process, 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 Database Developer to join our IT team. This is a remote based role.

Job Description

 PSD Citywide is looking for a talented Database Developer with administration experience to join our team of technology professionals. 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 (Team, Customers and Financial Consultants).

Responsibilities & Duties

• Develop, analyze, implement and optimize database stored procedures and functions with MS SQL Server using T-SQL and Oracle using PL/SQL (we need professional work experience)
• Create and optimize database queries, database objects (i.e. tables, views, indexes, etc) and work with application developers to design/maintain database scripts according to custom features
• Hands-on database troubleshooting experience.
• Monitoring, tuning, and optimizing database performance.
• Good knowledge of database backups and restores
• Performing our application installation tasks, upgrades, migrations, and patching
• Creating and extending custom import and export scripts and other custom database add-ins that provide extended features to our application users.
• Maintain technical documentation for connection procedures, installations, custom code description, etc
• Participate in a daily scrum and weekly team sprints.
• Other duties as assigned.

Qualifications

• The qualified candidate must have a minimum of 3-5 years of hands-on experience in both Oracle & SQL Server database administration including maintenance, troubleshooting and support; understanding of Oracle (10 and above) and SQL Server (SQL Server 2012, and above).
• Familiar with Windows operating systems, tools, and architecture as they relate to supporting database environments.
• Strong SQL skills: ability to create and modify complex stored procedures and functions.
• Familiar with other operating systems such as Linux and Unix.
• Self-motivated; capable of working independently and results focused.
• Able to work multiple projects simultaneously.
• Shares knowledge with peers and documents solutions and deliverables.
• Excellent problem-solving skills and the ability to work in a fast-paced environment a must.
• Confident; strong interpersonal, communication (both oral and written) and client-facing skills.
• Committed to providing excellent customer service.
• Built and deployed Docker containers would be considered an asset.
• Apache Tomcat knowledge would be considered an asset.
• Java/Java Swing knowledge would be considered an asset.
• IntelliJ IDEA and other enterprise software development tools would be considered an asset.

Recruitment Process

All 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 Interview

If you are invited to a screening interview you will discuss your experience with one of our HR team members. This interview is an opportunity to get to know a little more about the company, the type of work we do and impact we have.

Virtual Interview

Candidates invited to a virtual interview will meet with our hiring team and HR. 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.

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 is an equal opportunity employer. We are committed to providing accommodations for 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.