How can a Database Administrator collaborate with other departments?

In business we must identify the users and their roles. According to the roles we must grant the access to them. Post covid working from home has been increased many fold that increased the surface area of attacks. It's good to follow standards and policies.

Es importante segmentar los usuarios que pretenden acceder a los datos evaluando previamente sus necesidades, de ahí se puede tomar una decisión del nivel de acceso, a cuáles entidades podrán acceder, edición de datos si es permitida y períodos de tiempo definidos.

Having a variety of data access options is pivotal to ensuring a happy user base. We have been able to accomplish this in 4 ways: The ability to view it data (1) through our application, (2) through the ability to download the data, (3) through an API, and (4) through PDF generated reports has all given users a variety of access points to the data. Each user is different and understanding HOW they want to view the data is as important as WHAT they want to view. While it does require more work to maintain, offering many options to view data will increase the user base and their happiness.

Las vistas sobre tablas simplifican y aseguran que se respete el esquema ya definido, permitiendo consultas más seguras. Querys programas que ayuden a realizar respaldos son una ventaja, ya que permiten que el mismo sistema haga las copias de datos en otras tablas cuando la necesidad lo amerite.

Primordial hoje os dados é o ouro de todas as empresas, o segredo de cada negócio. Domine os dados e dominará seu negócio em todos os sentidos

Primordial hoje os dados é o ouro de todas as empresas, o segredo de cada negócio. Domine os dados e dominará seu negócio em todos os sentidos

Es importante que el departamento informático que esté a cargo del almacenamiento y estructura de las bases de datos comunique a todos las demás ramas de la organización lo que se considere oportuno en relación a cómo se guardan sus datos, en qué proyectos o entidades se alojan los datos así como también bajas del sistema de cara a mantenimiento. Todo se debe comunicar en un lenguaje entendible para los demás usuarios, tomando en cuenta que quizás muchas personas no manejen la terminología técnica y el glosario asociado.

DBA’s are NOT the center of the universe. They are a valued part of a much bigger picture. Without stakeholders, Engineering, and many other departments, there would be no software applications, and therefore little to no need for said DBA’s. This is coming from someone with 26 years of DBA experience. Clear, concise communication with wide open channels is beyond critical for the overall success of any organization. Assumptions kill.

Todo dato tiene un nivel de sensibilidad y si es alto es más exigente su tratamiento, cada empresa puede definir una norma sobre esto pero también puede haber reglamento de orden gubernamental, el cual se debe cumplir para almacenar, compartir o destruir la información.

This is an essential skill not only for a DBA but for any employee. Always seek out ways that processes can improve! Continuous improvement accomplished many things, such a the following: 1) Creating a culture of continuous adaptability and improvement. 2) Engages the DBA in other departments he or she may not otherwise communicate with. 3) Open opportunities of integrations and potentially reduce redundancy. In larger organizations, it’s not uncommon for entire departments to not be aware of resources, such as data in a database, that are available to them. The more a DBA can be involved in every facet of a business, the more integrated the database can be, leading to a more well rounded data management plan and architecture.

This is a practice everyone is the organization must follow. We must sit together in a meeting and discuss the project and provide the inputs that will help us to build the project in a best way possible including the best security aspects. We must work on SIPs. Automate wherever its needed. Build the reports. Rescue redundancy. It's very common that the database and its design will be understand by everyone in the organization so it's always to get DBA onboard in meetings.

Communication should be continuous when it comes to feedback from users of the database. There are a variety of ways to achieve this: 1) Hold regular office hours where users of the database can come with questions, feedback, recommendations, etc. 2) Host info sessions, monthly or quarterly, about the database, including topics such as how to appropriately access the data, what improvements are coming down the line, or the latest practices in database management and security. 3) Host a feedback portal online so users can ask questions and request improvements. 4) Host an internal facing site that contains information about the database outlining any recent changes or updates to the architecture.

Make and maintain an ERD! It is an excellent communication tool that can inform Data Analysts and Data Sciences on how the data is related within the database. It can reduce a significant amount of headache - coworkers can take a brief look at the diagram and know immediately what to query instead of trying to navigate tables and see the connections through trial and error.