SQL Developer Encouraging Discovery in Data
0 - 3 Years
Full Time
|
Chennai, India
Job Description :
SQL Developer Encouraging Discovery in Data
Candidate Application:
Full Name:
Contact Number:
Email Address:
Current Location:
Position Applied For:
Qualification:
Year of Passout:
Candidate Category: Fresher / Experienced
Willingness to Relocate: Yes / No
Total Years of Experience: (If applicable)
Current/Last Drawn Salary (Monthly/Annual):
Notice Period:
Job Description:
Responsibilities:
Database Design and Logical/Physical Data Modelling: Create, implement, and manage standardised relational database schemas, tables, constraints, keys, views, and data structures in accordance with enterprise architecture standards and business needs.
Advanced SQL Query & Stored Procedure Engineering: To support application logic, reporting, and analytics, create, test, and manage intricate SQL queries, stored procedures, user-defined functions (UDFs), database triggers, and CTEs.
Query Performance Tuning & Optimisation: To increase throughput and reduce latency, examine execution plans, find query bottlenecks, improve index techniques, rewrite ineffective queries, and adjust database setups.
ETL Pipeline & Data Integration Automation: To ingest, transform, and reconcile massive amounts of structured and semi-structured data across enterprise systems, create, manage, and keep an eye on reliable Extract, Transform, Load (ETL) and Extract, Load, Transform pipelines (using SSIS, Talend, Python, or native database utilities).
Database Security, Backup & Recovery Management: Set up automatic database backup procedures, disaster recovery exercises, and integrity checks in accordance with data protection laws; implement role-based access control (RBAC), data encryption, and masking policies.
Required Skills:
Relational Database & SQL Engineering Mastery: Expert proficiency with major enterprise RDBMS platforms, including ANSI SQL and T-SQL/PL-SQL dialect execution.
Query Optimisation & Performance Tuning Capabilities: Extensive knowledge of database engine internals, execution plan analysis, deadlock resolution, index building and maintenance, and partitioning techniques.
ETL Pipeline & Data Warehouse Design: Practical experience creating staging environments, dimensional data models (Star/Snowflake Schema), automated data integration jobs, and data transformation procedures.
Administration & Security of Databases Database permissions, transaction isolation levels, ACID compliance, database mirroring and replication, and migration utility management are all fundamental concepts.
Experience: 0 to 3 yrs
Salary: Best in the Industries
Immediate Joiner Mostly Preferred
Interested Candidates Contact the HR ASAP
Warm Regards,
HR - Maria
88708 33430
infohrmaria04@gmail.com
Key Skills :
Industry :
Education :
Vacancies : 5
Posted On : 1 days ago
About Company :
GS Infotech has established itself as a true independent service provider in the field of placements. We are an certified company known for our highly reliable and effective services. A service company is only as strong as the trust of its candidates and the quality of its reputation, and we have earned vast repute in our industry.
Overview :