Oracle Database DBA/Developer

ITTrailBlazers1

Mt Laurel, NJ, United States permanent

Posted: August 27, 2015

Job Description

TCS America Inc.-Full Time

The database developer will assist in the support of Oracle 10g, 11g, and 12c Databases on Exadata, LINUX & Client-UX platforms. This role is responsible for providing database support, performance tuning, and technology upgrades on Oracle 10g, 11g, and 12c in both OLTP and OLAP environments. A core function of this role is to troubleshoot and research issues related to database performance, query performance, space management, and other technical issues. The database Developer will be responsible for implementing best practices in the design, deployment and management of scalable, reusable and extensible integration components.. Communication will be a key component as this job requires interaction with a variety of internal teams at various levels concerning technical and non-technical issues related to database infrastructure and performance.

Responsibilities

Works collaboratively within a solution team to design and implement database solutions that are of high quality and cost and allow Client, America's Most Convenient Bank to be the better bank in every market in which it competes

Monitor database space and capacity, estimate sizing and growth requirements

Performs ongoing database performance tuning, including review & tune complex SQL statements

Collaborate with application and infrastructure teams to solve database level issues including availability and stability of the database environments

Designs/support complex ETL processes and Oracle databases that are highly performant and meet enterprise standards for availability and fault tolerance in a secure environment

Assists team members in performance tuning and troubleshooting ETL processes and queries under development and in production as needed.

Packages Oracle database scripts and deployment instructions for the DBA Engineering group to deploy to upper environments.

Participates in the design and development of large-scale data marts or changes to enterprise data warehouses.

Develops interfaces to enterprise metadata environments and ensures ETL metadata flows into the metadata environment accurately as part of new ETL development.

Defines and ensures adherence to best practices for ETL and database development into standard warehouse models and dimensional data structures.

Provides assistance to team members and may assume a lead role within projects

4 Year Degree or equivalent experience

10+ years of experience in data-base oriented development in an enterprise environment.

Financial industry experience preferred

Experience with Oracle Database Administration (10g,11g, Exadata)

Experience managing databases larger than 10TB

Knowledge/Experience with database appliances (Exadata) data guard, compression and backup tools.

Ability to perform both Oracle and also operating system performance monitoring

Dimensional data mart experience required.

Strong skills in data structure analysis, and development of stored procedures, SQL, and scripting in support of data transformation and delivery

Strong skills in development and performance optimization of SQL queries

Strong skills in design and development of relational data structures

A good knowledge of the operating system(s) and proven scripting skills in both Windows and Unix environments

Proven hands-on experience utilizing SQL, Oracle PL/SQL and SQL Loader, Microsoft DTS and T-SQL, VBScript, and Perl, DOS or UNIX shell scripting for manipulating large volumes of data to and from enterprise systems, as well as experience manipulating flat-files, EBCDIC to ASCII conversion, and non-relational data

Please feel free to reach me at 732-227-1772 Ext 315

Why Apply Through MisuJob?

AI-Powered Job Matching: MisuJob uses advanced artificial intelligence to analyze your skills, experience, and career goals. Our matching algorithm compares your profile against thousands of job requirements to find positions where you have the highest chance of success. This saves you hours of manual job searching and ensures you only see relevant opportunities.

One-Click Applications: Once you create your profile, applying to jobs is effortless. Your resume and cover letter are automatically tailored to highlight the most relevant experience for each position. You can apply to multiple jobs in minutes, not hours.

Career Intelligence: Beyond job matching, MisuJob provides valuable career insights. See how your skills compare to market demands, identify skill gaps to address, and understand salary benchmarks for your experience level. Make data-driven decisions about your career path.

Frequently Asked Questions

How do I apply for this position?

Click the "Register to Apply" button above to create a free MisuJob account. Once registered, you can apply with one click and track your application status in your dashboard.

Is MisuJob free for job seekers?

Yes, MisuJob is completely free for job seekers. Create your profile, get matched with jobs, and apply without any cost. We help you find your dream job without any hidden fees.

How does AI matching work?

Our AI analyzes your resume, skills, and experience to understand your professional profile. It then compares this against job requirements using natural language processing to calculate a match percentage. Higher matches mean better fit for the role.

Can I apply to jobs in other countries?

Absolutely. MisuJob features jobs from companies worldwide, including remote positions. Filter by location or look for remote opportunities to find jobs that match your preferences.

Ready to Apply?

Join thousands of job seekers using MisuJob's AI to find and apply to their dream jobs automatically.