Database Engineer-MySQL at Jellyfish Technologies · Noida · 4 - 6 years · ₹8L - ₹15L / yr · Posted 22 Apr 2022
- Communicate and coordinate effectively across multiple internal teams and external contractors.
- Prioritize and deliver results effectively on concurrent projects in a fast-paced team-oriented environment.
Database Development Skills :
- Write and review MSSQL code and queries used in standard database objects (functions, stored procedures, triggers, and views) and queries generated by application.
- Automate, document, and demonstrate routine tasks and processes.
- Commit database administration and automation code to source control in Git repository.
- Track and apply changes to database objects and data transformations in testing and production environments.
- Maintain database continuous integration, delivery, and deployment efforts in support of DevOps initiatives.
- Leverage open-source platforms and cloud technologies to improve efficiency and scalability of data services.
Database Administration Skills :
- Deliver actionable feedback to business owners and development teams regarding SQL Server performance and scalability.
- Apply industry standard security principles and best practices.
- Provide and monitor Instance and Database level access to users and applications.
- Support audit compliance efforts by reporting on setup, configuration, and application data.
Required Experience :
- Proven track record of analyzing and solving complex data issues.
- Query tuning, optimization, and monitoring in an enterprise environment.
- Root cause analysis of performance and integrity issues.
- Data analytics and reporting using complex SQL queries.
Background :
- Degree in Computer Science or equivalent experience.
- 5-7 years of Microsoft SQL Server Database Engineer experience.
Shubham Vishwakarma
Full Stack Developer - Averlon
About Jellyfish Technologies
About
Company social profiles
Similar jobs (2)
Position : SQL Database Developer
Experience : 10+ Years
Domain : Mutual Fund / Capital Markets
Location : Noida
Work Mode : Hybrid
Role Overview :
We are looking for a Senior SQL Developer with 10+ years of experience in SQL Server and T-SQL development, preferably with experience in the Mutual Fund / Capital Markets / Financial Services domain.
Mandatory Skills :
- SQL Server & T-SQL
- Stored Procedures, Functions, Triggers, Views & SQL Jobs
- Complex SQL Queries & Data Manipulation
- Query Performance Tuning & Optimization
- Indexing, Execution Plans & Partitioning
- Data Migration, Porting, Transformation & Validation
- Database Troubleshooting
- SQL Server Performance Monitoring
- Version Control / Git
- Database Security & Data Integrity
Domain Knowledge :
- Mutual Fund / Capital Markets experience preferred.
- Understanding of financial transactions, reporting, reconciliation, and business processes.
Key Responsibilities :
- Develop and optimize T-SQL queries, stored procedures, views, functions, and triggers.
- Perform query tuning, indexing, execution plan analysis, and performance optimization.
- Handle data migration, transformation, porting, validation, and reconciliation.
- Troubleshoot database and production/UAT issues.
- Ensure data accuracy, integrity, consistency, and security.
- Work with developers, BAs, QA teams, and business stakeholders.
- Independently own database development and optimization activities.
- Education: Bachelor's degree in Computer Science, IT, Engineering, or related field.
.NET
HTML/CSS
Javascript
Angular (2+)Experience and Required Skill Sets:
1 Solid experience in software design and development using Microsoft ASP.NET framework, C#, Visual Studio, and in writing clean, readable, and easily maintainable code
2 5+ years of experience in WCF, WPF, VB.NET, SQL Server, JQuery, Angular 10 and above.
3 5+ years of experience in developing highly scalable REST/Web APIs
4 5+ years of experience in developing highly efficient SQL/NoSQL Queries
5 5+ years of experience in Relational and Document databases
6 Strong understanding of object-oriented programming and possess strong fundamental design principles for building a scalable application.
7 Experience in using the MVC framework, working knowledge in APIs, and Service Oriented Architecture
8 Strong understanding of object-oriented programming and possess strong fundamental design principles for building a scalable application.
9 Experience in Angular version 10 and above is required
10 Expert in SQL programming & Database Design (Stored procedure, Function, Trigger, Constraints, Replication)
11 Strong ability in HTML and JavaScript (AJAX, DOM)
12 Development experience with data integration technologies including REST, SOAP, JSON, XML
13 Expertise in programming and usage of any unit testing framework. Expertise in integration testing and continuous integration.
14 Experience working in a DevOps environment will be an added advantage.
Responsibilities:
• Ability to create complex, enterprise-transforming applications that meet and exceed client expectations.
• Responsible for the bottom line. Strong project management abilities. Ability to encourage the team to stick to timelines.
• Follow best-in-class coding practices and review the solutions vis-à-vis the requirements and technical specifications.
• Should demonstrate strong client interfacing capabilities like emails and calls with clients in the US/UK
Follow CutshortShubham Vishwakarma
Full Stack Developer - Averlon