Application Database Administrator-5053571 at Optimal Solutions and Technologies in Baton Rouge, Louisiana

Posted in Other 20 days ago.





Job Description:
































Position:





Application Database Administrator-5053571












Location:


Baton Rouge, LA




Job Id:



5116-RCAT-4


# of Openings:



1





Optimal Solutions & Technologies (OST, Inc.) is focused on excellence. We specialize in providing Management Consulting, Information Technology, and Research Development and Engineering services. OST is one of an elite set of companies worldwide to be externally appraised CMMI Level 5.

The fundamental distinction of the OST team is its business knowledge in both the public and private sectors. We serve the aerospace & transportation, association & nonprofit, defense, education, energy, financial, healthcare, and technology & telecommunications industries. OST is successful because we listen to our clients, we learn from our clients, and we know our clients.

Engagement Length in Months:

3 years 4months.

What are the daily work hours?

Monday through Friday, 8am -5pm

Where is the physical work office located?

504 Mayflower Street, Baton Rouge, LA 70802.

(Contractor personnel, with permission of the Project Manager, will work offsite: State Remote or Contractor Remote)

Description of specific Duties in a typical workday for this position:

The Resource for this position is expected to perform tasks such as:


  • Data Architecture

  • Data Modeling

  • Support for specific applications using databases

The ideal candidate will demonstration expert experience administering multiple relational databases such as Oracle, MS SQL, MySQL and PostgreSQL. Strong scripting skills (PowerShell, php, python, ruby, Perl, etc.). Knowledge of database connectivity issues. Strong analytical and troubleshooting skills.

The scope of the proposed services will include the following:


  • Data Extraction, Transformation, and Loading

  • Database Backup and Recovery

  • Performance Monitoring

  • Specialized Data Handling

  • Database Tuning

  • Capacity Planning

Expertise and/or relevant experience in the following areas are mandatory:


  • SQL Server, Administration and Performance Tuning

  • Index design

  • Use DMO's to collect query data, index data

  • Extended Events

  • SSIS or other relevant ETL software

Expertise and/or relevant experience in the following areas are desirable but not mandatory:


  • Familiarity with Web Based Applications, Entity Framework

  • Database DevOps Practices

  • SSRS

  • SSAS

  • PowerBI/Tableau or other BI Platforms

  • Data Warehousing design

  • SQL Server concurrency and isolation

  • Data movement features of SQL Server

OST is an equal opportunity employer. Applicants are considered for positions without regard to race, religion, gender, native origin, age, disability, or any other category protected by applicable federal, state, or local laws.




Apply for this Position