Need only locals here ,
Oracle & SQL Database Administrator
Onsite (Work Location: Princeton NJ- need only locals to NJ
$50-55/hr on c2c
Need 10 yrs profile
Mandate skills Required skills : -Databases-RDBMS-Oracle PL/SQL, Admin , SQL , APEX EBS.Oracle tools and technologies (e.g., Oracle RAC, Data Guard), SSMS and Azure may also be required, Performance tuning , Schema and Object Management: manage database objects: tables, views, indexes, stored procedures, triggers, Oracle database concepts and architecture 19c database
Key Responsibilities of an Oracle Database Professional:
• Database Design and Implementation 19c database
• Creating database structures, designing database objects (like tables, indexes, etc.), and ensuring the database architecture meets organizational needs.
• Performance Tuning
• Identifying and resolving performance bottlenecks, optimizing database queries, and ensuring efficient data access.
• Backup and Recovery , Rman export datapump import datapump
• Security Management Implementing and maintaining access controls, user authentication, and data encryption to protect sensitive data.
• Troubleshooting and Support- Identifying and resolving database-related issues, providing support to users, and ensuring smooth operation of the database environment.
• Database Administration Installing, configuring, upgrading, and patching Oracle database software.
• Monitoring and Maintenance.
Key Responsibilities of an SQL Database Professional:
• Database Support for Applications: Understand how applications use the database (schema, queries, procedures).Work with developers to optimize SQL queries and database access patterns.
• Ensure the database design supports business functionality and performance goals.
• Schema and Object Management: manage database objects: tables, views, indexes, stored procedures, triggers, etc.Apply changes to the schema during application upgrades or deployments.
• Performance Tuning :Monitor query performance using tools like SQL Profiler, Execution Plans, or DMVs.Recommend and implement indexing strategies.Assist in resolving performance issues affecting applications.
• Release and Deployment Support :Review and execute database scripts as part of application release cycles.
• Security and Access Control: Manage roles, users, and permissions aligned with application needs.Ensure application users follow the principle of least privilege.
• Backup, Recovery, and Data Integrity : To Perform backup and restore in the various databases.Support data recovery for application-level issues (e.g., restore a single table or record). Validate integrity of business-critical data.
• Monitoring and Incident Response :Monitor database health and respond to incidents affecting application performance. Help troubleshoot application errors related to the database.
• Provide support during outages or maintenance windows.
Skills Required:
• Strong knowledge of Oracle database concepts and architecture 19c database.
• Strong knowledge of SQL database concepts and architecture of database.
• Strong knowledge of APEX EBS.
• Proficiency in SQL Server.
• Experience with database performance tuning and optimization.
• Familiarity with database security best practices.
• Experience with backup and recovery procedures.
• Excellent problem-solving and troubleshooting skills.
• Strong communication and collaboration skills.
• Experience with specific Oracle tools and technologies (e.g., Oracle RAC, Data Guard), SSMS and Azure may also be required.
Regards
Pavan
VDart Inc
Ph: (470) 251-2584 Ext:1866
Email: Pavankumar.s@vdartinc.com
Website: https://vdart.com
Confidentiality Notice
The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer.
You received this message because you are subscribed to the Google Groups "Xrecnet IT Recruiters Network - Corp to Corp IT Jobs & Hotlists" group.
To unsubscribe from this group and stop receiving emails from it, send an email to xrecnet+unsubscribe@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/xrecnet/CAGf9M0-EBrKXHKEfOzm967sAHoe5TYGtpxU%3DMtmJa5dZgw5Lww%40mail.gmail.com.
No comments:
Post a Comment