Data Base Architect / Developer (bi-lingual Portugues/English)
Inbenta is a global technology company headquartered in Allen, Texas with offices and team members around the world. We develop an Automatic Language Processing (or Natural Language Processing – NLP) engine, which provides answers to human intentions formulated in natural language. Based on our proprietary and patented technology, Inbenta builds a set of conversational solutions for businesses such as chatbots, knowledge management tools, digital demos, and search engines. Our customers include many global blue-chip companies in Banking, Insurance, Automotive, Services, Retail, Transportation, and other sectors.
Job Summary
The Data Base Architect is responsible for is responsible for designing data infrastructure to extract and organize data for authorized individuals to access by collaborating with department heads to determine the data storage and organizational needs and using the information to create and maintain data infrastructure.
Responsibilities
Manage our MySQL databases on RDS and Aurora in AWS, ensuring high availability, optimal performance, and data security.
Responsible for all aspects of maintaining Inbenta’s MySQL instances.
Perform performance tuning to optimize database performance, including query optimization, index creation, and database parameter adjustments.
Extensive experience in managing databases on clustered Aurora environments, including configuration, performance optimization, and troubleshooting.
Apply automation and software to streamline manual tasks.
Monitor production and non-production database environments daily, including health, performance, storage, backups, ETL, and workflow processes.
Participate in schema design, implementation, and data migration across large MySQL databases.
Collaborate on database releases and execute related deployments.
Contribute to end-to-end solutions emphasizing performance, high availability, and growth needs.
Create tools and automation to improve database administration and management efficiency.
Participate in R&D projects to enhance database infrastructure security, performance, manageability, and availability.
Proactively identify, diagnose, and solve complex security issues.
Work directly with Amazon as needed to resolve issues and collaborate on improving our infrastructure related to database.
Requirements
Bachelor's or master's degree in computer science, Engineering, or a related field can be forgiven in leu of experience
10+ years of experience in administering MySQL/PostgreSQL/Aurora databases in both production and non-production environments.
Knowledge and experience in using AWS cloud services, particularly RDS/Aurora/Snowflake.
Proficient in SQL language and query optimization.
Ability to write code in Python or Bash scripting to automate tasks and processes.
Familiar with AWS command line tooling.
Strong skills in Linux system administration.
*Applying to this job offer you authorize us to process your personal data with the only purpose of the job offer recruitment, according to our Applicant Privacy Policy.