Overview
Skills
Job Details
Title : Database Administrator - 005
Location : Tallahassee, FL
Duration : 6 + Months
Job Type : C
Description: Preferred Consultant Knowledge, Skills, and Abilities: 2 - 8 years experience SQL Database Analyst.
The Agency s required and preferred Consultant Knowledge, Skills and Abilities include:
Skills : Intermediate SQL Database Analyst:
Required Consultant must demonstrate: (Minimum):
1. Demonstrated effective writing and documentation skills.
2. Skill in SQL Server database administration
3. Skill in working in Windows operating systems
4. Skill as a SQL developer and SQL Server Management Studio tools
5. Skill in creating stored procedures, views, and functions
6. Skill in supporting SQL Server data replication, high availability, and validation
7. Skill with SQL Server software installation, patching, and upgrading.
8. Ability to work independently and to resolve complex issues
9. Ability to effectively diagnose, isolate, and resolve complex problems pertaining to server and data infrastructure
10. Ability to write T- SQL, Stored Procedures, Functions, and Database Triggers
11. Ability to Tune SQL and T-SQL queries for performance, index maintenance and implementation, and proactively identify performance bottlenecks while providing sound solutions
12. Operational support skills, including experience with system installations, troubleshooting, migrations and upgrades
13. Knowledge of Windows and PowerShell scripting
14. Skill in logical and physical database design and data models
15. Knowledge of the software development lifecycle process
16. Practical experience in monitoring and tuning databases to provide a high availability service
17. Ability to maintain currency on tools, methodologies, and technologies related to data administration
18. Knowledge of data privacy and protection initiatives
19. Strong database security administration skills
20. Strong interpersonal skills to resolve problems in a professional manner
21. Ability to effectively communicate technical data processing information verbally and in writing
22. Knowledge of SQL Server backup/recovery technologies and processes
23. Knowledge of SQL Server Replication practices and processes
24. Knowledge of SQL Server Clusters and Failover (AG clusters and regular Failover clusters) methodologies
25. System/Application/Database development, design and/or administration
26. Developing in T-SQL or PL/SQL languages
27. Assisting application/web development teams and business area customers in the design, deployment, and development of solutions