Job Description
Job Title: Database administrator
Location: Remote
We are currently seeking candidates who meet the following qualification
Key Responsibilities:
- Implement, administer, manage, and monitor Oracle databases in both production and non-production environments while ensuring data integrity and security.
- Develop and optimize Oracle SQL and PL/SQL code for enterprise applications.
- Automate database processes and align them with Enterprise CI/CD workflows using tools like Jenkins or similar automation platforms.
- Utilize hands-on experience with Oracle APEX development to build and enhance database-driven applications.
- Lead large, complex initiatives to design and implement performance tuning improvements. Collaborate with developers to optimize queries and advise on tuning strategies.
- Analyze and optimize SQL performance using tools such as Explain Plan and recommend improvements for better execution plans.
- Support cross-functional development teams by identifying data structures, relationships, and constraints to optimize application performance.
- Leverage in-depth knowledge of Oracle internal views, built-in functions, and architecture for data analysis and query optimization. Perform tasks such as tablespace consolidation, DBMS reorganization, partition analysis, and index analysis.
- Troubleshoot and resolve complex database issues in Oracle 11g/19c environments running on Solaris/Linux systems.
- Monitor and fine-tune SQL and PL/SQL queries for optimal performance using Oracle-native tools like Oracle SQL Developer.
- Use data modeling techniques and tools like Erwin to design star schema models and other database structures.
- Develop tools and scripts using SQL, PL/SQL, and Linux shell scripting to support database administration in test and development environments.
- Apply best practices for creating and managing DDL/DML SQL and shell scripts.
- Collaborate on large-scale development projects using Agile methodology and contribute to iterative software delivery.
Qualifications: - Experience in Oracle database administration and development.
- Advanced proficiency in Oracle SQL and PL/SQL.
- Hands-on experience with database automation and CI/CD tools such as Jenkins.
- Experience with Oracle APEX development.
- Expertise in performance tuning, query optimization, and using Explain Plan.
- Experience with Oracle internal views, partitioning, indexing, and DBMS reorganization techniques.
- Strong troubleshooting skills in Oracle environments (11g/19c) on Solaris/Linux platforms.
- Proficient in using Oracle SQL Developer and Erwin Modeling Tool for database design and optimization.
- Demonstrated experience with Agile methodology in large development projects.
- Strong communication and collaboration skills to work effectively with cross-functional teams.
Preferred Skills: - Experience with other automation tools and modern development practices.
- Knowledge of data warehousing concepts and advanced data modeling techniques.
- Exposure to cloud database solutions or migrations.
If you meet these qualifications, please submit your application via link provided in Linkedin.
Kindly do not call the general line to submit your application.
Job Tags
Remote job,