Entreprise:
Secteur: comptabilité / gestion / audit
Taille: Moins de 20 employés
Description de l'annonce:
The Database Developer is responsible for
taking business requirements and creating database schema to reflect the intent
of the requirements. This position will also help other developers to write efficient
complex queries, profile and optimize query code as well as use capabilities of
the database to improve performance. General database administration experience
is a strong plus.
Candidates must have the following skills:
· Expertise in MySQL and Oracle database systems; MySQL 8.0 experience a plus; MS SQL Server experience a plus
· Expertise in Structured Query Language (SQL)
· Expertise in database design, ERDs, schema creation
· Expertise in creating stored procedures, functions, views
Position Responsibilities and Essential Duties: (Other duties may be assigned)
· Ability to work efficiently with MySQL and Oracle databases; any experience with SQL Server a plus
· Ensure data integrity and system performance for all of our databases
· Create and maintain the database schemas based on business and project requirements
· Understand the intended use of the database structures & help educate development team members on them
· Write efficient complex queries; assist developers to do the same
· Create upgrade scripts to move changes from development to production
· Support database management and provide help for upgrade and migration of databases to new releases
· Maintain database documentation
· Advise and guide systems development team members on database/file design, performance monitoring and application/maintenance design and tuning
· Troubleshoot the incidents and problems reported on database systems
· Work with IT and Client Solution team members to ensure the database integrity, high availability and security
· Help provide the root cause analysis on the major incidents/problems
Education/Experience:
· 3-5 years in DB Development with MySQL and/or Oracle
· Bachelor's degree or higher preferred
· Expertise in MySQL and Oracle database systems; MySQL 8.0 experience a plus; MS SQL Server experience a plus
· Expertise in Structured Query Language (SQL)
· Expertise in database design, ERDs, schema creation
· Expertise in creating stored procedures, functions, views
· Scripting or programming experience a plus (Python/PHP)
· Detail-oriented, strong analytical and problem solving skills
· Excellent communication and team-building skills
· Ability to work independently
· Ability to interact with business users and executive management and translate business requirements into technical implementations