DATABASE ARCHITECT SKILLS, EXPERIENCE, AND JOB REQUIREMENTS

Published: October 9, 2024 - The Database Architect designs and manages large-scale distributed systems, integrating software, hardware, and network components. Demonstrates expertise in open-source messaging solutions, functional architecture, and documentation of complex infrastructures. Leads system optimization and collaborates on development projects using Agile methodologies to ensure efficient and scalable solutions.

Essential Hard and Soft Skills for a Standout Database Architect Resume
  • Database Design
  • SQL Databases
  • Data Modeling
  • Distributed Systems
  • Messaging Solutions
  • Performance Tuning
  • Cloud Infrastructure
  • Database Security
  • Disaster Recovery
  • NIX Systems
  • Analytical Thinking
  • Problem Solving
  • Attention to Detail
  • Team Collaboration
  • Leadership
  • Adaptability
  • Communication Skills
  • Time Management
  • Critical Thinking
  • Stakeholder Management

Summary of Database Architect Knowledge and Qualifications on Resume

1. BS in Computer Engineering with 9 years of Experience

  • Hands-on experience with designing and implementing database systems
  • In-depth understanding of database structure principles
  • Experience gathering and analysing system requirements
  • Expertise in SQL Server and Azure SQL
  • Hand on experience with advanced T-SQL features.
  • Regular production database maintenance task.
  • Knowledge of Data lake and Azure Data factory 
  • Knowledge of Log shipping and High Availably 
  • Detailed knowledge of query optimizer and how it relates to query performance
  • Must be detail oriented and have ability to work in a multi-tasking environment with excellent problem determination, root cause analysis skills.
  • Experience in upgrading databases, applying security patches and service packs
  • Ability to grasp advanced technical principles, theories, and concepts and creatively solve database issues

2. BS in Applied Mathematics with 4 years of Experience

  • Long and solid experience in the operation of DB clusters at scale, on several technologies (MySQL mandatory, and bonus for others like PostgreSQL)
  • Be open to custom development when necessary (Python, Golang) and used to automate DevOps style (Terraform, Terragrunt, scripting at all levels)
  • A significant curiosity and a good autonomous watch on the different storage solutions on the market
  • Recommend the right solutions according to the uses.
  • Experience with managed database offers in the cloud (AWS Aurora in particular)
  • Understand the differences and use cases compared to manually managed databases
  • Build strong relationships with users to always be one step ahead of future needs.
  • Know how to structure the projects necessary to respond to them
  • Ability to work independently and in a team environment
  • Must have experience in migrating Oracle from Aix to Linux.
  • Proficient using Google mail, calendaring and shared drives

3. BS in Information Technology with 5 years of Experience

  • Expert in migration and integration of data and DB Objects from legacy systems to new applications and new technologies.
  • Good hand on experience with optimizing data queries for improving performance
  • Hands-on experience designing RDBMS databases for web applications
  • Experience with star schema and dimensional data modeling.
  • Experience in data architecture experience including data warehousing.
  • Experience in application performance management - Systems Availability and Performance tuning
  • Expert in Designing, writing, testing, and debugging database stored procedures and complex queries to extract, calculate or manipulate information using SQL-Server 2000 /2005/2008 database 
  • Experience documenting technical specifications
  • Work experience in visualization and reporting tools (such as Tableau and Business Objects) 
  • Relational and MPP database work experience
  • Experience cloud-based setting work 
  • Experience establishing client relationships and document client needs 

4. BS in Software Engineering with 6 years of Experience

  • Strong proficiency in deploying and managing MySQL & PostgreSQL technologies/features including replication
  • Solid hands-on experience with Cloud AWS or Google Cloud
  • Certifications in related IT, DBMS and  Cloud technologies 
  • Good architectural knowledge of relevant OS, storage, networking, virtual machines, high availability
  • Experience in automation and infrastructure as code is highly preferable by leveraging Ansible and Terraform toolsets. 
  • Familiarity with Github and Jenkins 
  • Seasoned experience and skills in leading projects such as cloud, data center migrations, server consolidation, disaster recovery fail over/fail back, configuration management, security, audit and compliance
  • Experience in relational database technology knowledge
  • Experience in object-oriented design, development, and programming techniques
  • Experience with PostgreSQL Tools, Performance tuning, troubleshooting, database administration
  • Experience in object-oriented design, development, and programming techniques
  • Experience working within Cloud development (AWS, Azure, Google Cloud)

5. BS in Database Management with 10 years of Experience

  • DBA experience supporting SQL Server, Oracle and SSRS in a corporate environment. 
  • Experience in migrating Oracle on Aix to Linux.
  • Outstanding performance tuning and troubleshooting skills with a positive attitude.
  • Outstanding Oracle SQL tuning skills.
  • Strong work ethic and ability to multitask in a dynamic fast paced environment with multiple priorities
  • Customer centric with strong interpersonal and communications skills, both written and verbal
  • In-depth knowledge of database engine and database internals
  • Strong operational knowledge of Oracle and all aspect of tuning Oracle database.
  • Knowledge of Golden Gate 
  • Experience in implementing Oracle Directory services.
  • Strong knowledge of Shell Scripting, AIX, Linux and Microsoft Server Platforms

6. BS in Information Systems with 4 years of Experience

  • Experience database development in Defense or secured Government Installations.
  • Experience with Oracle DBA, MS SQL MSCA, or MSCE, Enterprise DB (EDB).
  • Knowledge in Database development and administration in cloud solutions.
  • Familiar with leading data migrations from Oracle Databases.
  • Working experience architecting, designing, and implementing databases as well as implementing and executing ETL tools.
  • Experience with NAVSEA financial systems, such as CSAS, or MSE PROD 
  • Experience transforming large, government programs to the cloud.
  • Strong written and oral communication skills.
  • Google Cloud Professional Collaboration Engineer Experience or Certification
  • Recent experience with leading successful improvement projects in an agile environment for organizations similar in size to GSA.
  • Experience analyzing customer requirements and providing assistance with requirements development similar in size, scope, and complexity.
  • Recent experience delivering emergent technologies to complex business solutions for stakeholders from multiple disciplines.

7. BS in Data Science with 7 years of Experience

  • Experience in MS SQL Server Database Administrator and has held a Senior DBA level position.
  • Experience using Azure\AWS IaaS and\or Azure PaaS\AWS RDS.
  • Experience with AWS or Azure portals, configuration, and maintenance via the portal.
  • Experience creating and configuring Availability Groups and Listeners.
  • Experience with enterprise performance and HA monitoring.
  • Experience with Windows Server platforms in relation to SQL installations and upgrades.
  • Expert knowledge of functions associated with the implementation and maintenance of SQL Server 2008 and greater including security, back-up/restoration, logging, reporting and recovery procedures.
  • Support of business and system processes and procedures.
  • Strong database design and schema refactoring experience.
  • Proven ability with query tuning dramatically improving database performance.
  • Self-motivated and collaborative with other team members.
  • Detail oriented and organized with an ability to meet deadlines.
  • Ability to work under pressure and in a fast-moving and constantly changing environment.

8. BS in Computer Science with 7 years of Experience

  • Experience designing, building and managing complex computing systems 
  • Experience designing, building and managing NoSQL/ Big Data environments such as Hadoop, MongoDB and Cassandra
  • Experience designing, building and managing open-source messaging solutions such as RabbitMQ or ActiveMQ
  • Hands-on experience in the design or development of distributed large-scale systems including software, hardware, network and process components
  • Expertise in documenting architectures and interfaces
  • Experience in developing large-scale functional system architectures and implementation designs in collaboration with stakeholders and development engineers in distributed development projects
  • Can build the requirements and interface development, functional architecture and software design and software implementation of large-scale distributed software infrastructures
  • Knowledge of computer internal architecture and design to include specific details and design of some variants of the NIX-based operating systems
  • Able to lead the design, improvement and optimization of complex datastores
  • Knowledge of the Agile project management methodologies 
Relevant Information
Database Administrator Skills, Experience, and Job Requirements
Senior Database Administrator Skills, Experience, and Job Requirements
Oracle Database Administrator Skills, Experience, and Job Requirements
Database Analyst Skills, Experience, and Job Requirements