Database Developer
- Cybage
- 6 - 8 years
- Pune
- 2 months ago
- Email to a friend
- Report this job
Job Description
Responsibilities:
- Design and develop robust database solutions, including schemas, tables, views, stored procedures, and functions for Azure SQL Managed Instance.
- Possess a strong understanding of database design principles, including normalization and denormalization techniques.
- Write and execute complex Transact-SQL (T-SQL) scripts for data processing, migration, and transformation.
- Create and maintain data models that ensure data integrity and consistency.
- Optimize database performance by implementing indexing strategies, partitioning, and fine-tuning queries.
- Identify and troubleshoot long-running queries and performance bottlenecks efficiently.
- Manage user roles, permissions, and encryption to ensure database security.
- Document database design using entity-relationship (ER) diagrams, data dictionaries, and design specifications.
- Design and extend logical and physical database structures, including data modeling and profiling.
- Develop and maintain SQL scripts for schemas, users, tables, constraints, indexes, stored procedures, views, and roles.
- Utilize advanced database features such as materialized views, dynamic SQL, and other solutions.
- Implement Full Load, Delta Load, and CDC using SQL or ETL tools.
- Apply working knowledge of data warehousing and dimensional modeling.
Qualifications:
- Minimum 6+ years of experience as an MSSQL developer
- Proven experience in all phases of the database development lifecycle (SDLC)
- In-depth knowledge of Transact-SQL (T-SQL) scripting and database administration tasks
- Solid understanding of database design principles, normalization techniques, and data modeling best practices
- Experience in optimizing database performance and troubleshooting performance issues
- Excellent problem-solving and analytical skills
- Strong communication and collaboration skills
- Ability to work independently and as part of a team
Preferred Skills:
- Experience with Azure SQL Managed Instance and cloud database deployments
- Experience with data warehousing and ETL processes
- Strong problem-solving and debugging skills for business logic implementation.
- Knowledge of DevOps principles and practices
- Good to have experience with PL/SQL, Oracle databases, and writing SQL queries across major RDBMS.
- Familiarity with Python, Azure Cloud, PySpark, DataLake, and Databricks for scripting and automation.
- Experience with version control systems (e.g., Git)
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: Engineering - Software & QA
Role Category: DBA / Data warehousing
Role: Database Developer / Engineer
Employement Type: Full time
Contact Details:
Company: CybageLocation(s): Pune
+ View Contact
Keyskills: SQL Development T-SQL Ms Sql Development ETL Tool
Fraud Alert to job seekers!
₹ Not Disclosed
Similar positions
Cybage
About Cybage:Founded in 1995, Cybage Software Pvt. Ltd., a technology consulting organization is a leader in the hi-tech and outsourced product engineering space. We are a valued partner to technology startups, mid-size companies, and Fortune 500 corporations alike. Our solutions are focused on mode...
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in