Database Architect SQL Server

Job description

<p>Immediate to 90 Days Joiners.

</p><p><br/></p><p>Position Title : SQL </p><p><br/></p><p>Role : DBA Architect.

</p><p><br/></p><p>Location : Nagpur(Onsite).

</p><p><br/></p><p>Experience :10+ years.

</p><p><br/></p><p>Employment Type : Full-time.

</p><p><br/></p><p>We are seeking a seasoned SQL DBA Architect to lead our database infrastructure, performance tuning, and cloud initiatives..

</p><p><br/></p><p>Required Skills : 10+ years of experience in database architecture and administration.

</p><p><br/></p><p>- Strong knowledge of Microsoft SQL Server.

</p><p><br/></p><p>- Proficient in T-SQL, Stored Procedures, Functions, and Triggers.

</p><p><br/></p><p>- Experience with XML operations.

</p><p><br/></p><p>- Hands-on experience with SSIS and SSRS.

</p><p><br/></p><p>- Expertise in SQL Server Indexes and performance tuning.

</p><p><br/></p><p>- Familiarity with NoSQL databases.

</p><p><br/></p><p>- Experience in cloud database platforms and migration.

</p><p><br/></p><p>- Skilled in backup strategies and maintenance plans.

Show more Show less<br/><br/>We are looking for an experienced Database Architect with a strong background in Microsoft SQL Server and a proven track record in designing, implementing, and optimizing complex database environments.

</p><p><br/></p><p>The ideal candidate will be responsible for leading database architecture, ensuring high availability, optimizing performance, and supporting cloud migration initiatives.<br/><br/>You will play a key role in defining the database strategy, establishing best practices, and collaborating with cross-functional teams to deliver scalable and secure data solutions that support business-critical applications.<br/><br/>Key Responsibilities :<br/><br/>- Design, develop, and maintain database architectures to support application development and data analytics needs.<br/><br/>- Lead database design, data modeling, and schema optimization efforts for performance and scalability.<br/><br/>- Oversee and implement database security, backup, and recovery strategies to ensure data integrity and availability.<br/><br/>- Perform database performance tuning, query optimization, and index management to maximize efficiency.<br/><br/>- Develop, implement, and maintain stored procedures, triggers, and functions using T-SQL.<br/><br/>- Administer and optimize SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).<br/><br/>- Manage database migration and replication between environments, including on-premise to cloud transitions.<br/><br/>- Collaborate with developers and DevOps teams to integrate database components into application frameworks.<br/><br/>- Evaluate and recommend emerging database technologies and architectures, including NoSQL and cloud-native databases.<br/><br/>- Monitor and maintain database health using automation tools and proactive alerting.<br/><br/>- Lead database capacity planning, scaling, and high-availability configurations (Always On, Clustering, Mirroring, etc.).<br/><br/>- Maintain documentation of database configurations, processes, and security standards.<br/><br/>Required Skills & Qualifications :<br/><br/>- 10-12 years of experience in Database Architecture and Administration.<br/><br/>- Expertise in Microsoft SQL Server (2016 or later).<br/><br/>- Strong command of T-SQL, stored procedures, functions, views, and triggers.<br/><br/>- Hands-on experience with SSIS (SQL Server Integration Services) and SSRS (SQL Server Reporting Services).<br/><br/>- Deep knowledge of SQL indexing, query optimization, and performance tuning.<br/><br/>- Experience with XML data handling and database automation scripts.<br/><br/>- Familiarity with NoSQL databases such as MongoDB, Cassandra, or Cosmos DB.<br/><br/>- Proven experience in cloud database platforms (Azure SQL, AWS RDS, or Google Cloud SQL).<br/><br/>- Expertise in backup and disaster recovery strategies.<br/><br/>- Strong analytical, troubleshooting, and problem-solving abilities.<br/><br/>- Excellent communication and stakeholder management skills.<br/><br/>- Bachelor's or Master's degree in Computer Science, Information Technology, or a related field.<br/><br/>Preferred Skills :<br/><br/>- Experience with Power BI or other reporting/analytics tools.<br/><br/>- Exposure to Data Warehousing and ETL pipelines.<br/><br/>- Knowledge of DevOps CI/CD practices related to database deployments.<br/><br/>- Understanding of data governance and security compliance standards (GDPR, ISO, etc.).<br/><br/>- Familiarity with containerized databases (Docker/Kubernetes).<br/><br/></p> (ref:hirist.tech)

Required Skill Profession

Computer Occupations