Position Title: Database Specialist/Architect & Administrator
Experience Level: 5+ Years
Work Mode: Remote (Must come to office on-demand basis)
Employment Type: Full-Time
Notice Period: Immediate to 15 days preferred
We are seeking a highly skilled and experienced Database Architect to join our dynamic team. If you are passionate about database technologies and have a proven track record in MySQL and MSSQL, we would love to hear from you.
Job Summary:
As a Database Architect, you will be responsible for designing, implementing, and maintaining robust database solutions that meet the evolving needs of our organization. Your role will involve ensuring the performance, security, and scalability of our database systems while adhering to industry best practices and compliance requirements.
Key Responsibilities:
- Design and develop database architectures that support business requirements and ensure data integrity.
- Create and maintain database models, including conceptual, logical, and physical designs.
- Collaborate with development teams to integrate databases with applications.
- Analyze database performance issues and implement solutions to optimize performance.
- Monitor and tune databases to ensure efficient performance and resource utilization.
- Develop and implement indexing strategies to enhance query performance.
- Implement database security measures to protect sensitive data and ensure compliance with regulatory standards.
- Conduct regular security assessments and audits to identify and mitigate vulnerabilities.
- Develop and enforce database access controls and policies.
- Design and implement scalable database architectures to support growth and high availability.
- Develop strategies for database replication, clustering, and failover to ensure continuous availability.
- Implement disaster recovery plans and conduct regular testing.
- Plan and execute data migration projects to move data between systems without data loss.
- Develop and manage data replication processes to ensure data consistency across multiple databases.
- Provide support for data integration and transformation activities.
- Design and implement data warehousing solutions to support business intelligence and analytics.
- Develop ETL processes to extract, transform, and load data from various sources.
- Ensure data quality and consistency within the data warehouse.
Required Skills and Qualifications:
- Experience: 5+ years of experience in database architecture, with a strong focus on MySQL and MSSQL.
- Technical Skills:
- Proficiency in database designing and modelling.
- Expertise in performance optimization and tuning.
- Strong knowledge of database security and compliance standards.
- Experience with scalability and high availability solutions.
- Proficiency in data migration and replication techniques.
- Knowledge of data warehousing principles and ETL processes.
- Additional Skills:
- Strong analytical and problem-solving abilities.
- Excellent communication and collaboration skills.
- Ability to work independently and as part of a team.
- Strong project management skills with the ability to handle multiple projects simultaneously.
