US
0 suggestions are available, use up and down arrow to navigate them
What job do you want?

Senior SQL Developer job in Alpharetta at LanceSoft Inc

Create Job Alert.

Get similar jobs sent to your email

List of Jobs

Apply to this job.
Think you're the perfect candidate?
Senior SQL Developer at LanceSoft Inc

Senior SQL Developer

LanceSoft Inc Alpharetta, GA Full-Time
The Senior SQL Developer will be responsible for designing, developing, documenting, and supporting the company finance account system of record. This position is responsible for leading a small team to refactor key processing functions of the legacy system into stored procedures with a goal of optimizing current processing for performance and resiliency.
 
Essential Responsibilities:

Will be responsible for converting legacy financial systems from VB6 to T-SQL. Strong financial experience required. For example, financial settlements, principal payments, etc.
  • Develop the technical approach, database design, and execution for the refactor of the legacy system of record
  • Optimize query performance by modifying existing queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing table objects
  • Work with delivery team to understand functional requirements and interact with other cross-functional teams to architect, design, develop, test, and release features.
  • Support multiple teams with planning, scoping and creation of technical solutions for the new product capabilities, through to continuous delivery to production.
  • Perform other duties and/or special projects as assigned
Qualifications/Requirements:
  • B.S. in Computer Science, Mathematics, or Engineering or equivalent work experience
  • 7+ years of experience in the full life cycle of designing and developing databases and applications using MS-SQL Server
  • 5+ years experience developing database solutions in the consumer finance industry
  • Expertise creating, deploying, and supporting SSIS packages, T-SQL queries, and stored procedures
  • Expertise in sophisticated relational database report design, development and maintenance using reporting tools such as MS Access - Writing Transact-SQL Stored Procedures
  • Relational Database Design/Development to include performance Tuning, error handling via TRY/CATCH with event logging, locking/block management
  • Experience in SSIS, SSRS and Service Broker
  • Experience developing and maintaining ETL processes that support data movement across platforms in a hybrid environment
  • Team player with strong communication and interpersonal skills, possess a high degree of self-motivation and ability to work independently with minimal supervision
  • In-depth knowledge in business analysis, requirements definition and translation, as well agile methodologies and software development lifecycle
  • Perform other duties and/or special projects as assigned
Desired Characteristics:
  • Strong attention to detail as well as organization and time management skills
  • Ability to work with teams to gather and analyze unrefined business requirements from multiple sources and formulate and deliver a test plan in a timely manner
  • Ability to work under the pressure of multiple projects and deadlines at once
  • Highly motivated self-starter with a high level of demonstrated initiative
  • Ability to quickly learn, adapt, and think outside the box

Recommended Skills

  • Sql Server Reporting Services
  • Extract Transform Load (Etl)
  • Database Design
  • Sql Server Integration Services
  • Relational Databases
  • Data Modeling
Apply to this job.
Think you're the perfect candidate?

Help us improve CareerBuilder by providing feedback about this job:

Job ID: MjIyMjoyMi0xNDM3NjItNDMx

CareerBuilder TIP

For your privacy and protection, when applying to a job online, never give your social security number to a prospective employer, provide credit card or bank account information, or perform any sort of monetary transaction. Learn more.

By applying to a job using CareerBuilder you are agreeing to comply with and be subject to the CareerBuilder Terms and Conditions for use of our website. To use our website, you must agree with the Terms and Conditions and both meet and comply with their provisions.