Responsibilities

• Writing advanced SQL, analyzing developer SQL and make recommendations for performance tuning SQL, rewriting SQL, or adding indexes for efficiency and creating/updating stored procedures.
• Creating stored procedures, triggers, functions, packages, Logical and Physical database design.
• Operate in an agile development team and participate in the design, development, testing, and debugging of applications.
• Work with a technical lead and product manager to clearly define product requirements.
• Work with colleagues and engineering leadership to define technical solutions that meet business requirements.
• Develop clean, elegant, and reusable code that is easy to maintain and extend.
• Ensure that the architectural integrity of the source code is maintained and improved.
• Identify improvements to reduce technical debt.
• Conduct efficient code reviews and enforce team coding standards.

Qualification and Experience

• BS in Computer Science, Computer Engineering, or related technical discipline.
• 5+ years of commercial software engineering experience.
• Proficient in .NET C# and .NET Core
• Hands on working knowledge of Cloud Databases especially AWS Managed Databases such as Aurora MySQL and Postgres
• Experience with Cloud Database management and configurations in the areas of; Cloud DB Performance, Cost Optimization, Multiregional, Scalability, Replication, Utilization, Security, Accounts optimization
• Hands on working with SQL, PL/SQL for structured and non-structured data, and SQL & ORM Query optimization and tuning.
• Familiarity with implementing and supporting databases in an AWS Cloud Infrastructure environment.
• Knowledge of MVVC architectures and frameworks such as Node, Nest, Spring-Hibernate is a plus
• Must be able to identify and implement improvements for DB tables/schemas by indexing, keys, costing, etc.
• Exposure to various web technologies such as gRPC, SOAP, REST, and OData.
• Experience in SCRUM or other agile development processes.
• DevOps mindset with proven ability to architect and optimize an agile CI/CD pipeline including continuous testing
• Strong experience with modern application development workflows and version control systems like GitHub, Gitlab, or Bitbucket.
• High proficiency in writing automated tests using NUnit testing framework.

Competencies

To perform the job successfully, an individual should demonstrate the following competencies:

• Discipline and Perseverance – Focus and commitment to solving complex issues through to completion.
• Flexibility and Hard Work – Operate in a fast-paced, iterative development environment; learn and adapt to new technologies.
• Problem Solving – Strong critical thinking and problem-solving capabilities.
• Quality – Dedicated to producing high-quality software and implementing development best practices.
• Team Work – Communicate effectively and operate in a team environment.
• Effective Communicator - Strong written and oral communication skills.
• Excellent time management skills - a proven ability to utilize your sense of urgency to prioritize tasks effectively.
• Self-Improvement - actively self-improves through individual learning, coursework, or otherwise.

MV