SQL Server Job Description
SQL server
provides timely support of SQL Server environments, including after hours for those critical SQL Server instances.
SQL Server Duties & Responsibilities
To write an effective SQL server job description, begin by listing detailed duties, responsibilities and expectations. We have included SQL server job description templates that you can modify and use.
Sample responsibilities for this position include:
Monitor and address database server performance issues including running SQL profiler, identifying long-running SQL, advising development teams to improve performance, optimizing performance using techniques including indexing and schema normalization/denormalization, capacity planning, and server resource usage
Develop and maintain T-SQL components of the MIS reporting suite
Create and maintain SQL for use in in-house BI applications and dashboards
Development of SQL Server Reporting Services reports
Development of SQL Server Integration packages for importing, exporting and processing data
Supporting SQL Server mirrored databases and "always on" environments
Administer and manage Microsoft SQL databases
Administer database security and maintains logins
Assist the Application Development staff by developing efficient SQL code to access and manipulate database objects as projected in functional requirements
Solution development activities like performance testing and use case development and validation
SQL Server Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for SQL Server
List any licenses or certifications required by the position: MCITP, MVP, MCTS, SQL, MCDBA, ITIL, MCSE, MCSA, SSL, DBA
Education for SQL Server
Typically a job would require a certain level of education.
Employers hiring for the SQL server 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, Technical, Information Technology, Information Systems, Business, Administration, Design, Management Information Systems
Skills for SQL Server
Desired skills for SQL server include:
High Availability options for SQL Server
Index management
T-SQL
Indexes
Security
SQL
SSIS
SQL Server
Statistics
Backup and recovery
Desired experience for SQL server includes:
Strong, clear communication skill
Must be able to work well with all types of customers
The ability to concurrently work multiple competing projects the ad-hoc requests and questions
The ability to quickly and calmly react to shifting requirements
A burning desire to automate whenever and wherever possible
Excellent communication skills, must have an advanced English level, oral and written
SQL Server Examples
1
SQL Server Job Description
Job Description Example
Our company is growing rapidly and is hiring for a SQL server. To join our growing team, please review the list of responsibilities and qualifications.
Responsibilities for SQL server
- Review and limited update of SQL Server Reporting Services (SSRS) Interfaces to other systems
- Delivering sales and technical collateral including deployment guidance, best practices, sizing whitepapers, and reference architectures
- Providing expert technical architectural support and guidance for Microsoft solution opportunities including onsite technical workshops for customers
- Analyze credit data and publish data requests to design, develop, and fulfill, ensuring quality, compliance, and timeliness
- Participate in production operations process automation initiatives
- Produce ad-hoc reports based on customer and credit consortium data for internal and external analysis and evaluation
- Proposes technical solutions, including working with architects, new application design, process flows
- Participates in defining new architecture working with the Sr
- Provides mentorship to less experienced team members, monitoring effort and status
- As part of an agile/scrum team working with the develop team on release scripts and deployments
Qualifications for SQL server
- Source control (Especially TFS)
- Experience with VERITAS and/or Windows Clustering, SAN/disk replication products
- Programming experience with C# and VB.NET is preferred
- Installing and migrating new SQL Server Service packs and release levels
- Familiarity with software concepts such as Micorsoft Clustering, Failover Cluster Instances, Always On, Database Mirroring, TSM/TDP
- Good Transact SQL skills – ability to write and tune complicated stored procedures and views utilizing inner and outer joins
2
SQL Server Job Description
Job Description Example
Our company is searching for experienced candidates for the position of SQL server. 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
- Developing and running SQL Server Reporting Services and SQL Server Integration Services
- Accountable for the operational support and continuous improvement of the SQL estate, processes for Development and Test environments (System, Load, Performance, UAT) up to, and including Production
- Assist with SQL Server performance issues
- Experience with SQL Server transactional replication
- Manage database security, create users and set appropriate permissions and monitors transaction activity and utilization
- Develop DTS/SSIS packages to perform ETL operations from various data sources
- Other formats
- Perform data research and analysis on data and processes used to generate various letters
- Task estimation in effort hours
- Warranty support
Qualifications for SQL server
- 5 plus years' working with T-SQL
- Exposure to data warehouse models and design
- Database performance tuning (DB2 preferred)
- Should have minimum 4+ yrs of Experience on SQL Server Admin
- Should have minimum 6+ years of Experience on SQL Server Admin
- Designs, develops, and supports solutions utilizing MS SQL relational database management system
3
SQL Server Job Description
Job Description Example
Our company is growing rapidly and is searching for experienced candidates for the position of SQL server. 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
- Knowledge and experience of cloud technology such as Microsoft Azure (preferred) or Amazon AWS and SQL Server Database IaaS, DBaaS
- Knowledge of legacy SQL Server versions (2000, 2005, 20008, 2008 R2) with focus on migration
- Demonstrated ability to present formal training to a number of delegates and/or published technical SQL articles in any format (blog, white paper, internal training documentation )
- Demonstrated ability to engage in IT discussions related to availability, agility, business value, security management, High-Availability and Disaster Recovery, data protection
- Fluent in T-SQL
- Design indexes to improve the performance of existing applications
- Writing and improving T-SQL queries
- Automation, process efficiency and appropriate tooling (Code/Branch Management and Deployment/Configurations) is utilised to reduce cycle times, and improve reliability, audit and traceability for all system deployments across multiple applications
- Monitor and analyze DB activity
- Perform operational maintenances
Qualifications for SQL server
- Extensive experience with SQL Server database environments leveraging databases, tables/views, stored procedures, jobs
- Designs, develops, and supports solutions utilizing MS SQL Server relational database management system
- 6+ years of relevant development life cycle experience in systems and applications including systems/application design6
- Experience with data processes (public record, tax, census, AVMs, ) a plus
- Use of PDF libraries
- Knowledge of Italian or any main European language would be an advantage
4
SQL Server Job Description
Job Description Example
Our growing company is searching for experienced candidates for the position of SQL server. 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
- Be a hands-on Database Administrator responsible for the design, maintenance, integration and operational support for the MSSQL environment SQL Server 2008/2012/2014
- Continuously monitor performance of SQL server, application and scheduled job performance and work to improve performance establish performance baselines
- Perform Data analysis using various techniques such as SQL, Reporting tools
- Modify / update T-SQL scripts for importing data
- Develop, enhance and maintain various SQL Server databases
- Develop ad-hoc reports using advanced SQL queries
- Day to day Monitoring and managing SQL Server estate
- Knowledge and experience in a secondary enterprise database technology such as Oracle, Sybase, NoSQL
- Knowledge and experience of data ingestion, ETL/ELT processes and tools
- Integration Services and Reporting Services
Qualifications for SQL server
- Knowledge of High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server - Always On , Clustering, Failover
- Candidates must have 5 years of SQL Server experience
- Familiar with SQL Server profiler and how to diagnose its output
- Bachelor’s degree in Computer Engineering, Computer Engineering, or related field
- Minimum five (5) years’ experience in SQL Server Database Administration
- Experience in supporting development efforts in all phases of the development life cycle
5
SQL Server Job Description
Job Description Example
Our company is looking for a SQL server. 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
- Provide expert knowledge in SQL
- Maintenance of a SQL Server physical and virtual DB environment
- Installation, Administration and Maintenance of SQL Server environments
- Perform regular security audits of all databases and servers
- Troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues
- A broad awareness of storage (including replication), networking and server technologies (including virtualisation)
- Develop workflows that can handle the data integration jobs with dependencies, alerting mechanism, error handling
- Research and identify third party tools / software that improves development process
- Document best practices for database maintenance, backup and restore, performance tuning and access control
- Ensure data integrity and help to maintain and manage current data structures
Qualifications for SQL server
- 7+ Yrs on SQL Server Administration
- Knowledge of Microsoft Visual Studio 2013/2015
- Experience with design and engineer SQL Server database with other infrastructure technologies (backup tool, monitoring tool, O.S
- Experience with Other DBMS
- Proficient in scripting (SQL Scripting)
- S/he must also be proficient in physical and logical database design