Database Architect Job Description
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:
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:
Desired experience for database architect includes:
Database Architect Examples
Database Architect Job Description
- 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
- 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
Database Architect Job Description
- 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
- 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
Database Architect Job Description
- 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
- 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
Database Architect Job Description
- 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
- 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)
Database Architect Job Description
- 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
- 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