Skip to main content

A new day in healthcare. Together, CVS Health and Aetna help people on their path to better health.

SQL Senior Database Admin - 64023BR

Primary Location: Chicago, IL
Additional Locations: IL-Chicago
Apply
Description:
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 Senior Architect 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 next generation platform for operational and Business Intelligence.

Fundamental Components:
· Maintain and implements new databases for various bswift environments as production, Sandbox, QA, UAT, 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.
· 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 2016 SSIS packages as well as Microsoft Analysis Services cubes (including DMVs and dimensions). Ability to write complex DMX queries.
· 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 database problem resolution support, including off-hours coverage, based on required business service levels.
· 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.
· Evaluate and implement products and implement best-practices to enhance bswift Database Management and Data Warehouse solutions.
· Analyzes designs, creates and implements databases, including access methods, device allocations, validation checks, organization and security.
· Designs data models, logical and physical databases, data dictionaries and schemas.

Background Experience:
· 10+ years of experience developing, maintaining and administering Microsoft SQL Server databases.
· 5+ years of experience with other Microsoft SQL Server products (SSIS, SSAS, SSRS) as well as BI concepts.
· 2+ Yrs of experience in Graph DB Neo4J (noSQL) Database Engineering.

Potential Telework Position:
No

Percent of Travel Required:
0 - 10%

EEO Statement:
Aetna is an Equal Opportunity, Affirmative Action Employer

Benefit Eligibility:
Benefit eligibility may vary by position. Click here to review the benefits associated with this position.

Candidate Privacy Information:
Aetna takes our candidate's data privacy seriously. At no time will any Aetna recruiter or employee request any financial or personal information (Social Security Number, Credit card information for direct deposit, etc.) from you via e-mail. Any requests for information will be discussed prior and will be conducted through a secure website provided by the recruiter. Should you be asked for such information, please notify us immediately.

#LI-DT1

Click To Review Our Benefits (PDF)

Apply

Jobs for you

Recently Viewed Jobs

You do not have any recently viewed jobs

Your Saved Jobs

You do not have any saved jobs

Sign up for Job Alerts

Join our Talent Community

At Aetna, we are pioneering a total approach to health and wellness and we need talented candidates like you to join our team. Become a member of our talent community to be the first to know about career initiatives that match your skills and interests as they become available, in addition to details on upcoming events, networking opportunities, and news about Aetna.

Join Our Talent Community

Sign up to receive information about job openings that are tailored to your skills and interests. Plus, get the latest career news from Aetna.