Talent.com
This job offer is not available in your country.
SQL Developer

SQL Developer

Intelliswift Software India Pvt LtdGurgaon
30+ days ago
Job description

Job Description : Responsibilities :

  • Design, develop, and maintain relational databases, schemas, tables, stored procedures, functions, views, and triggers using SQL Server, Oracle, MySQL, PostgreSQL, or other relevant database platforms.
  • Write and optimize complex SQL queries for data retrieval, manipulation, analysis, and reporting to meet application and business requirements.
  • Develop and implement ETL (Extract, Transform, Load) processes using SQL Server Integration Services (SSIS), Oracle Data Integrator (ODI), or other ETL tools, or through custom SQL scripts.
  • Ensure the performance, scalability, and stability of database systems through proactive monitoring, performance tuning, and optimization of queries and database configurations.
  • Troubleshoot and resolve database-related issues, including query performance problems, data inconsistencies, and database errors, in a timely and efficient manner.
  • Collaborate closely with application developers, system administrators, and other technical teams to understand data requirements and ensure seamless integration between applications and databases.
  • Participate in the planning and execution of database backups, recovery procedures, and disaster recovery strategies to ensure data availability and business continuity.
  • Monitor database performance metrics, identify potential bottlenecks, and implement proactive measures for improvement.
  • Create and maintain comprehensive technical documentation for database designs, schemas, stored procedures, and ETL processes.
  • Adhere to database security best practices and implement security measures to protect sensitive data.
  • Stay up-to-date with the latest SQL Server features, database technologies, and industry best practices.
  • Participate in code reviews and contribute to the team's knowledge sharing and best practices.

Technical Skills :

  • SQL : Excellent and demonstrable proficiency in writing complex SQL queries, stored procedures, functions, views, and triggers using Transact-SQL (for SQL Server), PL / SQL (for Oracle), or other database-specific SQL dialects (MySQL, PostgreSQL).
  • Database Design : Strong understanding of relational database design principles, normalization, data modeling techniques (ER diagrams, etc.), and schema design.
  • ETL (Extract, Transform, Load) : Proven experience in designing, developing, and implementing ETL processes using tools like SQL Server Integration Services (SSIS), Oracle Data Integrator (ODI), Apache NiFi, or through custom SQL scripting.
  • Database Performance Tuning : Demonstrated ability to analyze and optimize SQL query performance, identify and resolve database bottlenecks, and implement indexing strategies.
  • Stored Procedures and Functions : Expertise in developing, debugging, and maintaining efficient stored procedures, functions, and triggers to encapsulate business logic and improve performance.
  • Database Administration Fundamentals : Basic understanding of database administration tasks such as database backups, restores, user management, security configurations, and performance monitoring.
  • Version Control : Familiarity with version control systems like Git for managing database scripts and schema changes.
  • Operating Systems : Comfortable working with Windows Server or Linux operating systems as they relate to database :
  • Bachelor's degree in Computer Science, Information Technology, or a related field.
  • 5 -10 years of professional experience as a SQL Developer, with a strong focus on relational database development and management.
  • Proven expertise in writing and optimizing complex SQL queries across various database platforms.
  • Solid understanding of database design principles and ETL processes.
  • Strong analytical and problem-solving skills with the ability to troubleshoot database issues effectively.
  • Good verbal and written communication skills to interact effectively with technical and non-technical stakeholders.
  • Ability to work independently and collaboratively within a team environment.
  • Bonus Points :

  • Experience with specific database platforms such as SQL Server, Oracle, MySQL, or PostgreSQL.
  • Knowledge of data warehousing concepts, dimensional modeling, and OLAP techniques.
  • Experience with database scripting languages like Python or PowerShell for automation tasks.
  • Familiarity with NoSQL databases (MongoDB, Cassandra).
  • Experience working with cloud-based database services (Azure SQL Database, AWS RDS, Google Cloud SQL).
  • Experience in an Agile development environment.
  • Relevant certifications (Microsoft Certified : Database Administrator, Oracle Database SQL Certified Associate).
  • ref : hirist.tech)

    Create a job alert for this search

    Sql Developer • Gurgaon