Mainframe Database Administrator Lead (Hybrid) - Military Veterans
at CareFirst BlueCross BlueShield
Resp & Qualifications
PURPOSE:
Assists, defines, and/or oversees database organization, standards, controls, procedures, and documentation. Provides recommendations in the definition, design, and creation of a database environment. Develops applications to help solve database solutions to business problems, data architectures, database management system facilities and capabilities, and the operation and tuning of databases. 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. Maintains database dictionaries and integrates systems through database design. Maintains and documents shell scripts and batch processes. Lead and mentor less experience Administrators.
ESSENTIAL FUNCTIONS:
- Maintains and documents shell scripts and batch processes. Develops and applies procedures for periodic database backup.Executes processes in SQL for databases such as stored procedures/functions/packages, database job, materialized view, view, synonyms, and DB link. Analyzes impact on database before making any changes to database.
- Leads 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.
- Develops applications to help solve database solutions to business problems, data architectures, database management system facilities and capabilities, and the operation and tuning of databases. Provides recommendations in the definition, design, and creation of a database environment.
- Develop and implement techniques to prevent system problems, troubleshoot incidents to recover services, and support root cause analysis.
- 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.
- Lead, train and mentor less experience Administrators.
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 related IT 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: 8 years Experience perform full data management duties, including migration and continuous integration/delivery.
Preferred Qualifications:
- This opening is for a lead application database administrator for our Mainframe DB2. Responsibilities include creation and maintenance of all database objects, running all DB2 utilities, performance tuning of applications and SQL, troubleshooting application and database issues, providing on-call support, and handling of all requests from application/product teams and other infrastructure teams. The Lead DBA is expected to handle any DB2 technology requests and lead the DBA efforts on any application or infrastructure project requiring mainframe DB2 databases. We leverage Qrep tools heavily, so it is highly desirable that any candidate has significant experience in Qrep. Also desirable would be some experience with The Cloning Tool, Optim Archive, and Query Monitor.
Knowledge, Skills and Abilities (KSAs)
- Proficient with SQL performance and tuning.
- High-level of analytical and troubleshooting skills.
- Proficient in Microsoft Office applications.
- Excellent communication skills both written and verbal.
- Ability to train others.
- In-depth knowledge of DB2, MS SQL Server and similar databases.
- Knowledge of structured query language (SQL).
- Must be able to meet established deadlines and handle multiple customer service demands from internal and external customers, within set expectations for service excellence. Must be able to effectively communicate and provide positive customer service to every internal and external customer, including customers who may be demanding or otherwise challenging.
Salary Range: $107,640 - $213,785
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
Database Administration
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
Reston, VA
At CareFirst BlueCross BlueShield, we’re building the future of healthcare with the widest coverage and the largest network for medical, dental and vision insurance in Maryland, Washington, D.C. and Northern Virginia. Every day, we make a meaningful difference in the communities where we both live and work. We solve real problems for the people we serve with equal parts empathy and urgency-simplifying the complex, delivering tailored solutions and stepping forward with new ideas. Join an inspired, collaborative team that's building the healthcare experience we want for our families.
CareFirst BlueCross BlueShield is a regional leader in providing health care insurance coverage and related services throughout Maryland, Washington, D.C. and Northern Virginia. In addition to our offices all around the region, we are also hiring subsidiary companies located in Baltimore, MD, Alexandria, VA and Charleston, WV.
CareFirst offers a wide range of diverse opportunities, whether you're a recent college graduate looking for an entry-level position or a seasoned professional in your field. No matter your experience or background, we are looking for new hires to share and develop their skills. Use our job search tool to research current job openings and apply for positions in which you are interested by registering and submitting your resume.