SQL Database Architect

About the Role

We are seeking an experienced SQL DBA Architect to lead the design, implementation, and management of robust database systems across our organization. This role involves a blend of strategic planning, hands-on technical expertise, and collaboration with cross-functional teams to ensure database solutions meet business and technical requirements.

Key Responsibilities

Database Architecture & Design:

Design scalable, high-performance, and secure database architectures to support enterprise applications.

Define and enforce database standards, including naming conventions, indexing strategies, and partitioning.

Performance Optimization:

Lead efforts to optimize database performance, including query tuning, indexing strategies, and workload distribution.

Implement and maintain monitoring solutions to ensure proactive identification of performance issues.

Data Management & Security:

Architect and oversee database backup, recovery, and disaster recovery solutions.

Ensure compliance with data governance policies, security best practices, and relevant regulations (e.g., GDPR, HIPAA).

Technology Integration:

Collaborate with development and infrastructure teams to integrate database solutions with applications and cloud platforms (e.g., Azure, AWS).

Evaluate and implement emerging database technologies, including NoSQL and cloud-native solutions.

Leadership & Collaboration:

Mentor and guide junior DBAs and developers on best practices in database design and management.

Work closely with stakeholders to translate business needs into technical database solutions.

Automation & DevOps:

Develop and implement scripts for database provisioning, configuration, and deployments.

Leverage automation tools to streamline database administration and management.

Documentation & Reporting:

Maintain comprehensive documentation of database architectures, configurations, and processes.

Provide regular reports on database health, capacity planning, and performance metrics.

Education:

Bachelors or Master’s degree in Computer Science, Information Technology, or related field.

Experience:

8+ years of experience in database administration, with at least 3 years in a database architecture role.

Proven expertise in SQL Server, PostgreSQL, MySQL, and other relational database systems.

Experience with data warehousing, ETL tools (e.g., SSIS), and reporting tools (e.g., SSRS).

Technical Skills:

Advanced knowledge of T-SQL, database design principles, and normalization techniques.

Proficiency in high-availability solutions (e.g., clustering, Always On, replication).

Experience with cloud-based database solutions (Azure SQL, AWS RDS, etc.).

Familiarity with NoSQL databases (e.g., MongoDB, Cassandra) is a plus.

Soft Skills:

Exceptional problem-solving and analytical skills.

Strong leadership and communication abilities.

Ability to work collaboratively with cross-functional teams.

Preferred Certifications

Microsoft Certified: Azure Solutions Architect Expert

Microsoft Certified: Database Administrator Associate

AWS Certified Solutions Architect – Professional

Certified Data Management Professional (CDMP)