Application DBA

Date: Jul 28, 2019

Location: Greensboro, NC, US

Company: Lincoln Financial

Alternate Locations: Greensboro, NC (North Carolina)

Relocation assistance is not available for this opportunity.

Requisition #58423

About the Company

Lincoln Financial Group, a Fortune 250 company with over 10,000 employees, provides advice and solutions that help empower Americans to take charge of their financial lives with confidence. Our core business areas — Life Insurance, Annuities, Retirement Plan Services and Group Protection — focus on supporting, preserving and enhancing over 17 million customer’s lifestyles and retirement outcomes.

Headquartered in Radnor, Pennsylvania, Lincoln Financial Group is the marketing name for Lincoln National Corporation (NYSE: LNC) and its affiliates. The company had $253 billion in assets under management as of December 31, 2017.

Ranked one of the Best Large Employers in America by Forbes magazine, Lincoln Financial Group makes a serious investment in our employees’ futures through a broad range of wealth accumulation and protection plans, health and wellness programs, and career development resources designed to help each individual reach their personal and professional goals.

 

The Application DBA will take ownership of defining relationships between various related data sources and created a new data source to perform operational reporting with new analytics tools such as Tableau and other emerging tools.  

Position would also advise on how best to extend our data model for new requirements and identifying new opportunities using our new data model.

 

Primary Function of the position:

  • Clearly understand existing MSSQL, ORACLE databases schemas translate them into data new structures/models for use.
  • Provide query optimization guidance and assistance to developers.
  • Perform query analysis to optimize existing queries and indexes.
  • Maintain data model/data dictionary, identifying any gaps or inaccuracies.

 

Requirements:

  • Minimum of 3-5 years overall IT experience; 2 years of data modeling and data management with Oracle
  • Skilled  in conceptual, logical, and physical data modeling
  • Expert level skills using SQL, skills tuning queries, and experience with data modeling tools and techniques
  • Preferred but not required:
  • Experience working with legacy systems a plus.
  • Data warehouse and BI experience a plus
  • AWS skills with the following components and tools
  • S3 (Simple Storage Service), EC2 (Elastic Compute 2), EMR (Elastic Map Reduce aka Hadoop), RDS (Relational Database Service), ElasticSearch, Lambda, Elastic Beanstalk, Data Pipeline, SQS (Simple Queue Service), Kinesis, VPC
  • IAM Roles, Ranger, Kerberos  (security related). Minimal travel. #LI-AY1

 

This position may be subject to Lincoln’s Political Contribution Policy.  An offer of employment may be contingent upon disclosing to Lincoln the details of certain political contributions. Lincoln may decline to extend an offer or terminate employment for this role if it determines political contributions made could have an adverse impact on Lincoln’s current or future business interests, misrepresentations were made, or for failure to fully disclose applicable political contributions and or fundraising activities.

Any unsolicited resumes/candidate profiles submitted through our web site or to personal e-mail accounts of employees of Lincoln Financial Group are considered property of Lincoln Financial Group and are not subject to payment of agency fees.

Lincoln Financial Group (“LFG”) is an Equal Opportunity employer and, as such, is committed in policy and practice to recruit, hire, compensate, train and promote, in all job classifications, without regard to race, color, religion, sex (including pregnancy), age, national origin, disability, sexual orientation, gender identity and expression, veterans status, or genetic information.  Applicants are evaluated on the basis of job qualifications.  If you are a person with a disability that impedes your ability to express your interest for a position through our online application process, or require TTY/TDD assistance, contact us by calling 260-455-2558.

#P3 


Nearest Major Market: Greensboro

Job Segment: Database, DBA, Oracle, Developer, ERP, Technology