Highlights
Strong skills in SQL Performance tuning of inefficient queries Experience in Database Performance Tuning using AWR/ADDM reports Strong skills in maintaining multiple databases and support development, testing and performance teams Strong skills in writing Stored Procedures, Packages, Triggers, Views, etc. Experience in Oracle Database versions (11g,12c,19c) Strong skills in both logical and physical database design/modeling Strong skills in identifying and fixing database issues, related to deadlocks, application locks and waits, contentions, etc.
Numbers & Facts
| Location | Indianapolis, IN |
| Industry | Other/Not Classified |
| Salary | $50–$55 Per Hour |
| Company Size | 100 to 499 employees |
| Year Founded | 1998 |
| Website | www.eteaminc.com |
Description
Role:DBA
Duration:12 months
Location: Indianapolis, IN 46204
Required Skills:
Preferred Skills:
Duration:12 months
Location: Indianapolis, IN 46204
Required Skills:
- 5-7 Years of experience as a DBA Proven track record of executing at least one complex database migration, preferably involving Exadata platforms or On-Premises-to-Cloud movements.
- Experience in configuring advanced Data Guard. Configure and test automated database Switchovers and Failovers using Data Guard Broker to ensure minimal-downtime cutovers. Experience in Golden gate installation, Configuring Exacts, Replicates etc.
- Design and maintain enterprise backup architectures utilizing RMAN, optimizing parameters like channel parallelism, SECTION SIZE, and Block Change Tracking (BCT). Proven experience planning and executing quarterly full-stack Exadata patching, including the database layer, Grid Infrastructure (GI), storage cell software, InfiniBand/RoCE switches, and server firmware.
- Experience in Oracle Database versions (11g,12c,19c) Strong skills in both logical and physical database design/modeling Strong skills in identifying and fixing database issues, related to deadlocks, application locks and waits, contentions, etc.
- Strong skills in SQL Performance tuning of inefficient queries Experience in Database Performance Tuning using AWR/ADDM reports Strong skills in maintaining multiple databases and support development, testing and performance teams Strong skills in writing Stored Procedures, Packages, Triggers, Views, etc. PL/SQL skills Experience in writing shell/batch scripts for processes like backups, schema refreshes, Wait and lock alerts, Maintenance jobs, etc.
- Experience with OEM monitoring and alerting Experience in Oracle Data-Pump utility Capacity planning, User management Bachelor's degree or equivalent experience
Preferred Skills:
- Oracle certifications are a plus Data Masking, Exadata, Golden Gate experience. Ability to adapt quickly to an existing, complex environment.
- Ability to quickly learn new concepts is necessary.
- Candidate should be self-motivated, independent, detail oriented, responsible team-player and exhibit exceptional relationship management skills.
- Strong communication skills, both written and oral Passionate about building high-quality systems with software implementation best practices while leading and mentoring a team of developers.
- Ability to understand methodologies and tools used for delivery and display a passion to follow and devise processes for improving quality Ability to multi-task & support multiple priorities / multiple deliverables Ability to understand requirements and turn them to useful client deliverables using a team Strong Analytical and Problem-Solving Skills Experience with JEE/WEB applications are a plus Responsibilities: Manage day-to-day database operations Maintain schema objects, database and security standards Maintenance and Monitoring of all Databases Supporting different application teams, releases and projects Identifying and Tuning performance bottlenecks User administration and maintenance, Schema refreshes, etc.
About Company
Looking for a great job? Join eTeam. We’re looking for talented staffing professionals to join our staff. We also provide contract assignments and full-time jobs at Fortune 2000 Companies. We’ve been named one of the best companies to work for by Staffing Industry Analysts and New Jersey Business.