SQL 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 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
**Scope**: Experience with Microsoft SQL Server 2022, 2019 versions
SME (L3 or above only) DBA consultant with ten plus years of experience will provide enterprise services to build, maintain MS SQL-Servers and Oracle with latest version. Implement CIS security best practices and automate the build standard. Implement policy management features to leverage the product features to roll out changes seamlessly. Example: SQL 2019 or above, Oracle 19c and above.
Install, upgrade and patch both existing and new database environments and other supporting tools such as SCCM or Ansible based automation. Twice a month, requires patching both non-prod and Prod/DR environments with latest security patches available.
Implement alerts through SCOM and OEM monitoring on new build servers environment to automate DBA proactive jobs and actively monitoring. Having Windows PowerShell or Linux scripting experience is mandatory to perform the job duty.
Must have experience with ServiceNow and auto ticketing implementation for database monitoring alerts, Hygiene best practice implementation, SDLC, change control best practices. Consultant will participate 24X7 production database support (Rota based) as required.
Understanding of current support processes, definition of the to-be processes and gap analysis
Partnering with IT-Risk, CISO organization for planning and implementing security initiatives, performing vulnerability assessments, patch management, anti-virus management. Having knowledge of Qualys Scan is preferred.
Establishing process for maintaining sound backups for all database environments. Such as SQL Server Full, Differential, Log backups, RMAN backups, Export and Import dump automation.
Proactively monitor the SQL and Oracle production databases and ensure alerts are provided when they occur, take corrective action to resolve these issues, and alert the IT management team of the issue.
Consultant will follow the SDLC policies and implement such policies and procedures to mitigate future risks.
Review, hardening and securing the current databases as per CIS standards. Provide guidance for securing databases which store sensitive and/or restricted data
Implementing database security controls via CyberArk to prevent data loss/leakage or unauthorized access to databases. Manage/Enhance Database Engine Security Configuration.
Identify root cause analysis (“RCA”) of performance issues and recommend the best possible solutions. Conduct RCAs for recurring production Database Administration related problems and automation is the Key.
Must have work experience with Always on Availability Groups (AG), HA-DR environment and advance database features such as Transparent data encryption (TDE), Policy management, Resource Governor, and Extended events.
Must have experience with data platform tools such as Delphix to virtualize the database environment, dynamic data masking and DCT implementation.
Must have experience with auditing, data architecture, data warehouse Azure Purview, SQL Server and AWS - Databricks or RedShift. performance tuning, ETL - SSIS tuning for faster loads on heavy volumes of data processing
Nice to have experience with Cohesity backup appliance, F5 Load balancer to route the sessions, Backup encryption and AWS - S3 storage gateway implementation to upload backups securely in AWS cloud.
**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