Here are sample job advertisements for Database Architect roles...


Database Architect

Fontainebleau Las Vegas

Las Vegas, NV 89109


The Database Architect is responsible for the design and architecture of databases, data warehouses, and data for business intelligence tools. This position will create and extract requirements and develop logical and physical data models. In addition, this position will drive, develop, and execute data strategies including secure data acquisition, reporting, and business intelligence. Manage data extraction and migration, as well as data governance.

ESSENTIAL DUTIES AND RESPONSIBILITIES:


The following and other duties may be assigned as necessary:

  • Lead data modeling, storage, and design and maintenance of data maps (ETL/ELT)
  • Extend functionality of tools by deploying secure API integrations and automation tasks
  • Architect, integrate and configure applications to fully utilize Microsoft SQL Server and Cloud native databases technologies that support complex, highly available, and resilient database systems
  • Monitor database efficiency, ensure high availability, and maintains database performance by troubleshooting problems, fine tune the database environments and perform capacity planning
  • Hands-on architecture of data warehouse layer from ingestion to cleansing to making data available
  • Secure API implementation
  • Perform other job-related duties as requested

QUALIFICATION REQUIREMENTS:

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Must be at least 21 years of age.

  • 5+ years of experience modeling, visualizing, and interpreting data
  • Experience with one or more cloud-based data warehouse (e.g., Redshift, Snowflake)
  • Bachelor’s in computer science, Information Systems or related field or equivalent work experience
  • 5+ years of work experience in SQL and/or data architecture
  • An excellent foundational understanding of data types, data structures, and database systems and their specific use cases

CERTIFICATES, LICENSES, REGISTRATIONS:

Team Member must be able to qualify for licenses and permits required by federal, state, and local regulations.

LANGUAGE SKILLS:

Ability to read and interpret documents in English, such as safety rules, operating and maintenance instructions and procedure manuals. Ability to read and communicate verbally in English. Written communication skills in in English may also be required.

REASONING ABILITY:

Ability to apply commonsense understanding to carry out instructions furnished in written, oral, or diagram form. Ability to deal with problems involving several concrete variables in standardized situations.


Database Architect

PRISM

Folsom, CA 95630

PRISM is a joint powers authority of California public entities, which was established in 1979 to provide insurance and risk management services to California’s counties. Since then, our membership has expanded beyond the counties to include numerous other public agencies such as cities, schools, joint powers authorities, fire districts, etc. Recently, PRISM has expanded to include agencies in other states.

As the organization has grown, the amount of data and dependency on data has increased. More data is collected than ever, creating increased demands on staff to manage and maintain that data. Data collected is used in many ways to improve awareness, accuracy and accessibility to enhance PRISM’s programs and services.

This position will be responsible for working with the various departments throughout PRISM to take a lead role regarding all data and database initiatives.

As part of the Infrastructure Team in the IT Department, this position will report directly to the Chief Information Officer. However, duties will be spread across multiple departments/teams, and assignments and tasks will come from a variety of IT managers/supervisors in the organization. Therefore, working with multiple teams, and frequent changes from one project to the next will be a common characteristic of this job.

Duties will range from specific and creative, such as writing scripts to transform data or a process to more routine and operational like verifying database backups are successful and recoverable.

Necessary Skills/Experience/Knowledge:

  • Database ArchitectureFrameworksFlowsIntegrationsWarehousesExtract, Transform, Load (ETL)High AvailabilityGovernanceQuality StandardsUnique challenges with Cloud data/databases
  • Database AdministrationPerformanceData SecurityAvailabilityBackup and recoveryUser Management/PrivilegesCapacity managementUpgrades/Patching
  • Database Design/DevelopmentDatabase design principlesDatabase structure and data objectsData dictionaries and data entity diagramsAdvanced SQL skillsStored procedures, scripting
  • Support cloud hosted databases and infrastructure
  • Experienced problem solver
  • Ability to work through a project from conception to completion
  • Exceptional customer service skills
  • Thrive in a team environment
  • Ability to prioritize and manage competing demands

Desired Skills/Experience/Knowledge:

  • Windows Server Administration
  • Software versioning
  • Change control processes/procedures
  • Agile Scrum
  • Jira

Database Architect

Studio Designer

We currently have an excellent opportunity for a Database Architect/Administrator. We are looking for a candidate who is aggressive, willing and eager to learn fast, and grow with the company. The right candidate will be familiar with Postgres database technologies operating in a cloud (AWS) environment. In this position, the successful candidate will work with IT and Product Development teams to design, implement, operate, and tune database platform. This position demands a hands-on, team player with excellent interpersonal communication skills and customer focus.

Core Responsibilities:

  • Work with architects and developers to design and implement relational database schema objects.
  • Design and implement database optimization processes including query plan evaluation and optimization.
  • Work as part of the internal IT operations teams to build and troubleshoot network and server issues; and optimize the database environment.
  • Review and enforce database change management standards for Development, QA, and production.
  • Develop, implement, and verify processes for system monitoring, storage management, and DR/BC.
  • Design and implement database security to ensure integrity and consistency.
  • Manage SLS and adherence to production controls - Sarbanes-Oxley (SOX) and other compliance frameworks.
  • Proactively stay current with technologies and industry best practices associated to the position.

What You’ll Ideally Have:

  • Excellent communication skills and well within a team environment and within team processes.
  • Design, implementation, and management experience of web-scale SQL platforms for SaaS products.
  • Expertise in troubleshooting and performance monitoring Postgres or SQL Server Database server (Query Tuning, Server Tuning, Disk Performance Monitoring, Memory Pressure, CPU bottleneck etc.).
  • Expertise in SQL and writing efficient and highly performant stored procedures and SQL code.
  • Experience with installation and configuration of database clusters, replication, log shipping, mirroring, and other HA tools.
  • Database, file size, and space forecasting ability.
  • Ability to manage a complex database system and assist clients with Database Integration for future Business Intelligence efforts.

Additional Skills:

  • System administration fundamentals including Installation, Configuration & Security setups.
  • Experience with RedGate or comparable Postgres tooling.
  • Experienced in architecting high availability, business resumption and disaster recovery solutions.
  • Understanding of key infrastructure technologies such as Clustering, SAN Storage, Virtualization, Cloud services.
  • Data Warehouse and VLDB experience highly desired.