Do you want to work for one of BC’s Top Employers for 2021 and join an innovative, technology-driven and growth-focused organization?
Systems Ltd. (LandSure) is looking for a Database Administrator to join our team.
Who we are:
LandSure is a subsidiary of the Land Title and Survey Authority of British Columbia (LTSA), a publicly accountable, statutory corporation that manages BC's land title and survey systems. Our team of more than 80 employees supports the LTSA through information system consulting services, project management, customer support, and communications.
We offer meaningful work in the public interest. In support of the Province’s 30-point housing plan, LandSure has helped the LTSA build and launch the Condo and Strata Assignment Integrity Register as well as the Land Owner Transparency Registry, a first-of-its-kind registry.
We offer an innovative, performance-driven culture. We have helped the LTSA become a leader in automated property registration and through technology, we are reducing turnaround time for customers and improving the consistency, accuracy and efficiency of the LTSA’s services. We also build and manage innovative products such as ParcelMap BC and AUTOPROP, which support access to information for the land and real estate sectors.
We offer balance. LandSure provides employees with the ability to work for a stable, independent, values-driven technology company. The environment is entrepreneurial, innovative, and fast-paced yet supportive. Our culture is of mutual respect, constantly improving our professional and personal skills, and celebrating our accomplishments.
Reporting to the Manager, Software Development, the Database Administrator (DBA) will ensure that database management and operations are done in a manner upholding highest industry standards, methodologies, and procedures insuring data integrity and availability while protecting core business activities and databases from service disruption. Candidates must be able to demonstrate outstanding teamwork, communication skills and enthusiasm for making the LTSA a world leader in title registration, survey system management, and land and property-based management systems in general.
DBA will support and manage multiple database environments (Development, Test,
Staging, Production) which includes IBM DB2, MySQL, Postgres and Microsoft SQL Server.
The DBA coordinates
and deploys the release of changes to all database environments and ensures all
database systems are kept current. The DBA is responsible for managing the
performance, health, availability, backup/restore and Disaster Recovery of all
our databases within a mixed Linux and Windows environment.
Key responsibilities include:
- Actively manage the health, performance and support of database systems
- Identify flaws or issues in existing databases and implement improvements
- Monitor and identify costly SQL Statements, analyse and tune execution plans
- Create, review, approve, schedule, and monitor all scripts, queries and database extracts performed on our production environment
- Resolve problems by direct analysis and troubleshooting of our database environments
- Understand database security models and ensure they are implemented and monitored to control access to the data
- Provide occasional off hour system support for deployment and releases
- Provide off hour on-call support as part of a team rotation, as defined by customer business requirements
- Support the management team to set priorities and ensure timely delivery of projects
We encourage you to apply if you have:
Education and Experience
- Bachelor’s degree in Software Engineering, Computer Science or equivalent combination of certification and experience
- Minimum of five (5) years of hands-on experience in the deployment of large (enterprise scale) database environments supporting online business
- Demonstrated experience managing databases in a Linux/Unix/Windows environment
- Hands-on skill and proficiency in problem determination and troubleshooting techniques in a mixed Linux and Windows environment and working with Linux and MS Windows servers
Knowledge, Skills and Abilities
- Specific expertise required:
- Database design and administration on DB2/MySQL/Postgres/MSSQL or equivalent experience with other well-known database systems
- Setup and use of database monitoring tools (e.g. Foglight), and system monitoring tools
- Database performance tuning, SQL tuning and optimization
- High Availability (HA), Disaster Recover (DR) and database replication
- Deploying and installing Databases, software upgrades, patches and fixes
- SQL statement tuning and optimization
- Strong knowledge and understanding of Database systems architecture, schemas, authentication, permissions, tablespaces, buffers/cache, storage, etc.
- Backup and recovery
- Scripting (shell or other)
- Knowledge or experience in ETL processes, data warehouse design and development are an asset
- Cloud knowledge specifically on AWS is an asset
- Demonstrated experience working with complex databases
- Strong communication and interpersonal skills and the ability to work as part of a highly motivated and adaptable team in a complex and changing environment
- Able to manage multiple conflicting priorities, reprioritize tasks, work independently and meet deadlines
- High level of integrity and strong sense of personal responsibility in accomplishing the organization’s goals
- Experience administering, monitoring, consulting, and optimizing highly available NoSQL (e.g., Elasticsearch) databases for mission critical workloads a nice-to-have
The LTSA operates critical systems that underpin BC’s private property market, civil justice system, taxation and Crown land management frameworks. Ensuring we hire properly qualified and suitable candidates is necessary for the programs and activities of the LTSA and LandSure. As part of our hiring process, we will request that a candidate supply certain personal information so that we may conduct identity, reference, education and credential verification, and criminal record checks. Credit bureau inquiry checks may also be conducted for certain positions. As a public body, the LTSA is authorized to collect personal information under section 26(c) of the Freedom of Information and Protection of Privacy Act (FIPPA).