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