Oracle DBA
Tidal Federal Solutions, Inc. - McLean, VA

This job posting is no longer available on Tidal Federal Solutions, Inc.. Find similar jobs: Oracle Database Administrator jobs - Tidal Federal Solutions jobs

Oracle database administrator needed to provide database administration and system support for complete SDLC for the an IRS existing database environment (UNIX or Linux).

The qualified candidate will be responsible for:
    •Supporting multiple development, integration, user acceptance, performance and production Oracle database environments (development, Integration Test, User Acceptance and Production support) in UNIX

    •Designing database schemas, normalizing database structures, denormalizing database structures for reporting, and maintaining ERDs and data dictionaries

    •Conducting database monitoring activities

    •Participating in data conversion of legacy systems

    •Writing complex queries and scripts using Oracle PL/SQL

    •Writing stored procedures, triggers, and advanced PL/SQL

    •Testing PL/SQL code and data structures and data changes

    •Troubleshooting Development, Testing, Production database-related issues, including performance tuning

Job Requirements

Basic Qualifications:
    • IRS Moderate or High Risk Background Investigation

    •Hands on experience supporting applications in the IRS environment

    •Hands-on experience developing data warehouse solutions and as a DBA

    1-3 years of Unix/Solaris experience with database management systems

    Working experience of Oracle DB

    Knowledge of principles and practices of database management and data modeling

    •Working knowledge and experience with database stored procedures

    •Experience with writing packages, stored procedures, triggers, and complex analytical queries, and experience in tuning complex queries are necessary

    •Performance tuning of column-based database architecture to support fast data retrieval

    •Experience and knowledge of design tactics necessary to work with terabytes of data

    •Experience in ETL and ETL techniques.

Additional Qualifications:
    •Ability to work independently and deliver results with minimal oversight

    •Knowledge of technical and data architecture concepts and their implementation

    •Strong interpersonal and communication skills, positive personality to effectively conduct team work

    •Ability to communicate effectively to all levels of management and project teams (verbally and in writing)

    •Ability to lead/participate in peer reviews of database work products and code.