Database Architect

The Company:

3DR Laboratories provides post processing services to hundreds of hospital radiology departments, stand-alone imaging centers and radiology practices enabling them to obtain expert processing of their medical imaging cases within hours or even minutes for emergencies. 3DR Labs is open 24 hours per day and 7 days a week. We never close.

Visit us online at https://3drlabs.com to learn more about us.

We are searching for a Database Architect to join our technology team.

This is a remote/virtual role. We are open to candidates from the following states where we already have established operations: AL, AR, AZ, FL, GA, IA, IL, IN, KS, KY, LA, MI, MS, NE, OH, OK, OR, PA, SC, SD, TN, TX, UT, WA, WI, WV.

Summary: The Database Architect is responsible for creating, administering, and troubleshooting databases that process large amounts of information and keep it secure. Their duties include using code and web architecture to design data systems, analyze, maintain existing databases, and implement new user features.

Essential Duties and Responsibilities:

Database Management Systems (DBMS): Create, manage, monitor, maintain, and optimize specific database systems like MySQL, PostgreSQL, SQL Server

Database Design: Design, implement, and maintain databases to ensure data integrity, availability, and security. Build conceptual, logical, and physical data models to meet business needs and application development.

Collaboration: Work with cross-functional teams to understand requirements and develop scalable solutions.

Performance Tuning: Optimize performance through indexing, normalization, query optimization, and tuning.

Data Security: Apply database security principles and best practices to ensure data confidentiality, integrity, and availability. This includes but is not limited to encryption strategies.

DevOps: Utilize knowledge of DevOps tools and practices to build, configure and monitor infrastructure.

• Infrastructure as Code for automating the provisioning and configuration of database infrastructure, ensuring consistency and reproducibility.
• Continuous Integration/Continuous Deployment (CI/CD) for setting up CI/CD pipelines for database schema changes and data migrations and automating testing and deployment processes..
• Monitoring and log aggregation to provide insights on database performance and troubleshooting.
• Version control to control and track changes to schemas as well as database and pipeline.

Backup and Recovery:

• Maintain and optimize existing backup solutions while proposing, designing, and implementing new backup and recovery strategies to safeguard critical data and ensure business continuity.
• Perform regular backups and disaster recovery planning to safeguard critical data. Utilize backups and/or automation to periodically refresh test and staging environment DB’s

Scripting and Automation: Utilize scripting languages (e.g., SQL, Python, PowerShell) to automate routine tasks and database maintenance.

Availability and Disaster Recovery: Maintain and optimize replication (master-master, master-replica, master-relay-replica), clustering, and failover techniques to ensure high availability and disaster recovery.

Compliance and Governance:

• Apply knowledge of common regulatory requirements (e.g., GDPR, HIPAA) and data governance frameworks for ensuring data compliance.
• Build familiarity with internal data governance policies and provide regular feedback on changes necessary to maintain compliance with external data use, cloud readiness, disaster recovery etc.

Documentation: Documenting database configurations, procedures, and creating reports for stakeholders.

Data Modeling: Design conceptual, logical, and physical data models to support application development.

Data Warehousing: Develop and implement data warehousing solutions to support business intelligence and reporting needs using knowledge of data warehousing concepts, ETL (Extract, Transform, Load) processes, and dimensional modeling for building data warehouses and data marts. Create, deploy and maintain a functioning data warehouse that will regularly ingest data from an OLTP source DB into the OLAP warehouse DB

Big Data Technologies: Clean refine and curate large volumes of structured and unstructured data, collected from various application sources for management, use, and analysis inside or outside the organization, using big data technologies such as Azure Data Lake, Azure Blob storage, AWS S3, NoSQL etc.

Data Integration: Integrate data from disparate sources, i.e. databases, APIs, files, and streaming data sources.

Master Data Management (MDM): Analyze business data common across departments and applications and propose a roadmap and plan for implementing a master data management solution to manage and govern master data across the enterprise.

Cloud Computing: Apply expertise in cloud-based data platforms (e.g., Azure, AWS, Google Cloud) and services for building scalable and cost-effective data solutions.

Knowledge, Skills, and/or Abilities Required:

• Bachelor’s degree in computer science, Information Technology, or related field.
• Proven experience as a Postgres, SQLServer, and/or MySQL Database Administrator (prefer all three) and NoSQL solutions such as MongoDB or Cassandra.
• In-depth knowledge of database architecture, administration, and performance tuning.
• Experience with Devops tools like Ansible, Vagrant, Azure Resource Manager, Terraform, or AWS Cloud Formation for creation of on-prem or cloud iaC pipelines for automation of database infrastructure deployment and configuration.
• Familiarity with database schema migration patterns and experience setting up and performing database migrations via tools such as Entity Framework CLI, Flyway, TypeORM CLI, etc.
• Strong understanding of data warehousing concepts and methodologies surrounding operational datastores (ODS), data warehouses, and datamarts and their roles in a data warehouse architecture
• Understanding of OLTP and OLAP databases, concepts, and differences.
• Experience with conceptual architecture and logical, physical modeling and implementation of data warehouse solutions for performant consumption by analytics and reporting tools such as PowerBI
• Experience with ETL and pipeline orchestration tools such as SSIS, Azure Data Factory, Stitch, Panopoly, Talend, Kafka, Airflow etc. and their use in extracting data and loading it into the ODS, data warehouse, or datamarts
• Experience with replication techniques such as master-slave and master-master replication and their implementation in production system.
• Experience on an MDM project involving master data identification, cleansing, distribution, and update.
• Experience leveraging cloud environments, databases, and tools such as:
• Amazon Web Services (AWS): Amazon RDS, Amazon Redshift, Amazon S3
• Microsoft Azure: Azure SQL Database, Azure Data Factory, Azure Databricks, Azure Synapse Analytics, Azure Data Lake
• Proficiency with scripting languages (i.e., PowerShell, Python, Perl) using them for automation tasks.
• Proficiency in SQL scripting and database management tools.
• Proficiency in using Git for version control.
• Familiarity with microservice architectures and their implications on physical/logical database design

Preferred Qualifications:

• Certification in Postgres, MySQL, and/or SQL Server database administration or related field.
• Experience working in hybrid cloud environments and contributing to hybrid cloud transitions.
• Experience with cloud data management and governance tools such as Informatica, Collibra, etc.
• Experience using containerization technologies such as Docker and Kubernetes

EEO

We’re an equal opportunity employer. All applicants will be considered for employment without attention to race, color, religion, sexual orientation, gender identity, national origin, age, veteran status, or disability status. We require an inclusive environment free from discrimination and harassment.