Details: A Remote Database Architect & Administrator position is currently available at Belcan. This is a 3-6 month contract position with the possibility to extend. The database architect is a skilled professional who designs and oversees the development of database systems that efficiently store, manage, and organize data. They play a crucial role in determining the structure, security, and performance of databases to meet the needs of organizations. Database Architects collaborate with IT teams, data analysts, and software developers to ensure data integrity, availability, and optimal performance. This role will also perform typical SQL server database administration functions, with the responsibility for the administration, monitoring, and troubleshooting of a database system’s servers and infrastructure. You will need to have a strong understanding of Microsoft SQL servers, Windows servers, related hardware and software, and the technical and programming requirements for building database applications and architecture. You will also need to be able to work well across functional teams. JOB DUTIES: *Database Design: Design and create database systems that align with organizational needs, considering data relationships, schemas, and integrity. *Data Modeling: Develop data models, entity-relationship diagrams, and data dictionaries to define the structure and relationships within the database. *Database Security: Implement security measures, access controls, and encryption protocols to safeguard sensitive data. *Performance Optimization: Optimize database performance by designing efficient query structures, indexing strategies, and database partitioning. *Scalability Planning: Plan for database scalability by designing architectures that can handle increased data volumes and user loads. *Backup and Recovery Planning: Develop strategies for data backup, disaster recovery, and business continuity to ensure data availability. *Database Migration: Plan and execute database migration projects, ensuring smooth transition between different database systems or versions. *Data Integration: Integrate databases with other systems, applications, and data sources to facilitate data sharing and synchronization. *Data Governance: Establish data governance practices, including data quality, metadata management, and data lifecycle management. *Collaboration: Collaborate with development teams, data analysts, and stakeholders to understand requirements and ensure database solutions meet business goals. *Database Administration: Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems. *Database Configuration: Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security. *Database performance tuning. *Database Troubleshooting: Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end. *Database Environment Support: -Provide support for critical production systems. -Perform scheduled maintenance and support release deployment activities after hours. *DBA team growth: Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members. REQUIRED QUALIFICATIONS: Education and Experience: *A bachelor’s or master’s degree in computer science, information technology, or a related field is typically required. *Relevant work experience in database architecture, database administration, or related roles is highly beneficial. *Database Management Systems: Proficiency in database management systems such as SQL Server, Oracle, MySQL, PostgreSQL, NoSQL databases, etc. *Data Modeling Tools: Experience with data modeling tools
PostgreSQL database-partitioning Data Analyst Computer Science database-management Microsoft SQL Server Oracle database-security data-modeling database-design data governance Information technology (IT) data-integration Administrator Collaboration SQL NoSQL MySQL Windows Server