Consultant - Database Administration

Role Overview: As a Database Administrator at Ontellus, your main responsibility will be to provide technical and functional support for various databases, focusing on Microsoft SQL Server (MSSQL) 2008 and above. Your duties will include managing database design, configuration, implementation, and maintenance, as well as application design, performance tuning, data migration, and other aspects of database administration. Key Responsibilities: - Provide primary support for third-party systems in production, test, and development environments, as well as reporting processes. - Lead activities related to database security, backups, recovery, monitoring, analysis, and optimization. - Assist end users with reporting requirements, documentation, and database design. - Write complex queries, functions, stored procedures, and triggers. - Develop technical specifications for third-party systems implementation and reporting. - Design, plan, and implement database environments with proper sizing and configuration. - Coordinate installation, configuration, troubleshooting, and maintenance of databases. - Establish and maintain database standards, policies, procedures, and change management standards. - Implement security measures, database hardening, vulnerability assessment, and patch management. - Troubleshoot and resolve issues within database environments. - Monitor and manage database health and performance using software tools. - Plan and implement database application patches and upgrades. - Define and maintain capacity plans, disaster recovery plans, and database facilities. - Train and mentor team members, monitor database environments, and ensure operational efficiency. - Work with technical analysts to configure servers and troubleshoot configuration problems. - Stay updated on technology trends and contribute to budget justifications and technical reports. Qualifications Required: - Minimum 5 years of experience as a database administrator in a production environment. - Experience with Disaster Recovery/Business Continuity plans and working in a team environment. - Bachelor's degree in Computer Science or related field or equivalent work experience. - Proficiency in MS SQL 2008+, SSRS, SSIS, VSDT, and Microsoft Office Suite. - Strong organizational, time management, communication, and problem-solving skills. - Ability to work in a team environment, demonstrate adaptability, and maintain high levels of attendance and punctuality.,