Application Database Analyst

List of tasks to be performed:
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.