Sr. SQL Developer (Banking Domain experience)

Mumbai malad work from office

6 Days working

1 & 3 Saturday off

AWS Expertise: Minimum 2 years of experience working with AWS services like RDS, S3, EC2, and Lambda.

Roles and Responsibilities

1. Backend Development: Develop scalable and high-performance APIs and backend systems using Node.js. Write clean, modular, and reusable code following best practices. Debug, test, and optimize backend services for performance and scalability.

2. Database Management: Design and maintain relational databases using MySQL, PostgreSQL, or AWS RDS. Optimize database queries and ensure data integrity. Implement data backup and recovery plans.

3. AWS Cloud Services: Deploy, manage, and monitor applications using AWS infrastructure. Work with AWS services including RDS, S3, EC2, Lambda, API Gateway, and CloudWatch. Implement security best practices for AWS environments (IAM policies, encryption, etc.).

4. Integration and Microservices:Integrate third-party APIs and services. Develop and manage microservices architecture for modular application development.

5. Version Control and Collaboration: Use Git for code versioning and maintain repositories. Collaborate with front-end developers and project managers for end-to-end project delivery.

6. Troubleshooting and Debugging: Analyze and resolve technical issues and bugs. Provide maintenance and support for existing backend systems.

7. DevOps and CI/CD: Set up and maintain CI/CD pipelines. Automate deployment processes and ensure zero-downtime releases.

8. Agile Development:

Participate in Agile/Scrum ceremonies such as daily stand-ups, sprint planning, and retrospectives.

Deliver tasks within defined timelines while maintaining high quality.

Required Skills

Strong proficiency in Node.js and JavaScript/TypeScript.

Expertise in working with relational databases like MySQL/PostgreSQL and AWS RDS.

Proficient with AWS services including Lambda, S3, EC2, and API Gateway.

Experience with RESTful API design and GraphQL (optional).

Knowledge of containerization using Docker is a plus.

Strong problem-solving and debugging skills.

Familiarity with tools like Git, Jenkins, and Jira.

• Hands on Work experience as a Python Developer
• Hands on Work experience in SQL/PLSQL 
• Expertise in at least one popular Python framework (like Django, Flask or Pyramid)
• Knowledge of object-relational mapping (ORM)
• Familiarity with front-end technologies (like JavaScript and HTML5)
• Willingness to learn & upgrade to Big data and cloud technologies like Pyspark Azure etc.
• Team spirit
• Good problem-solving skills
• Write effective, scalable code

Experience in developing applications using .Net Core Ver. 6/7, ASP.Net MVC (C#), .Net Core Web API & Web App, Web Services, OOPS, SOLID principles.

Experience in software development and system architecture with Microsoft technologies.

Able to integrate the database objects with the Microservices.

Expert working knowledge of Multi-threading.

Solid experience in converting .NET Framework multi-threaded services into .NET Core.

Worked as part of a cross-functional team on code reviews, internal infrastructure, and process enhancement.

Understanding of CI/CD pipeline is mandatory.

Strong hands-on experience with C# and solid principles.

Expertise in entity framework core with code first approach.

Expertise in writing RESTful services.

Knowledge of RDBMS concepts.

• Ruby

• Rails framework

• MySQL

• API development

• Design Patterns

Develop, test, and maintain all APIs

• Manage and maintain SQL and No-SQL tables, data, and stored procedures within all databases

• Compile and analyze data, processes, and codes to troubleshoot problems and identify areas for improvement

• Collaborating with the front-end developers and other team members to establish objectives and design more functional, cohesive code to enhance the user experience and support analytical products

• Troubleshoot and diagnose production issues

Main Responsibilities:

• Should be accountable for the deliverables of assigned MS Dynamics CRM functionality
• Should be able to work with Business groups, Architects to understand the functional expectations, produce technical solutions and documentation
• Should be able to conceptualize and design solution, independently customize, develop/code using MS Dynamics 365 and technologies such as C#, .Net, Integration technologies including SQL Server & Kingsway Soft
• Should be able to own technical impediments, liaise with various groups and troubleshoot /resolve
• Participate in the Scrum process activities including Sprint Planning and Estimating sessions, Daily Stand-ups, Sprint Demos and Sprint retrospectives.

Basic Qualifications:

• 4+ years’ strong experience in MS dynamics 365 implementations & support and extensive experience with C#, .NET, JavaScript, Power apps
• Strong experience in Web API development and plug in’s
• Strong experience in integration technologies including SQL Server & KingswaySoft to connect internal & third-party systems
• Experience with Power BI, SQL Server Integration Services, ASP.net, client-side JavaScript frameworks, Xamarin.

Preferred Qualifications:

• Strong experience using Microsoft Azure Dev Ops, MS Visual Studio and MS SQL server

What you need to have:

We are looking for a Senior Microsoft SQL Developer to design, develop, test, plan, implement and maintain conceptual and logical database models.

For this role, you should know how to analyze system requirements and implement migration methods for existing data. Hands-on experience with SQL Server 2012 and above is also required. Ideally, you are familiar with database design, reviewing code, writing stored procedures, creating and modifying SQL agent jobs, making structural changes to tables and views.

Ultimately, you will develop database solutions to ensure project information is stored effectively and securely.

We’re a fast-growing company with clients in the United States, UK, and Australia. You will join a team of talented developers, quality engineers, product managers whose mission is to impact above 100 million people across the world with technological services by the year 2030.

Working as Senior Microsoft SQL Developer at Navtech, you will:

1. Design conceptual and logical data models and flowcharts.
2. Improve system performance by conducting tests, troubleshooting, and integrating new elements.
3. Design and Build database systems of high availability and quality depending on each end user’s specialized role.
4. Help write and optimize in-application SQL statements.
5. Handle common database procedures such as upgrade, backup, recovery, migration, etc.
6. Ensure performance, security, and availability of databases.
7. Use high-speed transaction recovery techniques and backup data.
8. Provide proactive and reactive data management support and training to users.
9. Determine, enforce and document database policies, procedures, and standards.
10. Perform tests and evaluations regularly to ensure data security, privacy, and integrity.
11. Monitor database performance, implement changes, and apply new patches and versions when required.

1. 5+ years of experience in SQL Server Development with at least 1 year of Lead experience.
2. Advanced experience in database monitoring, troubleshooting, performance tuning, and high availability strategies for SQL Server 2016, SQL Server in Cloud (AWS RDS preferred).
3. Advanced skills in resolving database locking conflicts/blocking and resource utilization.
4. Ability to work with other developers and engineers to analyze database performance and identify problems in areas such as execution plans, index coverage, and SQL server statistics.
5. A thorough understanding of Performance Monitoring, Tuning, and Optimization, using native and third-party monitoring and troubleshooting tools.
6. Advanced knowledge of SQL Server Disaster Recovery (DR) options, Always On availability groups, and experience administering Windows Server, including Active Directory, Failover clustering, database partitioning, security, and encryption (a plus).
7. Experience supporting SSIS, SSRS, replication, database mirroring (a plus).
8. PowerShell scripting experience with the ability to write automated scripts and strong knowledge of system tables and DMV’s is required. (a plus).
9. Administering Microsoft SQL Server databases in a high transaction, 24x7 database environment (a plus).
10. Experience in Postgres, No-SQL databases (a plus).
11. MCSA SQL Server 2012/2016 , MCSE or MCDBA (a plus).
12. Should have excellent logical, analytical, and communication skills with client interaction experience.

Benefits

• Working with industry giants while following your passion for technology.
• Competitive pay package with additional bonus and benefits.
• Performance review and Appraisal Twice a year.
• Family Health Insurance cover for self and family.
• Work with US, UK, and Europe-based industry-renowned clients for exponential technical growth.
• Work with a culturally diverse team from different geographies

Requirement:-
1. Strong PHP Core programming expertise
2. MySQL DB Model Design and Programming expertise
3. Strong skills in either Joomla or WordPress - at least one is needed.
4. Working know how of HTML 5/ CSS 3
5. Knowledge of SVN or any other version control tools
6. Must have solid REST/API implementation and integration concepts.

Preferred addons :-
1. Good to have Frontend Skills in - Javascript/JQuery/Bootstrap/Angular
2. Experience in common third-party social APIs (google, Facebook, eBay etc)
3. Experience with Payment Gateway integration with APIs like (paypal, payza, authorise.net, Firstdata, Ipayout, Stripe etc)
4. Any experience in Ionic / PhoneGap is a plus

Benefits
1. 6 months of probation period.
2. Working Days: Monday-Friday (As per International Standards).
3. Working Timings: 9 hours per day including break of 1 hour
4. Opportunities to learn and grow.