Principal Database Engineer
| Company | Veracode |
|---|---|
| Location | Burlington, MA, USA |
| Salary | $Not Provided – $Not Provided |
| Type | Full-Time |
| Degrees | Bachelor’s, Master’s |
| Experience Level | Senior, Expert or higher |
Requirements
- BS/MS in Computer Science or related field, or relevant industry experience.
- Extensive hands-on experience supporting relational database solutions including PostgreSQL, Oracle and MySQL in production at scale.
- Experience managing/operating highly available databases in public cloud deployments, preferably AWS.
- Experience in Cloud deployments and concepts for CI/CD, Microservices (k8), Networking and Security.
- Experience in DevOps and Infrastructure as Code (IaC) to deploy and manage resources.
- Significant tuning/optimization expertise in large RDBMS deployments. Experience is AWS services would be desirable.
- Expertise in relational database design including partitioning, indexing and data modeling techniques.
- Strong diagnostic skills.
- Advanced knowledge of SQL.
- Hands-on experience with NoSQL/Document database solutions such as MongoDB, AWS Redshift, ElasticSearch including data modeling, tuning, shard key selection, etc.
- Knowledge of approaches to data security, governance, and access controls
- Highly collaborative team player.
- Strong organizational and communication skills.
Responsibilities
- Production database health and performance monitoring, including participation in on-call rotation.
- Partner with Veracode engineering teams to craft optimized data models and access paths for well-designed cloud-native services.
- Deploy cloud resource and their configurations using DevOps tooling, preferably terraform.
- Proactively monitor and perform query tuning and optimization across databases underpinning multi-tenant SaaS applications.
- Design, implement and exercise approach to BCDR scenarios for our database systems.
- Analyze existing systems and design databases to support our business applications, ensuring scalability, security, performance, and reliability.
- Decompose legacy data models to enable de-coupled services with reasonable bounded context and develop migration strategies/implementation between them.
- Perform code review/approval/governance functions.
- Translate logical data models into physical, optimized and highly available database structures including partitioning, sharding and replication for mission critical applications.
- Develop and document database architectures.
Preferred Qualifications
- Proficiency in a core programming language, e.g. Python, Java.
- Experience with AWS database services such as RDS, Aurora, Redshift.
- Proficiency in IAC, preferably Terraform.
- Experience with CI/CD tooling and practices