Become part of a dream team at a successful distance learning college.Job title: SQL Consultant / Administrator – Intermediate Level roleReports to the Business Analysis and Dispatch ManagerUnlock Your Potential as an Intermediate SQL Database Administrator!Ready to embark on a Learning experience? At Oxbridge Academy, we're on the lookout for an Intermediate SQL Database Administrator who thrives on optimizing performance, ensuring security, and driving excellence in our database systems.What are we looking for:We are seeking an intermediate SQL Database Administrator who excels in collaborative environments, embraces innovation, and thrives under pressure. Ideal candidates will have 2-3 years of experience and a desire to take ownership of their career.If you're passionate about creating remarkable solutions and eager to contribute your expertise to a diverse and inclusive work community, we invite you to join us.ResponsibilitiesConfigure, fine-tune, and optimize SQL databases for peak efficiency.Monitor performance, troubleshoot bottlenecks, and elevate query response times.Implement robust backup and recovery strategies to safeguard crucial data.Secure data with precise access controls, authentication, and authorization mechanisms.Uphold data integrity.Keep databases up-to-date and secure through regular updates and maintenance.Plan for scalability by tracking growth trends and suggesting optimizations.Collaborate across teams, contribute to disaster recovery planning, and automate tasks.Manage improvements and new functionalities of the application in coordination with other applications.Support users during budgetary and reporting campaigns.Manage relationships with the IT team.Prepare business requirements and ensure that the documentation is up-to-date.Look for new reporting methods or build new reports to assist managers.Exposure to SSRS.Exposure to technical setups pertaining to SQL user creation and security permissions.SkillsCritical thinkingProblem-solvingDecision-makingProficiency in ExcelSQLExpertise in SQL, deep understanding of relational database concepts, and proficiency in writing complex SQL queries. Proven experience in database design, development, and optimization, demonstrating a track record of success in managing medium to large-scale data systems. Proficiency in database management systems such as MySQL and Microsoft SQL Server, with a keen understanding of their respective features and functionalities. Familiarity with data modeling and schema design principles, enabling you to create efficient and maintainable database structures. Strong analytical and problem-solving abilities, empowering you to unravel data mysteries and optimize query performance.Knowledge of database administrationDatabase cleanup logsPostgraduate SQL, MySQL, and SQL backgroundSQL data modelingETL tools (Extract Transform and Load)Overview knowledge of JAVAPower BI knowledgePackage & RemunerationMarket Related
#J-18808-Ljbffr