Jobs
>
Los Angeles

    SQL Server Database Administrator III - Los Angeles, United States - L.A. Care Health Plan

    L.A. Care Health Plan
    L.A. Care Health Plan Los Angeles, United States

    10 hours ago

    Default job background
    Description

    Salary Range: $105, Min.) - $139, Mid.) - $156, Max.)

    Established in 1997, L.A. Care Health Plan is an independent public agency created by the state of California to provide health coverage to low-income Los Angeles County residents. We are the nation's largest publicly operated health plan. Serving more than 2 million members in five health plans, we make sure our members get the right care at the right place at the right time.

    Mission: L.A. Care's mission is to provide access to quality health care for Los Angeles County's vulnerable and low-income communities and residents and to support the safety net required to achieve that purpose.

    Job Summary


    This position is responsible for providing oversight in all aspects of SQL Server database system design, implementation, troubleshooting, and administration.

    Duties


    Oversee all aspects of SQL Server database system design, implementation, troubleshooting, and administration. Develop, install, maintain and monitor company databases in a high performance/high availability environment while supporting enterprise projects. Provide general database design, implementation and administration to assure highest reliability and availability of I.T. services. Manage the Data Synchronization of multiple databases between data centers using transaction replication. Maintain database backup/recovery procedures and disaster recovery database environment. Implement and support database software upgrade and patch management procedures.

    Identify performance issues, deadlocks/contentions and resolve them. Generate traces, execution plans and SQL Profiling. Create and manage database constraints and indexes. Support Development Team and Business users with database operations including the development of complex SQL, tuning of DML and the creation of stored procedures. Proactive housekeeping/archiving and shrinking of databases and logs. Develop and support procedures for database security.

    Develop processes, procedures and guidelines for troubleshooting database events and performing tasks. Provide tier 2 and 3 support for all corporate SQL Server database systems and services to meet or exceed service level agreements.

    Evaluate and seek solutions to production issues as wells as new projects. Work closely with application developers and project managers in solving production issues.

    Perform other duties as assigned.

    Duties Continued


    Education Required


    Bachelor's Degree in Computer Science or Related FieldIn lieu of degree, equivalent education and/or experience may be considered.

    Education Preferred


    Master's Degree

    Experience


    Required:

    At least 5-7 years of extensive and broad based experience in the design, administration and support of SQL Server databases with in depth experience in SQL Server 2008 R2/2012.

    Extensive experience writing T-SQL and stored procedures and query tuning on high transaction databases.

    Experienced in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).

    Experience in SQL Server clustering and HA technologies including Always On, mirroring, log shipping and transactional replication.

    Preferred:

    Experience in administering SharePoint and IIS Platforms is preferred.

    Skills


    Required:

    Sound knowledge of RDBMS concepts, database architecture and SQL/T-SQL.

    Ability to maintain detailed database related documentation.

    Licenses/Certifications Required


    Licenses/Certifications Preferred


    Required Training


    Physical Requirements


    Light

    Additional Information


    Salary Range Disclaimer: The expected pay range is based on many factors such as geography, experience, education, and the market. The range is subject to change.

    L.A. Care offers a wide range of benefits including

    • Paid Time Off (PTO)
    • Tuition Reimbursement
    • Retirement Plans
    • Medical, Dental and Vision
    • Wellness Program
    • Volunteer Time Off (VTO)
  • Capital Group Companies

    Administrative Assistant Iii

    4 hours ago

    Capital Group Companies Los Angeles, United States

    "I can succeed as an Executive Assistant at Capital Group." · As one of our Executive Assistants, you will be a critical support partner for our NACG executive leadership team. You've built a career assisting others and know the level of attention this role demands. You've tested ...

  • C2PM

    Bim Administrator Iii

    2 days ago

    C2PM Los Angeles, United States

    **About C2PM**:C2PM stands at the forefront of the construction consulting landscape, offering a full spectrum of program management, construction management, and specialized engineering services. We pride ourselves on tackling public works infrastructure, transportation, aviatio ...

  • UCLA Health

    Administrative Assistant Iii, Losangeles

    2 days ago

    UCLA Health Los Angeles, United States

    **Description** · Make a positive impact on one of the nation's top health systems. Help ensure the efficient delivery of award-winning patient care. Take your professional expertise to the next level. As the Scheduling Coordinator for Cross-Sectional and Vascular Interventional ...

  • UC Irvine Campus

    Administrative Assistant Iii

    5 days ago

    UC Irvine Campus Orange, United States

    Updated: Apr 12, 2024 · Location: Orange-Campus · **Job Type**: · Department: Surgery · **Job Opening ID**:61039 · **Working Title**: Administrative Assistant III · **Department**: Surgery · **Bargaining Unit**: CX · **FLSA**: Non-Exempt · **Payroll Job Code**: 004722 · **Job Loc ...

  • Mantek Solutions Inc.

    Infrastructure Administrator III

    1 week ago

    Mantek Solutions Inc. Los Angeles, United States

    Infrastructure Administrator III · Our direct client has a 6-month contract with an option to hire. The position is for an IT Infrastructure Administrator III to work at the client Headquarters location in downtown Los Angeles, CA. · W2 only / local candidates encouraged to app ...

  • City National Bank

    Loan Administrator III

    4 days ago

    City National Bank Los Angeles, United States

    Overview: · LOAN ADMINISTRATOR III WHAT IS THE OPPORTUNITY? Provides loan documentation support to Commercial Banking Relationship Managers and Credit Officers in facilitating loan preparation and documentation activities. Serves as a liaison with lending team, City Loan Center ...

  • City National Bank

    Loan Administrator III

    1 week ago

    City National Bank Los Angeles, United States

    **LOAN ADMINISTRATOR III** · **WHAT IS THE OPPORTUNITY?** · Provides loan documentation support to Commercial Banking Relationship Managers and Credit Officers in facilitating loan preparation and documentation activities. Serves as a liaison with lending team, City Loan Center ...

  • City National Bank

    Loan Administrator III

    1 week ago

    City National Bank Los Angeles, United States

    **LOAN ADMINISTRATOR III** · **WHAT IS THE OPPORTUNITY?** · Provides loan documentation support to Commercial Banking Relationship Managers and Credit Officers in facilitating loan preparation and documentation activities. Serves as a liaison with lending team, City Loan Center ...

  • Yamaha Motor

    Administrative Assistant Iii

    1 day ago

    Yamaha Motor Cypress, United States

    Yamaha has an excellent opportunity for an **Administrative Assistant 3** to join our **Motorsports Team** in the **Cypress, CA** location. In this role you will provides administrative Support to Motorsport Group Company Field Sales Region (West/South). · **What you'll be doing* ...

  • BioPhase Solutions

    Administrative Coordinator III

    4 days ago

    BioPhase Solutions Los Angeles, United States

    Job Description · Job DescriptionBioPhase Solutions specializes in recruiting top talented professionals for Southern California's Scientific community. We are currently looking for an Administrative Coordinator III to work for a leading Greater Los Angeles area biotechnology com ...

  • UCLA Health

    Administrative Assistant III

    1 week ago

    UCLA Health Los Angeles, United States Full time

    Make a positive impact on one of the nation's top health systems. Help ensure the efficient delivery of award-winning patient care. Take your professional expertise to the next level. UCan do all this and more at UCLA Health. · As the Administrative Assistant III (AA3) Image Libr ...

  • Harvest Technical Services

    IT Infrastructure Administrator III

    1 week ago

    Harvest Technical Services Los Angeles, United States

    Job Description: · In this position the IT Infrastructure Administrator will provide troubleshooting, monitoring, analysis, and documentation of various Oracle database systems and applications. · You may be asked to set-up, maintain, manage, and administer Oracle databases inc ...

  • Gensler

    Storage Administrator III

    3 days ago

    Gensler Los Angeles, United States

    At Gensler, we design for people. We leverage our global perspective and local presence to innovate at every scale. We're not just designers. We're tinkerers, craftspeople, visionaries, innovators, and thought leaders. Fueled by passion and entrepreneurial spirit, our people brin ...

  • Gensler

    Storage Administrator III

    2 days ago

    Gensler Los Angeles, United States

    At Gensler, we design for people. We leverage our global perspective and local presence to innovate at every scale. We're not just designers. We're tinkerers, craftspeople, visionaries, innovators, and thought leaders. Fueled by passion and entrepreneurial spirit, our people brin ...

  • University of California

    Research Administrator III

    3 days ago

    University of California Los Angeles, United States

    Under the general direction of the Department Chair, Chief Administrative Office (CAO), Chief Financial Officer (CFO) and other Department leaders and in concert with other research administrative staff, you will be the primary custodian for all post-award administration for intr ...

  • Randstad USA

    Administrative Assistant III

    3 weeks ago

    Randstad USA Los Angeles, United States TEMPORARY, Full time

    The level III Administrative Assistant demonstrates thorough knowledge in the assigned area and works under direction only as needed. The Assistant provides administrative support to senior managers and may also provide administrative support to a broader department or team. Addi ...

  • Randstad USA

    Administrative Assistant III

    3 weeks ago

    Randstad USA Los Angeles, United States TEMPORARY, Full time

    The level III Administrative Assistant demonstrates thorough knowledge in the assigned area and works under direction only as needed. The Assistant provides administrative support to senior managers and may also provide administrative support to a broader department or team. Addi ...

  • UCLA Health

    Administrative Assistant III

    1 week ago

    UCLA Health Los Angeles, United States

    JOB DUTIES · Description This position is responsible for managing or administering a wide-range of responsibilities to support day-to-day administration of an academic or non-academic organization(s). Administrative support includes planning and/or development; interprets, mon ...

  • Harvest Technical Services, Inc.

    IT Infrastructure Administrator III

    3 days ago

    Harvest Technical Services, Inc. Los Angeles, United States

    Job Description · Job DescriptionJob Description: · In this position the IT Infrastructure Administrator will provide troubleshooting, monitoring, analysis, and documentation of various Oracle database systems and applications. · You may be asked to set-up, maintain, manage, and ...

  • GRIFOLS, S.A.

    Administrative Assistant III

    1 week ago

    GRIFOLS, S.A. CA-Los Angeles, United States

    · Would you like to join an international team working to improve the future of healthcare? Do you want to enhance the lives of millions of people? Grifols is a global healthcare company that since 1909 has been working to improve the health and well-being of people around the w ...