Database Developer Job Description
Database developer
provides performance assessment and tuning in large scale enterprise application development and/or support role, query design/optimization, perform Oracle SQL/PL-SQL tuning.
Database Developer Duties & Responsibilities
To write an effective database developer job description, begin by listing detailed duties, responsibilities and expectations. We have included database developer job description templates that you can modify and use.
Sample responsibilities for this position include:
Develop SQL queries/reports to extract complex datasets and metrics from multiple databases
Implement SQL Server best practices
Perform database design, modeling and implementation of new databases both clustered and non-clustered environments on Microsoft platforms including MS SQL Server 2005, 2008, and 2012
Will be responsible for writing advanced SQL queries, stored procedures and/or triggers, analyzing and optimizing queries including unit testing
Will design, develop, and deploy DTS/SSIS Packages to SQL Server
Provide support of mission critical systems and serves as primary point of contact for coordination and resolution of SQL Server issues with Microsoft
Develop using defined SDLC methodologies
Enterprise level T-SQL development and data modeling for OLTP databases
Develop SQL Reports
Understanding and solving business problems using Oracle and/or SQL Server database development
Database Developer Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for Database Developer
List any licenses or certifications required by the position: SQL, MCSA, II, ITIL, OCP, IAT, SDK, AWS, PKI, MCSE
Education for Database Developer
Typically a job would require a certain level of education.
Employers hiring for the database developer job most commonly would prefer for their future employee to have a relevant degree such as Bachelor's and Collage Degree in Computer Science, Education, Engineering, Technical, Information Technology, Business, Information Systems, Software Engineering, Mathematics, Design
Skills for Database Developer
Desired skills for database developer include:
SQL
T-SQL
Java
Database architecture and best practices for Oracle SQL and PL/SQL coding style and application tuning
Relational databases
Transform
C#
Extract
Python
SDLC
Desired experience for database developer includes:
Build database tools and scripts to automate repetitive tasks
Design and implement complex logical and physical Data Models
Take ownership of projects and be self-directed
Sound knowledge of SSIS and Business Intelligence Technologies
Broad exposure with DW architectures
Exposure to SSAS and Business Intelligence Technologies
Database Developer Examples
1
Database Developer Job Description
Job Description Example
Our innovative and growing company is hiring for a database developer. If you are looking for an exciting place to work, please take a look at the list of qualifications below.
Responsibilities for database developer
- Will be responsible for DBA activities such as Data Backup/Restores, Mirroring, data sharing, and backup strategies
- Have expertise of plan, execute and manage servers in Disaster Recovery situations
- Establishing and maintaining linked servers
- Comfortable with source code repositories, such as SVN (TFS optional)
- Understanding of leading Data Encryption techniques required to encrypt/ decrypt data
- Design and develop transactional databases to support business applications, ensuring system scalability, security, performance and reliability
- Design and develop analytical databases to support business intelligence applications, ensuring system scalability, performance and reliability
- Exercises independent judgment and discretion
- Incorporate industry standard security principles and ensure they are applied to all databases
- Leverages change management practices
Qualifications for database developer
- Assist with performance tuning and SQL optimization
- Prepares and supports users by conducting training and providing after hours support if needed
- The position requires a solid understanding of relational and dimensional database development and SDLC methodologies
- Education - Bachelors degree in Engineering or Science
- Communications - Strong English
- Bachelors of Science in Management Information Systems or related field
2
Database Developer Job Description
Job Description Example
Our growing company is looking to fill the role of database developer. If you are looking for an exciting place to work, please take a look at the list of qualifications below.
Responsibilities for database developer
- Report development (SQL, Business Objects, Qlikview, PERL)
- Coordinating urgent/timely data extract tasks, facilitating a ?follow-the-sun? model
- Re-build Financial Data Warehouse (Oracle platform using in-house PL/SQL based ETL) to support company changes, as its source system
- System analysis and design with focus on Data Modeling, Database migration, design and development
- Evaluate, recommend and verify enhancements in order to increase application efficiency, capacity and achieve the results requested by the end user
- Work with Data Modelers and Architects on database application design and development
- Work with BI developers to align design and development for optimal performance
- Support or partner with QA personnel to ensure appropriate testing and quality
- Troubleshoot production issues, research and suggest improvements for application performance enhancements/automation, query tuning
- Scrub, parse and sort data based on best practices, industry standards, corporate policies and research specifications
Qualifications for database developer
- Design, Development, and provide Administrative oversight of SQL Server databases
- Minimum 5 years of experience developing Microsoft SQL databases
- Microsoft Certified Database Administrator a plus
- Experience in creation and layout of systems and database objects
- Strong knowledge of extremely large database optimization practices (indexing, partitioning, ) in Hadoop and / or Vertica environments
- Sybase and DB2
3
Database Developer Job Description
Job Description Example
Our company is looking to fill the role of database developer. Please review the list of responsibilities and qualifications. While this is our ideal list, we will consider candidates that do not necessarily have all of the qualifications, but have sufficient experience and talent.
Responsibilities for database developer
- Provide administrative services including security patches for all systems being administered
- Fly on military aircraft or ride in military vehicles in the official conduct of duties of the position
- Transforming or translating complex business trends into analytic and reporting requirements
- Developing custom business reports
- Designing significant enhancements to the established data warehouse environments
- Building moderate to complex query capabilities, compiling data from multiple sources or formats
- Building tests for data integrity to ensure intelligence is consistent with business needs
- Building complex business intelligence tools, databases, methods or systems for process and data validation
- Develop technology that provides highly available data store infrastructure disaster recovery capability
- Responding to urgent Regulatory related data inquiries
Qualifications for database developer
- Proficient in Informatica or similar ETL tool
- Strong relational database skills especially with DB2
- Strong understanding of ETL processes and experience with tools such as Informatica
- Create high quality and optimized stored procedures and queries
- Experience with Power Designer or some similar modeling tool
- Familiar with lifecycle of a trade and flows of data in an investment banking operation
4
Database Developer Job Description
Job Description Example
Our company is hiring for a database developer. To join our growing team, please review the list of responsibilities and qualifications.
Responsibilities for database developer
- Participate in the ongoing development and operations of a data warehouse and business intelligence architecture that enables fact-based decision support
- Designing and prototyping new analyses, reports, applications and systems
- Develop visual database environments based on customer requirements and SME input
- Integrate and optimize 3D models and other visual assets into proprietary real-time 3D engine
- Optimize GIS data to be optimized and used in terrain generation software
- Perform quality assurance and troubleshooting checks on output
- Create/modify ERD's
- Design and develop structures and relations using database architectural standards
- Create/optimize/maintain databases, tables, constraints, functions, stored procedures, indexes, and triggers
- Generate well-performing reports as needed (clinical, financial, analytics)
Qualifications for database developer
- Knowledge and/or experience with 3rd party backup and performance monitoring tools a plus
- Exposure to new database technologies such as NoSQL, in-memory databases, graph databases and/or data grids a plus
- DevOps experience including configuration, optimization, backup, high reliability, monitoring and systems version control
- 5+ years of database development supporting OLTP and reporting applications
- Experience with VLBDs
- Extensive experience with indexing strategies
5
Database Developer Job Description
Job Description Example
Our innovative and growing company is looking for a database developer. We appreciate you taking the time to review the list of qualifications and to apply for the position. If you don’t fill all of the qualifications, you may still be considered depending on your level of experience.
Responsibilities for database developer
- Develop, enhance, code, test, debug, implement and documents complex programs for business solutions
- Creates documentation in work assignments such as program code notes and technical documentation
- Interview end-users and gather application requirements
- Design, document, create, and optimize database schemas
- Tune queries, stored procedures, and functions to improve performance
- Responsibilities include but are not limited to migrating legacy applications, assessing needs, systems development, and recommending build/buy solutions
- Writes specifications for programs of high complexity
- Perform daily production support / monitoring functions
- Schedules/Performs training of groups and/or individuals on the general use of programs developed
- Work closely with user departments in system and programmer design of new applications
Qualifications for database developer
- Experience with Alteryx, SQL Server, SSIS required
- Experience designing Data marts, Data Warehouse, Data Models using Alteryx/Wherescape and SSIS
- Expertise in relational and multi-dimensional database schemas is a must
- Advanced level of writing and reading query plans
- Experience designing Star, Snow flake Schemas and OLAP cubes
- Well versed in development Data Transformation Services (DTS) packages