What are the responsibilities and job description for the Database Analyst position at Sanrose Information Services Inc.?
Job Details
THIS IS AN ONSITE WORK POSITION
Position: Database Analyst
Education: Bachelor s Degree in Computer Science, Management Information Systems (MIS) or other technology related field.
Required Experience:
1. Experience as a Database Administrator with Oracle, PL/SQL
2. Experience with Oracle 19c Multi-Tenant Architecture and database infrastructure design on RAC Databases.
3. Experience Red Hat Linux & Oracle Linux Operating Systems.
4. Experience in following processes and procedures to standardize Database installations and configuration.
5. Experience automating, scripting, and streamlining processes for efficiency and accuracy utilizing Unix shell scripting or other scripting tools.
6. Broad experience in the art of performance tuning, utilizing OEM or third-party tools to finely tune objects and queries in Oracle 19c.
7. Comprehensive understanding of Oracle backup methodologies
8. Experience with setup and scheduling of RMAN backups as well as successful database restores.
9. Monitor alert logs, OEM and system alerts, acting on the results.
10. Willingness to participate in after-hours Production support.
11. Proficiency in Linux, Unix, Java, and DBA
12. Understanding of production environments, technical support, and troubleshooting
13. Knowledge of Automatic Storage Management (ASM)
14. Experience with Oracle Exadata
15. Experience working in UNIX operating system
16. Ability to write simple to complex Linux/Unix shell scripts and Perl scripts
17. Strong knowledge in Unix/Linux System administration,
18. Ability to work independently and to resolve complex Oracle issues
19. Experience with data pump and working knowledge to use expdp and impdp.
20. Ability to effectively diagnose, isolate, and resolve complex problems pertaining to data infrastructure
21. Ability to write, SQL, PL/SQL, Oracle Stored Procedures, Functions, Packages and Database Triggers
22. Ability to Tune Oracle SQL and PL/SQL performance
23. Experience in logical database design and data models
24. Understanding of the software development lifecycle process
25. Practical experience in monitoring and tuning a database to provide a high availability service
26. Experience with Oracle Enterprise Manager (OEM).
27. Knowledge of data privacy and protection initiatives
28. Strong communication and collaborative skills
29. Excellent verbal and written communication skills
Preferred Experience:
1. Excellent working skills with Oracle Exadata
2. Experience with SQL performance tuning and database architecture.
3. Experience in converting non CDB databases to CDB
4. Experience in working with Informatica
No phone calls please. Apply only via e-mail. No visa sponsorship provided at this time.
