Database Designer Job Description
Database designer
provides relational Database Management System (RDBMS) - (Oracle/SQL Server) - support to applications supported by assigned department.
Database Designer Duties & Responsibilities
To write an effective database designer job description, begin by listing detailed duties, responsibilities and expectations. We have included database designer job description templates that you can modify and use.
Sample responsibilities for this position include:
Perform/enhance backup and recovery strategies within Oracle and SQL Server
Perform independent database performance analysis on assigned modules with a focus on SQL query efficiency and schema design
Under the supervision of an experienced Database Designer, perform database performance analysis with a focus on SQL query efficiency and schema design
Support multi-sites and heterogeneous environments with different web browsers (Chrome, IE, Firefox), different operating systems (Windows, Linux, Android), different security levels
Define volumetrics
Design and build system architecture and enable automatic deployment of systems from network level up to application within minutes with focus on database schema design and best practices
Have a hunger to get involved in every part of our system
Work with a team of informaticists, oncologists in the lymphoma service, and software engineers to map data and build and maintain our lymphoma database
Identify clinical data elements within the clinical databases and the electronic medical record
Curate, validate, and manage clinical data in the database
Database Designer Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for Database Designer
List any licenses or certifications required by the position: DB, EDC, PMI, TOGAF, ITIL
Education for Database Designer
Typically a job would require a certain level of education.
Employers hiring for the database designer job most commonly would prefer for their future employee to have a relevant degree such as Bachelor's and Associate Degree in Computer Science, Computer Information Systems, Education, Communication, Design, Management, Science, Computer, Human-Computer Interaction, Technical
Skills for Database Designer
Desired skills for database designer include:
21 CFR Part 11 Compliance
Relational databases and interactive computer programs
SQL
CDM processes
Oracle
PL/SQL and the Oracle RDBMS
Windows applications
Access
EDC application
JavaScript
Desired experience for database designer includes:
Effective Database development including design, stored procedures, triggers, UDF
A good degree from a leading university in an engineering or computer science related discipline
Significant experience with Database and Web solutions architecture and design, IT infrastructures, Linux and Windows environments and system administration
Knowledge of Business Intelligence tools, Data Integration and DB Reporting (Pentaho, SAP BODS, Tableau, or equivalent)
Familiarity with scripting languages, especially shell scripts and Python
Capacity to lead ambitious projects involving multiple teams on multiple sites
Database Designer Examples
1
Database Designer Job Description
Job Description Example
Our company is growing rapidly and is looking for a database designer. We appreciate you taking the time to review the list of qualifications and to apply for the position. If you don’t fill all of the qualifications, you may still be considered depending on your level of experience.
Responsibilities for database designer
- Assist in developing standard operating procedures for data entry and clinically-relevant quality tests
- Standardize clinical data to common vocabularies and classifications to facilitate collaboration across cancer care institutions
- Be a clinical data expert on our team and support the retrospective and prospective research efforts of oncologists and researchers in the lymphoma service
- Develop detailed and thorough knowledge of OnBase database schema, database operations and database communication layers
- Create white papers from research to support database initiatives
- Review database schema changes and generated queries as needed
- Work with less experienced Database Designers to enforce database standards
- Develop a detailed understanding of the OnBase database schema and database operations for assigned modules
- Collaborate with other development teams to review database queries
- Manage and solve technical changes, issues and concerns of low and medium complexity work with little to no guidance, but requires some guidance for complex work
Qualifications for database designer
- Some experience of the wireless industry and technologies (GSM/UMTS/LTE) is a plus
- Pitch design solutions to stakeholders, explaining and rationalizing design decisions to non-design audiences
- Work with developers to iterate on designs during implementation
- Prioritize and work in an agile, iterative way
- Have experience in any of the following and proven track record of development, systems integration, and configuration of systems that include either DB2, TSA, WAS, ISAM, Cognos, DataPower
- Previous experience of system multitenancy & working knowledge of database (DB2) design and best practices is highly desirable
2
Database Designer Job Description
Job Description Example
Our company is growing rapidly and is hiring for a database designer. Please review the list of responsibilities and qualifications. While this is our ideal list, we will consider candidates that do not necessarily have all of the qualifications, but have sufficient experience and talent.
Responsibilities for database designer
- Participate in team tasks related to executing operational activities
- Ensure the consistent use of SOPs
- Act as a contributing core team member by participating in process improvement initiatives and liaising with study set up team members
- Maintain existing mySQL and Filemaker program databases
- Make enhancements to existing mySQL and Filemaker program databases
- Perform integration between existing mySQL and Filemaker program databases
- Support other team members in development and maintenance of program web portal
- Perform testing of mobile applications
- Contribute to the development of technical design decisions involving the database
- Work collaboratively with Application Architects, Project Managers, and Business Owners to develop the database model and design
Qualifications for database designer
- Microsoft Excel must be able to use pivot tables, and create graphs and charts, export data
- Extract, extrude, and produce 3-D feature models from overhead collection sources
- Ability to use computer applications
- Solid experience with Data Warehouse and BI systems
- This role can involve working to tight deadlines and when necessary, long hours
- 5+ years of professional experience with relational databases – writing queries and managing data
3
Database Designer Job Description
Job Description Example
Our growing company is hiring for a database designer. Thank you in advance for taking a look at the list of responsibilities and qualifications. We look forward to reviewing your resume.
Responsibilities for database designer
- Develop and implement new database and data loading patterns
- Proactively work on identifying and addressing DB/application performance issues
- Contributes to system development and deployment activities to ensure that data base systems management concerns are addressed
- Adheres to departmental and organizational standards and processes
- Provides input to strategic IT goals, objectives, tools, methodologies, and infrastructure
- Maintains accurate and up-to-date knowledge of requirements for maximizing database potential (performance)
- Work independently and proactively in a rapidly changing team environment
- Evaluates and solicits feedback on processes and procedures to identify potential areas for improvement
- Coordinates activities with supervisor and other DBA's
- Assist the Architects and Project Managers in the development of full life cycle documentation and documents all activities
Qualifications for database designer
- Models professional attitude and comfort working in a corporate setting populated by diverse types of people
- Curate and edit internal records created by less experienced Database Designers
- Minimum of 2 years’ data management/start-up processes and/or database programming experience, and 4 years of experience in clinical research is preferred
- 6+ years of experience with designing educational materials to include codifying learning objectives, developing curricula, designing and producing briefs, manuals, videos, and educational training tools and courses
- BA or BS degree or 4 years of experience as an intelligence analyst in a professional environment in lieu of a degree
- Ability to design training materials that include codifying learning objectives, developing curricula, and designing and producing briefs, manuals, videos, and multimedia training tools and courses
4
Database Designer Job Description
Job Description Example
Our company is growing rapidly and is hiring for a database designer. Thank you in advance for taking a look at the list of responsibilities and qualifications. We look forward to reviewing your resume.
Responsibilities for database designer
- Work closely with the Infrastructure, Operations, and SW Engineering staffs as needed to help troubleshoot and maintain production databases and to resolve production outages
- Communicate complex technical information in a timely, concise and coherent manner
- Maintain an in depth understanding of industry trends and evolving technology
- This is a position with duties surrounding all phases of software life-cycle development
- Completing tasks assigned by the Lead Developer/Architect and/or the Project Manager
- Develop logical and physical geospatial data models based on client driven business requirements
- Provides support for expanding and varied programming work
- Works with other technical team members to coordinate the completion of tasks
- Understand the day-to-day operations of the client and the technology being deployed and can help define and implement functionality that meets the requirements of the project's specifications
- Support developers and testers in troubleshooting database problems
Qualifications for database designer
- Ability to demonstrate flexibility to adapt to changing situations
- Fluent in English and Chinese (due to business communication with Chinese-speaking countries)
- Strong solution maker
- Med Tech, Lab Testing, Medical Terminology
- Work is performed in a general office setting
- Work is performed with multiple interruptions
5
Database Designer Job Description
Job Description Example
Our company is growing rapidly and is looking for a database designer. Please review the list of responsibilities and qualifications. While this is our ideal list, we will consider candidates that do not necessarily have all of the qualifications, but have sufficient experience and talent.
Responsibilities for database designer
- Other tasks outlined by development manager
- Collaborate with product managers on requirements for manipulating data to support key features for new and existing products within the EBSCOhost environment
- Write detailed technical database design specifications that describe how to map bibliographic data sources to EBSCO’s proprietary format
- Use ETL tools to carry out the instructions in design specifications
- Work with team members including QA, PM on product configurations and complex data transformations to ensure accurate technical implementation of database functionality and appearance according to specifications
- Provide troubleshooting and defect resolution for existing products
- Contribute to discussions about metadata standards
- For licensed secondary databases (LSDs), design and build databases from start to finish
- Identify opportunities for process improvement and drive process improvement projects from beginning to end
- Lead the design of useful, usable, and desirable products in a team environment
Qualifications for database designer
- Good knowledge of DBs (MySQL, Microsoft SQL Server, or equivalent)
- Good understanding and knowledge of SQL Development
- 7+ Years of experience in logical and physical database modeling concepts, both transactional and non-transactional
- Experience creating logical entities and defining their attributes defining the relationships between various objects
- Experience working with load test/monitoring tools to tune and optimize Oracle databases
- Experience with test and deployment automation at the database tier