The database designer and DBA's is responsible for defining the detailed database design, including tables, indexes, views, constraints, triggers, stored procedures, and other database-specific constructs needed to store, retrieve, and delete persistent objects, and SQL applications, writing and testing code following procedures, collaborating with clients and analyst teams and security.
- Object-Oriented Analysis and Design techniques.
- System Architecture, including Database and System performance tuning, as well as hardware and network work load balancing.
- Database Administration an understanding of the implementation language and environment.
- Design stable, reliable and effective databases.
- Optimize and maintain legacy systems.
- Modify databases according to requests and perform tests.
- Solve database usage issues and malfunctions.
- Liaise with developers to improve applications and establish best practices.
- Gather user requirements and identify new features.
- Develop technical and training manuals.
- Provide data management support to users.
- Ensure all database programs meet company and performance requirements.
- Research and suggest new database products, services and protocols.
- Microsoft (MS) Access 2007 or higher developer experience.
- Experienced in MS Excel and spreadsheet development and analysis.
- Relational database design (unique identifiers, relational table creation).
- Understand and use data types.
- VBA knowledge and application.
- Advanced Form creation for adds, edits, deletions.
- Advanced reporting knowledge.
- Ability to create complicated IF statements and calculated fields.
- Knowledge of using multiple functions within fields such as datepart, min, max, avg,
- Ability to create macros.
- Knowledge of importing and linking various sources of data such as Excel and Access.
- SQL knowledge to create Select, Update, Delete, Union, Append queries. Outer joins, Equal joins.
- Ability to create emails and attach reports to them.
- Ability to create ERD diagrams & Work Flow diagrams.
- Experience writing procedures.
- Experience manipulating data within Excel or other files to the correct format for Access to read. Such as comma delimited files.
- User Support: Reviews queries for performance issues, making changes as needed. Participates in the design and development of the system, as well as creation of user documentation.
- Problem Solving: Assist staff with troubleshooting non-routine report related issues. Escalate highly complex report issues to the appropriate staff member.
- Internal Procedures: Develop and document internal procedures.
- Report Quality & Testing: Tests reports and reporting functionality in coordination with end users to assure data quality.
- Business Relationship: Works with the customer/stakeholder to evaluate, plan, and develop/re-engineer current or new reports. Participates in the interdisciplinary discussion and brainstorming events to develop new functionality/workflows.
- Workflow Management: Monitors the status of report requests daily, prioritizing as needed.