Database Architect || Immediate Joiner

We are seeking a skilled and innovative Database Architect to design, implement, and maintain robust database solutions that meet the needs of our growing organization. The ideal candidate will be responsible for analyzing business requirements, creating database structures, and ensuring optimal performance, scalability, and security of our database systems. This role involves collaboration with various teams, including software developers, data analysts, and system administrators, to ensure seamless integration and efficient data management.Key Responsibilities:
1. Database Design and Architecture:

• Design and develop logical and physical database models that align with business needs.
• Define and implement database architecture standards, best practices, and guidelines.
• Analyze data requirements and create optimized schema for transactional and analytical databases.

2. Database Development and Implementation:

• Create and manage database objects, including tables, views, indexes, and stored procedures.
• Develop data migration and integration strategies for importing and exporting data across platforms.
• Oversee database provisioning, deployment, and upgrades.

3. Performance Optimization:

• Monitor and tune database performance, ensuring high availability and reliability.
• Optimize query execution plans and troubleshoot performance issues.
• Implement database partitioning, indexing, and caching strategies to improve efficiency.

4. Data Governance and Security:

• Establish and enforce data governance policies and compliance requirements.
• Implement database security measures, including encryption, access controls, and audits.
• Ensure data integrity, backup, and disaster recovery strategies are in place.

5. Collaboration and Communication:

• Work closely with development teams to ensure database integration with applications.
• Collaborate with data analysts to support business intelligence and reporting needs.
• Provide mentorship and guidance to junior database developers and administrators.

Qualifications:
Education and Experience:

• Bachelors degree in Computer Science, Information Technology, or a related field (Masters preferred).
• Proven experience (5+ years) as a Database Architect, Database Administrator, or similar role.

Technical Skills:

• Expertise in database management systems such as Oracle, MySQL, SQL Server, PostgreSQL, or MongoDB.
• Strong understanding of database design principles, normalization, and denormalization.
• Proficiency in writing and optimizing complex SQL queries and stored procedures.
• Knowledge of cloud-based databases and platforms like AWS RDS, Azure SQL, or Google Cloud Spanner.
• Familiarity with data warehousing concepts and tools like Snowflake, Redshift, or BigQuery.
• Experience with ETL tools and data integration platforms.
• Understanding of database security, compliance standards (e.g., GDPR, HIPAA), and disaster recovery planning.

Technical Skills:

• Strong knowledge of relational database management systems (RDBMS) such as PostgreSQL, MySQL, SQL Server, or Oracle.
• Proficiency in writing and optimizing complex SQL queries.
• Experience with NoSQL databases like MongoDB, Cassandra, or DynamoDB (preferred).
• Familiarity with database design tools and techniques (e.g., ERD, Normalization, Dimensional Modeling).
• Knowledge of cloud database services (e.g., AWS RDS, Azure SQL, Google Cloud Spanner).
• Experience in performance tuning, indexing strategies, and query optimization.
• Proficiency in database migration and replication strategies.
• Understanding of database security best practices (e.g., Role-Based Access Control, Data Encryption).