The Database Administrator (DBA) is responsible for ensuring database performance, integrity, and security. Key tasks include SQL query optimization, database migrations, backup and recovery procedures, monitoring performance, and creating documentation. This role will collaborate with development and operations teams to maintain optimal database operations.
We are seeking a skilled and experienced Database Administrator (DBA) to join our growing team. This DBA role is a ninja role; We need a detailed oriented person who can dig into a variety of system backends and help find areas of performance and reliability risks in our database infrastructure.
The ideal candidate will be responsible for ensuring the integrity, security, and performance of our databases. This role involves monitoring and optimizing SQL queries, verifying database configurations, and performing database migrations and upgrades. The DBA will collaborate closely with our development and operations teams to maintain smooth database operations and support ongoing projects.
If you want to contribute to exciting projects and make an impact in a dynamic and collaborative environment, we want to hear from you.
KEY RESPONSIBILITIES
- DATABASE OPERATIONS
- SQL Query Optimization: Review and optimize SQL queries to enhance database performance and efficiency. Identify and address bottlenecks to improve query execution times.
- Database Configuration Verification: Validate database configurations to ensure compliance with best practices and security standards. Implement necessary adjustments to optimize database settings for performance and security.
- Database Migrations and Upgrades: Plan and execute database migrations and upgrades in coordination with development and operations teams. Ensure seamless transition with minimal downtime and data loss.
- Backup and Recovery: Establish and maintain robust backup and recovery procedures to safeguard critical data. Regularly test backup integrity and implement disaster recovery strategies.
- Performance Monitoring and Tuning: Monitor database performance metrics and proactively identify areas for improvement. Implement tuning strategies to optimize database performance and resource utilization.
- Documentation: Assist in the upgrade and creation of system documentation of database configurations, procedures, and standards. Work directly with Operations Services team to draft runbooks and technical documentation of all database environments.
EXPERIENCE REQUIREMENTS
- Proven experience as a Database Administrator, with expertise in SQL query optimization, database configuration management, and database migrations.
- A strong working knowledge of how databases optimize and execute queries, with the ability to assist developers in building optimal high performing database queries, transactions, and stored procedures.
- Strong working background with MS SQL Server, and proficiency in other database technologies such as MySQL, PostgreSQL, or Oracle.
- Strong understanding of database architecture, including indexing, storage, and caching mechanisms.
- Experience with database migration tools and techniques, such as dump and restore, replication, or schema migration scripts.
- Familiarity with version control systems and automated deployment pipelines.
- Excellent problem-solving skills and attention to detail.
- Strong communication and collaboration skills, with the ability to work effectively in a team environment.
PREFERRED QUALIFICATIONS
- Certification in database administration (e.g., Oracle Certified Professional, Microsoft Certified Database Administrator).
- Experience with cloud-based database platforms (e.g., Amazon RDS, Microsoft Azure SQL Database).
- Knowledge of containerization technologies (e.g., Docker, Kubernetes) and their impact on database deployments.
Top Skills
Ms Sql Server
MySQL
Oracle
Postgres
Similar Jobs at Bounteous
The Platform Reliability Analyst ensures the health of cloud infrastructure by monitoring performance, managing incident responses, and collaborating with teams to resolve issues. Responsibilities include proactive system monitoring, coordinating outages, and conducting root cause analyses. The ideal candidate has strong communication skills and an understanding of cloud technologies to support system optimization.
What you need to know about the Dublin Tech Scene
From Bono and Oscar Wilde to today's tech leaders, Dublin has always attracted trailblazers, with more than 70,000 people working in the city's expanding digital sector. Continuing its legacy of drawing pioneers, the city is advancing rapidly. Ireland is now ranked as one of the top tech clusters in the region and the number one destination for digital companies, with the highest hiring intention of any region across all sectors.
