IT Database Architecture Specialist

Job Summary:

We are seeking an experienced IT Database Administrator to play a key role in designing, building, and operating a robust data architecture that supports the growth of our company and enables new business capabilities.

Responsibilities:

• Collaborate with IT and business teams to understand and define data-related problems, identify and meet data structure and storage requirements, and maximize data value.
• Design and implement database structure, architecture, and platforms that effectively support the needs of the company.
• Develop and refine standards, processes, procedures, and guidelines for database environments using industry experiences, best practices research, and business needs.
• Stay current with emerging technologies and advancements in data management and warehousing.

Data Governance:

• Partner with internal teams to design data management and governance protocols, manage the information lifecycle, design infrastructure, and data integration controls.
• Develop and implement data security policies, procedures, and best practices to protect sensitive information and meet compliance objectives.
• Collaborate within the business on the design of data capture, validation, and structures for maximum data quality and reuse.
• Contribute to data standardization, data strategy, governance, and change management.

Database Management:

• Design, configure, implement, and maintain databases and supporting architecture.
• Monitor database performance, and conduct regular maintenance, tuning, and optimization.
• Monitor and manage the performance, availability, and reliability of critical data services.
• Review and manage ETL processes to ensure optimization and best practices.
• Develop, implement, and maintain database backup and recovery strategies to ensure data reliability and minimize downtime.
• Identify and resolve database performance issues, such as slow queries, inefficient indexing, or resource contention.
• Conduct database capacity planning to anticipate future storage and performance needs.
• Implement and maintain database monitoring tools to proactively identify and resolve issues.
• Participate in data mapping, integrations, and migrations between transactional systems in support of ongoing operations, systems implementations, mergers, and acquisitions.
• Contribute to the overall master data architecture and management in a multi-system environment.
• Create and maintain comprehensive documentation of data architecture and systems, including schema, configurations, and standard operating procedures.
• Build, maintain, and publish data architecture and database specifications, schemas, and technical documentation.
• Generate regular reports on database performance, usage, and security compliance for management and stakeholders.

---