SQL Developer at Mirabel Technologies, Inc · Hyderabad · 3 - 5 years · ₹7L - ₹13L / yr · Profitable · Posted 15 Feb 2023
MongoDBJob Description:
Candidate should ideally be a B.E/B.Tech graduate with around 3 to 5 years of experience, with core T-SQL scripting , performance tuning, SSIS, NOSQL skills. The current role requires a core T-SQL , NoSQL and SSIS developer. The SQL Developer will be responsible for:
- Creating & designing database and all database objects such as tables, views, StoredProcedures, functions etc.
- Writing and troubleshooting simple to complex SQL scripts, stored procedures, views, functions, etc. as per the requirement.
- Troubleshooting and fixing all performance issues with respect to databases (objects & scripts).
- SQL Query tuning and performance tuning.
- Develop/migrate existing scripts to SSIS.
- Maintaining referential integrity, domain integrity and column integrity by using the available options such as constraints, etc.
- Maintaining database objects (like tables, views,Stored Procedures) performance by following the tuning tips like normalization, indexes, etc.
- Importing and exporting the data from different sources using tools, writing required scripts.
- Works closely with other members of the team to accomplish the projects.
- Assists project teams to design and develop core business components utilizing industry-accepted analysis and design standards.
- Provides and/or assists with, project management and project leadership.
- Create and maintain documentation for all the projects.
- Working with NOSQL databases (Mostly on MongoDB) .
PRIMARY SKILLS:
TSQL, SQL, NoSQL, Performance Tuning, SSIS, Import & Export of data from different data sources and from different formats.
SECONDARY SKILLS:
Database Administration
REQUIRED SKILLS:
- 3+ years of professional experience in working with MSSQL Server 2008 and above.
- 3+ years of professional experience in writing TSQL scripts.
- Thorough experience in SQL query tuning and performance tuning.
- Experience in developing and maintaining SSIS packages.
- Experience in working with NoSQL databases. MongoDB would be preferable.
- Fluent knowledge of MSSQL server DBA.
- Should be a good team player and should possess good attitude and work ethics.
- Should possess excellent communication and written skills.
PREFERRED SKILLS:
- MSSQL DBA.
- SSIS.
- NOSQL, MongoDB
Shubham Vishwakarma
Full Stack Developer - Averlon
About Mirabel Technologies, Inc
About
The Next Generation of Automation:
Mirabel Technologies is a privately owned, international tech company that provides all-in-one software solutions for businesses. President Mark McCormick founded Mirabel Technologies in 2003 with the vision to help publishers streamline operations in an ever-changing media environment.
After launching over a dozen successful magazines in South Florida, McCormick introduced Mirabel’s flagship product, The Magazine Manager. As the first web-based CRM made for publishers, it now serves more than 17,000+ media properties worldwide.
Since then, other publishing products followed suit, including The Newspaper Manager, a CRM specific to newspapers, and Mirabel’s Magazine Central, a library-like platform to display digital editions.
In 2019, Mirabel Technologies expanded into marketing automation and email verification with Mirabel’s Marketing Manager and Clean Your Lists, respectively.
Coming Soon: The company plans to join the subscription industry with ChargeBrite, a brand-new digital platform tailored to any business with a recurring revenue model.
Tech stack
.NET
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