Developer, Database Job Description
Developer, database
provides MS SQL Server and/or Oracle Database Administration and implements, operates and maintains database assets that support IT and business services.
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:
Develop automation within the environment for SQL server deployment and updates, maintenance, custom software deployments
Provide production database administration and support integration with development members and third parties during the application development lifecycle
Database administration tasks to ensure scalability, security, performance and reliability
Provide basic system administration functions
Design and develop batch software on the UNIX platform utilizing Korn shell scripting as a wrappers to execute BTEQ/SQL, SAS and/or Perl programs
Design, implement and maintain all SQL Server Integration Services packages and ETL transformation/loads
Work closely with our team of Web and mobile application developers to develop, implement, and maintain operational databases and application data access code using MySQL and C# (ASP.NET) in an n-tier cloud hosted environment supporting online real time applications batch-oriented functions
Performs database design and integration of systems, including client/servers communication and web services
Formulate policies, procedures, and standards relating to database management, and monitors transaction activity and utilization
Perform quality control audits to ensure accuracy, completeness, and proper usage of data in tables and various support tools, such as database dictionaries
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:
Environment
Administration
Oracle and Microsoft SQL Server architecture as related to development
SQL
Version and revision control practices and procedures
LDAP
Shibboleth and Single Sign On
Business Objects
Continuous integration and SCRUM
Database Administration
Desired experience for developer, database includes:
Responsible for overall architecture of BI solution
Write and maintain data loads and ETL processes
Write and develop and maintain complex SSRS based reports
Assist developers with application designs and queries
Advocate "best practices" database management
Insure and monitor data integrity
Developer, Database Examples
1
Developer, Database Job Description
Job Description Example
Our company is hiring for a developer, database. 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 developer, database
- 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
Qualifications for developer, database
- 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
2
Developer, Database Job Description
Job Description Example
Our company is growing rapidly and is hiring for a developer, database. 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 developer, database
- 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
Qualifications for developer, database
- 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
3
Developer, Database Job Description
Job Description Example
Our growing company is hiring for a developer, database. To join our growing team, please review the list of responsibilities and qualifications.
Responsibilities for developer, database
- 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
Qualifications for developer, database
- 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
4
Developer, Database Job Description
Job Description Example
Our growing company is searching for experienced candidates for the position of developer, database. To join our growing team, please review the list of responsibilities and qualifications.
Responsibilities for developer, database
- 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
Qualifications for developer, database
- 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
5
Developer, Database Job Description
Job Description Example
Our company is growing rapidly and is searching for experienced candidates for the position of developer, database. 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 developer, database
- 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
Qualifications for developer, database
- 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