Database Analyst (Modeller, DBA)

15
Nov

Database Analyst (Modeller, DBA)

  • Contract
  • Toronto
  • Posted 1 month ago

JO2444: Database Analyst

Anticipated Duration: 1 year

Duration of Potential Extension: 12 Months and 6 Months

Project Location: Toronto, Ontario

Hourly Rate: must not exceed $80 CAD.

Description of Assignment

The Database Analyst will analyze business transformation requirements; analyze business processes and legacy systems; design, implement, and maintain database systems; perform data modelling, data integration and synchronization; and monitor and resolve data or database issues. The specialist will identify and recommend opportunities for better utilization of technologies to improve business process and efficiency, and to improve data governance to better comply with corporate privacy and security rules.

The specialist will require extensive experience with data modelling and database systems, Oracle database administration, NoSQL and big data techniques, Cloud platform and security, data integration and synchronization.

The key credentials of the specialist include:

  • Experience in data modelling and database design
  • Experience in RDBMS such as Oracle 12c and SQL Server 2014+
  • Experience in data integration and synchronization
  • Familiarity with temporal data management, big data, NoSQL, Cloud Computing databases

Qualifications       

  • 10 years of experience in information management with a focus on design and modelling of database systems, database administration, and data integration and synchronization
  • 3 years of experience in designing conceptual, logical, and physical data models (CDM/LDM/PDM)
  • 5 years of experience as a professional Oracle DBA with a deep understanding of data storage, encryption, partitioning, replication, backup, recovery, system monitoring and logging, performance tuning, and RAC
  • 3 years of experience designing and developing data integration solutions using package software such as Informatica, Oracle Streams or GoldenGate
  • Deep understanding of different types of Oracle database objects including tables / views /materialized views, indexes, partitioning, keys, stored functions / procedures and packages
  • Experience in data conversion, data cleansing, data masking, de-identification and encryption methodologies
  • Experience with data privacy and security management, database performance design best practises
  • Experience in modern software development methodologies and processes such as Agile, CI/CD and DevOps
  • Experience with or knowledge of AWS environments, AWS RDS, AWS Aurora, and NoSQL such as Hadoop, MongoDB, DynamoDB, as asset
  • Excellent organizational, interpersonal, problem solving, verbal and written communication skills with a strong focus on customer service
  • BS in Computer Science, Information Management, Software Engineering, STEM major, or related discipline or equivalent experience

Technical Capabilities:

  • Data Modelling techniques and tools such as ERwin, ER/Studio, PowerDesigner
  • Oracle, MySQL, SQL Server; SQL, SQL:2011, PL/SQL, T-SQL
  • Data integrations using tools such as Informatica, Oracle Streams or GoldenGate
  • Unix/Linux, Shell scripting, SAN storage
  • MongoDB, Hadoop, AWS, AWS RDB, AWS Aurora, RedShift, DynamoDB

Assignment Duties

  • Identify and analyze business strategies, processes and practices in the context of evolving business, information, security, application, and technology architecture
  • Perform requirements and system analysis, including analysis of legacy systems
  • Design and implement database solutions to meet architecture quality attributes for availability, capacity, performance, scalability, and security
  • Develop conceptual, logical, and physical data models for relational and non-relational databases
  • Ensure database solutions meet data security and compliance requirements
  • Provides technical database administration services for multi-database environment both on-premise and in the cloud
  • Create technical system documentation including data models, systems designs and operational support documents.
  • Work with developers for platform selections, database design, SQL programming, and technical guidance
  • Work closely with development teams to ensure data or database issues are addressed in a timely manner to minimize disruption
  • Design and implement data purge / archive policy and procedure
  • Work closely with the application development team to support development efforts
  • Provide daily operational support of the database systems including problem resolution, configuration and patch management
  • Recommend improvements around database support processes, procedures, and tools, Provide strategies and solutions for automated management and monitoring of the database and transaction processing environments.
  • Liaison with database vendors on issues such as software upgrades, compatibility concerns, issue troubleshooting and solution
  • Perform routine maintenance including monitoring, backups, managing disk space, and maintaining database objects
  • Create, test and maintain database objects in development, QA, acceptance, and production servers
  • Clone and refresh databases between environments and ensure proper data masking is applied
  • Monitor, evaluate, troubleshot, and resolve issues related to database performance
  • Participate in change management processes including deploying database changes in various environments manually or using scripts from Git
  • Promote and enforce change management guidelines and procedures
  • Meet with users for clarification and elaboration as may be necessary to clearly define a problem and conceptualize a development plan
  • Recognize, gather, correlate, and analyze facts, draw conclusions, define problems, and devise solutions and alternatives and make appropriate recommendations
  • Identify risks, issues and constraints associated with database solutions and designs
  • Ensure the delivered mission critical system is highly performing, secure, and scalable
  • Promote, support and maintain a culture of compliance, ethics and integrity
  • Stay abreast of, research and test emerging technologies in the area of data and database management, and recommend infrastructure changes to improve operating efficiency
  • Promote modern software development methodologies such as Agile, CI/CD and DevOps
  • Contribute to the ongoing team development by sharing knowledge, information and lessons learned
  • Perform other duties as required by the projects

Deliverables

  • Data and database architecture based on business requirements, non-functional requirements, corporate I&T strategies and directions, security and privacy compliance, and industrial best practices
  • Database design and data modeling
  • System analysis report, detailed designs and technical specifications
  • Conceptual, logical and physical data models
  • Security and privacy compliance guidelines and best practices
  • Database refactoring
  • Design strategies to accommodate application performance requirements
  • Database installation and configuration
  • Administration of development, QA, acceptance, and production databases
  • Database replication
  • Database change promotions
  • Database performance tuning and troubleshooting
  • Data conversion, data cleansing, data masking, de-identification and encryption
  • Strategy of data synchronization and data integration
  • Data integration and synchronization among various systems
  • Strategy of digital transformation and application modernization
  • Cloud migration strategies for databases
  • Cloud based integration architecture and solution
  • Security model for Cloud based data integration
  • Re-engineering, enhancement or replacement of business rules and associated technologies
  • Mentorship, knowledge sharing and transfer

Job URL: https://01millennium.com/jobs/database-analyst-modeller/

Data Modeller

 

 

Apply Online