SQL Developer Job Description
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:
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:
Desired experience for SQL developer includes:
SQL Developer Examples
SQL Developer Job Description
- 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
- 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
SQL Developer Job Description
- 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
- 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
SQL Developer Job Description
- 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
- 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
SQL Developer Job Description
- 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
- 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
SQL Developer Job Description
- 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
- 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