Senior Specialist

Job Description (Posting).Basic Qualifications: Degree in computer science/information systems, engineering, or related field preferred or a corresponding number of years experience in technical operations or software engineering.Job Responsibilities: Good experience in Installation and Administration of Oracle database. Installation and Configuration of Oracle Real Application Cluster (RAC) databases. Hands-on experience in configuring and implementing RAC clustered database solutions using Oracle. Administers all database objects including tables, indexes, views, sequences, triggers, packages, and procedures. Monitoring free space availability of data file and adding data files. Regular check of alert logs, trace file and database jobs logs. Optimizing resource intensive query. Backing up database objects and restoring. Monitoring of performance, space utilization, disk, and memory usage. Troubleshooting database problems faced by Application developers/users/team members. Scheduling jobs using rdbms scheduler. Basic SQL Basic Linux/Unix OS knowledge Installation, configuration and maintain Oracle database software Upgrading ,migration and Patch(fix bug) oracle database software Troubleshooting problems regarding the databases alert, applications, and development tools. Maintain sound backup and recovery policies and procedures to make database available 24 7 Implement and maintain strong database security policy (create and maintain users and roles, assign privileges) Perform database tuning, Oracle instance components including SQL and PL/SQL, and performance monitoring and database maintenance Perform schema refresh non-prod with production environments Plan database growth and changes (capacity planning) Perform general technical trouble shooting and give consultation to development teams Work with Oracle Corporation for technical support Setup and maintain documentation and standards for future purpose Deployment of strong disaster recovery plans as per SLA (service level agreement) DBA should have sound communication skills with management, development teams, vendors, and systems administrators DBA should possess a sound understanding of the business Exposer of Database on Cloud (AWS/Google/Azure any one of them) is required. Additional Information: Experience with 12c,18c and 19c required. (1.) To provide support for on call escalations and doing root cause analysis of given issue (2.) To independently resolve tickets within agreed SLA of ticket volume and time (3.) To adhere to quality standards, regulatory requirements and company policies (4.) Work on value adding activities such Knowledge base update and management, Training freshers, coaching analysts (5.) To ensure positive customer experience and CSAT through First Call Resolution and minimum rejected resolutions or Reopen Cases

QualificationB-Tech

Skill (Primary)EPS-Database-Oracle