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.)