- Featured in:
-
More Database Architect Resumes
Use these Database Architect samples as a guideline or visit our extensive library of customizable best resume templates.
Select
Customize
Download
Find out what is the best resume for you in our Ultimate Resume Format Guide.
Additional Architecture Resume Samples
Database Architect Resume Samples
No results found
0-5 years of experience
Conducted complete inventory for two bag production plants and structured MP2 software to meet company needs
- Implemented supply and parts accountability from a non-existent system and ensured its successful launch
- Designed chain of custody method for parts department to allow proper flow of parts and tools to authorized users
- Recovered unused assets in excess of ten thousand dollars to improve upper managements scope on the company’s available inventory
- Instituted training for all supervisors and management to ensure the understanding and execution of all phases of supply and parts accountability
0-5 years of experience
Provided production/development/QA support for business and mission critical applications.
- Implemented, configured, and administered replication for MS SQL 2005 Servers.
- Performed development and production upgrades from system 2005 to 2008 versions.
- Responsible for performance/tuning of all the instances.
- Designed SQL Server monitoring product to monitor multiple SQL Server tasks on 2005 and 2008 SQL Servers.
- Responsible to assign proper login/user access on instance/database level.
- Upgraded multiple 2005 databases to 2008 R2
0-5 years of experience
Architected the data archiving solution to handle high data volume and improve application performance.
- Managed projects from operations as well as development group based on business needs and priorities.
- Reviewed the SLA from various vendors when the company decided to move to a new data center. Created the process to restore the production database at the new data center.
- Implemented Oracle Streams to move master data from a factory schema to different Oracle environments.
- Tuned the queries and database, performed backup/recovery, data export/import using Data Pump, authentication, auditing, database monitoring, patch installation and other DBA tasks (24×7 support).
- Designed the star schema for a data mart for special reporting needs like activity and trend reporting. Implemented the ETL process using plsql stored procedures, cron batch jobs and shell scripts.
- Environment:Oracle10g, Solaris, Oracle Designer, OEM, RMAN, DataGuard, OWB, CVS, PL/SQL, XML
0-5 years of experience
Completed design, development and deployment of a data warehouse including a normalized data store for consolidating data from multiple systems as well as dimensional data marts for loading into multidimensional databases for data analysis.
- Developed ETL packages using SSIS for loading data into the NDS and DDS.
- Created a suite of executive-level reporting from the new warehouse using SSRS.
- Created SSAS cubes for data analysis as well as trained high-end users to navigate and dice the cubes using Excel and PowerPivot.
- Assisted the team with migrating to TFS from Perforce. Developed a document set for common TFS-related tasks and led the training effort.
- Completed four complex reporting projects for the Fraud, Policy Administration Services, Operations and Quality Control units. Many of these reports completely automated manual tasks and contributed to improving departmental efficiencies.
- Developed a framework for mass-generating subscription reports using SQL Server 2008 Standard Edition. The process mimics data-driven subscriptions without the need for SQL Server Enterprise Edition.
0-5 years of experience
Implemented and developed data warehouse, which helped the OLTP system run 40-60% faster.
- Lead team which converted the Freshnex system from Informix to Oracle
- Data Modeled using Erwin 3.5.2 for Data Warehouse, deciding on space requirements and backup criteria
- Managed database security, which involved the design, development and implementation of automated data backup and restoration procedures to provide technical support for database maintenance and disaster recovery
0-5 years of experience
Performed SQL query optimization through use of SQL Profiler, appropriate indexing, reducing use of cursors and reducing load on tempdb.
- Constructed a flexible dynamic framework for automating database build process and stored procedure unit tests
- Designed and implemented database schema for [company name] Corporate Error Reporting (CER) product which shipped in Beta format to over 240,000 desktops and 21,000 servers
- Implemented reporting using SQL Reporting Services (SRS). All reports were localized and globalized in 5 separate languages
- Responsible for merging CER database with [company name] Operations Management (MOM) database
- Worked on project through entire [company name] life cycle, from product planning, design, coding, code review, threat analysis and shipping
- Promoted after 10 months
0-5 years of experience
Managed all aspects of database design, implementation, administration, and support processes to ensure the availability, operability, and stability of data assets.
- Researched and recommended new technologies to achieve improved architectural performance while controlling the costs of IT operations across the enterprise.
- Established and conducted all operations for full-service consulting and managed technical services to translate business requirements into innovative database solutions.
- Engaged and managed strong business relationships with stakeholders to ensure high levels of service, response, driving the overall success of business and technical strategies.
- Mentored senior technical staff and provided support as an escalation point for critical technical issues.
0-5 years of experience
Lead architect on commercial accounting system for the film industry.
- Supervised developers and approved code before it moved into production.
- Researched, tested and recommended 3rd party software solutions.
- Managed Quality Assurance teams testing the software.
- Introduced the Agile programming methodology which resulted in significant cost cutting.
0-5 years of experience
Created and maintained logical & physical data models. Resolved database stability and optimization issues. Involved in managing various database applications for trading environments. Responsible for migrating databases systems from BofA to Merrill Lynch’s environments.
- Delegating weekly responsibilities of assignments, interfacing with business managers, application users, and project managers to gather/define/document requirements for new initiatives and resolving current issues.
- Implemented BofA/Merrill Lynch’s transitioning activities: integrating key BofA trading system components to ML’s environment, eventual decommissioning of transitioning platforms.
- Involved in resolving all database performance issues, performance enhancements, and tuning strategies.
- Responsible for reviewing/approving all SQL code before deployment to Production.
- Mentoring database developers on SQL code standards and best practices. This led to a decrease in database outages; from 10 per month to less than 2 per year.
- Optimizing imbedded SQL in perl/shell scripts for faster completion time; from hours to minutes.
0-5 years of experience
Developed criteria, based on database design requirements, for selection of a report writing software platform for a new web portal project.
- Reviewed vendor software packages and recommended the report writing software that best met the design requirements.
- Developed pilot database and application to test the selected Web Portal Report Writing software.
- Developed a final recommendation for product selection.
0-5 years of experience
Database Architect experience for oracle 9i and oracle 8i, which includes data modeling, logical and physical database design, Analyzing and evaluating database design,
- System Administered Sun/HP UNIX System and Oracle Application release 11i.
- Performed Database Performance Tuning, Backup and recovery, cloning, Disk space management, memory management on development and Production Environment, full Technical Implementation of Oracle application 11i.
- Implemented Financial, CRM, Supply Chain link, HR, OWB, manufacturing, BIS, EDW, Discoverer 3i and Discoverer 4i on SUN and HP Platform. Maintained and Application support for Oracle Application 11i4 (ERP) Upgraded 11i2 to 11i4 on IBM AIX64 platform.
- Upgraded database from 8.0.6 to 8.1.7.1.
- Tuned Oracle Application 11i3 and troubleshoot MFG, BOM, WIP, ENG, INV and other finance module like AP, AR, and GL. Technical Lead in installing and implementing 11i3 for CRM (Sales Compensation). Performed 11i3 cloning supported and managed four 11i instances.
- Written PL/SQL scripts to handle assignment gaps. Team member for 10.7 to 11i4 migration.
- Upgraded the oracle application 10.7 to 11i4 on sun Platform.
0-5 years of experience
Developed database systems to automate budgeting processes for SAP accounting, compensation and hiring.
- Created database prototypes for future development of all systems for [company name]’s financial budgetary models.
- Designed and developed a contract management system to accurately track all clinical trials and oversee costs.
- Created clinical trial database budgeting system to model trial enrollment utilizing matrix, statistical and regression
- Utilizing SDLC and Agile, developed and integrated advanced financial algorithms to provide budgetary models and implemented an organized data environment to manage and allocate expenses across all divisions and branches.
- Designed User, Functional and Technical Design Specifications and created EDC forms to capture clinical data.
0-5 years of experience
Architected a database to be used to tracked when, where, and how often reserved soldiers were called for duty
- Wrote the ASP.Net WEB application in C# that allowed each stakeholder to maintain information needed by their department
- Developed reports, using BIDS for the Generals and staff officers to show inflow and outflow of soldiers through the system
- Developed a windows service in C# to interact with a feed from the Department of the Army server in DC to synchronize data between systems
- Built SSIS packages to synchronize data to an MS Access database so data could be used in the field
- Established security policies and implemented security controls to protect sensitive data
0-5 years of experience
Develop standards and policies for database design, data entry, and ensure compliance.
- Manage the daily operations for the clinical databases supporting dental care delivery. Responsible for data accuracy (inputs/outputs) and technology/server management.
- Developed training materials for report analyst training and supported the creation of dashboards for executives.
- Implemented the business requirements and developed the database design for the external network provider data mart to be implemented in the enterprise data warehouse database.
0-5 years of experience
- Inspected business flow of clinic to identify database requirements for scheduling and prescribing, then designed an ERD
- Engineered and implemented a complete normalized database in Oracle, and assigned users’ authorizations for efficiency
- Delivered additional functions of database in a package containing 4+ procedures and functions using PL/SQL
- Created user-friendly interfaces and generated 5+ reports to present data records
0-5 years of experience
- Oversaw and led the database design portion for all new eCommerce-driven projects, including the waitlist functionality which increased limited sales by 30%
- Assisted in determining project and technical specifications for new features within the website
- Created SSRS reports through Report Builder to provide visibility to company metrics and inventory movements
- Coordinated with third party warehouse vendor to enhance data workflow and resolve all data inconsistencies
- Built and refactored SSIS packages to better transfer data across multiple SQL instances
- Handled and reviewed all SQL deployments within a continuous integration environment
- Enhanced and maintained multiple SSAS Cubes for reporting
- Proactively monitored servers across multiple environments on a 24×7 basis
6-10 years of experience
- As Senior Database Architect for the BIS application suite developed for the US Navy, PMRF, was responsible for all aspects of software design and development; Requirements analysis, development, data manipulation and loading, documentation and coding standards, implementation, and training of users.
- Performed Network server installation and management. Applied government standards and security requirements to data access. Implemented network security.
- Performed all DBA functions for installation, upgrading, and migration of databases versions 6 thru 9.
- Created Visual Basic interfaces to send and receive data from several external US Navy Financial systems.
- PC hardware repair and upgrade.
0-5 years of experience
Database Architect for software development company specializing in procurement and materials management for the hospitality industry.
- Standardized SQL database schema and created an updateable deployment system to allow the company to standardize and version its entire customer base and decrease deployment times for new customers from days to minutes.
- Designed and developed a meta-schema to allow for multi-language capability without changes to existing functionality.
- Designed and developed a multi-currency system with real-time foreign exchange support across any number of currencies and dates.
- MS SQL Server, MySQL, PHP, Java
0-5 years of experience
Project manager for implementation of a web-enabled accounts reconciliation application to facilitate rapid closure of financial transactions for quarterly and annual accounting periods.
- Architected solutions for migrating applications and databases to new environments and infrastructures.
- Database architect to reengineer numerous databases across multiple business units and to develop normalized schema models for VLDB and MDDB repositories.
- Served on the Database Review Board which reviewed proposed database physical / logical models and validated / approved them for correctness and best practices.
- Drafted database optimization standards for universal adoption using Oracle, DB2UDB and Sybase including system, database and SQL best practices and optimization techniques.
- Integrated internal and external data sources, including Airport Services and third-party Industry market data, into Analytical Data Warehouse. Developed data models, source-to-target data mapping, and ETL specification.
- Produced conceptual, logical and physical data models, metadata, and Oracle DDL using ER/Studio Data Architect.
- As a DML (Manager) in charge of Common Initiatives, successfully brought several technology projects through full life-cycle development to completion.
- Developed ER/Studio administration standards and processes for ER/Studio data model and repository management, and the publishing of metadata through the ER/Studio Portal.
- Designed C, C++, Java, PERL and SAS applications and managed development / implementation teams through installation.
0-5 years of experience
Maintained and supported 100 – 300 production SQL databases (2000/2005/2008r2/2012) in physical and virtualized environments.
- Performed performance tuning on queries and databases on a routine basis.
- Supported & maintained SSIS, SSRS, & SSAS deployments/packages.
- Assisted in the daily maintenance of the prod/test/dev environments on physical servers and VMs. Assist with installation on client machines, cluster setup, upgrades, restores and backups.
- Routinely ran database backups, restores, maintenance plans, reporting of data, security, and health of databases on servers with internal and external customers.
- Executed physical DBMS changes, monitored and maintained database capacity, managed physical DBMS configurations, and support cluster servers. Set-up replication and monitoring, implement physical DBMS changes in support of normal data growth.
- Solved critical and non-critical tickets using SalesForce.com or JIRA ticketing system.
- Created and maintained SQL DBA run books which include policy, installation, security, scripts, company processes and expectations from DBA outlook.
- Conducted high level meetings with management discussing projects and maintaining project deadlines in accordance with business standards.
- Lead in charge of installation of SQL Server Software on multiple platforms/datacenter environments, plans for upgrades, clustering and decommissioning of servers.
0-5 years of experience
Responsible for logical and physical database design, implementation and administration of all database systems including StudioWorks- Yearbooks web application and StudioBalfour – Web 2.0 application. Database environments included MySQL, Oracle on Linux.
- Designed and implemented database cluster architecture.
- Designed a database to support the web application clustering.
- Completed StudioWorks database redesign and conversion which resolved the huge database performance challenges.
0-5 years of experience
Modeled and designed SQL Server and Postgres databases for medical robotics systems.
- Developed data vault for the warehousing of slowly changing “dimensional” data
- Developed database objects (stored procedures, tables, etc) for the manipulation of data
- Defined source control structure for database code
- Developed change scripts, population scripts, and test data scripts
- Installed and configured SQL Server 2008 databases
- Performed User Maintenance
0-5 years of experience
The Database Architect for a federal government hazardous materials management system.
- Daily activity categories were lead Oracle DBA, lead PL/SQL developer, logical and physical data modeler, and production code promotion.
- Database code promotion scripts were re-factored and much of the stored database procedures tuned for better performance. Table partitions were adjusted to be more consistent with data use.
- Managed work flow for four highly technical personnel.
- Tools used: SOLARIS, Linux, ORACLE 10g-11g, Grid Control, Oracle Data Modeler, SQLDeveloper, Jdeveloper
0-5 years of experience
Oversaw all database schema design on projects for all development teams. Databases were designed and implemented in Oracle and Microsoft SQL Server.
- Responsible for the deployment and administration of critical databases both on and off site.
- Documented policies, and provided training for development teams and end-users.
- Developed an extensive customer billing spreadsheet using Excel, VBA, SQL Server.
6-10 years of experience
Architected and designed IDV Solutions brand product, Location Feature Server (LFS) 1.0. Location Feature Server is a .NET (written in C#) based server product which enables organizations to view their data overlaid as intelligent, interactive features on Microsoft Virtual Earth map, Google map and other base maps. Combined with the UI toolset in Flash named LFS Visual, LFS enables organizations to unlock and reveal significant trends, patterns, anomalies which are “locked up” or latent within their various data sources.
- Managed and architected a data warehouse project for CAC call center. This application includes a management console and reporting system. Backend consists of a stage database and a data warehouse. Main responsibilities included manage user requirements, project planning, project management, architect solutions, wrote stored procedures and designed data warehouse. The Front end using .Net and C# and ASP .Net.
- Worked as the Database Architect of IDV, responsibilities include architecture of database infrastructure, hardware selection, server configuration, database administration, database design, performance tuning, security and permission management, backup/restore and database development (including write stored procedures, trigger and database access code using C#.
- Participated in British Petroleum (BP) Hurricane Management System (BP-HMS) for 2006 Gulf Mexico Hurricane season. This project uses the IDV Solutions Location Feature Server (LFS) as a backend server and LFS Visual as front end written in .Net using C#. The HMS integrated with BP SharePoint portal and its database. HMS system uses ArcSde gateway from ESRI (Microsoft SQL Server as backend database server) to manage the spatial data and Microsoft SQL Server to manage the business data.
- Worked as a team member for Department of Transportation (DOT) project using .Net, SharePoint and C#. Responsibilities including create Oracle Spatial databases and write stored procedures for spatial analysis.
- Built a demo project Microsoft using SQL Server 2008 spatial capability using .Net and C#. Responsibility included load shapefiles, create stored procedures and write plug-in for VFS (C#) to use the spatial analysis feature include in SQL Server 2008.
0-5 years of experience
Responsibilities include Database Architecture, Design, Code Review and Performance Testing & Maintenance of Production Systems.
- Maintain, bug fixing, enhancement, , performance tuning and production support for [company name]’s ad .system using back end PL/SQL, external tables.
- Designed and implemented a framework for publishing daily average 10 TB production data to GRID/HADOOP data pipe lines using PL/SQL, Oracle scheduler and perl scripts.
- Supported /Enhanced and maintain home-grown ETL system including Mat views, Partitions, Parallelism, Data Replication, IOT, Advanced SQL Analytical Functions, External Tables.
- Architecture, design, performance tuning and DB related support to DOTS pipeline, which feeds serving from ad system.
0-5 years of experience
- Assisted in management of 500,000 customer record database for 200 clients using MS Access and Donor Perfect.
- Developed new solutions with classic ASP and SQL.
- Provided information support for Capital Campaigns.
10+ years of experience
- Founder of Consulting Agency, providing resource augmentation solutions to Top 100 companies.
- Developed business and data integration solutions for company acquisitions
- Supported application development within JDE, PeopleSoft, ISI, McCormick and Peachtree packaged software.
- Managed database operating software and infrastructures.
0-5 years of experience
- Re-architected the back-end ETL process supporting the Call Center reporting data warehouse using Microsoft SQL-Server.
- Designed new data warehouse reporting system that provided statistics which improved the Quality of calls and workorders, and also improved Call Responses thru providing information on attendance, availability, schedule compliance, and other business statistics.
- Re-designed the enterprise consolidated schemas for rapid reporting services.
- Source systems included Sybase, Oracle, SQL Server databases.
0-5 years of experience
Lead for Data Architecture and Business Intelligence on variety of projects.
- Designed and developed reports using SSRS, ETL Package using SSIS.
- Design OLAP data warehouse using Kimble’s methodology.
- Provided database coding to support business applications using T-SQL and PL/SQL.
- Configured and maintained SQL Server Database Mirroring and snapshot of database.
- Conducted peer design and code reviews.
- Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
- Performed database design by analyzing business requirements
- Assisted in troubleshooting and resolution of database issues
0-5 years of experience
Implemented databases with extensive aggregate reporting functions and charting capabilities utilizing ETL macros in MS Access and MS Excel, charting trends and high traffic/trouble sites.
- Responsible for designing the databases of the newly migrated applications and completing associated enterprise relationship diagrams with flowcharts and project artifacts documentation.
- Managed capacity planning, disaster recovery response by performance analysis of site radio towers.
- Developed and maintained database objects, tuned structures for efficient data storage, and retrieval.
6-10 years of experience
Designed and populated databases and a Business Intelligence reporting system for the College.
- Implemented and managed all aspects of a Business Objects solution at the College. This includes branding and customization of the UI, report template creation, naming standards, advanced security, universe development, report development, automation of BAIR backups, upgrades, troubleshooting, training, evangelist, ETL, designed for scalability. Upgraded BO.3.1 to 4.0.
- Developed reports that will annually save the 1.5 person Institutional Research reporting team over 1 person month.
- Implemented a strategy that allows reuse of budget reports by many departments throughout campus.
- Designed database standards and databases to support the College’s reporting needs.
- Member of the security team representing database implementation.
- Developed standards and naming conventions for Datatel ODS ETL.
- Designed and developed SSIS jobs to extract, transform and transfer data.
- Responsible for all aspects of MS SQL*Server database performance and scalability, from database server to query.
0-5 years of experience
Lead the design of a new database based application that ingests 20 GBs data/day and feeds data to 2,000+ remote sites. Responsible for complete redesign of an overhaul of existing legacy database based application to add new functionality and significantly improve performance
- Fully responsible for all Conceptual/Logical/Physical Design
- Fully responsible for delivering Data Architect artifacts for the Federal Enterprise Architecture and presenting designs to the government client.
- Held company wide training sessions on database design and performance tuning
- Fully responsible for integrating the teams design with the government operations group and multiple 3rd party vendors that interact with the application.
- Absolute end of the line and final arbiter for all performance issues
0-5 years of experience
- Designed ERD diagram with conceptual and relational schema based on a requirement analysis
- Implemented queries and achieved normalization
- Documented violation constraints
0-5 years of experience
Responsible for Enterprise Database Management at FHLBanks – Office of Finance, the central funding arm of the Federal Home Loan Banks system.
- Full life cycle Sybase and MS SQL Server database administration. Responsible for database design and modeling, installation, replication setup, upgrades, patching, capacity planning and performance tuning, shell/Perl scripting.
- Successfully completed annual Disaster Recovery testing for last 3 years, by failing over to DR site and failing back.
- Currently leading the effort to migrate Sybase ASE Servers from version 15.5 to 15.7, and Sybase replication servers from 15.6 to 15.7 version.
0-5 years of experience
Responsible for working with development teams on migrating DB2 SQL to Oracle SQL
- Perform migration and mitigation of empty strings from DB2 to Oralce.
- Perform database query analysis of DB2 queries in Oracle SQL Studio.
- Work on Business Intelligence teams on redeploying DB2 code to be handled more efficiently by Oralce database preventing an entire re-write of the application.
- Create PL/SQL scripts to migrate and correct table data for conversion.
- Refresh development, test, training and QA environments as needed from Production.
0-5 years of experience
Design, troubleshooting, and customization of Microsoft SQL Server relational databases queries, reports, data extraction & transformation (ETL).
- Designed and developed specialize resource and rental scheduling module for Microsoft Retail Management System (RMS) using ORM (Object-Role Modeling) Artificial Intelligence technology in C# .NET (windows) environment.
- Developed digital signature capture system for generating receipts and contracts.
- Level 3 customer technical support.
- System installation and configuration for Windows, Linux, Mac OS X.
0-5 years of experience
Hardware, Database & Application Performance tuning of SQL server 2000 clusters running on windows server 2003 enterprise edition.
- Increasing the site uptime. The company had a problem of frequent database downtime which in-turn brings the website down. Average 100K loss in revenue per hour of down time.
- Overall environment management. Writing lot of OSQL utilities for the product support group.
- Fine tuning of the cluster disk subsystem. Setting effective backup strategy.
- Providing 24X7 support for the database issues related to product and web sites.
- Troubleshooting and solving the complex end user issues related to data, integrity, transactions and product bugs in database.
- Training the developers of the company in writing efficient database code.
0-5 years of experience
Assisted Software Engineers with creating databases for interactive websites using SQL Server 2005 database
- Projects included coding and debugging using Visual C#, XHTML, HTML, ASP.NET, javascript and SQL stored procedures
- Provided Oracle 9i, 10g and SQL Server 2005 database support on Windows and UNIX platforms, for business national units
- Performed database maintenance tasks to support application changes and ensures the integrity and efficient performance of the databases; including backup recovery, migration, space management, structural changes and performance tuning
0-5 years of experience
Served as lead database (Oracle on Solaris) architect and DBA
- Served as Solaris Administrator
- Designed database schema for in-house and commercial applications
- Provided in-house programming support in SQL, Perl, VBA, Java, Unix
- Extensive vendor and product review
- Extensive client presentations with potential partners
- Supervised two junior programmers
6-10 years of experience
- Principal database architect of Latin America’s first and only major national real estate database soon to be implemented to assist national property registries, real estate agents, and domestic and international markets.
- A four year project working closely with SQL database programmers and web site developers.
- Created a complex and in depth architecture plan for programmers to transfer into code requiring two dashboard controls to manage database.
- Assisted in the Beta testing of this national database.
0-5 years of experience
Designed a custom database that supports the new ERP system for this wholesaler.
- Created design for new database schema to handle multiple legal entities and profit centers for ERP System.
- Created mapping of legacy data structure to new ERP database structure.
- Created series of Stored Procedures to convert data from legacy system to new ERP with validation testing.
- Created trigger generator to support audit functionality, and stored procedure generator.
- Created testing framework in Visual Studio 2013 C# based on XML test cases.
6-10 years of experience
Created and maintained FHIEdatabase physical design models from object or logical models. Design and create database schema scripts (DDL), deploy schema build scripts. Maintain database baselines in Rational Clearcase and Subversion Version Control. Work with CM in tracking and fixed software bugs using Rational ClearQuest.
- DBA support in application development, testing and production. Administration include install, upgrade, patching, performance tuning, monitoring, backup and recovery, export/import, sql*loader etc. Setup database in Oracle Failsafe on Windows and RAC environment on Linux.
- Designed, structured, and maintained the large and complex DOD, VA, CROSS, and LOGGING databases for Federal Health Information Exchange (FHIE). Designed and implemented the database structure, physical tables/objects, access control via roles/synonyms/privileges.
- Worked with application development team or project management regarding project planning, resource allocation, task definitions and schedules.
- Developing database models, data dictionaries, data flow diagrams and FHIE DB run book etc documentation.
- Helped troubleshooting database problems. Assess root causes for bug or production problem.
- Analyzed database performance and identify problematic SQLs, gather schema and table statistics, tune database and optimize query execution plans using SQL Tuning Analyzer, Oracle SQL profiles and baselines.
- Designed the peer review process and procedures.
0-5 years of experience
Review performance and recommend new architect for 12TB Oracle Data Warehouse
- Design and manage hardware build for Data Warehouse database using DELL and NetApp with four NICs
- Manage ETL Developer, QA and DBA teams on Data Warehouse performance improvement project.
- Develop and implementation of rapid Oracle RAC deployment procedure using cloning tools.
- Architect portable, expandable, and stable Oracle 10G R2 RAC.
- Promoted to lead position and manage Data Warehouse DBA after six months.
0-5 years of experience
Wrote functional requirements and lead development efforts on two separate products – an integration engine, and record matching and linking application.
- Reviewed the data flows within the electronic health record management application. Created a comprehensive data model and a new database schema.
- Designed and developed a complete data layer framework.
- Proposed and designed a few architectural changes to the application.
- Developed modules for the integration of external data sources via Web Services API.
- Developed parsers for XML based incoming messages, including CCR, and a CCR document builder.
- Led company preparation to the 2010 IHE Connectathon.
- Designed, developed and implemented code for migration MSeHA data from Oracle to MySQL.
- Designed, developed and implemented application extracting complete patient information into XML files for the MarkLogic indexing and search engine.
- Implemented database change management with LiquiBase.
0-5 years of experience
Design IT solutions supporting business and technical goals based on SQL 2005 database: T-SQL, IS, AS (MDX), RS
- Perform dimensional modeling to facilitate understanding and development of data marts.
- Design and implement ETL for both OLAP and OLTP data marts.
- Analyze, design, implement tools to monitor and improve data quality in different CRM systems (Siebel, msorg) using SQL Server 2005.
- Coordinate efforts to establish common practices for inter-departmental cooperation.
- Design and implement practices for improved performance and resource usage.
- Design, construct and implement data exchange between various systems to support analysis of overall system performance and data quality.
6-10 years of experience
Leads prod management on Oracle RAC, and Data Guard systems for Verimatrix Partners in more than 37 countries, including tier 1 partners such as Ericcson, TeliaSonera, FetchTV and Comcast.
- Establish and enforce best practices for above 15 RACs and 30 Data Guard production systems
- Leads troubleshooting and performance tuning in Verimatrix Global services Team.
- In charge of data modeling and schema design for Verimatrix engineering team.
- Provide training for Junior DBAs and database developers
- Design and lead Oracle Core training courses to Verimatrix Partners.
0-5 years of experience
Worked with a three-member team responsible for upgrades of Unisys MCP and DMSII software, including Remote Databases, and general maintenance to the Unisys (A17 and A19 multi processor systems).
- Used Team Quest SMFII to create year-end report and usage of system by categories to assist clients to determine the need for additional processors for the peak Christmas season.
- Performed Regression testing on new EMC disk and Storage TEK Tape drives to determine the best of breed to purchase and implement.
- Supported team member responsible for insuring databases were mirrored and all redundancy aspects were fulfilled including creating mirrored packs and adding or reducing pack families.
- Assisted developers in resolving COBOL failures and issues
Database Architect Duties and Responsibilities
Daily job duties for database architects vary based on the amount of data they manage and the number of other IT professionals they regularly work with. These core tasks, however, are common despite those variables:
Create and Maintain Databases Database architects design new databases to securely store data, then maintain those databases to ensure that data remains safe and accessible. This also includes testing all database functions and features to ensure consistent and efficient operations.
Assess Data Needs Database architects review a company’s database needs and develop plans and programs to manage these issues.
Evaluate Database Components Database architects evaluate software, hardware, and computer networks as they relate to the database to check for bugs and other issues that may affect functionality.
Perform Data Cleanup Database architects clean up databases by removing excess and old data that no longer needs to be stored.
Design Database Applications Database architects create new database applications.
Back Up Data Database architects regularly back up data to prevent data loss.
Collaborate with Staff Database architects collaborate with system architects, information technologists, and other staff members regarding data storage practices, network operation, and other computer issues.
Database Architect Skills and Qualifications
Database architects need excellent computer skills and a high degree of programming knowledge to create and maintain databases and manage data. Employers look for candidates who display the following essential skills:
- Programming – database architects use multiple programming languages to design database applications, which requires excellent computer programming skills
- Computer skills – database architects use computer skills to work with multiple software programs, computer networks, and applications
- Analytical thinking – database architects use analytical skills to evaluate databases and database components
- Attention to detail – database architects study and examine databases for security, data flow, and functionality, which requires good attention to detail
- Communication skills – database architects collaborate frequently with other members of the IT staff, which requires good verbal communication skills
Database Architect Education and Training
Employers look for database architects who have a bachelor’s degree in information technology, engineering, computer science, or a similar field. Candidates who have a master’s degree in one of these disciplines are even more desirable to employers, though this is not usually a requirement of employment. Little on-the-job training is provided to database architects, who already have the skills and knowledge needed to perform the job’s day-to-day functions. However, many employers provide database architects with a brief orientation period during which they become familiar with the company’s data needs and existing database functions. This orientation period varies by company but typically lasts no longer than a few weeks.
Database Architect Salary and Outlook
PayScale data shows that database architects earn $112,816 annually. Software developers, who share some core tasks with database architects, earn $103,560 in median annual pay. Information from the Bureau of Labor Statistics shows that jobs in this field will rise 24 percent by 2026, a growth rate that is much faster than the national average. Database architects receive full benefit packages that include health, dental, vision, and life insurance coverage. Retirement options, paid vacation days, and sick days usually come standard in these packages as well. Some companies provide additional perks to employers, such as free parking, gym memberships, and continuing education reimbursement.
Helpful Resources
Search for jobs, learn career strategies, and master the tips and tricks needed to succeed as a database architect with these helpful resources:
Association for All IT Architects – visit IASA to search for IT jobs of all types, look for upcoming industry events, and find education programs for
database architects and other information technology professionals
Big Data Architect’s Handbook: A Guide to Build Proficiency in Tools and Systems Used by Leading Big Data Experts – learn codes for creating data applications and managing data with this in-depth book written for database architects and data professionals of all types
Data Management Association International – search for events, explore learning resources, and read content for data professionals in all fields at the DAMAI website
Data Modeling Made Simple with Embarcadero ER/Studio Data Architect: Adapting to Agile Data Modeling in a Big Data World – learn more about data modeling concepts and data management practices with this in-depth book written for database architects
CompTIA: Informational Technology Industry & Association – visit the CompTIA website to explore training events, find helpful tools, and discover other resources for database architects and IT professionals
Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design – discover tips and strategies for database design with this book that covers different database types, design terminology, and techniques that database architects need to succeed
Architecture Cover Letter Examples
Rate This Article
Database Architect
Last edited by: Gabriela Barcenas, CONTENT STRATEGIST -
Gabriela Barcenas
CONTENT STRATEGISTGabriela is a Certified Professional Resume Writer (CPRW) and career adviser. With 10 years of digital media experience and five years of resume writing expertise, her publication history includes fashion, education, travel, social justice, equitable design and career advice.
