Database Administrator

RESPONSIBILITIES

• Maintain, optimize, and troubleshoot legacy Microsoft SQL Server environments
• Migrate schemas, data, and stored procedures as directed
• Design and implement backup, restore, and disaster recovery strategies across database platforms
• Collaborate with staff and vendor teams to support database operations in FHS, AWS and Azure
• Monitor database performance and ensure high availability and security
• Maintain documentation and contribute to process improvements
• Process Diagrams and Flow Charts
• Understanding the AS-IS production platforms and the processes that support the systems within the Department of Taxation.
• Understanding the Technical Requirements for the various projects supporting both legacy and projects.
• Supporting production and development database systems and supporting architecture
• Organizing and attending various Department meetings
• Write test cases, and documentation as needed.
• Assist team members document processes and procedures
• Help manage the Standard Operating Procedures for Taxation’s processes

REQUIREMENTS

• Detailed understanding of RDBMS systems like Oracle, Microsoft SQL ServerProven experience as a DBA with both SQL Server and PostgreSQL
• Working knowledge of AWS RDS, Azure SQL, and managed database services
• Proficiency in SQL, PL/pgSQL, and PowerShell
• Familiarity with database migration tools (e.g., pgLoader, AWS DMS)
• Strong understanding of data security, integrity, and compliance best practices
• Familiarity with performance tuning and query optimization
• Ability to work on ad-hoc assignments with limited guidance
• Excellent knowledge of MS Office including Outlook
• Ability to use MS Visio and Powerpoint
• Outstanding communication and interpersonal abilities
• Creativity, team player, and customer-oriented mindset