Description :

About the Company :

AI CERTs is a globally recognized EdTech and certification organization specializing in Artificial Intelligence, Data Science, and Cloud technologies. The company delivers industry-leading learning programs, professional certifications, and technology-driven solutions that support global upskilling and digital transformation. AI CERTs values innovation, excellence, and continuous learning.

Role Overview :

The Senior Database Architect will be responsible for architecting, managing, optimizing, and securing enterprise-grade database ecosystems across on-premise and cloud platforms (Azure/AWS). The role involves planning scalable solutions, handling large datasets, ensuring high availability, driving automation, and leading database modernization initiatives.

Key Responsibilities :

- Architect, design, and manage SQL Server database environments across on-premise and cloud platforms

- Oversee installation, configuration, and lifecycle management of large databases (up to 20+ TB)

- Design high-availability architectures including Always On, Clustering, Log Shipping, and Replication

- Implement robust Disaster Recovery frameworks ensuring minimal downtime

- Lead performance optimization initiatives including query tuning, indexing, and workload analysis

- Drive database automation using PowerShell, SSIS, and SQL tasks

- Develop and maintain SSIS packages, SSRS reports, and data pipelines

- Lead Azure/AWS migration projects including planning, execution, and validation

- Define database standards, governance, and security policies

- Conduct root cause analysis for production issues and ensure long-term fixes

- Collaborate with development, DevOps, and infrastructure teams for seamless release cycles

- Provide 24x7 support for critical systems and mentor junior DBAs

- Implement and manage data warehousing, data engineering pipelines, and Azure Data Factory workflows

Required Skillsets :

- Deep expertise in SQL Server Administration for large enterprise databases

- Strong experience designing HA/DR architectures (Always On, Clustering, HADR)

- Proven capabilities in query tuning, indexing strategies, and performance troubleshooting

- Strong hands-on experience with SSIS, SSRS, and PowerShell automation

- Proficiency in Azure SQL, AWS RDS, and cloud migration methodologies

- Solid knowledge of data warehousing, data engineering, and Azure Data Factory

- Experience working with monitoring tools such as RedGate, SQL Diagnostic Manager, or SolarWinds DPA

- Strong analytical, documentation, and communication skills

- Ability to architect scalable, secure, and resilient database infrastructures

Good-to-Have Skillsets :

- Experience as an Oracle DBA or Oracle certifications (OCA/OCP)

- Exposure to DevOps/CI-CD pipelines for database deployments

- Strong understanding of T-SQL development and ETL design

- Experience with cloud-native database services and hybrid architectures

Education :

- Bachelors degree in Computer Engineering, Information Technology, or related technical field

- Microsoft, Oracle, AWS, or cloud database certifications preferred