AffinityX jobs - Database Developer

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. Candidates must have the following skills:

Strong knowledge of MySQL and Oracle database systems; MySQL 8.0 experience a plus; MS SQL Server experience a plus

Strong knowledge of Structured Query Language (SQL)

Strong knowledge of database design, ERDs, schema creation 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
Required Candidate Profile

• 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
• Comfortable to work in US/ UK shift(5 days week)
  

Perks And Benefits

Performance Incentives and Other Benefits