Senior Database Architect Job in TekFriday
- Kpr sugar apperals
- 10 to 14 Yrs
- Hyderabad
- 11 months ago
- Email to a friend
- Report this job
Job Description
- We are looking for a dynamic professional who combines expertise in Snowflake data warehousing, SQL development and Data Science to help us build and maintain a robust, scalable data infrastructure. In this role, you will be responsible for architecture, implementing, and optimizing cloud-based data pipelines, writing complex SQL queries for data extraction and transformation, and leveraging machine learning algorithms to generate insights from large datasets. You will play a key role in enabling data-driven decision-making across the organization. What we expect you to do :SQL Development & Optimization :Write and troubleshoot SQL code and design (stored procedures, functions, tables, views, triggers, indexes, and constraints) .Perform performance tuning and query optimization using tools like SQL Profiler and other monitoring/troubleshooting utilities .Write efficient, complex queries against very large data sets and ensure database performance, security, and availability .Database Redesign & Architecture :Analyze, redesign, and implement database schemas to improve scalability, performance, and reliability .Translate business requirements into technical designs for database integration and development .Optimize database architecture to support evolving application and business needs .Data Analysis & Reporting :Conduct data analysis to uncover actionable insights and support decision-making .Create and maintain reports using SQL Server Reporting Services (SSRS) or other tools as required .Data Warehousing :Develop and maintain data pipelines using modern data warehousing tools such as Snowflake .Collaborate with cross-functional teams to design and build ETL/ELT pipelines for data warehousing .Ensure data accuracy, consistency, and reliability across data warehouses .Database Administration :Handle database backups, recovery, upgrades, migrations, and maintenance to ensure smooth operations .Monitor and troubleshoot common database issues, ensuring timely resolutions .Profile server resource usage and perform optimization as needed .Automation & BI Tools :Create jobs and schedules to automate ETL packages within SSIS .Write and optimize in-application SQL statements and BI-ETL processes .Automate tasks wherever possible, ensuring efficiency and accuracy .Collaboration & Documentation :Document SQL processes, procedures, and database designs .Collaborate with stakeholders, business analysts, and other teams to gather and translate business requirements into database solutions .Provide on-call support, resolve issues, and ensure timely follow-ups with end-users and management .System & Tools Management :Use tools like Visual Studio, SQL Server Management Studio, and GitHub for database management and versioning .Work with frameworks such as AWS, Azure, FTP/sFTP/VPN protocols, and modern relational databases .Familiarity with API integration concepts like Web API, WCF, REST, and SOAP . What Were Looking Fo r:10+ years of experience in MS-SQL development, database design, and data warehousing, preferably in BFSI or similar industrie s.Expertise in Microsoft SQL Server, Snowflake, and other relational database s.Strong proficiency in T-SQL with experience in wait statistics, execution plan analysis, extended events, and dynamic management view s.Experience in SQL Server Reporting Services (SSRS), data warehousing tools, and ETL pipeline s.Familiarity with Visual Studio, SQL Server Management Studio, and GitHu b.Experience in database troubleshooting, performance optimization, and handling common database issue s.Knowledge of MS scripts, replications, and profiling server resource s.Strong analytical and quantitative skills with the ability to solve problems effectivel y.Highly motivated with excellent troubleshooting skill s.Ability to work in a fast-paced, result-driven environment while meeting strict deadline s.Strong communication and documentation skill s.Flexibility to adapt to unexpected changes in priorities or directio n.Sense of ownership and accountability for tasks and project s.,
Employement Category:
Employement Type: Full timeIndustry: IT Services & ConsultingRole Category: Not SpecifiedFunctional Area: Not SpecifiedRole/Responsibilies: Senior Database Architect Job in TekFridayContact Details:
Company: TekFriday ProcessingLocation(s): Hyderabad+ View Contact
Keyskills: SQL development Data Science Data Warehousing Database Administration TSQL Visual Studio SQL Server Management Studio GitHub AWS Azure Performance optimization Analytical skills Communication skills SQL Server Reporting Services SSRS
Fraud Alert to job seekers!
₹ Not Specified
Similar positions
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in