Oracle Database DBA/Developer
Location: Mt Laurel, NJ, us
Company Description
TCS America Inc.-Full Time
Job Description
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
Qualifications
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
Additional Information
Please feel free to reach me at 732-227-1772 Ext 315
There are more than 50,000 engineering jobs:
Subscribe to membership and unlock all jobs
Engineering Jobs
60,000+ jobs from 4,500+ well-funded companies
Updated Daily
New jobs are added every day as companies post them
Refined Search
Use filters like skill, location, etc to narrow results
Become a member
🥳🥳🥳 452 happy customers and counting...
Overall, over 80% of customers chose to renew their subscriptions after the initial sign-up.
To try it out
For active job seekers
For those who are passive looking
Cancel anytime
Frequently Asked Questions
- We prioritize job seekers as our customers, unlike bigger job sites, by charging a small fee to provide them with curated access to the best companies and up-to-date jobs. This focus allows us to deliver a more personalized and effective job search experience.
- We've got over 200,000 jobs from 15,000+ vetted companies. No fake or sleazy jobs here!
- We aggregate jobs from 15,000+ companies' career pages, so you can be sure that you're getting the most up-to-date and relevant jobs.
- We're the only job board *for* software engineers, *by* software engineers… in case you needed a reminder! We add thousands of new jobs daily and offer powerful search filters just for you. 🛠️
- Every single hour! We add 2,000-3,000 new jobs daily, so you'll always have fresh opportunities. 🚀
- Typically, job searches take 3-6 months. EchoJobs helps you spend more time applying and less time hunting. 🎯
- Check daily! We're always updating with new jobs. Set up job alerts for even quicker access. 📅
What Fellow Engineers Say