Database Developer

Position title: Database Developer
Office location: United States

Open to candidates residing and are authorized to work in the US states.

 
Candidates must have the following skills:
 
  • Strong knowledge of MySQL and Oracle database systems; MS SQL Server experience a plus
  • Strong knowledge of Structured Query Language (SQL)
  • Strong knowledge of database design, ERDs, schema creation  
 
Job Description
 
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.
 
  • Position Responsibilities and Essential Duties:
  • 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 
  • Strong knowledge of MySQL and Oracle database systems; MS SQL Server experience a plus
  • Strong knowledge of Structured Query Language (SQL)
  • Strong knowledge of database design, ERDs, schema creation  
  • 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
 
Ability to travel; estimate under 25%