Senior Database Engineer - SQL Server

Job Role : Senior Database Engineer

Location : Hyderabad & Noida

Notice Period : Immediate or less than 15 days

Experience : 8 - 12 years

Key Skills & Technologies

• Snowflake : 3+ years of experience
• Streamsets : 2+ years of experience

• Develop data pipelines for optimal extraction, transformation, and loading (ETL) from various sources using SQL and cloud database technologies.
• Collaborate with stakeholders (Executive, Product, Data, and Design teams) to address data-related technical issues.
• Work with data and analytics experts to enhance data system functionality.
• Assemble large, complex data sets to meet business requirements.
• Analyze and improve existing SQL code for performance, security, and maintainability.
• Design and implement internal process improvements, focusing on automation and scalability.
• Perform unit testing and bug fixes for databases.
• Develop and enforce best practices for database design and development.
• Lead database projects within scrum teams.
• Support dashboard development through exploratory data analysis (desirable).

• Strong SQL experience, particularly with PostgreSQL hosted on cloud platforms (AWS, Azure, GCP).
• Experience with cloud-based data warehouses like Snowflake (preferred) or Azure Synapse.
• Proficiency in ETL/ELT tools such as IBM StreamSets, SnapLogic, or DBT.
• Knowledge of data modeling and OLAP systems.
• Deep understanding of databases, data marts, and enterprise systems.
• Expertise in data ingestion, cleaning, and de-duping.
• Ability to fine-tune report queries and design indexes.
• Familiarity with SQL security techniques (e.g., column-level encryption, TDE).
• Experience mapping source data into ER models (desirable).
• Adherence to database standards (e.g., naming conventions, architecture).
• Exposure to source control tools like GIT or Azure DevOps.
• Understanding of Agile methodologies (Scrum, Kanban).
• Experience with NoSQL databases and real-time replication (desirable).
• Experience with CI/CD automation tools (desirable).
• Programming experience in Golang, Python, and visualization tools like Power BI or Tableau (desirable).

• Excellent communication skills.
• Ability to work effectively in distributed teams.
• Capable of managing multiple timelines simultaneously.
• Adept at articulating data insights to inform business decisions.
• Comfortable with ambiguity and risk management.
• Able to explain complex technical concepts to non-technical audiences.

(ref:hirist.tech)