MS SQL Server and Oracle DBA **Req number:** R4516 **Employment type:** Full time **Worksite flexibility:** Remote **Who we are** CAI is a global technology services firm with over 8,500 associates worldwide and a yearly revenue of $1 billion+. We have over 40 years of excellence in uniting talent and technology to power the possible for our clients, colleagues, and communities. As a privately held company, we have the freedom and focus to do what is right—whatever it takes. Our tailor-made solutions create lasting results across the public and commercial sectors, and we are trailblazers in bringing neurodiversity to the enterprise. **Job Summary** We are looking for a motivated SQL and Oracle DBA ready to take us to the next level! If you have strong MS SQL-Servers and Oracle experience with latest version and are looking for your next career move, apply now. **Job Description** We are looking for a **SQL and Oracle DBA** to provide enterprise services to build, maintain MS SQL-Servers and Oracle with latest version. This position will be **full-time** and **remote.** **What You’ll Do** **Oracle SME DBA must to have experience and skills:** + Ten plus years of experience with Oracle installation and setup of Oracle 21c, 19c, 12c, 11g, 10g databases. He/She should have experience with ASM, CRSCTL for HA, Flashback recovery. + Strong experience with Oracle Quarterly patches and upgrades from End of Life products (EOL) for various versions of Oracle products such as 19c, 21c or above . + Expert in High Availability technologies such as Oracle 19c RAC, multiplexing with ASM. Linux OS experience is must to expand ASM, DATA, FRA disks expansion. + Must have technical documentation of the work performed and very good team player skills. + Implement Oracle 19cc Multi- tenant, database installation, configuration and management. + Need to support 24x7 Production servers in shift basis. Must have strong experience with production DBA experience in supporting Oracle Database versions (10g, 11g, 12c, 19c, 21c). Data Guard experience to setup Physical/Standby/Snapshot Databases, Database Replication/Clone. + Data guard (DG) set up across data centers. Backup, Recovery and Restore of various Oracle versions Databases. DG Failover and failback as needed during DR test. + Experience with Oracle Grid Control & Grid Infrastructure installation and configuration. Oracle Enterprise Manager (OEM monitoring setup) for centralized monitoring. + Excellent DBA expertise with Production Database Administration, RMAN backup/recovery, Performance Tuning, Trouble-shooting, High Availability, Architecture Design, Infrastructure Analysis, Backup & Recovery and Disk Storage (ASM). + Expert in Administration and Tools including OEM, RMAN, Cold & Hot Backups , Expdp/Impdp, OLAP/Partition/RAC, TOAD, SQL*PLUS + Expert in Production Database Daily Administration (such as data loading, data processing, job scheduling via OEM, UNIX) and + Data Warehouse maintenance such as partitioning tables, creating materialized views. + Automating Database or schema level refresh in development/test environment from production backups or tape storage. + Data Security implementation via CyberArk, Firewall, User and schema management etc. + Optimizing SGA and PGA memory area based on application needs. + Experience with Automatic memory management (AMM), Automatic database diagnostic management (ADDM), Huge pages configuration for very large memory blocks. + Expert in Database Health Maintenance using Enterprise Manager, Self-developed shell scripts & methodology, Diagnostic, Tuning Pack and DBMS_ Utilities/Procedures. + Strong experience with installation, Setup, Maintenance and Upgrade of Oracle Databases RAC/stand alone in Linux OS environment. **What You'll Need** Required: + Person must have a bachelor or master degree with computer science as a major concentration. + AWS cloud certification is vital to perform hybrid cloud, public cloud and private data centers. Nice to have exposure with Artificial Intelligence and Machine Learning experience in data engineering platform. + 10+ years in banking and financial services, with a focus on IT and operations project management, knowledge of Core Banking products and payment architecture. + Agile based project management experience with any of the following functionality: Customer, conversions, deposits, Teller/Branch, Data Warehouse, cold storage, imaging, accounting, regulatory reporting, tax reporting, general ledger, Digital channels + 5+ years of supporting complex projects, and experience specifically with commercial Banking applications. Strong experience managing third party vendor relationship with Banking Vendors. + Experience in developing reports for weekly, monthly project status meeting and periodic steering committee meetings. + Experience with Cybersecurity implementation and infrastructure engineering. + Knowledge of Banking solutions and applications integrated with banking solutions such as BSA/AML, ACH payments, transaction processing, loans booking, Cash Management and Private wealth management. Broad commercial and private banking experience. Preferred: + Nice to have OFSA product experience to support OFSA databases. + Nice to have experience with 21c Container database setup and enhancements. + Nice to have experience with various RDBMS products MS SQL 2022, 2019 version databases support, and MySQL administration/support. + Nice to have experience with Oracle Financials such as Application modules include General Ledger (GL), Accounts Receivable (AR), Accounts Payable (AP) and Oracle Projects. + Nice to have experience with EMR, Glue, Amazon Quick Sight and data mesh implementation in AWS cloud **Physical Demands** + Ability to safely and successfully perform the essential job functions + Sedentary work that involves sitting or remaining stationary most of the time with occasional need to move around the office to attend meetings, etc. + Ability to conduct repetitive tasks on a computer, utilizing a mouse, keyboard, and monitor **Reasonable accommodation statement** If you require a reasonable accommodation in completing this application, interviewing, completing any pre-employment testing, or otherwise participating in the employment selection process, please direct your inquiries to application.accommodations@cai.io or (888) 824 – 8111.