ABOUT THE EMPLOYER
“We are a leading technology company specializing in web data extraction and analysis. Our innovative solutions empower businesses with valuable insights derived from web data. We are seeking a skilled DBA to join our dynamic team and contribute to the development and maintenance of our web crawling infrastructure.”
WHAT WILL YOU WORK ON?
- Ensure availability and performance of the databases that support Trackstreet online services and business operations (e.g. system monitoring, performance tuning, routine maintenance tasks, etc.)
- Perform capacity planning to properly identify required hardware, software, database configuration/architect necessary to support application needs.
- Enforce best practices for improving performance, scalability and operational manageability of production databases.
- Create and perform database and system maintenance policy and procedures.
- Perform and document disaster recovery functions.
- Work with development team to coordinate new data development ensuring consistency and integration.
- Work with Database Analyst to optimize all database objects, stored procedures, tables, views, triggers, indexes, user-defined functions and SSIS packages.
- Knowledge of Policy Management, Resource Governor and dynamic management views
- Part of on-call rotation to respond to and resolve database issues to ensure production applications are online
WHAT SKILLS AND EXPERIENCE ARE WE LOOKING FOR?
- At least 5 years’ hands-on experience supporting multi-tenant database systems in a high-availability and high-volume environment.
- Experience supporting PostgreSQL systems in cloud or data center environments.
- Experience with YellowBrick +++ l DataBrick or similar big data platforms
- Experience with SnowFlake +
- Experience with BigQuery +
- Detailed understanding of PostgreSQL architecture and internals.
- At least 3 years’ experience working in a DevOps/SRE environment.
- Experience with cloud providers such as AWS, Azure, or GCP, especially working with virtual machines in AWS or GCP.
- Experience with cloud-native database systems such as AWS RDS, GCP CloudSQL, etc.
- Experience and strong understanding of database structures, data modeling, database schema design, database administration, best-practices.
- Experience supporting, monitoring, and configuring Linux environments for database systems.
- Experience with Infrastructure-as-Code systems, preferably Terraform.
- Experience with NoSQL databases such as MongoDB, Redis, ElasticSearch, or DynamoDB.
- Hands on experience with MySQL Server
- Experience designing and maintaining systems for HIPAA, HITRUST, or other Cybersecurity Framework
ARE THERE ANY OTHER REQUIREMENTS?
- Conversational level of English (the team is US-based)
- At least 3 hours of overlap with the US timezones
To apply to this position, please reach out by email kate@hiretruss.staging.getciville.com or telegram @ejunina