Database Analyst

V2Soft is a global leader in IT services and business solutions, delivering innovative and cost-effective technology solutions worldwide since 1998. We have headquarteerd in Bloomfiled Hills, MI and have 16 offices spread across six countries. We partner with Fortune 500 companies to address complex business challenges. Our services span AI, IT staffing, cloud computing, engineering, mobility, testing, and more. Certified with CMMI Level 3 and ISO standards, V2Soft is committed to quality and security. Beyond our work, we actively support local communities and non-profits, reflecting our core values. Join us to be part of a dynamic and impactful global company!
Please visit us at www.v2soft.com to know more .

Job Description:

• 8+ Years of experience as a Database Administrator with Oracle, PL/SQL
• 1+ year's experience with Oracle 19c Multi-Tenant Architecture and database infrastructure design on RAC Databases.
• Experience Red Hat Linux & Oracle Linux Operating Systems.
• Experience in following processes and procedures to standardize Database installations and configuration.
• Experience automating, scripting, and streamlining processes for efficiency and accuracy utilizing Unix shell scripting or other scripting tools.
• Broad experience in the art of performance tuning, utilizing OEM or third-party tools to finely tune objects and queries in Oracle 19c.
• Comprehensive understanding of Oracle backup methodologies
• Experience with setup and scheduling of RMAN backups as well as successful database restores.
• Monitor alert logs, OEM and system alerts, acting on the results.
• Willingness to participate in after-hours Production support.
• Proficiency in Linux, Unix, Java, and DBA
• Understanding of production environments, technical support, and troubleshooting
• Knowledge of Automatic Storage Management (ASM)
• Experience with Oracle Exadata
• Experience working in UNIX operating system
• Ability to write simple to complex Linux/Unix shell scripts and Perl scripts
• Strong knowledge in Unix/Linux System administration,
• Ability to work independently and to resolve complex Oracle issues
• Experience with data pump and working knowledge to use expdp and impdp.
• Ability to effectively diagnose, isolate, and resolve complex problems pertaining to data infrastructure
• Ability to write, SQL, PL/SQL, Oracle Stored Procedures,
• Functions, Packages and Database Triggers
• Ability to Tune Oracle SQL and PL/SQL performance
• Experience in logical database design and data models
• Understanding of the software development lifecycle process
• Practical experience in monitoring and tuning a database to provide a high availability service
• Experience with Oracle Enterprise Manager (OEM).
• Knowledge of data privacy and protection initiatives
• Strong communication and collaborative skills
• Excellent verbal and written communication skills

Preferred KSA's:

• Excellent working skills with Oracle Exadata
• 3+ years' experience with SQL performance tuning and database architecture.
• Experience in converting non CDB databases to CDB
• Experience in working with Informatica

V2Soft is an Equal Opportunity Employer ( EOE). We welcome applicants from all backgrounds, including individuals with disabilities and veterans.
https://www.v2soft.com/careers - to view all of our open opportunities and to learn more about our benefits.