Database Administrator/Architect

1 week ago

Markham, Ontario, Canada PeopleToGo Full time



Job Title: Database Administrator/Architect
Location:
Type: Contract

Our client is currently seeking an experienced Database Administrator/Architect to work out of their Toronto office.

Role:


As a member of the Enterprise Architecture team within Information Services, the Data Base Administrator/Architect is responsible for defining and maintaining enterprise-wide Dbases, data architecture and data governance in order to expand the company's use of data as a strategic enabler of corporate goals and objectives. The DBA/Architect participates in annual strategic planning contributing to the architectural roadmap of the organization. The DBA/Architect will also participate in Project initiatives to provide subject matter expertise as part of design, evaluation, selection and implementation activities.



The DBA/Architect will be required to perform the following tasks as part of role:


§ Design and deploy data architecture


§ Identify improvements to existing databases by determining users' information requirements and system performance and functional requirements;


§ Implement enterprise data architecture and data management processes, procedures


§ Resolve conflicts among users' needs for data;


§ Advise programmers, analysts, and users about the efficient use of data;


§ Generate new database from physical design specifications;


§ Perform or check database sizing results;


§ Develops and implements procedures that will ensure the accuracy, completeness, and timeliness of data stored in the database;


§ Produce and review data architecture related models, documents and other deliverables


§ Develops and implements security procedures for the database, including access and user account management


§ Develops and maintains data dictionaries;


§ Maintains configuration control of the database;


§ Coordinates changes to the database, including the deletion of records, changes to the existing records and additions to the database;


§ Performs updates to the database design;


§ Responsible for implementing database tuning procedures;


§ Develops and coordinates backup, disaster recovery and virus protection procedures.


Qualifications:



§ A minimum of 5 years experience in designing and deploying data architectures (data architecture, data modeling, physical database design, database administration and data warehouses) for business application


§ Experience with business requirements analysis, entity relationship planning, database design, reporting structures, etc.


§ Experience with data modeling tools / techniques and data manipulation languages (Erwin, PL-SQL, XML, etc.).


§ Direct experience in implementing enterprise data architecture and data management processes, procedures, and decision support.


§ Demonstrated expertise with repository creation, and data and information system life cycle methodologies.


§ Experience producing and reviewing data architecture related models, documents and other deliverables.


§ Demonstrated ability to enforce adherence and process improvement to standards.


§ Strong understanding of RDBMS databases such SQL Server and Oracle


§ Understanding of Master Data Management concepts


§ A strong understanding of data-related industry trends, laws and best practice


§ Background in full lifecycle implementation or COTS and/or in-house systems development in the role of developer, analyst or database administrator.


§ Excellent knowledge of Microsoft Office Suite including Word, Excel, and PowerPoint.


§ Working knowledge of Visio, ARIS or other modeling tools desirable.


§ Experience with Business Intelligence, Data Warehouse, Operational Data Stores, Dimensional Modeling skills an asset


§ Financial sector experience (preferably in banking) is considered an asset.


§ Strong interpersonal, written, and oral communication skills.


§ Highly self-motivated and directed, able to manage multiple initiatives, driven by separate senior stakeholders simultaneously.


§ Proven analytical, conceptual and problem-solving abilities.


§ Experience working in a team-oriented, collaborative environment.


§ Able to interact with both Senior IS and Senior Business executives appropriately.



Education / Training:


§ University, college or technical degree in information technology. Alternatively, extensive proven track record in the primary position disciplines within the Financial Sector environment.



Licenses / Certificates:


§ Technical Designations are valued, but not required.


§ ITIL Foundations V3 desirable.

  • Database Administrator

    1 week ago

    Markham, Ontario, Canada Intellifi Full time

    Are you looking to join a company who is committed to investing in technology and is one of Canada's largest mortgage lenders? Are you excited to use your technical expertise to join a technology solutions entrepreneurial start-up within a well- established national financial services organization? Join our growing team of data and analytics staff who truly...

  • Database Administrator

    1 week ago

    Markham, Ontario, Canada Dealer-FX Group Full time

    Overview:_ Who We Are_Since 2007, Dealer-FX has transformed how automotive retailers manage their service operations and interact with consumers. Through advanced data integrations and mobile technology, Dealer-FX streamlines processes and communication for automotive service departments while delivering convenience, transparency, and trust to consumers....

  • Database Analyst

    1 week ago

    Markham, Ontario, Canada InnoVyne Technologies Inc Full time

    Education: Bachelor's degree Experience: 1 year to less than 2 yearsWork setting: Computer hardware or software retailer/wholesaler Research and development institution Internet Service Provider (ISP)Tasks: Collect and document user's requirements Data Science Design and develop database Design, construct, modify, implement and test data models and database...

  • Principal Architect

    1 week ago

    Markham, Ontario, Canada Huawei Technologies Canada Co., Ltd. Full time

    Our team has an immediate permanent opening for aPrincipal Architect.Responsibilities:Analyze the customer's business scenarios and key requirements.Design competitive multi-dimensional database architecture.Responsible for the technical decisions on the entire multi-dimensional database.Ensure the competitiveness of the core architecture and ensure that the...

  • database analyst

    1 week ago

    Markham, Ontario, Canada Starzlink Corporation Full time

    Education: College/CEGEPExperience: 7 months to less than 1 yearTasksOperate database management systems to analyze dataDevelop and implement data administration policy, standards and modelsResearch and document data requirements, data collection and administration policy, and data access rulesDevelop policies and procedures for network access and usage and...

  • Database Services Manager

    1 week ago

    Markham, Ontario, Canada Pet Valu Full time

    Database Services Manager page is loaded Database Services Manager Apply locations 0001 – Markham Office time type Full time posted on Posted 3 Days Ago job requisition id R21202 Location: Markham, OntarioJob Description:Job OverviewA hands-on Manager Database Services who thrives in a dynamic work environment, this role involves leading a database...

  • Clinical Data Architect

    1 week ago

    Markham, Ontario, Canada Astellas Full time

    Astellas Canada – Clinical Data Architect & Engineer At Astellas, we strive to become a cutting-edge, value-driven life science innovator. This means working at the forefront of healthcare change to turn innovative science into VALUE for patients. What sets us apart is our focus on patients, our pioneering innovation, our collaborative culture, and the...

  • Clinical Data Architect

    1 week ago

    Markham, Ontario, Canada Astellas Pharma Inc. Full time

    Job Description Astellas Canada – Clinical Data Architect & EngineerAt Astellas, we strive to become a cutting-edge, value-driven life science innovator. This means working at the forefront of healthcare change to turn innovative science into VALUE for patients. What sets us apart is our focus on patients, our pioneering innovation, our collaborative...

  • Landscape Architect

    1 day ago

    Markham, Ontario, Canada exp Full time

    Landscape Architect, Project ManagerBrampton, ONAt EXP, we're driven to provide innovative solutions for the world's built and natural environments. As a team of engineers, architects, designers, scientists, creators and a community of professionals, we bring diverse and talented people together to solve the world's most complex challenges. Here, you join a...

  • Senior Principal Architect

    1 week ago

    Markham, Ontario, Canada Huawei Full time

    Our team has an immediate permanentopening for aSenior Principal Architect.Responsibilities:Continuously track and analyze emerging technical trends and developments in both industry and academia. Formulate strategic technical plans for the next 2-5 years based on comprehensive insights.Collaborate closely with stakeholders to comprehend their business needs...

  • Senior Principal Architect

    1 week ago

    Markham, Ontario, Canada Huawei Technologies Canada Co., Ltd. Full time

    Our team has an immediate permanentopening for aSenior Principal Architect.Responsibilities:Be able to lead the architecture design of one or more core systems in the big data domainBe able to generate insights from the industry and academic trends of big data analytics, and propose technical strategy androadmapBe able toinfluence stakeholders on technical...

  • Chief Architect – Hardware Acceleration for Big Data

    1 week ago

    Markham, Ontario, Canada Huawei Technologies Canada Co., Ltd. Full time

    Our team has an immediate permanentopening for aChief Architect.Responsibilities:Proactively Analyze Technical Trends:Continuously monitor and analyze technical trends and developments from both industry and academia. Formulate strategic technical plans for the next 2-5 years based on insightful analysis.Architect Innovative Computing Infrastructure:Take the...

  • Proposal Administrator

    1 week ago

    Markham, Ontario, Canada exp Full time

    Proposal AdministratorMarkham, ONAt EXP, we're driven to provide innovative solutions for the world's built and natural environments. As a team of engineers, architects, designers, scientists, creators and a community of professionals, we bring diverse and talented people together to solve the world's most complex challenges. Here, you join a team that...

  • Business Intelligence System Architect

    1 week ago

    Markham, Ontario, Canada Enghouse Systems Full time

    We are seeking a talented and experienced Business Intelligence Systems Architect with expertise in Power BI to join our team. The ideal candidate will play a crucial role in planning, designing, developing, and maintaining our business intelligence solutions to meet the evolving needs of our organization. What you will be doing: Design and implement...

  • Data Architect-Apptio

    1 week ago

    Markham, Ontario, Canada IBM Computing Full time

    IntroductionAt IBM, work is more than a job - it's a calling: To build. To design. To code. To consult. To think along with clients and sell. To make markets. To invent. To collaborate. Not just to do something better, but to attempt things you've never thought possible. Are you ready to lead in this new era of technology and solve some of the world's most...

  • Proposal Administrator

    1 week ago

    Markham, Ontario, Canada exp Full time

    Proposal Administrator**Markham, ONAt EXP, we're driven to provide innovative solutions for the world's built and natural environments. As a team of engineers, architects, designers, scientists, creators and a community of professionals, we bring diverse and talented people together to solve the world's most complex challenges. Here, you join a team that...

  • Petconnect Administrator

    1 week ago

    Markham, Ontario, Canada Pet Valu Full time

    Location: Markham, OntarioJob Description:Job SummaryThe FranConnect (internally referred to as PETConnect) Administrator will need to assist users within FranConnect by handling escalated customer service issues, managing user permissions, creating, and managing reports, and maintaining the customer database. The Administrator must be able to work with...

  • DBA (database administrator)

    1 week ago

    Markham, Ontario, Canada PRO HOST NETWORK INC Full time

    Salary 104,000 annually / 40 hours per week Terms of employment Permanent employment Full time Start date Starts as soon as possible Source Job Bank # OverviewEducationExperience 3 years to less than 5 years Who can apply to this job?Only apply to this job if:You are a Canadian citizen, a permanent or a temporary resident of Canada.You have a valid...

  • Systems Administrator(Azure)

    1 week ago

    Markham, Ontario, Canada Randstad Full time

    Systems AdministratorRandstad DigitalEmployment Type - Permanent Full-timeLocation - Hybrid(3 days a week in office) MarkhamSalary- Negotiable based on experience and qualifications*All applicants must me legally eligible to work in Canada*Systems administrator to be part of a team, responsible for the IT server and storage infrastructure. Be able to support...

  • Lease Administrator

    1 week ago

    Markham, Ontario, Canada BGIS Full time

    Who We AreSUMMARYThe Lease Administrator is responsible for abstracting key information from lease agreements, entering and maintaining the integrity of lease data within the lease management database as well as collecting and paying monthly rental payments on behalf of landlords and tenants.KEY DUTIES & RESPONSIBILITIESLease Abstraction Reviews lease...