Database Administration Specialist

Company: Clark Insurance
Location: Houston
Posted on: September 18, 2023

Job Description:

Company:MMC CorporateDescription:Marsh McLennan (MMC) Database Services are growing at fast pace and currently have an opportunity for a creative and inquisitive Database Administrator (Oracle/MSSQL). This role is hybrid.The candidate for the following position is based in the US office:Database Administrator (Oracle/MSSQL)What can you expect?* We are a large team who together, across the AUS, UK, Canada, Mexico & US, are responsible for significant databases & projects related to our Oracle/MSSQL environment.* We are offering an emerging and varied role, with a stimulating range of duties and responsibilities, designing strategies for our Enterprise Database Systems and setting standards for operations, programming, and security, using ETL architecture standards.* We are moving to an automation first approach, so welcome your entrepreneurial, inquisitive nature, to research & present new, replacement tech that will contribute to defining, maintaining, and strengthening the database strategy, service offerings and support of this critical department.* Our Database Services team are Global, this role could be based remotely, out of any of our US office locations, with a degree of remote working also available.* Export and Import data with Exp & Imp and EXPDP/IMPDP utilities, Experience in scheduling and troubleshooting jobs via Control-M tool; Create and monitoring table space / storage requirements, Perform online redefinitions on table to remove fragmentation; Create and managing database objects like tables, views, and indexes, partitions.* Create profiles and attaching them with users and monitoring the users. Proficiency in database security and audit requirements.* Export and Import data with Exp & Imp and EXPDP/IMPDP utilities, Experience in scheduling and troubleshooting jobs via Control-M tool; Create and monitoring table space / storage requirements, Perform online redefinitions on table to remove fragmentation; Create and managing database objects like tables, views, and indexes, partitions.* Create profiles and attaching them with users and monitoring the users. Proficiency in database security and audit requirementsWhat is in it for you?* An opportunity to join an enthusiastic and collaborative team in a role that is building a new work culture.* A competitive basic salary plus a full benefits package, including an excellent pension scheme, life assurance, private healthcare/medical insurance, plus a series of flexible benefits.* Discretionary bonus.* Flexible working/working remotely.We will count on you to:* Design and construct large relational databases.* Integrate new systems with existing structure and refine system performance and functionality.* Manage data integration and train users on effective implementation of database practices* Compute solutions to data problems in a timely manner with techniques that offer long-term success* Transmit information feedback between end-users and data specialists to ensure high-quality programs* Maintain an open and optimistic point of view to build broad systems that provide dependable and customized usage to multiple end-users* Provide support with continuing maintenance, updates and upgrades; identifying and fixing problems as they arise* Provide recommendations for performance tuning and improvements to existing databasesWhat you need to have:* 5+ years of experience in supporting Oracle RDBS, experience in Oracle 11g/12C/19c, handle Oracle Installations and Oracle Database upgrades in a single instance and RAC environments; Applying quarterly PSU / CPU patches; Knowledge of configuring ASM Disks & ASM database creation, RAC installation and monitoring RAC databases; Oracle Cloud infrastructure (Exadata) experience is a plus.* Maintain and troubleshoot database health, Identify and troubleshooting SQL performance problems; Generate and analyze Statpack, AWR,ADDM,ASH and TKPROF reports and provide recommendations for performance improvement; Create baseline for SQL queries from Historical plans and manage execution plans across databases.* Backup and restoration/recovery of database using RMAN and manual approach; Configure and manage backup & recoveries through RMAN utility, Perform offline and online backup & recoveries;* Cloning/duplicate and troubleshooting database issues as needed; Configure Standby Databases & Active standby databases; Monitoring and troubleshooting Standby issues, DR Failover and Switchover.* Hands on experience on up-gradation of Databases from 10g to 11g , 11g to 12c and from 12c to 19c (single Instances and RAC); Installation of Agent and grid software. Troubleshooting grid and Agent related issues; Configure OEM alerts and templates and define alert rules.What makes you stand out?* Experience of or interest in Oracle/MSSQL database technologies* Familiarity with data visualization, data migration and data modelling tools* Experience in applied mathematics and statisticsMarsh McLennanMarsh McLennan (NYSE: MMC) is the world's leading professional services firm in the areas of risk, strategy and people. The Company's 85,000 colleagues advise clients in 130 countries. With annual revenue of over $20 billion, Marsh McLennan helps clients navigate an increasingly dynamic and complex environment through four market-leading businesses. Marsh advises individual and commercial clients of all sizes on insurance broking and innovative risk management solutions. Guy Carpenter develops advanced risk, reinsurance and capital strategies that help clients grow profitably and pursue emerging opportunities. Mercer delivers advice and technology-driven solutions that help organizations redefine the world of work, reshape retirement and investment outcomes, and unlock health and wellbeing for a changing workforce. Oliver Wyman serves as a critical strategic, economic and brand advisor to private sector and governmental clients. For more information, visit marshmclennan.com, or follow us on LinkedIn and Twitter.Marsh McLennan and its Affiliates are EOE Minority/Female/Disability/Vet/Sexual Orientation/Gender Identity employers.

Keywords: Clark Insurance, Houston , Database Administration Specialist, IT / Software / Systems , Houston, Texas