Database Architect/Database Warehouse Management - Chicago
|Position Title:||Database Architect/Database Warehouse Management|
Working At Aetna -- the Value To You
What does it mean to work at Aetna? A lot. From programs and benefits that support your financial, physical and emotional health to opportunities to build your knowledge and expand your career, the company makes working here a valuable experience in many ways.
bswift, an Aetna portfolio company, is a Chicago-based technology company that provides industry-leading benefits administration for employers and exchanges nationwide. We are currently looking for a Database Architect/Database Warehouse Management to join our team in our Chicago, IL location.
Positon Summary: The successful candidate is responsible for directly supporting the daily administration of the Microsoft SQL Servers used at bswift Database Management and Data Warehouse environments, as well as the application databases used for EDI, Imports, Infrastructure and other business applications. Will provide technology strategy, direction, management and support to business systems delivery and maintenance. Will also help build bswift generation platform for operational and Business Intelligence.
Maintain and implements new databases for various bswift environments as production, sandbox, QA, development or performance.
Monitors capacity and performance for production and non-production databases to ensure they are highly reliable, efficient, cost effective, and provide the required functionality.
Seeks opportunities to improve database performance by identifying tuning measures and implementing them when appropriate.
Ensures that all required production and non-production databases are properly backed up and recovered when required. Develops and maintains database backup and recovery procedures.
Tests upgrades/new releases of database software and related products. Assesses impacts to customers and the database environment.
Plays major contributor role in the testing and evaluating of new database products and tools. This includes the determination of their applicability to the database environment.
Maintain, enhance, develop and administer complex ETL solutions using MS SQL Server 2014 SSIS packages as well as Microsoft Analysis Services cubes (including DMVs and dimensions). Ability to write complex DMX queries.
Construct architecture for hourly/nightly aggregations and summarizations needed in Data Warehouse.
Provide expertise on decisions and priorities regarding the enterprises overall data warehouse architecture.
Establish methods and procedures for tracking data quality, completeness, redundancy and improvement; and processes for governing the identification, collection and use of corporate metadata to assure metadata is accurate and valid in the business intelligence environments.
Provides input to the process of integrating vendor application software into the bswift infrastructure.
Provides database problem resolution support, including off-hours coverage, based on required business service levels.
Provides transfer of knowledge and skills to other team members, application areas, and business customers.
Actively participate in day-to-day interactions with various cross-functional teams of developers, DBAs and associate product managers.
Evaluate and implement products and implement best-practices to enhance bswift Database Management and Data Warehouse solutions.
How to apply
Please use the "Apply" link to apply to this position. If you cannot view this link, you can find this position on our website by visiting: , click on apply online, search openings, and enter 38541BR in the keyword field. Additional information on what its like to work for Aetna and more can also be found on our website.
We value leadership, creativity and initiative. If you share those values and a commitment to excellence and innovation, consider a career with Aetna.
Aetna does not permit the use of tobacco related products or drugs in the workplace.
Aetna is an EO/AA Employer-Minorities/Women/Veterans/Disability.
No search firms please.
You will not be asked for personal information until you have been fully evaluated through Aetna's screening processes. Aetna will never ask applicants for money. If you want to verify the identity of someone who contacts you from Aetna, call 1-800-AETNAHR (1-).
Here are some of our newer ads
|Database Architect/Database Warehouse Management|