Database Architect (DBA)

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, FSA
• Generous PTO plan

Job Title: Database Architect

Salary: $165,000 - $200,000

Department: Technology

Reports To: Chief Digital Information Officer

FLSA Status: Exempt

Location: Sacramento, CA

Work Model: Remote

Schedule: Mon-Fri, 8-5 (Could vary)

JOB SUMMARY:

Responsible for designing, developing, and administrating a healthcare-related common data model. Primary responsibility for defining, creating, and maintaining enterprise databases and database structures within the organization. Analyzes, tests, and implements physical database design supporting various business applications. Provides high degree of coordination between user, technical, application, and customer entities to ensure effective data management as an enterprise. This role ensures solutions meet business objectives and establishes and maintains user trust and confidence in IT’s knowledge and concern for users’ business needs.

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.
• 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; 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/post-implementation capacity meetings.
• Develop rules, procedures, and standards for access/maintenance of shared data resources.
• Review the physical database structures for data integrity, performance quality, recoverability, maintenance, and space requirements.
• Communicate complex technical information in a concise and articulate manner.
• Participate in technical strategy meetings.
• Participate in the evaluation and recommendation of DBA tools/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/organize data for authorized individuals to access.
• Performance monitoring and tuning: Closely monitor performance; identify problems and implement solutions.
• Maintain database backup/recovery environment: Ensure that data recovery time objectives are established and met; verify implementation of correct backup strategy.
• Keep database and model at current release and maintenance levels.
• Reorganize database structures as needed: Automate procedures regularly; use tools to reorganize or defragment database table spaces, tables, and indexes; provide an efficient database environment.
• Perform application refreshes on request: Refresh data from one environment to another at the request of the application development staff.
• 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:

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 computing environments (e.g., Unix, z/OS, Windows, Linux, Web).
• Designing/implementing/optimizing a common data model is a must.
• Demonstrated experience working with customers of various 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 theoretical knowledge of relational database techniques.
• Skilled in seeing the big picture and conceptualizing and documenting creative solutions.
• Experience designing/modeling/developing and supporting large RDBMS systems (familiarity with EHR 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 extraction, 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 communication skills.
• Ability to present and explain technical information to diverse 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.