Senior Database Developer - Data Modeling & DB Design Schema

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.

.Net Core Developer

Experience 2+ Yrs in .Net Core/C# Responsibilities Responsible for designing and developing REST APIs using .Net Core Framework and C#. Create high-performance REST APIs for financial applications. Qualifications B.Tech/BE or MCA – May be relaxed in the case of experienced candidates.

Experience At least 2+ Years of experience as .Net Core Developer Proficient in .Net Core and C# Excellent knowledge in developing REST APIs and Entity Framework Knowledge and experience in writing SQL, SPs, and Triggers Sound knowledge in MVC frameworks and databases. Good project management skills. Good communications skills A good team player

Salary 2 -8 LPA

Job Profile

Purpose of Role: To support and maintain the existing and future applications managed by ABD (Agile Business Development) Team.

Main Responsibilities:

• To work on existing and future applications as required
• Work with ABD India Application Support and Business Support team to address production issues and/or to do development work
• Work with US ABD team to coordinate the on-going support and monthly release of C-Hub (Customer-Hub) application and other ABD Applications
• Report status to management on project progress
• Identify and escalate related issues and risks
• Coordinate with others in Development and Business Support team to implement new features of SQL Server/ MS Web based technologies 
• Assess current modules and offer performance improvements techniques  
• Make sure Database Design Standards/coding standards established by ABD are followed
• Constant communication with ABD leadership team in US.
• Problem Solving ability with “Can-do” attitude
• IT experience in Banking industry is preferred

Candidate Profile:

• Minimum 10 years of experience at least 3-5 years of experience in Corporate & Investment Banking area and Bachelor's degree in Engineering, Accounting, Finance, or equivalent
• Expertise with MS SQL Server development including SSIS and SSRS, Proficient in development of Stored procedure, Views, Functions etc in MS SQL Server
• Experienced with DBA kind tasks such as replication, linked server, query analyzer, DBCC commands, data transfer from one DB server to other DB Server etc
• Experienced in MS Excel VBA and macro scripting
• Knowledge of data Encryption in database

Envoy combines technology and global immigration services to offer the only immigration management platform that makes it seamless for companies to hire and manage an international workforce. We empower companies to acquire the best talent regardless of where they are in the world; helps mobilize employees around the world to take advantage of business opportunities; and enables the management of entire global workforces, providing a strategic, proactive view into workforce and financial forecasting and compliance. We are a fast-growing, award-winning technology company, a leader in our space, and are backed by some of the country’s leading venture capital and growth equity firms.

Our Engineering Team

We have a passionate product engineering team that works on complex technical challenges, employs creativity, and constantly learns a variety of frameworks, tools, and technologies. While we are dedicated to delivering excellent product, we also believe having fun along the way motivates us to pour our heart into what we do. Our team has mastered development and delivery process, allowing the team to focus on designing, architecting, and crafting masterpieces.

We are growing rapidly and expanding our team in India, join our product engineering team to be part of this exciting journey.

“Any fool can write code that a computer can understand. Good programmers write code that humans can understand.” – Martin Fowler

Skills Required

• 5+ years of strong programming experience on .NET platform
• Expertise in C#, ASP.NET Web API / Typescript / Angular (or any front-end framework or passion to learn Angular)
• Hands on experience with SQL
• Azure experience is a plus but not a deal breaker
• Knowledge and experience with Html, CSS, JavaScript
• Experience designing high-level and low-level design of the system
• Experience with microservices architecture is a plus

Expectations

• Contribute to tech grooming backlog items providing design, architecture, and implementation details
• Quality is the key driver to successful delivery, ensure highly testable and quality deliverables
• Leverage troubleshooting and analytical skills to analyze issues
• Experience with debugging, performance profiling and optimization 

Relevant Experience

3 to 10 years

Job Description and Key Skills Required:

• Hands-on with any of the programming languages like NodeJS/ExpressJS, Python, Java, Php or any.
• Design and create efficient RESTful API endpoints for both internal and public consumption
• Strong understanding of database technologies such as MySQL, Postgress, Oracle , relational Database.
• Work closely with front end developers to understand required data model
• Comfortable deploying applications on AWS, and have a strong working knowledge of EC2, RDS and S3.
• Must understand overall system design, architecture , improve design and implement new processes.
• Strong understanding of sessions, cookies & local storage is must.
• Experience with in memory databases like redis basic, Memcache
• Independently think of solutions to complex requirements; possess exceptional logical skills.
• Analyse current products in development, including performance, scalability, diagnosis and troubleshooting.
• Work with the existing framework and evolve it by building reusable code & libraries
• Search and introduce new software related technologies, processes and tools.
• Bonus: You're fluent with React.
• Bonus: Interested in full-stack development.
• Bonus: Any experience of iOS/Android mobile development.
• Bonus: Experience with CI servers such as Jenkins, Travis or similar types
• Bonus: Experience with web server like Nginx

Reporting and Business Intelligence

Minimum of 8 to 10 years of experience in Report building and Business Intelligence with

Profound knowledge on Oracle BI Publisher and BI Analytics with Oracle Fusion HCM domain especially in Core HR, Payroll and Absences modules

Primary skill:

• Experience generating BI publisher reports, dashboards and drill-down reports
• BI Publisher (RTF design/ eText/ Scheduling/ Parameter Handling/Bursting/backup and migration of reports to different pods)
• Design Oracle BI Publisher Data Models, Data sets and Templates/sub-templates
• Strong PL/SQL and Advanced PL/SQL experience
• Solid understanding of performance tuning best practices and experience improving end-to-end processing times
• Knowledge on the data models related to Fusion HCM (Core HR, Absence and Payroll modules)

Nice to have skills:

• Experience generating BI publisher reports, dashboards and drill-down reports
• Strong OBI Administrator activity
• Create mobile applications with Oracle Business Intelligence Mobile App Designer
• Use BI Mobile to access BI Content
• Create and modify Interactive Dashboards
• Knowledge of additional reporting tools viz. HCM Extract / OTBI / Analysis Dashboard would be an added advantage

Behavioural and Process Skills

• Experience working in Agile teams
• Self-motivated and self-directed abilities to prioritize and execute tasks in a high-pressure environment with "time-critical" deadlines
• Proven analytical, evaluative, and problem-solving abilities
• Possesses a team and customer service provision orientation