We are seeking a highly skilled Database Architect with extensive experience in Database Development and Database Design to join our dynamic team. The ideal candidate should have a strong foundation in SQL Server Development, coupled with a solid understanding of Database Administration. This role will involve leading database development initiatives, ensuring best practices, and mentoring junior developers. You will play a critical role in shaping the database architecture, optimizing queries, and implementing effective database solutions in alignment with business goals.

Key Responsibilities :

Database Development & Design :

- Lead the design, implementation, and maintenance of efficient database structures and data models.

- Work closely with cross-functional teams to design scalable, high-performance databases.

- Review and optimize database schema, relationships, and structures for improved performance.

SQL Server Development :

- Design and write complex T-SQL queries, stored procedures, and triggers to support application development.

- Implement performance tuning and query optimization techniques.

- Develop and maintain ETL processes to ensure data accuracy, transformation, and loading from multiple sources.

Database Administration :

- Assist in the overall administration of SQL Server databases, including installation, configuration, patching, and upgrades.

- Implement backup, restore, and disaster recovery strategies for databases.

- Monitor and troubleshoot database issues, ensuring minimal downtime and high availability.

Team Leadership & Mentoring :

- Lead a team of database developers, providing guidance on best practices and technical expertise.

- Collaborate with developers and stakeholders to translate business requirements into robust database solutions.

- Ensure that junior developers follow coding standards and practices.

Data Security & Compliance :

- Enforce data security measures, ensuring that sensitive data is properly handled and compliant with regulatory standards.

- Implement user roles, permissions, and auditing within SQL Server to control access.

Collaboration & Stakeholder Management :

- Collaborate with project managers, architects, and stakeholders to gather requirements and deliver database solutions that align with business objectives.

- Prepare and deliver presentations on database solutions and best practices

Performance Optimization :

- Continuously evaluate and optimize database performance by identifying and resolving bottlenecks and improving query performance.

- Use tools like SQL Profiler, Execution Plans, and Indexing Strategies to enhance database performance.

Documentation & Reporting :

- Create detailed documentation on database designs, structures, and processes.

- Provide regular status reports to leadership regarding ongoing database initiatives.

Mandatory Skills & Qualifications :

Experience :

- Minimum 12+ years of experience in Database Development and Database Design, with a strong track record in SQL Server Development.

- Extensive experience in writing complex T-SQL queries, stored procedures, views, and triggers.

- Strong knowledge of database normalization, indexing, and query optimization techniques.

- Proven experience in database architecture design and building scalable databases.

Technical Skills :

- SQL Server (2012/2014/2016/2019) expertise, including SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS).

- Experience with database performance tuning and troubleshooting.

- Knowledge of ETL processes, data migration, and data warehousing concepts.

- Expertise in database security, backup, recovery, and disaster recovery planning.

- Proficiency in version control tools like Git or similar.

Database Administration :

- Strong understanding of SQL Server Database Administration tasks, including installation, configuration, and performance monitoring.

- Ability to manage high availability and disaster recovery solutions for SQL Server environments.

Leadership & Communication :

- Proven experience in leading a team of database developers.

- Strong communication skills, capable of collaborating with business and technical teams effectively.

- Ability to mentor and guide junior developers.

Preferred Skills :