Sign up menu

SQL Developer

Orion Advisor Solutions LLC Omaha, NE
Apply

The Database Developer is responsible for the effective design, architecture, and operation of enterprise wide databases for Orion. This position will leverage SQL Server and MySQL, related engines and tuning tools. This position is responsible for identifying innovative approaches to achieving top performance in a rapid application development environment while maintaining overall database reliability and integrity.

Essential Functions of the Job

  • Assists with identifying performance bottlenecks (OS, Network, and Database), tuning of both SQL statements and RDBMS software; suggests optimal performance recommendations.

  • Writes, debugs and unit tests stored procedures and triggers.

  • Design stable, reliable and effective database objects based on customer requirements.

  • Optimize and maintain legacy systems.

  • Modify database objects according to requests and perform tests.

  • Ensure data quality and integrity in databases.

  • Liaise with developers to improve applications and establish best practices.

  • Prepare design specifications and functional documentation for assigned database projects.

  • Gather user requirements and identify new features.

  • Develop technical and training manuals.

  • Provide data management support to users.

  • Monitors databases to optimize database performance, health, resource use, and physical implementations of databases; address a variety of database integration issues including migration between disparate databases, integration, maintenance/conversion, capacity planning issues, and new applications.

  • Provides support to application developers in designing and implementing physical database structures.

  • Reviews, develops, and designs data models using standard diagramming techniques, in conjunction with application development teams; creates logical data models and translates into physical database structures that integrate with existing or proposed database structures.

  • Responds to occasional requests from Production to resolve any database related customer issues.

  • Troubleshoots, capacity plans and performs maintenance as needed.

  • Provides technical support for middleware and administration tools.

  • Participates in selection of appropriate database software and hardware products.

  • Transfers knowledge and educates team relating to any technical areas of expertise.

Skills Needed to Perform the Job

  • Proven work experience as a Database Developer.
  • In-depth understanding of data management (e.g. permissions, recovery, security and monitoring).
  • Knowledge of software development and user interface web applications.
  • Hands on experience with SQL Server with familiarity with MySQL and .Net framework a plus.
  • Familiarity with working with SQL Server and AWS tools for troubleshooting, schema management.
  • Excellent analytical and organization skills.
  • An ability to understand front-end users requirements and problem-solving attitude.
  • Familiarity with cloud services such as AWS, Google Cloud, Azure, etc.
  • Strong knowledge of database clustering, replication, as well as database modeling and design skills.
  • Strong knowledge of data dictionary and database scripting, SQL development, unit testing, and systems administration on Microsoft.
  • Familiarity with Bash and the terminal, Linux navigation.
  • Ability to work well with end users, software engineers, and managers.
  • Ability to design and implement solutions to ensure database availability and recoverability.
  • Ability to script solutions as well as a strong knowledge of Command-Line or GUI administration tools to manage change control and monitoring of systems.
  • Proven architecture skills in designing database environments for various business needs (e.g., high-availability, failover, replication, and disaster-recovery, virtual machine environment).
  • Ability to multi-task while maintaining careful attention to detail.
  • Ability to work effectively both individually and within a team environment.
  • Ability to work with a sense of urgency to meet deadlines and address competing priorities.
  • Proficient skills with Microsoft Office software including Word, Excel, PowerPoint and Outlook.
  • Effective written, listening and verbal communication skills.
  • Effective problem solving and organizational skills.

Education Needed to Perform the Job

  • Minimum of a Bachelors degree in Computer Science or related field of study required.
  • Orion Industry Certification must be obtained within 90 days of employment.

Experience Needed to Perform the Job

  • Minimum of 3 years of experience with installing, configuring, tuning and troubleshooting MySQL/Aurora in a high volume, high availability production environment required.
  • Minimum of 2 years running MySQL/Aurora in a cloud based environment preferred.
  • Previous experience with life-cycle administration support including database design, database development, testing, deployment, and maintenance required.
  • Experience with Database Optimization and Performance Tuning required.
  • Experience with architecture, set up and administration of MySQL/Aurora required.
  • Experience with database troubleshooting and failure resolution required.

*Equivalent education and experience will be considered

#LI-RA1

#LI-REMOTE

Position at Orion Advisor Technology

About Us

AsOne-Orion, we accomplish our best work by being personally accountable to each other and the clients we serve. We are creating a welcoming environment where everyone is respected, valued, and heard. Our willingness todisruptourselves, and the industry ensures we stay ahead of client expectations. Thinking differently is in our DNA weinnovate, push boundaries, reject the status quo, and relentlessly pursue transformative outcomes. It is our collective will towinthat drives Orions success and powers success for our clients and everyone at Orion.

Unique offerings include healthcare benefits start on Day 1, student loan repayment, paid parental leave, paid sabbaticals, free access to best-in-class financial planning, "PAWternity" leave, rewards and recognition, and more.

Date Posted May 3, 2022
Date Closes June 2, 2022
Requisition R430
Located In Omaha, NE
SOC Category 00-0000.00
Apply

Similar Jobs

icon
28 May ( Today )

Non-Invasive Cardio Tech

icon
28 May ( Today )

Pathologist Assistant - ASCP

icon
28 May ( Today )

Medical Lab Scientist - Molecular Lab - $10,000 Sign-On Bonus!!!