Local profile required || Oracle & SQL Database Administrator || Princeton NJ (Hybrid)

Rate max $55/hr on c2c.

Only Local profile.

Dear Vendors,

I hope this email finds you well.

Position: Oracle & SQL Database Administrator

Location: Princeton NJ (Hybrid) 

Client: HCL

Duration: Long Term

Job description:

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.