Trek10 builds and manages massively scalable cloud architectures using cutting edge AWS technologies. Headquartered in South Bend, IN, we have a local footprint but operate with a global reach. Today we have customers on four continents and from coast to coast in the United States and a global brand for deep expertise. We are a Premier Tier AWS Consulting Partner with the following AWS Partner Competencies: DevOps, Migration, IoT, Data and Analytics, and SaaS. We have a focus on designing and building serverless / cloud native and IoT systems, DevOps automation, and providing 24/7 AWS infrastructure support. We are pioneering the future of cloud computing and having a lot of fun while we do it!
To better understand the type of cutting edge work we do for our clients, please take a look at some of our case studies.
The SQL Developer will design, develop, and maintain SQL databases ensuring their performance, availability, and security.
Duties And Responsibilities
Optimize database systems for SQL performance and scalability, tuning and query optimization specifically with MySQL on Amazon Aurora RDS
Deploy SQL as Code including schema changes and data migrations, for example, with versioned DB scripts, Redgate SQL Compare, Liquibase, or similar tooling
Troubleshoot and deep dive into SQL query execution plans
Write and troubleshoot complex SQL queries, stored procedures, and triggers.
Refactor, test and optimize complex SQL queries
Responsible for everything in database engineering, from writing SQL queries to knowing database internals and optimizing hardware and network attributes for RDS.
Learn, coach, and share knowledge and skills with other Trek10 team members
Lead re-platforming and refactoring efforts for existing systems
Own the implementation of stories and other engineering of advanced cloud work for clients
Perform research and documentation for problems and potential solutions
Be a technical team advocate, ensuring clear direction and efficient execution
Hands-on involvement in the development of projects. Enforces standards, procedures, and methodologies for the software development life cycle.
Participate in cross-functional implementation teams to deliver solutions to clients
Prepare work for team members of varying levels of experience, defining stories and task type work
Contribute to internal IP and open source development
Participate in delivery efforts using Agile or other work methodologies
Build relationships with vendors and partners
Engage with clients including presentations, technical decisions, and education opportunities
Learn, research, and stay up to date on best practices and evolutionary capability in the Amazon Web Services (AWS) cloud
Share knowledge and skills with other Trek10 team members and client teams
Write cool blog posts, do talks at community events, help us achieve additional certifications in the AWS Partner Community, help our clients solve all sorts of problems
Occasional travel may be required to meet stakeholders, kick off new projects, attend conferences, and attend company functions.
Other duties as assigned
Required Qualifications
6+ years of general IT experience (programming, hardware, software, etc)
3+ years of experience with Amazon Web Services
3+ years experience with AWS Cloud database services including Aurora RDS Native patterns with services like AWS Lambda
1+ year code-defined infrastructure experience
1+ Continuous Integration and Deliver (CI/CD) experience
Have worked with Agile Project Management or other project management work methodologies.
Preferred Qualifications
Bachelor's degree in Information Technology, Computer Science, or a related field.
AWS Associate and/or Professional Level Certification
3 years experience architecting and building scalable, automated infrastructure
3+ years of database query development utilizing MySQL, SQL dialect and Microsoft T-SQL
In-depth knowledge of indexes, query instrumentation and execution time improvement
Familiarity with application level programming languages desirable, such as Python, Node.js, C# or Java. , Node.js
Intermediate experience building scalable, automated infrastructure
Intermediate experience working in a consultative, client-facing consulting role
Able to demonstrate effective verbal and written communication skills
Demonstrated documentation and presentation skills
Competencies
Communication: The ability to effectively convey information, ideas, and instructions to individuals or groups, both verbally and in writing.
Time Management: The ability to effectively plan and organize one's own time in order to meet deadlines, prioritize tasks, and make the most efficient use of time.
Self Management: The ability to manage one's own emotions, thoughts, and behavior in different situations.
Building Work Relationships: The ability to establish and maintain positive and productive relationships with colleagues, clients, and other stakeholders.
Problem Analysis: The ability to identify, understand, and analyze problems in order to find solutions.
Technical expertise: The ability to understand, apply, and stay current with the knowledge, concepts, and practices in a specific field or industry.
Planning: The ability to set goals, develop action plans, and effectively allocate resources in order to achieve desired outcomes.
Benefits
We are a remote-first company with a lot of flexibility!
Medical, dental and company paid vision and telemedicine; Insurance that start on day one of your employment!
401k plan with a healthy company match.
Vacation and unlimited sick time.
Company paid short-term disability and long-term disability.
9 company paid holidays.
Monthly Employee Care stipend to spend on YOU!
Annual home office set up and equipment allowance.
Have fun! We get together at various locations across the US for team retreats!
Robust training and continuous learning environment with lots of team support!
Develop a skill set that will set you up for long term professional growth and development!
Get paid (of course)! We have competitive salaries!
We are committed to providing equal employment opportunities to all persons regardless of race, color, ancestry, citizenship, national origin, religion, veteran status, disability, genetic characteristic or information, age, gender, sexual orientation, gender identity, marital status, family status, pregnancy, or other legally protected status (collectively, “protected statuses”). We do not tolerate unlawful discrimination in any employment decisions, including recruiting, hiring, compensation, promotion, benefits, discipline, termination, job assignments or training.
Trek10 participates in E-Verify. All persons hired will be required to verify identity and eligibility to work in the United States and to complete the required employment eligibility verification form upon hire. We are unable to sponsor or take over sponsorship of an employment Visa at this time.
Seniority level
Mid-Senior level
Employment type
Full-time
Job function
Information Technology
Industries
IT Services and IT Consulting
Referrals increase your chances of interviewing at Trek10, Inc. by 2x