Design, develop, and implement SQL Server databases based on business requirements and best practices.
Create database schema, tables, views, stored procedures, and functions to support application functionality and data access.
Ensure data integrity, security, and performance through proper database design and normalization techniques.
Analyze query execution plans and performance metrics to identify and address performance bottlenecks.
Implement indexing strategies and database optimizations to improve query performance.
Design and implement ETL processes to extract, transform, and load data from various sources into SQL Server databases.
Document database configurations, performance tuning activities, and Power BI solutions for knowledge sharing and future reference.
Provide training and support to end-users on SQL Server best practices, database performance optimization techniques, and Power BI usage.
Minimum Requirements:
BTech degree in Computer Science or related discipline, MTech degree preferred.
Assertive communication, strong analytical, problem solving, debugging, and leadership skills.
Must have experience with source control tools like Bit Bucket and/or Git.
Strong understanding of cloud technologies including SaaS, PaaS, and IaaS.
Good Hands-on experience diagnosing performance bottlenecks, wait stats, SQL query monitoring, review and optimization strategies.
Create normalized and highly scalable logical and physical database design and switch between different database technologies like Oracle, SQL Server, Elastic databases.
7+ years of overall experience building and maintaining SQL server and data engineering for the organization.
7+ year SQL server development experience with strong programming experience in writing stored procedures and functions.
Excellent understanding of Snowflake and other data warehouses.
Experience in designing and hands-on development in cloud-based analytics solutions.
Proficient level understanding on AWS storage services and AWS Cloud Infrastructure offerings.
Designing and building data pipelines using API ingestion and Streaming ingestion methods.
Knowledge of Dev-Ops processes (including CI/CD) and Infrastructure as code is essential.