Oracle Database Administrator

• Oracle DBA to be part of DBA team supporting a large OSFAA-FCCM application project.
• The Database Administrator (DBA) is required to perform Oracle database changes related to a large OCAC environment – "personalizing" it to meet the application's needs.
• Net new DB server build requirements and review project docs to ensure design specifications meet application needs.
• Advise on bank’s DB standards as required on projects (e.g. Audit processes, database access, job configuration)
• Create new databases (OCAC PDBs - CDBs)
• AWR reporting, tuning and optimization of databases.
• Updates to database schema (create, alter, or drop objects) details.
• Apply database permissions (add, modify, or delete logins, grant/revoke permissions to DB objects)
• Deploy code (stored procedures, SQL scripts)
• Setup DB traces for Performance Testing to capture various performance metrics.
• Support testing cycles (e.g. Running scripts, database backup/restores)
• Documentation updates, as required.
• Add or Alter DB parameters at session and Instance level dynamically.
• DB Links creation for PDB Duplication and for access to remote databases.
• Backup and recovery of database using RMAN tool and database flashback using GRP (Guaranteed restore point) and export and import for restoring specific objects at database level.

Required

• 7+ years’ experience in a DBA role
• Work as part of a DBA team providing the project 24/7 support through rotating shifts.  
• Strong experience and knowledge in installing and building OCAC (Oracle19c upgrades/in place upgrades and Clustered RAC installs)
• Experience in implementing Oracle Wallet TDE for data security of RAC databases.
• Experience in Advanced Compression for large tables and partitioning large tables to improve performance.
• Responsible for Network Configuration and involved in Client Server environment using TNSNames, Listener, NET configuration assistant and other configuration files.
• Use Data pump Export/Import as the Prime method for backup and copying data from one environment to another.
• Knowledge of Oracle Real Application Clusters (RAC), ASM, and Active Data Guard.
• Strong experience with AWR, ADDM reporting, SQL Tuning Advisor, SQL Trace & TKProf and optimization of Database/VLDBs.
• Proven working experience in a large highly regulated enterprise IT environment is a must.

Education:

• University Degree or a College degree/diploma is required.

GalaxE is a professional IT services firm that specializes in platform-driven solutions and the use of automation to achieve enterprise business transformation and mission-critical change for some of the largest companies in the world. Using our proprietary solution set, GxFource®, we apply machine learning techniques and predictive analytics tools as part of a broad artificial intelligence strategy that provides effective impact and data-driven business transformation.

Since its founding, GalaxE has been dedicated to advancing the benefits of technology. As we continue that legacy and look to the future, a focus on business enablement through agile, cost-efficient, and effective integration of people, process, and technology anchors our success. We revolutionize change in the costs of doing business that transform companies and their ability to leap beyond the competition.

At GalaxE we value people and are committed to diversity and inclusion where our employees are made to feel comfortable and are encouraged to be authentic. We focus on cultivating both traditional IT and non-traditional, new collar, workers through our Outsource to America®, program.

We are always looking for passionate, entrepreneurial-minded innovators and disrupters; game-changers that take ownership of the work they produce and bring it each and every day. Working with like-minded team members you will get a chance to discover, develop, and use cutting-edge technologies to transform the way we deliver creative business solutions.

Sound like you? Join us and find out for yourself what it means for you, and your career, to be part of the GalaxE team. Let’s build something, together. #WeAreGalaxE

Equal Opportunity Employer/Veterans/Disabled

Physical Requirements:

• Prolonged periods of remaining stationary at a desk and working on a computer
• Must be able to lift to 15 lbs., as needed
• Must be able to work on-site (corporate/client offices), as needed (not applicable for 100% remote roles)
• Occasionally required to bend, kneel, crouch, and reach overhead.
• Hand-eye coordination necessary to operate computers and various pieces of office equipment.
• Specific vision abilities required include close vision, the ability to tolerate fluorescent lighting, and the ability to adjust focus.

Employees must be able to perform the physical requirements of the position satisfactorily and, if requested, reasonable accommodations will be made to enable employees requiring accommodations to perform the essential functions of their jobs, absent undue hardship.

For more information, please visit https://www.galaxe.com/