Omniscius Consulting
Senior PostgreSQL\MySQL Database Administrator
Omniscius Consulting, Chicago, Illinois, United States, 60290
Our client is seeking an experienced Senior PostgreSQL/MySQL Database Administrator able to perform remote consulting assignments, health checks, tuning, assessments, troubleshooting, installations, and migrations.Will require participation in our 24/7 on-call support rotation. Will require daily multitasking among multiple clients.PostgreSQL DBA Experienced with:
MINIMUM of 10 years of experience as a PostgreSQL DBA Database AdministratorMINIMUM of 7 years of experience as a MySQL DBA Database AdministratorPostgreSQL versions 9.3 to 14MySQL (and/or MariaDB 5.7 - 10.x) 5.7 - 8.xAWS SCT, AWS DMS, AWS Aurora PostgreSQLAble to support PostgreSQL/MySQL/MariaDB in cloud environment (AWS, Azure or GCP)Experience with supporting a PostgreSQL/MySQL/Aurora AWS RDS environmentHomogenous and Heterogenous Migrations to PostgreSQLKnowledgeable in best practices for maintenance configurationsProduction experience with Installation, Configuration, Upgrades and PatchesAd hoc Index MaintenanceUser and Role ManagementPerformance tuning, query analyzationAble to troubleshoot problems with little or no assistanceProviding configuration, monitoring and on-call support for development, test, and production environmentsAble to assist clients with PostgreSQL/MySQL issues on the phone and via screen sharing software on the spotLinux and Microsoft Windows experience requiredMust communicate effectively both verbally and writtenMust be able to demonstrate ability to troubleshoot technical issues.On-call support and regularly scheduled off-hours production installationsAbility to export and import data from and to a PostgreSQL/MySQL databaseWilling to attain additional CertificationWilling to learn new skills that benefit the team and company when askedQualifications:
Bachelor's degree in MIS, Computer Science, Information Technology, or a related field.3+ years of experience in a managed services environment.In-depth knowledge of PostgreSQL and MySQL architecture, configuration, and performance tuning.Proficiency in scripting languages such as Bash, Python, or Perl for automation tasks.Experience with database replication, clustering, and high availability solutions.Strong analytical and problem-solving skills, with the ability to troubleshoot complex database issues efficiently.Excellent communication skills and the ability to work effectively in a collaborative team environment or independently.PostgreSQL, MySQL, and/or MongoDB certification is a plus.DESIRED:
Experience with AWS Glue and other AWS applicationsOptimizing loads of large volumes of data into a databaseStored Procedure and Function DevelopmentWriting Foreign Data WrappersMariaDB Galera cluster experience is a plusLinux/Unix Shell scripting and windows scriptingExperience with large corporate business environmentsData modeling concepts, also data warehousing development and design a plusSystem administration skills a plusTechnical support or call center support experience a plusProfessional Consulting Experience a plusVPN/Network/RDC configuration and debugging skills a plusAdvantages of working with XTIVIA:
Open, flexible time off for your work/life balanceComplete insurance package (medical, dental, vision, life, AD&D, 401K and disability) for employees and their dependentsFlex office hours to help with family responsibilitiesTeladoc for on-demand remote medical care via telephone and video conferencingCertifications and training available to support employee professional developmentHR Programs, like Employee Assistance Program and Holiday Charity Matching ProgramStellar people who are passionate and committed to our customers
#J-18808-Ljbffr
MINIMUM of 10 years of experience as a PostgreSQL DBA Database AdministratorMINIMUM of 7 years of experience as a MySQL DBA Database AdministratorPostgreSQL versions 9.3 to 14MySQL (and/or MariaDB 5.7 - 10.x) 5.7 - 8.xAWS SCT, AWS DMS, AWS Aurora PostgreSQLAble to support PostgreSQL/MySQL/MariaDB in cloud environment (AWS, Azure or GCP)Experience with supporting a PostgreSQL/MySQL/Aurora AWS RDS environmentHomogenous and Heterogenous Migrations to PostgreSQLKnowledgeable in best practices for maintenance configurationsProduction experience with Installation, Configuration, Upgrades and PatchesAd hoc Index MaintenanceUser and Role ManagementPerformance tuning, query analyzationAble to troubleshoot problems with little or no assistanceProviding configuration, monitoring and on-call support for development, test, and production environmentsAble to assist clients with PostgreSQL/MySQL issues on the phone and via screen sharing software on the spotLinux and Microsoft Windows experience requiredMust communicate effectively both verbally and writtenMust be able to demonstrate ability to troubleshoot technical issues.On-call support and regularly scheduled off-hours production installationsAbility to export and import data from and to a PostgreSQL/MySQL databaseWilling to attain additional CertificationWilling to learn new skills that benefit the team and company when askedQualifications:
Bachelor's degree in MIS, Computer Science, Information Technology, or a related field.3+ years of experience in a managed services environment.In-depth knowledge of PostgreSQL and MySQL architecture, configuration, and performance tuning.Proficiency in scripting languages such as Bash, Python, or Perl for automation tasks.Experience with database replication, clustering, and high availability solutions.Strong analytical and problem-solving skills, with the ability to troubleshoot complex database issues efficiently.Excellent communication skills and the ability to work effectively in a collaborative team environment or independently.PostgreSQL, MySQL, and/or MongoDB certification is a plus.DESIRED:
Experience with AWS Glue and other AWS applicationsOptimizing loads of large volumes of data into a databaseStored Procedure and Function DevelopmentWriting Foreign Data WrappersMariaDB Galera cluster experience is a plusLinux/Unix Shell scripting and windows scriptingExperience with large corporate business environmentsData modeling concepts, also data warehousing development and design a plusSystem administration skills a plusTechnical support or call center support experience a plusProfessional Consulting Experience a plusVPN/Network/RDC configuration and debugging skills a plusAdvantages of working with XTIVIA:
Open, flexible time off for your work/life balanceComplete insurance package (medical, dental, vision, life, AD&D, 401K and disability) for employees and their dependentsFlex office hours to help with family responsibilitiesTeladoc for on-demand remote medical care via telephone and video conferencingCertifications and training available to support employee professional developmentHR Programs, like Employee Assistance Program and Holiday Charity Matching ProgramStellar people who are passionate and committed to our customers
#J-18808-Ljbffr