What are the responsibilities and job description for the Database Engineer position at Vertex Sigma Software?
As a Database Engineer at Sigma Software, you will design, build, and operate scalable, secure data stores that power our applications and analytics. You’ll partner closely with application and data teams to shape schemas, tune performance, and automate operations using AWS and infrastructure-as-code. Your work will improve reliability, reduce cost, and accelerate delivery from development through production.
In this role, you will:
● Design and develop efficient, scalable database solutions aligned to business requirements.
● Install, configure, and upgrade database software and related tooling.
● Monitor performance and optimize queries, indexes, and schemas for reliability and speed.
● Implement and maintain database security controls to protect sensitive data.
● Collaborate with application developers to optimize schema designs and SQL.
● Troubleshoot incidents and provide timely resolution across environments.
● Develop and maintain documentation for architecture, configuration, and runbooks.
● Perform capacity planning and recommend infrastructure improvements.
● Manage and support AWS database infrastructure (e.g., RDS/Aurora/Redshift).
● Stay current on emerging database technologies, patterns, and best practices.
● Strong understanding of AWS and IaC for database resources.
● Proven experience as a Database Engineer/DBA.
● Deep knowledge of DBMSs (e.g., PostgreSQL, MySQL, SQL Server, Redshift).
● Proficiency in SQL and query optimization.
● Solid grasp of data modeling, normalization, and schema design principles.
● Hands-on experience with performance tuning and monitoring.
● Understanding of backup/restore and disaster recovery procedures.
● Knowledge of database security best practices.
● Excellent problem-solving, analytical, communication, and collaboration skills.
● Ability to thrive in a fast-paced, dynamic environment.
Nice to have:
● AWS networking fundamentals.
● Experience with Terraform Cloud and IaC workflows.
● Automation/scripting with Python or Shell.
● CI/CD for databases (e.g., Bamboo, Flyway, or similar)
- Health Care Plan (Medical, Dental & Vision)
- Life Insurance (Basic, Voluntary & AD&D)
- Paid Time Off (Vacation, Sick & Public Holidays)
- Training & Development
- Retirement Plan (401k, IRA)
- Free breakfast and lunch
