JOB SUMMARY:
- 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 highly 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 resources do not have a relevant college degree, an additional 4 years of relevant work experience is required.
Linked-in
Google