Annapolis Micro Systems is seeking an organized, detail-oriented, and analytical professional to join our team as a Database Systems Analyst. The Database Systems Analyst will oversee the development, modification, and improvement of the company databases and applications. They will collaborate with end-users across all internal departments to facilitate execution of user acceptance testing and aid in identifying database and application functionality needs. They will communicate with the Database Architect to explain identified database and application functionality needs, and they will be able to create efficient packets for the Database Architect to address all at once.
Responsibilities
- Oversee the development, modification, and improvement of company databases and applications
- Assess database design and optimize according to the company's objectives
- Gather and interpret data from the database
- Evaluate existing databases using testing methods and tools
- Prepare reports and make database systems recommendations based on those findings
- Evaluate and improve application usability
- Support the President with the development of estimates for development efforts and prioritization of development activities
- Communicate with internal end-users to understand and forecast the database functionality needs of their department
- Facilitate execution of user acceptance testing
- Collaborate with Database Architect to identify and expedite database functionality solutions
- Create SQL queries as needed
Requirements
- Bachelor's degree in computer science, data science, information systems or other relevant fields
- Proficiency with a database system
- US citizenship
- Has received, or is willing to receive, a government mandated vaccine
Desired Technical Background
- 1+ years of experience as a tester in hands-on application testing and developing and executing test scripts
- 1+ years of experience working with entity relationship diagrams, database schemas, test data, and source to target data verification
- 1+ years of experience with system testing methodologies
- 1+ years of experience with productivity tools, including Microsoft Office, such as Excel and using configuration management and defect tracking tools, such as Atlassian JIRA
- Knowledge of system or software development life cycle (SDLC)
- Ability to assess and comprehend system and functional requirements
- Ability to create and update test cases and perform requirement traceability to ensure all requirements are tested and accounted for
- Experience supporting and reporting data management and data quality applications
- Ability to support automated testing and usability testing
- Ability to support QA reviews, peer reviews, and reviews of SDLC products and artifacts
- Experience with Atlassian Jira for configuration management and defect tracking
- Knowledge of the system or software development life cycle (SDLC)
- Knowledge of manual and automated testing, 508 compliance, performance, UAT, Unit, regression, and integration testing
- Experience as a tester and analyst in hands-on applications testing and developing and executing test scripts
- Experience in mapping business and technical requirements into test cases and generating test scripts
- Experience in creating and updating test cases and performing requirement traceability to ensure all requirements are tested and accounted for
- Experience in accurately modeling requirements, using at least one if not more of the following: Functional Decomposition, Data Flow Diagrams, User Context Diagrams, Activity Diagrams, Workflow modeling, Use Cases, Process Modeling, Prototyping
- Ability to analyze complex systems, identify issues, and propose effective solutions