SQL Server Database Developer Job Description
SQL server database developer
provides agile/Scrum based Software Engineering best practices for full-stack software development (front-end: jQuery, bootstrap; back-end: Perl, Oracle SQL).
SQL Server Database Developer Duties & Responsibilities
To write an effective SQL server database developer job description, begin by listing detailed duties, responsibilities and expectations. We have included SQL server database developer job description templates that you can modify and use.
Sample responsibilities for this position include:
Proactive involvement in the development, enhancement and ongoing maintenance of .NET and SQL server based applications
Building robust, scalable and high performance solutions that meet the business requirements
Creating and executing unit testing for every new functionality being developed
Documenting functional design and technical design
Working independently in the team with ability to promote code across dev and test environments and ensuring quality code is delivered into test and production
Assisting with problem support and resolution
Troubleshoot databases to identify and correct malfunctions and other operational difficulties
Implement DoD security requirements, including the deployment of software patches/updates, Computer Tasking Orders, Public Key Infrastructure (PKI), and Data at Rest (DAR)
Create and maintain appropriate documentation related to database tasks
Serve as a subject matter expert for NHRC applications, queries, and databases
SQL Server Database Developer Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for SQL Server Database Developer
List any licenses or certifications required by the position: SQL, CE, MCSA
Education for SQL Server Database Developer
Typically a job would require a certain level of education.
Employers hiring for the SQL server 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, Information Systems, Business, Information Technology, Software Engineering, Financial Services, Business/Information Systems
Skills for SQL Server Database Developer
Desired skills for SQL server database developer include:
Agile methodology
SCRUM
SDLC
Development technologies and concepts
MVC design pattern and other OO design techniques
Newer database architectures
Oracle
PowerShell
SQL Server Analysis Services
Software development best practices
Desired experience for SQL server database developer includes:
Troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, connectivity issues, security issues
Ability to work closely with business line personnel and gain a solid understanding of their processes
This is a “hands-on” position requiring solid technical skills, excellent interpersonal and communication skills
Be a self-starter with the ability to work independently within teams
Maintain source code for database and ETL projects
Knowledge of newer MS SQL features (column store, memory tables)
SQL Server Database Developer Examples
1
SQL Server Database Developer Job Description
Job Description Example
Our company is searching for experienced candidates for the position of SQL server 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 SQL server database developer
- Provide database development assistance in creating and enhancing applications including stored procedures and update scripts
- Modify databases per requests and perform tests
- Design stable, reliable and effective databases
- Solve database performance issues and diagnose malfunctions
- Optimize and maintain legacy systems
- Ensure database programs meet reliability and performance standards
- Provide ETL support for BI/BA team and Tableau users
- Be the go-to team member for data issues
- Lead database and reporting development projects
- Design, enhance and maintain SQL Server database
Qualifications for SQL server database developer
- Working Knowledge of IBM Datastage 9.x and above ETL
- Ability to make accurate level of effort (LOE) estimates
- Experience with building and maintaining SSAS cubes preferred, but not necessary
- 8 years working experience with SQL Server 2008R2, 2012, 2014, or 2016 in developing, implementing, and supporting SQL server databases for web based applications
- Bachelor’s degree or foreign equivalent in Computer Science or related field and 5 to 7 years of experience using Microsoft SQL Server
- Experience with Azure SQL Data Warehouse a plus
2
SQL Server Database Developer Job Description
Job Description Example
Our company is growing rapidly and is searching for experienced candidates for the position of SQL server database developer. To join our growing team, please review the list of responsibilities and qualifications.
Responsibilities for SQL server database developer
- Write SQL statements
- Create or modify database objects and/or write SQL code in support of application
- Monitor and improve database performance and capacity
- Ensure that database systems are safeguarded and implement necessary security measures to ensure data integrity
- Responsible for controlling privileges and permissions to databases and for standards and design of physical data storage, maintenance, and access and security administration
- Assist with upgrading database for new version release when needed
- Syncing data across data sources or platforms
- Conduct research on emerging database and application development software products, languages, and standards in support of procurement and development efforts
- Lead a small team of developers through the development process
- Introduces and tests new technologies to continuously improve the technical capabilities of the team
Qualifications for SQL server database developer
- Bachelors and 5+ years experience (or equivalent combination)
- In-depth understanding of data management including Microsoft SQL Server permissions, recovery, security, monitoring, and data modeling
- Familiarity working with .Net Framework, C#, JavaScript, and HTML
- MUST have Lead experience - this is not as much a individual contributor!
- Expert knowledge in SQL database administration as demonstrated by no less than 6 years' experience working as a SQL Server Database Administrator
- Be able to demonstrate proficiency with tuning SQL databases for performance, reliability, and availability
3
SQL Server Database Developer Job Description
Job Description Example
Our company is hiring for a SQL server 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 SQL server database developer
- Creates project scope and timeline for small applications
- Encodes documentation using standard project templates
- Perform analysis of data structures
- Design data transformation
- Implementing reports based on the configurable data structures, filters, calculations
- Analysis of the data layer optimization
- Design and develop new database schema objects such as tables, indexes, views, stored procedures, functions, triggers, jobs, while supporting legacy database schema currently supporting production environment
- Evaluate specifications and translate them into a conceptual, logical, and physical set of architectural models and deliverables
- Select which standards will be applied to a solution
- Define how systems will be structured and constructed
Qualifications for SQL server database developer
- Experience with technologies, such as SnapLogic, Github, Confluence, JIRA is a plus
- Extensive experience writing TSQL
- Experience working in SQL Server 2016
- Experience in Monitoring SQL Server databases through agent jobs and scripts
- Good understanding of database design for Data Warehouse and OLAP
- Good understanding of database security
4
SQL Server Database Developer Job Description
Job Description Example
Our innovative and growing company is searching for experienced candidates for the position of SQL server database developer. If you are looking for an exciting place to work, please take a look at the list of qualifications below.
Responsibilities for SQL server database developer
- Excellent understanding of SDLC processes and automated tools, spanning requirements /issue management, defect tracking, source control, build automation, test automation and release management
- Ensure architecture alignment with current and future business priorities and directives
- Leverage technology advances through tactical and strategic technology solutions, reference architectures, frameworks, and components
- Ensure compliance in in-house developed, custom applications or services with control objectives to ensure continued data integrity and security, and compliance with industry, internal, and regulatory requirements
- Participate in the comprehensive design of the overall application architecture for complex business systems that primarily utilize the Microsoft .Net framework
- Participate in the development of system internal and external design specifications
- Code, compile and test highly complex programs or modules
- Help resolve production system problems
- Participate with other IT professionals to evaluate new technologies in the market and recommend cohesive direction for the IT organization
- Works in a team to maintain all SQL Server 2017 (SSIS, SSRS, SSAS, R Server, PowerBI) and open-source databases for LightStream, including setup, configuration, administration, tuning, trouble-shooting, data manipulation and backups
Qualifications for SQL server database developer
- 1+ years of SSIS,SSAS, SSRS, SQL Stored procedures development experience dealing with large volume data processing and analytics
- Be able to demonstrate proficiency with SQL Server backup, high availability and Disaster Recovery solutions
- Experience in writing code in T-SQL (Stored Procedure, Functions, Triggers)
- MCA or Degree in Computer Science or related technical discipline preferred
- Healthcare concepts and data experience is preferred
- YouTrack, Upsource, TeamCity
5
SQL Server Database Developer Job Description
Job Description Example
Our innovative and growing company is looking for a SQL server database developer. Thank you in advance for taking a look at the list of responsibilities and qualifications. We look forward to reviewing your resume.
Responsibilities for SQL server database developer
- Performs requirements gathering, business design, technical design, development, testing, and implementation
- Recommends hardware configurations as they pertain to database performance and high availability
- Creates and maintains backup and recovery plans and high availability planning
- Responsible for the organization, security and protection of the databases and data
- Provides daily operational activities such as backups/restores, application troubleshooting, log monitoring, adds, moves and changes
- Works with other Technology Team members, Product Networking and Tech Support for any application development, network plans, trouble-shooting, implementations and changes on the database servers
- Participates in the On-Call production support rotation and may occasionally be required to do work at the office during non-business or late night hours
- Maintains confidentiality of the company and its clients' proprietary information
- Support current structures
- DB development ownership (with Existing architect)
Qualifications for SQL server database developer
- Azure SQL DB and Azure SQL Data Warehouse knowledge is plus
- Expert T-SQL development skills including query optimization, stored procedures, views, functions and triggers
- SQL Server Data Tools (SSDT)
- Must have at least one year of hands-on, successful experience in actually doing the work in a SQL Server environment
- Knowledge in Informatica ETL development
- 1 year of experience in SQL Server Database Development