Senior Database Engineer

Job Description

Seeking a seasoned Database Architect with expertise in Oracle and/or PostgreSQL, system wide migrations, and complex query creation and optimization. The ideal candidate should have at least 7 years of experience in database management and be able to work independently. Key responsibilities include defining a schema for a new product, managing and maintaining databases, planning and executing system wide migrations, creating and optimizing complex queries, ensuring the security and integrity of the database, and providing training and support to team members. This role requires excellent communication and problem-solving skills, as well as a strong understanding of database architecture, design, and security.

Responsibilities:

• Design, implement, and maintain Oracle and PostgreSQL databases

• Expert in ETL tools, data integration, and migration processes

• Create and optimize complex SQL queries for performance and efficiency

• Develop and refine database functions, procedures, and packages

• Analyze and troubleshoot database performance issues, implementing tuning solutions

• Ensure database architecture aligns with application needs and best practices

• Collaborate with development teams on data models and database design

• Provide documentation, training and support to other team members

• Assure quality, security and compliance requirements are met as part of projects delivery

Qualifications:

• 7+ years of experience with Oracle and/or PostgreSQL

• Experience in designing database schemas from scratch

• Experience with documentation such as ERDs and DB Relations

• Experience with system wide migrations

• Strong understanding of database architecture and design

• Experience with complex query creation and optimization

• Experience with performance tuning and troubleshooting

• Strong understanding of database security

• Experience with database backup and recovery

• Excellent communication and problem solving skills

• Bachelor's degree in Computer Science or related field is a plus

• Experience in development of SaaS enterprise scale product

• Experience in working with globally distributed teams following Agile methodology and Scrum.

• Experience in working with modern CI/CD tools and related ecosystem of applications uDeploy, Jenkins, Artifactory, Maven etc.

• Experience using source control tools like Git, SVN etc.

Other Skills

• Flexible to work with the lean and small team environment.

• Requirement understanding, development, implementation, testing, problem analysis & resolution, and technical documentation (Coding & Design documentation)

• Ability to understand requirements and map to low & highlevel technical design.

• Able to create a design for small components.

• Must be detail oriented, organized, and able to work independently with minimal supervision.

• A real "Problem Solver" with independency.

• Must be able to take initiative be productive and efficient.