SQL Developer Jobs in Pune - Sara Technologies Pvt Ltd
Job Description
Jd
The Sr. SQL Developer will lead the development of new AND the maintenance/optimization of existing Ad-Hoc Queries, Stored Procedures, SQL Agent Jobs, Triggers, Indexes, Views and Functions. This role will also be responsible for installing, maintaining and configuring Microsoft SQL Server database instance with SQL Server Integration (SSIS) and Reporting Service (SSRS). Business Intelligence Development, Implementations, and Data Warehousing will also be key responsibilities in this role.
A Day in the Life
Performance Tuning and Query Optimization using native SQL Server tools
Database backups and recovery, configure replication, db system planning
Ensure performance, security, and availability of databases.
Develop and maintain complex stored procedures
Create documentation and UML diagrams for database processes.
Handle common database server optimization tasks.
Maintain Domo cards and optimized cards already in production.
Maintain ETL processes and code.
Create complex ad hoc queries
Optimize database schemas, maintain database jobs, and dictionaries.
Ability to fix issues related to database performance and provide corrective measures.
Partner with stakeholders to create reports and dashboards for internal departments.
Maintain and develop backend data layer code for internal applications.
Maintain and optimize business intelligence environment (DOMO, COGNOS). (Domo and Cognos is optional)
What Sets You Apart
Ability to troubleshoot issues with the databases and applications within our environment.
Strong knowledge of data analytics and BI tools such as Domo or COGNOS is required.
Must have strong critical thinking and problem-solving skills.
Ability to communicate effectively.
The ability to reverse engineer and re-write complex queries
Education and Experience
Database modeling, design, troubleshooting, error handling, and hardware planning
Must have working experience of AWS - Redshift
The Sr. SQL Developer will lead the development of new AND the maintenance/optimization of existing Ad-Hoc Queries, Stored Procedures, SQL Agent Jobs, Triggers, Indexes, Views and Functions. This role will also be responsible for installing, maintaining and configuring Microsoft SQL Server database instance with SQL Server Integration (SSIS) and Reporting Service (SSRS). Business Intelligence Development, Implementations, and Data Warehousing will also be key responsibilities in this role.
A Day in the Life
Performance Tuning and Query Optimization using native SQL Server tools
Database backups and recovery, configure replication, db system planning
Ensure performance, security, and availability of databases.
Develop and maintain complex stored procedures
Create documentation and UML diagrams for database processes.
Handle common database server optimization tasks.
Maintain Domo cards and optimized cards already in production.
Maintain ETL processes and code.
Create complex ad hoc queries
Optimize database schemas, maintain database jobs, and dictionaries.
Ability to fix issues related to database performance and provide corrective measures.
Partner with stakeholders to create reports and dashboards for internal departments.
Maintain and develop backend data layer code for internal applications.
Maintain and optimize business intelligence environment (DOMO, COGNOS). (Domo and Cognos is optional)
What Sets You Apart
Ability to troubleshoot issues with the databases and applications within our environment.
Strong knowledge of data analytics and BI tools such as Domo or COGNOS is required.
Must have strong critical thinking and problem-solving skills.
Ability to communicate effectively.
The ability to reverse engineer and re-write complex queries
Education and Experience
Database modeling, design, troubleshooting, error handling, and hardware planning
Must have working experience of AWS - Redshift
Job Particulars
Role it software engineer
Education Diploma, B.Com, M.Com, BCA, BE/B.Tech, BSc, MCA, ME/M.Tech, MSc, PG Diploma, 12th Pass (HSE)
Who can apply Freshers and Experienced (0 to 3 Years )
Hiring Process Face to Face Interview
Employment TypeFull Time
Job Id957696
Job Category IT/Software , Diploma
Locality Address
State Maharashtra
Country India
About Company
Sara Technologies Pvt Ltd
Jobs By Location
Pune
Delhi
Mumbai
Hyderabad
Noida
Bangalore
Kolkata
Ahmedabad
Chennai
Gurgaon
Others also searched for
Job & career videos Subscribe