Application DBA / Data Architect - Product Delivery- CS STARS

Profile

CS STARS delivers industry-leading software and services for managing risk, claims, and insurance. With offices worldwide, CS STARS helps customers use information technology to improve business processes, manage costs and reduce risk. CS STARS is an affiliate of Marsh & McLennan Companies, Inc. (MMC), a global professional services firm with approximately 55,000 employees and annual revenues approaching $12 billion. MMC also is the parent company of Guy Carpenter, Marsh, and Mercer. MMC's stock (ticker symbol: MMC) is listed on the New York, Chicago, Pacific, and London stock exchanges. MMC's Web site address is ****CS STARS' Web site address is ****The successful candidate will exemplify Marsh's IGNITE Operating Principles, the behaviors that guide our conduct and growth - In Touch: Get out in front by being informed and being connected; Genuine: Be authentic with clients and each other; Nimble: Be flexible and move quickly to deliver quality results; Inclusive: Be open to diverse ideas, experiences and backgrounds; Trusted: Stand for integrity and ethical behavior; and Engaged: Actively participate in making Marsh extraordinary.
We’re looking for an experienced Database Application Developer
who has exceptionally strong expertise with Oracle in order to design and implement efficient large OLTP/OLAP databases for our risk management products. The candidate must work inside the context of software application and must understand the overall application development process and the application architecture. The candidate should be adept at understanding the interactions between our applications and databases and is able to recommend and design a sound application persistence layer that performs and scalable.
The candidate must be able to clearly demonstrate hands-on experience on analyzing and performance tuning large/complex Oracle databases. The candidate must demonstrate deep understanding and knowledge of Oracle database architecture and its internal workings. The ideal candidate must have the ability to thrive in a work environment that is highly collaborative and fast paced.
Responsibilities:
Participate in domain modeling, analyze domain models, build logical data models, and convert a logical data model to an efficient physical data model
Recommend and implement performance enhancements in the application persistent layer and the database, e.g. indexing, database physical characteristics like PCTFREE, PCTUSED, block size, etc. based on the requirement from applications
Analyze production database performance issues, perform query tuning and implement required enhancements
Research and design data mart/data warehouse for the analytic/reporting needs from our applications
Skill Requirements:
5 years of experience in the database application field
Thorough knowledge of Oracle database architecture and how everything works internally
Thorough knowledge and strong expertise of relational database modeling and implementations
Excellent skills in writing efficient queries to solve complex business issues.
Able to employ Oracle database diagnostic tools to collect performance data, analyze the results, localize the issue, and then recommend the fixes.
Strong expertise with OLAP
Knowledge and experience in leveraging other Oracle products, e.g. Replication, Logging/Auditing, RAC, etc.
Proven experience in implementing Data Mart/Data Warehouse
Good communication skills in both writing and verbal
Must be able to thrive in a highly collaborative and fast-paced environment
SQL Server database knowledge is a plus.
Microsoft .net platform knowledge is a plus.
To apply or if you have questions please contact: ****
Joanne Quesada
Marsh
12421 Meredith Drive
Urbandale, IA 50398
Web: ****

Company info

Sign Up Now - EmploymentCrossing.com