Under Development Features: Talent Bank/Pool, VMS Intigration, Analytics, Social Integration, Reports, API Integration, Resource and Timesheets Management, Company Admin

Under Development Features: Talent Bank/Pool, VMS, Analytics, Social/API Integration, Company Admin

 Data Engineer/ Administrator (780 views)

NW Washington, DC
March 30, 2020

** Direct Client Requirement ****
Title: Data Engineer/ Administrator
Location: NW Washington, DC
Rate: DOE
Interview Type: In-Person only
Work Status: Successful applicants must be legally authorized to work in the U.S.
Job Type: C2C,C2H ,W2,
Experience: 7 YEARS
 

 
In-person:
Our client, an international financial institution based in NW Washington, DC has a position available for an Data Engineer

Position Overview:

This department develops and maintains the systems and computing facilities. These systems and facilities support the business process of investments, liabilities management, cash operations, risk management, new products, pension investment, pension administration, and accounting. These systems are critical to the proper management of the Bank’s financial resources.

The specific assignment is to augment the logical database administrator function and scale up capacity to support additional projects that is on our way. The incumbent will be responsible for the performance, integrity, availability, and security of a database. They will also be involved in the planning and development of the database, as well as troubleshooting any issues on behalf of the users. The logical database administrator will ensure that databases have the following qualities: data remains consistent across the database, data is clearly defined, users can access data concurrently in a form that suits their needs, and there is provision for data security and recovery control (all data is retrievable in an emergency). The period of the assignment is between 6 months to 12 months depending on performance of the candidate.

General Accountability:
The candidate would be a self-starter and capable of working independently to high standards of quality. The engagement requires Oracle Exadata, MS SQL SERVER, Oracle APEX, Oracle RAC & Data Guard experience DBA.

Scope of Work:

  • Provide Logical Database Support to development projects and perform maintenance for existing applications, as per the Oracle & MS SQL Database & Oracle APEX operation guidelines, which will describe naming standards, processes, and procedures to be followed.
  • Provide support on Development, Test & Production late hours and weekends.
  • Perform server configuration of Oracle & MS SQL database, as per best practices followed in the industry, and document the standards for future use.
  • Perform configuration and development life cycle for Oracle APEX with Apache, Tomcat web server experience and HTML/CSS knowledge.
  • Provide security management, which includes Account management and access control, as well as object permission Troubleshoot and monitor using tools in RDBMS level, as well as OS level and Control access permissions and privileges.
  • Provide time to time onsite data center support at with field engineers.
  • Communicate regularly with technical, applications, and operational staff to ensure database integrity and security.
  • Commission and install new applications, and customize existing applications to make them fit for purpose.
  • Oversee bulk data migration, as per requirements.
  • Map out the conceptual design for a planned database.
  • Refine the logical design so that it can be translated into a specific data model.
  • Promote database code from lower environment to production environment.
  • Maintain data standards, including adherence to the Data Protection Act.
  • Write database documentation, including data standards, procedures, and definitions for the data dictionary (metadata).
  • Perform backup/recovery and refresh of databases using the best practices followed in the industry and Database team.
  • Work closely with system administrators to define the platform requirement and to effect performance tuning and capacity planning.
  • Provide administrative support for high availability/disaster recovery aspects, understand Database failover/Switchover technologies for both Oracle & MS SQL Server.
  • Follow ITIL processes for incident management, change management and problem management.
  • Understanding and acting on ICFR, SOC1, SOX compliance.

Skill Set Requirements & Selection Criteria:

  • Bachelor’s degree, with a minimum of 5-7 years relevant experience in Information technology.
  • Relevant experience of minimum 3-5 years in financial sector is must.
  • 5 – 8+ years relevant experience as a logical dba in Oracle, MS SQL Server & Oracle APEX is must.
  • Experience with Web Applications and Web Server (Tomcat, Apache etc.) with HTML/CSS knowledge.
  • Experience Oracle Exadata, Virtualization & Database Cloud technologies is a must.
  • Experience Windows and Linux platform is must.
  • Experience in optimization of Oracle MS SQL server performance is must.
  • Experience on Backup/Recovery, Data Migration and Disaster Recovery is must.
  • Good Technical Documenting Skills is must.
  • Certification on Oracle & MS SQL Server is a big plus.
  • Relevant experience in remote management of Production database system.
  • Unix/Windows Shell Scripting experience is required.
  • Relevant experience in use of ITIL processes.
  • Relevant experience for SOX compliance of critical financial systems.
  • Ability and willingness to propose creative and optimal solutions.

    Experience Matrix for levels:

    • Level I – 3+ years of experience
    • Level II – 6+ years of experience
    • Level III – 8+ years of experience

      Thanks

      Rohit/Siva

      Rohit@Sohanit.com/siva@sohanit.com

      PH:402-241-9609/402-241-9606

      Apply here or Please send to resumes@sohanit.com

Position Keywords: Web Applications , Bank's , CSS , ICFR , Oracle Exadata , SOC1 , Unix , Database , Test , MS SQL SERVER , MS SQL , Windows , HTML , Tomcat , big , RDBMS , Oracle RAC , Development , Apache , development life cycle , SOX , MS SQL Server , Follow ITIL processes , Web Server , Oracle , Oracle APEX

Pay Rate: DOE

Job Duration: 12 Months

% Travel Required: None

Job Posted by: Consulting Services

Job ID: NTT 78

Work Authorization: Successful applicants must be legally authorized to work in the U.S

Don't have time now?
Get a reminder in your inbox