Lead Software Engineer

Skills Required:

• 7+ years of experience as software engineer.
• Experience in Dot.Net technologies - Asp.Net MVC, WebAPI, .NetCore
• Experience in ORM like Entity Framework /Dapper
• Experience with Object-Oriented Design and SOLID principles
• Experience with Unit Testing, Mocking and Dependency Injection frameworks
• Experience with SQL Server, NoSQL or other database technology
• Experience with software quality, testing procedures and build automation tools
• Knowledge of the Principles & Patterns of Agile Software
• Ability to understand and troubleshoot existing code and maintain existing systems.
• Ability to identity performance bottlenecks.
• Experience working with version control tools such as GIT and CI/CD tools.

Qualifications Required:

Education: Relevant degree in software engineering fields; training in principles and techniques of software development.

Experience: 1-5 years of relevant software architecture, software development and software testing experience.

Skills:

• Strong technical skills in .Net, C#, VB, SQL Server 2008, Oracle, AJAX, Web Services. Strong English reading and writing communication skills, with an ability to express and understand complex technical concepts. Strong analytical, problem-solving, and conceptual skills. Ability to work in teams and has strong interpersonal skills. Ability to work under pressure and meet tight deadlines. Ability to deal with clients and travel to project sites. Possess good organizational skills. Demonstrated ability to lead a moderate group of software engineers and also able to work independently. Ability to anticipate potential problems, determine and implement solutions.

Responsibilities: Responsible for software development activities throughout the project, including key phases of process such as development, testing, implementation.

Other: Be familiar with systems concepts design and standards. Good awareness and practical approach of standard SDLC and be quickly able to understand adhere to coding standard followed by Ember Technologies Pvt. Ltd.

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