Job Description:
JOB SUMMARY:
The Database Administrator (DBA) will be responsible for the development, performance, integrity, and operations of database systems of Vertex. As a DBA you will work with engineering teams to educate about best practices and lead implementation of ideal queries and database structures. Vertex runs several RDBMS systems, including PostgreSQL, MS SQL Server and Oracle. This position requires the ability to work independently, as well as in collaboration with others to implement solutions.
ESSENTIAL JOB FUNCTIONS AND RESPONSIBILITIES:
Operational Database Management
-
Monitor database performance, conduct regular performance tuning, and optimize queries, query patterns, and system for maximum efficiency
-
Install, configure, and upgrade database software and related tools
-
Develop and implement database backup and recovery strategies to ensure data reliability and minimize downtime.
-
Manage routine maintenance tasks, such as database backups, index rebuilding, and statistics gathering.
-
Manage and optimize critical production databases to ensure the availability and reliability of critical databases to ensure optimization and best practices.
Engineering Database Expertise and Best Practices
-
Work with engineering teams to implement database related best practices
-
Review SQL queries for optimal implementation to prevent production issues
-
Recommend database techniques such as prepared statements, indexes, and/or cursors to assist and educate engineering teams
Performance Optimization and Troubleshooting
-
Identify and resolve database performance issues, such as slow queries, inefficient indexing, or resource contention.
-
Conduct database capacity planning to anticipate future storage and performance needs.
-
Implement and maintain database monitoring tools to proactively identify and resolve issues.
KNOWLEDGE, SKILLS AND ABILITIES:
-
Strong verbal and written communication skills with the ability to collaborate well within a team and across organizations.
-
Strong Experience implementing and managing PostgreSQL and SQL Server databases with automation and configuration management tools and techniques.
-
Experience in scripting/deployment languages such as PowerShell, Python, Go, Terraform
-
Experience with deployment, configuration, and maintenance of PostgreSQL on Amazon Aurora Serverless v2 RDS and RDS for SQL Server
EDUCATION AND TRAINING:
-
BS in computer science, Information Technology, or a related field.
-
Minimum of 5+ years of proven work experience as a Database Administrator
-
Strong knowledge of database management systems, such as Microsoft SQL Server, PostgreSQL, and Oracle
-
Proficiency in writing complex SQL queries and optimizing database performance.
-
Knowledge of Cloud Infrastructure, particularly AWS and Azure
-
Experience building and maintaining highly available database environments with cross site/region failover.
-
Experience performing advanced tuning of PostgreSQL and SQL Server for high volume throughput.
-
Ability to design, deploy, and manage database services on cloud platforms like AWS and Azure.
-
Experience with Software as a Service (SaaS) environments including architecture and management.
-
Understanding of security best practices when architecting and deploying databases.
-
Experience developing SQL queries to support troubleshooting and reporting in a live production environment.
-
Participate in an on-call rotation in support of production environments
-
Performing occasional off-hours or weekend work as needed.