Applications Database Analyst

Overview

Remote
Depends on Experience
Contract - W2
Contract - 1 year(s)
No Travel Required

Skills

SQL Server
MySQL
Oracle

Job Details

JD:
MUST HAVE:
Business Requirements: Analyze and translate business requirements into efficient database designs that
meet the data needs of the organization and align with the business goals and processes.
Data Modeling: Create conceptual, logical, and physical database models using tools like ERD diagrams
to depict a visual representation of the organization's data and how it relates to the business requirements.
Database Design Patterns: Utilize common database design patterns to solve recurring design problems.
Data Integration: Utilize common data integration techniques to consolidate data from multiple sources
into a cohesive and consistent dataset.
Normalization Techniques: Utilize normalization principles to reduce redundancy and improve data
integrity.
Indexing Strategies: Implement indexing techniques to optimize query performance and data retrieval.
Database Security: Use data security best practices to enforce data privacy and protect sensitive
information.
Scalability and Performance: Design database that can scale horizontally or vertically to handle increasing
workloads.
Collaboration and Communication: Work closely with stakeholders, developers, architects, and other team
members to ensure the database design meets the project requirements.
Knowledge with the following qualifications:
Database Skills: Proficiency in database management systems like MySQL, Oracle, SQL Server,
PostgreSQL, etc. Strong understanding of database concepts, normalization, indexing, and query
optimization.
Data Modeling: Knowledge of data modeling concepts and tools to design database structures, entities,
relationships, and data flow diagrams.
Problem-Solving Skills: Ability to troubleshoot database issues, identify root causes, and implement
effective solutions to optimize database performance and data integrity.
Analytical Skills: Strong analytical and critical thinking skills to analyze data, identify patterns, and make
data-driven recommendations.
SQL Proficiency: Strong command of SQL (Structured Query Language) for querying, manipulating, and
managing data within databases.
Database Administration: Familiarity with database administration tasks such as performance tuning,
backup and recovery, security management, and user access control.
Communication Skills: Effective communication skills to collaborate with team members, stakeholders,
and business users, and to translate technical concepts into non-technical terms.
Working knowledge (2+ years experience) of one of more of the following qualifications:
Knowledge/experience with Agile Methodologies
Knowledge/experience of SDLC practices
DevSecOps, Secure Coding practices, and the Solutions Development Framework (Docker, Jenkins,
GitLab)
Experience with Cloud architecture, design and development
Knowledge of business process re-engineering principles and processes
Change Management and Configuration Management (VersionOne, ServiceNow, etc)
Application Lifecycle Management (ALM)
Required Experience Level:
5+ years experience in designing large and complex IT solutions in large organizations. Position requires
strong leadership and team-building skills. Must be able to collaborate effectively with a group of high
performing individuals as well as Leadership.
Educational Requirements:
A degree from an accredited College/University in Computer Science, Information Technology, Management
Information Systems, or a related field is preferred.
NOTE: If resource does not have a relevant college degree, an additional 4 years of relevant work
experience is required.
Please send your resume's to Resumes(@)itekpeople(.)com
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.