Database Analyst

Job Title: IT - Software Developer IVLocation work will be performed: VAT101 - VA B1 - RemoteApplications Database Analyst (Remote):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 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)Additional Required Skills/Experience:A minimum of eight (8) years relevant experience.A degree from an accredited College/University in the applicable field of services is required. If the individual's degree is not in the applicable field then four additional years of related experience is required.Typically performs all functional duties independently.Note: Special credentials (licenses and/or certifications) may be required at the Task Order level on a case-specific basis."Additional Provisions:Pass both a client mandated clearance process to include drug screening, criminal history check and credit check.Once candidate s resume is approved and interview passed, the agency is responsible for providing drug screening. Failure to submit the drug screening results will delay the security clearance process.If a candidate is given an interim clearance, continuation of employment is then based on the candidate receiving a sensitive clearance.Candidate must have lived in the US for the past 5 years.Cannot have more than 6 months travel outside the United States within the last five years. Military Service excluded. (Exception does not include military family members.) All overtime must be pre-approved in writing by the client manager or his/her designated representative.Agency will not be reimbursed for overtime charges without previous written authorization. Authorized overtime will be reimbursed at straight time.