Database Administrator (DBA)
Health Care that Starts with You!
Join a truly mission-driven organization! Independent, nonprofit UCare is recognized as one of the Minnesota's leading health plans. We provide more than 225,000 members across Minnesota and western Wisconsin with the health coverage plans and services they need to maintain and improve their health. The innovative coverage we create makes a difference for Medicare-eligible individuals, individuals and families enrolled in Minnesota Health Care Programs, such as MinnesotaCare and Medical Assistance, and disabled adults with special health care needs. UCare is growing in size, membership, products, geographic coverage, and employees. We're an organization that's going places. Be part of a team that cares about you, be part of UCare.
ABOUT UCAREAt UCare, we deliver high-quality health coverage and services to help members of all ages maintain and improve their health. It's a big job that takes innovative ideas, strategic partnerships, and a commitment to doing the right thing. Above all, it takes a compassionate team that is dedicated to making a real difference in the lives of our members and our communities.WORKING AT UCAREWorking at UCare is more than just a career; it's a mission. A mission that defines us as professionals, unites us as an organization, and shapes how we interact with our members and each other. Our values of integrity, community, quality, flexibility, and respect permeate every aspect of our organization - from who we are and how we act, to what we do and how we do it. We owe our continued success to our employees who proudly embody our mission and values in everything they do. DATABASE ADMINISTRATOR (DBA) Position DescriptionThis position is responsible for all functions associated with the efficient design, implementation and maintenance of Oracle/SQL databases. Oracle experience is a must for this position. Analyzes business application requirements and develops specifications for database construction and maintenance. Also responsible for database modeling, normalization, and vendor interfaces. Maintain and document all production databases and interface systems and resolves database performance problems. This position interacts with many constituencies to develop database solutions to business problems. This position is also responsible for the design and building of tables, relationships, stored procedures and triggers.·Plan and coordinate the activities related to running production environments utilizing Oracle databases.·Creates and maintains all databases required for development, testing, education and production usage.·Perform ongoing tuning of the database instances, plan and implement backup and recovery of the Oracle databases.·Controls migrations of programs, database changes, reference data changes and menu changes through the development cycle.·Implement and enforce security for all of the Oracle databases·Performs database re-organizations as required to assist performance and ensure maximum uptime of the database.·Puts standards in place to ensure that all application design and code is produced with proper integrity, security and performance. The DBA will perform reviews on the design and code frequently to ensure the site standards are being adhered to.·Administers all database objects, including tables, clusters, indexes, views, sequences, packages and procedures.·Install, configure, trouble-shoot Oracle/SQL database and Oracle Application systems in Windows, HP-UX and Linux servers.·Plan and coordinate the development of test and training and project related database environments. ·Plan and design database physical structure to accommodate large transaction volume and high availability. ·Collaborate with developers to implement SSIS packages, Stored Procedures and Triggers. ·Provide solutions for database sizing and capacity planning, server requirements and space requirements. ·Collaborate with System Engineers group to design, implement and test enterprise backup and recovery solution, including Disaster Recovery initiatives.·Collaborate with the Application Development and Systems Engineer groups to implement/integrate Active Directory, LDAP and/or DHCP solutions. ·Collaborate with the Networks Services and Applications Development groups to ensure the platforms are robust enough to support the needs of the databases. ·Upgrade and patch databases and systems as requested. ·Perform database mirroring, replication and support data loading, conversion and batch job operation and do trouble-shooting of development/production system. ·Recommend, schedule, and perform software improvements and upgrades.·Other projects and duties as assigned.
Bachelor's degree in Computer Science preferred; demonstrated experience may be considered in lieu of degree.Required Experience Five or more years of Database administration experience in Oracle and SQL Server. Experience in managing and tuning large volume Oracle and SQL Server databases. Experience in setting up SQL Server Replication. Experience in managing SQL Server 2008 R2 and SQL Server 2012. Experience in managing Oracle 11g database. Experience in setting up and managing SQL Server partitioning. Experience in deploying SSIS packages and SSRS reports. Experience with Oracle Grid and Management Studio. Experience in database performance tuning. Experience in tuning SQL statements. Knowledge of SSAS, Cubes and data warehouse environments. Experience upgrading SQL server databases to Virtual environments.
Experience working in healthcare. Experience working on Oracle Financials.THE UCARE DIFFERENCEUCare is proud to be a recognized Star Tribune Top Workplace for the 7th consecutive year. As a part of our collaborative team, you'll experience the rewards that come with helping others and seeing the positive results of your hard work. We value and respect each individual's ideas and contributions, and give you the freedom to grow both personally and professionally. We are centrally located, and offer onsite education, equipment and wellness resources, a myriad of volunteer activities, and a number of other rewards. If you're looking for a welcoming environment that celebrates what you have to offer, helps you build on your strengths, and gives you the opportunity to truly make a difference, we invite you to apply. As an Equal Opportunity/Affirmative Action Employer, we welcome and employ a diverse employee group committed to meeting the needs of UCare, our members, and the communities we serve.
Enter a highly collaborative environment where people are truly engaged, and feedback is valued. You'll enjoy a competitive salary and benefits, as well as a host of other perks, including a nationally recognized wellness program, and a bright, open, award-winning office space in Northeast Minneapolis just minutes from major freeways and retail centers.
At UCare, we welcome and employ a diverse employee group committed to meeting the needs of UCare, our members, and the communities we serve.