Hyve Solutions
Key Responsibilities
Perform advanced database administration tasks for Sybase, MySQL, Vertica, PostgreSQL, and MS SQL. This includes installation, configuration, replication setup, version upgrades, patch management, performance monitoring, and advanced troubleshooting. Support both on-prem and cloud-hosted environments (AWS RDS, Azure SQL Database, Google Cloud SQL, etc.).
Forecast storage, IOPS, and compute requirements for current and future workloads. Implement and maintain scalable, resilient database infrastructure to support business growth and high-throughput applications.
Implement and maintain high availability (HA) and disaster recovery (DR) strategies, including clustering, Always On availability groups, logical and physical replication, backup/restore validation, and geo-redundancy. Conduct DR drills and BCP testing.
Perform database schema and object design, DDL scripting, stored procedure/function development, testing, and deployment using version-controlled pipelines. Implement routine maintenance plans including reorgs, update stats, and index optimization.
Review and optimize complex SQL and database code in Sybase, MySQL, Vertica, PostgreSQL, and MS SQL. Implement query rewrites, index tuning, and system-level tuning (buffer pool sizing, parallelism, I/O tuning) to resolve deep performance bottlenecks.
Support application developers with database analysis, ER modeling, schema changes, controlled test data setup, data masking, bulk data loads, legacy data restoration, and SQL tuning. Actively participate in code reviews and performance testing.
Collaborate on database design and optimization with development teams, including indexing strategies, execution plan analysis, and workload balancing. Recommend improvements based on and AWR-like reports.
Conduct regular database maintenance, patching, and security hardening, including encryption (at rest/in-transit), auditing, user role reviews, vulnerability scanning, and timely remediation. Lead incident response and root cause analysis for database-related outages.
Develop and maintain automation tools and scripts (e.g., in Bash, Python, PowerShell, or Ansible) to streamline database operations, backups, deployments, and monitoring tasks. Integrate with CI/CD pipelines for DevOps alignment.
Enforce best practices and execute large-scale database upgrades and migrations, including cross-platform (e.g., Solaris to Linux, Sybase to MySQL, SAP to CIS, or on-prem to cloud), version upgrades, collation changes, and data movement across heterogeneous systems. Validate with rollback strategies and cutover rehearsal.
Enforce database development and operational standards, including naming conventions, CI checks, DR documentation, and security baselines. Maintain database to compliance with industry regulations (GDPR, HIPAA, SOX) and internal audit requirements.
Technical Skills
- Proficiency in Sybase, MySQL, Vertica, PostgreSQL, and MS SQL. - Experience with performance tuning, replication, backup/recovery, and high availability. - Familiarity with cloud database platforms (AWS, Azure, GCP). - Strong scripting skills (Python, Bash, PowerShell). - Understanding of database security, compliance, and governance. Education
Bachelor’s degree in Computer Science, Information Technology, or related field. Experience
Minimum 5 years of experience with enterprise-level database environments. Preferred Attributes
Ability to work independently and collaboratively in a global team.
Strong analytical and troubleshooting skills under pressure.
Excellent communication skills in English (additional regional language skills are a plus).
Willingness to work in shifts and be available for on-call support as needed.
Salary Range
120K - 140K/yr DOE Hyve Perks
Every Day is Casual Day • Company Discounts • Community Involvement Opportunities • Profit Sharing • Medical, Dental & Vision Insurance • 401k • FSA & HSA • Paid Vacation, Holiday & Sick Days • Employee Stock Purchase Plan • Tuition Reimbursement • Live Well Work Well Program • And More The preceding job description has been designed to indicate the general nature and level of work performed by employees with this classification. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities and qualifications required of employees assigned to this job. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability or protected veteran status. Diversity and inclusion make us all better.
#J-18808-Ljbffr
Perform advanced database administration tasks for Sybase, MySQL, Vertica, PostgreSQL, and MS SQL. This includes installation, configuration, replication setup, version upgrades, patch management, performance monitoring, and advanced troubleshooting. Support both on-prem and cloud-hosted environments (AWS RDS, Azure SQL Database, Google Cloud SQL, etc.).
Forecast storage, IOPS, and compute requirements for current and future workloads. Implement and maintain scalable, resilient database infrastructure to support business growth and high-throughput applications.
Implement and maintain high availability (HA) and disaster recovery (DR) strategies, including clustering, Always On availability groups, logical and physical replication, backup/restore validation, and geo-redundancy. Conduct DR drills and BCP testing.
Perform database schema and object design, DDL scripting, stored procedure/function development, testing, and deployment using version-controlled pipelines. Implement routine maintenance plans including reorgs, update stats, and index optimization.
Review and optimize complex SQL and database code in Sybase, MySQL, Vertica, PostgreSQL, and MS SQL. Implement query rewrites, index tuning, and system-level tuning (buffer pool sizing, parallelism, I/O tuning) to resolve deep performance bottlenecks.
Support application developers with database analysis, ER modeling, schema changes, controlled test data setup, data masking, bulk data loads, legacy data restoration, and SQL tuning. Actively participate in code reviews and performance testing.
Collaborate on database design and optimization with development teams, including indexing strategies, execution plan analysis, and workload balancing. Recommend improvements based on and AWR-like reports.
Conduct regular database maintenance, patching, and security hardening, including encryption (at rest/in-transit), auditing, user role reviews, vulnerability scanning, and timely remediation. Lead incident response and root cause analysis for database-related outages.
Develop and maintain automation tools and scripts (e.g., in Bash, Python, PowerShell, or Ansible) to streamline database operations, backups, deployments, and monitoring tasks. Integrate with CI/CD pipelines for DevOps alignment.
Enforce best practices and execute large-scale database upgrades and migrations, including cross-platform (e.g., Solaris to Linux, Sybase to MySQL, SAP to CIS, or on-prem to cloud), version upgrades, collation changes, and data movement across heterogeneous systems. Validate with rollback strategies and cutover rehearsal.
Enforce database development and operational standards, including naming conventions, CI checks, DR documentation, and security baselines. Maintain database to compliance with industry regulations (GDPR, HIPAA, SOX) and internal audit requirements.
Technical Skills
- Proficiency in Sybase, MySQL, Vertica, PostgreSQL, and MS SQL. - Experience with performance tuning, replication, backup/recovery, and high availability. - Familiarity with cloud database platforms (AWS, Azure, GCP). - Strong scripting skills (Python, Bash, PowerShell). - Understanding of database security, compliance, and governance. Education
Bachelor’s degree in Computer Science, Information Technology, or related field. Experience
Minimum 5 years of experience with enterprise-level database environments. Preferred Attributes
Ability to work independently and collaboratively in a global team.
Strong analytical and troubleshooting skills under pressure.
Excellent communication skills in English (additional regional language skills are a plus).
Willingness to work in shifts and be available for on-call support as needed.
Salary Range
120K - 140K/yr DOE Hyve Perks
Every Day is Casual Day • Company Discounts • Community Involvement Opportunities • Profit Sharing • Medical, Dental & Vision Insurance • 401k • FSA & HSA • Paid Vacation, Holiday & Sick Days • Employee Stock Purchase Plan • Tuition Reimbursement • Live Well Work Well Program • And More The preceding job description has been designed to indicate the general nature and level of work performed by employees with this classification. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities and qualifications required of employees assigned to this job. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability or protected veteran status. Diversity and inclusion make us all better.
#J-18808-Ljbffr