SQL Job Description
SQL
provides support for SQL, SQL Express, SSRS, SSIS and MySQL, diagnoses and resolution of database problems, and configuration.
SQL Duties & Responsibilities
To write an effective SQL job description, begin by listing detailed duties, responsibilities and expectations. We have included SQL job description templates that you can modify and use.
Sample responsibilities for this position include:
Maintain and enhance existing database server centric components (stored procedures, indexes, SSIS packages, SSRS, data transfer and transformation services) for all our application platforms
Experience with a variety of reporting and visualization tools, SSRS, SSIS, SSAS and data replication
Setting up replication/redundancy and failover strategies
Develop and maintain the various database systems across the business ensuring high levels of availability (SQL Server 2008/R2, 2005)
Review database schema and ensure normalization
Carefully analyze constraints and referential integrity
Create and monitor routines to analyze, measure, and improve data quality
Perform database development tasks
Help establish standards for data formats and processes
Work with the business project lead and other development team members to develop and enhance the applications
SQL Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for SQL
List any licenses or certifications required by the position: SQL, MCITP, MVP, MCTS, ITIL, II, IAT, MCSA, MCDBA, MCSE
Education for SQL
Typically a job would require a certain level of education.
Employers hiring for the SQL 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, Information Systems, Engineering, Information Technology, Technical, Business, Mathematics, Management, Finance
Skills for SQL
Desired skills for SQL include:
SQL
High Availability options for SQL Server
Indexes
SSIS
T-SQL
Index management
Java
Oracle
SQL Server
Replication
Desired experience for SQL includes:
General knowledge of Windows 2008/2012 and hardware including RAID configurations
Exposure to usage of Checkstyle, Code Formatter, PMD and CI tools such as Hudson, TeamCity
Work with other business personnel in order to develop business and systems requirements
Develop, enhance and maintain reports for our application platforms
Participate in the development of any new platform that supports or replaces the existing systems
Improve the performance of data transfer processes between our various platforms
SQL Examples
1
SQL Job Description
Job Description Example
Our innovative and growing company is looking to fill the role of SQL. If you are looking for an exciting place to work, please take a look at the list of qualifications below.
Responsibilities for SQL
- Intermediate experience with SQL Server 2012 and higher
- Configure, deploy, and support MS-SQL Server databases using approved tools & utilities
- Ensure that nightly SSIS jobs complete successfully
- Ensure database solutions are available, accurate, secure, and developed according to business requirements
- Participate in on-line processing database and performance tuning
- Work with others in IT to build the logical database area
- Povide technical guidance during all the phases of the development process
- Proactive tuning and working with developers to insure that the database is laid out to efficiently work with the application
- Developing and maintaining database backup and recovery strategies
- Working proactively with developers and infrastructure team to develop, maintain and test a recovery strategy locally and at a disaster recovery location
Qualifications for SQL
- Prior experience in SQL based programming, database design, and development
- Experience of supporting developers and technical end users
- Experience of supporting web and commercial database applications
- A minimum of five years technical experience in DBA related functions
- Strong technical knowledge of Microsoft SQL Server 2000 to 2014
- Experience as a DBA working in medium to large organisations supporting a varied catalogue of mission critical databases supporting enterprise scale application systems
2
SQL Job Description
Job Description Example
Our company is looking for a SQL. 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
- Develop and Implement Store Procedures, SSIS packages and SSRS reports
- Perform routine monitoring, administration and maintenance of the MS SQL Server databases within the hosted environments
- Design, build, implement and maintain db schema, stored procedures, views, functions and ETL processes for data integration
- Perform triage on emerging data quality issues, implementing both short-term and long-term solutions
- Design and build Web Service methods to retrieve and present data for use and reporting scenarios
- Perform ad hoc research and data analysis
- Create and maintain PowerBI reports and queries along with other various data visualizations
- Evaluate emerging data technologies and visualization tools for opportunity and fit
- BS in Computer Science, Engineering, Math or a related field of study
- A self-starter, passionate about data and like to solve difficult problems with effective solutions
Qualifications for SQL
- Experience in doing performance tuning on large MS SQL database
- Excellent documentation skills and DBA documentation management capabilities
- Experience with VLDB an advantage
- In-depth understanding of hardware specification and configuration for SQL optimization
- SQL Server performance enhancement
- A minimum of 2 years of experience on the items mentioned above
3
SQL Job Description
Job Description Example
Our innovative and growing company is searching for experienced candidates for the position of SQL. 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
- Troubleshoot and resolve a variety of identified problems (integrity issues, performance issues, blocking and deadlocking issues, replication issues, with a high degree of success and confidence
- Demonstrated ability to compose clear and concise technical written communication ability to articulate technical information to non-technical audience and vice-versa
- Develop and maintain the various applications across the business, reports and dashboard production, CRM
- Identify, design and deliver improvements to the existing core systems
- Performance tuning, troubleshooting, writing queries and stored procedures manage user access, develop and run data import routines from external systems and test and update disaster recovery procedures as needed
- Will be responsible for developing and executing database upgrade plans an implementing and maintaining data security and integrity features
- Ensures appropriate linkages to existing databases and data processing systems and that adequate security and recovery procedures are in all data base designs
- Directs the training of user groups in the protocols involved in updating and accessing the database and monitors transactions to ensure correct usage of the database
- Improving and modifying internal processes to suit organization needs using knowledge of database task automation
- Must possess experience with obtaining or providing database metrics and audits and basic troubleshooting of Windows Servers
Qualifications for SQL
- Proficiency in Java and C/C++ a plus
- Proficiency in Unix and its standard commands and scripting
- Good understanding of DBMS concept
- Proficiency with SQL (Sybase desirable)
- Basic understanding of Java/, HTML
- Basic understanding of WebsphereTx (desirable)
4
SQL Job Description
Job Description Example
Our company is looking for a SQL. 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
- DBMS Features implementation Data Replication, high availability like clustering, Compression
- Building SSIS Packages to automate processes
- May be required to participate in a 24x7 on-call rotation
- Performs data analysis to provide management with timely and accurate information and predict future requirements
- Performs/schedules routine maintenance on databases to keep them running at peak performance
- Participates in continuous business process redesign to improve internal operations
- Troubleshoots issues and recommends solutions
- Demonstrated ability to reduce and/or prevent production defects based on the continuous root cause analysis and process improvement
- Provide day to day team leadership in product support, optimization, and maintenance
- Mentorship of more junior developers and analysts
Qualifications for SQL
- Understanding and practice of ITIL (desirable)
- Willing to work in shifts (includes Night Shift)
- Resilience - Continues to work effectively and pursue goals when faced with obstacles, periods of change and uncertainty, or resistance from others
- Expert level knowledge in SQL programming
- Management of integrations tools for existing integrations using either IBM CastIron or Dell Boomi
- Knowledge of ORACLE, Cassandra, MySQL, MongoDB desirable
5
SQL Job Description
Job Description Example
Our growing company is searching for experienced candidates for the position of SQL. If you are looking for an exciting place to work, please take a look at the list of qualifications below.
Responsibilities for SQL
- Respond to service ticket requests and troubleshoot issues as needed
- NetApp, huge plus
- Building Tables
- Create new and modify existing SSRS reports for operational reporting
- Work directly with end consumers (Actuarial, Claims, ) to analyze and solve problems
- Assist the application teams with new database development, automation, and scheduling of jobs
- Bulk data movement/ETL proficiencies are required for this position
- Provide business and technical analysis, development and documentation
- Develop detailed technical specifications and ETL documentation in collaboration with application and solution architects
- Design and develop ETL code, ETL audit control and scheduling processes
Qualifications for SQL
- Microsoft database clustering using active/passive methodology
- SQL Server 2008 (and higher) experience
- Three or more years of experience in database management and administration
- Experience using Microsoft products
- Responsible for production moves of all SQL code from development and testing environments
- Pension program