SQL Developer

Posted Sep 29

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.

SUMMARY/OBJECTIVE OF THE JOB:

The SQL Developer's primary focus will be to optimize queries for Aurora MySQL on AWS to improve performance. This position plays a critical role in ensuring the performance and efficiency of production database systems.

DUTIES AND RESPONSIBILITIES:

  • Identify and resolve performance issues in Aurora MySQL post-migration from SQL server
  • Analyze and rewrite stored procedures to improve performance
  • Monitor performance metrics of the Amazon Aurora cluster using Amazon RDS Performance Insights and Amazon CloudWatch to identify performance bottlenecks and proactively tune
  • Analyze slow queries, prioritizing frequently run and long-running queries
  • Use wait event data and thread state data specific to Aurora MySQL to determine where sessions are spending time and identify performance problems.
  • Collaborate with application development teams on schema and data types for performance improvement.
  • Provide recommendations and implement responsible production updates to minimize downtime, considering different trade-offs due to the DB integration with various applications.
  • Be a technical team advocate, ensuring clear direction and efficient execution
  • 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
  • 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.
  • Proven expertise in MySQL performance tuning and optimization.
  • Experience with Aurora MySQL and AWS environment.
  • Familiarity with Microsoft SQL server, although direct work with SQL servers is not required.
  • Experience with automated schema and data type changes using tools like Liquibase.
  • AWS Associate and/or Professional Level Certification
  • 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.