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.
*Equivalent education and experience will be considered
Position at Orion Advisor Technology
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|
|Located In||Omaha, NE|