Database Developer Job Description
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:
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:
Desired experience for database developer includes:
Database Developer Examples
Database Developer Job Description
- 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
- 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
Database Developer Job Description
- 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
- 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
Database Developer Job Description
- 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
- 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
Database Developer Job Description
- 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)
- 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
Database Developer Job Description
- 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
- 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