Database Analyst II

Posted:
10/7/2024, 1:47:31 AM

Location(s):
South Carolina, United States ⋅ Columbia, South Carolina, United States

Experience Level(s):
Junior ⋅ Mid Level ⋅ Senior

Field(s):
Data & Analytics ⋅ Software Engineering


Summary
 

Why should you join the BlueCross BlueShield of South Carolina family of companies? Other companies come and go, but for more than seven decades we’ve been part of the national landscape, with our roots firmly embedded in the South Carolina community. We are the largest insurance company in South Carolina … and much more. We are one of the nation’s leading administrators of government contracts. We operate one of the most sophisticated data processing centers in the Southeast. We also have a diverse family of subsidiary companies that allows us to build on a variety of business strengths. We deliver outstanding service to our customers. If you are dedicated to the same philosophy, consider joining our team!


Enterprise Database Services – works with all areas of I/S, including all I/S Project Management Offices, application development areas, and other areas of I/S Operations, on the creation and maintenance of all data bases, both operational and informational, under the DB2 and IMS data base management systems on the z/OS mainframe platform. As part of infrastructure, Data Base Administration also works with other Technical Support areas on the selection, installation, testing and maintenance of vendor software used to support IMS and DB2 databases.

The database structures created and maintained by Enterprise Database Services contain data for application systems used by most of the areas of the company. Data Base Administration is one of the key resources in the development and maintenance of these applications and has responsibilities in all phases of the system development methodology used by I/S.


Description
 

This position will participate in an on-call rotation and occasional after hours and weekend work.
Work environment: Problem determination and assistance 24/7.

Position Purpose:

Analyze and develop complex logical and physical database designs, data models and relational data definitions in support of corporate and client information systems requirements. Ensure that department standards for data are adhered to in constructing data management programs and tools.  Perform regular monitoring, maintenance, and housekeeping for performance, capacity, and troubleshooting of assigned databases. Mentor less experienced personnel.

What You'll Do:

  • Define data architecture standards for the organization, structure, attributes, and nomenclature of data elements. Design, develop, test, and implement new database objects (tables, views, indexes, databases, etc) and administer existing architectures supported for performance and maintenance related issues.

  • Analyze and recommend best practice steps to prevent potential database issues, such as performance degradation or potential loss of service as well as recommend actions to fix issues when database problems do occur (outages or potential errors). Recommend methods to recover or improve databases to include analysis/review of vendor products.

  • Provide input into complex decisions as they relate to data architecture, infrastructure and/or administration. Consult with information systems areas on database issues and proposed changes. Recommend tuning to databases and queries when they are not performing to customer requirements.

  • Analyze and recommend upgrades to database software and components based on security requirements, new technology, or evolving application system requirements. Analyze and recommend capacity planning (SAN storage) based on captured growth trends and monitoring.

  • Review database environments to ensure they meet security controls and audit requirements; continually mitigate identified risks and vulnerabilities. Ensure recoverability of databases by creating, scheduling and monitoring database backups for dependent systems.

  • Support management on enterprise wide and departmental goals and objectives. Provide education and information on security policies, practices, and awareness programs. May provide estimation on work efforts and recommendations on training plans for less experience staff.

To Qualify for This Position, You'll Need:

Position requires ADP Tier 1 Clearance. Must be US Citizen to obtain.

Required Education:

•Bachelor's in a job-related field OR,

•4 years job related work experience OR,

•Associate's and 2 years job related work experience


Required Work Experience:

•8 years of IT experience including varied database administration experience.


Required Skills and Abilities:

•Knowledgeable in most aspects of constructing data marts, data architectures and operational data stores.

•Good business analysis, data acquisition, and access analysis and design skills.

•Able to provide input into complex decisions as they relate to data architecture. •Able to relate knowledge of security issues for data management to less experienced personnel.
 

We Prefer That You Have:

  • Experience with the administration of IBM DB2 for z/OS.

  • Experience with the administration of IBM IMS database management system, including management of large partitioned (HALDB) databases, COBOL programming language.

What We Can Do for You:

We understand the value of a diverse and inclusive workplace and strive to be an employer where employees across all spectrums have access and opportunity to develop their skills, advance their careers and contribute their unique abilities to the growth of our company.

Our comprehensive benefits package includes:

  • Subsidized health plans, dental and vision coverage

  • 401K retirement savings plan with company match

  • Life Insurance

  • Paid Time Off (PTO)

  • Nine paid holidays

  • On-site cafeterias and fitness centers in major locations

  • Wellness program and healthy lifestyle premium discount

  • Tuition assistance

  • Service recognition

  • Employee Assistance

  • Discounts to movies, theaters, zoos, theme parks and more

What to Expect Next:

After submitting your application, our recruiting team members will review your resume to ensure you meet the qualifications. This may include a brief telephone interview or email communication with our recruiter to verify resume specifics and salary requirements. Management will be conducting interviews with those candidates who qualify with prioritization given to those candidates who demonstrate the preferred qualifications.



 

We participate in E-Verify and comply with the Pay Transparency Nondiscrimination Provision. We are an Equal Opportunity Employer.

Some states have required notifications. Here's more information

Equal Employment Opportunity Statement

BlueCross BlueShield of South Carolina and our subsidiary companies maintain a continuing policy of nondiscrimination in employment to promote employment opportunities for persons regardless of age, race, color, national origin, sex, religion, veteran status, disability, weight, sexual orientation, gender identity, genetic information or any other legally protected status. Additionally, as a federal contractor, the company maintains Affirmative Action programs to promote employment opportunities for minorities, females, disabled individuals and veterans. It is our policy to provide equal opportunities in all phases of the employment process and to comply with applicable federal, state and local laws and regulations.

We are committed to working with and providing reasonable accommodations to individuals with physical and mental disabilities.

If you need special assistance or an accommodation while seeking employment, please e-mail [email protected] or call 1-800-288-2227, ext. 47480 with the nature of your request. We will make a determination regarding your request for reasonable accommodation on a case-by-case basis.

Total Dental Administrators Inc

Website: https://tdadental.com/

Headquarter Location: Phoenix, Arizona, United States

Employee Count: 101-250

Year Founded: 1995

IPO Status: Private

Industries: Dental ⋅ Health Care ⋅ Health Insurance ⋅ Insurance ⋅ Life Insurance