Language

Analyst, Database II - Request #36200670

Data Acquisition
Solarwinds
Frameworks
Optimization
Provisioning
NIST
Backups
Confluence
Agile
JIRA
Unstructured Data
Datasets
Data Management
Data Architecture
AWS Cloudwatch
Google Cloud
Terraform
AWS Cloudformation
Amazon Relational Data Service
Amazon Web Services
SQL Queries
Oracle
Database Modeling
Database
Database Administration
Data Migration
SQL
Description:

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. Business and political climates may change, but we’re stronger than ever. Our A.M. Best rating is A+ (Superior) — making us the only health insurance company in South Carolina with that rating. We’re 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!

Job Title: Analyst, Database II

Position Notes:

  • Required Education: Bachelor's degree in Computer Science, Information Technology or other job related degree. or 4 years of job related work experience or 2 years of job related experience plus an associate’s degree in Computer Science, Information Technology or other job related degree. 
  • Required Work Experience: 8 years of IT experience including varied database administration experience.
  • Interview: Remote
  • Role: Onsite is Highly Preferred but open to Remote (Cloud Database Analyst II)
  • Team Name: CBIC Cloud Migration 
  • Hours: 8:30 a.m. to 5 p.m. - Possible overtime, when needed to meet project timelines
  • Required Technologies: • Cloud Data Migration Experience. • Agile Experience. Familiarity with Jira and Confluence. • SQL & Database Query Optimization, Strong proficiency in writing complex SQL queries, analyzing execution plans, and optimizing performance across large datasets. Infrastructure as Code (IaC) Tools – Terraform, ARM Templates, or CloudFormation, required for automating infrastructure provisioning and ensuring consistency across environments. Security & Compliance Frameworks (NIST 800-53, FedRAMP) • Database Monitoring & Management Tools, Familiarity with tools like CloudWatch (AWS), Azure Monitor, or third-party solutions (e.g., SolarWinds, Redgate) for monitoring database health, performance, and availability. • Cloud Database Platforms (AWS RDS, Azure SQL, or Google Cloud SQL), Hands-on experience managing and optimizing cloud-hosted relational databases, including provisioning, configuration, and performance tuning.
  • Nice To Have: Experience working with relational (Oracle Ama) and non- relational databases in the cloud and on-premises for handling semi-structured or unstructured data in cloud-native applications. Cloud Certifications. 

Duties:

  • 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. •20% 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. 
  • 20% 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. 
  • 15% 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. 
  • 15% 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. 
  • 15% 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. 
  • 15% 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.

Cloud Engineer

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. 

Required Software and Tools: Standard office equipment. 

Required Education: Bachelor's degree in Computer Science, Information Technology or other job related degree. or 4 years of job related work experience or 2 years of job related experience plus an associate’s degree in Computer Science, Information Technology or other job related degree. 

Required Work Experience: 8 years of IT experience including varied database administration experience.

This is the pay range that Magnit reasonably expects to pay someone for this position is $50 - $62/hour. Benefits: Medical, Dental, Vision, 401K (provided minimum eligibility hours are met).

BlueCross is a strong supporter of our veterans, and many service men and women have joined our ranks. We’ve found the dedication, work ethic and job skills that serve well in the military excel in many of our lines of business, and we proudly have veterans filling positions in Human Resources, Information Technology, Customer Service, Operations, General Services and more. 

Through our government contracts, we also have employees serving at Shaw Air Force Base, the Naval Health Clinic in Charleston, the Naval Hospital in Beaufort and in our hometown of Columbia, S.C., at Ft. Jackson. If you are a full-time employee in the National Guard or Reserves, we will even cover the difference in your pay if you are called to active duty. If you're ready to join in a diverse company with secure, community roots and an innovative future, apply for a position now!

QUALIFICATION/ LICENSURE :
  • Work Authorization : US Citizen
  • Preferred years of experience : 1+ Years
  • Travel Required : No travel required
  • Shift timings: Not specified
Job Location columbia, South Carolina
Pay USD 50.00 - USD 62.00 Per Hour
Contract Duration 6 month(s)