Oracle Data Adminstrator - Albany, NY
Company: UnitedHealth Group
Posted on: February 13, 2019
UnitedHealth Group is a company that's on the rise. We're expanding in multiple directions, across borders and, most of all, in the way we think. Here, innovation isn't about another gadget, it's about transforming the health care industry. Ready to make a difference? Make yourself at home with us and start doing your life's best work.(sm) As a Senior Oracle Database Administrator for the State of New York All Payer Database (APD) Project, you will be responsible for managing the delivery of a multi-Terabyte Oracle Exadata environment that will contain public and private health care claims and encounter data from insurance carriers, health plans, third-party administrators, pharmacy benefit managers, Medicaid and Medicare. Data will be synthesized to support the management, evaluation, and analysis of the NYS health care system.Primary Responsibilities:Install, upgrade and patch Oracle databases so that our environments remain currentProvide and implement performance tuning recommendations of all components in Exadata database machineOptimize database performance on Exadata using Exadata specific performance features in combinations with Oracle database tuning featuresAutomate database administration tasks using SQL, PL/SQL, packages, procedures, functions and triggers and shell scriptsAssist users with both basic SQL questions and sophisticated SQL tuning strategiesTest backup and recovery scenarios, as well as formulate disaster recovery proceduresUse Enterprise Manager and other tools for availability and performance monitoringAnalyze database resource consumption, for problem avoidance and trend forecastingStrong working knowledge or Oracle Real Application Security (RAS)Strong working knowledge of security controls required for regulatory compliance. This includes areas of encryption, centralized logging, inactive disablement, un-intrusive logging techniques, STIG change protocol and implementation, secure coding requirements, account management and access control standardsWork closely with Security Auditors to remediate Oracle Linux scan findings as well as regular penetration test findingsWork with engineers in support of SSO authentication requirementsRequired Qualifications:5+ years of experience with Oracle RDBMS, SQL and PLSQL 3+ years of experience with Unix/Linux knowledge including Shell scripting 5+ years' experience managing multi-terabyte Oracle database environments 5+ years of Data Warehouse experience1+ years of experience managing Work experience in Oracle 12c 3+ years of Healthcare experienceExperience with Oracle Performance Monitoring & Tuning, including Exadata specific performance features Understanding of Oracle Optimizer, optimizer parameters, parsing mechanism and how optimizer influences in controlling, stabilizing execution plans Thorough knowledge of Dimensional Data Modeling and traditional ER modeling and leveraging Performance Impacts on DWH systemsWorking knowledge of security controls required to meet health care regulatory requirements Ability to be on call 24/7 (shared) for problem resolutionExperience with and willingness to support 24x7 production environmentsPreferred Qualifications:Bachelor's degreeState Medicaid Data Warehouse or Medicaid Management Information Systems Experience Experience with NY Medicaid/Health Exchange dataInformatica tuning experience to assist ETL developers in meeting SLA load requirementsTableau performance tuning experienceASM and RMAN ExperienceAccomplished in handling Performance Benchmarking and configuration, of in-memory database tuning and other middlewareCareers with Optum. Here's the idea. We built an entire organization around one giant objective; make health care work better for everyone. So when it comes to how we use the world's large accumulation of health-related information, or guide health and lifestyle choices or manage pharmacy benefits for millions, our first goal is to leap beyond the status quo and uncover new ways to serve. Optum, part of the UnitedHealth Group family of businesses, brings together some of the greatest minds and most advanced ideas on where health care has to go in order to reach its fullest potential. For you, that means working on high performance teams against sophisticated challenges that matter. Optum, incredible ideas in one incredible company and a singular opportunity to do your life's best work.SMDiversity creates a healthier atmosphere: UnitedHealth Group is an Equal Employment Opportunity/Affirmative Action employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national origin, protected veteran status, disability status, sexual orientation, gender identity or expression, marital status, genetic information, or any other characteristic protected by law.UnitedHealth Group is a drug-free workplace. Candidates are required to pass a drug test before beginning employment.Job Keywords: Oracle Data Adminstrator, SQL, RDBMS, Unix, Linux, Albany, New York, NY
Job Title: Oracle Data Adminstrator - Albany, NY Shift: Day Job Travel: No Business: Optum State Govt Solutions Family: Technology Telecommuter Position: No Job Level: Director Overtime Status: Exempt Posted Date: 1/14/2019 City: Albany State: NY Country: United States Department: Optum State Govt Data Warehsng - provided by Dice Analysis, Backup and Recovery, Database, Database Administration, Data Modeling, Data Warehouse, Director, Disaster Recovery, Encryption, Exchange, Genetic, Informatica, Linux, Manager, Management, Middleware, Modeling, Oracle, PLSQL, PL/SQL, Project, Protocol, Scripts, Security, Shell Scripting, Shell Scripts, SQL, Unix
Keywords: UnitedHealth Group, Albany , Oracle Data Adminstrator - Albany, NY, IT / Software / Systems , Albany, New York
Didn't find what you're looking for? Search again!