Senior Database Engineer

Job Description Seeking a Database Architect to design and develop efficient, scalable, and secure database systems. The role requires hands-on experience in building new relational data models and ensuring rigorous testing and high availability of databases. What You'll Do • Design and develop database systems with a focus on efficiency, scalability, and security • Determine appropriate database architecture, data storage, and indexing techniques • Collaborate with software developers and system administrators to meet performance and scalability requirements • Analyze organizational data needs and identify the most suitable database systems • Design and implement database structures ensuring data security and integrity • Manage back-end data integration and architecture including dimensional data modeling and ETL development • Lead DB migration projects, specifically Oracle to SQL Server • Design and maintain High Availability (HA) and Disaster Recovery (DR) options for SQL Server • Develop and maintain DB deployment strategies across various environments • Focus on designing and maintaining data warehouses and large-scale data repositories • Implement solutions for managing data in the cloud, especially on AWS RDS • Ensure data security by implementing protocols such as encryption and access controls • Automate regular processes, track issues, and document changes etc. What You'll Need • 5+ years of experience in designing and developing database systems • Extensive experience with Oracle to SQL Server migration • Proficiency in DB deployment strategies and maintenance • Experience in back-end data integration and architecture • Knowledge of AWS RDS for hosting and managing databases • Experience with Windows server and Active Directory • Ability to implement security protocols and ensure data accuracy • Experience in working on AWS RDS • Knowledge of data security protocols such as encryption and access controls • Familiarity with automating regular processes