Job Title: SingleStore DBA
Location: Austin TX Onsite
Contract Role
Job Description:
We are looking for a SingleStore DBA with Python Programming. He/She will be responsible for managing and maintaining our SingleStore database environment. This includes database performance tuning, monitoring, backup and recovery, and ensuring data integrity and security. The ideal candidate will have a solid background in database administration, particularly with SingleStore, and will use their Python programming skills to develop scripts and tools to automate routine tasks and improve database efficiency. Key Responsibilities:
Skills Set:
- SQL
- Jnix Shell scripting
- Jnix/Bash
- Amazon Web Services (AWS)
- MemSQL
- Amazon Web Services S3 (AWS S3)
- SingleStore
- Columnar DB
- Git
- Linux
- Linux Administration
- PL/SQL
- Python
Nice To Have:
- Vertica
- Snowfiake
- MySQL
Roles & Responsibilities:
- Install, configure, and maintain SingleStore database systems.
- Monitor database performance, implement performance tuning, and optimize queries.
- Ensure high availability and disaster recovery of database systems.
- Develop, test, and deploy backup and recovery plans.
- Implement and maintain database security policies and procedures.
- Create and maintain database documentation, including data models, schemas, and procedures.
- Develop Python scripts to automate database management tasks and enhance operational efficiency.
- Troubleshoot and resolve database-related issues and provide support to development teams.
- Collaborate with other IT professionals and stakeholders to ensure seamless integration of database systems with other applications.
- Stay updated with the latest industry trends and best practices in database management and Python programming. Qualifications:
- Bachelor's degree in Computer Science, Information Technology, or a related field.
- Proven experience as a Database Administrator, specifically with SingleStore.
- Strong proficiency in Python programming, with experience in writing scripts for database management and automation. * In-depth knowledge of database performance tuning, query optimization, and troubleshooting.
- Experience with database backup and recovery procedures.
- Familiarity with database security best practices.
- Excellent problem-solving skills and attention to detail.
- Strong communication and collaboration skills.
- Ability to work independently and manage multiple tasks effectively. Preferred Qualifications:
- Experience with other RDBMS database systems (e.g., Vertica, MySQL, Oracle).
- Familiarity with cloud-based database solutions and infrastructure (e.g., AWS).
- Experience with managing Distributed databases.
- Experience with DevOps tools and practices.
- Knowledge of data warehousing and ETL processes:
Shivi Sharma| Talent Acquisition Specialist
Amaze Systems Inc
USA: 8951 Cypress Waters Blvd, Suite 160, Dallas, TX 75019
Canada: 55 York Street, Suite 401, Toronto, ON M5J 1R7
D: +1 (469) 606-0367
E: shivi.s@amaze-systems.com | www.amaze-systems.com/
USA | Canada | UK | India
Amaze Systems is an Equal Opportunity Employer (EOE), and does not discriminate based on age, gender, religion, disability, marital status, race and also adheres to laws relating to non-discrimination on the basis of national origin and citizenship status.
—
—