Job DescriptionBIICS, Inc is looking to fill a Database Administrator position. 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.
Responsibilities:- Managing and maintaining all production and non-production databases related to the Enhanced Field System (EFS) modernization project.
- Managing and maintaining the (EFS) migration process.
- Maintaining and updating the DEL website Parent Portal as necessary.
- Actively participate in meetings or other project activities to produce project deliverables.
- Producing monthly status reports that outline accomplishments and planned activities for the following month.
- Understanding the project requirements and project goals and using that understanding to produce project deliverables.
- Communicating project progress and information to key stakeholders.
- Assisting in the preparation of information for program leadership team, executive steering committee, and project management as appropriate.
- Ensuring technical direction and standards for database maintenance, access and security are being followed.
- Identifying and eliminating obstacles to solution plans, business goals or implementation. Assist in the development and implementation of contingency plans.
- Participating in conference calls with State and Federal stakeholders, as necessary.
- Researching and maintaining knowledge in database administration and possible application to the project/program.
Requirements- Minimum 8 years of experience working with various database management systems in database design, testing, implementation, maintenance, and administration of multiple platform environments.
- Experience with performing backup and recovery on database management systems, configure database parameters, and prototype designs against logical data models, defines data repository requirements, data dictionaries and warehousing requirements.
- Minimum 8 years of experience writing complex efficient queries, views, stored procedures, and user defined functions with MS T/SQL.
- Minimum 5 years of experience with MS SQL Server and SQL Server Reporting Services (SSRS) utilizing parameters, sub-reports, drill down technologies and subscriptions.
- Minimum 5 years of experience producing technical documentation related to requirements, specifications, traceability matrices, designs, or testing.
- Minimum 3 years of experience creating and maintaining reports in Azure Power BI.
- Minimum 3 years of experience developing with web applications.
- Minimum 2 years of experience working with Azure Dev Ops and Visual Studio .NET.
- Minimum 3 years of experience administering cloud database platforms, including Azure SQL Managed Instance, Azure SQL Database, and/or Azure Database for PostgreSQL.
- Expertise in aligning application strategies with data security standards and regulatory requirements.
- Proficiency with Microsoft Word, Excel and Visio. Reviews documents, including requirements documents, testing plans, development plans and architectural plans to ensure that implementation of said documents and plans will result in the system required by the user.
- 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 with cloud database platforms, including Azure SQL Database and Azure Database for PostgreSQL.
- Experience supporting high-volume transactional and analytical database workloads.
- Experience with performance engineering and database tuning methodologies.
