Job Title: Applications Database Analyst

Location: 100% Remote

Salary/Payrate: $30/HR to $103/HR 1099 OR $60K - $155K W2

Work Environment: 100% Remote

Term: Contract to Hire (Potential to convert after 6 months)

Bachelor’s degree required: No, preferred

Referral Fee: AMS will pay $500 should the person you refer gets hired

JOB DESCRIPTION

#LI-MG1

Our federal client is looking to hire a 100% remote Applications Database Analyst. Please send your resume in WORD format should you be interested in exploring this role. The position is on a contract to hire basis and will pay an hourly rate of $30/HR to $103/HR 1099, dependent on experience. We also offer the option of a W2 annual salary of $60K to $155K, with full benefits and PTO.

***Due to the required clearance with our government client, only US Citizens, Green Card and Green Card EAD holders may be considered. Clearance requires that the candidates have resided in the US for the past five years. The selected candidate cannot have left the country for longer than 90 consecutive days and no more than 180 cumulative days***

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.