Position :
Lead Database
engineer
Location
:
Newark, NJ
Duration
:
Fulltime
permanent opportunity
What You Will Do:
•
Lead the configuration, design, and implementation of large-scale SQL Server
databases and Redshift/Aurora Postgres database clusters
•
Design and implement disaster recovery solutions to meet business RPO & RTO
requirements
•
Design indexing, query tuning and partitioning strategies to improve database
performance and reduce SQL query response times
•
Design and implement solutions to migrate data from large on-prem SQL databases
to Redshift databases in AWS
•
Develop scripting solutions to automate operational database tasks (DDL/DML
deployment, security management and database maintenance)
•
Implement proactive monitoring and maintenance solutions to improve reliability
and scalability of our enterprise database platforms
•
Partner with architecture and engineering teams in the design, development, and
implementation of new database applications
•
Collaborate with engineering and support teams in defining, documenting, and
evangelizing database best practices
What You Will Need:
•
10+ years of experience in the architecture, design, and implementation of
large-scale RDBMS database systems
•
3+ years of hands-on experience in the design, implementation, and management
of multi-node Redshift & Aurora Postgres database clusters on AWS
•
Strong experience in database schema design, use of sort keys and distribution
keys in Redshift and indexing strategies in Aurora Postgres
•
Strong knowledge of security related concepts in AWS databases (IAM roles,
users, policies, temporary credentials, and security groups)
•
Hands-on experience with bash / python scripting and source code management
tools such as GIT
•
Experience with Agile methodologies (Kanban/Scrum) including tools such as Jira
and Confluence
•
Excellent written and verbal communication skills
•
Bachelor’s degree in computer science or a related field.
What We Would Love to See:
•
Experience with financial services datasets across investment, product and
distribution functions
