WHAT DOES A DATABASE MANAGER DO?
Published: October 11, 2024 - The Database Manager leads a team of engineers to design, develop, and maintain software that supports a large sharded production database environment with high uptime requirements. This role focuses on evolving operational practices to enhance efficiency and resilience while collaborating with development teams to drive investments in database infrastructure. Additionally, the Database Manager is responsible for overseeing the Asset Management database and ensuring the seamless integration and functionality between TF Cloud and the Council's finance system.
A Review of Professional Skills and Functions for Database Manager
1. Database Manager Duties
- Database Management: Develop a technical understanding of the capabilities and limitations of the current database, managing the vendor(s) as appropriate and acting as the main point of contact for all database-related issues.
- Data Flow Management: Manage daily data flows within the database and between the database and other systems.
- Cross-Team Collaboration: Work across teams to identify data collection points and improve the quality and accuracy of manual and automated data flows into the database.
- External Team Management: Manage the external data research team and the collection of industry information and contacts to feed into the database.
- Marketing Collaboration: Work with the marketing department on appropriate data categorization (based on marketing needs and extraction of data).
- Subscription Management: Work with the subscriptions department on appropriate data categorization and related access levels concerning individual/corporate access/accounts.
- External Engagement: Engage external data collection/research agencies to generate new names for marketing targeting, using a combination of desktop research and phone-based research.
- Database Accuracy: Ensure the accuracy of the database at all times, eliminating duplicates at both individual and site levels.
- Continuous Improvement: Initiate ideas to constantly improve the collection, storage, and usage of data.
- Protocol Establishment: Establish rules and protocols regarding data collection that are adhered to across the business.
- Compliance Management: Maintain adherence to data protection and security protocols, as laid down by global GDPR and local data privacy requirements.
2. Database Manager Details
- Data Architecture: Lead initiatives to design and build data storage/data lakes, APIs, information dashboards, and other end-user information portals or resources.
- Database Design: Design and develop databases for the capture and retrieval of complex data and metadata.
- AI & ML Development: Develop technical tools and programming that leverage artificial intelligence, machine learning, and big-data techniques to cleanse, organize, and transform data, and to maintain, defend, and update data structures and integrity on an automated basis.
- Integration Development: Develop capability to integrate public database query outputs into Plexium informatics workflows.
- Design Standards: Create and establish design standards and assurance processes for software, systems, and applications development.
- Vendor Management: Source and manage interactions with software service providers to meet data user needs.
- Database Implementation: Design and implement exploration and operations databases and workflows.
- Quality Assurance: QA/QC and report on analytical and other data sets to the senior geoscience team.
- Data Management: Generate and run queries, reports, and validation scripts to maintain the integrity of all data.
- Collaboration: Work with site personnel to ensure the capture of relevant new and historic information to facilitate the generation of geological and resource models.
- Data Auditing: Audit site data entry and data import processes to ensure the timely availability of data and share best practices across the organization.
3. Database Manager Responsibilities
- Database Development: Ensure the database is developed according to project requirements.
- Database Design: Define, design, and build complex dimensional databases.
- Performance Management: Maintain database performance by troubleshooting problems.
- Standards Enforcement: Maintain database results by setting and enforcing standards and controls.
- Data Security: Ensure the data is backed up, secured, and protected.
- Security Installation: Ensure the installation of security software as needed.
- DBMS Management: Install and upgrade the DBMS Server.
- Disaster Recovery: Create disaster recovery plans and manage data backup and recovery operations.
- Data Recovery: Ensure data recovery and backup using RMAN, Flash-Back Recovery, and other software.
- System Upgrades: Accomplish platform upgrades and improvements by supervising system programming.
- Policy Development: Develop policies, procedures, and controls to secure the database.
- Regulatory Compliance: Ensure compliance of the data with legal regulations.
- Performance Monitoring: Monitor database performance, upgrade, and update database systems and software.
4. Database Manager Accountabilities
- Database Solutions: Provide database solutions and monitor data entry procedures.
- Capacity Planning: Prepare reports on database scalability and capacity planning.
- Stakeholder Engagement: Work with stakeholders to understand specific database needs and upgrade and update the databases to meet ongoing requirements.
- Database Management: Ensure database management and maintenance tasks are performed effectively.
- Project Reporting: Provide regular updates to management on database project status.
- Application Maintenance: Maintain applications running on Windows/UNIX platforms, IIS/Apache/WebSphere web and application servers, and SQL Server/Oracle databases and other environments.
- Database Updating: Keep the proprietary property database updated by liaising with brokers and landlords for the latest intel on property, leases, and availabilities.
- Report Support: Support brokers in the creation of reports (short lists, long lists) and inspection packs.
- Technology Advocacy: Represent the local brokerage team as a technology user champion, streamlining and consolidating feedback from brokers on tech needs back to the regional technology team (JLLT).
- Technology Partnership: Partner with JLLT to understand the basics of technology and current capabilities, and help educate brokers on how to incorporate tech and data to create a differentiated experience for clients.
- Best Practices Advocacy: Advocate for best practices and standardized business processes to drive data quality and completeness in the market intelligence platform.
- Training Coordination: Attend regional training sessions led by JLLT, translate the information back to the team locally, and serve as the first point of contact for brokers on tech-related queries.
- Onboarding Support: Ensure that new brokers are brought up to speed and adopt JLL’s single operating system.
5. Database Manager Functions
- Team Leadership: Leading a team of engineers to design, write, and ship software that manages a large sharded production database environment with high uptime requirements.
- Operations Improvement: Evolving operations practices, improving efficiency, and ensuring services are resilient and scalable to meet high uptime requirements.
- Communication Skills: Communicating with all levels of the organization, from engineers to vice presidents.
- Collaboration: Partnering closely with development teams to support new product features and drive investments in the database infrastructure.
- Cloud Transition: Working to transition services into public cloud platforms as part of the strategic roadmap.
- Database Development: Responsible for the development of the Asset Management database for the Property and Facilities Management Departments (Asset Management).
- System Integration: Responsible for developing and maintaining the functionality between TF Cloud and the Council's finance system (Agresso), including the preparation of service charge accounts.
- System Maintenance: Responsible for maintaining the Council's Property Asset Management System (TF Cloud) and Finance system (Agresso) on behalf of the statutory compliance manager and other team members as appropriate.
- Data Collection: Responsible for Asset Management data collection.
- Data Analysis: Responsible for Asset Management data analysis to support major estate strategy decision-making.
- System Improvement: Maintain TF Cloud and be responsible for its improvement to reflect changing requirements and corporate developments.
- System Updates: Update TF Cloud to reflect changes in land ownership, leasing, and assets.