SQL Server Database Administrator III
Found in: beBee jobs US - 2 weeks ago
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.
This position is responsible for providing oversight in all aspects of SQL Server database system design, implementation, troubleshooting, and administration.
DutiesOversee 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 ContinuedEducation 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 DegreeExperience
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.
Required:
Sound knowledge of RDBMS concepts, database architecture and SQL/T-SQL.
Ability to maintain detailed database related documentation.
Licenses/Certifications RequiredLicenses/Certifications Preferred
Required Training
Physical Requirements
LightAdditional 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)
-
Oracle Database Administrator III
Found in: beBee jobs US - 1 week ago
Los Angeles, California, United States L.A. Care Health Plan Full timeSalary 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...
-
SQL / DBA architect - Hiring OPT CPT H1B Candidate
Found in: beBee jobs US - 2 weeks ago
Los Angeles, California, United States Jobrino Full timeWe're searching for a seasoned pro-level MongoDB repository administrator/architect. With this job you are going to help us to change from monolithic relational SQL Server sources toward a sent out database/micro solutions architecture using MongoDB.You'll help assess and judge the applicability of MongoDB for recently proposed applications/solutions. You...
-
Service Oriented Architecture Administrator II
Found in: beBee jobs US - 1 week ago
Los Angeles, California, United States L.A. Care Health Plan Full timeSalary 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...
-
Service Oriented Architecture Administrator II
Found in: beBee jobs US - 1 week ago
Los Angeles, California, United States L.A. Care Health Plan Full timeSalary 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...
-
Enterprise Server Analyst
Found in: beBee jobs US - 1 week ago
Los Angeles, California, United States The Los Angeles Unified School District Full timeAbout the Role: For LAUSD's Information Technology Division, a Enterprise Server Analyst assists with planning, configuring, analyzing, implementing, managing, and monitoring components of the District's Enterprise Server systems, cloud deployments, and related collaboration and messaging technologies.Job Duties:Participates in system testing, certification,...
-
ETL Data Integration Developer III
Found in: beBee jobs US - 2 weeks ago
Los Angeles, California, United States L.A. Care Health Plan Full timeSalary 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...
-
Business Intelligence Developer III
Found in: beBee jobs US - 7 days ago
Los Angeles, California, United States L.A. Care Health Plan Full timeSalary Range: $91, Min.) - $121, Mid.) - $136, 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...
-
Lead SQL Reports Developer
Found in: beBee jobs US - 6 days ago
Los Angeles, California, United States L.A. Care Health Plan Full timeSalary Range: $102, Min.) - $132, Mid.) - $163, 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...
-
Technical Analyst III
Found in: beBee jobs US - 2 weeks ago
Los Angeles, California, United States L.A. Care Health Plan Full timeSalary 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...
-
Clinical Data Analyst III
Found in: beBee jobs US - 2 weeks ago
Los Angeles, California, United States L.A. Care Health Plan Full timeSalary Range: $88, Min.) - $115, Mid.) - $142, 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...
-
Data Engineer
Found in: beBee jobs US - 2 weeks ago
Los Angeles, California, United States codesbright Full timeResponsibilities Utilizes the Microsoft SQL Server database software to manage and house data from multiple sources. Assists in the designing of data structures that can support large amounts of data are easy to use and processes efficiently; implements creation of data structures. Designs creates and QCs ETL processes via SQL Server's SSIS functionality...
-
Business Intelligence Developer
Found in: beBee jobs US - 7 days ago
Los Angeles, California, United States MSIT Full timeResponsibilities Design develop bank wide dashboard using PowerBI. Design develop and maintain reports ad hoc queries and analytical tools. Produce metrics and other report objects and components. Perform ongoing monitoring automation and refinement of reports and PowerBI. Work with BI Management to identify and resolve data related issues. Work with...
-
Clinical Data Analyst III
Found in: beBee jobs US - 2 weeks ago
Los Angeles, California, United States L.A. Care Health Plan Full timeSalary Range: $88, Min.) - $115, Mid.) - $142, 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...
-
Principal Systems Administrator
Found in: beBee jobs US - 2 weeks ago
Los Angeles, California, United States L.A. Care Health Plan Full timeSalary Range: $121, Min.) - $160, Mid.) - $180, 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...
-
C++ Developer
Found in: beBee jobs US - 1 week ago
Los Angeles, California, United States Matal Full timeResponsibilities Work with Lead and development team to ideate scalable software solutions. Adhere to development strategies and coding practices. Develop well-functioning databases and applications Ensure consistency with initial design and adhere to Schedules/Deadlines. Manage server-side architecture. Analyze structural requirements for new software and...
-
C++ Developer
Found in: beBee jobs US - 1 week ago
Los Angeles, California, United States Soro Technologies Full timeResponsibilities Work with Lead and development team to ideate scalable software solutions. Adhere to development strategies and coding practices. Develop well-functioning databases and applications. Ensure consistency with initial design and adhere to Schedules/Deadlines. Analyze structural requirements for new software and applications. Collaborate with...
-
Senior BI Cognos Developer
Found in: beBee jobs US - 2 weeks ago
Los Angeles, California, United States QData Full timeRequired Qualifications Bachelor's Degree in Computer Science / MIS or equivalent experience 5+ years of experience BI Database Experience Cognos BI experience 3+ years (Framework Manager/Data Modeling) Extensive experience on multiple full life cycle Data Warehouse implementations Extensive experience in business intelligence and OLAP SSIS(SQL Server...
-
Report Writer III
Found in: beBee jobs US - 7 days ago
Los Angeles, California, United States L.A. Care Health Plan Full timeSalary Range: $77,265.00 (Min.) - $100,445.00 (Mid.) - $123,625.00 (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...
-
System Administrator
Found in: beBee jobs US - 7 days ago
Los Angeles, California, United States Hadrian Full timeHadrian — Manufacturing the FutureHadrian is building autonomous factories that help aerospace and defense companies make rockets, jets, and satellites 10x faster and 2x cheaper. Our CEO, Chris Power, discusses the importance of what we're building in this video.We are a lean but mighty team (and growing) people that are passionate about building critical...
-
Program Manager III
Found in: beBee jobs US - 7 days ago
Los Angeles, California, United States Mitchell Martin Inc Full timeOur Client, Provides health insurance for low-income individuals, is seeking an Program Manager IIILocation: RemotePosition Type: ContractJob Summary:The enterprise Portfolio Management Office (ePMO) is accountable for intake, execution, and managing the oversight of strategic programs and projects approved and budgeted by Board of Governors. These programs...