The Enlyte Family of Businesses

Mitchell | Genex | Coventry

Enlyte is the parent brand of Mitchell, Genex and Coventry, an organization unlike any other in the Property & Casualty industry, bringing together three great businesses with a shared vision of using technology innovation, clinical services and network solutions to help our customers and the people they serve. Our suite of products and services enable our employees to help people recover from challenging life events, while providing opportunities for meaningful impact and career growth.

Must be willing to work in PST time zone for at least 8:30 AM to 5 PM PST.

The Principal Database/BI Report Developer will be responsible for the analysis, design, validation, and implementation of enterprise-wide database development including data modeling, ETL, and Performance tuning In Oracle/PostgreSQL/SQL Server with exposure to reporting tools like Tableau, SSRS, and SSAS.

Duties and Responsibilities:

• Follows policies and procedures for the definition, management, protection, and efficient utilization of data and databases.
• Performs database development and management activities in a safe, recoverable and professional manner that ensures the optimal operation of all database environments.
• Establishes database management systems, standards, guidelines and quality assurance for database deliverables, such as conceptual design, logical database, capacity planning, external data interface specification, data loading plan, data maintenance plan and security policy.
• Documents and communicates database design.
• Evaluates and installs database management systems.
• Codes complex programs and derives logical processes on technical platforms.
• Builds windows, screens and reports.
• Assists in the design of user interface and business application prototypes.
• Participates in quality assurance and develops test application code in client server environment.
• Provides expertise in devising, negotiating and defending the tables and fields provided in the database.
• Adapts business requirements, developed by modeling/development staff and systems engineers, and develops the data, database specifications, and table and element attributes for an application.
• At more experienced levels, helps to develop an understanding of client's original data and storage mechanisms.
• Determines appropriateness of data for storage and optimum storage organization.
• Determines how tables relate to each other and how fields interact within the tables for a relational model.
• Stays apprised of changes and innovations in Oracle's information technology space, including new features, bug/fixes and compatibility concerns with operating systems and utilities.
• Actively participates in the implementation of disaster recovery and fail-over capability, and maintains detailed technical support documentation.
• Performs capacity monitoring; and short and long-term capacity planning in collaboration with development resources, system administrators and system architects.
• Exploits RDMS software, database management tools and utilities, data warehouse and replication techniques to implement requirements to enhance our database solutions.
• Maintains security commensurate with legal regulations, corporate policy, and best practices while implementing security solutions that balance auditor requirements with user requirements.
• Participates in 24x7 on-call rotation.

• Bachelor's degree in Computer Science or Information Systems, or related equivalent experience and two plus year's professional experience in database administration and software systems development.
• A minimum of 10 years related I.T. experience.
• Extensive experience in migrating from an On-prem DB to AWS.
• AWS Certification is a plus.
• Extensive technical knowledge and experience in database management techniques including physical database optimization, data distribution, database performance monitoring and data governance.
• Comprehensive experience with BI stack/methodologies, Dimensional modelling.
• Knowledge and awareness of networking issues pertaining to database design, optimization, and implementation within client server and web architecture.
• Proficient in support duties such as performance tuning, monitoring, backup, recovery, and security.
• Proficient with SQL, PL/SQL, Shell scripting.
• Strong analytical and organizational skills, oral and written communications skills, problem solving and critical thinking skills.
• Ability to meet deadlines and be flexible, work independently or as part of a team, and ability to self-motivate and be proactive.
• Ability to mentor junior staff members of the team.
• Ability to drive data base/data governance strategies and implementation across the enterprise.

PI239468809