Principal Software Engineer(Database)

  • Full-time

Company Description

insightsoftware is a growing, dynamic computer software company that helps financial reporting solutions. At insightsoftware, you will learn and grow in a fast-paced, supportive environment that will take your career to the next level. We are looking for future insighters who can demonstrate teamwork, results orientation, a growth mindset, disciplined execution, and a winning attitude to join our growing team!

Job Description

We’re looking for a creative, talented Database Engineer to join our fast-growing Software Engineering group. Working on an Agile development team, you will be responsible for developing, and supporting our class-leading suite of Financial Software Products servicing the office of the CFO.

We enjoy our work as much as we enjoy working together and want Engineers who can get things done while having a positive influence on our workplace environment. The successful candidate must have a passion for software development, deeply care about code quality, and be committed to software craftsmanship.

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.

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.

Qualifications

  • BE/B.Tech in Computer Science, Computer Engineering, or related technical discipline.
  • 9+years of overall database engineering experience
  • 2+ years of commercial software engineering experience.
  • Proficient in SQL, PL/SQL for structured and non-structured data, and SQL & ORM Query optimization and tuning.
  • Hands on working knowledge on traditional DBs like Oracle, SQL Server and Cloud Databases especially AWS Managed Databases such as Aurora MySQL and Postgres
  • Must be able to identify and implement performance improvements for DB tables/schemas by indexing, keys, costing, etc.
  • Familiarity with implementing and supporting databases in an AWS Cloud Infrastructure environment.
  • Experience with Cloud Database management and configurations in the areas of; Cloud DB Performance, Cost Optimization, Multiregional, Scalability, Replication, Utilization, Security, Accounts optimization
  • Knowledge of MVVC architectures and frameworks such as Node, Nest, Spring-Hibernate is a plus
  • Exposire with Python and .NET C# / .NET Core.
  • 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.

Additional Information

All your information will be kept confidential according to EEO guidelines.

** At this time insightsoftware is not able to offer sponsorship to candidates who are not eligible to work in the country where the position is located. **

insightsoftware About Us: Hear From Our Team - InsightSoftware (wistia.com)