SQL Developer

4 weeks ago

Remote, United States Trek10 Full time

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.



  • SQL Developer

    2 weeks ago

    Remote, Oregon, United States TEKsystems Full time

    Job SummaryWe are seeking a skilled SQL Developer to join our team at TEKsystems. As a SQL Developer, you will be responsible for designing, implementing, and maintaining databases using Microsoft SQL Server.Key ResponsibilitiesDesign and develop database structures, including tables, views, and stored procedures.Write and optimize SQL queries to ensure...

  • SQL Developer

    3 weeks ago

    Remote, United States TEKsystems Full time

    Job DescriptionJob DescriptionTop Skills' Details1. SQL Development- 5-7 years experience2. Stored procedures, triggers, Vue3. Culture- Must be able to work remotely, staying focused and being a team player. Job DescriptionThis non-profit is looking for a SQL developer who will be responsible for writing and maintaining stored procedures and views in a...

  • SQL Server Developer

    3 weeks ago

    Remote, Oregon, United States External Full time

    Job DescriptionFull Employment OpportunityThis is a full-time position that requires a strong background in SQL Server development and analysis. The ideal candidate will have experience working with SQL Server and be able to design, implement, and maintain databases.Local Candidates OnlyThis position is only open to local candidates. We do not consider...

  • SQl Server Analyst, Developer

    4 weeks ago

    remote, United States External Full time

    THIS IS A FULL EMPLOYMENT POSITIONLOCAL CANDIDATES ONY, NON LOCAL APPLICATIONS WILL NOT BE CONSIDERED. NO RELOCATION AVAILABLEMUST BE A GREENCARD OR US CITIZEN, NO SPONSORSHIP AVAILABLE THIS IS ALSO AN ONSITE POSITION, NO HYBRID OR REMOTE OPTION SHIFT WORK IS ALSO AVAILABLETHIS IS MORE OF A JUNIOR MIDLEVEL TYPE ROLE AS A SQL SERVER ANALYST WITH DEVELOPMENT...

  • Senior Database Developer

    3 days ago

    Remote, Oregon, United States TEKsystems Full time

    Job OverviewWe are seeking a skilled Senior Database Developer to join our team at TEKsystems. As a key member of our database team, you will be responsible for designing, implementing, and maintaining our Microsoft SQL Server database systems.Key Responsibilities:Design and implement database tables and structures to meet business requirementsDevelop and...

  • Senior Full Stack Developer

    4 days ago

    Remote, Oregon, United States COGNITIVE MEDICAL SYSTEMS INC Full time

    Job Title: Mid-Level Full Stack DeveloperCognitive Medical Systems Inc is seeking a highly skilled Mid-Level Full Stack Developer to join our team. As a key member of our development team, you will be responsible for designing, developing, and maintaining our software applications.Key Responsibilities:Design and develop software applications using Angular,...

  • Java Lead Developer

    2 weeks ago

    Remote, United States Softcom Systems Inc Full time

    Job DescriptionJob DescriptionHi  ,Hope you are doing well. We are Looking for Java Lead- Remote- Contract for one of our clients. Below are the job descriptions for this positions. Have a look and let me know if you are interested.       Please attach your updated Resume  Job Title: Java LeadJob Location: RemoteRole: ContractMust have: Java...

  • Java Lead Developer

    2 weeks ago

    Remote, Oregon, United States Softcom Systems Inc Full time

    Job Title: Java LeadWe are seeking a highly skilled Java Lead to join our team at Softcom Systems Inc. The ideal candidate will have extensive experience in Java development, with a strong focus on Spring Boot Microservices and Loyalty (Crowdtwist) experience.Key Responsibilities:Proven expertise in Java development with a strong focus on Spring Boot...

  • Senior Azure Solution Developer

    2 months ago

    Remote, United States NeoGenomics Full time

    Description Are you motivated to participate in a dynamic, multi-tasking environment? Do you want to join a company that invests in its employees? Are you seeking a position where you can use your skills while continuing to be challenged and learn? Then we encourage you to dive deeper into this opportunity. We believe in career development and...

  • Senior Java Developer

    4 days ago

    Remote, Oregon, United States TEKsystems Full time

    Job SummaryTEKsystems is seeking a highly skilled Java Web Development Expert to support the migration of a critical application from Struts 1 to Struts 2. The ideal candidate will have extensive knowledge of Java 6 and Java 8, as well as experience working with n-tier architectures and strong Java Web Development experience.Key Responsibilities:Participate...

  • Business Intelligence Developer

    3 weeks ago

    Remote, Oregon, United States Symbotic Full time

    About the RoleWe are seeking a highly skilled Business Intelligence Developer to join our team at Symbotic. As a key member of our Customer Success team, you will be responsible for designing, developing, and maintaining Qlik Sense applications to support business intelligence and data visualization needs.Key ResponsibilitiesCollaborate with cross-functional...

  • Senior Java Developer

    2 weeks ago

    Remote, Oregon, United States TEKsystems Full time

    Job DescriptionTEKsystems is seeking a highly skilled Senior Java Developer to join their fast-paced software development team. As a key member of the team, you will be responsible for assisting in software development and maintenance of the current product suite by participating actively in all phases of the software development lifecycle.Key...

  • Senior Azure Solution Developer

    1 month ago

    Remote, Oregon, United States NeoGenomics Full time

    Senior Azure Solution DeveloperWe are seeking a highly skilled Senior Azure Solution Developer to join our team at NeoGenomics. As a key member of our technology team, you will be responsible for designing, developing, and maintaining innovative cloud-based solutions using Microsoft's Azure platform.Key Responsibilities:Design and develop software systems...

  • Senior .Net Full Stack Developer

    3 weeks ago

    Remote, United States Horizon Resource Services Full time

    Job DescriptionJob DescriptionOverview: Senior Net Full Stack DeveloperWork Location: Remote Overview: Eagle Harbor Solutions, a Koniag Government Services company, is seeking a .Net Full Stack Developer to join a development team supporting both established projects and building applications from the ground up. The ideal candidate is a team player that is...

  • Data Warehouse Developer, Senior

    2 months ago

    Remote, United States Percepta Full time

    SENIOR DATA WAREHOUSE DEVELOPER At Percepta, we bring first-class service across each market we support. As a Senior Data Warehouse Developer working remotely, you'll be a part of creating and delivering amazing customer experiences, while also enjoying the satisfaction of being part of a unique culture What You'll Be Doing The Senior Data Warehouse...

  • Senior Java Developer

    1 month ago

    Remote, United States TEKsystems Full time

    Job DescriptionJob Description***CITIZENS ONLY for this position*** cannot accept visa candidates or GC-EAD, unfortunately. Please contact Emily Hendrixson to be submitted to this opportunity at ehendrix@teksystems.com | M: (402) 319-6001 | https://www.linkedin.com/in/emily-hendrixson-92a84082/ 100% Remote PositionSenior Java DeveloperTop Skills...

  • Senior Java Developer

    3 weeks ago

    Remote, United States TEKsystems Full time

    Job DescriptionJob Description***CITIZENS ONLY for this position*** cannot accept visa candidates or GC-EAD, unfortunately. Please contact Emily Hendrixson to be submitted to this opportunity at ehendrix@teksystems.com | M: (402) 319-6001 | https://www.linkedin.com/in/emily-hendrixson-92a84082/ 100% Remote PositionSenior Java DeveloperTop Skills...

  • Oracle Utilities Developer

    3 weeks ago

    Washington/remote 100%, United States Expedite Technology Solutions Full time

    Technical Skills :Oracle Utilities Work and Asset Management: P4 - ExpertLinux Shell Scripting: P3 - AdvancedPro*C Programming Language: P3 - AdvancedRole Description :Ideal candidate is a strong SME on Oracle Utilities billing component v1.6.x, comfortable with reading and debugging customization code written in Rules Lang, and able to develop enhancements...

  • Data Entry Specialist

    4 weeks ago

    Remote, Oregon, United States Recruit Monitor Full time

    About the JobWe are seeking a highly skilled Data Entry Salesperson to join our team at Recruit Monitor. This is a remote opportunity based in the United States.Key ResponsibilitiesGenerate new, modify existing, and execute ad-hoc reporting to support business processes and data-driven decision making.Develop and maintain powerful data quality standards and...

  • Data Entry Specialist

    2 weeks ago

    Remote, Oregon, United States Recruit Monitor Full time

    About the JobWe are seeking a highly skilled Data Entry Salesperson to join our team at Recruit Monitor. As a Data Entry Salesperson, you will play a critical role in supporting our business operations by generating and maintaining reports, and providing departmental knowledge on performance and data analysis.Key ResponsibilitiesGenerate new, tweak existing,...