Database Developer Job Description

Question

Database Developer Job Description

Job descriptions
Information Technology

Job summary 1

Our team is seeking a skilled Database Developer to design, develop, and implement data visualizations and self-service tools that will put key information at the fingertips of our decision-makers. This role will interact with all facets and levels of the organization to define requirements, develop solutions, and drive value by leveraging an agile development process. The right candidate must be both technically and functionally versed in building a business intelligence suite from the ground up. Collaboration with and contribution to a cross-functional team will be key to the successful delivery of business requirements. This role requires an energetic attitude, creative problem-solving, a passion for technology and data, excellent communication, relationship-building skills, as well as flexibility in approach and design.

Duties & Responsibilities 1

special offer

Download all 10 Database Developer Job Descriptions

100Hires
eBook

Free Guide:

The Ultimate guide
to recruiting

Customer Engagement: Partner with business and product stakeholders to provide them the ability to make decisions and gain insights through data visualization and reporting. This would include requirements gathering, iterations, visualization best practices, design, deployment, and ongoing enhancements
Innovation: Add value by providing innovative solutions, and delivering improved-upon methods of data presentation by focusing on the business need and the business value of the solution
Data Querying: Be able to write SQL to do initial data mining that can then be communicated or translated to peer ETL developers for database development.
Prototyping: Build prototypes for demonstration and illustration purposes for peer groups, Business partners, or senior leaders
BI Development: Develop reports, dashboards, SQL queries, or metadata layers, using Tableau and other tools. Experience with Agile development methodology is required.
Problem-Solving: Support peers, and stakeholders as a Subject Matter Expert (SME) through troubleshooting, analysis of results, production support, and identification of opportunities to solve business problems through BI
- Data Visualization: Synthesize and translate Business data needs into creative visualizations in Tableau
- Storytelling: Solve Business challenges by helping to translate the meaning of data, and the impact of that data, and be able to effectively communicate the story that the deliverable tells or the problem that the deliverable solves
- Drive for Efficiencies: Look for opportunities to improve current processes or find efficiencies by applying industry best practices for BI development

Requirements & Skills 1

Job summary 2

Our Database Developer will be instrumental to Company’s success by individually contributing to and collaborating with the database team on designs and implementations for the database. A successful Database Developer will be responsible for requirement analysis through production deployment and support enabling the growth of our online lending applications. The Database Developer will be working collaboratively with our product, data, and software engineering teams on designs and implementations to grow our business while reporting directly to the Database Architect.

Duties & Responsibilities 2

Working with our product team to understand business requirements as they relate to our database.
Working collaboratively with the other software and database engineers to design and develop solutions that meet business requirements.
- Working individually on projects to ensure on-time delivery of designs and implementations as well as production support after deployment.
- Meeting our strategy for the long-term growth of our online databases through collaborative design sessions with the Database Architect.
- Analyze and assess existing implementations for maintainability, reliability, scalability, and performance. Help define improvements for existing solutions.

Requirements & Skills 2

4+ years experience in relational database design and development.
4+ years of experience in performance tuning, backup/recovery, troubleshooting, and scalability/capacity planning.
2+ Years of Amazon Web Services (AWS) experience.
- Bachelor's degree in Computer Science, Computer Engineering, or related field.
- Experience with Git (GitHub & Bitbucket), Jira and Confluence.
- Experience with writing complex SQL queries and query optimization.

Job summary 3

We are looking for a Database Developer to join us. You will be providing database development expertise for building solutions that support our customers and our teammates who serve them.

Duties & Responsibilities 3

Review, evaluate, design, develop, implement, and maintain company databases using industry-leading database tools.
Provide database-related leadership to project teams and mentor team members on database technologies as needed.
Develop implementation documentation which may include data sources, data diagrams, and other data movement processes.
Write code for database access, modifications, and constructions including stored procedures.
Develop SQL queries in the creation of business applications and SQL reports from corporate data sources.
Work closely with the Information Technology staff and end-users to design and develop specifications, data dictionaries, and access methods for optimum performance.
- Implement plans and procedures that automate and improve the efficiency and effectiveness of data processes and analysis.
- Provide effective testing of new technology related to data management, storage, and retrieval.
- Fulfill the above duties and responsibilities while fully participating in the team’s Agile-style project processes.

Requirements & Skills 3

BA/BS degree in Computer Science, MIS, Electrical Engineering, or comparable experience
Minimum of five years experience developing complex database systems for multi-tier, web-based, and mobile technologies
Familiar with a variety of industry standards regarding Microsoft database development concepts, practices, and procedures.
Proficiency with database development including the development of stored procedures, indexes, ActiveBatchjobs, SSIS packages, and use of RedGate tools
Proficiency with database technologies like Azure SQL or SQL Server on AWS.
- Proficient with Snowflake cloud data warehouse
- Proficient in a Windows and Microsoft Office computing environment.
- Excellent written and verbal communication and interpersonal skills.

Job summary 4

We are looking for a Database Developer who is committed to applying their education and vast experience to provide for natural resource conservation practices in support of an effort by Federal and State agencies, universities, and professional societies to deliver science-based information to landowners.

Duties & Responsibilities 4

Requirements & Skills 4

Bachelor’s Degree in MIS, Computer Science, Business Information Systems, Engineering or relevant discipline (4 years of experience instead of degree) and 6+ years of experience working with Databases in an enterprise environment or a Master’s and 4+ years of experience
Functional knowledge and hands-on experience in development languages (s) such as Python, JavaScript, Java, or .net.
Proficient knowledge of and ability to utilize Microsoft SQL Server 2016 or higher
PostgreSQL Experience
Recent experience supporting live production databases
- Strong functional knowledge of data integration services and how data is passed through them
- Experience supporting spatial databases (Microsoft/ESRI/PostgreSQL)
- Experience working with SAFe / Agile software development teams

Job summary 5

The Database Developer provides the opportunity to work with a variety of platforms and technologies including Databases, Web Services, and gives exposure to Financial Services as well as cutting-edge technologies.

Duties & Responsibilities 5

Maintain database integrity and keep databases running at an optimum level
- Maintain ETL processes
- Find opportunities for improvement in the existing systems and help formulate a plan to implement the changes
- Help resolve the critical production issues

Requirements & Skills 5

Job summary 6

The Database Developer will be responsible for all aspects of development related to report generation including writing report queries, developing PL/SQL, creating views, and integrating the results in external systems such as user interfaces.

Duties & Responsibilities 6

Requirements & Skills 6

Advanced knowledge of SQL
Relational database understanding
Organization and analytical skills, with problem-solving ability
- Customer service attitude
- Scripting language to drive reports.
- Ability to work independently, take initiative, and contribute to new ideas required in a diverse, fast-paced, deadline-driven team environment

Job summary 7

We are seeking a Database Developer to develop, maintain, and enhance all new and existing MS Access/SQL Server database applications under the guidance of management. This individual will also provide training and technical support to the business units utilizing the applications. Additionally, they will be responsible for developing reporting for business units as well as some ad hoc reporting as needed.

Duties & Responsibilities 7

Provides ongoing support and maintenance for all internal MS Access/SQL Server database applications within the Mortgage division.
Responsible for the design, development, testing, and implementation of all new database applications as needed.
Develop business unit-specific reporting based on requests from management as well as some ad hoc reports.
- Continuously researches enhancements to improve the user experience for in-house applications and reports.
- Documents all changes performed to applications and reports and updates policies and procedures as necessary.
- Ensures all backup versions of applications are current.

Requirements & Skills 7

Job summary 8

As part of our development team, in this role as a Database Developer, you will play a significant part in developing databases, deploying migrations, and database design by analyzing requirements within a complex data environment. There will be a strong emphasis on strong SQL skills and stored procedures. You will interact with other teams such as DBA, development, architects, and other areas of the business.

Duties & Responsibilities 8

Requirements & Skills 8

3+ years MS SQL Server Data Engine experience required
3+ years of experience in using MS Visual Studio, SQL Server Data Tools (SSDT), GIT, and SQL Server Management Studio (SSMS) required
3+ years of experience with complex SQL Server queries & stored procedures required
MCTS, MCITP, MCSA, and/or MCSE certifications a plus
Excellent written and verbal communication between varied teams
- Ability to organize and plan work independently in a rapidly changing environment
- Ability to multi-task and context-switch effectively between different activities and teams
- Ability to pass strict background check for handling sensitive data

Job summary 9

We are looking for a Database Developer with significant database development experience to add to our development team.

Duties & Responsibilities 9

Work with a team of driven, supportive, and highly skilled professionals.
Receive a robust benefits package that includes Employee Stock Ownership Plan!
Be part of an empowered accountability culture where each employee-owner has a meaningful stake in the future success and growth of the company.
Work in an Agile development environment, following a mix of Scrum and other Agile Methodologies.
- Deliver quality designs, models, and code.
- Perform unit testing and code reviews.
- Identify areas of innovation, improvements, efficiencies, and performance scale improvements.

Requirements & Skills 9

Job summary 10

Currently, we are seeking individuals to fill a Database Developer opportunity.

Duties & Responsibilities 10

Work on customer tickets to expand, add and monitor the SQL environment.
- Consult with customers on SSAS Multi-dimensional cubes.
- Partner with peers on troubleshooting SSAS and SQL issues.
- Assigned to projects to upgrade or expand SQL and SSAS environments.

Requirements & Skills 10

Develop the conceptual, logical, and physical data models, tabular and multidimensional cubes to meet business requirements.
Design, implement and support Microsoft SQL databases.
Requirements gathering, analysis, and documentation.
Strong SQL experience with both transactional and OLAP/cube databases.
- Experienced in multi-dimensional cube modeling.
- Experience in developing Data marts and OLAP cubes using SSAS/MDX.
- Excellent verbal and written communication skills.

Frequently asked questions

What are 10 things database developers do?

Database developers play a critical role in designing, developing, and maintaining databases that store and manage an organization's data. Here are ten key tasks that database developers commonly perform:

Database Design: They design the structure and layout of databases, including defining tables, fields, relationships, and constraints. They analyze data requirements, normalize data models, and optimize database performance.

Database Development: They develop and write the code to create and modify database objects, such as tables, views, stored procedures, functions, and triggers. They use programming languages like SQL (Structured Query Language) and other database-specific languages.

Data Modeling: They create logical and physical data models that depict how data is organized and stored within the database. They work with stakeholders to understand business requirements and translate them into efficient data structures.

Data Migration: They plan and execute data migration processes to transfer data from one system or database to another. This involves mapping data fields, transforming data formats, and ensuring data integrity during the migration process.

Query Optimization: They optimize database queries and SQL code to improve performance and efficiency. They analyze query execution plans, index usage, and database statistics to identify bottlenecks and make necessary adjustments.

Database Security: They implement and maintain database security measures to protect sensitive data. This includes defining user roles and permissions, implementing encryption, and ensuring compliance with data privacy regulations.

Database Maintenance: They perform regular database maintenance tasks, such as backup and recovery, monitoring database performance, applying software patches and updates, and managing database growth.

Troubleshooting and Debugging: They identify and resolve database-related issues, such as data inconsistencies, performance problems, or system errors. They use diagnostic tools, logs, and debugging techniques to investigate and address issues promptly.

Collaboration with Application Developers: They work closely with application developers to ensure proper integration of databases with software applications. They provide guidance on database-related requirements, assist with data access and manipulation, and troubleshoot database-related issues in the application layer.

Data Quality Assurance: They ensure data integrity and quality by implementing data validation rules, data cleansing processes, and data governance practices. They perform data audits, identify and resolve data inconsistencies or anomalies, and maintain data documentation.

These tasks may vary depending on the specific organization's needs and the database management systems used (e.g., Oracle, MySQL, SQL Server, etc.). Database developers collaborate with other IT professionals, stakeholders, and end-users to ensure effective database design and usage in support of the organization's goals and objectives.

What are database developer skills?

Database developers require a specific set of skills to effectively design, develop, and maintain databases. Here are some key skills that are typically associated with successful database developers:

Database Management Systems (DBMS): Proficiency in one or more DBMS platforms such as Oracle, MySQL, Microsoft SQL Server, PostgreSQL, or MongoDB. Knowledge of the specific database technology, its features, capabilities, and syntax is crucial.

SQL and Database Query Languages: Strong command of SQL (Structured Query Language) and understanding of database query languages. Ability to write complex SQL queries, optimize query performance, and manipulate data efficiently.

Database Design and Data Modeling: Expertise in designing database structures, normalizing data models, and creating efficient database schemas. Familiarity with data modeling techniques and tools such as ER diagrams, UML, or entity-relationship modeling.

Data Integration and ETL: Experience with data integration processes, Extract-Transform-Load (ETL) methodologies, and tools like SSIS (SQL Server Integration Services) or Informatica. Ability to integrate data from various sources, transform it for storage and analysis, and ensure data quality.

Query Optimization and Performance Tuning: Proficiency in optimizing database queries, index usage, and database performance. Knowledge of techniques like indexing strategies, query plan analysis, and query rewriting to improve performance.

Database Administration: Understanding of database administration tasks, including backup and recovery, database security, user management, and data integrity. Knowledge of database administration tools and practices to ensure the smooth operation of database systems.

Programming and Scripting: Familiarity with programming languages used in database development, such as SQL, PL/SQL, T-SQL, or Python. Ability to write scripts and stored procedures to automate tasks, implement business logic, and enhance database functionality.

Data Security and Compliance: Understanding of data security principles and best practices. Knowledge of data privacy regulations, encryption methods, and security controls to protect sensitive data.

Troubleshooting and Debugging: Strong problem-solving and debugging skills to identify and resolve database-related issues. Ability to analyze error logs, diagnose performance problems, and implement solutions effectively.

Collaboration and Communication: Effective collaboration and communication skills to work with cross-functional teams, stakeholders, and end-users. Ability to understand and translate business requirements into technical solutions and communicate complex concepts to non-technical stakeholders.

Additionally, database developers should be detail-oriented, have strong analytical and critical-thinking abilities, and be able to adapt to evolving technologies and industry trends. Continuous learning and staying updated with advancements in database technologies are also important to enhance skills and knowledge in this field.

We use cookies to offer you our service. By continuing to use this site, you consent to our use of cookies as described in our policy