Database Architect and Administrator

Database Architect and Administrator

Position Overview

We are seeking an experienced Database Architect and Administrator with expertise in Database Architecture, SQL, Data Modeling, and Database Optimization. The ideal candidate should have a proven track record of over 6 years in managing, designing, and optimizing database systems for high performance and scalability.

Key Responsibilities

1. Database Architecture

• Design, implement, and maintain scalable database architectures to meet business needs.
• Define database standards, guidelines, and best practices for data storage and retrieval.
• Ensure database solutions align with organizational objectives.

1. Database Administration

• Install, configure, and manage database management systems (DBMS).
• Monitor database performance and perform regular backups and recovery processes.
• Troubleshoot and resolve database-related issues promptly.

1. SQL Development

• Write and optimize SQL queries for data extraction, manipulation, and reporting.
• Design and implement complex stored procedures, triggers, and functions.
• Ensure query performance optimization to minimize execution time.

1. Data Modeling

• Develop logical and physical data models to support business processes.
• Maintain data integrity and consistency through robust modeling techniques.
• Collaborate with stakeholders to understand data requirements and translate them into models.

1. Database Optimization

• Analyze database performance and implement optimization techniques.
• Conduct indexing, partitioning, and tuning to improve system efficiency.
• Stay updated on emerging database technologies and recommend upgrades when necessary.

Qualifications and Skills

• Experience: Minimum of 6+ years in database architecture, administration, and optimization.
• Technical Skills:
• Strong proficiency in SQL and database query optimization.
• Hands-on experience with database systems such as MySQL, PostgreSQL, Oracle, or MS SQL Server.
• Expertise in data modeling tools and techniques.
• Analytical Abilities: Strong problem-solving skills and attention to detail.
• Communication: Ability to effectively communicate technical concepts to non-technical stakeholders.

Preferred Qualifications

• Certification in database administration or architecture (e.g., Oracle DBA, Microsoft SQL Server).
• Experience with cloud-based databases (AWS RDS, Azure SQL, Google Cloud Spanner).
• Knowledge of database security practices and compliance standards.