SQL Engineer- Software Engineer II

Company: SunTrust
Location: Charlotte
Posted on: March 19, 2023

Job Description:

The position is described below. If you want to apply, click the Apply button at the top or bottom of this page. You'll be required to create an account or sign in to an existing one.

Need Help?

If you have a disability and need assistance with the application, you can request a reasonable accommodation. Send an email to Accessibility (accommodation requests only; other inquiries won't receive a response).

Regular or Temporary:

Regular

Language Fluency: English (Required)

Work Shift:

1st shift (United States of America)

Please review the following job description:

Deliver technically complex solutions. Perform system integration support for all project work. Consult and partner with the business product owners to understand the end goal and offer solutions and recommendations during the design.

In this role you will be a member of the Truist Dealer Retail Services Technology team providing full system lifecycle support including development, test, and implementation of highly robust and reliable solutions. This position will also include working in collaboration with engineers in other groups to ensure that the applications adhere to corporate standards and technologies. The candidate will be expected to follow standard development methodologies and companywide best practices for engineering technical solutions that require an understanding of industry best practices. Responsibilities will include analysis, design, development, and implementation of new auto loan servicing initiatives using Microsoft T-SQL, SSIS, and SSRS. Will attend second level support calls as necessary.

ESSENTIAL DUTIES AND RESPONSIBILITIES
Following is a summary of the essential functions for this job. Other duties may be performed, both major and minor, which are not mentioned below. Specific activities may change from time to time.

• Develop customized coding, software integration, perform analysis, configure solutions, using tools specific to the project or the area.
  
• Lead and participate in the development, testing, implementation, maintenance, and support of solutions in adherence to company standards, including support for subsequent release testing.
  
• Build in and maintain security controls and monitoring in support of company standards.
  
• Take ownership of task and contribute to larger, more complex initiatives.
  
• Solve complex technical and operational problems.
  
• Partner with the business owners to provide solutions that meet their goals and expectations.
  
• Provide application support (Hands on) including complex problem research, analysis, resolution including attending production support calls when necessary.
  
• Analyze, debug, and fix batch job failures.
  
• Work on multiple highly visible, business critical Application support and initiatives simultaneously.
  
• In an Agile environment: Responsible for delivering high quality working software and automating manual/reusable tasks working directly, and engage with, the business from the beginning of the design work. Leverage continuous engineering practices to deliver business value regarding effectiveness of the design. Actively participate in refining user stories. Responsible for design, developing, and maintaining automated unit testing, and supporting integration and functional testing. Responsible for providing automated monitoring capabilities, providing warranty support, and providing knowledge transfer to production support. Develop code in accordance with the acceptance criteria established by the Product Owner.
  QUALIFICATIONS
  Required Qualifications
  The requirements listed below are representative of the knowledge, skill and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
  1. Bachelor's Degree and four to seven years of experience or equivalent education and software engineering training or experience
  2. In-depth knowledge in information systems and ability to identify, apply, and implement IT best practices
  3. Understanding of key business processes and competitive strategies related to the IT function
  4. Ability to plan and manage projects and solve complex problems by applying best practices
  5. Ability to provide direction and mentor less experienced teammates. Ability to interpret and convey complex, difficult, or sensitive information
  
  Preferred Qualifications:
  
  • 3+ years of Software Engineering experience, or equivalent demonstrated through one or a combination of the following: work experience, training, military experience, education
    
  • 2+ years of experience with T-SQL
    
  • 2+ years of experience with SQL Server Integration Services (SSIS)
    
  • 2+ years of experience with SQL Report development (SSRS)
    
  • Solid knowledge of relational database design and development (SQL, stored procedures, data modeling), SSIS packages and SSRS reports.
    
  • Skills in troubleshooting integrity issues, blocking/deadlocking issues, replication, connectivity, and security issues
    
  • Knowledge and understanding of secure SDLC (System Development Life Cycle) methodologies
    
  • 2+ years of C#.NET experience
    
  • 2+ years of web application development experience
    
  • Experience with Azure DevOps CI
    
  • Auto Finance industry experience is an advantage
    
  • Strong verbal, written, and interpersonal communication skills
    
  • BS/BA degree in Computer Science and/or related discipline
    
  • Continuous Integration and Continuous Development experience
    
  • Experience with source control i.e. GIT
    
    OTHER JOB REQUIREMENTS / WORKING CONDITIONS
    
    Sitting
    Constantly (More than 50% of the time)
    Standing
    Frequently (25% - 50% of the time)
    Walking
    Frequently (25% - 50% of the time)
    Visual / Audio / Speaking
    Able to access and interpret client information received from the computer and able to hear and speak with individuals in person and on the phone.
    Manual Dexterity / Keyboarding
    Able to work standard office equipment, including PC keyboard and mouse, copy/fax machines, and printers.
    Availability
    Able to work all hours scheduled, including overtime as directed by manager/supervisor and required by business need.
    Travel
    Minimal and up to 10%
    
    General Description of Available Benefits for Eligible Employees of Truist Financial Corporation: All regular teammates (not temporary or contingent workers) working 20 hours or more per week are eligible for benefits, though eligibility for specific benefits may be determined by the division of Truist offering the position. Truist offers medical, dental, vision, life insurance, disability, accidental death and dismemberment, tax-preferred savings accounts, and a 401k plan to teammates. Teammates also receive no less than 10 days of vacation (prorated based on date of hire and by full-time or part-time status) during their first year of employment, along with 10 sick days (also prorated), and paid holidays. For more details on Truist's generous benefit plans, please visit our Benefits site. Depending on the position and division, this job may also be eligible for Truist's defined benefit pension plan, restricted stock units, and/or a deferred compensation plan. As you advance through the hiring process, you will also learn more about the specific benefits available for any non-temporary position for which you apply, based on full-time or part-time status, position, and division of work.
    
    Truist supports a diverse workforce and is an Equal Opportunity Employer that does not discriminate against individuals on the basis of race, gender, color, religion, citizenship or national origin, age, sexual orientation, gender identity, disability, veteran status or other classification protected by law. Truist is a Drug Free Workplace.
    
    EEO is the Law Pay Transparency Nondiscrimination Provision E-Verify

Keywords: SunTrust, Charlotte , SQL Engineer- Software Engineer II, IT / Software / Systems , Charlotte, North Carolina