JobTitle : Senior Oracle Database Administrator

Visa:: USC & GC only

Location:: New York, NY 10038 (Onsite) Need local with DL

Duration: 6+Months

Experience: 10+Years

Client:NYC Administration for Children's Services

JobDescription:

 Scopeof Work 

TheSenior Oracle Database Administrator (DBA) is responsible for managing andmaintaining all ACS Oracle Database environments. Day to day work includesensuring the smooth, efficient, and secure operation of Oracle databasesystems, including design, installation, maintenance,

performancetuning, security, and capacity planning, while collaborating with other teamsto meet business needs.

Thecandidate specific duties will include:

•Plan, design, install, configure, secure, maintain, and support all Oracle RAC19c database environment on Exadata and Oracle Data Guard on Disaster Recovery(Site B).

•Analyze, monitor the resource utilization, and tune the performance of all theOracle database environments.

•Administer and maintain Oracle Exadata clusters, including upgrading databasesand Oracle Grid Infrastructure.

•Validate, and implement Quarterly patches on Exadata Oracle database RACservers (Production and Development) including security updates on a regularschedule with Oracle Professional Services

•Validate, and implement Quarterly patches on Oracle data guard (Site B)including security updates on a regular schedule following the quarterly patchimplementation from Oracle Professional Services.

•Enable and Support Oracle encryption on all the database environment withOracle Key Vault.

•Assist the Unix and network security team in monitoring operating systemsecurity.

•Ensure that all changes to the environment adheres to established ChangeManagement policies and procedures.

•Maintain disaster recovery configurations for Oracle Linux systems, performperiodic disaster recovery test for the critical databases and maintaindisaster recovery documentation procedures.

•Perform Database backup and test recovery plans using Veeam Solution.

•Administer, monitor, and troubleshoot clustered server environment using OracleASM.

•Provide technical assistance to Systems development and Business Users

•Setup and monitor the scheduled Oracle batch jobs.

•Setup and monitor system alerts to provide 24x7 support and high availability.

•Liaise with Oracle, and other vendors to troubleshoot critical technical issuesand escalate based on the criticality.

•Follow communications protocol for Database outages and file incident report.

•Escalate major database issues/problems to senior OIT Management

•Respond to Service Desk tickets for technical support ensuring timely follow upand resolution.

•Maintain inventory of all database environment and software assets

•Available to work after hours and weekends as needed.

 Qualifications

 •Preferably 8-10 experience as a Senior Oracle DBA managing a large-scale Oracleenvironment with Oracle Data Guard on Oracle Linux environment.

•Experience in Shell scripting, Perl, and Python.

•Experience in supporting and troubleshooting networking services and protocolsto support Linux environment i.e. TCP/IP, SSL, SFTP, SSH, Send mail, etc.

•Experience in migrating database to cloud environment (AWS, Azure, or OracleCloud) is a big plus.

•Experience in supporting Oracle WebLogic, and Oracle RDBMS in Oracle Linuxoperating systems.

•Knowledge of approaches, tools, and techniques for recognizing and resolvingtechnical (software, application) problems

•Strong interpersonal skills, problem solving skills, and customer serviceskills.

•Ability to multitask and perform in a high-paced/high-pressure environment.

•Ability to work independently or within a group to solve complex problems.

•Ability to communicate with different levels of the organization.

•Strong team player with service-oriented attitude and customer focus