Database Analyst Job Description
Database analyst
provides proactive monitoring and performance tuning including physical server level, database level, and query tuning.
Database Analyst Duties & Responsibilities
To write an effective database analyst job description, begin by listing detailed duties, responsibilities and expectations. We have included database analyst job description templates that you can modify and use.
Sample responsibilities for this position include:
Intermediate level Structured Query Language (SQL) or SAS programming skills
Work closely with customers, application development and other DBA teams to ensure that stringent back-up, recovery and replication strategies are developed, tested, implemented and maintained for development and production database environments
Evaluate, design, implement, review & modify EHS databases consistent with regulatory requirements
Coordinate project data issue identification, escalation, and resolution as appropriate
Provide technical direction and guidance to less experienced personnel to include oversight of tasks and deliverables on a project by project basis
Perform other ad hoc tasks as assigned
Perform Data Analysis/Data Profiling on key Master Data entities in order to report and plan data remediation and data cleanup activities
Research and identify the sources of data in an organization and maps them to specific entities, attributes or domains
Utilize data profiling tool for analysis purposes and configures tool for specific data needs
Define and write functional specification in support of the data quality requirements
Database Analyst Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for Database Analyst
List any licenses or certifications required by the position: MCSA, MCSE, SQL, OCP, ITIL, II, IAT, MCTS, SAS, DBA
Education for Database Analyst
Typically a job would require a certain level of education.
Employers hiring for the database analyst job most commonly would prefer for their future employee to have a relevant degree such as Bachelor's and Master's Degree in Computer Science, Education, Technical, Business, Engineering, Information Systems, Management, Mathematics, Administration, Information Technology
Skills for Database Analyst
Desired skills for database analyst include:
SQL
End-to-end systems development life cycles
Database utilities on multiple hardware/software platforms using multiple database engines
Iterative and other modern approaches to software development
Waterfall
Replication
Methods
Internals
Performance tuning at both server level and query level
Design
Desired experience for database analyst includes:
Requires 10 years of experience in data modeling, and database development with BS or MS degree (or equivalent)
Supporting new business initiatives and projects
Provide 24x7 production support * Processing Enterprise Change Management business requests for various database activities
5 years of support experience with Oracle
Informatica, Business Objects, Teradata, or Oracle development
Expert with configuration, installation, troubleshooting, and supporting
Database Analyst Examples
1
Database Analyst Job Description
Job Description Example
Our growing company is looking for a database analyst. To join our growing team, please review the list of responsibilities and qualifications.
Responsibilities for database analyst
- Experience working with email service providers
- Hands on experience with large customer data sets
- Experience working with a global center of excellence is a plus
- Strong ability to analyze and interpret numbers, and explain information to stakeholders
- Gain thorough understanding of data requirements and business/client needs
- Proactively monitor the performance of development and production databases to detect existing or potential incidents and/or performance issues
- Manage escalated issues as appropriate
- Champion consistency across databases by identifying data inconsistencies and working with environment owner(s) to enable data completeness
- Designing, developing, modifying, and troubleshooting software programs to include desktop applications and computer based Information Technology IT systems
- Designing, development and modifications for databases and programs
Qualifications for database analyst
- Excellent computer skills, Excel & PowerPoint a must
- Multilingual is a must
- BI desired - Beginner/Intermediate skills/experience in at least one BI tool like Business Objects, OBIEE, Tableau
- Information Technology related degree or equivalent hands on development work experience (5+years)
- Expertise in understanding various tool, writing and maintaining codes to manage the jobs, testing and troubleshooting codes in case of any errors reported or during change management
- Experience in Coding or in Testing Various platforms
2
Database Analyst Job Description
Job Description Example
Our innovative and growing company is hiring for a database analyst. To join our growing team, please review the list of responsibilities and qualifications.
Responsibilities for database analyst
- Knowledge of Oracle, OLAP, and SSAS design a plus
- Strong inter-personal and team member skills
- Ability to work with equal level of effectiveness at all management levels in company
- Develop and maintain databases and modeling activities for all business efforts
- Collaborate with end-users to create apps and reports to sit on top of the data warehouse, including but not limited to an enterprise-wide suite of daily reports, user-defined report “favorites” based on specific job functions, a browser-based reporting portal
- Configure systems and databases according to standards and best industry practice
- Produce technical documentation necessary for the administration of database environments, while maintaining a high standard regarding quality of service
- Support the SOW process
- Maintains database for various projects
- Integrates data from various sources
Qualifications for database analyst
- Familiarity with different coding structures and adaptability to new coding requirements
- Must have proven ability to communicate technical concepts to clients having varying levels of technical expertise the ability to work effectively with data managers, subject matter experts and both internal and external high-profile clients
- Bachelor’s degree in quantitative fields, Statistics, Math, Operations Research and Economic
- Java programming and Long-term care or Home Health care industry experience an asset
- Knowledge of object-oriented database concepts is essential
- Intuition, experience and desire to work with web applications or computer software independently
3
Database Analyst Job Description
Job Description Example
Our company is growing rapidly and is looking to fill the role of database analyst. 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 analyst
- Supervise the activities of the data entry team
- Provide the initial QC of data entered into CITP databases by the data entry team
- Train and mentor Db Entry Analysts and establish data entry procedures for new data types
- Collect and manage field test data
- Work directly with Cat engineering teams to identify exact field test requirements
- Manage the implementation of field test requests from the engineering team on test engines in the field
- Modify and upgrade the SuperComm 2 diagnostic database, on the average of four times per month based on field test data and test requests
- The Analyst will validate the accuracy of ECM diagnostics through data quality checks on the average of four per month
- The Analyst will facilitate resolution of any issues with data received from field test sites and correct issues within the database programming structure
- Analyst will consult with engineers to identify their data collection requirements for the data base
Qualifications for database analyst
- Desire to work in a team setting and engage in collaborative activities with staff and faculty
- Attention to detail, ability to work independently with a team
- Knowledge and understanding of Business Objects (Super User)
- A Bachelor's Degree, preferably in computer science or a related field is required
- Additional education, particularly in database management, Business Objects, programming or IT infrastructure, is beneficial
- Maintain current industry knowledge of relevant concepts
4
Database Analyst Job Description
Job Description Example
Our company is looking for a database analyst. To join our growing team, please review the list of responsibilities and qualifications.
Responsibilities for database analyst
- Develop daily / weekly / monthly reports using SAS, SQL, Tableau, Excel, and other tools
- Help maintain architecture and process flow diagrams for data systems
- 3-5 years of on-the-job DBA experience
- Moderate exposure to “big data” or data warehouse technology highly desired
- Foundational understanding of data warehouse technologies and data partitioning
- Collaborate with subject matter experts to analyze data requirements, determine gaps and develop process to source data where needed
- Troubleshoot and optimize system and reporting performance
- Partner with Product Management to assist with financial modeling and forecasting
- Microsoft SharePoint a plus
- Effectively and simply presents results and translate statistical and business terminology to senior members of management
Qualifications for database analyst
- DoD Secret Clearance (We can process a successful candidate for the clearance and candidates may start with an interim secret clearance.)
- Bachelor degree in Information Technology or completion of a college program in computer science or equivalent experience
- Minimum of 7 years’ general experience in Information Technology
- Expert logical and objective analytical skills and ability to use sound judgement when evaluating potential solutions, while respecting fixed deadlines and adjusting to priority changes and corporate objectives
- Demonstrated experience in the technical aspect of projects (performance, security, robustness, ) and in the resolution of complex problems with various stakeholders
- Great ability to work in a team or autonomously
5
Database Analyst Job Description
Job Description Example
Our innovative and growing company is looking for a database analyst. 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 analyst
- Demonstrates proficiency in SQL to perform data loads, data extracts and conversions
- Ability to develop SQL code independently for intermediate to moderately complex procedures in both Oracle and MSSQL Server environments
- Assists in the development, maintenance, and support of the OEAS Knowledgebase data warehouse and corresponding BI applications, including data design and integration, database architecture/metadata and repository creation
- Evaluate and recommends available database management system (DBMS) products
- Develops methodology for the ongoing assessment of database performance
- Works collaboratively with users and team members to gather requirements
- Identifies and troubleshoots errors and/or problems with applications
- Monitors database performance, identifies potential areas for improvement, makes modifications as appropriate
- Support Asset Management processes by assisting with tagging, shipping, data entry, audit, as needed
- Analyzes data requirements, application and processing architectures
Qualifications for database analyst
- Ability to multi-task, work efficiently under pressure and in crisis situations
- Ability to influence and sell ideas to his/her colleagues, supervisor and management
- Knowledge of IT processes (ITIL) and quality management processes is a plus
- Experience with installing applications on Windows Server
- Must be able to react quickly in a fast-paced retail environment
- Ability and willingness to continue to expand knowledge and experience