Senior Database Engineer

Job Code: MACIN10120

Role: Senior Database Engineer

Skill Set: RDBMS, NoSQL databases, PostgreSQL, Oracle, MySQL, AWS

Desired Industry Experience: 5+ years

Role Description:

Job Title: Senior Database Engineer
Experience: 8 + Years
Company: Macrosoft Inc.

Responsibilities

• This individual will work closely with users, technical leads, project managers, and other cross-functional development teams to design and deliver database solutions. This includes writing SQL queries, developing backend procedures, functions and integration with applications within the core pathway. Also support quality assurance team(s)
• Optimize/tune queries for best performance efficiency, Assess security of SQL written for potential risks
• Tackle simple/moderate DBA tasks independently
• This individual must develop database/backend solutions using disciplined database development and testing processes, adhering to team/company standards and database best practice guidelines, and corporate policies

Desired Skills:

Demonstrable experience in database design and development role on medium to large, enterprise-scale databases. The engineer must be familiar or have experience with Enterprise Integration Patterns, EAI, SOA, EDA architectures and their main principles

Candidate must be able to demonstrate experience in the following:

• Working with RDBMS and NoSQL databases.
• PostgreSQL / Oracle / MySQL
• Design and development (governance/setting standards, versioning, etc.)
• Cloud – AWS preferred (RDS, DynamoDB, EC2, IAM, S3)
• Write/tune moderate to highly complex queries
• ETL – moderate to complex data structure, high volume of data
• Familiarity with various SQL clients
• Practice with Git and Continuous Integration infrastructure
• Transformation of Oracle SQL scripts into Postgres scripts
• Data migration from Oracle db to Postgres db
• Experience with AWS DMS, SCT tools