Oracle DBA in Chesterfield, MO at Signature Consultants

Date Posted: 12/20/2019

Job Snapshot

Job Description

Oracle DBA Summary:

Signature Consultants has an opportunity for an Oracle DBA. In this role the candidate will partner with business and IT teams to understand requirements; apply Data Warehouse and Master Data Management methodologies in software delivery; logical and Physical data modeling/implementation (normalized and dimensional) ensuring referential integrity; design, create, and tune SQL/application database objects (tables, views, indexes, etc.); develop database packages, procedures, functions and triggers; change Management for Data Definition Language (DDL) and Data Manipulation Language (DML); create deployment scripts that contain DDL necessary to migrate versions through environments; and assist developers with data access methods and optimal usage of database resources.

Responsibilities:

  • Perform database Application performance monitoring, tuning and optimization
  • Monitoring and runtime optimization of applications data jobs, replication and ETL activities
  • Planning for future capacity and performance needs (organic and strategic growth)
  • Establish and maintain database Application documentation and standards. Also review with stakeholders
  • Comply with all Security, Architecture and Infrastructure standards. Recommend improvements as needed
  • Run deployment scripts in development database environments (separation of duties)
  • Provide 24x7 support when required. Update support documentation to minimize "key person risk"
  • Perform general technical trouble shooting and give consultation to development teams
  • Interface with System DBA team and/or database vendor for tech support and Service Request management
  • Provide leadership, technical advice and support to continuously improve the database strategy
  • Partners with dev teams to formulate approach and appropriate uses of utilities and DMBS Tools
  • Maintain leading edge knowledge of industry and technology trends, to effectively assess and recommend

Qualifications:

  • Bachelor's degree in Computer Science or equivalent experience/education
  • 8+ years and extensive knowledge of Oracle 11G databases and PL SQL required
  • 8+years in Data Warehousing and Business Intelligence architecture / design in a high volume environment
  • Experience with both OLTP and dimensional databases and performance tuning of multi-terabyte implementations.
  • Demonstrated experience with Entity Relationship (ER), Dimensional, and object modeling techniques (e.g. Erwin)
  • Superior analytical and problem resolution skills. Excellent verbal and written communication skills.
  • Proactive personality with a proven track record of delivering on responsibilities and tasks.
  • Excellent ability to translate business needs and problems into systems' design and technical solutions.

About Signature Consultants, LLC

Headquartered in Fort Lauderdale, Florida, Signature Consultants was established in 1997 with a singular focus: to provide clients and consultants with superior staffing solutions. For the ninth consecutive year, Signature was voted as one of the "Best Staffing Firms to Work For" and is now the 15th largest IT staffing firm in the United States (source: Staffing Industry Analysts). With 28 locations throughout North America, Signature annually deploys thousands of consultants to support, run, and manage their clients' technology needs. Signature offers IT staffing, consulting, managed solutions, and direct placement services. For more information on the company, please visit www.sigconsult.com. Signature Consultants is the parent company to Hunter Hollis and Madison Gunn.