Oracle & SQL Database Administrator
TechDigital Corporation
Princeton, NJ, United States
1 day ago
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Apply on www.careerbuilder.com
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Role details
Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Job source
Tech stack
Query Performance
Application Performance Management
Application Release Automation
User Authentication
Microsoft Azure
Databases
System Configuration
Data Integrity
Data Recovery
Data Security
Database Design
Database Security
+18 more
Database Storage Structures
Database Theory
Oracle Data Guard
Disaster Recovery
Oracle Databases
Oracle (Applications)
Oracle Rac
Performance Tuning
Query Optimization
Release Management
Sqlprofiler
Recovery Manager (RMAN)
SQL Stored Procedures
SQL Databases
Backup and Restore
Apex Code
Database Optimization
SQL Server Management Studio (SSMS)
Job description
- 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., * 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.
Requirements
SQL Databases, Oracle Database, Oracle DBA (Database Administrator), SQL Databases, Oracle Database, Oracle DBA (Database Administrator), Database Design, Performance Tuning/Optimization, Database Optimization, Query Optimization, * 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.
Apply for this position
This job is hosted externally. Click below to view the full posting and apply.
Apply on www.careerbuilder.com
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Loading talks and stories from around this roleβ¦