Database Administrator
Orion Advisor Services, LLC - Omaha, NE

This job posting is no longer available on NorthStar Financial Services Group, LLC. Find similar jobs: Database Administrator jobs - Orion Advisor Services jobs

The Database Administrator is responsible for the effective design, architecture, and operation of enterprise wide databases for Orion Advisor Services, LLC ("OAS"), a wholly owned subsidiary of NorthStar Financial Services Group, LLC ("NorthStar"). This position will leverage Microsoft SQL Server, related reporting 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:
· Support databases as a DBA including creating databases, administrating security, resolve and troubleshoot database issues, oversee and perform upgrades, conversions and deployments
· Provide support to application developers in designing and implementing physical database structures
· Use DBCC procedures to monitor the health of databases, tables and indexes to maintain database integrity of all production and in house databases
· Respond to occasional requests from Production to resolve any database related customer issues
· Maintain user connectivity while providing security to protect company data
· Write, debug and unit test stored procedures and triggers
· Ability to troubleshoot, capacity plan and performance maintenance
· Monitor server and database performance and health
· Create, rotate, and integrate related database backups based on the business needs by having thorough knowledge of the database software recovery mechanisms
· Assist with identifying performance bottlenecks (OS, Network, and Database), tuning of both SQL statements and the RDBMS software, and have the knowledge to recommend optimal performance recommendations
· Ability to configure and tune MS SQL Server on Windows Servers for maximum uptime and performance
· Ability to tune and load-balance clustered SQL Servers
· Implement and maintain database security, Replication, SQL Clustering, Standby Server, DTS, Log Shipping, and SQL Mail
· Monitor databases to optimize database performance, 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
· Install, configure, tune and troubleshoot MS SQL Server
· Participate in the selection of appropriate database software and hardware products
· Provide technical support for middleware and administration tools
· Participate in the transfer of knowledge and the education of staff relating to any technical areas of expertise
· Review, develop, and design data models using standard diagramming techniques, in conjunction with application development teams; create logical data models and translate into physical database structures that integrate with existing or proposed database structures

Knowledge/Skills:
· Proficient with Microsoft Office software including Word, Excel, and Outlook
· Good oral and written communication skills
· Effective problem solving skills
· Careful attention to detail
· Ability to work effectively both individually and within a team environment
· Ability to work well with users, software engineers, and managers
· Ability to reach goals and deadlines
· Strong database modeling and design skills
· Strong familiarity with database clustering, replication, and log shipping
· Proven architecture skills in designing database environments for various business needs (e.g., high-availability, failover, replication, and disaster-recovery)
· Strong knowledge of data dictionary and database scripting, SQL development, unit testing, and systems administration on Microsoft.
· Ability to design and implement solutions to ensure database availability and recoverability
· Ability to script solutions as well as a strong knowledge of the GUI administration tools to manage change control and monitoring of the systems
· Ability to troubleshoot and

Education*:
· Bachelor’s degree in Computer science or related field of study, or equivalent experience

Experience*:
· At least three years of experience with installing, configuring, tuning and troubleshooting MS SQL Server in a high volume, high availability production environment
· At least two years running MS SQL Server in an MS Cluster environment
· 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 MS SQL Server
· Experience with database troubleshooting and failure resolution required

*Equivalent education and experience will be considered.

Conformance Statement:
The above statements are intended to describe the general nature and level of work being performed by individuals assigned to this position. They are not intended to be an exhaustive list of all duties, responsibilities and skills required.

Working Conditions/Equipment/Safety:
Normally works in a general office environment with the use of computer, printer, telephone, copier, fax, and

NorthStar Financial Services Group, LLC - 18 months ago - save job - block