SQL Developer Job in Mazik Tech Solutions
- Kpr sugar apperals
- 3 to 8 Yrs
- Hyderabad
- 3 months ago
- Email to a friend
- Report this job
Job Description
- Location: Hyderabad/Bangalore Education/Experience Requirements: Bachelors degree, 3+ years experience in Computer science or in a related field. Masters degree preferred. 5-8 years of work experience as SQL/ETL developer, preferably in IT Experience with some of the modern relational databases including SQL Server, Oracle. Strong proficiency with SQL and its variation among popular databases. Skilled at optimizing large, complicated T-SQL statements and index design. Expertise in wait statistics, execution plan analysis, extended events, and dynamic management views in SQL Server. Experience in using Visual Studio and SQL Server Management Studio. Experience in reporting tools like SSRS. Familiarity with Web services and other API concepts like Web API, WCF, REST, and SOAP. Capable of configuring popular database engines and orchestrating clusters as necessary SQL Server database administration experience preferred Capable of troubleshooting common database issues and optimizing performance Knowledge of MS scripts and replications. Familiar with tools that can aid in profiling server resource usage and optimization. Proficient understanding of code versioning tools such as GitHub, and frameworks such as AWS, Azure, FTP/sFTP/VPN protocols. Responsible for delivering projects heavy in back-end database work. Partner with other developers optimizing in-application SQL statements as necessary and establishing best practices. Create and maintain interfaces between multiple sources and databases. Essential Responsibilities: Responsible for coding, documentation, testing, and debugging of small to large programming projects. Performance Tuning, Query Optimization, and using SQL Profiler and other related monitoring and troubleshooting tools Scheduling backups and restoring from backups Working with SQL Server Reporting Services (SSRS) SQL Development ability to write and troubleshoot SQL Code and design (stored procedures, functions, tables, views, triggers, indexes, and constraints) Create technical design recommendations for developing and integrating programs per written specifications. Troubleshoot and solve issues with production systems. Analyze, create and implement database schemas and queries. Ability to write efficient, complex queries against very large data sets, model, analyze and manage large volumes of data. Write and optimize in-application SQL statements, BI-ETL, and SQL Codes. Documentation skills for SQL processes and procedures Translate Business requirements into ETL Process, reports, and queries in support of business analytics. Ensure performance, security, and availability of databases. Handle common database procedures such as upgrade, backup, recovery, migration, etc. Profile server resource usage and optimize and tweak as necessary Perform monitoring to ensure data reliability of all enterprise databases. Perform system upgrades as required for smooth operations of the databases. Provide on-call support, investigates and resolve problems, and provides timely follow-up and communication to managers and end-users on the resolution of measures. Modify and maintain existing applications based on the needs of the business Strong analytical and quantitative skills. Create jobs and schedules to automate ETL packages within SSIS.,
Employement Category:
Employement Type: Full timeIndustry: IT Services & Consulting
Role Category: Application Programming / Maintenance
Functional Area: Not Specified
Role/Responsibilies: SQL Developer Job in Mazik Tech Solutions at
Contact Details:
Company: Mazik Tech SolutionsLocation(s): Hyderabad
+ View Contact
Keyskills: SQL ETL SQL Server Oracle TSQL Visual Studio SQL Server Management Studio SSRS Web services WCF REST SOAP Database administration GitHub AWS Azure SQL Profiler Query Optimization
Fraud Alert to job seekers!
₹ Not Specified
Similar positions
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in