· Job Description:
Conceptualizes designs, develops, integrates, deploys and maintains the data layer and data components by applying specialized knowledge of information, data and database management disciplines to provide world-class solutions for our clients. Ensures organizational and team member success by applying knowledge of high performance team techniques, coaching techniques, mentoring models and collaboration strategies to work collaboratively as a member of a high performance team and to provide coaching/ mentoring to other team members as appropriate. Collaborate across business units to enhance knowledge of data engineering capability and information management and to increase intellectual capital by applying knowledge of data engineering management strategies and tools, communities of learning, delivery organizations and knowledge management tools, to contribute to the continuous enhancement and communication of the information management body of knowledge. Develops the data components of application solutions by applying knowledge of service offerings, capabilities, innovation, sales pursuit strategy, and data engineering solutions best practices to collaborate with the solution development team and the client to develop winning solutions that ensure win rates, margins and revenues are improved.
Participates in or leads a Data Engineering Team supporting one or more application projects. Works collaboratively with the Application team, including architects, developers and testers, to ensure project success. Engage and collaborate with the infrastructure DBA teams to ensure delivery of DB infrastructure components. Ensure integration of DE deliverables with other project deliverables. Collaborates with the Application Project manager to plan and manage the DE activities and deliverables. Coaches less experienced DE team members. Participates in discussion with customers and peers to collect and analyse data requirements.
Contributes significant, new and innovative ideas to the DE knowledge base. Active participant in one or more DE communities. Regularly contributes to discussions, forums and knowledge base. Provides input and advice to peers, management and customers in relation to data engineering principles, technologies, methods and best practices, within areas of expertise.
Participates in solution development for small/ medium deals. Participates in client meetings and presentations. Assists Data Architect or DE Leader develop solutions by documenting components of the solution, defining deliverables and preparing estimates. DBA: Plans and Leads database development and maintenance of databases including:
· Design database environments and databases.
· Design, develop, modify, test, release/ deploy and maintain database objects.
· Design database objects and supervise develop, modify, test, release/ deploy and maintain by other DBAs.
· Design, develop, modify, test, release/ deploy and maintain database security and audit solutions design, develop, modify, test, release/ deploy and maintain database recovery solutions.
· Execute database and data recovery.
· Manage database performance, capacity and availability.
· DBMS SW implementation, upgrade, patching.
Utilizing best practices, work plans, checklists and defined processes. Proactively supports application teams. Performs SQL tuning. Provides advice on application data issues.
Participates in project technical reviews. Leads work product reviews. Develops and maintains database support documentation. Designs database monitoring solutions and assists others in monitoring and proactively anticipating or identifying issues.
Takes ownership of complex database incidents and problems and provides resolutions in a timely manner. Engages SMEs or vendors to provide assistance to resolve more complex incidents as required. Data Analyst: Produce and maintain logical and physical data models for databases and projects. Participates in the development and maintenance of enterprise data models for less complex enterprises. Participates in formal Data Modelling Reviews. May lead reviews of simple data models. Assist business and technical personnel in data analysis activities including using SQL queries. Performs Model Conversion (data mapping) to produce a data dictionary and data mapping matrix between the external software and the internal database for business function replacement. Performs in data quality analysisdata profiling, to produce a data quality assessment (and baseline). Designs Data Transformation Strategies for Business Intelligence or Data Migration.