Become part of a dream team at a successful distance learning college.
Job title: SQL Consultant / Administrator – Intermediate Level Role
Reports to the Business Analysis and Dispatch Manager
Unlock 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're seeking an intermediate SQL Database Administrator who excels in collaborative environments, embraces innovation, and thrives under pressure. Ideal for someone with 2-3 years of experience who is eager 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.
Responsibilities
- Configure, 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 improvement and new functionalities of the application in coordination with other applications.
- Manage improvements in reporting.
- Support users during budgetary and reporting campaigns.
- Manage relationships with the IT team.
- Prepare business requirements and ensure that documentation is up-to-date.
- Explore new reporting methods or build new reports to assist managers with their teams.
- Exposure to SSRS.
- Exposure to technical setups pertaining to SQL user creation and security permissions.
Skills
- Critical thinking
- Problem-solving
- Decision-making
- Expert level in Excel
- SQL
Expertise 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 administration
- Database clean-up logs
- Postgraduate SQL, MySQL, and SQL background
- SQL data modeling
- ETL tools (Extract Transform and Load)
- Overview knowledge of JAVA
- Power BI knowledge
Package & Remuneration
Market Related
#J-18808-Ljbffr
