What are the responsibilities and job description for the Database Administrator (On-Site) position at Avenu Insights & Analytics?
Job Description
Job Description
Job Summary :
This client-facing technical support position involves SQL Server database script writing, software deployments, testing, troubleshooting and report maintenance for the newest unclaimed property management system used by state governments. Excellent written and oral communications skills along with strong task organization skills are required.
Key Responsibilities :
- Install, configure, and maintain SQL Server databases in on-premises and cloud environments.
- Manage database backups, restorations, linked servers, and database mail to ensure data integrity and availability.
- Develop, optimize, and maintain SQL scripts, stored procedures, triggers, views, and functions to enhance application functionality.
- Design and implement database structures, indexes, and schema modifications to support evolving business needs.
- Monitor database performance, security, and capacity planning , ensuring high availability and reliability.
- Troubleshoot database issues and provide proactive solutions to maintain system efficiency.
- Collaborate with software developers to ensure optimal database performance and seamless integration with applications.
- Implement best practices for database security and compliance , ensuring adherence to company and industry standards.
- Support internal stakeholders and state administrators with database-related queries, demonstrating strong customer service and professionalism.
- Document database configurations, procedures, and policies to streamline operations and knowledge transfer .
Perform other duties as assigned.
Qualifications & Skills :
Education & Experience
Work Environment
Physical Demands
Avenu Summary :
With the backing of four decades of public sector expertise and corporate capability, Avenu has successfully supported government services. Avenu was honored and recognized for four (4) consecutive years as a GovTech 100 Company representing the top 100 companies focused on making a difference in and selling to state and local government agencies across the United States.
Avenu is committed to helping communities thrive and brings a wealth of experience combined with innovation. Today, Avenu offers more administrative and financial support to government officials than any other organization. And with a responsive, client-focused approach, we foster partnerships that give our customers the certainty they need to accomplish more.
Avenu offers a competitive benefits and compensation package and are looking for team members who will thrive in our dynamic environment.
Avenu is an Equal Opportunity Employer. Selection for a position will be made without regard to race, religion, national origin, sex, political affiliation, marital status, non-disqualifying physical handicap, and age.