We are seeking an experienced and highly skilled Database Administrator with expertise in data warehousing and API integration to join our team. As a Database Administrator, you will be responsible for the design, implementation, maintenance, and optimization of our company's databases, with a particular focus on data warehousing and seamless API integration. You will collaborate with cross-functional teams to ensure the efficient and secure storage, retrieval, and analysis of data, as well as enable smooth API integration for data exchange and connectivity. Your expertise in these areas will be crucial in ensuring the secure, efficient, and effective storage, retrieval, and exchange of data, supporting our business operations, and enabling data-driven decision-making.

Responsibilities:

• Database Design and Implementation:
  • Design and implement database solutions based on business requirements, considering scalability, performance, and security.
  • Develop data models, database schemas, and data dictionaries for efficient data organization and retrieval.
  • Install, configure, and upgrade database systems and software.
  • Ensure database system availability, integrity, and reliability.
• Data Warehousing:
  • Design, develop, and maintain data warehouse solutions to support reporting and analytics requirements.
  • Implement and optimize Extract, Transform, Load (ETL) processes to populate the data warehouse.
  • Collaborate with data analysts and business stakeholders to define data requirements for the data warehouse.
  • Ensure data quality and consistency in the data warehouse through data cleansing and validation processes.
  • Monitor and tune data warehouse performance to ensure efficient data retrieval and processing.
• API Integration:
  • Integrate databases with external systems and APIs for seamless data exchange and connectivity.
  • Design and develop API interfaces to enable data retrieval, updates, and synchronization.
  • Collaborate with application developers to ensure smooth integration of APIs with database systems.
  • Implement data mapping, transformation, and validation processes for API integration.
  • Monitor and troubleshoot API integrations, resolving any issues or performance bottlenecks.
• Database Administration and Maintenance:
  • Perform regular database monitoring, troubleshooting, and performance tuning.
  • Implement and enforce database security measures and access controls.
  • Plan and execute database backup and recovery procedures.
  • Maintain database documentation, including data standards, procedures, and guidelines.
  • Monitor database system capacity and recommend hardware or software upgrades as needed.
  • Stay up-to-date with industry best practices and emerging database technologies.
• Data Integration and Migration:
  • Collaborate with application developers to ensure seamless integration of databases with applications.
  • Manage data migration projects, including data mapping, validation, and reconciliation.
  • Develop and maintain data integration processes between various data sources and target systems.
  • Ensure data consistency and integrity during the data migration process.
• Performance Monitoring and Optimization:
  • Monitor and analyze database performance metrics to identify and resolve performance bottlenecks.
  • Optimize database queries, indexes, and data structures for improved performance.
  • Recommend and implement  database performance tuning strategies.
• Backup, Recovery, and Disaster Planning:
  • Develop and implement backup and recovery strategies for databases and associated systems.
  • Test and validate database backups and recovery procedures.
  • Implement disaster recovery plans and perform regular drills.
• Database Security and Compliance:
  • Implement and enforce data security measures, including user access controls and data encryption.
  • Monitor database systems for potential security vulnerabilities and implement appropriate patches and upgrades.
  • Ensure compliance with data protection regulations and privacy requirements.
• Collaboration and Documentation:
  • Collaborate with cross-functional teams to understand data requirements and provide database solutions.
  • Document database configurations, changes, and procedures.
  • Provide technical guidance and support to developers and end-users regarding database-related issues.

Requirements:

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• Proven experience as a Database Administrator, with a focus on data warehousing  and API integration.
• Strong knowledge of database management systems, concepts, and best practices.
• Proficiency in SQL and experience with database query optimization.
• Experience with data warehousing concepts, ETL processes, and data integration tools.
• Familiarity  with API design and integration principles.
• Strong understanding of database security principles and data protection regulations.
• Excellent problem-solving and troubleshooting skills.
• Strong attention to detail and organizational abilities.
• Effective communication and collaboration skills.
• Knowledge of data governance and data quality management practices.
• Familiarity with cloud-based database technologies.

The Detroit Employment Solutions Corporation (DESC) is an Equal Opportunity employer committed to enhancing equity, inclusion, and diversity within our organization. DESC actively seeks applications from women, persons of color, veterans, individuals with disabilities, and other underrepresented groups.