Overview
On Site
$78 - $82 hourly
Contract - W2
Contract - Temp
Skills
Blueprint
Data Storage
Storage
Strategic Planning
Data Management
Data Warehouse
Big Data
Database Security
Access Control
Backup Administration
Recovery
Performance Tuning
Star Schema
Data Modeling
ERwin
Business Process
Insurance
Industry-specific
Data Structure
Data Integrity
Modeling
FOCUS
Amazon Web Services
Remote Desktop Services
Amazon RDS
RDBMS
Cloud Computing
SQL Tuning
Database Administration
Scripting
Python
Bash
Analytical Skill
Conflict Resolution
Problem Solving
Management
Database
PL/SQL
MySQL
Data Architecture
Artificial Intelligence
Messaging
Job Details
RESPONSIBILITIES:
Kforce has a client in San Antonio, TX that is seeking a Data Architect/DBA. A Data Architect focuses on designing the overall structure and blueprint for an organization's data storage and access, while a Database Administrator (DBA) is responsible for the practical implementation, maintenance, and security of those databases. Essentially, the Data Architect designs the "what" and "why" of the data, while the DBA ensures the "how" and "that it works."
Key Differences and Responsibilities:
Data Architect:
* Designs the overall data architecture for an organization, including data models, storage strategies, and access methods
* Focuses on long-term data needs and strategic planning for data infrastructure
* Researches and recommends new technologies to improve data management
* May be involved in data modeling, data warehousing, and big data solutions
* Works with stakeholders to understand data requirements and ensure alignment with business goals
Database Administrator (DBA):
* Implements and maintains databases based on the designs provided by the Data Architect
* Handles database security, user permissions, and access control
* Manages database backups, recovery, and performance tuning
* Troubleshoots database issues and ensures smooth operation
* May work with different database systems and technologies
REQUIREMENTS:
* Strong experience in Star-schema, 3NF, Data Vault data modeling to design optimized, scalable database structures
* Proficient in using data modeling tools like Erwin for creating and maintaining logical and physical data models
* Ability to understand complex business processes and translate them into accurate and efficient data models that meet organizational needs
* Experience in the insurance industry is a plus, providing valuable insight into industry-specific data structures and requirements
* Proficiency in working with large tables and complex joins, ensuring data integrity and optimal query performance
* Skilled in modeling tables and database structures with a focus on delivering the best query performance and minimizing response times
* Extensive experience with AWS RDS (Relational Database Service), including managing and optimizing relational database systems in the cloud environment
* Strong experience in SQL tuning, with a proven ability to analyze and improve query performance to meet business needs
* Proficient in automating routine database administration tasks using scripting languages like Python or Bash, improving efficiency and reducing manual work
* Strong analytical and problem-solving skills, with the ability to troubleshoot complex database issues and implement effective solutions
* Experience managing databases across multiple platforms (e.g., Oracle, SQL Server, MySQL) and integrating them into a unified data architecture
The pay range is the lowest to highest compensation we reasonably in good faith believe we would pay at posting for this role. We may ultimately pay more or less than this range. Employee pay is based on factors like relevant education, qualifications, certifications, experience, skills, seniority, location, performance, union contract and business needs. This range may be modified in the future.
We offer comprehensive benefits including medical/dental/vision insurance, HSA, FSA, 401(k), and life, disability & ADD insurance to eligible employees. Salaried personnel receive paid time off. Hourly employees are not eligible for paid time off unless required by law. Hourly employees on a Service Contract Act project are eligible for paid sick leave.
Note: Pay is not considered compensation until it is earned, vested and determinable. The amount and availability of any compensation remains in Kforce's sole discretion unless and until paid and may be modified in its discretion consistent with the law.
This job is not eligible for bonuses, incentives or commissions.
Kforce is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.
By clicking ?Apply Today? you agree to receive calls, AI-generated calls, text messages or emails from Kforce and its affiliates, and service providers. Note that if you choose to communicate with Kforce via text messaging the frequency may vary, and message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You will always have the right to cease communicating via text by using key words such as STOP.
Kforce has a client in San Antonio, TX that is seeking a Data Architect/DBA. A Data Architect focuses on designing the overall structure and blueprint for an organization's data storage and access, while a Database Administrator (DBA) is responsible for the practical implementation, maintenance, and security of those databases. Essentially, the Data Architect designs the "what" and "why" of the data, while the DBA ensures the "how" and "that it works."
Key Differences and Responsibilities:
Data Architect:
* Designs the overall data architecture for an organization, including data models, storage strategies, and access methods
* Focuses on long-term data needs and strategic planning for data infrastructure
* Researches and recommends new technologies to improve data management
* May be involved in data modeling, data warehousing, and big data solutions
* Works with stakeholders to understand data requirements and ensure alignment with business goals
Database Administrator (DBA):
* Implements and maintains databases based on the designs provided by the Data Architect
* Handles database security, user permissions, and access control
* Manages database backups, recovery, and performance tuning
* Troubleshoots database issues and ensures smooth operation
* May work with different database systems and technologies
REQUIREMENTS:
* Strong experience in Star-schema, 3NF, Data Vault data modeling to design optimized, scalable database structures
* Proficient in using data modeling tools like Erwin for creating and maintaining logical and physical data models
* Ability to understand complex business processes and translate them into accurate and efficient data models that meet organizational needs
* Experience in the insurance industry is a plus, providing valuable insight into industry-specific data structures and requirements
* Proficiency in working with large tables and complex joins, ensuring data integrity and optimal query performance
* Skilled in modeling tables and database structures with a focus on delivering the best query performance and minimizing response times
* Extensive experience with AWS RDS (Relational Database Service), including managing and optimizing relational database systems in the cloud environment
* Strong experience in SQL tuning, with a proven ability to analyze and improve query performance to meet business needs
* Proficient in automating routine database administration tasks using scripting languages like Python or Bash, improving efficiency and reducing manual work
* Strong analytical and problem-solving skills, with the ability to troubleshoot complex database issues and implement effective solutions
* Experience managing databases across multiple platforms (e.g., Oracle, SQL Server, MySQL) and integrating them into a unified data architecture
The pay range is the lowest to highest compensation we reasonably in good faith believe we would pay at posting for this role. We may ultimately pay more or less than this range. Employee pay is based on factors like relevant education, qualifications, certifications, experience, skills, seniority, location, performance, union contract and business needs. This range may be modified in the future.
We offer comprehensive benefits including medical/dental/vision insurance, HSA, FSA, 401(k), and life, disability & ADD insurance to eligible employees. Salaried personnel receive paid time off. Hourly employees are not eligible for paid time off unless required by law. Hourly employees on a Service Contract Act project are eligible for paid sick leave.
Note: Pay is not considered compensation until it is earned, vested and determinable. The amount and availability of any compensation remains in Kforce's sole discretion unless and until paid and may be modified in its discretion consistent with the law.
This job is not eligible for bonuses, incentives or commissions.
Kforce is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.
By clicking ?Apply Today? you agree to receive calls, AI-generated calls, text messages or emails from Kforce and its affiliates, and service providers. Note that if you choose to communicate with Kforce via text messaging the frequency may vary, and message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You will always have the right to cease communicating via text by using key words such as STOP.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.