AI CERTs™
Website:
aicerts.ai
Job details:
Job Pay:- Upto 20lpa
Shift Timing- 3PM-12AM IST
Job Description: Senior Database Architect
Position Overview
The Senior Database Architect is responsible for designing, implementing, and optimizing scalable, secure, and high-performance database solutions. This role involves working with cross-functional teams to define data architecture standards, ensure data integrity, and support mission-critical applications.
Key Responsibilities
Design and implement database architectures, schemas, and data models for enterprise applications.
Develop and maintain data integration and ETL pipelines.
Optimize database performance, including indexing, query tuning, partitioning, and caching.
Ensure database security, backup, disaster recovery, and high availability strategies.
Evaluate and select appropriate database technologies (SQL/NoSQL, cloud databases, data warehouses).
Collaborate with development teams to define database standards, best practices, and coding guidelines.
Conduct capacity planning and forecast database resource requirements.
Review database code (SQL scripts, stored procedures, triggers) and ensure adherence to architecture standards.
Drive migration and modernization initiatives (on-prem to cloud, legacy to modern DB platforms).
Troubleshoot complex database issues and provide expert-level support.
Create and maintain documentation related to data architecture, schemas, and processes.
Required Skills & Qualifications
Bachelor’s or Master’s degree in Computer Science, Information Technology, or a related field.
8–12+ years of experience in database development and architecture.
Proficiency in RDBMS such as:
MySQL
PostgreSQL
Oracle
SQL Server
Experience with NoSQL databases (MongoDB, Cassandra, DynamoDB, Redis).
Strong understanding of data modeling (OLTP/OLAP), normalization, and ER diagrams.
Expertise in query optimization, performance tuning, and indexing strategies.
Hands-on experience with cloud platforms:
AWS (RDS, Aurora, DynamoDB)
Azure SQL, Cosmos DB
Google Cloud SQL / BigQuery
Experience with data warehousing concepts and tools.
Strong knowledge of ETL tools and data integration frameworks.
Familiarity with microservices architecture and API-driven systems.
Excellent problem-solving and communication skills.
Preferred (Nice-to-Have)
Experience with Kubernetes, containerized databases, or serverless architectures.
Certifications in AWS, Azure, or database technologies.
Experience in big data processing tools like Spark, Hadoop, Kafka.
Click on Apply to know more.