Database Architect Job Description
Database architect
provides expert technical Oracle DBA support for the company's production databases and associated technologies, including Oracle, MySQL and PostgreSQL.
Database Architect Duties & Responsibilities
To write an effective database architect job description, begin by listing detailed duties, responsibilities and expectations. We have included database architect job description templates that you can modify and use.
Sample responsibilities for this position include:
Design, develop and support Oracle-based batch processing, Perl and Java applications
Design, develop and support Oracle-based batch processing and Perl and Java applications
Monitor and Manage applications within the SQL environment
Design, plan, implement and support Oracle 11g,12c & Mongo databases
Work in a leading edge environment
Document the database environments
Work with Technology Development group to implement new technologies and systems
Familiarity with Visual studio and SSIS packages
Familiarity with SSAS and SSRS
Define and Develop required processes
Database Architect Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for Database Architect
List any licenses or certifications required by the position: OCP, SQL, DBA, OCM, MCSE, MCSDBA, MCSA, OCA, IAT, MCDBA
Education for Database Architect
Typically a job would require a certain level of education.
Employers hiring for the database architect job most commonly would prefer for their future employee to have a relevant degree such as Bachelor's and Master's Degree in Computer Science, Technical, Engineering, Education, Computer Engineering, Business/Administration, Management, Project Management, Information Technology, Mathematics
Skills for Database Architect
Desired skills for database architect include:
PostgreSQL
MySQL
Apache Hadoop
Oracle
Oracle DBMS
VMware
SQL
Java
Principles
Cassandra
Desired experience for database architect includes:
Deep knowledge of various data sources (government, open source APIs, point-of-sale, proprietary sources, ) and experience in linking them
Strong technical knowledge in software development methodologies, design patterns, tools and implementation
Database schema creation and management
Work with the Global Technology Infrastructure (GTI) organization across all technology areas (server based, Database, Web, Storage and Network) to define that strategy and ensure that CT feedback is incorporated into all future strategies
Experience with other Big Data technologies (Hadoop, Hive, Pig, Mahout, Spark, Storm, ) is a big plus
Own the schema and layout of each game’s data warehouse and ETL systems
Database Architect Examples
1
Database Architect Job Description
Job Description Example
Our innovative and growing company is searching for experienced candidates for the position of database architect. We appreciate you taking the time to review the list of qualifications and to apply for the position. If you don’t fill all of the qualifications, you may still be considered depending on your level of experience.
Responsibilities for database architect
- Work to meet data requirement deliverables and integrations through advanced SQL queries and SQL scripts, stored procedures and triggers
- Lead in architecting, designing, modeling, developing, maintaining and deploying complex data models, and data integrations utilizing SQL server (SSIS) based ETL processes for new and existing systems
- Develop stored procedures, complex SQL queries, scripts and database programming for systems
- Participate in all of Software Development Life Cycle, starting from requirements, design, maintenance, enhancement, coding, and administration of SQL servers
- Drive improvement in our methodologies, systems, tools and processes
- Helping other game analysts in ensuring effective adherence to data integrity processes with each games developers to ensure new and existing telemetry events are effective and efficient, and testing these event results in a development, test and live production environment
- Produce and lead others in the creation of regular reports and dashboards to drive insights and data driven decisions
- To work collaboratively with Game GMs, Product Managers and each game team’s Producers to present data and analysis that will provide actionable insights into the game to improve the acquisition, engagement and monetization of our audience
- Provide high level database support and guidance to existing systems and those in development
- Document all aspects of existing and future database installations
Qualifications for database architect
- Strong technical experience in BI and statistical software (Tableau, Microstrategy, R, ), data warehouses
- Passion for gaming, understanding of free-to-play game mechanics in social and mobile games
- A desire to learn new methods in data mining/manipulation
- Background in statistics, management consulting, banking, software engineering or other quantitative disciplines is highly valued
- Clear verbal and written communication style
- Ability to work in a very dynamic environment with a cross section of individuals in multiple roles/responsibilities
2
Database Architect Job Description
Job Description Example
Our innovative and growing company is looking to fill the role of database architect. To join our growing team, please review the list of responsibilities and qualifications.
Responsibilities for database architect
- Responsible for ensuring data consistency and integrity across all systems
- Manage the administration and support for all development/testing/production databases
- Provide performance tuning, high availability implementation and support change management / release management
- Manage design and implementation of backup and recovery processes for all databases
- Automate management and maintenance of all databases
- Establish performance baseline standards for new and existing databases
- Establish, implement and execute regularly planned upgrades
- Work closely with other IT resources across the enterprise
- Establish monitoring standards to ensure all events are monitored for proper system performance
- Develop long-term strategic goals for production databases
Qualifications for database architect
- A minimum of a BS in Computer Science, Statistics or equivalent work experience
- Experience with database backup technologies such as RMAN, Avamar
- Bachelors Degree in related field or equivalent and 8+ years of experience
- Investigates, reviews and recommends adoption of new features, utilities and integration of new releases of existing DBMSs
- Researches developments in database technologies to recommend appropriate new tools
- Provides guidance to DBAs on best usage of database technology new features
3
Database Architect Job Description
Job Description Example
Our innovative and growing company is looking to fill the role of database architect. If you are looking for an exciting place to work, please take a look at the list of qualifications below.
Responsibilities for database architect
- Develops and enforces corporate standards in database design and implementation and mechanisms to ensure usage compliance
- Conducts architecture related research as directed by management to better understand database solution(s) for a specific domain
- Collaborates with others to develop and maintain current and future state database architecture standards, guidelines, blueprints and roadmaps
- Provides input and guidance to support database architecture governance
- Provides support to teams to analyze and identify issues when the database architecture does not meet requirements
- Communicating effectively to project team and client team on status of projects, timelines, blockers
- Lead in planning and implementing the data integration and data migration activities
- Coordinate with team members to perform database programming based on project requirements
- Perform quality assurance tests for ensuring data integrity across multiple databases
- Interact with business teams to understand project requirements
Qualifications for database architect
- Experience designing databases supporting complex business rules
- Architecture knowledge with experience in providing technical solutions for applications
- Ability to facilitate design sessions with subject matter experts to define database requirements and resolve requirements issues
- Object Oriented Analysis, Design, and OO Tool experience is a plus
- Experience supporting technical project efforts including project planning, design, build, test, and data conversion/migration report design and builds
- Experience as Development team lead in a client environment
4
Database Architect Job Description
Job Description Example
Our company is hiring for a database architect. If you are looking for an exciting place to work, please take a look at the list of qualifications below.
Responsibilities for database architect
- Provide valid inputs in database architectural discussions
- Assist in identifying process improvements for database performance, reliability and stability
- Perform troubleshooting and analysis to assess root cause of data issues in a timely manner
- Understands best practices for data modelling, database programming and job scheduling and ETL package dependencies
- Provides technical leadership for large-scale database projects
- Ensures development using industry-standard code guidelines and best practices
- Co-ordinate with other architects to deploy database related changes to development and production environments
- Evaluate the technical feasibility of project requests and participate in technical scope definition
- Provide guidance on technical specifications, data modeling, and review proposed data models
- Reviews designs for solutions and/or operating systems often provided by supplier to refine and optimize system performance
Qualifications for database architect
- Solid experience in DB2 min
- Understanding of data architecture concepts and best practices in enterprise scale systems from logical to physical design (relational and star schema, meta data repositories)
- Knowledge of ORMs such as Hibernate
- BS degree with Computer Technology or equivalent experience
- Baccalaureate Degree in Computer Science, Computer Information Systems, Business Administration, Mathematics, or a related field
- Microsoft Certified Solutions Expert (expert)
5
Database Architect Job Description
Job Description Example
Our company is growing rapidly and is looking for a database architect. If you are looking for an exciting place to work, please take a look at the list of qualifications below.
Responsibilities for database architect
- Publishes architectural specifications for use by the organization and suppliers
- Exhibits strong conceptual understanding of most platforms and applications
- Demonstrates the ability to translate requirements into robust solutions
- Lead in research and development of data platform team in both classic database and NoSQL
- Defining the technical solution to meet the agreed non-functional requirements service availability, business continuity, performance, manageability “ITIL”, capacity planning, security and backup & recovery
- Architect in Project Delivery for the Infrastructure, DBaaS Solutions for the Migration Approach
- Expert level support of databases supporting mission critical web applications and internal applications
- Design, install and maintain highly available database systems including, monitoring, security, backup and recovery, and performance tuning
- C# .NET or similar experience dealing with Windows background services, console applications, ADO.NET, LINQ, XAML
- Experience developing with front-end JavaScript frameworks
Qualifications for database architect
- Experience in deploying large, complex solutions at Fortune 100 class companies
- Strong Financial Acumen and experience in developing business case justification including technical and financial analysis
- Bachelor's Degree or equivalent years of experience maybe accepted to satisfy the degree requirements
- Experience with install and configuration, semantic layer, system monitoring and usage tracking, security model with user groups and roles
- Experience implementing repositories at the physical, business model and presentation layer to meet the business requirements
- Experience designing and constructing a large-scale Oracle infrastructure for a federal agency or commercial entity