Principal Database Engineer

Mitchell International

Principal Database Engineer

US Remote

Job ID : 24-16783

Type : Regular Full-Time

of Openings : 1

Category : Software Development

Mitchell International, Inc.

Overview

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.

Responsibilities

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.

Qualifications

• 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.

Benefits

We're committed to supporting your ultimate well-being through our total compensation package offerings that support your health, wealth and self.

These offerings include Medical, Dental, Vision, Health Savings Accounts / Flexible Spending Accounts, Life and AD&D Insurance, 401(k), Tuition Reimbursement, and an array of resources that encourage a lifetime of healthier living.

Benefits eligibility may differ depending on full-time or part-time status. Compensation depends on the applicable US geographic market.

The expected base pay for this position ranges from $107,089 - $150,000 annually and will be based on a number ofadditional factors, including skills, experience, and education.

The Company is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, religion, color, national origin, gender, gender identity, sexual orientation, age, status as a protected veteran, among other things, or status as a qualified individual with disability.

Don't meet every single requirement? Studies have shown that women and underrepresented minorities are less likely to apply to jobs unless they meet every single qualification.

We are dedicated to building a diverse, inclusive, and authentic workplace, so if you're excited about this role but your past experience doesn't align perfectly with every qualification in the job description, we encourage you to apply anyway.

You may be just the right candidate for this or other roles.#LI-FP1#LI-Remote

Salary : $107089 - $150000 annually

Please see job description

PI240805115