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