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.