Skip to main content

Information Technology

Aetna IT is committed to keeping our members at the heart of everything we do. Our top-talent workforce delivers leading-edge technology, drives innovation, turns vision into action and challenges the art of the possible. We provide best-in-class services to our members by delivering groundbreaking healthcare tools, enabling consumer-friendly interactions and protecting data security. Your mission will be to deliver innovating technology solutions including: Hybrid cloud infrastructure, artificial intelligence/machine learning capabilities and infrastructure as code.

Aetna, a CVS Health Company, is a company with a world-class IT team and we will be counting on you to carry on our success as the preferred provider of infrastructure services for our business partners.

Back to Job Navigation (Overview)

Success Profile

What makes a successful Information Technologist?
Here are the traits we are looking for:

  • Adaptable
  • Collaborative
  • Communicator
  • Digitally Savvy
  • Good Listener
  • Problem-solver
  • Results Driven
  • Team Player
  • Technologically savvy
  • Versatile
  • Relationship expertise
  • Diplomatic
  • Trustworthy
  • Business Savvy

Back to Job Navigation (Success)

Benefits

  • Medical

  • Dental

  • Vision

  • Healthcare
    FSA

  • Dependent
    Care FSA

  • Health and
    Wellness
    Programs

Back to Job Navigation (Rewards)

Job Details

Senior Database Administrator - 69272BR

Primary Location: Chicago, Illinois
Additional Locations: IL-Chicago
Apply
Description:
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.
· Support and accelerate the path towards DevOps by smartly leveraging cloud capabilities with cloud technologies and within traditional processing environments.
- Participate in the design, implementation and support of SQL databases and distributed systems in cloud environments

· Participate in after-hours, on-call support rotation.


Background Experience:
10+ years of experience developing, maintaining and administering Microsoft SQL Server databases.
· 3+ years experience in deploying/migrating and managing cloud-hosted database solutions (such us SQL Azure, AWS, etc.)

Additional Job Information:
Ability to work effectively with business areas, IT support teams, IT management, and peers.Excellent verbal and written communication skills.

Potential Telework Position:
No

Percent of Travel Required:
N/A

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

Benefit Eligibility:
Benefit eligibility may vary by 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.

Apply

Influential Content

Back to Job Navigation (Trending)

Sign up for Job Alerts

Explore This Area

Check out where you could be working if you apply.

View Map

Similar Jobs

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, a CVS Health Company.