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

Key Responsibilities :

- 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).

Required Skills :

- 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).

Personal Attributes :

- 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.