
Oracle DBA
- Irving, TX
- Permanent
- Full-time
- Install and configure new SQL databases on various platforms (physical, virtual, cloud).
- Set up database clusters, replication, and high availability solutions.
- Configure database parameters and optimize for performance.
- Perform regular database maintenance tasks such as vacuuming, analysing, and reindexing.
- Monitor database health and performance using various tools.
- Implement and maintain database security measures, including access control and encryption.
- Optimize SQL queries and database schema for improved efficiency.
- Regularly perform database backups and test recovery procedures.
- Manage disaster recovery plans and ensure business continuity.
- Troubleshoot database issues and provide timely solutions.
- Assist developers with database design and query optimization.
- Implement and maintain database security policies and procedures.
- Ensure compliance with relevant data privacy regulations (e.g., GDPR, HIPAA).
- Regularly audit database security and access controls.
- Oracle / Mongo / Cassandra Golden gate experience
- Minimum of 5+ years of Oracle, SQL database management systems in testing, implementation, maintenance and administration in a multiple platform environment.
- BS or MS in CS/EE/ECE/ or related 5+ years of experience in IT industry.
- Upgrades of Oracle, SQL , PostgreSQL database migrations and updates and application of database patches.
- Backup and restores, export and import of data to and from Oracle, SQL run time configuration of Oracle, SQL.
- Develop and implement backup and recovery strategies to protect against data loss.
- Monitoring at server, database, collection level, and using various monitoring tools related to Oracle, PostgreSQL.
- Strong understanding of SQL architecture and internals.
- Proficiency in SQL and database/data design and architectural principles and methodologies.
- Familiarity with Linux/Unix operating systems.
- Scripting skills (e.g., Bash, Python) for automation.
- Supports multiple services and multiple databases of medium complexity with multiple concurrent users, ensuring control, integrity and accessibility of data.
- Implements multiple projects along with the production support.
- Will perform on-call support for critical needs.
- Experience with database monitoring tools.
- Implement performance tuning strategies to ensure optimal database response times.
- Responsible for providing support to customers by researching, diagnosing, troubleshooting issues, and resolving incidents and providing support for software bugs and other technical problems.