Real HR Hero - Thompson HR Consulting
Database Architect (DBA)
Real HR Hero - Thompson HR Consulting, Sacramento, California, United States, 95828
Come work for a company that makes a difference within the communities of the State of California. This company works on cutting-edge prevention programming, providing counties with an independent administrative and fiscal intergovernmental structure. Our client helps fund, develop, and implement California's mental health services and educational programs.
As a mental health organization, this company actively seeks to support qualified disabled candidates in obtaining employment with their company and is an Equal Opportunity Employer. Please complete the self-identification section of the application.
This company offers a VERY Generous Benefits Package, including:
10% company-sponsored retirement account (401a) 100% vested - additional compensation/retirement.Medical, Dental, Vision, LTD, Life Insurance, Wellness Program, FSAGenerous PTO planJob Title:
Database Architect (DBA)Salary:
$165,000 - $200,000Department:
TechnologyReports To:
Chief Digital Information OfficerFLSA Status:
ExemptLocation:
Sacramento, CAWork Model:
RemoteSchedule:
Monday-Friday, 8am-5pm (Could vary depending on business needs)
JOB SUMMARY:
The Database Architect is responsible for the design, development, and administration of a healthcare-related common data model. Has primary responsibility for the definition, 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 things like 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 impact on database and network performance.Responsible for designing data infrastructure to extract and organize data for authorized individuals to access. Identify internal and external data sources, collaborating to determine data storage and organizational needs and using 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.Facilitator working 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.
Required Education/Experience:Requires a bachelor's degree in computer science, engineering, or related field. Or equivalent 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 is 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 filesExperience 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 packagesExcellent 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.
COMPUTER SKILLS
- Demonstrate the ability to use Microsoft office suite (Outlook, Excel, Word, PowerPoint), Adobe, Google office suite, and other modern connectivity applications (Zoom, Slack, Asana) for daily internal communication.
LANGUAGE SKILLS and MATHEMATICAL SKILLS
- Demonstrate the ability to read, comprehend, and respond appropriately through written or verbal form; demonstrate tactfulness when communicating, including internal communication with staff members of all levels; ability to communicate with a variety of audiences effectively. Ability to add, subtract, multiply, and divide in all measure units using whole numbers, common fractions, and decimals.
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, fingers to type; answer phones; write; use calculator; demonstrate strength to lift and carry materials weighing up to 20 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
- Varies depending on business needs; however, the company's regular business hours are 8:00 am to 5:00 pm, Monday - Friday.
As a mental health organization, this company actively seeks to support qualified disabled candidates in obtaining employment with their company and is an Equal Opportunity Employer. Please complete the self-identification section of the application.
This company offers a VERY Generous Benefits Package, including:
10% company-sponsored retirement account (401a) 100% vested - additional compensation/retirement.Medical, Dental, Vision, LTD, Life Insurance, Wellness Program, FSAGenerous PTO planJob Title:
Database Architect (DBA)Salary:
$165,000 - $200,000Department:
TechnologyReports To:
Chief Digital Information OfficerFLSA Status:
ExemptLocation:
Sacramento, CAWork Model:
RemoteSchedule:
Monday-Friday, 8am-5pm (Could vary depending on business needs)
JOB SUMMARY:
The Database Architect is responsible for the design, development, and administration of a healthcare-related common data model. Has primary responsibility for the definition, 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 things like 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 impact on database and network performance.Responsible for designing data infrastructure to extract and organize data for authorized individuals to access. Identify internal and external data sources, collaborating to determine data storage and organizational needs and using 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.Facilitator working 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.
Required Education/Experience:Requires a bachelor's degree in computer science, engineering, or related field. Or equivalent 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 is 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 filesExperience 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 packagesExcellent 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.
COMPUTER SKILLS
- Demonstrate the ability to use Microsoft office suite (Outlook, Excel, Word, PowerPoint), Adobe, Google office suite, and other modern connectivity applications (Zoom, Slack, Asana) for daily internal communication.
LANGUAGE SKILLS and MATHEMATICAL SKILLS
- Demonstrate the ability to read, comprehend, and respond appropriately through written or verbal form; demonstrate tactfulness when communicating, including internal communication with staff members of all levels; ability to communicate with a variety of audiences effectively. Ability to add, subtract, multiply, and divide in all measure units using whole numbers, common fractions, and decimals.
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, fingers to type; answer phones; write; use calculator; demonstrate strength to lift and carry materials weighing up to 20 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
- Varies depending on business needs; however, the company's regular business hours are 8:00 am to 5:00 pm, Monday - Friday.