North Carolina jobs

Sr. Oracle Developer

Artech Information System LLC (agency)Charlotte, NCContract8+ years experience

Pay not listed

2 things to check before you apply.

On Artech Information System LLC’s own careers site (SmartRecruiters), checked open today.

  • To check: Posted by the employer 10 years agoLong-open jobs are sometimes already filled. Ask when they plan to hire.
  • To check: No pay range listedAsk for the pay range before you interview.
  • Checked: On the company's own careers siteSmartRecruiters board
  • Checked: Checked open todaySmartRecruiters board
  • Checked: No reposts foundSmartRecruiters board
  • Trust score 60 / 100 · Check details
See all 6 checksShow fewer
How we check

What you’ll do

  • Analyze database performance, design and plan capacity, and oversee server-class database control.
  • Lead complex database initiatives involving architecture, design, integration, and data modeling.
  • Consult client groups on data and database strategies and technological advancements.
  • Tune large Oracle databases, manage database space, and develop complex PL/SQL code.

Summarised from the posting by AI and can be wrong. The full description is the source.

Requirements

Licenses and certifications

  • Technical certifications (preferred)

Experience

  • 5–8 years of custom application development, with a heavy emphasis on Oracle architecture, design, and development
  • 8+ years of Oracle application data tuning and optimization, development, and data modeling
  • 4+ years of hands-on experience in an Oracle 12c/11g environment
  • Experience tuning and optimizing large databases (2+ TB)
  • Experience in performance analysis and tuning using standard Oracle tools (Explain Plan, SQL Trace, ADDM/AWR) and third-party solutions
  • Experience modeling and creating database objects, including partitioned tables, views, indexes, and packages
  • Experience planning and coordinating database space management and working with storage concepts such as rebuilds, compression, logging, and cache
  • Experience developing original and/or complex PL/SQL code and providing coding guidance to less experienced staff
  • Experience as a lead support analyst, including triage, outage coordination, application support escalation, and troubleshooting
  • Experience with UNIX shell scripting and scheduling tools such as Autosys
  • Familiarity with SDLC methodologies and defect tracking tools
  • Track record of 2+ full project lifecycles, development, and post-implementation support activities
  • Demonstrated ability to follow best-practice SDLC methodology
  • Previous exposure to accounting or financial applications (preferred)
  • Banking or financial experience (preferred)
  • Experience with OLTP/OLAP applications (preferred)
  • Experience with ERWin modeling tool (preferred)
  • Knowledge of and experience with reporting packages such as Business Objects (preferred)

Education

  • Advanced degree (preferred)

Skills

  • Understanding of Kimball methodology, star schemas, slowly changing dimensions, database and data security, and large-scale financial services data (preferred)

Your match

Sign in and add your resume to see which of this job's requirements it shows.

Sign in to check your match

Saved to your account, encrypted. The AI that reads it doesn't keep it or train on it.

Full job description

From Artech Information System LLC’s careers site

Company Description

Artech is the 10th Largest IT Staffing Company in the US, according to Staffing Industry Analysts' 2012 annual report. Artech provides technical expertise to fill gaps in clients' immediate skill-sets availability, deliver emerging technology skill-sets, refresh existing skill base, allow for flexibility in project planning and execution phases, and provide budgeting/financial flexibility by offering contingent labor as a variable cost.

Job Description

Sr. Oracle Developer

6+ months Contract

Charlotte NC

Job Description:

Show full descriptionShow less
  • Provides the highest technical expertise for the performance analysis, design, capacity planning, and control of the organization's server-class databases.
  • Handles and leads the most complex or critical data / database management initiatives that typically involve multiple disciplines and multiple business groups, including responsibility for database architecture, design, integration, and/or data modeling.
  • As the recognized technical expert, consults extensively with multiple client groups to provide strategic solutions, influencing long-range internal and enterprise-level data/ database architecture and management strategies.
  • Serves as a consultant on technological advancements.

Additional:

This position is for a senior technical developer/database analyst, with a focus on performance tuning and capacity planning.

Candidate must have at least 5-8 years of experience working with custom application development with a heavy emphasis on Oracle architecture, design and development.

Candidate must possess excellent technical skills and demonstrated ability to follow best practice SDLC methodology.

Should also be knowledgeable and have experience working with large scale applications, preferably financial, in large scale organizations.

Candidate must have an analytical, logical thought process for developing project solutions and resolutions to issues.

Technical skills should include strong Oracle, Performance Tuning, Data Warehousing, PL/SQL, Business Intelligence, and UNIX. Excellent oral and written communication skills are mandatory.

Technical certifications and advanced degrees are preferred.

Basic qualifications:

  • 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
  • Planned and coordinated DB space management, worked with storage concepts (Rebuilds, Compression, Logging, Cache)
  • Developed original and/or complex PL/SQL code and provided coding guidance to less experienced staff
  • Played the role of lead support analyst, including triage duties and outage coordination. Acted as an escalation point for application support and troubleshooting.

Minimum Qualifications:

  • 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)
  • Familiarity with SDLC methodologies, defect tracking (including tools)
  • Track record of 2+ full project lifecycle and development, as well as post-implementation support activities
  • Excellent verbal and writing skills, including documentation skills
  • The ability to work in a multi-tasking team environment. This role supports multiple in-flight development projects at the same time.

Preferred skills:

  • Previous exposure to Accounting / Financial applications a plus
  • Experience with OLTP/OLAP type applications
  • Understanding of Kimball Methodology, Star Schemas, Slowly changing dimensions, Database and data security, large scale Financial Services Data
  • Experience with ERWin modeling tool
  • Knowledge of and experience with reporting packages (Business Objects etc.)

Qualifications

banking / financial experience is preferred

Additional Information

For more information, please contact

Jyoti Pandey

973-507-7568

Something wrong with this job? Report it · This flag looks wrong

Similar jobs

Sr. .NET Developer

Aretum · Remote · US only

$120k–$150k/yrFull-time

StrongChecked open todayPosted 1 month ago

Senior Oracle Developer

Southwest Gas · Las Vegas, NV

$95k–$143k/yr

StrongOpen 2 monthsChecked open todayPosted 2 months ago

Sr. Software Engineer

Photon · United States

$37k/yrFull-time

Looks goodOpen 9 monthsChecked open todayPosted 9 months ago

See more like this