- Ensure performance, security, and availability of databases
- Prepare documentations and specifications
- Profile server resource usage, and optimize and tweak as necessary
- Collaborate with other team members and stakeholders
- Translate business needs to technical specifications
- Design, build and deploy BI solutions (e.g. reporting tools)
- Maintain and support data analytics platforms (e.g. MicroStrategy)
- Create tools to store data (e.g. OLAP cubes)
- Conduct unit testing and troubleshooting
- Evaluate and improve existing BI systems
- Collaborate with teams to integrate systems
- Develop and execute database queries and conduct analyses
- Create visualizations and reports for requested projects
- Develop and update technical proficiency with SQL and its variation among popular databases
- Experience with some of the modern relational databases
- Skilled at optimizing large complicated SQL statements
- Knowledge of best practices when dealing with relational databases
- Capable of configuring popular database engines and orchestrating clusters as necessary
- Proven experience as a BI Developer or Data Scientist
- Industry experience is preferred
- Background in data warehouse design (e.g. dimensional modeling) and data mining
- In-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework
- Familiarity with BI technologies (e.g. Microsoft Power BI, Oracle BI)
- Knowledge of SQL queries, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS)
- Proven abilities to take initiative and be innovative
- Analytical mind with a problem-solving aptitude
SQL Developer - Gurugram, India - Cocentrus
Description
Please find the Job responsibility as below :
Job Profile: SQL Developer
Experience: 4+Years
Salary : Budget upto 18.0 lac
Location: Gurgaon
Working Hours: 10:00 am to 7:00 pm
Working Days: Monday to Friday (Saturday & Sunday Off)
KeyRolesAnd write and optimize in-application SQL statements