SQL Developer Job Description
SQL developer
provides 24 hour a day 365 days a year daily problem resolution and support of SQL Server 2008R2, SQL 2012-2016.
SQL Developer Duties & Responsibilities
To write an effective SQL developer job description, begin by listing detailed duties, responsibilities and expectations. We have included SQL developer job description templates that you can modify and use.
Sample responsibilities for this position include:
Maintain the SQL database
Help create and test SQL statements for data presentation and further automation
Setting up and monitoring routine maintenance SQL jobs and developing / maintaining an alert strategy(s) for failed jobs and database problems and/or failures
Modify / update T-SQL scripts for importing and organizing data
Manage daily / monthly data and reporting processes automated through SQL Server agent
Work closely with analysts and other department personnel in advising best SQL coding practices
Migrating SAS reporting into a SQL Server Data Warehouse platform
4 + years of implementing database systems, with at least 3 years using MS SQL, data modeling, including an understanding of all normalized forms, design and development of stored procedures, views and triggers
2 + years of integrating SQL Server solutions in .NET environments, with working knowledge of C#, ASP.NET and SOA with web services
Excellent attention to detail, ability to detect and correct problems within SQL scripts
SQL Developer Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for SQL Developer
List any licenses or certifications required by the position: SQL, MCSA, CE, MCSE, MCDBA, AWS, MVP, MCITP, MCTS, TIBCO
Education for SQL Developer
Typically a job would require a certain level of education.
Employers hiring for the SQL developer job most commonly would prefer for their future employee to have a relevant degree such as Bachelor's and Master's Degree in Computer Science, Education, Engineering, Information Systems, Information Technology, Technical, Business, Mathematics, Science, Software Development
Skills for SQL Developer
Desired skills for SQL developer include:
SQL
Higher
Microsoft SQL Server 2012
Data modeling concepts
Design fundamentals
Oracle PL/SQL packages
Procedure
T-SQL
C#
Java
Desired experience for SQL developer includes:
Ability to manage multiple projects simultaneously within time and budget constraints
Knowledge of enterprise resource planning (ERP)
Knowledge of modern JavaScript programming patterns, such as client-side MVC, dynamic resource loading, JSONP, event-driven programming
Pentaho (ETL) & Drools and others
Interface with the product application development w.r.t
Work on data acquisition, data import, data export and data management activities
SQL Developer Examples
1
SQL Developer Job Description
Job Description Example
Our growing company is searching for experienced candidates for the position of SQL 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 developer
- Develop new software programs and applications
- Plan phases of the software development life cycle (SDLC)
- Remove code script from company Web site and/or related Web applications as necessary
- Build BI-Based Reports
- Produce technical documentation, design and test systems changes accurately to insure system efficiency, integrity, productivity and maintainability
- Provide post-implementation support and develop future, iterative system releases
- Assist Analysts and Developers with the design, prototyping and preparation of software specifications and interaction designs for product features
- Develop robust, high quality software meeting the requirements of the agreed specifications and complying with the development team standards and procedures
- Assist with the preparation of test plans for the purpose of quality assurance testing software deliverables
- Establish and maintain good working relationships both within the development team and the wider organization
Qualifications for SQL developer
- Knowledge of an Agile-related development process
- Will be using SSAS, SSIS & SSRS
- Passionate about Software Development and building design-led software
- A thorough understanding of Tables, Stored Procedures, Indexes, Transactions, Views
- Knowledge on Data integrity and database design is a plus
- Ability to adapt to a rapidly changing dynamic environment
2
SQL Developer Job Description
Job Description Example
Our company is looking for a SQL 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 developer
- Knowledge of advanced SQL programming concepts like CTE (Common Table Expressions)
- Minimum 5 years of experience with Microsoft SQL Server Integration Services (SSIS) or equivalent ETL platform
- Proven ability to analyze, document, and reverse engineer any type of SQL based applications and processes
- Make recommendation on how to rewrite, modify, redesign SQL based application and processes based on analysis
- Setting up database drive optimization for highly effective I/O usage
- Setting up security access and maintain auditable records
- Provide production support for existing reporting
- Provide production support for existing database systems
- Work closely with various data source contacts to resolve production issues or implement production changes
- Design, Build and manage the data warehouse
Qualifications for SQL developer
- Must be able to work effectively as an individual and in a team environment
- Must have experience in a workflow process tool like JIRA
- ETL Stored procedures
- Work with the Architects to ensure best practice data warehouse design
- Bachelor's degree or equivalent knowledge from schooling and years of experience
- The ability to work/query across many databases/servers
3
SQL Developer Job Description
Job Description Example
Our company is growing rapidly and is hiring for a SQL developer. To join our growing team, please review the list of responsibilities and qualifications.
Responsibilities for SQL developer
- Create, modify and test various SQL queries, stored procedures and views for obtaining data from diverse source systems and platforms
- Assist in the roll-out of new SQL based applications, problem fixes, and enhancements of software
- Follow Microsoft SQL and database best practices to improve the operational reporting environment while focusing on resolving problems raised by team members, stakeholders and end users
- Implement ETL and other data movement requirements using SQL and Microsoft SSIS
- Develops original and/or complex code in T-SQL
- Design and develop new SQL code as part of an ETL process
- Improve SQL procedures, Window services / .NET programs which transform and load data
- Develop stored procedures functions using T-SQL
- Responsible for data profiling, source-target mappings, ETL development, SQL tunings and optimization, testing and implementation
- Excellent verbal and written communication skills including demonstrated ability to effectively and professionally communicate with others, including situations where you may disagree with people
Qualifications for SQL developer
- 5 years + SQL Developer experience and supporting in-house applications in a deadline driven environment
- T/SQL Analysis
- Strong ability to lead technical discussions and technical issues resolution
- Effective written and verbal communication skills analytical ability
- Be able to maintain versions and Sync different database environments
- Fine tune existing Stored Procedures and Dynamic SQL
4
SQL Developer Job Description
Job Description Example
Our company is growing rapidly and is searching for experienced candidates for the position of SQL 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 developer
- Assist with development and tuning of SQL stored procedures and functions
- Maintenance of MS SQL Databases
- A 'building quality in' mindset is critical
- Provides development estimates and participates in project planning
- Participates in designing and developing complex systems by writing Design Specifications description of framework, interfaces, services, reports, business components, and interaction between the components
- Responsible for ensuring quality delivery of code through static and dynamic testing techniques
- Minimum 2 years of experience as a Lead or Senior Developer
- Understanding of project management concepts and techniques required
- Ability to be flexible, set priorities and meet deadlines in a changing environment for self team
- Must have decision-making skills for problem identification and solution recommendation
Qualifications for SQL developer
- SQL programming, writing stored procedures, Data Modeling knowledge
- Geography Data knowledge a plus
- Relevant tertiary qualifications, IT and/or business
- Prior experience in Financial Services essential, preferably with Treasury, Finance and/or regulatory experience
- Experience with ETL (Extract, Transform and Load) processes, defining data metrics
- SQL Server and Oracle experience required
5
SQL Developer Job Description
Job Description Example
Our company is looking to fill the role of SQL developer. To join our growing team, please review the list of responsibilities and qualifications.
Responsibilities for SQL developer
- Provides task updates to peers, team leader/manager, and others, as appropriate
- Building Positive working relationships with colleagues
- Completes functional database tasks under the direction of a lead to create and/or modify new and existing stored procedures script out data manipulation language (DML) queries for ad-hoc reporting
- Collaborates with DBAs, data architect, software developers, system architects, and quality assurance to complete business initiatives in a timely manner
- Follow database development standards for Microsoft enterprise and application databases
- Document the logical and physical components of operational databases and their functionality during the course of their work
- Understand table indexing and query strategies, database objects maintenance and performance issues
- Analyze problems as assigned and provide solutions to address business needs
- Understand how assigned programs link with those of other programs and the overall system schema
- Create consistent and accurate technical and end-user documentation of implemented applications, databases and systems
Qualifications for SQL developer
- Two years of T-SQL development experience
- 6+ years of experience in developing applications working with C#, .NET, and SQL
- Strong Oracle SQL coding skills
- Experience with full application development life cycle
- Prior application development experience a plus
- Very aggresive amount of paid time off and excellent work/life balance