Get AI-powered advice on this job and more exclusive features.
Want to make an impact? We offer that. Due to continued growth, we are currently hiring a Senior Database Administrator to join our team.
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.
Are you intrigued? Do you want to learn more?
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
emagine is an Equal Employment Opportunity Employer; we value bringing together individuals from diverse backgrounds to develop innovative solutions for our customers.
#J-18808-Ljbffr