Sr. Database Administrator

Business Intelligence & Informatics Consultant Services, Inc. (BIICS, Inc)•Tallahassee, FL

2d•$61 - $83

About The Position

BIICS, Inc. is hiring a Sr. Database Administrator for its Enhanced Field System (EFS) modernization project. The position is located in Tallahassee, Florida. The incumbent must live in Florida and be able to present on-site if needed. Staff are required to be off the week of Christmas and New Year unless services are required with prior approval from division leadership. The role manages production and non-production databases and the EFS migration process, and maintains the DEL website Parent Portal. It also supports project delivery through participation in project activities, monthly status reporting, stakeholder communications, and preparation of information for program leadership, executive steering committee, and project management. The administrator ensures database maintenance, access, and security standards are followed; helps identify and address obstacles and develop contingency plans; participates in State and Federal stakeholder calls as needed; and maintains knowledge of database administration practices and their potential application to the project.

Requirements

At least 8 years of experience with various database management systems, including database design, testing, implementation, maintenance, and administration in multiple-platform environments.
Experience performing database backups and recovery, configuring database parameters, prototyping designs against logical data models, and defining data repository, data dictionary, and data warehousing requirements.
At least 8 years of experience writing complex, efficient queries, views, stored procedures, and user-defined functions with MS T/SQL.
At least 5 years of experience with MS SQL Server and SQL Server Reporting Services (SSRS), including parameters, sub-reports, drill-down technologies, and subscriptions.
At least 5 years of experience producing technical documentation related to requirements, specifications, traceability matrices, designs, or testing.
At least 3 years of experience creating and maintaining reports in Azure Power BI.
At least 3 years of experience developing web applications.
At least 2 years of experience working with Azure Dev Ops and Visual Studio .NET.
At least 3 years of experience administering cloud database platforms, including Azure SQL Managed Instance, Azure SQL Database, and/or Azure Database for PostgreSQL.
Expertise aligning application strategies with data security standards and regulatory requirements.
Proficiency with Microsoft Word, Excel, and Visio.
Demonstrated experience with large-scale implementation projects.
Expert knowledge of relational database management systems and database architecture principles.
Strong performance-tuning and troubleshooting skills in complex database environments.
Experience reducing query response times and improving application performance through database optimization techniques.
Experience optimizing cloud database resource utilization and supporting cloud cost management initiatives.
Ability to analyze complex database environments and recommend performance, scalability, availability, and optimization strategies.
Experience supporting high-volume transactional and analytical database workloads.
Experience with performance engineering and database-tuning methodologies.
Must live in Florida and be able to present on-site if needed.

Responsibilities

Manage and maintain production and non-production databases related to the Enhanced Field System (EFS) modernization project.
Manage and maintain the EFS migration process.
Maintain and update the DEL website Parent Portal as necessary.
Participate in meetings and other project activities to produce project deliverables.
Produce monthly status reports outlining accomplishments and planned activities for the following month.
Use an understanding of project requirements and goals to produce project deliverables.
Communicate project progress and information to key stakeholders.
Assist in preparing information for the program leadership team, executive steering committee, and project management, as appropriate.
Ensure technical direction and standards for database maintenance, access, and security are followed.
Identify and eliminate obstacles to solution plans, business goals, or implementation, and assist in developing and implementing contingency plans.
Participate in conference calls with State and Federal stakeholders as necessary.
Research and maintain knowledge of database administration and its possible application to the project or program.
Review requirements, testing, development, and architectural documents and plans to ensure implementation will result in the system required by the user.