Overview
emagine is a dynamic, fast-growing international consulting and technology company, founded on real-world experience, focused on custom-fit solutions. We have the proven people and expertise to complete complex projects, while delivering lasting knowledge-transfer benefits to empower our partners for the next challenge.
Due to continued growth, we are currently hiring a Senior Database Administrator to join our team.
Responsibilities
* Administer, maintain, and optimize RDBMS databases for performance, integrity, and reliability.
* Implement and manage database replication, mirroring, and high-availability configurations.
* Design and enforce robust backup and disaster recovery policies.
* Ensure database and data security in line with organizational and regulatory standards.
* Perform tuning and optimization of SQL queries and database instances.
* Conduct regular data cleansing, vacuuming, and integrity checks.
* Maintain data consistency and enforce data management best practices.
* Develop and maintain API integrations between NCSE systems and external applications.
* Support development of API integrations for NCSE Open Data Portal.
* Design, build, and maintain BI dashboards and automate reporting workflows.
* Ensure effective interaction between the database and applications including Metabase, SEAS, QGIS, Power BI Desktop, AWS Workspaces, MS Azure, AGOL, Microsoft Suite, FME, DBeaver, and SQL Developer (Oracle).
Key Requirements
* In-depth knowledge of Oracle RDBMS (11g, 12c, 19c, 21c)
* Proficient in PL/SQL development
* Experience in data modeling and schema design
* Installation, configuration, and upgrades of Oracle on various platforms
* Strong backup and recovery skills using RMAN and Oracle Data Guard
* Performance tuning using SQL optimization tools
* Security management, including data encryption and compliance standards
* Proficient in using Oracle Enterprise Manager for monitoring
* Experience with cloud infrastructure, particularly Oracle Cloud Infrastructure (OCI)
Nice to Have
* Familiarity with cloud backup and recovery procedures
* Knowledge of monitoring automation tools
* Experience with ETL processes and tools
* Familiarity with scripting languages such as Bash, Python, and PowerShell
So, are you ready to join our team? It’s important to remember, emagine is an Equal Employment Opportunity Employer; we value bringing together individuals from diverse backgrounds to develop innovative solutions for our customers.
Get notified about new Senior Database Administrator jobs in Dublin, County Dublin, Ireland.
#J-18808-Ljbffr