SQL Developer

WHO WE ARE

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
• Advanced level experience developing shell scripts in large-scale enterprise database environments
• 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.