SQL Database Developer Job Description
SQL Database Developer Duties & Responsibilities
To write an effective SQL database developer job description, begin by listing detailed duties, responsibilities and expectations. We have included SQL database developer job description templates that you can modify and use.
Sample responsibilities for this position include:
SQL Database Developer Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for SQL Database Developer
List any licenses or certifications required by the position: SQL, MCSA, CE, IAT
Education for SQL Database Developer
Typically a job would require a certain level of education.
Employers hiring for the SQL 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, Engineering, Technical, Education, Business, Information Systems, Information Technology, Software Engineering, Mathematics, Statistics
Skills for SQL Database Developer
Desired skills for SQL database developer include:
Desired experience for SQL database developer includes:
SQL Database Developer Examples
SQL Database Developer Job Description
- Supporting Daily Jobs Containing ETL Packages
- Server and database level security
- Population and Refresh of Data Cubes
- Review and optimize the views, stored procedures, indices and scripts
- Integrate and support data requirements from new and existing applications
- Maintain, update and debug the various reporting applications
- Create custom reports as needed
- Develop and optimize T-SQL code, including database scripts, triggers and stored procedures for web based applications
- Develop Microsoft SQL Server SSIS packages to implement ETL requirements
- Database performance monitoring, SQL tuning and analysis, troubleshooting, and data concurrency analysis
- Deployment, monitoring and maintenance of all database environments (OLTP/OLAP) which are high performing and highly available
- Implementing capacity planning best practices and monitoring
- Participating in planning, implementation, and maintenance of all aspects of database disaster recovery
- Keeping the database performance within best practices
- Continuing to expand systems and database documentation when architecting or automating new features
- Building / deploying with automation and configuration management policies and scripts
SQL Database Developer Job Description
- Plan and conduct high quality full-life cycle usability engineering programs for a specific product/line including user requirements gathering and validation and design evaluation
- Coordinate and track implementation of recommendations among designers and developers
- Independently carry out all aspects of usability research, including planning, justification, recruitment, logistics, conducting evaluations, analyzing results, documenting issues, and proposing and prioritizing recommendations
- Coordinate with product teams to gather requirements and to ensure UI standards are understood and followed
- Deliver UI recommendations in the form of documentation, page designs, story-boards, or a moderate level of prototyping
- Champion UCD principles to developers and product managers
- Co-author portions of UI Standards
- A university degree in Information Technology or several years of comparable job experience
- The willingness to learn data visualization and reporting tools such as MS Power BI, Tableau, SAP Business Objects and other tools, as needed
- Create database queries/ services that handle massive amount of data
- Must not have traveled outside of the United States for more than 180 days in the last five years
- Quantifiable experience with any scripting or programming in object-oriented language
- Experience working with data analytics methods and techniques
- This position requires strong technical expertise and excellent communication skills at all levels
- Proficiency with MS SQL programming with a minimum of 2 years of experience
- Experience with Data Warehouse and ETL processes implementation
SQL Database Developer Job Description
- Perform database Performance and Tuning
- Drive automation of installation, configuration, monitoring, operational and support tasks for Databases
- Assist in development of systems and procedures affecting database management, design and maintenance
- Participate in product evaluations, design review sessions, data requirement meetings and consulting with application development products
- Advanced level of writing stored procedures, reading/writing queries
- Maintain and enhance the existing stored procedures, functions and scripts
- Create and maintain documentation for projects
- 80% spend on database/Back-End and middle tier development & 20% on Front-End development
- Design and implement data warehouses for Business Intelligence
- Design and implement reports and reporting dashboards using Business Intelligence Tools
- 3+ Years of experience in developing enterprise products
- Should have strong coding/programming skills in Java [core and related technologies]
- Good hands on experience in Relational Databases (SQL Server or Oracle)
- Experience in SOAP/Rest Web Services is important
- Experience in HTML/JSP/JavaScript/CSS [front-end] is required
- Knowledge of OOPS, concepts of Object Oriented design
SQL Database Developer Job Description
- Create ETL scripts to load data between systems
- Participate in architecture and requirements reviews
- Develop and maintain documentation regarding database architecture
- Verify data integrity during the testing process
- Deploy and manage database schema changes
- Monitor and maintain core ETL processes (T-SQL/SSIS)
- Work closely with senior database developers to document requirements, design technical solutions and attend project workshops and meetings
- Develop changes in T-SQL and SSIS for both “business as usual” and project work streams
- Work collaboratively with teams to construct and manage optimized data structures
- Develop and maintain server objects
- Ability to design complex modules and components also addressing nonfunctional requirements in the designs
- Authoring Low Level Design documents
- Understanding of Secure coding practices and vulnerabilities
- Excellent analytical, problem-solving skills and ability to learn and adapt to new software techniques quickly
- Typically may have a Bachelor Degree or global equivalent experience in an IT/CS
- Has experience with MS SQL Server suite of products like SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS)
SQL Database Developer Job Description
- Complete work assigned and assist with projects
- Work with application developers and business analysts to develop data for new applications
- Assist DBA in structure design of OLTP systems the Data Warehouse
- Manage replication of data across multiple systems
- Write data access web services in .Net for communication between live transaction systems
- Assist in writing reports using MS Reporting Services
- Assist in upgrade of databases to new versions and hardware
- Technical Support – Formulate policies, procedures, and standard relating to database management, and monitor transaction activity and utilization
- Assist in the maintenance and administration of several production SQL Server databases
- Work with other engineers to troubleshoot, repair and performance tune databases
- Experience in Database Backup, Recovery and Disaster Recovery procedures
- Experience in gathering and documenting requirements for databases, , data analysis use cases
- Extensive knowledge & experience (3+ years) with T-SQL
- Bachelor’s Degree and a minimum of 2 years of relevant IT experience OR a Master's Degree OR a High School Diploma and 6 years of relevant experience
- A bachelors degree in Computer Science or related field or completion of a technical training program in software development programming language and four years related experience
- High school diploma or GED and six years business experience will also qualify