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