Applications Database Analyst

Applications Database AnalystPlanIT Group is seeking an Applications Database Analyst for our Federal customer in the Washington, DC area. The ideal candidate has 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).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 MethodologiesKnowledge/experience of SDLC practicesDevSecOps, Secure Coding practices, and the Solutions Development Framework (Docker, Jenkins, GitLab)Experience with Cloud architecture, design, and developmentKnowledge of business process re-engineering principles and processesChange 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.Additional Provisions:Must be able to obtain a Position of Public Trust ClearancePass both a client mandated clearance process to include drug screening, criminal history check and credit check.All candidates must be a US Citizen or US Permanent Resident only.Candidate must have lived in the United States 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.)