Database Administrator (PostgreSQL, MySQL)
Quantam Solutions provides IT solutions and consulting for various clients. We offer a competitive hourly wage, health benefits, paid time off, and a 401(k) plan. We're currently seeking a Database Administrator.
JOB DESCRIPTION
We are seeking a new Database Administrator (DBA) that possesses expertise in PostgreSQL as well as MySQL. Most of the workload is Cloud hosted on AWS, Azure or Google Cloud, however, there will be on-premises instances that require DBA support as well.
Candidates with experience with AWS database technologies like AWS RDS, AWS Aurora PostgreSQL, and AWS Aurora MySQL will gain preference. Candidates with experience in MongoDB, MariaDB (as well as other open-source databases used in Cloud environments) will also gain preference, though this is not a requirement.
ADDITIONAL INFORMATION:
Hybrid schedule of three days remote and two days in office in Frankfort, KY.
RESPONSIBILITIES
Install, configure, administer, and maintain database systems, ensuring high availability and disaster recovery.
Perform routine database maintenance tasks, including backups, database restoration, and database migration.
Ensure data security, privacy, and compliance by implementing proper access controls and security patches.
Troubleshoot and resolve database issues in a timely manner.
Optimize queries and database performance through indexing, query optimization, and other performance-enhancing methods.
Monitor database performance and recommend improvements.
Identify bottlenecks, optimize SQL queries, and design database structures for high performance.
Collaborate with developers to design, implement, and maintain the schema of databases.
Assist with the creation of stored procedures, triggers, and other database objects.
Work with other teams to scale databases effectively to meet performance and storage requirements.
Design and implement backup, replication, and failover solutions to ensure business continuity.
Perform disaster recovery tests and ensure the database systems are always available in the event of system failures.
Plan and execute database upgrades and patches with minimal downtime.
Keep up to date with the latest features, tools, and techniques.
Maintain comprehensive and up-to-date documentation for all database systems, processes, and policies.
Create operational and technical reports to communicate database status and performance.
SKILLS REQUIRED
Extensive experience in database administration, performance tuning, and ensuring the availability and security of PostgreSQL and MySQL databases.
Experienced in providing support for high-availability environments, as well as database environments that do not require high-availability.
Expected to take a technical lead role within the team for PostgreSQL and MySQL database technologies.
Thorough understanding of System Development Lifecycle (SDLC) industry practices.
Experience supporting application developers and business users in application development.
Work on a team of 12 DBAs that currently support: Microsoft SQL Server, Oracle, DB2 and IMS databases.
Job Types: Full-time, Contract
Pay: $45.00 - $47.00 per hour
Expected hours: 40 per week
Benefits:
401(k)
Dental insurance
Health insurance
Health savings account
Life insurance
Paid time off
Vision insurance
Schedule:
Monday to Friday
Work Location: Hybrid remote in Frankfort, KY 40601
Quantam Solutions provides IT solutions and consulting for various clients. We offer a competitive hourly wage, health benefits, paid time off, and a 401(k) plan. We're currently seeking a Database Administrator.
JOB DESCRIPTION
We are seeking a new Database Administrator (DBA) that possesses expertise in PostgreSQL as well as MySQL. Most of the workload is Cloud hosted on AWS, Azure or Google Cloud, however, there will be on-premises instances that require DBA support as well.
Candidates with experience with AWS database technologies like AWS RDS, AWS Aurora PostgreSQL, and AWS Aurora MySQL will gain preference. Candidates with experience in MongoDB, MariaDB (as well as other open-source databases used in Cloud environments) will also gain preference, though this is not a requirement.
ADDITIONAL INFORMATION:
Hybrid schedule of three days remote and two days in office in Frankfort, KY.
RESPONSIBILITIES
Install, configure, administer, and maintain database systems, ensuring high availability and disaster recovery.
Perform routine database maintenance tasks, including backups, database restoration, and database migration.
Ensure data security, privacy, and compliance by implementing proper access controls and security patches.
Troubleshoot and resolve database issues in a timely manner.
Optimize queries and database performance through indexing, query optimization, and other performance-enhancing methods.
Monitor database performance and recommend improvements.
Identify bottlenecks, optimize SQL queries, and design database structures for high performance.
Collaborate with developers to design, implement, and maintain the schema of databases.
Assist with the creation of stored procedures, triggers, and other database objects.
Work with other teams to scale databases effectively to meet performance and storage requirements.
Design and implement backup, replication, and failover solutions to ensure business continuity.
Perform disaster recovery tests and ensure the database systems are always available in the event of system failures.
Plan and execute database upgrades and patches with minimal downtime.
Keep up to date with the latest features, tools, and techniques.
Maintain comprehensive and up-to-date documentation for all database systems, processes, and policies.
Create operational and technical reports to communicate database status and performance.
SKILLS REQUIRED
Extensive experience in database administration, performance tuning, and ensuring the availability and security of PostgreSQL and MySQL databases.
Experienced in providing support for high-availability environments, as well as database environments that do not require high-availability.
Expected to take a technical lead role within the team for PostgreSQL and MySQL database technologies.
Thorough understanding of System Development Lifecycle (SDLC) industry practices.
Experience supporting application developers and business users in application development.
Work on a team of 12 DBAs that currently support: Microsoft SQL Server, Oracle, DB2 and IMS databases.
Job Types: Full-time, Contract
Pay: $45.00 - $47.00 per hour
Expected hours: 40 per week
Benefits:
401(k)
Dental insurance
Health insurance
Health savings account
Life insurance
Paid time off
Vision insurance
Schedule:
Monday to Friday
Work Location: Hybrid remote in Frankfort, KY 40601
