Database Administrator

Overview:

Essential Functions / Responsibilities:

• Provide support, on-going maintenance, and required modifications to database applications
• already in production.
• Work with agency customers to develop and implement a process to receive data and disperse it to the appropriate internal applications, adhering to all State of Florida security guidelines.
• Assist in designing the Database Architecture and Strategic plan for agency customers.
• Provide research and analytical services for new projects as they emerge.
• Develop protocol for implementing existing and newly developed Database applications within the existing environment.
• Implement changes to existing and newly-developed Database applications when authorized and in accordance with Agency Change Management/Service Request procedures.
• Create technical documentation associated with projects upon request.
• Conduct Pilot projects and research new technologies to support current or new processes as needed.
• Create complete and accurate project documentation.
• Develop timelines as requested.
• Evaluate and recommend improvements to systems and/or processes as requested.
• Evaluate system tools and determine their usefulness to the Agency and its customer’s environment.
• Maintain accurate and detailed accounting of hours worked and tasks completed for each project.
• Mentor junior and journeymen Database Administrators.
• Work within the constraints of the Agency policies on security, privacy, and procedures.
• Support and comply with all Agency policies and procedures.
• Document work activities through Agency Change Management, Service Desk and Cost
• allocation procedures.
• Reporting for emergency duty is required as part of this position. Emergencies may occur at any time and create varying degrees of damage, human suffering, injury, death, and property damage or destruction. The NWRDC, along with many other local and state agencies, has responsibilities before, during, and/or after emergencies. The NWRDC Consultants are an important part of our emergency responsibilities. In the event of an emergency, unless Consultant is granted a temporary exemption from emergency duty, Consultant may be required to work before, during, and/or beyond normal work hours or days to perform emergency duties including, but not limited to, responses to or threats involving any disaster or threat of disaster, man-made or natural.
• Other tasks as directed by Platform Manager.

Qualifications:

• 8 - 12 years’ experience – SQL Database Analyst.
• 4 - 10 years’ experience – Couchbase Database Administrator.
• Demonstrated effective writing and documentation skills.
• Skill in SQL Server database administration.
• Skill in working in Windows operating systems.
• Skill as a SQL developer.
• Skill in creating stored procedures, views, and functions.
• Skill in supporting SQL Server data replication, high availability, and validation.
• Skill with SQL Server software installation, patching, and upgrading.
• Ability to work independently and to resolve complex issues.
• Ability to effectively diagnose, isolate, and resolve complex problems pertaining to server and data infrastructure.
• Ability to write T- SQL, Stored Procedures, Functions, and Database Triggers.
• Ability to Tune SQL and T-SQL queries for performance, index maintenance and
• implementation, and proactively identify performance bottlenecks while providing sound solutions.
• Operational support skills, including experience with system installations, troubleshooting, migrations and upgrades.
• Knowledge of Windows and PowerShell scripting
• Skill in logical and physical database design and data models
• Knowledge of the software development lifecycle process
• Practical experience in monitoring and tuning databases to provide a high availability service.
• Ability to maintain currency on tools, methodologies, and technologies related to data Administration.
• Knowledge of data privacy and protection initiatives.
• Strong database security administration skills.
• Strong interpersonal skills to resolve problems in a professional manner.
• Ability to effectively communicate technical data processing information verbally and in Writing.
• Knowledge of SQL Server backup/recovery technologies and processes.
• Knowledge of SQL Server Replication practices and processes.
• Knowledge of SQL Server Clusters and Failover (AG clusters and regular Failover clusters)Methodologies.
• System/Application/Database development, design and/or administration.
• Developing in T-SQL or PL/SQL languages.
• Assisting application/web development teams and business area customers in the design, deployment, and development of solutions.

WiredPeople provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability, or genetics. In addition to federal law requirements, WiredPeople complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.