Data Warehouse Architect / DBA - Lansing, MI
Applied: No
| Date Posted: | Tuesday, February 6th, 2024 |
| Job Location: | Lansing, MI |
| Pay Rate: | Competitive |
| Employment Type: | Full-time |
| Job Duration: | Permanent |
| Required Skills: | Analysis, Architecture, Database, Database Administration, Database Administrator, Data Modeling, Data Warehouse, DBA, ERwin, Genetic, Hardware, Linux, Management, Modeling, Project, Security, SQL, Teradata, Unix, Validation |
Job Description:
Optum gives you the opportunity to showcase your passion and technical expertise, to transform health care, as we change the way our businesses and consumers engage with technology.
With a technology career at Optum, you have an amazing power to transform the health care industry and improve peoples' lives. We are a top notch health care company that is driven by the latest technology enabling us to significantly improve the quality of health care and improve the lives of tens of millions. This is a unique opportunity for you to make an impact by utilizing your technical expertise to help people live healthier lives. This is where you will work with the best and the brightest and together make positive change a reality. This where you will do your life's best work.(sm)
In this exciting role, as a Data Warehouse Architect / DBA, you will work with state-of-the-art relational database technologies and be part of a team of highly skilled IT Database professionals working on mission critical applications and systems.
As a Data Warehouse Architect / DBA, you will be responsible for the design, implementation, support and maintenance of all functions of relational database systems. You will be responsible for the following: database access, methods and time, device allocations, validation checks, organization, security, documentation, and statistical methodology. In this role, you will monitor overall standards and procedures and assist in integrating various systems. You will also consult with users, determine requirements and recommend database establishment and utilization.
Primary Responsibilities:
Provide database administration for mission-critical client projects in complex database environments
Perform database modeling for mission-critical client projects
Uphold enterprise policy guidelines and recommend new/improved guidelines
Partner with project teams and interact with customers to design/develop solutions for projects and operational issues for existing and proposed databases
Act as a liaison serving as primary point of contact between application business segments and database administrators
Demonstrate the knowledge and ability to perform in all of the basic database management skills of database administration, Web connectivity, physical structure, overall architecture, and database analysis
Provide standardization and consistency across environments
Ensure a stable and secure database environment
Implement and monitor database functionality to ensure stable environments
Identify and initiate resolutions to user problems and concerns associated with database server equipment (hardware and software)
Anticipate customer needs and proactively develop solutions to meet them
Serve as a key resource on complex and/or critical issues
Solve complex problems and develop innovative solutions
Perform complex conceptual analyses
Review work performed by others and provides recommendations for improvement
Forecast and plan resource requirements
Review the work of others
Develop innovative approaches
Serve as Subject Matter Expert
Serve as a leader/mentor
Required Qualifications:
5+ years of data architect experience
5+ years of DBA experience with Teradata V12/13/14
5+ years with experience in ETL using Teradata Utilities in a Unix/Linux environment
Experience with performance tuning within a large database or data warehouse environment (SQL, Explains, etc.)
Advanced SQL Skills
3+ years of experience working with end users/customers to understand requirements, and system and business issues
3+ years of experience performing technical analysis to develop solutions for end user/customer
Preferred Qualifications:
Experience working in a state government environment
Healthcare industry experience
Experience with BI reporting
Experience modeling database solutions
Experience using ERWin for data modeling
Careers with Optum. Here's the idea. We built an entire organization around one giant objective; make health care work better for everyone. So when it comes to how we use the world's large accumulation of health-related information, or guide health and lifestyle choices or manage pharmacy benefits for millions, our first goal is to leap beyond the status quo and uncover new ways to serve. Optum, part of the UnitedHealth Group family of businesses, brings together some of the greatest minds and most advanced ideas on where health care has to go in order to reach its fullest potential. For you, that means working on high performance teams against sophisticated challenges that matter. Optum, incredible ideas in one incredible company and a singular opportunity to do your life's best work.(sm)
Diversity creates a healthier atmosphere: All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national origin, protected veteran status, disability status, sexual orientation, gender identity or expression, marital status, genetic information, or any other characteristic protected by law.
UnitedHealth Group is a drug-free workplace. Candidates are required to pass a drug test before beginning employment.
Job Keywords: Database Administrator; Relational Database, DBA, Database Administration, Database Administrator, Information Technology, IT, SQL, UNIX environment, technology, Optum, Lansing, MI, Michigan
Job Title: Data Warehouse Architect / DBA - Lansing, MI
Shift: Day Job
Travel: No
Business: Optum Data Management
Family: Information Technology
Telecommuter Position: No
Job Level: Individual Contributor
Overtime Status: Exempt
City: Lansing
State: MI
Country: United States
Department: Optum Data Management
About UnitedHealth Group:
We have modest goals: Improve the lives of others. Change the landscape of health care forever. Leave the world a better place than we found it. Such aspirations tend to attract a certain type of person. Crazy talented. Compassionate. Driven. To these individuals, we offer the global reach, resources and can-do culture of a Fortune 14 company. We provide an environment where you’re empowered to be your best. We encourage you to take risks and in return, offer a world of rewards and benefits for performance. Exceeding your limits is an exceptional start to your life's best work.(SM) Just like you, we are driven by a set of fundamental principles that are guiding our way forward. Our values of integrity, compassion, relationships, innovation, and performance serve as a foundation to transform health care. Are you in? Learn more about your future at UnitedHealth Group at http://careers.unitedhealthgroup.com
Browse IT Jobs by location:
Remote Jobs:
To search for remote jobs, enter optional keywords followed by Remote.
To search for remote jobs in a specific country, add that country. For example, Remote UK.
Special Locations:
Enter Silicon Valley or
San Francisco Bay Area
IT Jobs in Canada:
Alberta – 11 jobs
British Columbia – 10 jobs
Manitoba – 0 jobs
New Brunswick – 0 jobs
Newfoundland and Labrador – 0 jobs
Northwest Territories – 0 jobs
Nova Scotia – 0 jobs
Nunavut – 0 jobs
Ontario – 13 jobs
Prince Edward Island – 0 jobs
Quebec – 0 jobs
Saskatchewan – 0 jobs
Yukon – 0 jobs
IT Jobs in the United Kingdom:
England – 59 jobs
Northern Ireland – 0 jobs
Scotland – 0 jobs
Wales – 0 jobs
IT Jobs in the United States:
Alabama – 2 jobs
Alaska – 1 job
Arizona – 4 jobs
Arkansas – 14 jobs
California – 100 jobs
Colorado – 16 jobs
Connecticut – 8 jobs
Delaware – 2 jobs
District of Columbia – 15 jobs
Florida – 31 jobs
Georgia – 13 jobs
Hawaii – 2 jobs
Idaho – 2 jobs
Illinois – 14 jobs
Indiana – 9 jobs
Iowa – 8 jobs
Kansas – 1 job
Kentucky – 4 jobs
Louisiana – 4 jobs
Maine – 0 jobs
Maryland – 11 jobs
Massachusetts – 43 jobs
Michigan – 6 jobs
Minnesota – 11 jobs
Mississippi – 0 jobs
Missouri – 5 jobs
Montana – 0 jobs
Nebraska – 1 job
Nevada – 1 job
New Hampshire – 1 job
New Jersey – 48 jobs
New Mexico – 2 jobs
New York – 152 jobs
North Carolina – 17 jobs
North Dakota – 0 jobs
Ohio – 18 jobs
Oklahoma – 2 jobs
Oregon – 26 jobs
Pennsylvania – 22 jobs
Rhode Island – 3 jobs
South Carolina – 4 jobs
South Dakota – 0 jobs
Tennessee – 3 jobs
Texas – 48 jobs
Utah – 8 jobs
Vermont – 0 jobs
Virginia – 19 jobs
Washington – 31 jobs
West Virginia – 0 jobs
Wisconsin – 5 jobs
Wyoming – 0 jobs
Our commitment to job seekers
Job seekers, we're committed to making your job search experience a breeze. Please, note the following four things:
- We never ask you to register or fill out an application form with a million questions. Everything is in your resume, and if job posters have questions, they can and should follow up with an interview. That's what an interview is for!
- We never direct you to various third-party websites or Applicant Tracking Systems (ATS) where you have to register or fill out the same huge application forms again and again and again
- We use Ajax to submit your resume, and here's the zest of our website
- By default, we save your application information in local storage. If your cover letter is generic enough, you'll save a few keystrokes when you apply for another job!
It's extremely easy to submit your resume to multiple jobs on our website! Please, check us out and help spread the word about us!
Our domain name is easy to remember. Those who know C++, C# or Java will easily recognize the static keyword in our company name.
Now, if you're really brave, we encourage you to read about some serious problems this website addresses. These problems plague all niche job boards out there as well as the big guns in the recruitment industry. This is the most important part! Please, read it!
