Database Designer Resume Sample
Work Experience
- Analyze reports, forms, queries, and data extraction BRD and TRD user requirement documents created by the analyst teams to understand data model changes
- Perform detailed data profiling activities to define source system
- Create and maintain data mappings, transformation logic for logical and physical models (ETL TRD, SLM)/STM) to support implementation and ongoing maintenance of the operational data stores and warehouses
- Work with business and subject matter experts (SME's) to define new business and data definitions
- Collaborate with analysts, architects and developers through all phases of the SDLC process
- Has knowledge of database relationships and table design to support modeling approach and standards compliance. Provides detailed analysis on all new data model and ETL development and enhancement requests to ensure the solution is developed in an efficient manner and works properly with other applications within the system
- Understands and translates business needs into data models supporting long-term solutions
- Validates business data objects for accuracy and completeness
- Analyzes data-related system integration challenges and proposes appropriate solutions
- Develops data models according to company standards
- Guides System Analysts, Engineers, Programmers and others on project limitations and capabilities, performance requirements and interfaces
- Reviews modifications to existing software to improve efficiency and performance
- Examines new application design and recommends corrections if required
- Installs, maintains and supports ERWin modeling software
- Provides leadership, technical direction and long term planning to the group
- Leads medium to large groups in complex projects
- Works with the Application Development team to implement data strategies, builds data flows and develops conceptual data models
- Creates logical and physical data models using best practices to ensure high data quality and reduced redundancy
- Optimizes and updates logical and physical data models to support new and existing projects
- Maintains conceptual, logical and physical data models along with corresponding metadata
- Develops best practices for standard naming conventions and coding practices to ensure consistency of data models
- Recommends opportunities for reuse of data models in new environments
- Evaluates data models and physical databases for variances and discrepancies
Education
Professional Skills
- Excellent customer focus and excellent interpersonal skills
- Demonstrated excellent oral/written communication skills
- Demonstrated experience working on projects, training, designing process solutions, and directly interacting with customers
- Demonstrated strong background in Database Design and Database Modeling
- Strong relational database experience (Sybase or SQL Server)
- Proven experience creating logical entities and defining their attributes as well as defining the relationships between the various data objects
- Demonstrated ability to develop staff through training, coaching and counseling, including leading the work of Levels 1-2
How to write Database Designer Resume
Database Designer role is responsible for translation, software, insurance, modeling, design, reporting, architecture, security, auditing, database.
To write great resume for database designer job, your resume must include:
- Your contact information
- Work experience
- Education
- Skill listing
Contact Information For Database Designer Resume
The section contact information is important in your database designer resume. The recruiter has to be able to contact you ASAP if they like to offer you the job. This is why you need to provide your:
- First and last name
- Telephone number
Work Experience in Your Database Designer Resume
The section work experience is an essential part of your database designer resume. It’s the one thing the recruiter really cares about and pays the most attention to.
This section, however, is not just a list of your previous database designer responsibilities. It's meant to present you as a wholesome candidate by showcasing your relevant accomplishments and should be tailored specifically to the particular database designer position you're applying to.
The work experience section should be the detailed summary of your latest 3 or 4 positions.
Representative Database Designer resume experience can include:
- Strong communication skills, including influencing skills
- Experience working on projects, training, designing process solutions, and directly interacting with customers
- Experience with complex Database design and architecture, database programming, data analysis, data modeling, data integration, and data warehousing
- Experience of using ER/Studio data modelling tool or similar data modelling tool
- Experience using all of the following HTML, CSS, and JavaScript for rapid prototyping
- Experience in designing, creating and developing Oracle database systems
Education on a Database Designer Resume
Make sure to make education a priority on your database designer resume. If you’ve been working for a few years and have a few solid positions to show, put your education after your database designer experience. For example, if you have a Ph.D in Neuroscience and a Master's in the same sphere, just list your Ph.D. Besides the doctorate, Master’s degrees go next, followed by Bachelor’s and finally, Associate’s degree.
Additional details to include:
- School you graduated from
- Major/ minor
- Year of graduation
- Location of school
These are the four additional pieces of information you should mention when listing your education on your resume.
Professional Skills in Database Designer Resume
When listing skills on your database designer resume, remember always to be honest about your level of ability. Include the Skills section after experience.
Present the most important skills in your resume, there's a list of typical database designer skills:
- Strong written and oral communication skills, organizational skills, and attention to details
- Clinical Research Systems' focused informatics experience including knowledge of 21 CFR Part 11
- Oracle DBA or DBMS development experience
- Experience in developing logical and physical data models using data modeling tools
- Experience using SSRS and SSIS or other reporting program like Crystal Reports
- Strong Excel coding: Macros, VBA, Pivot Tables, etc
List of Typical Experience For a Database Designer Resume
Experience For Database Designer & Administrator Resume
- Experience of CRM & Billing applications, and within a telecoms environment would be advantageous
- A strong working knowledge of SQL, PL/SQL and the Oracle RDBMS
- Demonstrated knowledge of data and database concepts
- Experience managing/planning multiple tasks on an extended basis and within deliverable time frames
- Experience picking up and understanding new technologies and concepts with little or no help from more senior staff
- IT experience in an enterprise scale environment
Experience For Senior Database Designer Resume
- Good knowledge of a Software Development Lifecycle
- A working knowledge of Unix scripting
- Ideally have exposure and working with multiple technologies – databases, middleware, COTS packages and Java
- Oracle RDBMS Performance Tuning techniques
- Takes a technical leadership role in the team
Experience For Database Application Designer Resume
- Maintains adequate version control for data analysis and design artifacts
- Proven analytical skills including problem solving, information gathering, business to IT translation of requirements, use case development and extensive testing execution
- Considered an expert in their discipline
- Works with the Application Development team to implement data strategies, build data flows and develop conceptual data models
- Analytical experience including problem solving, information gathering, business to IT translation of requirements, use case development and extensive testing execution
Experience For Application Lead-database Designer Resume
- Knowledge of data and database concepts
- Lead/Participate in development of complex Database Modification Request Specifications, as determined by the DM Global Teams
- Understand and follow departmental and corporate WPDs and SOPs, and contribute to their development as needed
- Assist developers on DBMS usage guidelines, improvements in logic and other design considerations
- Knowledge of Version Management software
- Familiarity with the Agile Methodology would also be an advantage
- Influence technical decisions across multiple stakeholders
- Active Secret/SSBI clearance
List of Typical Skills For a Database Designer Resume
Skills For Database Designer & Administrator Resume
- Experience in Database Design including Database Modeling
- Experience working with a business intelligence tool
- Experience in managing database design, implementation and production support
- Experience with SQL database optimization techniques
- Experience with relevant development and change management tools (Jira, Confluence, Remedy)
Skills For Senior Database Designer Resume
- Experience with SQL analysis/tuning, PL/SQL Development, and Oracle
- Proven ability to schedule, plan and organize staff in problem solving activities
- Demonstrated working knowledge of DB2 in both a z/OS and Linux environment, DDL, SQL, etc
- Experience with Data transfer/manipulation/ETL methodologies
- More than 7 years’ experience as a Database Designer
- Proven ability to manage/plan multiple tasks on an extended basis and within deliverable time frames
- Proven ability to pick up and understand new technologies and concepts with little or no help from more senior staff
- Proven knowledge of Data warehouse and business intelligence
Skills For Database Application Designer Resume
- Experience as a Database Designer
- Planning and conducting the analysis of complex business issues to be solved with process changes and information systems
- Working closely with business users to resolve ongoing functional issues
- Analyzing business application requirements for functional areas
- Coordinating work with cross-functional teams leaders
Skills For Application Lead-database Designer Resume
- Understanding of Interface technologies (SOAP, MQ, JMS, Web Methods)
- Responsible for planning, designing, reviewing and approving robust, stable, scalable and manageable designs
- Responsible for planning, designing, reviewing and approving robust, stable, scalable and manageable database designs
- Perform daily monitoring of multiple databases to include Backup Execution/Monitoring and Performance Enhancement/Tuning
- Define database back-up, recovery and archiving strategy
Skills For Junior Database Designer Resume
- Define logical schemas based on logical grouping and determine & document estimated size of data
- Leads development of Clinical Study Edit Check Specification documentation to support efficient Edit Check Programming/UAT
- Consults with Clinical Data Manager and Database Programmers during Clinical Database Start-Up Process on Design/Specification questions
- Exposure to Microsoft Reporting Services
- Knowledge of UNIX Shell scripting, c# .Net Windows services, WinForms or ASP.Net
- Responsible for the technical correctness and completeness of engineering designs and artifacts
- Drive team’s support and guidance to cross-functional teams and technical resources
- Identify data requirements from across the organization and develop a plan to create a data warehouse and a reporting competency within the different business functions
- Develop new applications deploying enhanced/robust databases (auditable and secure), user Interfaces and reporting capabilities
Skills For Smart Database Designer Resume
- Maintain the existing MS SQL legacy databases and user interfaces
- Responsible for maintaining the MS SQL Environment’s Infrastructure, working with the infrastructure team to coordinate the support of (Hardware-Physical & Virtual, Storage, Software Versions & Licensing)
- Responsible for maintaining the MS SQL Environment’s Architecture (Database Design Plan, Job Maintenance Plan, Archival Plan, Auditing & Security Policy Plan and Disaster Recovery/High Availability Plan)
- Troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log issues, security issues etc
- Experience creating complex SQL queries
- Work independently, as well as, work collaboratively with a team
- Create conceptual, logical, and physical database designs that support client/business objectives
Skills For Database Modeler / Designer Resume
- Support/monitor the creation of the physical data models
- Analyze content and quality of databases and provide data normalization approaches
- Define load, frequency and recovery requirements
- Create logical entities and define their attributes and define relationships between the various data objects
- Design physical data models and generate initial Data Definition Language: Normalize model (bring it to the third normal form; Create schemas, data types, primary & foreign keys, default values, table space, hashing, partitioning)
- Define volumetrics; De-normalization of model (where necessary); and Define access requirements
- Leads/Participates in development of complex Database Modification Request Specifications, as determined by the DM Global Teams
- Willingness to be hands-on as required
- Help the Director to allocate resources for database design and implementation
Skills For Senior Manager, Database Designer Resume
- Maintain documentations on database design, functionality and specification
- Design and implement databases design standards in collaboration with data and application architects
- Create and maintain documentation of detailed design documents, diagrams, and engineering specifications, build changes, models, troubleshooting and support guides, systems metrics, and overall project information (including key deliverables)
- Proven working experience as a Database administrator: Experience in database performance tuning, database security, database management, data maintenance, database installation and configuration, database tuning and performance management, database backup recovery and high availability
- Lead development of Clinical Study Edit Check Specification ocumentation to support efficient Edit Check Programming/UAT
Skills For Database Solution Designer Resume
- Consult with Clinical Data Manager and Database Programmers during Clinical Database Start-Up Process on design/Specification questions
- Replication Monitoring for Oacle streams and application-based replication
- Maintenance and enhancement of existing DBMS software baseline
- Design and development of new capabilities to include data structure design and capacity planning
- Application, testing, and documentation of database upgrades and patches
- Development and debugging of PL/SQL packages, procedures, and triggers
Skills For Tdm-tcb Prototype Database Designer Resume
- Understands how the data and our team fits into the “bigger picture” within Westfield Group and applies this understanding in work.
- Provides estimates and project plans involving data design changes
- Oracle database administration most recent version
- Determine, enforce and document database policies, procedures and standards. Perform tests and evaluations regularly to ensure data security, privacy and integrity
- Assisting developers on DBMS usage guidelines, improvements in logic and other design considerationsEDUCATION & EXPERIENCE
- Lead development of Clinical Study Design and Specification documentation to support efficient Database Build/UAT