Senior Database Engineer
Senior Database Engineer
Redapt Inc. is a pioneering world-class data center infrastructure integrator, technology engineering firm, and cloud services provider. Our teams focus on delivering innovative solutions and services that power our customers' most demanding applications and enable them to extract powerful insights from data that drive true business value.
We are looking for a Senior Database Engineer to join our Cloud Solutions team. This individual will have a passion for cloud data platforms, open source technologies, and enjoys working in an environment where every project requires a best-of-breed solution.
Our engineers design, modernize, and optimize database solutions that solve real-world problems and deliver value to our long-term clients. We encourage them to leverage modern cloud database platforms, automation tools, and proven engineering practices while interfacing with thought leaders across the industry.
Responsibilities:
- Design, develop, test, and maintain scalable, secure relational database solutions that support cloud-native and enterprise applications.
- Design logical and physical data models, schemas, tables, relationships, constraints, indexes, and partitioning strategies based on application and business requirements.
- Develop and maintain SQL, stored procedures, functions, views, triggers, and other database components used by applications and integration workflows.
- Tune database performance across SQL, indexing, schema design, execution plans, configuration parameters, storage, and capacity to meet demanding application workloads.
- Review application data-access patterns and collaborate with software engineers to improve query efficiency, transaction behavior, concurrency, and scalability.
- Plan and execute database migrations, upgrades, schema changes, and platform modernization efforts with strong validation, data-integrity, and rollback practices.
- Implement and support database backup and recovery, replication, high availability, security, access controls, monitoring, auditing, and capacity planning.
- Automate database provisioning, configuration, schema deployment, maintenance, and operational workflows using infrastructure as code, scripting, CI/CD, and cloud-native tooling.
- Diagnose and resolve database performance, locking, connectivity, availability, and data-integrity issues across development, test, and production environments.
- Translate customer and application requirements into practical data models, database designs, engineering tasks, and implementation plans, and evaluate new database technologies where appropriate.
Skills you bring with you:
- Advanced SQL and relational database design skills, including data modeling, normalization and denormalization, indexing, constraints, transactions, and schema design.
- Strong hands-on experience with PostgreSQL and familiarity with one or more additional enterprise relational database platforms such as SQL Server, Oracle, or MySQL.
- Strong database development experience, including stored procedures, functions, views, triggers, schema versioning, and database change management.
- Proven ability to troubleshoot and tune database workloads using execution plans, query analysis, indexing strategies, statistics, locking and concurrency analysis, and configuration tuning.
- Practical experience designing and operating databases in AWS, including managed relational database services such as Amazon RDS and Amazon Aurora.
- Solid understanding of database reliability and operations, including backup and recovery, replication, high availability, disaster recovery, monitoring, security, encryption, and access control. Experience with Python or Bash and automation tools such as Terraform, AWS CDK/CloudFormation, or equivalent is a strong plus.
Qualifications:
- BS or MS in Computer Science, Information Systems, Engineering, or a related field preferred; equivalent experience considered.
- 5+ years o