Database Management Analyst Job Description
Database Management Analyst Duties & Responsibilities
To write an effective database management analyst job description, begin by listing detailed duties, responsibilities and expectations. We have included database management analyst job description templates that you can modify and use.
Sample responsibilities for this position include:
Database Management Analyst Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for Database Management Analyst
List any licenses or certifications required by the position: ITIL, V4, V3
Education for Database Management Analyst
Typically a job would require a certain level of education.
Employers hiring for the database management 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, Engineering, Technical, Information Technology, Science, Life Science, Business, Biological Sciences, Chemistry
Skills for Database Management Analyst
Desired skills for database management analyst include:
Desired experience for database management analyst includes:
Database Management Analyst Examples
Database Management Analyst Job Description
- Assignment to project teams to represent information security requirements and perform operations and administration tasks
- Act as Subject Matter Expertise (SME) over IAM practices, policies and procedures for the access management of Databases
- Database Resource Management
- Hands on experience in trouble shooting and performance tuning of SQL and stored procedures
- Maintain internal databases with a variety of information
- Liaising with other process owners and functional areas (eg
- Perform analysis of data, hierarchies, and processes that are critical to existing and future EPM systems
- Understand and requirements from key stakeholders by conducting interviews
- Learn how to Design, develop, test, and/or implement objects including (but not limited to) web forms, business rules, calculation scripts
- Support testing activities between IT, the Planning application support team and the EPM reporting team
- Total 12+ years of DB2 Database Administration experience out of which minimum 4+ should be on DB2 9.x or higher versions
- Working knowledge of v11 CM and NFM
- IBM Utilities
- Minimum 3-5 years of work experience as a Mainframe IMS database Administrator
- Prior experience with SQL/Oracle languages and database structures
- Moderate understanding of reporting and data visualization tools
Database Management Analyst Job Description
- Work with users during UAT to ensure the system has met requirements
- Create database objects (tables, views, stored procedures, jobs, packages, indexes ) and document them
- Provides system and network architecture support
- Provides technical support to business and technology associates
- Provides trouble resolution on complex issues
- Performs system and network upgrade tasks
- Responds to Level 3 and 4 change and problem requests
- Leads Level 1 and 2 incident recoveries and root cause analysis
- Provide second level technical trouble support
- Solve randomly occurring problems
- Experience with setting up/configuring data feeds via web services and SFTP
- Solid understanding of database marketing principles
- Experience with project management tools and processes
- Experience in building data mart/BI layers tailored for advanced reporting
- Experience creating and modifying database triggers and stored procedures
- Experience/knowledge in Bigdata technologies will be an added advantage
Database Management Analyst Job Description
- Perform technology upgrade tasks utilizing change control
- Design and configure vendor services orders for repetitive services & oversee implementation
- Respond to level 3 & 4 change and problem requests
- Participate in level 1/2 incident recoveries with minimal supervision
- Act as an internal consultant to our business partners to assess their decision-making, reporting and marketing needs, and recommend appropriate metrics, either from existing reports or from new reports to be developed
- Research, analyze and leverage data from a wide range of internal and external sources to generate comprehensive direct marketing lists
- Develop and apply a deep and broad understanding of the underlying business & marketing issues that your reports and analyses are intended to address, in order to ensure their accuracy & relevance
- Valuable for this role, is a hands on programming knowledge base of IBM campaign (Unica), Salesforce Marketing Cloud, Marketo or other marketing campaign software
- Reconcile the CMDB data when exceptions are noted between CMDB and other authoritative production data repositories
- Work closely with Network Operations Centre, Data Centre Analyst, Infrastructure, Network, Server, Implementation & Tools teams to establish business requirements for the CMDB
- Solid understanding of Operational Data Store structure
- Optional to have experience with database software – MS SQL, Sybase and with experience of other relational databases a plus
- Operational data stores is a plus
- Minimum 3-5 years of work experience as a Mainframe IMS and DB2 Database Administrator
- JAVA, J2EE, RDBMS, SQL, Linux
- Solution delivery experience with in-depth understanding of Software Development LifeCycle (SDLC) methodologies including SAEe, Agile
Database Management Analyst Job Description
- Assisting with data quality efforts by verifying security information against publically available data sources
- Ensure ITSM and CMDB alignment within an ITIL v3 framework
- Research and update information about Chinese chemical manufacturing companies including the English name and ownership of the manufacturing company, plant locations, and specific chemicals made at each site
- Monitor trade literature for changes to company information (e.g., company name, ownership, plant locations, chemicals manufactured, start-ups, expansions, closures)
- Research company Websites and other resources for updates or to develop new company listings
- Contact chemical companies to verify and develop information and to resolve research questions as needed
- Update IHS Chemical ChemAssets database to reflect changes
- Organize research material for quality control and to back-up database changes
- Respond quickly to questions needed for client inquiries or upcoming IHS Chemical publication deadlines
- Ensure that client deliverables are of the highest quality and completed according to schedule
- Strong understanding of service management frameworks
- Experience with consumption-based cost transparency which may include industry tools like Apptio and ServiceNow Financial Management
- Exhibits an advanced ability to impact and influence outcomes and to handle multiple priorities so as to build a strong network and relationships at senior levels across IT functions and the business
- Experience with team leadership and conflict management
- Ability to be consistently flexibility, resilient, and resourceful, working with multiple teams, delegating work load and ensuring team efficiency
- Works closely with stakeholders to establish business requirements for the CMDB
Database Management Analyst Job Description
- Resolving database performance issues, database capacity issues, replication and other data issues
- Working with other Information Architects and Database Designers to implement the physical data model
- Developing the database performance monitoring process and analyze data for optimization opportunities
- Taking on such other tasks as may be required to ensure a secure and compliant
- Innovate/Ad Hoc
- Research and update information about chemical manufacturing companies including the English name and ownership of the manufacturing company, plant locations, and specific chemicals made at each site
- Research producers, plant locations and capacity data for IHS Chemical projects
- Update IHS Chemical Assets database to reflect changes
- Monitor CMT OG Marketing share mailbox and respond to requests promptly
- Make updates, additions, etc in SFDC per requests
- Communicate CMDB activities to shareholders to enhance general awareness of processes and standards
- Liaise and work with business partners of various teams to ensure all use-cases and needs are met
- BA/BS degree and 5 years or more work experience in a programming, analytical and/or consulting role
- Demonstrated success as a thought partner and as a champion/leader of new ideas
- Sharp analytical skills with an ability to understand and build metrics, analyze data for insights and optimize campaigns based on learnings
- Strong SAS or SQL programming, business analysis and data analysis skills as evidenced by 5+ years of development and analysis experience