SQL Database Job Description
SQL database
provides support of maintenance plans (including DBCC), backup, recovery, and refresh of development SQL Server databases.
SQL Database Duties & Responsibilities
To write an effective SQL database job description, begin by listing detailed duties, responsibilities and expectations. We have included SQL database job description templates that you can modify and use.
Sample responsibilities for this position include:
Support MS SQL Server databases – provide 24X7 support for MS SQL Server environment including upgrade, patches, troubleshooting, cloning, and working with application teams and business customers
Troubleshoots and problem-solves SQL development and SQL server production issues
Provide database support to users and application developers by researching database problems, conducting SQL reviews, and developing queries
Create and automate the monitoring functionality in SQL to identify potential problems and provide proactive solutions
Manages SQL server security
Creates, sets-up and monitors all SQL server jobs
Responsible for installing the SQL Server database instances in all environments including but not limited to development, QA and Production
Responsible for supporting the SQL Server databases and ensuring their performance, availability, security and recoverability
Responsible for performing database monitoring and working with development teams throughout the project lifecycle on recommendations on database index optimization and SQL query design
Participate in developing database objects including tables, triggers, stored procedures, and views incorporating business rules into the database objects when possible
SQL Database Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for SQL Database
List any licenses or certifications required by the position: SQL, MCITP, MVP, MCTS, IAT, MCSA, II, DBA, MS, MCDBA
Education for SQL Database
Typically a job would require a certain level of education.
Employers hiring for the SQL database job most commonly would prefer for their future employee to have a relevant degree such as Bachelor's and University Degree in Computer Science, Education, Technical, Engineering, Information Systems, Information Technology, Business, Administration, Design, Technology
Skills for SQL Database
Desired skills for SQL database include:
Replication
High Availability options for SQL Server
Clustering
Indexes
SQL
Backups
Index management
Recovery models
Restores
DBCC commands
Desired experience for SQL database includes:
Extensive knowledge of T-SQL, MDX, and XMLA
Experience with release management and code review
Skilled in Relational Database Design Theory
Proficient with Windows Server 2008 / 2012
Able to generate reports in short notice using tools like SSRS, Visio, Spreadsheets (or similar) and explain solutions and explain data
Develop and run maintenance routines to ensure that database performance is as expected
SQL Database Examples
1
SQL Database Job Description
Job Description Example
Our innovative and growing company is searching for experienced candidates for the position of SQL database. If you are looking for an exciting place to work, please take a look at the list of qualifications below.
Responsibilities for SQL database
- Responsible for SQL databases full lifecycle including installation, configuration, and maintenance, and decommissioning
- Ensures availability and performance of databases
- Creates both the logical and physical data models
- Proactively monitors the database systems to ensure secure services with minimum downtime
- Implements data models and database designs, data access and table maintenance codes
- Pro-actively monitor the database systems to ensure secure services with minimum downtime
- Responsible for improvement and maintenance of the databases to include Deployments and upgrades
- Responsible for security and non-security patches based on company approved maintenance schedules
- Seek policies and practices that maximize uptime due to 24x7 nature of our business and the highly visible effect of unplanned and planned outages
- Participates in cross-team and cross-project implementations
Qualifications for SQL database
- Desire to grow in SQL knowledge that of other disciplines
- Experience as an application support resource
- Windows SQL Server 2008 & above experience
- Microsoft Windows Server 2008 & above experience
- Microsoft Windows Clustering experience
- Log shipping and Mirroring experience
2
SQL Database Job Description
Job Description Example
Our growing company is hiring for a SQL database. 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 database
- Install, maintain, and troubleshoot Microsoft SQL Server
- Participate in software application design and SQL server installations and upgrades
- Performs optimization, encryption, backup, and in-depth knowledge of database programming to create stored procedures, SQL statements, indices, Implements and documents database administration best practices
- Ensure SQL agent jobs, scheduled tasks and services run successfully
- Works with application administrators to ensure that all applications are functioning properly and resolves all database issues
- Makes recommendation for hardware upgrade based on system performance and forecasted growth
- Responsible to coordinate, manage, and perform off hours system updates and break/fixes
- Helps to provide assistance to clients as required for database design, implementation, and troubleshooting
- Perform general database administration duties
- Responding to database related alerts and escalations and working with support groups to come up with strategic solutions to recurring problems
Qualifications for SQL database
- SQL Coding and Developing skills
- Can give expert advice and lead others to perform
- Level 4 Repeated and successful experience
- Can perform without assistance and direct others in performing
- Level 3 Some experience
- Can perform with assistance
3
SQL Database Job Description
Job Description Example
Our company is hiring for a SQL database. If you are looking for an exciting place to work, please take a look at the list of qualifications below.
Responsibilities for SQL database
- A minimum of ten (10) years of combined and demonstrated database administrator experience with Microsoft SQL server*, while the resource was tasked with the following responsibilities
- Assist in the requirements analysis, design, development of SQL code and structures
- T-SQL script tuning and development
- Migration and execution of SQL stored procedures and scripts
- SQL Server environment maintenance
- Installing / configuring new SQL Servers
- Applying SQL security patches each month
- Establish and implement SQL procedures and standards
- Ensure availability, quality and performance of databases to support business requirements
- Monitor and review scheduled jobs and other processes
Qualifications for SQL database
- At least 5 years experience in Technical Expertise - Database Administrator (MySQL and Oracle)
- Improved the performance on Team Foundation Server by 80%
- Managed Project for Server migration
- Investigated performance issues at level of code, configuration, design and hardware
- Installed SQL Server on clustered environment, created databases
- Negotiated with customer on their Database requirements
4
SQL Database Job Description
Job Description Example
Our company is hiring for a SQL database. 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 database
- Integrate databases with software applications to improve application performance and efficiency
- Optimizes data retrievals and updates to improve performance
- Secures data in database to improve information privacy, data protection, and compliance with regulations
- Documents data, processes, and changes including capacity planning to improve quality and comply with auditing and other business requirements
- Set-up a maintenance schedule and patch/upgrade strategy including installing and testing upgrades
- Problem Management Skills – A high level of analytical skill is expected in dealing with recurring incidents and problem records
- Training and Documentation – It is expected of DBA to be able to create and develop work instructions and/or technical manuals
- Strong understanding of organizational change management and communications planning, with experience applying these techniques in mixed government and multi-contractor environments
- Manage and delegate database development and analysis efforts for a 3 - 5 person team
- Peer review and deploy scripts provided by developers
Qualifications for SQL database
- Developed batch scripts for Database backups & restore using VERITAS Net Backup
- A degree, ideally in computer science
- Well versed with writing and tuning T-SQL procedures and DTS/SSIS packages
- Physical demands include office work and the mobility sufficient to attend meetings in clinical departments throughout the Clinic
- Should have proven communication skills and experience in handling bridge calls
- Should have hands on experience in Database Clustering
5
SQL Database Job Description
Job Description Example
Our innovative and growing company is looking for a SQL database. If you are looking for an exciting place to work, please take a look at the list of qualifications below.
Responsibilities for SQL database
- Examine SQL stored Procedures and determine areas of code improvement following SQL Best Practice
- Provide SQL / database support to the application developers
- Maintains audit history of modified data such as changes in Country, Job Title, Company
- Manages Data Warehouse Marketing Infrastructure and Processes
- Installs database systems by developing flowcharts
- Provide support after hours, weekends, and holidays as needed
- Manage database availability, backup, restoration and recovery systems
- Monitor database system resources and performance
- Ensure quality data creation, presentation and data flow within our systems
- Oversee data consistency and third party interfaces
Qualifications for SQL database
- Minimum of 3-5 years of experience developing relational database applications with a primary focus on conversion of DTS packages into Stored Procedures
- Minimum of three years of experience creating scripts in a development environment, testing scripts in a quality assurance environment
- Accomplish department and organization mission by completing related tasks as needed
- Experience documenting new and existing processes updating existing documentation when changes are necessary
- Fast learner with a demonstrated ability to quickly learn technology and understand unique system requirements
- SSIS (Integration Services)