Manage and maintain production and non-production databases supporting the EFS modernization initiative
Lead and support the EFS database migration process
Perform database administration, monitoring, tuning, and optimization
Execute backup, recovery, disaster recovery, and high availability strategies
Configure database parameters and ensure optimal performance and reliability
Develop and maintain logical and physical data models, data dictionaries, and data repositories
Write and optimize complex T-SQL queries, views, stored procedures, and user-defined functions
Maintain and update the DEL Parent Portal website database components
Develop and maintain SQL Server Reporting Services (SSRS) reports with parameters, drill-downs, sub-reports, and subscriptions
Create and maintain Azure Power BI reports and dashboards
Produce and maintain technical documentation (requirements, specifications, designs, testing, traceability matrices)
Ensure compliance with data security standards, governance, and regulatory requirements
Establish and enforce database standards, access controls, and security protocols
Produce monthly status reports outlining accomplishments and upcoming activities
Communicate project status and technical information to stakeholders and leadership teams
Participate in project meetings, workshops, and State and Federal stakeholder calls
Identify risks, resolve technical issues, and support contingency planning
Continuously research and apply database administration best practices and emerging technologies
Bachelor’s degree in Computer Science, Information Systems, or related field (or equivalent experience)
8+ years of Database Administrator experience across multiple platforms
8+ years of experience in database design, development, testing, implementation, and administration
8+ years of experience writing advanced T-SQL (queries, views, stored procedures, UDFs)
5+ years of experience with MS SQL Server
5+ years of experience with SQL Server Reporting Services (SSRS)
5+ years of experience producing technical documentation
3+ years of experience creating reports and dashboards in Azure Power BI
3+ years of experience developing web applications
2+ years of experience with Azure DevOps and Visual Studio .NET
2+ years of experience with Azure SQL Managed Instance
Strong experience with backup/recovery, performance tuning, and database security
Proficiency with Microsoft Word, Excel, and Visio
Proven experience supporting large-scale, enterprise-level implementation projects