SQL DBA Job Description
SQL DBA
provides DBA support on all aspects of Microsoft SQL Server including administration, backup/recovery, replication, deployment and real time production troubleshooting responsibilities on MS SQL Server 2008/2008R2/2012/2014 DB environments.
SQL DBA Duties & Responsibilities
To write an effective SQL DBA job description, begin by listing detailed duties, responsibilities and expectations. We have included SQL DBA job description templates that you can modify and use.
Sample responsibilities for this position include:
Confirm that backups have been made and successfully saved to a secure location
Check the backup failure alerts, correct the errors and rerun the backups
Maintain and troubleshoot multiple types of high availability/DR techniques such as clustering, database mirroring, Log shipping, hot standby servers, , fail over and DR testing
Exposure to High Availability technologies - Clustering
Install and configure new Microsoft SQL Servers
Optimize queries, stored procedures and server performance
Establish monitoring, backup, restore and disaster recovery
Collaborate with developers to architect DB solutions for core platform initiatives
Participate in key periodic operations tasks including high availability and disaster recovery testing, operating system and database patching, database upgrades and migrations
Provide comprehensive and clear documentation for all new database builds, redevelopments, enhancements, for standard operational procedures
SQL DBA Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for SQL DBA
List any licenses or certifications required by the position: MCITP, MVP, MCTS, SQL, MS, ITIL, IAT, II, MCSA, MCDBA
Education for SQL DBA
Typically a job would require a certain level of education.
Employers hiring for the SQL DBA job most commonly would prefer for their future employee to have a relevant degree such as Bachelor's and Collage Degree in Computer Science, Technical, Education, Business, Engineering, Information Technology, Information Systems, Administration, Mathematics, Computer Engineering
Skills for SQL DBA
Desired skills for SQL DBA include:
High Availability options for SQL Server
Index management
Indexes
Statistics
Replication
High Availability options for MSSQL Server
Recovery models
Backups
Clustering
Data Warehousing
Desired experience for SQL DBA includes:
Performs data modeling, logical and physical database design
Actively participate in discussions and workshops with other I.T
Participate in, support and contribute to a variety I.T
Work effectively with I.T
MS SQL certification
Passionate about all things database and database administration
SQL DBA Examples
1
SQL DBA Job Description
Job Description Example
Our innovative and growing company is looking to fill the role of SQL DBA. To join our growing team, please review the list of responsibilities and qualifications.
Responsibilities for SQL DBA
- Manage and maintain all aspects of data services including cleaning and preparing data for variable printing, importing data from scanning platforms into database structures, re-coding, reconciling and exporting data according to specification
- Import, manage and validate text based data files with meticulous detail
- Maintain the quality control of client data
- Develop data manipulation processes using T-SQL and SQL Server
- Review the average duration of backup, any significant changes occurred investigates on this
- Validate the backup files using restore verify only
- Monitor all backup and log history is cleaning if it is designed
- Find out the newly added databases and define the backup plan
- Experience of working within an ITIL framework and following standards and guidelines per ITIL process, SR, Incident and CR, CAB meetings
- Create Users and assign permissions based on the level of database access the user would need
Qualifications for SQL DBA
- Structured work philosophy founded on strict adherence to corporate direction and change management policy genuine appreciation for data security including 100% compliance with US laws and regulations governing data privacy
- Working knowledge of Red Gate and Idera tools
- Familiarity with Oracle and SSIS is a major plus
- 3+ years hands-on experience as an Oracle DBA on Unix/Linux based systems (incl
- Creation of Databases, Tables, views
- Memory settings, monitoring CPU usage and Disk I/O activity
2
SQL DBA Job Description
Job Description Example
Our growing company is looking for a SQL DBA. If you are looking for an exciting place to work, please take a look at the list of qualifications below.
Responsibilities for SQL DBA
- Apply Service Packs
- Experience in SQL Server up gradations and migrations to later versions
- Exposure to latest versions of SQL Server - SQL 2008 & 2012
- Experience in DBMS scripts
- Experience in MySQL database administration
- Manages technical vendors
- Provisions non-standard items
- Acts as the liaison to the "Plan" organization for introduction of new technologies
- Oversee database backup strategy and recovery procedures
- Install periodic software patches and new product releases
Qualifications for SQL DBA
- You will have appropriate Windows and SQL Server certification
- Knowledge about Windows server operating systems (2012 R2)
- Excellent time and priority management, dealing with project and operational requests
- Knowledge about ITIL processes IT Service Management a plus
- A minimum of 3 years technical experience in DBA related functions
- Some system/network administrator experience would be an bonus
3
SQL DBA Job Description
Job Description Example
Our innovative and growing company is hiring for a SQL DBA. If you are looking for an exciting place to work, please take a look at the list of qualifications below.
Responsibilities for SQL DBA
- Oversee utilization of database and system log files
- Acquires and applies intermediate knowledge of database design and management including modeling, creation and maintenance of database objects
- Performs evaluation, modification and integration functions associated with vendor supplied database software
- Ensures business continuity by developing and implementing highly available database systems and database recovery plans and procedures
- Monitor databases and perform tuning enhancements to optimize their performance
- Participate as a team-member in data management strategies
- Participate in data-sourcing, import and data validation activities
- Write and troubleshoot mid-level stored procedures and scripts
- Develop and maintain ETLs and other DB processes
- Keep databases up and running with required performances and availability
Qualifications for SQL DBA
- Professional and Technical experience on L2 level HPUX administration
- Bachelor's degree in Computer Science or related field (minimum of Bachelor’s degree is required)
- Responsible for standards and design of physical data storage, maintenance, access, and security administration
- Investigating, reviewing, applying and testing all patches and bug fixes in the database environment and providing consultation on patch management, custom interface design and operational implementation
- Managing user security and access to databases to provide controlled access environment
- Participate in testing of all database-related changes
4
SQL DBA Job Description
Job Description Example
Our company is searching for experienced candidates for the position of SQL DBA. To join our growing team, please review the list of responsibilities and qualifications.
Responsibilities for SQL DBA
- Support requests for unscheduled Database backups and restores
- Review alert log entries, concurrent errors, other log failures and output files for concurrent request
- Verify scripts and automated tasks are completing successfully
- Synchronize “Test/Development/Training” Instances with “Production” as required
- Review the latest patch releases for the installed application modules, tuning opportunities, and fragmentation
- Provides appropriate resources for business applications by performing capacity planning, workload modeling and prediction
- Ensure the database management environments are updated with current stable versions of software products
- Installation, configuration and upgrades of SQL Servers
- Monitor, optimize and report on system performance
- Manage security of databases in production and test environments
Qualifications for SQL DBA
- Should have understanding about the database audits
- Experience of other Database technologies eg Oracle is a distinct advantage
- Ability to manage multiple tasks, work in a collaborative team environment
- Participate in on-going evolution, improvement, and automation of DBA procedures
- Database Monitoring Tools (Idera, Quest)
- Strong knowledge of computer software, such as SQL, Visual Basic, Oracle
5
SQL DBA Job Description
Job Description Example
Our company is looking to fill the role of SQL DBA. If you are looking for an exciting place to work, please take a look at the list of qualifications below.
Responsibilities for SQL DBA
- Assist developers in performance tuning of SQL statements
- Code migration of all objects following established change control procedures
- Create and refresh test database instances
- Provide on call 24 hour, 7 day per week database support for production databases
- Troubleshoot, investigate, offer and execute resolution to database issues
- Monitor and report on database storage utilization
- Create and execute various ad-hoc database queries, as needed
- Responsible for planning and designing SQL Server specifications, understanding database definition, structure, and long range requirements
- Work with the development team to ensure all database objects and interactions follow company standards and best practices
- Perform maintenance related activities during scheduled maintenance windows
Qualifications for SQL DBA
- Understands Concepts Of
- Experience in patching SQL Server
- Experience with Microsoft SQL Server and Microsoft Server 2008 R2 on Dell Servers and Storage Area Networks
- Open to learn/embrace new technologies
- Experience with supporting e-commerce based systems
- SQL Server 2012 Always On Technology