Current jobs related to Database Architect - Sacramento - California Mental Health Services Authority

  • Database Architect

    3 weeks ago

    Sacramento, California, United States Real HR Hero - Thompson HR Consulting Full time

    Job Title: Database ArchitectWe are seeking a highly skilled Database Architect to join our team at Real HR Hero - Thompson HR Consulting. As a Database Architect, you will be responsible for designing, developing, and administering a healthcare-related common data model.Key Responsibilities:Design and implement physical database structures to support...

  • Database Architect

    2 weeks ago

    Sacramento, California, United States Real HR Hero - Thompson HR Consulting Full time

    Job Title: Database ArchitectWe are seeking a highly skilled Database Architect to join our team at Real HR Hero - Thompson HR Consulting. As a Database Architect, you will be responsible for designing, developing, and administering a healthcare-related common data model.Key Responsibilities:Design and implement physical database structures to support...

  • Database Architect

    1 week ago

    Sacramento, California, United States Real HR Hero - Thompson HR Consulting Full time

    Job Title: Database ArchitectWe are seeking a highly skilled Database Architect to join our team at Real HR Hero - Thompson HR Consulting. As a Database Architect, you will be responsible for designing, developing, and administering a healthcare-related common data model.Key Responsibilities:Design and implement physical database structures to support...

  • Database Architect

    4 days ago

    Sacramento, California, United States Real HR Hero - Thompson HR Consulting Full time

    Job Title: Database ArchitectWe are seeking a highly skilled Database Architect to join our team at Real HR Hero - Thompson HR Consulting. As a Database Architect, you will be responsible for designing, developing, and administering a healthcare-related common data model.Key Responsibilities:Design and implement physical database structures to support...

  • Database Architect

    1 month ago

    Sacramento, California, United States Real HR Hero - Thompson HR Consulting Full time

    Job Title: Database ArchitectWe are seeking a highly skilled Database Architect to join our team at Real HR Hero - Thompson HR Consulting. As a key member of our technology team, you will be responsible for designing, developing, and administering a healthcare-related common data model.Key Responsibilities:Design and implement physical database structures to...

  • Database Architect

    4 weeks ago

    Sacramento, California, United States Real HR Hero - Thompson HR Consulting Full time

    Job Title: Database ArchitectJob Summary:The Database Architect is responsible for designing, developing, and administering a healthcare-related common data model. This role involves defining, creating, and maintaining enterprise databases and database structures within the organization. The successful candidate will analyze, test, and implement physical...

  • Database Architect

    4 weeks ago

    Sacramento, California, United States California Mental Health Services Authority Full time

    Job DescriptionJob SummaryThe Database Architect will be responsible for designing, developing, and administering a healthcare-related common data model. This includes primary responsibility for the definition, creation, and maintenance of enterprise databases and database structures within the organization. The successful candidate will analyze, test, and...

  • SQL Server Database Architect

    4 weeks ago

    Sacramento, California, United States Mindlance Full time

    Job Title: SQL Server AdministratorWe are seeking a highly skilled and experienced Microsoft SQL Server Database Administrator (DBA) to join our team at Mindlance. The ideal candidate will have expertise in SQL Server Reporting Services (SSRS) and Transact-SQL (TSQL), with a strong focus on database design, implementation, maintenance, and optimization.Key...

  • SQL Server Database Architect

    1 week ago

    Sacramento, California, United States Mindlance Full time

    Job Title: SQL Server AdministratorWe are seeking a highly skilled and experienced Microsoft SQL Server Database Administrator (DBA) to join our team at Mindlance. The ideal candidate will have expertise in SQL Server Reporting Services (SSRS) and Transact-SQL (TSQL).Key Responsibilities:Design, implement, and maintain SQL Server databases to ensure high...

  • Enterprise Architect

    3 weeks ago

    Sacramento, California, United States CalSTRS Full time

    Job Title: Enterprise ArchitectCalSTRS is seeking a highly skilled Enterprise Architect to join our team. As an Enterprise Architect, you will play a critical role in shaping the future of our technology landscape.Job SummaryThe Enterprise Architect will be responsible for developing and implementing IT strategies that align with the organization's business...

  • Salesforce Technical Architect

    2 weeks ago

    Sacramento, California, United States Resource Informatics Group Full time

    Job Title: Salesforce Technical ArchitectAt Resource Informatics Group, we are seeking a highly skilled Salesforce Technical Architect to join our team. The successful candidate will be responsible for designing and implementing high-performance technical solutions on the Salesforce SaaS platform.Key Responsibilities:Design and build technical solutions on...

  • Salesforce Technical Architect

    3 weeks ago

    Sacramento, California, United States Resource Informatics Group Full time

    Salesforce Technical Architect Job DescriptionWe are seeking a highly skilled Salesforce Technical Architect to join our team at Resource Informatics Group. The ideal candidate will have a strong background in Salesforce implementation and a proven track record of designing and building high-performance technical solutions on the Salesforce SaaS platform.Key...

  • Salesforce Technical Architect Position

    3 days ago

    Sacramento, California, United States Resource Informatics Group Full time

    Job Title: Salesforce Technical Architect PositionJob Summary:We are seeking a highly skilled Salesforce Technical Architect to join our team at Resource Informatics Group. The ideal candidate will have a strong background in Salesforce implementation, with a minimum of three years of experience as a Technical Architect on a Salesforce project. The...

  • Salesforce Technical Architect

    4 days ago

    Sacramento, California, United States Resource Informatics Group Full time

    Job Title: Salesforce Technical ArchitectJob Summary:Resource Informatics Group is seeking a highly skilled Salesforce Technical Architect to design and build high-performance technical solutions on the Salesforce SaaS platform. The ideal candidate will have a minimum of three years of full-time equivalent experience as a Technical Architect on a Salesforce...

  • Data Warehouse Administrator/Database Administrator

    4 weeks ago

    Sacramento, United States NetVision Resources Inc. Full time

    Key Duties/Responsibilities: Performs data warehouse administration for the Enterprise Data Warehouse in the Oracle Cloud Infrastructure, Oracle Autonomous Data Warehouse Environment Reviews existing architecture and provides solution recommendations where applicable Develops, tests, and implements scripts/jobs for data Extract Transform and Load (ETL) from...

  • Salesforce Technical Architect

    2 weeks ago

    Sacramento, California, United States Resource Informatics Group Full time

    Salesforce Technical Architect Job DescriptionWe are seeking a highly skilled Salesforce Technical Architect to join our team at Resource Informatics Group.Key Responsibilities:Design and build high-performance technical solutions on the Salesforce SaaS platform.Develop a recommended Salesforce solution architecture to meet customer enterprise architecture...

  • Senior Software Architect

    4 days ago

    Sacramento, California, United States Oracle Full time

    Job DescriptionOracle is seeking a highly skilled Senior Software Architect to join our team. As a key member of our software engineering division, you will be responsible for designing, developing, and troubleshooting software programs for databases, applications, tools, and networks.Key Responsibilities:Design and develop software programs for databases,...

  • PHP Full Stack Architect

    3 weeks ago

    Sacramento, United States Global It Solutions Usi Inc Full time

    Must have expertise in PHP frameworks, cloud technologies, and mobile development, strong background in designing, developing, and deploying enterprise web applications.Must have 10+ years of experience with the following tech stack.Architect, design, and develop enterprise-level web applications using MVC frameworks.Extensive experience working with PHP and...

  • Oracle Data Warehouse Architect

    1 week ago

    Sacramento, California, United States Qualitative Financials Full time

    Job Title: Oracle Data Warehouse AdministratorAt Qualitative Financials, we are seeking an experienced Oracle Data Warehouse Administrator to join our team. The successful candidate will be responsible for performing data warehouse administration for the Enterprise Data Warehouse in the Oracle Cloud Infrastructure, Oracle Autonomous Data Warehouse...

  • Oracle Data Warehouse Architect

    4 days ago

    Sacramento, California, United States Qualitative Financials Full time

    Job Summary We are seeking an experienced Oracle Data Warehouse Administrator to join our team at Qualitative Financials. The successful candidate will be responsible for performing data warehouse administration for the Enterprise Data Warehouse in the Oracle Cloud Infrastructure, Oracle Autonomous Data Warehouse Environment. Key Responsibilities Performs...

Database Architect

2 months ago

Sacramento, United States California Mental Health Services Authority Full time
Job DescriptionJob DescriptionDescription:

SUMMARY

The Database Architect is responsible for the design, development, and administration of a healthcare-related common data model. Includes primary responsibility for the definition[AB1] , creation, and maintenance of enterprise databases and database structures within the organization. Analyzes, tests, and implements physical database design supporting various business applications (including base definition, structure, documentation, long-range requirements, and operational guidelines). Ensures data recovery, maintenance, data integrity, and space requirements for physical databases are met through formulations and monitoring of policies, procedures, and standards relating to database management. Provides a high degree of coordination between user, technical, application, and customer entities to ensure effective data management as an enterprise. Above all, this role ensures solutions meet business objectives and establishes and maintains a high level of user trust and confidence in IT’s knowledge of and concern for users’ business needs. Has a willingness to work with customers of varying levels of technical expertise in a high-pressure, complex environment.

DUTIES AND RESPONSIBILITIES include but are not limited to:

· Create a long-term common data model for integration and interoperability between internal and external systems. Publish and present design reports.

· Research and recommend design criteria; publish standards and work with development staff; standardize environment and improve efficiency.

· Create, develop, and review the physical model created from the logical model, ensuring the detailed physical design of data structures and databases complies with standards, guidelines, and procedures recommended for all aspects of data modeling, database design, and maintenance; ensure proper data modeling and design paradigms are applied.

· Produce entity relationship diagrams, data flow diagrams, database normalization schemata, logical to physical database mapping, DDL, and database commands.

· Manage the implementation and use of the enterprise data dictionary.

· Lead design reviews for database designs, application code, and pre- and post-implementation capacity meetings; estimate sizes of new databases.

· Develop rules, procedures, and standards for the access and maintenance of shared data resources.

· Review the overall physical database structures for considerations of data integrity, performance quality, recoverability, maintenance, and space requirements.

· Communicate complex technical information in a concise and articulate manner.

· Participate in technical strategy meetings to discuss upgrades, capacity planning, performance reporting, and new application designs.

· Participate in the evaluation and recommendation of DBA tools and new DBMS technologies.

· Develop utilities for monitoring and evaluating data quality.

· Assist in the definition and development of database documentation and standards.

· Conduct application transaction volume and traffic analysis and interpret the impact on the database and network performance.

· Design data infrastructure to extract and organize data for authorized individuals to access. Identify internal and external data sources, collaborate to determine data storage and organizational needs, and use the information to create and maintain data infrastructure.

· Performance monitoring and tuning: Closely monitor performance; identify problems and implement solutions; ensure the database is running at optimum speed and efficiency.

· Maintain database backup/recovery environment: Assure that data recovery time objectives are established and met; verify implementation of correct backup strategy; develop recovery procedures; support recovery from loss of data caused by user or system error; respond quickly to refresh data.

· Keep database and model at current release and maintenance levels; install supporting products; provide current, stable production and development environments.

· Reorganize database structures as needed: Automate procedures at regular intervals; use tools to reorganize or defragment database table spaces, tables, and indexes; provide an efficient database environment to maximize productivity and improve performance.

· Perform application refreshes on request: Refresh data from one environment to another at the request of the application development staff; execute necessary tasks to accomplish this, including export, drop, create, and import pre-scheduled time to minimize impact; provide application development staff optimal development environment with current data.

· Capacity planning and reporting: Monitor file system space, database allocation, etc.; verify efficient use of disk storage; reclaim unused space; optimize space allocation and avoid out-of-space conditions.

· Serve as business liaison to database vendors.

· Work closely with application development staff and clients to help resolve problems, such as performance problems, hardware/software upgrades, application program design reviews, new application setup and implementation, application workload growth prediction and measurement, etc.

· Build and maintain a trusted working relationship with team members.

· Other duties as assigned.

Requirements:

QUALIFICATIONS

EDUCATION, EXPERIENCE, and SKILLS/KNOWLEDGE

· Requires a bachelor’s degree in computer science, engineering, or related field, or equivalent[AB1] experience.

· Master’s degree is desirable, equivalent experience acceptable.

· Recent in-depth experience in the design, administration, programming, and support of RDBMSs (e.g., Oracle, SQL Server, DB2) in one or more computing environments (e.g., Unix, z/OS, Windows, Linux, Web).

· Designing, implementing, and optimizing a common data model are a must.

· Demonstrated experience working well with customers of varying levels of technical expertise in high-pressure situations and complex environments.

· It is highly desirable that the individual has earned certification as a developer.

· Experience working with business-critical applications.

· Experience working with high availability applications.

· Thorough understanding of the common data model and solid theoretical knowledge of relational database techniques.

· Skilled in the ability to see the big picture and conceptualize and document creative solutions.

· Experience in designing, modeling, developing, and supporting large RDBMS systems (familiarity with electronic health record systems helpful).

· Extensive experience in logical and physical database design, hands-on data modeling techniques, and development methodology; physical schema design of table spaces, rollback segments, and data files

· Experience in the design of data extract, data migration, and data queuing facilities.

· Proficiency in the concepts and practice of database normalization techniques.

· Strong working knowledge of state-of-the-art database concepts/design/deployment, recovery techniques, performance monitoring and tuning, structured query language, and relational database design techniques.

· Knowledge of server-side development issues surrounding triggers, stored procedures, and packages

· Excellent oral and written communications skills.

· Ability to present and explain technical information to diverse types of audiences (management, users, vendors, technical staff) in a way that establishes rapport, persuades others, and gains understanding. Provide mentorship and share subject matter expertise with existing technical staff.

· Ability to write clear proposals and technical documents.

· Solid project management skills, including requirements definition, risk and quality management, schedule management and ability to manage projects in a cross-functional environment. Ability to synthesize multi-user requirements into a standard approach.

· Ability to weigh various suggested technical solutions against the original business needs and choose the most cost-effective solution.

· Proficiency in several RDBMS-specific middleware tools and utilities to support such activities as monitoring, database migration, DDL management, and replication is required.

· Experience with cross-platform networking in a TCP/IP environment.

· Extensive knowledge of SQL, including programming and optimizing code.

· Extensive knowledge of Azure or AWS.

· Solid programming knowledge of at least one 3GL/4GL/OO4GL language (e.g., C/C++, Perl, Unix shell, Visual Basic).

· Knowledge of Web-enabled GUIs is a plus.

REASONING – Demonstrate the ability to effectively apply common sense and follow-through to daily tasks; demonstrate the ability to work with little or no supervision; demonstrate excellent analytical skills; demonstrate the ability to efficiently conduct research and ask appropriate probing questions to complete necessary tasks.

PHYSICAL DEMANDS – The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. While performing the duties of this job, the employee is frequently required to sit and stand; use phone and headset; use hands, arms, finders to type; answer phones; write; use calculator; demonstrate strength to lift and carry materials weighing up to 10 pounds; demonstrate clear vision to read printed materials and a computer screen; hearing and speech to communicate in person and over the telephone.

SENSORY DEMANDS – The incumbent must spend long hours in intense concentration. The incumbent must also spend long hours on the computer entering information, which requires attention to detail and high levels of accuracy.

MENTAL DEMANDS – There are a number of deadlines associated with this position, which may cause significant pressure. The incumbent must also deal with a wide variety of people on various issues.

REGULAR WORK SCHEDULE – Schedule varies depending on business needs; however, company normal business hours are 8 a.m. to 5 p.m., Monday – Friday.