Aetna DB2 ZOS / IDMS DBA - 45913BR in Hartford, Connecticut
Req ID: 45913BR
The Database Technical Administrator provides technology strategy, direction, management and support to business systems delivery and maintenance. Designs and delivers technical and application architecture; manages standard technical products lifecycle; provides technical consulting and support to business systems delivery; delivers applied technology solutions.
Participates in or provides input to the logical data modeling process in order to ensure that business requirements are translated into a valid database design.
Employs relational modeling database design principles as necessary in translating a logical model to a physical design that supports the business requirements.
Uses logical data models to create and maintain physical database designs which meet identified business needs and provide adequate safeguards for security and integrity.
Working with a data modeler, leads access modeling sessions to complete physical database design requirements. Leads the physical database design process.
Ensures databases provide required functionality to meet identified business needs.
Ensures databases are high quality, cost-effective, maintainable, and contain solutions that can be leveraged.
Participates in data architecture requirements discussions and recommends usage of appropriate database and data management technology (i.e., DBMS, MQ, Data Propagator, DRDB).
DATABASE IMPLEMENTATION AND MAINTENANCE:
Implements databases for testing and production.
Monitors capacity and performance for test and 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 test and production databases are properly backed up and recovered when necessary.
Develops and maintains database backup and recovery procedures.
Ensures test and production databases are properly maintained; databases are reorganized/resized when necessary and other DBA utilities run when appropriate.
DATABASE NEW PRODUCT/VERSION TESTING & EVALUATION:
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.
Provides input to database technology direction setting and decision-making by formulating options, identifying issues, and making recommendations.
Participation in Production on call rotation is required.
Working knowledge of IBM DB2-ZOS, CA IDMS, performance monitors, commands and utilities is required.
Knowledge of IBM WebSphere MQ series, MQ Queue definition administration and operations is desired.
Knowledge of IBM Data Replication products, administration and operations is desired.
The highest level of education desired for candidates in this position is a Bachelor's degree or equivalent experience.
Functional - Information Management/Database Design (Physical)/4-6 Years
Functional - Information Management/Database Backup and Migration/4-6 Years
Functional - Information Management/Data Security Administration/4-6 Years
Functional - Information Management/Query and Database Access Tools/4-6 Years
Functional - Information Technology/Application maintenance & support/4-6 Years
Technical - Database/DB2 ZOS/4-6 Years/Administrator
Technical - Database/IDMS/4-6 Years/Administrator
Technical - Database/IBM DB2 Admin Tool/4-6 Years/Administrator
Technical - Database/IBM Data Propagator / Replication/1-3 Years/Administrator
General Business/Communicating for Impact/ADVANCED
Technology/Creating Technology Partnerships/ADVANCED
Full-Time Telework (WAH) and/or Part-Time Telework (ex: 2 days office-based, 3 days telework)
ADDITIONAL JOB INFORMATION
The successful candidate will work in a team environment with the opportunity to develop their individual skill sets. In addition to the database administration responsibilities, the candidate may have system programming opportunities in the near future.
Aetna is about more than just doing a job. This is our opportunity to re-shape healthcare for America and across the globe. We are developing solutions to improve the quality and affordability of healthcare. What we do will benefit generations to come.
We care about each other, our customers and our communities. We are inspired to make a difference, and we are committed to integrity and excellence.
Together we will empower people to live healthier lives.
Aetna is an equal opportunity & affirmative action employer. All qualified applicants will receive consideration for employment regardless of personal characteristics or status. We take affirmative action to recruit, select and develop women, people of color, veterans and individuals with disabilities.
We are a company built on excellence. We have a culture that values growth, achievement and diversity and a workplace where your voice can be heard.
Benefit eligibility may vary by position. Click here to review the benefits associated with this position.
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.
Job Function: Information Technology