Database Administrator
City of Maple Ridge
Date: 3 weeks ago
City: Maple Ridge, British Columbia
Contract type: Full time
Database Administrator 1 POSITION OVERVIEW
We have an exciting opportunity in our Information Technology Department for a Database Administrator 1. Reporting to the Manager of Business Solutions you will be responsible for planning, designing, developing, installing, monitoring, maintaining and optimizing the City’s corporate database systems. You will also be responsible for developing short and long-term strategies for data management, maintenance, environment growth, and the implementation of new technologies such as MS Azure DBaaS. You will be working with a variety of internal and external stakeholders on the delivery of business technology solutions, performing tests and evaluations to maintain the technical performance of database systems, and identifying, planning and executing upgrades to database systems when replacing aging business solutions.You will also periodically check to ensure adequate resources such as disk space, memory, CPU, etc. are properly allocated, and request and recommend changes as needed to obtain desired performance levels. Maintain test\development\staging database instances from production so they represent accurate environments. Compile and maintain documentation, diagrams, specifications, etc. about existing and proposed database environments.You will work closely with other IT Team members, to identify, implement, and support the use of database related technologies or solutions. Assist other IT staff in activities related to data modelling or development to ensure optimized design concepts, data consistency, security and adherence to privacy policies. EDUCATION AND EXPERIENCE Bachelor’s degree in Computer Science including or supplemented by courses in database management and administration plus sound related experience preferably in a municipal environment; or an equivalent combination of training and experience. KNOWLEDGE, SKILLS AND ABILITIES Thorough knowledge of problem definition and analysis related to business processes and systems planning.Considerable knowledge of the principles and techniques associated with database fundamentals, including administration, development, and design and management.Considerable knowledge in establishing standards, procedures and policies that ensure the integrity, security, availability and recovery of all data resources.Considerable knowledge of the operating techniques and procedures used in server installations and upgrades and computer installation.Considerable knowledge of the operations and functions of departments served and their requirements as applied to the work performed.Ability to analyze and evaluate data requirements and to prepare recommendations regarding the advisability and feasibility of incorporating changes or additions to the corporate data model.Ability to prepare detailed designs for all databases including physical and logical data structures, and to control shared usage of data throughout the corporation to maintain optimal performance.Ability to read and understand computer programs combining creativity with technical and analytical elements with a focus on continuous improvement.Ability to establish and maintain effective working relationships with a variety of contacts and to provide advice and assistance on matters related to the work.Ability to communicate effectively orally and in writing. EQUITY STATEMENTAt the City of Maple Ridge, we are dedicated to cultivating an inclusive culture that actively values and embraces diversity. We strive to attract and retain a talented, diverse workforce that is broadly reflective of the community we proudly serve. Accommodations are available on request for candidates taking part in all aspects of the selection process by contacting [email protected]. WHAT WE OFFER YOU:The City of Maple Ridge is a great place to work with competitive compensation packages that include the Municipal Pension Plan, a strong employee wellness program and the opportunity for professional career growth and professional development. If you want to help shape a growing community in a municipality that strives for service excellence, then this is the position for you. We thank all applicants for their interest, however, only those under consideration will be contacted.
We have an exciting opportunity in our Information Technology Department for a Database Administrator 1. Reporting to the Manager of Business Solutions you will be responsible for planning, designing, developing, installing, monitoring, maintaining and optimizing the City’s corporate database systems. You will also be responsible for developing short and long-term strategies for data management, maintenance, environment growth, and the implementation of new technologies such as MS Azure DBaaS. You will be working with a variety of internal and external stakeholders on the delivery of business technology solutions, performing tests and evaluations to maintain the technical performance of database systems, and identifying, planning and executing upgrades to database systems when replacing aging business solutions.You will also periodically check to ensure adequate resources such as disk space, memory, CPU, etc. are properly allocated, and request and recommend changes as needed to obtain desired performance levels. Maintain test\development\staging database instances from production so they represent accurate environments. Compile and maintain documentation, diagrams, specifications, etc. about existing and proposed database environments.You will work closely with other IT Team members, to identify, implement, and support the use of database related technologies or solutions. Assist other IT staff in activities related to data modelling or development to ensure optimized design concepts, data consistency, security and adherence to privacy policies. EDUCATION AND EXPERIENCE Bachelor’s degree in Computer Science including or supplemented by courses in database management and administration plus sound related experience preferably in a municipal environment; or an equivalent combination of training and experience. KNOWLEDGE, SKILLS AND ABILITIES Thorough knowledge of problem definition and analysis related to business processes and systems planning.Considerable knowledge of the principles and techniques associated with database fundamentals, including administration, development, and design and management.Considerable knowledge in establishing standards, procedures and policies that ensure the integrity, security, availability and recovery of all data resources.Considerable knowledge of the operating techniques and procedures used in server installations and upgrades and computer installation.Considerable knowledge of the operations and functions of departments served and their requirements as applied to the work performed.Ability to analyze and evaluate data requirements and to prepare recommendations regarding the advisability and feasibility of incorporating changes or additions to the corporate data model.Ability to prepare detailed designs for all databases including physical and logical data structures, and to control shared usage of data throughout the corporation to maintain optimal performance.Ability to read and understand computer programs combining creativity with technical and analytical elements with a focus on continuous improvement.Ability to establish and maintain effective working relationships with a variety of contacts and to provide advice and assistance on matters related to the work.Ability to communicate effectively orally and in writing. EQUITY STATEMENTAt the City of Maple Ridge, we are dedicated to cultivating an inclusive culture that actively values and embraces diversity. We strive to attract and retain a talented, diverse workforce that is broadly reflective of the community we proudly serve. Accommodations are available on request for candidates taking part in all aspects of the selection process by contacting [email protected]. WHAT WE OFFER YOU:The City of Maple Ridge is a great place to work with competitive compensation packages that include the Municipal Pension Plan, a strong employee wellness program and the opportunity for professional career growth and professional development. If you want to help shape a growing community in a municipality that strives for service excellence, then this is the position for you. We thank all applicants for their interest, however, only those under consideration will be contacted.
See more jobs in Maple Ridge, BC