• Success
    Manage your Success Plans and Engagements, gain key insights into your implementation journey, and collaborate with your CSMs
    Success
    Success Accelerators
    Accelerate your Purchase to Value engaging with Informatica Architects for Customer Success
    My Engagements
    All your Engagements at one place
  • Communities
    A collaborative platform to connect and grow with like-minded Informaticans across the globe
    Communities
    Product Communities
    Connect and collaborate with Informatica experts and champions
    Discussions
    Have a question? Start a Discussion and get immediate answers you are looking for
    User Groups
    Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
    Get Started
    Community Guidelines
  • Knowledge Center
    Troubleshooting documents, product guides, how to videos, best practices, and more
    Knowledge Center
    Knowledge Base
    One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
    Support TV
    Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
    Documentation
    Information library of the latest product documents
    Velocity (Best Practices)
    Best practices and use cases from the Implementation team
  • Learn
    Rich resources to help you leverage full capabilities of our products
    Learn
    Trainings
    Role-based training programs for the best ROI
    Certifications
    Get certified on Informatica products. Free, Foundation, or Professional
    Product Learning Paths
    Free and unlimited modules based on your expertise level and journey
    Experience Lounge
    Self-guided, intuitive experience platform for outcome-focused product capabilities and use cases
  • Resources
    Library of content to help you leverage the best of Informatica products
    Resources
    Tech Tuesdays Webinars
    Most popular webinars on product architecture, best practices, and more
    Product Availability Matrix
    Product Availability Matrix statements of Informatica products
    SupportFlash
    Monthly support newsletter
    Support Documents
    Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
    Product Lifecycle
    End of Life statements of Informatica products
    Ideas
    Events
    Change Request Tracking
    Marketplace
| Sign up

Data Governance & Privacy

Last Updated Date May 25, 2021 |
Stages Data Governance & Privacy Role

The Database Administrator (DBA) in a Data Integration Solution is typically responsible for translating the logical model (i.e., the ERD) into a physical model for implementation in the chosen data storage technology, implementing the model, developing volume and capacity estimates, performance tuning, and general administration of the storage solution.  In many cases, the project DBA also has useful knowledge of existing source database systems. If the solution requires multiple data storage technologies (RDBMS & Hadoop for example) the project may require more than one DBA to cover the skillsets required.   The Project Manager and Data Warehouse Administrator are responsible for ensuring that the DBAs are working in concert toward a common solution.

Responsibilities

  • Plans, implements, and supports enterprise databases
  • Establishes and maintains database security and integrity controls
  • Delivers database services while managing to policies, procedures and standards
  • Tests and implements new technical solutions
  • Monitors and supports the database infrastructure (including clients)
  • Develops volume and capacity estimates
  • Proposes and implements enhancements to improve performance and reliability
  • Provides operational support of databases, including backup and recovery
  • Develops programs to migrate data between systems
  • Works to resolve technical issues
  • Contributes to technical and system architectural planning
  • Supports data integration developers in troubleshooting performance issues
  • Collaborates with other Departments (i.e., Network Administrators) to identify and resolve performance issues

Qualifications/Certifications

  • Experience in database administration, backup and recovery
  • Expertise in database configuration and performance tuning
  • Appreciation of DI tool-set and associated tools
  • Experience in developing and supporting ETL real-time and batch processes
  • Strategic planning and system analysis
  • Strong analytical and communication skills
  • Able to work effectively with both business and technical stakeholders
  • Ability to work independently with minimal supervision
Previous
Next

Table of Contents

Success

Link Copied to Clipboard