Developer, Database Job Description
Developer, Database Duties & Responsibilities
To write an effective developer, database job description, begin by listing detailed duties, responsibilities and expectations. We have included developer, database job description templates that you can modify and use.
Sample responsibilities for this position include:
Developer, Database Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for Developer, Database
List any licenses or certifications required by the position: SQL, MCSA, II, ITIL, OCP, IAT, SDK, AWS, PKI, MCSE
Education for Developer, Database
Typically a job would require a certain level of education.
Employers hiring for the developer, database 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 Developer, Database
Desired skills for developer, database include:
Desired experience for developer, database includes:
Developer, Database Examples
Developer, Database Job Description
- Provide cluster and client administration services for a Linux cluster and Linux workstations including system specifications, software installation, and network configuration based upon research user needs
- Building and designing data access objects (stored procedures, universes, SQL statements) for reporting
- Architect and develop database warehousing solutions that pull from a variety of sources
- Design, install, monitor, maintain, and performance tune databases while ensuring high levels of data availability
- Partner with M&A team members to automate client deliverables and make data available for analysis
- Validate technical specifications
- Participate in requirements analysis and project plans to allow for successful implementation of systems
- Ensure new and existing applications are developed using continuous integration with automated unit and integration tests
- Research, analyze and identify architecture
- Respond to support requests associated with business information systems and web services development
- Other high level languages (Java, Python) would also be desirable
- Perform database diagnostics, query optimizations, performance tuning and monitoring
- Perform intensive back-end database testing and analysis utilizing functional requirements, use cases and test plans
- Report defects found and verify fixes implemented as a result
- Create and operate complex database release packages
- Perform junior DBA tasks
Developer, Database Job Description
- Design and develop data components- stored procedures, functions, views, indexes
- Working knowledge in the insurance and financial business
- Act as a liaison to the DBA team
- Construct database software per requirements and design while maintaining adherence to source/build control procedures
- Creation and maintenance of technical and process documentation
- Assist with Data ETL from multiple formats for database consumption including, but not limited to, xls, pdf, doc, csv, txt and others
- Work independently to solve analytic, theoretical, and technical problems
- Develop and maintain system, architecture, and Biomechanics research data, including written justifications and written requirement evaluation
- Develop technical specifications including the design of hierarchical, relational, and or multidimensional databases
- Develop and maintain application and data store for the storage, preservation, and use of research data including implementation of requirements and specifications, coding, testing, assessing application usability, assessing application / database performance, and preparing written documentation to industry best practice documentation
- Must hold a current Information Assurance DoDI 8570.01-M Information Assurance Technology (IAT) Level II certification(s)
- Oracle PL/SQL a definite plus
- Experience in database development such as DB2/Sybase/SQL/Stored Procedures (Must Have)
- Strong knowledge of XML/SQL/ Perl/Perforce/KSH Script (Must Have)
- Strong knowledge in batch processing concepts and development like Unix/Autosys/ETL (Must Have)
- Working knowledge in User Interface development
Developer, Database Job Description
- R-build Budget Planning and Forecasting (BPF) application to integrate with company changes
- Produce ad-hoc queries and develop reports to support technical needs
- Development and maintenance of the database stored procedures, views and functions for hosted and installed applications
- Ability to troubleshoot and debug existing databases and provide technical field support
- Incorporate design and peer code review feedback into deliverables
- Read and understand reversed engineered data models
- Participate in the development of new data models, analytic processes and construction of Operational Database and Data Warehouse architectures
- Coordinate and facilitate requirements, analysis, design and development of database objects and reports as necessary (tables, procedures, functions, etc…)
- Improving and streamlining the processes regarding data flow and data architecture to improve data accuracy, viability and value
- Communicate to business customers, technical teams and leadership in a consistent manner making complex technical issues and solutions clear, simple and understandable
- Strong with scripting language such as Perl/Python and Unix / K-Shell, Java is a big plus
- Experienced in Agile development process
- SQL, BI, DB2, Sybase, Unix
- Degree in Computer Science, or other numerate dicipline
- Extensive Database experience, pref
- Commercial IT Experience
Developer, Database Job Description
- Analyze, design, implement, and maintain SQL Server objects
- Have considerable knowledge in the different levels of locking, blocking and deadlocks and be able to write T-SQL code that avoid these situations
- Engage subject matter experts and gain an understanding of the data and underlying table structures
- Support and troubleshoot issues
- Work with external resources on large projects
- Work with other internal technical personnel to troubleshoot issues and propose solutions
- Support compliance with data stewardship standards and data security procedures
- Build our a large scale Oracle database with setup of ETL using Informatica
- Build out a Redshift reporting layer on AWS with real-time data transfer between Oracle and AWS
- Design and development of complex ETL procedures using tools such as Informatica
- Experience in database refactoring
- Experience with metadata driven database solutions
- Experience with Administration of related services such as Jira, Confluence, Bitbuket
- At least 4 - 6 years’ experience in data/dimensional modeling, Information architecture, ETL, deployment and administration to support various data warehousing projects
- Demonstrated expertise in supporting large-scale projects, including setting data warehouse strategy, database standards and processes
- Hands on experience with building ETL, queries, data warehouse, data marts, and cubes
Developer, Database Job Description
- Perform Microsoft SQL Server activities like monitoring, troubleshoot and resolve database problems
- Proficient in creating stored procedures and complex SQL queries
- Ensures research and innovation at all levels of the software development process
- Works harmoniously in a cross-functional team comprising managers, supervisors, business analysts, systems personnel, network staff, and other developers in ensuring the delivery of software solutions as planned, within set budget, and timely
- Functions as technical architect and Subject Matter Expert (SME) on enterprise related software systems
- Performs the role of the principal designer responsible for complex systems and their subsystems employing deep knowledge of current technology and tools, relevant systems that are already existing
- Works with agency clients and ETS personnel to determine and state highly complicated business requirements and processes
- Acts as a coach or mentor to junior software developers
- Performs administrative duties some project management tasks
- Cooperate with software development group to support and improve production operations and process and for software upgrades
- Practiced in the principles of ETL (Extract, Transform, and Load)
- Trained in relational database modeling and normalization
- Effective problem solving skills, and ability to analyze existing systems and ascertain users’ needs, and translate into clear proposals and plans
- Must have the ability to work multiple projects with multiple deliverables
- Must be proactive and be able to work both independently and collaboratively with staff in the IT&S division, internal customers and external vendors
- Excellent written and oral skills, including the ability to effectively communicate with internal customers and vendors, in a technical and non-technical manner, including communicating technical information to non-technical users