Sr. Oracle DBA/Developer
At a glance
Senior Data Architecture & Governance role at Collabera. Charlotte · contract.
Pay not stated Data Architecture & Governance salary
dataroles summary, based on the employer's posting.
What you'll do
- Tune Oracle applications and data models, then optimize performance across large databases
- Analyze query performance with Explain Plan, SQL Trace, ADDM/AWR, and third-party tools
- Create partitioned tables, views, indexes, and packages to support database needs
- Write complex PL/SQL and guide less experienced staff on coding practices
- Use UNIX shell scripts and scheduling tools such as Autosys
What you bring
- At least eight years working on Oracle application tuning, optimization, development, and data modeling
- At least four years of hands-on work in Oracle 12c or 11g environments
- Experience tuning databases larger than two terabytes and working with OLTP and OLAP
- Strong Oracle, PL/SQL, data warehousing, business intelligence, performance tuning, and UNIX skills
Who this fits
This senior contractor role suits someone with deep Oracle tuning and development experience who can also coach less experienced staff. The position is onsite in Charlotte.
From the employer
Collabera is ranked amongst the top 10 Information Technology (IT) staffing firms in the U.S., with more than $550 million in sales revenue and a global presence that represents approximately 12,000+ professionals across North America (U.S., Canada), Asia Pacific (India, Philippines, Singapore, Malaysia) and the United Kingdom. We support our clients with a strong recruitment model and a sincere commitment to their success, which is why more than 75% of our clients rank us amongst their top three staffing suppliers.
• Technical skills should include strong Oracle, Performance Tuning, Data Warehousing, PL/SQL, Business Intelligence, and UNIX.
• 8+ years Oracle application data tuning and optimization, development, and data modeling.
• Experienced in performance analysis and tuning, including the use of standard Oracle tools (Explain Plan, SQL Trace, ADDM/AWR) as well as third party solutions)
• Modeled, and created database objects, including partitioned tables, views, indexes, packages
• Developed original and/or complex PL/SQL code and provided coding guidance to less experienced staff
• 4+ years of hands on experience in Oracle 12c/11g environment
• Experience in large (2+ TB) database tuning and optimization
• Experience with UNIX shell scripting and Scheduling tools (e.g. Autosys)
- Any experience working with 12c
- Experience in databases larger than 2+ TB
- Experience with tuning and optimization
- Experience with OLTP/OLAP
To know more on this position or to schedule an interview, please contact;
Jiju Ninan at 704-893-3129
Data Architecture & Governance work from LinkedIn, X, Reddit and Upwork, in one list.
Each morning you get everything that fits, strongest first.
Data Architecture & Governance
Find me workBy the team behind dataroles.