Address
Form of work
SalaryResp & Qualifications
PURPOSE:
Designs, implements, and maintains databases with respect to access methods, access time, batch processes, device allocation, validation checks, organization, protection and security, documentation, and statistical methods. Perform activities related to the day-to-day administration and maintenance of transactional databases, ensuring that the database is available, performing properly, and safe. Perform complex installations, upgrades and patching, backup and recovery, performance tuning, security, monitoring, and configuration. Confer with appropriate managers regarding problems with and capabilities of databases.
ESSENTIAL FUNCTIONS:
- Develop and implement techniques to prevent system problems, troubleshoot incidents to recover services and support root cause analysis.
Provides project management support regarding most technical aspects of implementing project release upgrades for assigned systems which includes: properly following a project life cycle, the development of project plans, completing all appropriate documentation and notifications in order to obtain resolution within the established timeframes.
Supports the development teams application development. Administers database environments that support development.
Maintains data in database environment, including production.
Assists in defining back-up and recovery requirements.
Transforms and loads data into database. Carries out version control process. Analyzes legacy system data.
SUPERVISORY RESPONSIBILITY:
Position does not have direct reports but is expected to assist in guiding and mentoring less experienced staff. May lead a team of matrixed resources.
QUALIFICATIONS:
Education Level: Bachelor's Degree in Computer Science or IT related field OR in lieu of a Bachelor's degree, an additional 4 years of relevant work experience is required in addition to the required work experience.
Experience: 5 years Experience perform full data management duties, including migration and continuous integration/delivery.
Preferred Qualifications:
- 8 Years Experience.
- Provide day-to-day database support for mission critical applications on DB2 DPF (Database Partitioning Feature) and DB2 HADR (High Availability Disaster Recovery) databases.
- Rotating 24x7 on-call support responsibility.
- Manage and monitor DB2 HA (High Availability) infrastructure and TSA (Tivoli System Automation) to ensure 24 x7 system availability.
- Design and implement DB2 management functions such as system backup, database reorganization, Runstats, etc. for HA environment and to maximize system availability and use.
- Conduct performance tuning and optimization work on multiple DB2 databases tuning SQL and database structures for optimal performance and system throughput.
- Analyze performance issues and troubleshoot hardware, storage, network and workload for optimization.
- Install, configure, and manage the full DB2 software stack on AIX environment for HA and maximum performance.
- Partner with project teams and interact with customers to identify technical solutions for projects and operational issues.
- Provide support for data replication between production site and disaster recovery site.
- Ensure stability of both infrastructure and software stack
- Provide support for performance testing system optimization.
- Work with product vendors (e.g., IBM and EMC) for troubleshooting and collecting traces for enhanced vendor support.
- Other duties as assigned.
Projected Level of Effort:
- 40 hr./wk.
- Telecommuting permitted.
- (1) Consultant.
Preferred Technical Skills:
- Bachelors degree including 5 years of hands-on DB2 UDB experience in an AIX environment.
- Experience installing DB2 and applying DB2 Fixpack upgrades on AIX High Availability (HA) systems (both DPF and non-DPF).
- Configure, tune, and maintain HA using Tivoli System Automation (TSA)/High Availability Disaster Recovery (HADR) for database failover and failback support.
- Experience in DB2 SQL performance tuning using tools such as db2advis, db2expln, db2batch, db2exfmt and DSM.
- Configure DB2 Workload Manager (WLM) for load balancing and tuning different workloads (on-line transaction, ad-hoc query, and batch).
- Install and set up Q-Replication between databases, MQSeries and handle subscription changes.
- Configure DB2 backup clients with Tivoli Service Manager (TSM) and NetBoost Boost (InfiniGuard) for point-in-time backup recovery.
- Experience with flashcopy/snapshot functionality for database cloning and backup.
- Working knowledge of Federation, Multi-Dimensional Clustering (MDC) and Materialized Query Tables (MQT).
- Experience with IBM DB2 troubleshooting tools including, but not limited to, db2pd, db2diag, db2inspect, db2dart, db2top, and Data Server Manager (DSM).
- Experience with DB2 data movement and copy utilities such as load/import/export/High Performance Unload (HPU).
- Ability to write and troubleshoot DB2 shell/korn/perl scripts for automation.
- Working knowledge of scheduling tools such as Control-M and Crontab.
- Experience with database archiving tools such as Optim Data Growth (ODG) preferred.
- Understanding of DB2 BLU and knowledge of when BLU data structures are appropriate for implementation.
- Prior experience supporting Ab Initio, Cognos, HTTP server and Websphere applications.
- Ability to review and troubleshoot SQL scripts to identify and address performance issues.
Software:
DB2 11.1/11.5 LUW Advanced Server Edition, DB2 Extended Enterprise Edition/Database Partitioning Feature (DPF).
AIX 6.1/7.1, Linux, TSM, TSA, Q-Replication, InfiniGuard NetBoost, DSM, shell/Perl Scripting, Websphere application Cognos, Sharepoint, Microsoft Office.
Best Fit / Team Dynamics:
Sense of urgency given role of database support.
Open to feedback.
Independent contributor; will partner with developer.
Self starter and high initiative.
Interpersonal flexibility.
Works effectively in high state of change and ambiguity.
Knowledge, Skills and Abilities (KSAs)
- Knowledge of Oracle, DB2, MS SQL Server and similar databases.
- Ability to communicate effectively with analysts, developers, tests, and project managers in both oral and written form.
- Ability to work minimal supervision.
- High-level of analytical and troubleshooting skills.
- Proficient in Microsoft Office applications.
- Knowledge of Structured Query Language (SL).
Salary Range: $93,096 - $184,899
Salary Range Disclaimer
The disclosed range estimate has not been adjusted for the applicable geographic differential associated with the location at which the work is being performed. This compensation range is specific and considers factors such as (but not limited to) the scope and responsibilites of the position, the candidate's work experience, education/training, internal peer equity, and market and business consideration. It is not typical for an individual to be hired at the top of the range, as compensation decisions depend on each case's facts and circumstances, including but not limited to experience, internal equity, and location. In addition to your compensation, CareFirst offers a comprehensive benefits package, various incentive programs/plans, and 401k contribution programs/plans (all benefits/incentives are subject to eligibility requirements).
Department
IT Service Management
Equal Employment Opportunity
CareFirst BlueCross BlueShield is an Equal Opportunity (EEO) employer. It is the policy of the Company to provide equal employment opportunities to all qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veteran or disabled status, or genetic information.
Where To Apply
Please visit our website to apply: www.carefirst.com/careers
Federal Disc/Physical Demand
Note: The incumbent is required to immediately disclose any debarment, exclusion, or other event that makes him/her ineligible to perform work directly or indirectly on Federal health care programs.
PHYSICAL DEMANDS:
The associate is primarily seated while performing the duties of the position. Occasional walking or standing is required. The hands are regularly used to write, type, key and handle or feel small controls and objects. The associate must frequently talk and hear. Weights up to 25 pounds are occasionally lifted.
Sponsorship in US
Must be eligible to work in the U.S. without Sponsorship
#LI-KT1
