Engineer Database Job Description
Engineer Database Duties & Responsibilities
To write an effective engineer database job description, begin by listing detailed duties, responsibilities and expectations. We have included engineer database job description templates that you can modify and use.
Sample responsibilities for this position include:
Engineer Database Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for Engineer Database
List any licenses or certifications required by the position: MCITP, SQL, AWS, MS, MCTS, ITIL, HA, MCSE, MCDBA, OS
Education for Engineer Database
Typically a job would require a certain level of education.
Employers hiring for the engineer database 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, Engineering, Technical, Education, Information Technology, Mathematics, Information Systems, Software Engineering, Administration, Design
Skills for Engineer Database
Desired skills for engineer database include:
Desired experience for engineer database includes:
Engineer Database Examples
Engineer Database Job Description
- Supporting and maintaining software
- Acting as a liaison supporting investments and operations teams
- Developing and integrating related applications and design reports
- Full life cycle of a development project
- Enforce database standards across development teams
- Gather information from line of business and vendors, provides feedback and assists on building business use cases for proof of concept projects
- Research and identify new technology candidates to enhance the existing software portfolio or to replacing existing solutions
- Provide conceptual technology solution design and provide all cost estimation to help stakeholders to build business cases
- Engage internal users and vendors to participate proof of concept projects based on business stakeholder interests
- Implements new technology in lab environment which is based on due diligence requirements
- Software engineering, system administration, systems engineering, Database engineering, Database Administration
- Excellent knowledge around Engineering and supporting modern Database platforms and services – MySQL, Postgress, MariaDB with Galera
- Detailed understanding of IaaS and virtualization – service orientated architecture designed around the delivery of Infrastructure components
- BS in Computer Science or related IT field, or equivalent work experience
- Strong understanding of relational databases and database fundamentals, including data storage, data modeling, and data access patterns
- Basic SQL Server administration skills, such as backups, restores, taking and reverting snapshots, user/role security, access permissions
Engineer Database Job Description
- Troubleshooting and performance triaging
- Ability to design/architect scalable database-centric applications
- Understand and validate ETL test objectives
- Design and implement the infrastructure for the database testing for each project
- Design and develop automated script for database and execute them
- Testing at the system or sub-system level
- Document and track software failures
- Coordinate testing with cross-functional QA/Business Analytics teams
- Ability to create performance test plans, define strategies and design automation code
- Prepare Pardot's database infrastructure for the next phase of rapid scaling
- SQL/Scripting (Preferably Python) required, Tableau experience is a plus
- Excellent knowledge and practice of coding techniques in the map
- Ability to prioritize and balance many tasks at once on tight timelines
- Knowledge of Release process is a plus
- Background in Root Cause Analysis and 8D process is a plus
- Ability to work well on cross functional teams and be a team player
Engineer Database Job Description
- Serve as a data and database resource for the company
- Be curious, and understand the stack that uses Yelp’s databases
- Included within those responsibilities are the areas of data access and delivery technologies
- Duties include performance tuning, monitoring, software installs and upgrades, scripting, and physical and logical database design
- Familiarity with AWS services and scripting
- Familiarity with Web Applications and Service Oriented Architecture
- Migration off/to RDBMS, AWS DBs (RDS, DynamoDB, EMR, Redshift, Aurora, ), Data Information Lifecycle Management, Data Security, Big Data
- Manage the overall integrity, stability, scalability, and security of the above databases
- Manage and maintain database software, backups, and real-time failover capability
- Manage read replicas for reporting and scaling application usage
- Full understanding of database concepts, relational database design, and the concepts of data normalization
- Ability to interact with both technical and non-technical staff
- Bachelors of Science degree with major in Computer Science, Math or Engineering
- Demonstrated ability to plan and execute large scale database upgrades
- Experience with troubleshooting/solving database issues related to performance, stored procedures, configuration, and data discrepancies
- Familiarity with data access technologies and protocols, such as ODBC, OLEDB, ADO.NET, LINQ to SQL, Entity Framework, JDBC, Hibernate/NHibernate
Engineer Database Job Description
- Develops Views/Data Marts for information to be made available to external applications
- Implements security rules/standards
- Implements transformation code
- Reviews USA_Reference relational table design and USA_DW tables or operational issues with Data System Architect
- Responsible for Extract, Transform and Load (ETL) of data via Import/Export wizards, such as SSIS, PDI and/or other technologies
- Codes, tests, and documents ETL configurations
- Modifies/fixes ETL process flows
- Adapts ETL processes to accommodate changes in source systems and with new business user requirements
- Defines and captures metadata and rules associated with ETL processes
- Optimizes database code by analyzing query execution plans
- Minimum of 4+ years in IT data-related fields including Database Administration, ETL Development, SQL Development or similar
- At minimum 3 years in PL/SQL or Transact-SQL
- Prior knowledge of Siebel database structures a plus
- Prior experience with Teradata (v.13 and higher) a strong plus
- Demonstrated exposure and aptitude with database platforms including SQL Server and/or MySQL
- Ability to build and maintain strong working relationships with DBA , application teams and external hardware vendors
Engineer Database Job Description
- Editing datasets in using a database manement tool such as mongodb
- Submits weekly activity reports to Data Systems Manager and Director of Data Administration
- Assists with other duties as the Director of Data Administration and the Data Systems Manager assigns them
- Participate in the design and architecture of efficient and forward thinking database systems
- Performs set of disciplines for the planning analysis, design, and construction of custom applications on an organizational-wide basis
- Develops, implements, maintains COTS and custom applications
- Consults with clients to gather information about project needs, objectives, and functions
- Elicits, analyzes, and validates end-user requirements
- Develops prototypes, user interface designs, use cases, reports, and screen layouts
- Optimizes databases to improve performance
- Experience programming in any applicable administrative language (shell, Perl, Python,Java) is a must
- Bachelor's degree in Computer Science, Engineering, Computer Information Technology or equivalent
- Five years’ experience and proficient programming with C#, C++, Java, or other object oriented programming languages
- Proficient in TFS, Visual Studios, SSDT, MS Sequel Service Manager, and MS Excel
- Must be able to multi-task and provide great attention to detail on a demanding project
- Must be flexible and adaptable to changing software requirements and work priorities