Every business collects data. Whether it’s merely tracking sales and inventory, gathering demographic information about customers, or observing industry trends, companies need to find ways to manage that data so they can use it to change and improve. That’s where a Database Architect and Developer comes in.
Database Architects and Developers often take data from disparate sources. They envision ways to combine those sources into a more cohesive, easier-to-use framework, then develop the systems to store and manage that data. A Database Architect and Developer must create and execute an end-to-end vision for how a design might translate into physical databases, and how to integrate disparate sources of data.
Today, Database Architects and Developers need to be able to model and predict how changes in the way an organization acquires data could impact the way it uses that data, and map out the way data will flow through the various stages of a project.
Typical Duties and Responsibilities
- Provide development and administration support for various databases, primarily SQL server databases, in a client-server development environment including stored procedures and triggers, SQL, and index performance tuning, and database design and file storage
- Develop, deploy, and maintain Extract-Transform-Load (ETL) scripts and schedules
- Develop and implement all database indexing, maintenance, back-up, transformations, and stored procedures
- Expose data to application in various business tiers
- Assist software developers in implementing appropriate data access permission schemas
- Participate in the refinement and development of user stories, assessing the impact of new development on current database implementation
- Communicate with technical and product owner stakeholders to help them anticipate and mitigate configuration management issues
Education and Background
A bachelor’s degree in MIS, information technology, computer science, or data analysis, and multiple years of development experience in an Oracle or Microsoft SQL Server database environment, are required for this position.
Hands-on work experience in database design, architecture, development, and production support for enterprise applications are strongly preferred.
Skills and Competencies
- Experience developing reports using Crystal Reports or SQL Server Reporting Services
- Experience using database tools such as TOAD, Oracle’s SQL Developer, or MS SQL Server Management Studio
- Knowledge of developing analytic reports and dashboards using Microsoft Power BI or other similar tools
- Excellent command of the SQL language with the ability to write and optimize complex queries
- Solid knowledge of relational database architecture and concepts
According to Payscale the median annual salary of a Database Architect and Developer with
1 year of experience:
- Orlando, Florida: $125,000
- Tampa, Florida: $110,000
- Jacksonville, Florida: $130,000
- Miami, Florida: $104,000
- Atlanta, Georgia: $110,000
- Chicago, Illinois: $110,000
- Houston, Texas: $120,000
- Los Angeles, California: $110,000
- New York, New York: $110,000
- Seattle, Washington: $110,000
- Overall: $112,000
5 years of experience:
- Orlando, Florida: $126,000
- Tampa, Florida: $114,000
- Jacksonville, Florida: $135,000
- Miami, Florida: $135,000
- Atlanta, Georgia: $121,000
- Chicago, Illinois: $114,000
- Houston, Texas: $125,000
- Los Angeles, California: $112,000
- New York, New York: $114,000
- Seattle, Washington: $113,000
- Overall: $117,000
Similar Job Titles
- Data Designer
- Data Strategist
- Business Intelligence Solution Architect
- Solution Architect
- Cloud Architect
- Business Intelligence Architect
- Data Developer
- Data Engineer
- ETL Developer
- BI Developer
- Data Warehouse Consultant
- Business Information Consultant
- Data Warehouse Developer
Database Architects and Developers usually have educational backgrounds in computer engineering, computer science, or related fields with coursework in application design, systems development, and information management. They also study subjects like computer programming, web development, operating systems, systems analysis, and technology architecture. Students are encouraged to take as many courses in database-related specialties, including Microsoft, Oracle, IBM, SQL, and ETL as possible.
As students, people starting on the path to become a Database Architect and Developer do internships in IT fields where they can learn network management and application design. Database Architect and Developer is not usually an entry-level position, so many candidates often begin their careers as Database Administrators and work on their skills database management, data modeling, and data warehousing.
It’s also important for a Database Architect and Developer to pursue professional certifications like the CDP (Certified Data Professional), offered by the Institute for Certified Computing Professionals. Other certifications are available based on specific database software platforms. Companies like Microsoft, IBM and Oracle offer certifications on the products they make, including Microsoft Certified Database Administrator (MCDBA), Microsoft MSCE Certified Data Management and Analytics, Oracle Database Certifications and IBM Certified Database Administrator – DB2.
Companies are increasingly looking for more sophisticated software scripts, machine learning, and artificial intelligence (AI) so they can get even more in-depth data about their businesses. Business owners are hoping that machine learning and AI can help them look at trends and anticipate the evolution of customers’ tastes and opinions.
Many organizations are transitioning to storing their data in the cloud, and creating plans for cloud migration is a growing trend in the database architecture and development field. Also, as organizations attempt to become more agile and responsive, they desire real-time analytics, which requires a Database Architect and Developer to design faster and more flexible systems.
According to a survey of subscribers to the trade publication Database Trends and Applications, database performance is becoming a more common concern for Database Architects and Developers. In 2019, 64 percent of subscribers surveyed reported spending more time on database performance. Machine learning, the use of data lakes, and using data engines like Spark, are also becoming more common in the field.
As companies become more data-driven and depend on people who can help them collect, access, and interpret data to help them strategize and become more efficient, Database Architects and Developers will be needed to help develop software to access and manage the necessary data.
According to the U.S. Bureau of Labor Statistics, the computer and information technology industry — in which the position of Database Architect and Developer falls — is expected to grow by nine percent between 2018 and 2028, which is faster than average.
The typical work hours in an office setting for a Database Architect and Developer are usually from 9 a.m. to 5 p.m.
Freelance workers are usually able to set their own workdays and hours.
Where You Can Find Jobs
- 4 Corner Resources
- Career Builder
- IT Career Finder
Are You Interested in Becoming a Database Architect and Developer?
We will connect you to one of our headhunters or recruiters to see if you are a perfect fit for one of our job openings. If a job opening does not suit you, we will always keep you in mind as new positions open up. We have vast experience connecting professionals with some of the most well-known organizations in the country. Your next job or career path can be right around the corner. Check out our latest job openings and our blog for career advice.
Feel free to contact us at any time.